Sorunsuz Tek Kodla Rest Atma.Bunu QA ya Uyguladığınızda Hiç Bir Bug Kalmaz Grade Vs.

-- Bu prosudur K!$K!$ tarafından yazılmıştır editlenmemiştir tamamen en baştan yazılmıştır...
CREATE PROCEDURE [gunluk]
as
-----------------------------------------------------------------------
exec imbacodermyst
-----------------------------------------------------------------------
exec KNIGHTS_RATING_UPDATE
-----------------------------------------------------------------------
exec RANK_KNIGHTS
-----------------------------------------------------------------------
update Knights set Points=999999
-----------------------------------------------------------------------
EXEC USER_KNIGHTS_RATING_UPDATE
-----------------------------------------------------------------------
EXEC UPDATE_PERSONAL_RANK
-----------------------------------------------------------------------
update userdata set Loyalty = '1'where Authority = '255'
-----------------------------------------------------------------------
update userdata set LoyaltyMonthly = '1'where Authority = '255'
-----------------------------------------------------------------------
update userdata set Loyalty = '1'where Authority = '0'
-----------------------------------------------------------------------
update userdata set LoyaltyMonthly = '1'where Authority = '0'
-----------------------------------------------------------------------
Update userdata Set Loyalty = '100' Where Loyalty = '0'
-----------------------------------------------------------------------
truncate table currentuser
-----------------------------------------------------------------------


GO

Kullanım: exec gunluk