use kn_online
TRUNCATE TABLE _ITEMLOGS
GO
TRUNCATE TABLE _MYKOL
GO
TRUNCATE TABLE _PAYMENTNOTICE
GO
TRUNCATE TABLE _PREMIUMLOGS
GO
TRUNCATE TABLE _TEL
GO
TRUNCATE TABLE _UCRETSIZLOG
GO
TRUNCATE TABLE ACCOUNT_CHAR
GO
TRUNCATE TABLE ACCOUNT_NATION_CHECK
GO
TRUNCATE TABLE ACCOUNT_NATION_TRANSFERS_QUEUE
GO
TRUNCATE TABLE ALINAN_ITEM_KAYITLARI
GO
TRUNCATE TABLE BAKIM
GO
TRUNCATE TABLE BLOCKED_USERDATA
GO
TRUNCATE TABLE BLOCKED_WAREHOUSE
GO
TRUNCATE TABLE CLANREF
GO
TRUNCATE TABLE CLASS_CHANGE
GO
TRUNCATE TABLE COPY_SERIAL_ITEM
GO
TRUNCATE TABLE DeathLOG
GO
TRUNCATE TABLE DELLOS_TAX
GO
TRUNCATE TABLE DM_PLAYER
GO
TRUNCATE TABLE EbenezerCommand
GO
TRUNCATE TABLE ELMO_RANK
GO
TRUNCATE TABLE FRIEND_LIST
GO
TRUNCATE TABLE Gokhan
GO
TRUNCATE TABLE GUNLUK_NP_TAKIP
GO
TRUNCATE TABLE HardwareBanList
GO
TRUNCATE TABLE HardwareBanList2
GO
TRUNCATE TABLE HardwareBlockIPBanList
GO
TRUNCATE TABLE HardwareFollowHWID
GO
TRUNCATE TABLE HardwareFollowIP
GO
TRUNCATE TABLE HardwareIPBanList
GO
TRUNCATE TABLE HardwareLog
GO
TRUNCATE TABLE HERALIST
GO
TRUNCATE TABLE HERO_USER
GO
TRUNCATE TABLE IPBAN
GO
TRUNCATE TABLE item_zone
GO
TRUNCATE TABLE itemler
GO
TRUNCATE TABLE KARUS_RANK
GO
TRUNCATE TABLE KING_BALLOT_BOX
GO
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD
GO
TRUNCATE TABLE KING_ELECTION_LIST
GO
TRUNCATE TABLE KING_SYSTEM
GO
TRUNCATE TABLE KNIGHTS
GO
TRUNCATE TABLE KNIGHTS_ALLIANCE
GO
TRUNCATE TABLE KNIGHTS_RATING
GO
TRUNCATE TABLE KNIGHTS_USER
GO
TRUNCATE TABLE ListUserItems
GO
TRUNCATE TABLE MYKOL
GO
TRUNCATE TABLE MYST_CHECK
GO
TRUNCATE TABLE NATION_CHANGE_LOG
GO
TRUNCATE TABLE NATIONAL_POINT_DONATE_LIST
GO
TRUNCATE TABLE NATIONAL_POINT_TRANSFER_LIST
GO
TRUNCATE TABLE PPCARD_ITEM_PROBABILITY
GO
TRUNCATE TABLE PREMIUM_SERVICE
GO
TRUNCATE TABLE Quests
GO
TRUNCATE TABLE RENTAL_ITEM
GO
TRUNCATE TABLE RENTAL_ITEM_LIST
GO
TRUNCATE TABLE TB_USER
GO
TRUNCATE TABLE TERM_ITEM
GO
TRUNCATE TABLE UNIQTURK_1VS1_C
GO
TRUNCATE TABLE UNIQTURK_RIVAL_A
GO
TRUNCATE TABLE USER_CLAN_RANK
GO
TRUNCATE TABLE USER_KNIGHTS_MANNER_RANK
GO
TRUNCATE TABLE User_LockedItems
GO
TRUNCATE TABLE USER_LOGIN_LOG
GO
TRUNCATE TABLE USER_LOYALTY_INCREASES
GO
TRUNCATE TABLE USER_LOYALTY_INCREASES_TEMP
GO
TRUNCATE TABLE USER_MANNERPOINT_RANK
GO
TRUNCATE TABLE User_QuestLog
GO
TRUNCATE TABLE USER_RACECHANGELOG
GO
TRUNCATE TABLE USER_RENTAL_ITEM
GO
TRUNCATE TABLE USER_SAVED_MAGIC
GO
TRUNCATE TABLE USERDATA
GO
TRUNCATE TABLE USERDATA_SKILLSHORTCUT
GO
TRUNCATE TABLE WAREHOUSE
GO
TRUNCATE TABLE WAREHOUSE_ITEMLER
GO
TRUNCATE TABLE WEB_ITEMMALL
GO
TRUNCATE TABLE WEB_ITEMMALL_LOG
GO
TRUNCATE TABLE XSKIP_BM_USERS
GO
TRUNCATE TABLE ZONE_NP_RANK
UPDATE USER_KNIGHTS_RANK SET strElmoUserId = '<NULL>'
UPDATE USER_KNIGHTS_RANK SET strElmoKnightsName = '<NULL>'
UPDATE USER_KNIGHTS_RANK SET nElmoLoyalty = '0'
UPDATE USER_KNIGHTS_RANK SET strKarusUserId = '<NULL>'
UPDATE USER_KNIGHTS_RANK SET strKarusKnightsName = '<NULL>'
UPDATE USER_KNIGHTS_RANK SET nKarusLoyalty = '0'
UPDATE USER_PERSONAL_RANK SET strElmoUserId = '<NULL>'
UPDATE USER_PERSONAL_RANK SET nElmoLoyaltyMonthly = '0'
UPDATE USER_PERSONAL_RANK SET nElmoCheck = '0'
UPDATE USER_PERSONAL_RANK SET strKarusUserId = '<NULL>'
UPDATE USER_PERSONAL_RANK SET nKarusLoyaltyMonthly = '0'
UPDATE USER_PERSONAL_RANK SET nKarusCheck = '0'
-- KING_SYSTEM'i Güncelliyoruz...
DECLARE @Day tinyint
DECLARE @Month tinyint
DECLARE @Year smallint
SET @Day = DAY(GETDATE())
SET @Month = MONTH(GETDATE())
SET @Year = YEAR(GETDATE())
INSERT INTO KING_SYSTEM VALUES(1,3,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,21000000,21000000,NULL,NULL)
INSERT INTO KING_SYSTEM VALUES(2,3,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,21000000,21000000,NULL,NULL)