Oncelikle Bu Kodu Qa Ya girdiginiz Taktirde 1 Haftada 1 Sağ tarafa gore Kralları Oto Secer..

BİR TEŞEKKURU COK GORMEYİN.




Kod:
DECLARE @knightsIndex smallint @NationHuman tinyint @NationKarus tinyint @kingKarus varchar(21) @kingHuman varchar(21) SELECT @kingKarus = strKarusUserID from USER_PERSONAL_RANK where nRank = 1 SELECT @kingHuman = strElmoUserID from USER_PERSONAL_RANK where nRank = 1 SELECT @knightsIndex = Knights FROM USERDATA where strUserId = @kingKarus SELECT @knightsIndex = Knights FROM USERDATA Where strUserId = @kingHuman SET @NationHuman = 2 SET @NationKarus = 1 UPDATE USERDATA SET Rank = 0 Where Rank = 1 BEGIN IF EXISTS (SELECT * FROM KING_ELECTION_LIST WHERE strName = @kingKarus) DELETE FROM KING_ELECTION_LIST WHERE strName = @kingKarus IF EXISTS (SELECT * FROM KING_CANDIDACY_NOTICE_BOARD WHERE strUserId = @kingKarus) DELETE FROM KING_CANDIDACY_NOTICE_BOARD WHERE strUserId = @kingKarus INSERT INTO KING_CANDIDACY_NOTICE_BOARD Values @kingKarus, @NationKarus, 20, 0) INSERT INTO [KING_ELECTION_LIST] VALUES(1, @NationKarus, @knightsIndex, @kingKarus, 0) UPDATE USERDATA SET Rank = 1 WHERE strUserId = @kingKarus UPDATE KING_SYSTEM SET strKingName = @kingKarus WHERE byNation = @NationKarus END BEGIN IF EXISTS (SELECT * FROM KING_ELECTION_LIST WHERE strName = @kingHuman) DELETE FROM KING_ELECTION_LIST WHERE strName = @kingHuman IF EXISTS (SELECT * FROM KING_CANDIDACY_NOTICE_BOARD WHERE strUserId = @kingHuman) DELETE FROM KING_CANDIDACY_NOTICE_BOARD WHERE strUserId = @kingHuman INSERT INTO KING_CANDIDACY_NOTICE_BOARD Values @kingHuman, @NationHuman, 20, 0) INSERT INTO [KING_ELECTION_LIST] VALUES(1, @NationHuman, @knightsIndex, @kingHuman, 0) UPDATE USERDATA SET Rank = 1 WHERE strUserId = @kingHuman UPDATE KING_SYSTEM SET strKingName = @kingHuman WHERE byNation = @NationHuman END