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.

Thanks Emisand!.

PD: Don't close HeroGamers please it's a great server!!

I've added the .SQL scripts so you can load the database in SQL Server 2005 or 2008

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

I really love u bro !

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]

---

I was wrong. delete my post.

Nope that wont work. timestamp is an forgeinkey
Posted via Mobile Device

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.

So no one has a fix for this? -__-

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

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

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?

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.

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.