[XxXBowXxX]

المشاركة الأصلية كتبت بواسطة ™stop™ عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

use this best :)

sro_vt_account

use [sro_vt_account]
go
truncate table [dbo].[__siegefortressstatus__]
truncate table [dbo].[_blockeduser]
truncate table [dbo].[_casgmchatlog]
truncate table [dbo].[_notice]
truncate table [dbo].[_punishment]
truncate table [dbo].[_servicemanagerlog]
truncate table [dbo].[_shardcurrentuser]
truncate table [dbo].[_smclog]
truncate table [dbo].[quaysoepoint]
truncate table [dbo].[sk_charrenamelog]
truncate table [dbo].[sk_downlevellog]
truncate table [dbo].[sk_item_guardlog]
truncate table [dbo].[sk_itemsalelog]
truncate table [dbo].[sk_packageitemsalelog]
truncate table [dbo].[sk_pk_updatelog]
truncate table [dbo].[sk_resetskilllog]
truncate table [dbo].[sk_silk]
truncate table [dbo].[sk_silkbuylist]
truncate table [dbo].[sk_subtractsilk_vas]
truncate table [dbo].[sr_shardcharnames]
truncate table [dbo].[tb_net2e]
truncate table [dbo].[tb_net2e_bak]
truncate table [dbo].[tb_partnerinfo]
truncate table [dbo].[tb_paygate_trans]
truncate table [dbo].[tb_user]
truncate table [dbo].[tb_user_bak]
truncate table [dbo].[test_hn]
update [dbo].[_shardservice] set shardid = '64'

**********************

sro_vt_shard

use [sro_vt_shard]
go
truncate table [dbo].[_chest]
truncate table [dbo].[_chestinfo]
truncate table [dbo].[_user]
truncate table [dbo].[_openmarket]
delete from [dbo].[_accountjid] 
truncate table [dbo].[_guildwar]
truncate table [dbo].[_guildmember]
truncate table [dbo].[_guildchest]
truncate table [dbo].[_siegefortressstruct]
truncate table [dbo].[_siegefortressobject]
truncate table [dbo].[_siegefortressitemforge]
delete from [dbo].[_siegefortress]
insert into [dbo].[_siegefortress](fortressid) values (1)
insert into [dbo].[_siegefortress](fortressid) values (3)
insert into [dbo].[_siegefortress](fortressid) values (6)
update [dbo].[_alliedclans] set ally1 = '0', ally2 = '0', ally3 = '0', ally4 = '0', ally5 = '0', ally6 = '0', ally7 = '0', ally8 = '0'
delete from [dbo].[_guild] where id > 0
delete from [dbo].[_alliedclans] where id > 0
truncate table [dbo].[_inventoryforavatar]
truncate table [dbo].[_trainingcampsubmentorhonorpoint]
truncate table [dbo].[_blockedwhisperers]
truncate table [dbo].[_trainingcampmember]
truncate table [dbo].[_chartrijobsafetrade]
delete from [dbo].[_chartrijob] where charid > 0
truncate table [dbo].[_timedjob]
truncate table [dbo].[_staticavatar]
truncate table [dbo].[_inventory]
truncate table [dbo].[_memo]
truncate table [dbo].[_fleamarketnetwork]
truncate table [dbo].[_friend]
truncate table [dbo].[_charskillmastery]
truncate table [dbo].[_charskill]
truncate table [dbo].[_invcos]
delete from [dbo].[_charcos] where id > 0
delete from [dbo].[_char] where charid > 0
truncate table [dbo].[_charcollectionbook]
truncate table [dbo].[_charinstanceworlddata]
truncate table [dbo].[_charnamelist]
truncate table [dbo].[_charnicknamelist]
truncate table [dbo].[_charquest]
truncate table [dbo].[_clientconfig]
truncate table [dbo].[_deletedchar]
truncate table [dbo].[_gphistory]
truncate table [dbo].[_inventoryforlinkedstorage]
truncate table [dbo].[_itempool]
delete from [dbo].[_items] where id64 > 0
truncate table [dbo].[_skill_baohiem_tnet]
truncate table [dbo].[_timedjobforpet]
truncate table [dbo].[_trainingcampbuffstatus]
truncate table [dbo].[_trainingcamphonorrank]
insert into [dbo].[_trainingcamphonorrank](ranking) values (1)
insert into [dbo].[_trainingcamphonorrank](ranking) values (2)
insert into [dbo].[_trainingcamphonorrank](ranking) values (3)
insert into [dbo].[_trainingcamphonorrank](ranking) values (4)
insert into [dbo].[_trainingcamphonorrank](ranking) values (5)
insert into [dbo].[_trainingcamphonorrank](ranking) values (6)
insert into [dbo].[_trainingcamphonorrank](ranking) values (7)
insert into [dbo].[_trainingcamphonorrank](ranking) values (8)
insert into [dbo].[_trainingcamphonorrank](ranking) values (9)
insert into [dbo].[_trainingcamphonorrank](ranking) values (10)
insert into [dbo].[_trainingcamphonorrank](ranking) values (11)
insert into [dbo].[_trainingcamphonorrank](ranking) values (12)
insert into [dbo].[_trainingcamphonorrank](ranking) values (13)
insert into [dbo].[_trainingcamphonorrank](ranking) values (14)
insert into [dbo].[_trainingcamphonorrank](ranking) values (15)
insert into [dbo].[_trainingcamphonorrank](ranking) values (16)
insert into [dbo].[_trainingcamphonorrank](ranking) values (17)
insert into [dbo].[_trainingcamphonorrank](ranking) values (18)
insert into [dbo].[_trainingcamphonorrank](ranking) values (19)
insert into [dbo].[_trainingcamphonorrank](ranking) values (20)
insert into [dbo].[_trainingcamphonorrank](ranking) values (21)
insert into [dbo].[_trainingcamphonorrank](ranking) values (22)
insert into [dbo].[_trainingcamphonorrank](ranking) values (23)
insert into [dbo].[_trainingcamphonorrank](ranking) values (24)
insert into [dbo].[_trainingcamphonorrank](ranking) values (25)
insert into [dbo].[_trainingcamphonorrank](ranking) values (26)
insert into [dbo].[_trainingcamphonorrank](ranking) values (27)
insert into [dbo].[_trainingcamphonorrank](ranking) values (28)
insert into [dbo].[_trainingcamphonorrank](ranking) values (29)
insert into [dbo].[_trainingcamphonorrank](ranking) values (30)
insert into [dbo].[_trainingcamphonorrank](ranking) values (31)
insert into [dbo].[_trainingcamphonorrank](ranking) values (32)
insert into [dbo].[_trainingcamphonorrank](ranking) values (33)
insert into [dbo].[_trainingcamphonorrank](ranking) values (34)
insert into [dbo].[_trainingcamphonorrank](ranking) values (35)
insert into [dbo].[_trainingcamphonorrank](ranking) values (36)
insert into [dbo].[_trainingcamphonorrank](ranking) values (37)
insert into [dbo].[_trainingcamphonorrank](ranking) values (38)
insert into [dbo].[_trainingcamphonorrank](ranking) values (39)
insert into [dbo].[_trainingcamphonorrank](ranking) values (40)
insert into [dbo].[_trainingcamphonorrank](ranking) values (41)
insert into [dbo].[_trainingcamphonorrank](ranking) values (42)
insert into [dbo].[_trainingcamphonorrank](ranking) values (43)
insert into [dbo].[_trainingcamphonorrank](ranking) values (44)
insert into [dbo].[_trainingcamphonorrank](ranking) values (45)
insert into [dbo].[_trainingcamphonorrank](ranking) values (46)
insert into [dbo].[_trainingcamphonorrank](ranking) values (47)
insert into [dbo].[_trainingcamphonorrank](ranking) values (48)
insert into [dbo].[_trainingcamphonorrank](ranking) values (49)
insert into [dbo].[_trainingcamphonorrank](ranking) values (50)
exec [dbo].[_training_camp_updatehonorrank]
delete from [dbo].[_trainingcamp]
truncate table [dbo].[tab_refranking_huntercontribution]
truncate table [dbo].[tab_refranking_robbercontribution]
truncate table [dbo].[tab_refranking_tradercontribution]

**********************

sro_vt_shardlog

use [sro_vt_shardlog]
go
truncate table [dbo].[_logeventchar]
truncate table [dbo].[_logeventitem]
truncate table [dbo].[_logeventsiegefortress]
truncate table [dbo].[_logschedule]
truncate table [dbo].[_logserverevent]

have fun..

ممكن تجيلي تيم فيور عندي مشكلة برده