Wipe King Procedure

Knight Online private server tutorials/guides, new releases, and discussion
Post Reply
User avatar
DeadPoetic
Posts: 57
Joined: Fri Aug 17, 2018 3:45 am

Sat Aug 18, 2018 10:52 pm

TRUNCATE TABLE KING_BALLOT_BOX
TRUNCATE TABLE KING_ELECTION_LIST
TRUNCATE TABLE KING_SYSTEM
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD

EXEC RANK_KNIGHTS

INSERT INTO KING_ELECTION_LIST SELECT TOP 10 3,1,IDNum,Chief,0 FROM KNIGHTS WHERE Nation = 1 ORDER BY Points DESC
INSERT INTO KING_ELECTION_LIST SELECT TOP 10 3,2,IDNum,Chief,0 FROM KNIGHTS WHERE Nation = 2 ORDER BY Points DESC

DECLARE @Day tinyint
DECLARE @Month tinyint
DECLARE @Year smallint
DECLARE @Hour tinyint

SET @Day = DAY(GETDATE())+1
SET @Month = MONTH(GETDATE())
SET @Year = YEAR(GETDATE())
SET @Hour = 18

INSERT INTO KING_SYSTEM VALUES(1,1,@Year,@Month,@Day,@Hour,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,0,NULL,NULL)
INSERT INTO KING_SYSTEM VALUES(2,1,@Year,@Month,@Day,@Hour,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,10,0,0,NULL,NULL)
Image
Post Reply