Gunz 1.5 (2011 files) Complete Databases
Hello,
I am releasing the Complete Gunz 1.5 Databases.
All of them are in .bak format and also in .sql script format.
NOTE: The .bak files are generated with SQL Server 2008 R2. You will be unable to load them in previous versions of SQL Server.
You can use the .sql scripts in SQL Server 2005.
Databases included:
GunzDB
LogDB
AdmWebDB
The databases have preloaded data so you will not have Foreing Key errors.
You may add the latest items to the database in order to add them to characters or accounts of course.
You MUST keep the foreign keys in order to keep the database consistency.
Download GunZ 1.5 Databases (Scripts).rar from Sendspace.com - send big files the easy way
Download GunZ 1.5 Databases (.bak files).rar from Sendspace.com - send big files the easy way
Enjoy.
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Thanks Emisand!.
PD: Don't close HeroGamers please it's a great server!!
Re: Gunz 1.5 (Summer of 2011) Complete Databases
I've added the .SQL scripts so you can load the database in SQL Server 2005 or 2008
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Quote:
Originally Posted by
emisand
Hello,
I am releasing the Complete Gunz 1.5 Databases.
All of them are in .bak format and also in .sql script format.
NOTE: The .bak files are generated with SQL Server 2008 R2. You will be unable to load them in previous versions of SQL Server.
You can use the .sql scripts in SQL Server 2005.
Databases included:
GunzDB
LogDB
AdmWebDB
The databases have preloaded data so you will not have Foreing Key errors.
You may add the latest items to the database in order to add them to characters or accounts of course.
You MUST keep the foreign keys in order to keep the database consistency.
Download Link for .bak files:
Multiupload.com - upload your files to multiple file hosting sites!
Download Link for .sql files:
Multiupload.com - upload your files to multiple file hosting sites!
Enjoy.
excellent release (Y) there are your thanks
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Re: Gunz 1.5 (Summer of 2011) Complete Databases
A Few missing stuff in the database though not hard to fix there maybe more but I havent gotten past character cuz of spDTInstertDTCharacterInfo and im being a little lazy cuz that dumb database folder is in korean how fun ^^
Code:
[11/27/11 12:26:33] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spUpdateAccountLastLogoutTime (4294967295)} ), ErrCode( -1 )
ErrMsg - Error converting data type numeric to int.
State:37000,Native:8114,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
[11/27/11 12:28:31] MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spDTInsertDTCharacterInfo(2)} ), ErrCode( -1 )
ErrMsg - Cannot insert the value NULL into column 'TimeStamp', table 'GunzDB.dbo.DTCharacterInfo'; column does not allow nulls. INSERT fails.
The statement has been terminated.
State:23000,Native:515,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
State:01000,Native:3621,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
Re: Gunz 1.5 (Summer of 2011) Complete Databases
I was wrong. delete my post.
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Nope that wont work. timestamp is an forgeinkey
Posted via Mobile Device
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Quote:
Originally Posted by
Rotana
Nope that wont work. timestamp is an forgeinkey
Posted via Mobile Device
not o-o, let me execute the script and check.
Edit: It fucked up, don't know why.
Re: Gunz 1.5 (Summer of 2011) Complete Databases
So no one has a fix for this? -__-
Re: Gunz 1.5 (Summer of 2011) Complete Databases
From mine mind without checking.
insert an time stamp into DtTimeStamp
like for the 24th of nov.
2411
With 1 as id
this should do the trick
Posted via Mobile Device
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Quote:
Originally Posted by
Coldfx
From mine mind without checking.
insert an time stamp into DtTimeStamp
like for the 24th of nov.
2411
With 1 as id
this should do the trick
Posted via Mobile Device
that actually fixed thanks
Re: Gunz 1.5 (Summer of 2011) Complete Databases
I can't withdraw items from the storage for some reason.
This is what the server log shows:
Code:
MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spBringAccountItem (1, 1, 2)} ), ErrCode( -1 )
ErrMsg - Procedure or function 'spBringAccountItem' expects parameter '@CIID', which was not supplied.
State:37000,Native:201,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
Any solutions?
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Quote:
Originally Posted by
Phoenix
I can't withdraw items from the storage for some reason.
This is what the server log shows:
Code:
MMatchDBMgr::ExceptionHandler
ErrSQL( {CALL spBringAccountItem (1, 1, 2)} ), ErrCode( -1 )
ErrMsg - Procedure or function 'spBringAccountItem' expects parameter '@CIID', which was not supplied.
State:37000,Native:201,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]
Any solutions?
It's something with the insert query in the stored procedure "spBringAccountItem". I know I fucked up last time I tried to help, but meh, I just want to help.
Re: Gunz 1.5 (Summer of 2011) Complete Databases
Quote:
Originally Posted by
Vusion
It's something with the insert query in the stored procedure "spBringAccountItem". I know I fucked up last time I tried to help, but meh, I just want to help.
I know, that's what the log says, but I need a way to fix it.
This happens only when I use emisand's database. The one I made earlier never gave me any problems with withdrawing items or moving them to the storage.