Sağ Sıfırlama & Database Sıfırlama & KRal Ekle-Sil & RESET KODU Gerekli Olan Kodlar.

truncate table account_char

go

truncate table currentuser

go

truncate table deleted_userdata

go

truncate table knights

go

truncate table knights_rating

go

truncate table knights_user

go

truncate table tb_user

go

truncate table userdata

go

truncate table warehouse

go

truncate table np_kings

go

truncate table np_kings2

go

truncate table USER_SAVED_MAGIC

go

truncate table USERDATA_SKILLSHORTCUT

go

truncate table PREMIUM_SERVICE

go

truncate table KARUS_RANK

go

truncate table ELMO_RANK

go

truncate table HERO_USER

go



RESET KODU

NOT : 100 Kayitli kullanici var iken yapin , server kapayip girilmesi gerekir..



NOT 2 : ACMEDE Exec Guncelle Yazarak Oyun acikkende Reset Atabilrsinz



RESET KODU

NOT : 100 Kayitli kullanici var iken yapin , server kapayip girilmesi gerekir..



NOT 2 : ACMEDE Exec Guncelle Yazarak Oyun acikkende Reset Atabilrsinz



RES KODU :
[CODE]EXEC USER_KNIGHTS_RATING_UPDATE

EXEC UPDATE_PERSONAL_RANK

update Knights set Points = '999999'

exec rank_knights

update knights set points = '999999',ranking = '0'

update knights set points = '999999',ranking = '1'

where idname = (Select strname from KNIGHTS_RATING where nrank = 1)

update knights set points = '999999',ranking = '1'

where idname = (Select strname from KNIGHTS_RATING where nrank = 2)

update knights set points = '999999',ranking = '1'

where idname = (Select strname from KNIGHTS_RATING where nrank = 3)

update knights set points = '999999',ranking = '1'

where idname = (Select strname from KNIGHTS_RATING where nrank = 4)

update knights set points = '999999',ranking = '1'

where idname = (Select strname from KNIGHTS_RATING where nrank = 5)

exec kral_ekle NİCK

exec kral_sil NİCK

update userdata set loyaltymonthly = 0