[B]Create Procedure Rookie
BEGIN
update Knights set Ranking = '1'
EXEC USER_KNIGHTS_RATING_UPDATE
exec Rank_Knights
update Knights set Ranking = '1'
update userdata set Loyalty = '0'where Authority = '255'
update userdata set LoyaltyMonthly = '0'where Authority = '255'
--add
EXEC UPDATE_PERSONAL_RANK
TRUNCATE TABLE CURRENTUSER
END
GO[/B]
[B]Exec Rookie[/B]
Kod:[B]Create Procedure Rookie BEGIN update Knights set Ranking = '1' EXEC USER_KNIGHTS_RATING_UPDATE exec Rank_Knights update Knights set Ranking = '1' update userdata set Loyalty = '0'where Authority = '255' update userdata set LoyaltyMonthly = '0'where Authority = '255' --add EXEC UPDATE_PERSONAL_RANK TRUNCATE TABLE CURRENTUSER END GO[/B]
TEK KOD ;
Kod:[B]Exec Rookie[/B]
[B]Create Procedure RESET
BEGIN
update Knights set Ranking = '1'
EXEC USER_KNIGHTS_RATING_UPDATE
exec Rank_Knights
update Knights set Ranking = '1'
update userdata set Loyalty = '0'where Authority = '255'
update userdata set LoyaltyMonthly = '0'where Authority = '255'
--add
EXEC UPDATE_PERSONAL_RANK
TRUNCATE TABLE CURRENTUSER
END
GO[/B]
[B]Exec RESET[/B]
ulan berkay Hemen Rookie 😀
Kod:[B]Create Procedure RESET BEGIN update Knights set Ranking = '1' EXEC USER_KNIGHTS_RATING_UPDATE exec Rank_Knights update Knights set Ranking = '1' update userdata set Loyalty = '0'where Authority = '255' update userdata set LoyaltyMonthly = '0'where Authority = '255' --add EXEC UPDATE_PERSONAL_RANK TRUNCATE TABLE CURRENTUSER END GO[/B]
TEK KOD ;
Kod:[B]Exec RESET[/B]
Böyle Kullanmak İsteyenler İçin 🙂
Create Procedure RES
BEGIN
update Knights set Ranking = '1'
EXEC USER_KNIGHTS_RATING_UPDATE
exec Rank_Knights
update Knights set Ranking = '1'
update userdata set Loyalty = '0'where Authority = '255'
update userdata set LoyaltyMonthly = '0'where Authority = '255'
--add
EXEC UPDATE_PERSONAL_RANK
TRUNCATE TABLE CURRENTUSER
END
GO
Exec RES