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

Aspava

PvP-Gaming
Üye
16 Haz 2018
139
115
43
Awards
1
41
Bursa
tekport.net
DB sıfırlama kodu
Kod:
 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 
 
truncate table KNIGHTS 
 
go
 
truncate table KNIGHTS_ALLIANCE 
 
go
 
truncate table KNIGHTS_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



RES KODU :
Kod:
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)
KRAL EKLE - SİL
Kod:
exec kral_ekle NİCK
Kod:
exec kral_sil NİCK
SAĞ NP SIIFRLAMA KODU
Kod:
update userdata set loyaltymonthly = 0