Kod:

CREATE PROCEDURE Guncelle



--- Kullanım : EXEC GUNCELLE

AS

BEGIN

--------------------------------------------------------------------------------------------------

update userdata set Knights=0,Fame=0 where Authority=255

--------------------------------------------------------------------------------------------------

EXEC USER_KNIGHTS_RATING_UPDATE

--------------------------------------------------------------------------------------------------

EXEC UPDATE_PERSONAL_RANK

--------------------------------------------------------------------------------------------------

truncate table CURRENTUSER

--------------------------------------------------------------------------------------------------

UPDATE USERDATA

SET Loyalty = 0

WHERE Authority = 255

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 GmClan

EXEC GmNP

EXEC MuteNPBanNP

UPDATE USERDATA

SET Loyalty = 0

WHERE Authority = 255

---------------------------------------------------------------------------------------------------

update userdata set zone ='21' where zone='201'

update userdata set zone ='21' where zone='202'

update userdata set zone ='21' where zone='11'

update userdata set zone ='21' where zone='12'

update userdata set zone='21' where zone='1'

update userdata set zone='21' where zone='2'

update userdata set zone='21' where zone='61'

update userdata set zone='21' where zone='62'

update userdata set zone='21' where zone='81'

update userdata set zone='21' where zone='87'

update userdata set zone='21' where zone='88'

---------------------------------------------------------------------------------------------------

EXEC UPDATE_CLAN_RANK

---------------------------------------------------------------------------------------------------

EXEC RANK_KNIGHTS

EXEC USER_KNIGHTS_RATING_UPDATE

EXEC UPDATE_PERSONAL_RANK

EXEC GmClan

EXEC GmNP

EXEC MuteNPBanNP

----------------------------------------------------------------------------------------------------

update userdata set Knights = '0'where Level = '1'

update userdata set Knights = '0'where Level = '2'

update userdata set Knights = '0'where Level = '3'

update userdata set Knights = '0'where Level = '4'

update userdata set Knights = '0'where Level = '5'

update userdata set Knights = '0'where Level = '6'

update userdata set Knights = '0'where Level = '7'

update userdata set Knights = '0'where Level = '8'

update userdata set Knights = '0'where Level = '9'

update userdata set Knights = '0'where Level = '10'

update userdata set Knights = '0'where Level = '11'

update userdata set Knights = '0'where Level = '12'

update userdata set Knights = '0'where Level = '13'

update userdata set Knights = '0'where Level = '14'

update userdata set Knights = '0'where Level = '15'

update userdata set Knights = '0'where Level = '16'

update userdata set Knights = '0'where Level = '17'

update userdata set Knights = '0'where Level = '18'

update userdata set Knights = '0'where Level = '19'

update userdata set Knights = '0'where Level = '20'

----------------------------------------------------------------------------------------------------

END

GO



Ne İşe Yarar ?







Oyunda Yaptıgınız Resler Grade Kodları Vs.