- Joined
- Jan 26, 2004
- Messages
- 54
- Reaction score
- 10
I found GameDB Clear Query ^_^
1. modify INIT_GAMEDB stored procedure
2. run query -> exec INIT_GAMEDB
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