Здравствуйте, хочу на одном ПК поставить 3.3.5а и 4.3.4 но не знаю как правильно это сделать, подскажите кто знает, с меня +
в Auth\realmlist добавь еще один реалм. (не забудь заполнить gamebild у 4.3.4 15595, у 3.3.5 не помню, порты желательно указать разные у реалмов) и у второго сервера в конфиге измени realmid и порты чтоб так же было как и в реалмлисте. У 2х реалмов ток Auth оставь общим.
Продажа готовых сборок cataclysm 4.3.4, legion (7.3.5), shadowlands, draginflight. Исправление спеллов, квестов, крашей на любых версиях вов. Цена договорная. Пишите в лс, не дорого.
Сообщение # 2 отредактировано Sergey996 - Пятница, 20.06.2014, 02:04
что я сделал в 1 сервере ничего не менял только добавил в Серв\usr\local\mysql-5.5\data char1 и world1 во втором в ворлдсервер изменил две строчки
WorldDatabaseInfo = "127.0.0.1;3306;serv;123;world" CharacterDatabaseInfo = "127.0.0.1;3306;serv;123;char" на WorldDatabaseInfo = "127.0.0.1;3306;serv;123;world1" CharacterDatabaseInfo = "127.0.0.1;3306;serv;123;char1" и естественно порт 8085 поменял на 8086 и все бы ничего, но при запуске 2-го мира серв падает
делал по образу и подобию как тут http://www.youtube.com/watch?v=JzSjwQL4MNE
Добавлено (20.06.2014, 04:00) --------------------------------------------- Лог Начало
In mysql_stmt_prepare() id: 0, sql: "DELETE FROM pool_quest_save WHERE pool_id = ?" Table 'char1.pool_quest_save' doesn't exist In mysql_stmt_prepare() id: 1, sql: "INSERT INTO pool_quest_save (pool_id, quest_id) VALUES (?, ?)" Table 'char1.pool_quest_save' doesn't exist In mysql_stmt_prepare() id: 2, sql: "DELETE FROM guild_bank_item WHERE guildid = ? AND TabId = ? AND SlotId = ?" Table 'char1.guild_bank_item' doesn't exist In mysql_stmt_prepare() id: 3, sql: "UPDATE character_banned SET active = 0 WHERE unbandate <= UNIX_TIMESTAMP() AND unbandate <> bandate" Table 'char1.character_banned' doesn't exist In mysql_stmt_prepare() id: 4, sql: "SELECT guid FROM characters WHERE name = ?" Table 'char1.characters' doesn't exist In mysql_stmt_prepare() id: 5, sql: "SELECT 1 FROM characters WHERE name = ?" Table 'char1.characters' doesn't exist In mysql_stmt_prepare() id: 7, sql: "SELECT COUNT(guid) FROM characters WHERE account = ?" Table 'char1.characters' doesn't exist In mysql_stmt_prepare() id: 8, sql: "SELECT level, race, class FROM characters WHERE account = ? LIMIT 0, ?" Table 'char1.characters' doesn't exist In mysql_stmt_prepare() id: 9, sql: "INSERT INTO character_banned VALUES (?, UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+?, ?, ?, 1)" Table 'char1.character_banned' doesn't exist In mysql_stmt_prepare() id: 10, sql: "UPDATE character_banned SET active = 0 WHERE guid = ? AND active != 0" Table 'char1.character_banned' doesn't exist In mysql_stmt_prepare() id: 11, sql: "DELETE cb FROM character_banned cb INNER JOIN characters c ON c.guid = cb.guid WHERE c.account = ?" Table 'char1.character_banned' doesn't exist In mysql_stmt_prepare() id: 19, sql: "SELECT c.guid, c.name, c.race, c.class, c.gender, c.playerBytes, c.playerBytes2, c.level, c.zone, c.map, c.position_x, c.position_y, c.position_z, gm.guildid, c.playerFlags, c.at_login, cp.entry, cp.modelid, cp.level, c.equipmentCache, cb.guid, c.slot FROM characters AS c LEFT JOIN character_pet AS cp ON c.guid = cp.owner AND cp.slot = ? LEFT JOIN guild_member AS gm ON c.guid = gm.guid LEFT JOIN character_banned AS cb ON c.guid = cb.guid AND cb.active = 1 WHERE c.account = ? AND c.deleteInfos_Name IS NULL"
конец
Table 'char1.pet_aura' doesn't exist In mysql_stmt_prepare() id: 441, sql: "SELECT spell, active FROM pet_spell WHERE guid = ?" Table 'char1.pet_spell' doesn't exist In mysql_stmt_prepare() id: 442, sql: "SELECT spell, time FROM pet_spell_cooldown WHERE guid = ?" Table 'char1.pet_spell_cooldown' doesn't exist In mysql_stmt_prepare() id: 443, sql: "SELECT genitive, dative, accusative, instrumental, prepositional FROM character_pet_declinedname WHERE owner = ? AND id = ?" Table 'char1.character_pet_declinedname' doesn't exist In mysql_stmt_prepare() id: 444, sql: "DELETE FROM pet_aura WHERE guid = ?" Table 'char1.pet_aura' doesn't exist In mysql_stmt_prepare() id: 445, sql: "DELETE FROM pet_spell_cooldown WHERE guid = ?" Table 'char1.pet_spell_cooldown' doesn't exist In mysql_stmt_prepare() id: 446, sql: "INSERT INTO pet_spell_cooldown (guid, spell, time) VALUES (?, ?, ?)" Table 'char1.pet_spell_cooldown' doesn't exist In mysql_stmt_prepare() id: 448, sql: "INSERT INTO pet_spell (guid, spell, active) VALUES (?, ?, ?)" Table 'char1.pet_spell' doesn't exist In mysql_stmt_prepare() id: 449, sql: "INSERT INTO pet_aura (guid, caster_guid, spell, effect_mask, recalculate_mask, stackcount, amount0, amount1, amount2, base_amount0, base_amount1, base_amount2, maxduration, remaintime, remaincharges) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" Table 'char1.pet_aura' doesn't exist In mysql_stmt_prepare() id: 461, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType FROM character_pet WHERE owner = ? AND id = ?" Table 'char1.character_pet' doesn't exist In mysql_stmt_prepare() id: 462, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType FROM character_pet WHERE owner = ? AND entry = ? AND (slot = ? OR slot > ?)" Table 'char1.character_pet' doesn't exist In mysql_stmt_prepare() id: 463, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType FROM character_pet WHERE owner = ? AND (slot = ? OR slot > ?) " Table 'char1.character_pet' doesn't exist In mysql_stmt_prepare() id: 453, sql: "SELECT id, entry, owner, modelid, level, exp, Reactstate, slot, name, renamed, curhealth, curmana, abdata, savetime, CreatedBySpell, PetType FROM character_pet WHERE owner = ? AND slot = ?" Table 'char1.character_pet' doesn't exist DatabasePool char1 NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to Character database 127.0.0.1;3306;serv;123;char1
в 1 сервере ничего не менял только добавил в Серв\usr\local\mysql-5.5\data char1 и world1
Я надеюсь ты не копированием перенес базы) обычно после копирования лезут ошибки что какие то таблицы не доступны. а дампом залил) p.s запихай скрины под спойлер.
Продажа готовых сборок cataclysm 4.3.4, legion (7.3.5), shadowlands, draginflight. Исправление спеллов, квестов, крашей на любых версиях вов. Цена договорная. Пишите в лс, не дорого.
Сообщение # 4 отредактировано Sergey996 - Пятница, 20.06.2014, 04:18