Panelde Eski Kalan Useri Temizlemek

[bigahega]

1. Uygulucağimiz KOD

truncate table ACCOUNT_CHAR

truncate table USERDATA

truncate table TB_USER

truncate table WAREHOUSE

truncate table USER_SAVED_MAGIC

truncate table USERDATA_SKILLSHORTCUT

truncate table FRIEND_LIST

truncate table KNIGHTS

truncate table KNIGHTS_USER

truncate table KNIGHTS_RATING

update KING_SYSTEM set strKingName = '[KO-FOX.COM]'



update USER_KNIGHTS_RANK set strelmouserid = ''

update USER_KNIGHTS_RANK set strelmoknightsname = ''

update USER_KNIGHTS_RANK set nelmoloyalty = ''

update USER_KNIGHTS_RANK set strkarususerid = ''

update USER_KNIGHTS_RANK set strkarusknightsname = ''

update USER_KNIGHTS_RANK set strelmouserid = ''

update USER_KNIGHTS_RANK set nkarusloyalty = ''



update user_personal_rank set strelmouserid = ''

update user_personal_rank set nElmoLoyaltyMonthly = ''

update user_personal_rank set nelmocheck = ''

update user_personal_rank set strkarususerid = ''

update user_personal_rank set nkarusLoyaltyMonthly = ''

update user_personal_rank set Nkaruscheck = ''

2. Uygulucağimiz KOD

truncate table currentuser