Kod:
SQL
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
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)
Kod:
exec kral_ekle NİCK
Kod:
exec kral_sil NİCK
Kod:
update userdata set loyaltymonthly = 0
