- Krallıkla İlgili Tablolarımızı Temizliyoruz...
TRUNCATE TABLE KING_BALLOT_BOX
TRUNCATE TABLE KING_ELECTION_LIST
TRUNCATE TABLE KING_SYSTEM
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD
-- Önce Clanlarımızın Ranklarını Güncelliyoruz...
EXEC RANK_KNIGHTS
-- Karus İlk 10 Clan Liderini Kral Adayı Gösteriyoruz...
INSERT INTO KING_ELECTION_LIST SELECT TOP 10 41IDNumChief0 FROM KNIGHTS WHERE Nation = 1 ORDER BY Points DESC
-- El Morad İlk 10 Clan Liderini Kral Adayı Gösteriyoruz...
INSERT INTO KING_ELECTION_LIST SELECT TOP 10 42IDNumChief0 FROM KNIGHTS WHERE Nation = 2 ORDER BY Points DESC
-- 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(13@Year@Month@Day00000000000 000000001021000000002100000000NULLNUL L)
INSERT INTO KING_SYSTEM VALUES(23@Year@Month@Day00000000000 000000001021000000002100000000NULLNUL L)
TRUNCATE TABLE KING_BALLOT_BOX
TRUNCATE TABLE KING_ELECTION_LIST
TRUNCATE TABLE KING_SYSTEM
TRUNCATE TABLE KING_CANDIDACY_NOTICE_BOARD
-- Önce Clanlarımızın Ranklarını Güncelliyoruz...
EXEC RANK_KNIGHTS
-- Karus İlk 10 Clan Liderini Kral Adayı Gösteriyoruz...
INSERT INTO KING_ELECTION_LIST SELECT TOP 10 41IDNumChief0 FROM KNIGHTS WHERE Nation = 1 ORDER BY Points DESC
-- El Morad İlk 10 Clan Liderini Kral Adayı Gösteriyoruz...
INSERT INTO KING_ELECTION_LIST SELECT TOP 10 42IDNumChief0 FROM KNIGHTS WHERE Nation = 2 ORDER BY Points DESC
-- 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(13@Year@Month@Day00000000000 000000001021000000002100000000NULLNUL L)
INSERT INTO KING_SYSTEM VALUES(23@Year@Month@Day00000000000 000000001021000000002100000000NULLNUL L)