TRUNCATE TABLE ACCOUNT_CHAR
TRUNCATE TABLE CURRENTUSER
TRUNCATE TABLE DELETED_USERDATA
TRUNCATE TABLE KNIGHTS
TRUNCATE TABLE KNIGHTS_RATING
TRUNCATE TABLE KNIGHTS_USER
TRUNCATE TABLE TB_USER
TRUNCATE TABLE USERDATA
TRUNCATE TABLE WAREHOUSE
TRUNCATE TABLE USERDATA_SKILLSHORTCUT
TRUNCATE TABLE USER_SAVED_MAGIC
TRUNCATE TABLE USER_RENTAL_ITEM
TRUNCATE TABLE KNIGHTS_ALLIANCE
TRUNCATE TABLE RENTAL_ITEM
TRUNCATE TABLE RENTAL_ITEM_LIST
TRUNCATE TABLE USER_MANNERPOINT_RANK
TRUNCATE TABLE PREMIUM_SERVICE
 
TRUNCATE TABLE KING_BALLOT_BOX
TRUNCATE TABLE KING_ELECTION_LIST
TRUNCATE TABLE KING_SYSTEM
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD
 
TRUNCATE TABLE ITEMLER
TRUNCATE TABLE GOKHAN
TRUNCATE TABLE HERO_USER
TRUNCATE TABLE HACKTOOL_USERLOG
 
 
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,7,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)
INSERT INTO KING_SYSTEM VALUES(2,7,@Year,@Month,@Day,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)

EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_PERSONAL_RANK
exec imbacodermyst
exec otonpsimgesi
exec np_icon
exec Rank_Knights
update userdata set loyalty ='-5000' , Level = '5' , exp='0' , stritem='<NULL>' 
where authority ='255'
update userdata set loyalty ='1' 
where authority ='0'
update userdata set  authority='1'
where authority='2'

TRUNCATE TABLE KING_BALLOT_BOX
TRUNCATE TABLE KING_ELECTION_LIST
TRUNCATE TABLE KING_SYSTEM
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD
EXEC RANK_KNIGHTS
EXEC UPDATE_KING_ELECTION_LIST
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 + 2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)
INSERT INTO KING_SYSTEM VALUES(2,3,@Year,@Month,@Day + 2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,2100000000,2100000000,NULL,NULL)

update userdata set Loyalty = '0'where Authority = '255'
update userdata set LoyaltyMonthly = '0'where Authority = '255'
update userdata set authority = '255' where strUserID = (select userid from gokhan)
update userdata set stritem = '' where authority = '255'
update userdata set Knights = '0'where Level = '1' 
exec premium_azalt
exec KNIGHTS_RATING_UPDATE
exec RANK_KNIGHTS
EXEC USER_KNIGHTS_RATING_UPDATE
EXEC UPDATE_PERSONAL_RANK
declare @location varchar(120)
set @location = N'c:YedekDB Yedek-'+replace(str(year(getdate()))+'-'+str(month(getdate()))+'-'+str(day(getdate())),' ', '')+'.bak'

BACKUP DATABASE [Kn_Online] TO  DISK = @location WITH NOFORMAT, INIT,  NAME = N'KO-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10
declare @backupSetId as int
select @backupSetId = position from msdb..backupset where database_name=N'Kn_Online' and backup_set_id=(select max(backup_set_id) from msdb..backupset where database_name=N'Kn_Online' )
if @backupSetId is null begin raiserror(N'Verify failed. Backup information for database ''Kn_Online'' not found.', 16, 1) end
RESTORE VERIFYONLY FROM  DISK = @location WITH  FILE = @backupSetId,  NOUNLOAD,  NOREWIND
exec rescod
exec char_süreli_ban_guncelle

UPDATE    ITEM_UPGRADE
SET              nGenRate = 7000
WHERE     (nReqItem1 = 379021000) AND (nGenRate =10000)

UPDATE    ITEM_UPGRADE
SET              nGenRate = 6000
WHERE     (nReqItem1 = 379021000) AND (nGenRate =10000)

UPDATE    ITEM_UPGRADE
SET              nGenRate = 4000
WHERE     (nReqItem1 = 379021000) AND (nGenRate =10000)

UPDATE    ITEM_UPGRADE
SET              nGenRate = 2000
WHERE     (nReqItem1 = 379021000) AND (nGenRate =10000)

UPDATE    ITEM_UPGRADE
SET              nGenRate = 700
WHERE     (nReqItem1 = 379021000) AND (nGenRate =10000)

UPDATE    ITEM_UPGRADE
SET              nGenRate =2
WHERE     (nReqItem1 = 379021000) AND (nGenRate =10000)

UPDATE    ITEM_UPGRADE
SET              nGenRate = 1
WHERE     (nReqItem1 = 379021000) AND (nGenRate =10000)