Clean Database Juver

[llenn]

Copy And Paste on Database
RanGame1
RanLog
RanShop
RanUser

TRUNCATE TABLE [RanGame1].[dbo].[Attendance]
TRUNCATE TABLE [RanGame1].[dbo].[AttendanceInfo]
TRUNCATE TABLE [RanGame1].[dbo].[AttendanceLastMaintenance]
TRUNCATE TABLE [RanGame1].[dbo].[AttendanceTaskInfo]
TRUNCATE TABLE [RanGame1].[dbo].[ChaEquipmentPass]
TRUNCATE TABLE [RanGame1].[dbo].ChaFriend
TRUNCATE TABLE [RanGame1].[dbo].ChaFriendBackup
TRUNCATE TABLE [RanGame1].[dbo].ChaInfo
TRUNCATE TABLE [RanGame1].[dbo].ChaInventoryPass
TRUNCATE TABLE [RanGame1].[dbo].ChaNameInfo
TRUNCATE TABLE [RanGame1].[dbo].ChaStoragePass
TRUNCATE TABLE [RanGame1].[dbo].GuildAlliance
TRUNCATE TABLE [RanGame1].[dbo].GuildBattle
TRUNCATE TABLE [RanGame1].[dbo].GuildInfo
TRUNCATE TABLE [RanGame1].[dbo].GuildRegion
TRUNCATE TABLE [RanGame1].[dbo].LogPartyMatch
TRUNCATE TABLE [RanGame1].[dbo].PetInfo
TRUNCATE TABLE [RanGame1].[dbo].PetInven
TRUNCATE TABLE [RanGame1].[dbo].PostInfo
TRUNCATE TABLE [RanGame1].[dbo].PostToFoward
TRUNCATE TABLE [RanGame1].[dbo].PetTypeFlag
TRUNCATE TABLE [RanGame1].[dbo].UserInven
TRUNCATE TABLE [RanGame1].[dbo].VehicleInfo


TRUNCATE TABLE [RanLog].[dbo].HackProgramList
TRUNCATE TABLE [RanLog].[dbo].LogAction
TRUNCATE TABLE [RanLog].[dbo].LogExchangeFlag
TRUNCATE TABLE [RanLog].[dbo].LogHackProgram
TRUNCATE TABLE [RanLog].[dbo].LogItemExchange
TRUNCATE TABLE [RanLog].[dbo].LogItemMax
TRUNCATE TABLE [RanLog].[dbo].LogItemRandom
TRUNCATE TABLE [RanLog].[dbo].LogMakeType
TRUNCATE TABLE [RanLog].[dbo].LogPetAction
TRUNCATE TABLE [RanLog].[dbo].LogPetActionFlag
TRUNCATE TABLE [RanLog].[dbo].LogServerState
TRUNCATE TABLE [RanLog].[dbo].LogVehicleAction
TRUNCATE TABLE [RanLog].[dbo].LogVehicleActionFlag


TRUNCATE TABLE [RanShop].[dbo].ItemMallLogBuy
TRUNCATE TABLE [RanShop].[dbo].LogShopPurchase
TRUNCATE TABLE [RanShop].[dbo].ShopPurchase



UPDATE [RanShop].[dbo].[ShopItemMap]
   SET [ItemStock] = 9999

UPDATE [RanGame1].[dbo].[GuildRegion]
   SET [GuNum] = 0

TRUNCATE TABLE [RanUser].[dbo].LogLogin

UPDATE [RanUser].[dbo].[UserInfo]
   SET [ChaName] = NULL, [ChaRemain] = 2, [GameTime] = 0, [UserPoint] = 0, [UserPoint2] = 0, [Playtime] = 0


ALL RAN USER

TRUNCATE TABLE [RanUser].[dbo].BlockAddress
TRUNCATE TABLE [RanUser].[dbo].CheckId
TRUNCATE TABLE [RanUser].[dbo].FullUserInfo
TRUNCATE TABLE [RanUser].[dbo].gmc
TRUNCATE TABLE [RanUser].[dbo].IPInfo
TRUNCATE TABLE [RanUser].[dbo].LogGameTime
TRUNCATE TABLE [RanUser].[dbo].LogGmCmd
TRUNCATE TABLE [RanUser].[dbo].LogLogin
TRUNCATE TABLE [RanUser].[dbo].LogServerState
TRUNCATE TABLE [RanUser].[dbo].LogTopUp
TRUNCATE TABLE [RanUser].[dbo].newcheckid
TRUNCATE TABLE [RanUser].[dbo].ServerGroup
TRUNCATE TABLE [RanUser].[dbo].ServerInfo
TRUNCATE TABLE [RanUser].[dbo].StatGameTime
TRUNCATE TABLE [RanUser].[dbo].StatLogin
TRUNCATE TABLE [RanUser].[dbo].TopUp
TRUNCATE TABLE [RanUser].[dbo].UserInfo
TRUNCATE TABLE [RanUser].[dbo].Vote

 

[MentaL]

Truncate deletes all table content, for those unaware.

 

[Ecjay1]

do you have a "Send to all bank" query for GS ?

 

[hephaestusnetwork]

Here's my optimal method for cleaning my SQL tables:

USE RanGame1
Go
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'
--
USE RanLog
Go
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'
--
USE RanShop
Go
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'
--
USE RanUser
Go
EXEC sp_MSforeachtable 'TRUNCATE TABLE ?'