PDA

View Full Version : [MU] xin querry xóa acc tất cả (ACC,GUILD...) chỉ chừa lai DB trống



summoner
25-06-14, 05:01 PM
xin querry xóa acc tất cả (ACC,GUILD...) chỉ chừa lai DB trống

Dragon7x
25-06-14, 05:50 PM
xin querry xóa acc tất cả (ACC,GUILD...) chỉ chừa lai DB trống

chịu khó đào mộ đi bạn :|
<b><font color=red>[Chỉ có thành viên mới xem link được. <a href="register.php"> Nhấp đây để đăng ký thành viên......</a>]</font></b>

heroviet2301
25-06-14, 06:39 PM
Sao phải khổ vậy nhỉ, làm lại DB mới là xong thôi mà :|

babykute
25-06-14, 09:19 PM
Nếu là DB của NBB thì dùng Query này :). Nó đưa nhận vật về lúc mới tạo mà ko cần xóa :D Còn xóa hết dùng DB mới cho nhanh bạn ơi


-- Char Reset :Update Character set [clevel]=400, [experience]='0', [money]=10000000, [LevelUpPoint]=2000, [pointdutru]='0', [resets]=5, Relifes=0, ResetNBB=5, [strength]='26', [dexterity]='26', [vitality]='26', [energy]='26', [Leadership]='25', [Life]='110', [MaxLife]='110', [Mana]='60', [MaxMana]='60', [PkLevel] = '3', [PkTime] = '0', [pkcount] = '0', [NoResetInDay]='0', [Top50]=0, [Resets_Time]='0', PointUyThac=0, Onlinetime=0, [MagicList]= CONVERT(varbinary(180), null), SCFMasterLevel='0', SCFMasterPoints='0', SCFMasterSkill=CONVERT(varbinary(180), null), [SCFPCPoints]='0', Quest=CONVERT(varbinary(50), null), uythacoffline_stat='0', uythacoffline_time='0', UyThacOffline_Daily=0, point_event=0, PointUyThac_Event=0, DGT_Time=0, NBB_Resets_0h=0, NBB_Relifes_0h=0, reset_total=0, nbbtuluyen_str=0, nbbtuluyen_str_point=0, nbbtuluyen_str_exp=0, nbbtuluyen_str_cp=0, nbbtuluyen_agi=0, nbbtuluyen_agi_point=0, nbbtuluyen_agi_exp=0, nbbtuluyen_agi_cp=0, nbbtuluyen_vit=0, nbbtuluyen_vit_point=0, nbbtuluyen_vit_exp=0, nbbtuluyen_vit_cp=0, nbbtuluyen_ene=0, nbbtuluyen_ene_point=0, nbbtuluyen_ene_exp=0, nbbtuluyen_ene_cp=0, nbbtuluyen_point=0, nbbsongtu_lv=0, nbbsongtu_point=0, nbbsongtu_exp=0, nbbsongtu_cp=0
-- DELETE Rank Reset :
DELETE TopReset
-- DELETE Rank Reset Point:
DELETE TopResetScore
-- DEL Lucky Coin :
DELETE LuckyCoinsRank
-- Char Unblock :
Update Character SET ctlcode=0 WHERE ctlcode=1
-- Class DW :
Update Character SET Class='0', [MapNumber]='0', [MapPosX]='143', [MapPosY]='134', [MapDir]='0' WHERE (Class='1' OR Class='2' OR Class='3')
-- Class DK :
Update Character SET Class='16', [MapNumber]='0', [MapPosX]='143', [MapPosY]='134', [MapDir]='0' WHERE (Class='17' OR Class='18' OR Class='19')
-- Class ELF :
Update Character SET Class='32', [MapNumber]='3', [MapPosX]='175', [MapPosY]='115', [MapDir]='0' WHERE (Class='33' OR Class='34' OR Class='35')
-- Class MG :
Update Character SET Class='48', [MapNumber]='0', [MapPosX]='143', [MapPosY]='134', [MapDir]='0' WHERE (Class='49' OR Class='50' OR Class='51')
-- Class DL :
Update Character SET Class='64', [MapNumber]='0', [MapPosX]='143', [MapPosY]='134', [MapDir]='0' WHERE (Class='65' OR Class='66' OR Class='67')
-- Class SUM :
Update Character SET Class='80', [MapNumber]='51', [MapPosX]='53', [MapPosY]='226', [MapDir]='0' WHERE (Class='81' OR Class='82' OR Class='83')
-- Class RF :
Update Character SET Class='96', [MapNumber]='0', [MapPosX]='143', [MapPosY]='134', [MapDir]='0' WHERE (Class='97' OR Class='98' OR Class='99')
-- Reset Guild :
Update Guild SET [G_Created]=GETDATE(), [G_TopPoint]=0, [G_TopRS]=0, [G_TopMem]=0, [G_PointTotal]=0, [G_SlgMem]=0, [G_RSTotal]=0, [G_RSYesterday]=0, [time_update_rsyesterday]=0
-- Reset Acc :
Update MEMB_INFO set [bank]=20000000, [vpoint]=0, [gcoin]=0, [gcoin_km]=0, gcoin_km_day=0, [jewel_chao]=0, jewel_chao_day=0, [jewel_cre]=0, [jewel_blue]=0, IPBonusPoint=0, SCFVipMoney=0, nbb_pl=0, jewel_heart=0, nbbcuonghoa_point=0
-- Reset Tui Do :
UPDATE Character SET Inventory=CONVERT(varbinary(3776), null)
-- Reset Hom Do :
UPDATE warehouse SET Money=0, Items=CONVERT(varbinary(3840), null)
-- Reset Hom Do Extra:
DELETE ExtendedWarehouse
-- Reset GIFTCODE:
DELETE GiftCode
-- Reset GIFTCODE Tang:
UPDATE GiftCode SET status=1
-- Reset GiftLog:
DELETE GiftLog
-- Reset Time Online:
DELETE nbb_timeonline_date
-- Reset Quest Daily:
DELETE nbb_quest_daily
-- Reset Quest Daily:
DELETE nbb_use_money
-- Reset Quest Daily:
DELETE nbb_pl_daily
-- Reset Cuong Hoa:
DELETE nbb_cuonghoa
-- Reset TOP Point:
DELETE nbb_toppoint
-- Season 6.2-- Xoa Tien te, Cashop:UPDATE MEMB_INFO SET MuItemShopList=CONVERT(varbinary(720), null),MuItemShopGiftList=CONVERT(varbinary(720), null),MuItemShopGiftMsg=CONVERT(varbinary(4995), null), WCoin=0, WCoinP=0, GoblinCoin=0
-- Xoa BuffUPDATE Character SET SCFExtInventory=0, SCFSealItem=0, SCFSealTime=0, SCFScrollItem=0, SCFScrollTime=0
-- Xoa Dau Gia:
DELETE DauGia_Item
DELETE DauGia_Bid
-- Xoa Thue Item:
DELETE NBB_ThueItem
DELETE Titan_Rewards