Gunz 1.5 (2011 files) Complete Databases

[Coldfx]

Rename spBringAccountItem to spBringAccountItemOld
and Rename spBringAccountItem2 to spBringAccountItem

that should do the trick

[Phoenix]

Rename spBringAccountItem to spBringAccountItemOld
and Rename spBringAccountItem2 to spBringAccountItem

that should do the trick

It's fixed. Thanks a lot; I appreciate it.

[cerealnp]

Here's a fix for the Gamble Items:

USE [GunzDB]
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
--ALTER PROC [dbo].[spChangeGambleItemToRewardNormalItem]  
CREATE PROC dbo.spChangeGambleItemToRewardNormalItem  
	  @CID				INT
	, @CIID				INT
	, @GIID				INT
	, @GRIID			INT
	, @RewardItemID		INT
	, @RewardRentPeriod	INT


AS BEGIN

	SET NOCOUNT ON;

	DECLARE @RentHourPeriod		INT;
	DECLARE @GambleItemCount	INT;
	
	-----------------------------------------------------------------------------
			
	SELECT	@RentHourPeriod = ISNULL(RentHourPeriod, 0)
	FROM	GambleRewardItem gri(NOLOCK)  
	WHERE	GRIID = @GRIID
	AND		GIID = @GIID 
	AND		(ItemIDMale = @RewardItemID OR ItemIDFemale = @RewardItemID)
	
	IF (0 = @@ROWCOUNT) BEGIN
		SELECT -1 AS 'Ret'  
		RETURN
	END
			
	SELECT	@GambleItemCount = ISNULL(Cnt, 1)
	FROM	CharacterItem(NOLOCK)
	WHERE	CIID = @CIID;
		
	-----------------------------------------------------------------------------
	
	DECLARE @NowDate	DATETIME;
	SET @NowDate = GETDATE();	
	
	-----------------------------------------------------------------------------
			
	BEGIN TRAN -----------  
	
		----------------------------------------------------------------------------------------
		
		IF( @GambleItemCount > 1 ) BEGIN
		
			UPDATE	CharacterItem 
			SET		Cnt = Cnt - 1
			WHERE	CID = @CID 
			AND		CIID = @CIID 
			
			IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN  
				ROLLBACK TRAN  
				SELECT -2 AS 'Ret'  
				RETURN
			END
			
		END
		ELSE BEGIN
		
			UPDATE	CharacterItem 
			SET		CID = NULL
			WHERE	CID = @CID 
			AND		CIID = @CIID
			
			IF (0 <> @@ERROR) OR (0 = @@ROWCOUNT) BEGIN  
				ROLLBACK TRAN  
				SELECT -3 AS 'Ret'  
				RETURN
			END
			
		END
		
		---------------------------------------------------------------------------------------	
		
		INSERT CharacterItem(CID, ItemID, RegDate, RentDate, RentHourPeriod, Cnt)
		VALUES (@CID, @RewardItemID, @NowDate, @NowDate, @RentHourPeriod, 1)
		
		DECLARE @OrderCIID INT;			
		SET @OrderCIID = @@IDENTITY;
			
		IF (0 <> @@ERROR) BEGIN  
			ROLLBACK TRAN  
			SELECT -4 AS 'Ret'  
			RETURN
		END
			
			
		INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count])
		VALUES (202, @NowDate, @CID, @CIID, @GIID, 1);	
		
		IF (0 <> @@ERROR) BEGIN  
			ROLLBACK TRAN  
			SELECT -5 AS 'Ret'  
			RETURN
		END

		INSERT dbo.ItemChangeLog_CharacterItem(ChangeType, ChangeDate, CID, CIID, ItemID, [Count])
		VALUES (102, @NowDate, @CID, @OrderCIID, @RewardItemID, 1);
		
		IF (0 <> @@ERROR) BEGIN  
			ROLLBACK TRAN  
			SELECT -6 AS 'Ret'  
			RETURN
		END

		INSERT INTO LogDB..GambleLog(CID, GIID, RewardItemID, RegDate)  
		VALUES (@CID, @GIID, @RewardItemID, @NowDate);
		
		IF (0 <> @@ERROR) BEGIN  
			ROLLBACK TRAN  
			SELECT -7 AS 'Ret'  
			RETURN
		END
		
		----------------------------------------------------------------------------------------

	COMMIT TRAN  -----------
		
	SELECT 0 AS 'Ret', @OrderCIID AS 'ORDERCIID'
END

[[S]pirit]

oh god, three days of organizing and patching sql files down the drain

[Rain]

My god this is a Fucking epic releas! keep up the good work guys ! and thanks for this emi <3

[Phoenix]

Links updated.
I've uploaded the files to Sendspace since Multiupload is down for some reason.


Download Link for .bak files:
http://www.sendspace.com/file/q64998

Download Link for .sql files:
http://www.sendspace.com/file/6t16tm

[Elian]

Phoenix these links get me redirected to multiupload so it isnt working.

[adz28]

Phoenix these links get me redirected to multiupload so it isnt working.

Copy the text, paste it in your url bar and it will work.
In case someone other need them:
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

[Phoenix]

Phoenix these links get me redirected to multiupload so it isnt working.

Fixed. Main post updated.

Copy the text, paste it in your url bar and it will work.
In case someone other need them:
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

Thanks!

[ielitepro]

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Cannot execute script.

------------------------------
ADDITIONAL INFORMATION:

Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

I get that error :(

[iDelta]

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Cannot execute script.

------------------------------
ADDITIONAL INFORMATION:

Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

I get that error :(

Restart SQL Management Delete your GunzDB, Make now GunzDB.
and Execute again make sure it is still 3MB

[Seoa]

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Cannot execute script.

------------------------------
ADDITIONAL INFORMATION:

Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

I get that error :(

Not enough computer resources to execute the query. I got by this by sheer luck.

[gabire]

can someone post a fixed version of this 1.5 database (script) ?

thanks

[Dante77]

TITLE: Microsoft SQL Server Management Studio Express
------------------------------

Cannot execute script.

------------------------------
ADDITIONAL INFORMATION:

Exception of type 'System.OutOfMemoryException' was thrown. (mscorlib)

------------------------------
BUTTONS:

OK
------------------------------

I get that error :(

I'm getting the same error every time I try to execute it.

[Gun[Lengend]]

System.OutOfMemoryException

The Script is too big for you computer