kral aktivasyon kodu

[Cankan_22]

CREATE PROCEDURE [dbo].[KRAL_EKLE]
@CharID varchar(21)
AS
/*
Network Tarafindan Yazilmistir. Hacilamak Yasaktir!
*/
BEGIN

DECLARE @Nation tinyint,@clanID smallint,@ClanName varchar(31),@AccID varchar(21)
select @Nation = Nation from USERDATA where strUserId = @CharID
select @ClanID = sIDnum from KNIGHTS_USER where StrUserID = @CharID
select @ClanName = IDName from KNIGHTS where IDNum = @ClanID
select @AccID = strAccountID from ACCOUNT_CHAR where @CharID = strCharID1 or @CharID = strCharID2 or @CharID = strCharID3
END

BEGIN
update KING_SYSTEM set strKingName = @CharID where byNation = @Nation

insert into [KING_ELECTION_LIST] Values(1, @Nation, @ClanID, @CharID, 0)

insert into [KING_CANDIDACY_NOTICE_BOARD] Values(@CharID, @Nation, 20, 0)

insert into [KING_BALLOT_BOX] Values(@AccID, @CharID, @Nation, @ClanName)

update USERDATA set Rank = '1' where strUserId = @CharID

print 'Tebrikler, Kullanici Basariyla Kral Olmustur. '

END
GO