Delete from character where Name not like '%NHAMSV%'
Delete from AccountCharacter
Delete from GuildMember
Delete from Guild
Delete from MEMB_STAT
Delete from T_CGuid
Delete from T_CurCharName
Delete from T_FriendList
Delete from T_FriendMail
Delete from T_FriendMain
Delete from T_PeriodItemInfo
Delete from warehouse
Delete from CardPhone
Delete from DauGia_Bid
Delete from DauGia_Item
Delete from DauGiaNguoc_Bid
Delete from DauGiaNguoc_Item
Delete from DauGiaNguoc_TheHe
Delete from DoanhThu
Delete from Event_TOP_Card
Delete from Event_TOP_Point
Delete from Event_TOP_RS
Delete from GiftCode
Delete from GiftLog
Delete from IPBonus_acc
Delete from IPBonus
Delete from item_vpoint_changed
Delete from Log_chuyensv
Delete from Log_TienTe
Delete from NBB_Award
Delete from nbb_pl_daily
Delete from nbb_plmarket
Delete from nbb_quest_daily
Delete from nbb_timeonline_date
Delete from nbb_toppoint
Delete from nbb_topweek
Delete from nbb_use_money
Delete from TopReset
Delete from TopResetScore
Delete from GiaiTri_LoDe
--Log VWEB
Delete from event_doiitem_vweb
Delete from vweb_block
Delete from EVENT_TONGTOP_VWEB
Delete from EVENT_TONGTOP_VWEB_KETQUA
Delete from CardVweb
Delete from Log_ModVweb
Delete from Log_chuyensv
Delete from ShareFB_VWEB
Delete from vweb_warehouse_safe
Delete from vweb_block
Delete from vweb_muathe
Delete from vweb_gift_tichluythe
Delete from vweb_doingoc
Delete from VWEB_Resets_Log
Delete from VWEB_PointEvent_Log
Delete from VWEB_DanhHieuThue_Log
Delete from vweb_gift_thangcap
Delete from Event_TOP_TieuPhi
Delete from MEMB_INFO Where memb___id not like 'adm_block'
Update GameServerInfo set Number=0, ItemCount=0, ZenCount=0, MuShopItemCount=0