Как создать Вайп - удалить только персонажи...а Аккаунты ОСТАЛИСЬ???

[malinkhii]

ребята как сделать вайп чтобы только персонажи удалились ...а Акаунты ОСТАЛИСЬ ?

[ASTr1keRss]

Выполнить скрипт в query, удалить все кромe MEMB_INFO если каких данных не хватает сам поймешь как добавить...

Код Выделить Развернуть

Delete from AccountCharacter
Delete from BankEx
Delete from Character
Delete from ConnectionHistory
Delete from GameShopGiftStorage
Delete from GameShopPoint
Delete from GameShopStorage
Delete from GensMember
Delete from Guild
Delete from GuildMember
Delete from MEMB_CREDITS
Delete from MEMB_STAT
Delete from Monster_Kill_Info
Delete from Mu_DBID
Delete from MuCastle_MONEY_STATISTICS
Delete from MuCastle_REG_SIEGE
Delete from MuCastle_SIEGE_GUILDLIST
Delete from OptionData
Delete from T_CGuid
Delete from T_CurCharName
Delete from T_FriendList
Delete from T_FriendMail
Delete from T_FriendMain
Delete from T_LUCKY_ITEM_INFO
Delete from T_LuckyCoinRegCount
Delete from T_MacroInfo
Delete from T_MU2003_EVENT
Delete from T_PCBANG_POINT_INFO
Delete from T_PeriodItem_Info
Delete from T_PetItem_Info
Delete from T_QUEST_EXP_INFO
Delete from T_RegCount_Check
Delete from T_SkillTree_Info
Delete from T_WaitFriend
Delete from warehouse

[malinkhii]

не помогло!! только хуже стало

[ASTr1keRss]

я же тебе написал... добавь все таблицы которые есть в базе по принципу, проделай так с каждой таблицей в базе
Delete from AccountCharacter
Delete from Character
Delete from .... где вместо ... твоя таблица в базе MuOnline

Все кроме MEMB_INFO

[Moon]

На форуме эта тема подымалась, читай просто читай.

[Profesor08]

В твоем случае только:

DROP DATABASE MuOnline