Вернуться   D3Scene.Ru Софт портал игр | Хаки | Проги | Статьи > World Of Warcraft > Флейм и Обсуждение WoW > WoW Серверная
Присоединяйся к нам

WoW Серверная Хочешь поднять свой сервер? Mangos, ArcEmu, TrinityCore и другие эмуляторы.



Ответ
 
Опции темы Опции просмотра
Старый 06.05.2011, 10:20   #1
Старожил

 
Аватар для Regaska
 
Регистрация: 15.02.2009
Адрес: Гражданка - мёд!
Сообщений: 784
Репутация: 292
Отправить сообщение для Regaska с помощью ICQ Отправить сообщение для Regaska с помощью Skype™
Автор По умолчанию

[ArcEmu]Чистка базы


Очистка базы world..


Код:
DELETE FROM `vendors` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_proto`);  
 DELETE FROM `vendors` WHERE `item` NOT IN (SELECT `entry` FROM `items`);  

 DELETE FROM `creature_waypoints` WHERE `spawnid` NOT IN (SELECT `id` FROM `creature_spawns`);  

 DELETE FROM `trainer_spells` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_proto`);  
 DELETE FROM `trainer_defs` WHERE `entry` NOT IN (SELECT `entry` FROM `creature_proto`);  
 DELETE FROM `trainer_spells` WHERE `entry` NOT IN (SELECT `entry` FROM `trainer_defs`);  
 DELETE FROM `trainer_defs` WHERE `entry` NOT IN (SELECT `entry` FROM `trainer_spells`);  

 DELETE FROM `creature_quest_starter` WHERE `quest` NOT IN (SELECT `entry` FROM `quests`);  
 DELETE FROM `creature_quest_finisher` WHERE `quest` NOT IN (SELECT `entry` FROM `quests`);  
 DELETE FROM `gameobject_quest_starter` WHERE `quest` NOT IN (SELECT `entry` FROM `quests`);  
 DELETE FROM `gameobject_quest_finisher` WHERE `quest` NOT IN (SELECT `entry` FROM `quests`);  

 DELETE FROM `creature_quest_starter` WHERE `id` NOT IN (SELECT `entry` FROM `creature_proto`);  
 DELETE FROM `creature_quest_finisher` WHERE `id` NOT IN (SELECT `entry` FROM `creature_proto`);  
 DELETE FROM `gameobject_quest_starter` WHERE `id` NOT IN (SELECT `entry` FROM `gameobject_names`);  
 DELETE FROM `gameobject_quest_finisher` WHERE `id` NOT IN (SELECT `entry` FROM `gameobject_names`);  

 DELETE FROM `itemloot` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `gameobjectloot` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `creatureloot` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `pickpocketingloot` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `fishingloot` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `skinningloot` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `prospectingloot` WHERE `itemid` NOT IN (SELECT `entry` FROM `items`);  

 DELETE FROM `itemloot` WHERE `entryid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `prospectingloot` WHERE `entryid` NOT IN (SELECT `entry` FROM `items`);  
 DELETE FROM `fishingloot` WHERE `entryid` NOT IN (SELECT `Zone` FROM `fishing`);  
 DELETE FROM `gameobjectloot` WHERE `entryid` NOT IN (SELECT `entry` FROM `gameobject_names`);  
 DELETE FROM `creatureloot` WHERE `entryid` NOT IN (SELECT `entry` FROM `creature_proto`);  
 DELETE FROM `pickpocketingloot` WHERE `entryid` NOT IN (SELECT `entry` FROM `creature_proto`);  
 DELETE FROM `skinningloot` WHERE `entryid` NOT IN (SELECT `entry` FROM `creature_proto`)

Очистка базы character..


Код:
DELETE FROM `playeritems` WHERE `ownerguid` NOT IN (SELECT `guid` FROM `characters`);  
 DELETE FROM `tutorials` WHERE `playerId` NOT IN (SELECT `guid` FROM `characters`);  
 DELETE FROM `social_friends` WHERE `character_guid` NOT IN (SELECT `guid` FROM `characters`);  
 DELETE FROM `social_ignores` WHERE `character_guid` NOT IN (SELECT `guid` FROM `characters`);  
 DELETE FROM `questlog` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);  
 DELETE FROM `corpses` WHERE `guid` NOT IN (SELECT `guid` FROM `characters`);  
 DELETE FROM `mailbox` WHERE `player_guid` NOT IN (SELECT `guid` FROM `characters`);  
 DELETE FROM `characters` WHERE `acct` NOT IN (SELECT `acct` FROM `accounts`);  
 DELETE FROM `gm_tickets` WHERE `playerGuid` NOT IN (SELECT `guid` FROM `characters`);
  Ответить с цитированием Наверх
Ответ


Здесь присутствуют: 1 (пользователей: 0 , гостей: 1)
 
Опции темы
Опции просмотра

Ваши права в разделе
Вы не можете создавать новые темы
Вы не можете отвечать в темах
Вы не можете прикреплять вложения
Вы не можете редактировать свои сообщения

BB коды Вкл.
Смайлы Вкл.
[IMG] код Вкл.
HTML код Выкл.

Быстрый переход


Powered by vBulletin
Copyright © 2017 vBulletin Solutions, Inc.
Перевод: zCarot | Дизайн: G-A | Верстка: OldEr
Текущее время: 10:08. Часовой пояс GMT +4.