MMO Base News - World of Warcraft

удалить

Bloderboy — Sat, 08 Oct 2011 10:09:24 GMT

Форум: Базы ArcEmu
Автор темы: Bloderboy
Автор последнего сообщения: night-angel
Количество ответов: 1

Чистка базы

Bloderboy — Sun, 25 Sep 2011 13:47:40 GMT

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

Code

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..

Code

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`);

Решение проблем с кодировкой MySQL

Bloderboy — Sun, 25 Sep 2011 13:27:34 GMT

Зачастую встречаю вопросы на счет того, что где то на страничке вылазят иероглифы вместо текста, который берется с базы, либо же знаки вопроса (??????).

Только что наткнулся на тот же подводный камень при переписывании игры с cp1251 на utf8.

после подключения к базе данных я дописал

Code

mysql_query('SET NAMES utf8');
mysql_query('SET CHARACTER SET utf8');
mysql_query('SET character_set_database = utf8'

вместо utf8 необходимо выставить ту кодировку которая вам нужна.
На файлах стоит кодировка utf8… на таблице и ячейках в ней стоит тип utf8_unicode_ci. То есть грубо говоря все в utf8. Даже в .htaccess дописал
AddDefaultCharset UTF-8

а в базу лезут знаки вопросов "???????". долго не мог понять в чем же все таки заключается проблема… и… чисто случайно, при просмотре структуры таблиц я заметил что не все еще имеет тип UTF8.

Вот они, два чудо запроса

Code

SET NAMES utf8;
ALTER DATABASE `название_базы_данных` DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

RUDB r37.7 (ArcEMU/Ascent)

Bloderboy — Sun, 25 Sep 2011 13:16:51 GMT

RUDB r37.7 (3.3.3a) Скачть
RuDB R38.7 Скачать

Quote

RuDB R38.7 Исправлены допущенные ошибки при предыдущей конвертации

База данных 3.1.3 по Apiredev

Бульдозер — Mon, 05 Sep 2011 14:13:34 GMT

SVN Download

Database Version rev 25
98% New 3.1.3 Items
100% New 3.1.3 Npcs´s
New Fixxes 12.07.2009
Fixx Vendors
Fixx Nordend Crashes
Fixx NPCs Damage
Fixx Waypoints

SVN: https://india635.server4you.de:8443/svn/bhndb
Логин и пароль bhn

Locales DB in Russian Language

Administrator — Thu, 21 Apr 2011 16:57:14 GMT

Локализация представляет из себя сконвертированную RUDB rev. 21 под ArcEmu. Для работы с локализацией в базе данных arcemu-logon, в таблице accounts поле forceLanguage у данного аккаунта нужно задать ruRU.

скачать с свн

Query(запрос на изменении локали у всех аккаунтов):
Код:
UPDATE `accounts` SET `forceLanguage` = 'ruRU'