GameDB Clear Query

[newmania]

I found GameDB Clear Query ^_^

1. modify INIT_GAMEDB stored procedure
2. run query -> exec INIT_GAMEDB

USE [GameDb]
GO
/****** 개체: StoredProcedure [dbo].[INIT_GAMEDB] 스크립트 날짜: 07/09/2008 01:07:03 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO

/****** Object: Stored Procedure dbo.INIT_GAMEDB Script Date: 2008-4-14 5:52:46 ******/



ALTER PROCEDURE [dbo].[INIT_GAMEDB]
AS
BEGIN
TRUNCATE TABLE GUILD
TRUNCATE TABLE GUILDGROUP
TRUNCATE TABLE GUILDMEMBER
TRUNCATE TABLE CHATBUDDY
TRUNCATE TABLE CHATBUDDYGROUP
/* TRUNCATE TABLE CHATPRESENCE */
TRUNCATE TABLE CHATBLACKLIST
TRUNCATE TABLE CABAL_CHARACTER_TABLE
TRUNCATE TABLE CABAL_EQUIPMENT_TABLE
TRUNCATE TABLE CABAL_INVENTORY_TABLE
TRUNCATE TABLE CABAL_QDDATA_TABLE
TRUNCATE TABLE CABAL_QUESTDATA_TABLE
TRUNCATE TABLE CABAL_QUICKSLOT_TABLE
TRUNCATE TABLE CABAL_SKILLLIST_TABLE
TRUNCATE TABLE CABAL_WAREHOUSE_TABLE
/*
TRUNCATE TABLE CABAL_ITEMSERIAL_TABLE

DECLARE @GROUP INT
SET @GROUP = 0
WHILE ( @GROUP <= 32 )
BEGIN
EXEC .MAKE_ITEMSERIAL_BASE @GROUP
SET @GROUP = @GROUP + 1
END
*/
END

 

[kapa22]

Somethink like reset accounts good ;-) will help a lot when i can connect to game ^_^

 

[jobier]

does not work here at least not cleared