[Tutorial] Crear un servidor para WoW usando ArcEmu y NCDB [Tutorial]

fersee · 31 Agosto 2008, 14:14 PM

cuando inicio arcemu-world me sale tod esto
09:05 N ObjectMgr: 107 totem spells loaded.
09:05 N ObjectMgr: 54263 waypoints cached.
09:05 N ObjectMgr: 6711 spell skills loaded.
09:05 N ObjectMgr: 43 spell overrides loaded.
09:05 Sql query failed due to [table 'logon.charters' doesn't exist], Query: [SE
LECT * FROM charters]
Sql query failed due to [table 'logon.gm_tickets' doesn't exist], Query: [SELECT
`guid`, `playerGuid`, `name`, `level`, `map`, `posX`, `posY`, `posZ`, `message`
, `timestamp`, `deleted`, `assignedto`, `comment` FROM gm_tickets WHERE deleted=
0]
Sql query failed due to [table 'logon.characters' doesn't exist], Query: [SELECT
MAX(guid) FROM characters]
Sql query failed due to [table 'logon.playeritems' doesn't exist], Query: [SELEC
T MAX(guid) FROM playeritems]
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT MA
X(guid) FROM corpses]
Sql query failed due to [table 'logon.groups' doesn't exist], Query: [SELECT MAX
(group_id) FROM groups]
Sql query failed due to [table 'logon.charters' doesn't exist], Query: [SELECT M
AX(charterId) FROM charters]
Sql query failed due to [table 'logon.guilds' doesn't exist], Query: [SELECT MAX
(guildId) FROM guilds]
Sql query failed due to [table 'logon.gm_tickets' doesn't exist], Query: [SELECT
MAX(guid) FROM gm_tickets]
N ObjectMgr: 1403 vendors loaded.
09:05 N ObjectMgr: HighGuid(CORPSE) = 0
09:05 N ObjectMgr: HighGuid(PLAYER) = 1
09:05 N ObjectMgr: 418 reputation modifiers on reputation_creature_onkill.
09:05 N ObjectMgr: 2 reputation modifiers on reputation_faction_onkill.
09:05 N ObjectMgr: HighGuid(GAMEOBJ) = 2200057
09:05 N ObjectMgr: HighGuid(UNIT) = 4661965
09:05 N ObjectMgr: 23 instance reputation modifiers loaded.
09:05 N ObjectMgr: 226 monster say events loaded.
09:05 N ObjectMgr: HighGuid(ITEM) = 0
09:05 N ObjectMgr: HighGuid(CONTAINER) = 0
09:05 N WeatherMgr: Loaded weather information for 51 zones.
Sql query failed due to [table 'logon.groups' doesn't exist], Query: [SELECT * F
ROM groups]
09:05 N ObjectMgr: 0 groups loaded.
09:05 N ObjectMgr: HighGuid(GROUP) = 1
09:05 N ObjectMgr: HighGuid(CHARTER) = 0
09:05 N ObjectMgr: HighGuid(GUILD) = 0
09:05 N ObjectMgr: HighGuid(TICKET) = 4294967295
Sql query failed due to [table 'logon.arenateams' doesn't exist], Query: [SELECT
* FROM arenateams]
09:05 N ObjectMgr: 954 NPC Gossip TextIds loaded.
09:05 N WordFilter: Loading...
09:05 N WordFilter: Done.

09:05 N World: Database loaded in 7969ms.

Sql query failed due to [table 'logon.instances' doesn't exist], Query: [SELECT
MAX(id) FROM instances]
09:05 N Map: 25200 creatures / 10120 gameobjects on map 1 cached.
09:05 N InstanceMgr: Creating continent Kalimdor.
09:05 N Map: 22394 creatures / 12440 gameobjects on map 0 cached.
09:05 N InstanceMgr: Creating continent Eastern Kingdoms.
09:05 N Map: 9 creatures / 0 gameobjects on map 30 cached.
09:05 N Map: Sql query failed due to [table 'logon.corpses' doesn't exist], Quer
y: [SELECT * FROM corpses WHERE instanceId = 1]
143 creatures / 33 gameobjects on map 33 cached.
09:05 N Map: 90 creatures / 2 gameobjects on map 34 cached.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 2]
09:05 N Map: 211 creatures / 26 gameobjects on map 36 cached.
09:05 N Map: 2 creatures / 0 gameobjects on map 37 cached.
09:05 N Map: 313 creatures / 76 gameobjects on map 43 cached.
09:05 N Map: 206 creatures / 48 gameobjects on map 47 cached.
09:05 N Map: 215 creatures / 25 gameobjects on map 48 cached.
09:05 N Map: 261 creatures / 180 gameobjects on map 70 cached.
09:05 N Map: 356 creatures / 75 gameobjects on map 109 cached.
09:05 N Map: 404 creatures / 89 gameobjects on map 90 cached.
09:05 N Map: 272 creatures / 64 gameobjects on map 129 cached.
09:05 N Map: 329 creatures / 90 gameobjects on map 189 cached.
09:05 N Map: 261 creatures / 55 gameobjects on map 209 cached.
09:05 N Map: 503 creatures / 375 gameobjects on map 229 cached.
09:05 N Map: 1065 creatures / 433 gameobjects on map 230 cached.
09:05 N Map: 5 creatures / 44 gameobjects on map 249 cached.
09:05 N Map: 179 creatures / 2 gameobjects on map 269 cached.
09:05 N Map: 404 creatures / 66 gameobjects on map 289 cached.
09:05 N Map: 675 creatures / 177 gameobjects on map 309 cached.
09:05 N Map: 380 creatures / 164 gameobjects on map 329 cached.
09:05 N Map: 611 creatures / 24 gameobjects on map 349 cached.
09:05 N Map: 22 creatures / 51 gameobjects on map 369 cached.
09:05 N Map: 133 creatures / 12 gameobjects on map 389 cached.
09:05 N Map: 181 creatures / 3 gameobjects on map 409 cached.
09:05 N InstanceMgr: Creating continent Deeprun Tram.
09:05 N Map: 811 creatures / 93 gameobjects on map 429 cached.Sql query failed d
ue to [table 'logon.corpses' doesn't exist], Query: [SELECT * FROM corpses WHERE
instanceId = 3]

09:05 N Map: 25 creatures / 40 gameobjects on map 449 cached.
09:05 N Map: 14 creatures / 8 gameobjects on map 450 cached.
09:05 N InstanceMgr: Creating continent Alliance Military Barracks.
09:05 Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SEL
ECT * FROM corpses WHERE instanceId = 4]
N Map: 7 creatures / 0 gameobjects on map 451 cached.
09:05 N InstanceMgr: Creating continent Development Land.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 5]
09:05 N Map: 306 creatures / 103 gameobjects on map 469 cached.
09:05 N Map: 146 creatures / 0 gameobjects on map 509 cached.
09:05 N Map: 11 creatures / 0 gameobjects on map 529 cached.
09:05 N InstanceMgr: Creating continent Horde Military Barracks.
09:05 N Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [S
ELECT * FROM corpses WHERE instanceId = 6]
Map: 113 creatures / 0 gameobjects on map 531 cached.
09:05 N Map: 25778 creatures / 9768 gameobjects on map 530 cached.
09:05 N Map: 446 creatures / 252 gameobjects on map 532 cached.
09:05 N InstanceMgr: Creating continent Outlands.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 7]
09:05 N Map: 1152 creatures / 142 gameobjects on map 533 cached.
09:05 N Map: 242 creatures / 25 gameobjects on map 534 cached.
09:05 N Map: 95 creatures / 0 gameobjects on map 540 cached.
09:05 N Map: 94 creatures / 27 gameobjects on map 542 cached.
09:05 N Map: 81 creatures / 9 gameobjects on map 543 cached.
09:05 N Map: 28 creatures / 13 gameobjects on map 544 cached.
09:05 N Map: 175 creatures / 14 gameobjects on map 545 cached.
09:05 N Map: 141 creatures / 24 gameobjects on map 546 cached.
09:05 N Map: 157 creatures / 0 gameobjects on map 547 cached.
09:05 N Map: 147 creatures / 25 gameobjects on map 548 cached.
09:05 N Map: 175 creatures / 1 gameobjects on map 550 cached.
09:05 N Map: 60 creatures / 14 gameobjects on map 552 cached.
09:05 N Map: 181 creatures / 5 gameobjects on map 553 cached.
09:05 N Map: 98 creatures / 16 gameobjects on map 554 cached.
09:05 N Map: 151 creatures / 1 gameobjects on map 555 cached.
09:05 N Map: 162 creatures / 15 gameobjects on map 556 cached.
09:05 N Map: 57 creatures / 9 gameobjects on map 557 cached.
09:05 N Map: 146 creatures / 12 gameobjects on map 558 cached.
09:05 N Map: 482 creatures / 166 gameobjects on map 560 cached.
09:05 N Map: 3 creatures / 0 gameobjects on map 562 cached.
09:05 N Map: 576 creatures / 15 gameobjects on map 564 cached.
09:05 N Map: 19 creatures / 2 gameobjects on map 565 cached.
09:05 N Map: 32 creatures / 0 gameobjects on map 566 cached.
09:05 N Map: 141 creatures / 43 gameobjects on map 568 cached.
09:05 N Map: 142 creatures / 0 gameobjects on map 580 cached.
09:05 N Map: 129 creatures / 0 gameobjects on map 585 cached.
09:05 N Map: 0 creatures / 0 gameobjects on map 13 cached.
09:05 N Map: 0 creatures / 0 gameobjects on map 25 cached.
09:05 N InstanceMgr: Creating continent Testing.
09:05 N Map: 0 creatures / 0 gameobjects on map 42 cached.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 8]
09:05 N InstanceMgr: Creating continent Collins Test.
09:05 N Map: Sql query failed due to [table 'logon.corpses' doesn't exist], Quer
y: [SELECT * FROM corpses WHERE instanceId = 9]
0 creatures / 0 gameobjects on map 29 cached.
09:05 N InstanceMgr: Creating continent Scott Test.
09:05 N Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [S
ELECT * FROM corpses WHERE instanceId = 10]
Map: 0 creatures / 0 gameobjects on map 44 cached.
09:05 N InstanceMgr: Creating continent CashTest.
09:05 N Map:Sql query failed due to [table 'logon.corpses' doesn't exist], Query
: [SELECT * FROM corpses WHERE instanceId = 11]
0 creatures / 0 gameobjects on map 35 cached.
09:05 N InstanceMgr: Creating continent <unused> Monastery.
09:05 N Map: 0 creatures / 0 gameobjects on map 169 cached.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 12]
09:05 N Map: 0 creatures / 0 gameobjects on map 489 cached.
09:05 N InstanceMgr: Creating continent EmeraldDream.
09:05 Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SEL
ECT * FROM corpses WHERE instanceId = 13]
N Map: 0 creatures / 0 gameobjects on map 582 cached.
09:05 N Map: 0 creatures / 0 gameobjects on map 584 cached.
09:05 N InstanceMgr: Creating continent Transport: Ruttheran to Auberdine.
09:05 N Map: 0 creatures / 0 gameobjects on map 586 cached.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 14]
09:05 N InstanceMgr: Creating continent Transport: Exodar to Auberdine.
09:05 N Map: 0 creatures / 0 gameobjects on map 587 cached.Sql query failed due
to [table 'logon.corpses' doesn't exist], Query: [SELECT * FROM corpses WHERE in
stanceId = 15]

09:05 N InstanceMgr: Creating continent Transport: Menethil to Theramore.
09:05 N Map: 0 creatures / 0 gameobjects on map 588 cached.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 16]
09:05 N InstanceMgr: Creating continent Transport: Feathermoon Ferry.
09:05 N Map: Sql query failed due to [table 'logon.corpses' doesn't exist], Quer
y: [SELECT * FROM corpses WHERE instanceId = 17]
0 creatures / 0 gameobjects on map 589 cached.
09:05 N InstanceMgr: Creating continent Transport: Orgrimmar to GromGol.
09:05 N MapSql query failed due to [table 'logon.corpses' doesn't exist], Query:
[SELECT * FROM corpses WHERE instanceId = 18]
: 0 creatures / 0 gameobjects on map 590 cached.
09:05 N InstanceMgr: Creating continent Transport: Menethil to Auberdine.
09:05 N Map: 0 creatures / 0 gameobjects on map 591 cached.Sql query failed due
to [table 'logon.corpses' doesn't exist], Query: [SELECT * FROM corpses WHERE in
stanceId = 19]

09:05 N InstanceMgr: Creating continent Transport: GromGol to Undercity.
09:05 N Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [S
ELECT * FROM corpses WHERE instanceId = 20]
Map: 0 creatures / 0 gameobjects on map 593 cached.
09:05 N InstanceMgr: Creating continent Transport: Undercity to Orgrimmar.
09:05 N InstanceMgr: Creating continent Transport: Booty Bay to Ratchet.
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 21]
Sql query failed due to [table 'logon.corpses' doesn't exist], Query: [SELECT *
FROM corpses WHERE instanceId = 22]
09:05 N InstanceMgr: Deleting Expired Instances...
Sql query failed due to [table 'logon.instances' doesn't exist], Query: [DELETE
FROM instances WHERE expiration <= 1220184319]
Sql query failed due to [table 'logon.instances' doesn't exist], Query: [SELECT
* FROM instances]
09:05 N InstanceMgr: Loading 0 saved instances.

09:05 N World: Object size: 368 bytes
09:05 N World: Unit size: 4744 bytes
09:05 N World: Creature size: 6040 bytes
09:05 N World: Player size: 99320 bytes
09:05 N World: GameObject size: 608 bytes
09:05 N World: Processing 28315 spells...
09:05 N World: Starting Transport System...
09:05 N ObjectMgr: Loading Transports...
09:05 N World: Starting Auction System...
09:05 N AuctionMgr: Loading Auction Houses...
Sql query failed due to [table 'logon.auctions' doesn't exist], Query: [SELECT M
AX(auctionId) FROM auctions]
Sql query failed due to [table 'logon.auctions' doesn't exist], Query: [SELECT *
FROM auctions WHERE auctionhouse =7]
09:05 N AuctionHouse: Done 1/3, 33% complete.
Sql query failed due to [table 'logon.auctions' doesn't exist], Query: [SELECT *
FROM auctions WHERE auctionhouse =1]
09:05 N AuctionHouse: Done 2/3, 67% complete.
Sql query failed due to [table 'logon.auctions' doesn't exist], Query: [SELECT *
FROM auctions WHERE auctionhouse =2]
09:05 N AuctionHouse: Done 3/3, 100% complete.
09:05 N World: Backgrounding loot loading...
09:05 N BattlegroundManager: Starting...
09:05 N DayWatcherThread: Started.
Sql query failed due to [table 'logon.mailbox_insert_queue' doesn't exist], Quer
y: [SELECT * FROM mailbox_insert_queue]
09:05 N Network: Starting subsystem...
Sql query failed due to [table 'logon.server_settings' doesn't exist], Query: [S
ELECT setting_value FROM server_settings WHERE setting_id = "last_arena_update_t
ime"]
09:05 N DayWatcherThread: Initializing Arena Updates to zero.
Sql query failed due to [table 'logon.server_settings' doesn't exist], Query: [S
ELECT setting_value FROM server_settings WHERE setting_id = "last_daily_update_t
ime"]
09:05 N DayWatcherThread: Initializing Daily Updates to zero.
09:05 N DayWatcherThread: Running Weekly Arena Point Maintenance...
Sql query failed due to [table 'logon.characters' doesn't exist], Query: [SELECT
guid, arenaPoints FROM characters]
Sql query failed due to [table 'logon.server_settings' doesn't exist], Query: [R
EPLACE INTO server_settings VALUES("last_arena_update_time", 1220184319)]
Sql query failed due to [table 'logon.server_settings' doesn't exist], Query: [R
EPLACE INTO server_settings VALUES("last_daily_update_time", 0)]
IOCP: Spawning 1 worker threads.
09:05 N Server: Loading External Script Libraries...

ExtraScripts.dll : 0x0FF60000 : version mismatch!
GossipScripts.dll : 0x0FF60000 : v0.706 : loaded.
InstanceScripts.dll : 0x0FF90000 : v0.706 : loaded.
LUAScripting.dll : 0x18C30000 : version mismatch!
MoonGossipScripts.dll : 0x0FFC0000 : version mismatch!
MoonInstanceScripts.dll : 0x18C30000 : version mismatch!
MoonMiscScripts.dll : 0x0F5E0000 : version mismatch!
MoonQuestScripts.dll : 0x0FFC0000 : version mismatch!
MoonSpellHandlers.dll : 0x0F5E0000 : version mismatch!
ServerStatusPlugin.dll : 0x18C30000 : version mismatch!
SpellHandlers.dll : 0x0F5E0000 : v0.706 : loaded.

09:05 N Server: Loaded 3 external libraries.

09:05 N Server: Loading optional scripting engines...
09:05 N Server: Done loading script engines...
09:05 N Server: Ready for connections. Startup time: 27718ms

09:05 N RemoteConsole: Starting...
09:05 N LogonCommClient: Loading forced permission strings...
Sql query failed due to [table 'logon.account_forced_permissions' doesn't exist]
, Query: [SELECT * FROM account_forced_permissions]
09:05 N LogonCommClient: Attempting to connect to logon server...
09:05 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
09:05 N LogonCommClient: Authenticating...
09:05 N LogonCommClient: Authentication succeeded.
09:05 N LogonCommClient: Registering Realms...
09:05 N LogonCommClient: Realm `tormenta de hielo` registered as realm 2.
Sql query failed due to [table 'logon.characters' doesn't exist], Query: [SELECT
acct FROM characters]
09:05 N LogonCommClient: Logonserver latency is 0ms.
Sql query failed due to [table 'logon.characters' doesn't exist], Query: [SELECT
guid, level, race, class, gender, bytes, bytes2, name, positionX, positionY, po
sitionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_pending, pl
ayer_flags, guild_data.guildid FROM characters LEFT JOIN guild_data ON character
s.guid = guild_data.playerid WHERE acct=1 ORDER BY guid LIMIT 10]
Sql query failed due to [table 'logon.characters' doesn't exist], Query: [SELECT
guid, level, race, class, gender, bytes, bytes2, name, positionX, positionY, po
sitionZ, mapId, zoneId, banned, restState, deathstate, forced_rename_pending, pl
ayer_flags, guild_data.guildid FROM characters LEFT JOIN guild_data ON character
s.guid = guild_data.playerid WHERE acct=1 ORDER BY guid LIMIT 10]
Sql query failed due to [table 'logon.server_settings' doesn't exist], Query: [R
EPLACE INTO server_settings VALUES("last_arena_update_time", 1220184319)]
Sql query failed due to [table 'logon.server_settings' doesn't exist], Query: [R
EPLACE INTO server_settings VALUES("last_daily_update_time", 0)]

Ariath · 31 Agosto 2008, 14:41 PM

Dagosu, acabo de probar y parece que ahora mismo filebeam está fuera de servicio o algo. Luego después de comer, sobre las 4 o por ahí, subiré un mirror a Mediafire, a ver si de paso los promuevo para que se usen para las descargas XD

Mmm... fersee, yo de ti volvería a montar lo de las bases de datos desde 0, o bien, revisaría los configs.

Los errores que te salen, te está diciendo que las tablas que deberían estar en la base de datos logon no existen, o no las encuentra.

Eso puede tener 2 causas, o que hayas indicado en los archivos de configuración el nombre de la base de datos logon equivocado, o bien, que no hayas creado las bases de datos bien.

Los mensajes de "version mismatch" en la parte de las DLL, vienen a significar que hay algún lio entre las versiones de las DLL que se están cargando y la versión del propio emulador. Yo también lo que pasa es que no suelo cargar tantas, solo cargo las 3 o 5 principales.

Salu2

Rafa.net · 31 Agosto 2008, 14:59 PM

hola de nuevo, e visto que ay gente que pregunta sobre las ID y de mas las teneis todas en wow head, y para que te lleve localizaciones como instancias y demas solo teneis que poner por ejemplo..
.recall port blacktemple y te lleva a templo oscuro.
y si pones .recall list te da todas las localizaciones del juego.
Saludos gente.
Ariath te lo curras al maximo

Ariath · 31 Agosto 2008, 16:16 PM

Actualizado el primer post con un mirror para el tutorial en Mediafire, para quien tenga problemas con Filebeam.

Salu2

fersee · 31 Agosto 2008, 17:55 PM

hola ya lo cree de nuevo ahora se me queda en intercamvbiando datos pero en arcemu-world me aparece esto

GNU Affero General Public License for more details.

The key combination <Ctrl-C> will safely shut down the server at any time.

12:47 S Rnd: Initialized Random Number Generators.
12:47 D ThreadPool: Startup, launched 5 threads.
12:47 D ThreadPool: Thread 3020 entered the free pool.
12:47 D ThreadPool: Thread 3660 entered the free pool.
12:47 D ThreadPool: Thread 3240 entered the free pool.
12:47 D ThreadPool: Thread 452 entered the free pool.
12:47 D ThreadPool: Thread 3816 entered the free pool.
12:47 N Config: Loading Config Files...

12:47 S Config: >> configs/arcemu-world.conf
12:47 S Config: >> configs/arcemu-optional.conf
12:47 S Config: >> configs/arcemu-realms.conf
12:47 N MySQLDatabase: Connecting to `localhost`, database `world`...
12:47 D ThreadPool: Thread 3020 left the thread pool.
12:47 D ThreadPool: Thread 3020 is now executing task at 0x025292A8.
12:47 D ThreadPool: Thread 3660 left the thread pool.
12:47 D ThreadPool: Thread 3660 is now executing task at 0x02529420.
12:47 N MySQLDatabase: Connecting to `localhost`, database `character`...
12:47 D ThreadPool: Thread 3240 left the thread pool.
12:47 D ThreadPool: Thread 3240 is now executing task at 0x02529450.
12:47 D ThreadPool: Thread 452 left the thread pool.
12:47 D ThreadPool: Thread 452 is now executing task at 0x02529690.

Announce colors initialized.

12:47 N World: Loading DBC files...
12:47 N DBC: Loading DBC/ItemSet.dbc.
12:47 N DBC: Loading DBC/Lock.dbc.
12:47 N DBC: Loading DBC/EmotesText.dbc.
12:47 N DBC: Loading DBC/SkillLineAbility.dbc.
12:47 N DBC: Loading DBC/SpellItemEnchantment.dbc.
12:47 N DBC: Loading DBC/GemProperties.dbc.
12:47 N DBC: Loading DBC/SkillLine.dbc.
12:47 N DBC: Loading DBC/Spell.dbc.
12:47 N DBC: Loading DBC/ItemExtendedCost.dbc.
12:47 N DBC: Loading DBC/Talent.dbc.
12:47 N DBC: Loading DBC/TalentTab.dbc.
12:47 N DBC: Loading DBC/SpellCastTimes.dbc.
12:47 N DBC: Loading DBC/SpellRadius.dbc.
12:47 N DBC: Loading DBC/SpellRange.dbc.
12:47 N DBC: Loading DBC/SpellDuration.dbc.
12:47 N DBC: Loading DBC/ItemRandomProperties.dbc.
12:47 N DBC: Loading DBC/AreaTable.dbc.
12:47 N DBC: Loading DBC/FactionTemplate.dbc.
12:47 N DBC: Loading DBC/Faction.dbc.
12:47 N DBC: Loading DBC/TaxiNodes.dbc.
12:47 N DBC: Loading DBC/TaxiPath.dbc.
12:47 N DBC: Loading DBC/TaxiPathNode.dbc.
12:47 N DBC: Loading DBC/CreatureSpellData.dbc.
12:47 N DBC: Loading DBC/CreatureFamily.dbc.
12:47 N DBC: Loading DBC/ChrRaces.dbc.
12:47 N DBC: Loading DBC/ChrClasses.dbc.
12:47 N DBC: Loading DBC/Map.dbc.
12:47 N DBC: Loading DBC/AuctionHouse.dbc.
12:47 N DBC: Loading DBC/ItemRandomSuffix.dbc.
12:47 N DBC: Loading DBC/gtCombatRatings.dbc.
12:47 N DBC: Loading DBC/ChatChannels.dbc.
12:47 N DBC: Loading DBC/DurabilityQuality.dbc.
12:47 N DBC: Loading DBC/DurabilityCosts.dbc.
12:47 N DBC: Loading DBC/BankBagSlotPrices.dbc.
12:47 N DBC: Loading DBC/StableSlotPrices.dbc.
12:47 N DBC: Loading DBC/gtChanceToMeleeCrit.dbc.
12:47 N DBC: Loading DBC/gtChanceToMeleeCritBase.dbc.
12:47 N DBC: Loading DBC/gtChanceToSpellCrit.dbc.
12:47 N DBC: Loading DBC/gtChanceToSpellCritBase.dbc.
12:47 N DBC: Loading DBC/gtRegenMPPerSpt.dbc.
12:47 N DBC: Loading DBC/gtOCTRegenMP.dbc.
12:47 N DBC: Loading DBC/gtRegenHPPerSpt.dbc.
12:47 N DBC: Loading DBC/gtOCTRegenHP.dbc.
12:47 N DBC: Loading DBC/AreaTrigger.dbc.

12:47 N World: Beginning parallel server startup with 2 threads.

Sql query failed due to [table 'world.creature_names' doesn't exist], Query: [SE
LECT * FROM creature_names]
Sql query failed due to [table 'world.gameobject_names' doesn't exist], Query: [
SELECT * FROM gameobject_names]
Sql query failed due to [table 'world.creature_proto' doesn't exist], Query: [SE
LECT * FROM creature_proto]
Sql query failed due to [table 'world.areatriggers' doesn't exist], Query: [SELE
CT * FROM areatriggers]
Sql query failed due to [table 'world.itempages' doesn't exist], Query: [SELECT
* FROM itempages]
Sql query failed due to [table 'world.quests' doesn't exist], Query: [SELECT * F
ROM quests]
Sql query failed due to [table 'world.graveyards' doesn't exist], Query: [SELECT
* FROM graveyards]
Sql query failed due to [table 'world.teleport_coords' doesn't exist], Query: [S
ELECT * FROM teleport_coords]
Sql query failed due to [table 'world.fishing' doesn't exist], Query: [SELECT *
FROM fishing]
Sql query failed due to [table 'world.npc_text' doesn't exist], Query: [SELECT *
FROM npc_text]
Sql query failed due to [table 'world.worldmap_info' doesn't exist], Query: [SEL
ECT MAX(entry) FROM worldmap_info]
Sql query failed due to [table 'world.worldmap_info' doesn't exist], Query: [SEL
ECT * FROM worldmap_info]
Sql query failed due to [table 'world.zoneguards' doesn't exist], Query: [SELECT
* FROM zoneguards]
Sql query failed due to [table 'world.unit_display_sizes' doesn't exist], Query:
[SELECT * FROM unit_display_sizes]
Sql query failed due to [table 'world.items' doesn't exist], Query: [SELECT MAX(
entry) FROM items]
Sql query failed due to [table 'world.items' doesn't exist], Query: [SELECT * FR
OM items]
12:47 N ObjectMgr: 0 players loaded.
12:47 Sql query failed due to [table 'world.playercreateinfo' doesn't exist], Qu
ery: [SELECT * FROM playercreateinfo]
N ObjectMgr: 0 guilds loaded.
Sql query failed due to [table 'world.instance_bosses' doesn't exist], Query: [S
ELECT `mapid`, `spawnid`, `trash`, `trash_respawn_override` FROM `instance_bosse
s`]
12:47 N ObjectMgr: Sql query failed due to [table 'world.spelloverride' doesn't
exist], Query: [SELECT DISTINCT overrideId FROM spelloverride]
Sql query failed due to [table 'world.totemspells' doesn't exist], Query: [SELEC
T * FROM totemspells]
Sql query failed due to [table 'world.trainer_defs' doesn't exist], Query: [SELE
CT * FROM trainer_defs]
Sql query failed due to [table 'world.spell_disable' doesn't exist], Query: [SEL
ECT * FROM spell_disable]
6711 spell skills loaded.
12:47 N ObjectMgr: 0 disabled spells.
Sql query failed due to [table 'world.creature_timed_emotes' doesn't exist], Que
ry: [SELECT * FROM creature_timed_emotes order by `rowid` asc]
Sql query failed due to [table 'world.creature_waypoints' doesn't exist], Query:
[SELECT * FROM creature_waypoints]
Sql query failed due to [table 'world.vendors' doesn't exist], Query: [SELECT *
FROM vendors]
12:47 N ObjectMgrSql query failed due to [table 'world.ai_threattospellid' doesn
't exist], Query: [SELECT * FROM ai_threattospellid]
Sql query failed due to [table 'world.spellfixes' doesn't exist], Query: [SELECT
* FROM spellfixes]
Sql query failed due to [table 'world.spell_proc' doesn't exist], Query: [SELECT
* FROM spell_proc]
Sql query failed due to [table 'world.spell_effects_override' doesn't exist], Qu
ery: [SELECT * FROM spell_effects_override]
Sql query failed due to [table 'world.petdefaultspells' doesn't exist], Query: [
SELECT * FROM petdefaultspells]
: 0 vendors loaded.
Sql query failed due to [table 'world.clientaddons' doesn't exist], Query: [SELE
CT * FROM clientaddons]
Query failed: SELECT * FROM clientaddons
Sql query failed due to [table 'world.reputation_creature_onkill' doesn't exist]
, Query: [SELECT * FROM reputation_creature_onkill]
12:47 N ObjectMgr: 0 reputation modifiers on reputation_creature_onkill.
Sql query failed due to [table 'world.reputation_faction_onkill' doesn't exist],
Query: [SELECT * FROM reputation_faction_onkill]
12:47 N ObjectMgr: 0 reputation modifiers on reputation_faction_onkill.
Sql query failed due to [table 'world.reputation_instance_onkill' doesn't exist]
, Query: [SELECT * FROM reputation_instance_onkill]
Sql query failed due to [table 'world.npc_monstersay' doesn't exist], Query: [SE
LECT * FROM npc_monstersay]
Sql query failed due to [table 'world.weather' doesn't exist], Query: [SELECT zo
neId,high_chance,high_type,med_chance,med_type,low_chance,low_type FROM weather]

Sql query failed due to [table 'world.creature_spawns' doesn't exist], Query: [S
ELECT MAX(id) FROM creature_spawns]
Sql query failed due to [table 'world.gameobject_spawns' doesn't exist], Query:
[SELECT MAX(id) FROM gameobject_spawns]
12:47 N ObjectMgr: 0 groups loaded.
Sql query failed due to [table 'world.ai_agents' doesn't exist], Query: [SELECT
* FROM ai_agents]
Sql query failed due to [table 'world.itempetfood' doesn't exist], Query: [SELEC
T * FROM itempetfood ORDER BY entry]
12:47 N ObjectMgr: HighGuid(CORPSE) = 0
12:47 N ObjectMgr: HighGuid(PLAYER) = 0
12:47 N ObjectMgr: HighGuid(GAMEOBJ) = 0
12:47 N ObjectMgr: HighGuid(UNIT) = 0
12:47 N ObjectMgr: HighGuid(ITEM) = 0
12:47 N ObjectMgr: HighGuid(CONTAINER) = 0
12:47 N ObjectMgr: HighGuid(GROUP) = 0
12:47 N ObjectMgr: HighGuid(CHARTER) = 0
12:47 N ObjectMgr: HighGuid(GUILD) = 0
12:47 N ObjectMgr: HighGuid(TICKET) = 0
Sql query failed due to [table 'world.creature_quest_starter' doesn't exist], Qu
ery: [SELECT * FROM creature_quest_starter]
Sql query failed due to [table 'world.creature_quest_finisher' doesn't exist], Q
uery: [SELECT * FROM creature_quest_finisher]
Sql query failed due to [table 'world.gameobject_quest_starter' doesn't exist],
Query: [SELECT * FROM gameobject_quest_starter]
Sql query failed due to [table 'world.gameobject_quest_finisher' doesn't exist],
Query: [SELECT * FROM gameobject_quest_finisher]
Sql query failed due to [table 'world.gameobject_quest_item_binding' doesn't exi
st], Query: [SELECT * FROM gameobject_quest_item_binding]
Sql query failed due to [table 'world.gameobject_quest_pickup_binding' doesn't e
xist], Query: [SELECT * FROM gameobject_quest_pickup_binding]
Sql query failed due to [table 'world.npc_gossip_textid' doesn't exist], Query:
[SELECT * FROM npc_gossip_textid]
12:47 N ObjectMgr: 0 NPC Gossip TextIds loaded.
Sql query failed due to [table 'world.item_quest_association' doesn't exist], Qu
ery: [SELECT * FROM item_quest_association]
Sql query failed due to [table 'world.professiondiscoveries' doesn't exist], Que
ry: [SELECT * from professiondiscoveries]
Sql query failed due to [table 'world.creature_names_localized' doesn't exist],
Query: [SELECT DISTINCT language_code FROM creature_names_localized]
Sql query failed due to [table 'world.gameobject_names_localized' doesn't exist]
, Query: [SELECT DISTINCT language_code FROM gameobject_names_localized]
Sql query failed due to [table 'world.items_localized' doesn't exist], Query: [S
ELECT DISTINCT language_code FROM items_localized]
Sql query failed due to [table 'world.quests_localized' doesn't exist], Query: [
SELECT DISTINCT language_code FROM quests_localized]
Sql query failed due to [table 'world.npc_text_localized' doesn't exist], Query:
[SELECT DISTINCT language_code FROM npc_text_localized]
Sql query failed due to [table 'world.itempages_localized' doesn't exist], Query
: [SELECT DISTINCT language_code FROM itempages_localized]
Sql query failed due to [table 'world.command_overrides' doesn't exist], Query:
[SELECT * FROM command_overrides]
12:47 N WordFilter: Loading...
Sql query failed due to [table 'world.wordfilter_character_names' doesn't exist]
, Query: [SELECT * FROM wordfilter_character_names]
Sql query failed due to [table 'world.wordfilter_chat' doesn't exist], Query: [S
ELECT * FROM wordfilter_chat]
12:47 N WordFilter: Done.

12:47 N World: Database loaded in 2860ms.

Sql query failed due to [table 'world.creature_formations' doesn't exist], Query
: [SELECT * FROM creature_formations]
Sql query failed due to [table 'world.creature_spawns' doesn't exist], Query: [S
ELECT DISTINCT Map FROM creature_spawns]
12:47 N InstanceMgr: Deleting Expired Instances...
12:47 N InstanceMgr: Loading 0 saved instances.

12:47 N World: Object size: 368 bytes
12:47 N World: Unit size: 4744 bytes
12:47 N World: Creature size: 6040 bytes
12:47 N World: Player size: 99320 bytes
12:47 N World: GameObject size: 608 bytes
12:47 N World: Processing 28315 spells...
Sql query failed due to [table 'world.spell_coef_override' doesn't exist], Query
: [SELECT * FROM spell_coef_override]
12:47 N World: Starting Transport System...
12:47 N ObjectMgr: Loading Transports...
Sql query failed due to [table 'world.transport_data' doesn't exist], Query: [SE
LECT * FROM transport_data]
12:47 N World: Starting Auction System...
12:47 N AuctionMgr: Loading Auction Houses...
Sql query failed due to [table 'world.auctionhouse' doesn't exist], Query: [SELE
CT DISTINCT `group` FROM auctionhouse]
Sql query failed due to [table 'world.auctionhouse' doesn't exist], Query: [SELE
CT creature_entry, `group` FROM auctionhouse]
12:47 N World: Backgrounding loot loading...
12:47 N BattlegroundManager: Starting...
12:47 Sql query failed due to [table 'world.item_randomprop_groups' doesn't exis
t], Query: [SELECT * FROM item_randomprop_groups]
N Network: Starting subsystem...
12:47 N DayWatcherThread: Started.
IOCP: Spawning 1 worker threads.
12:47 N Server: Loading External Script Libraries...

Sql query failed due to [table 'world.item_randomsuffix_groups' doesn't exist],
Query: [SELECT * FROM item_randomsuffix_groups]
12:47 N DayWatcherThread:Sql query failed due to [table 'world.creatureloot' doe
sn't exist], Query: [SELECT * FROM creatureloot ORDER BY entryid ASC]
Sql query failed due to [table 'world.objectloot' doesn't exist], Query: [SELECT
* FROM objectloot ORDER BY entryid ASC]
Sql query failed due to [table 'world.skinningloot' doesn't exist], Query: [SELE
CT * FROM skinningloot ORDER BY entryid ASC]
Initializing Arena Updates to zero.
12:47 N DayWatcherThread: Initializing Daily Updates to zero.
12:47 N DayWatcherThread: Running Weekly Arena Point Maintenance...
Sql query failed due to [table 'world.fishingloot' doesn't exist], Query: [SELEC
T * FROM fishingloot ORDER BY entryid ASC]
Sql query failed due to [table 'world.itemloot' doesn't exist], Query: [SELECT *
FROM itemloot ORDER BY entryid ASC]
Sql query failed due to [table 'world.prospectingloot' doesn't exist], Query: [S
ELECT * FROM prospectingloot ORDER BY entryid ASC]
Sql query failed due to [table 'world.disenchantingloot' doesn't exist], Query:
[SELECT * FROM disenchantingloot ORDER BY entryid ASC]
Sql query failed due to [table 'world.pickpocketingloot' doesn't exist], Query:
[SELECT * FROM pickpocketingloot ORDER BY entryid ASC]
GossipScripts.dll : 0x05370000 : v0.706 : loaded.
InstanceScripts.dll : 0x053B0000 : v0.706 : loaded.
LUAScripting.dll : 0x053F0000 : v0.706 : delayed load.
ServerStatusPlugin.dll : 0x05490000 : v0.706 : loaded.
SpellHandlers.dll : 0x05540000 : v0.706 : loaded.

12:47 N Server: Loaded 5 external libraries.

12:47 N Server: Loading optional scripting engines...
12:47 N Server: Done loading script engines...
12:47 N Server: Ready for connections. Startup time: 4062ms

12:47 N RemoteConsole: Starting...
12:47 N LogonCommClient: Loading forced permission strings...
12:47 N LogonCommClient: Attempting to connect to logon server...
12:47 N LogonCommClient: Connecting to logonserver on `127.0.0.1:8093`...
12:47 N LogonCommClient: Authenticating...
12:47 N LogonCommClient: Authentication succeeded.
12:47 N LogonCommClient: Registering Realms...
12:47 N LogonCommClient: Realm `TORMENTA DE HIELO Test Server` registered as rea
lm 1.
12:47 N LogonCommClient: Logonserver latency is 0ms.

Ariath · 31 Agosto 2008, 18:31 PM

Juas, pues ahora te pasa lo mismo exactamente pero con la base de datos World ...

Prueba a borrar la base de datos entera (World, Character y Logon), y vuelve a importarlo todo.

Recuerda: Crea la BD (base de datos) Character, e importa el fichero con la estructura. Crea la BD logon e importas su estructura. Y por ultimo, ejecuta el tool.bat de WhyDB (asegurandote antes de que está correctamente editado), pulsa i para importar la BD World y cuando te haga una pregunta en inglés y te de a elegir entre Yes o No, elige lo segundo.

Con eso ya deberías tener de nuevo creadas las bases de datos.

Salu2

fersee · 31 Agosto 2008, 18:40 PM

no podrias subir todos los archivos de wowservers en un archivo win rar por favor

fersee · 31 Agosto 2008, 19:15 PM

tan cerca pero no lo logre se me queda en intercambiando datos...

como puedo solucionarlo

Ariath · 31 Agosto 2008, 20:29 PM

Estoy actualizando mi servidor, que lo tenía sin tocar desde hace algún tiempo, para ver si me ocurren los problemas que teneis algunos, como el no poder entrar a las instancias.

Salu2

P.D: Fersee, no recuerdo si habrás puesto los configs ya alguna vez en el foro, de todas formas, ponlos si no es es molestia, a ver si desentraño el enigma de los datos intercambiandose...

P.D 2: Vale, resuelto el tema de las instancias, o eso creo. Me he fijado en que, de las 3 instancias que he probado (Minas de la muerte, Las mazmorras y Karazhan), sólamente me ha salido el mensaje de que tal mazmorra no está disponible en modo normal en la tercera. Da la casualidad, de que es una mazmorra de banda, por lo cual solo se puede entrar en banda... o al menos en teoría.

Y digo en teoría, por que hay un comando muy simple de GM para ahorrarnos ese inconveniente y, por tanto, poder pasear por cualquier mazmorra a nuestra bola.

El comando en cuestión es .cheat triggerpass . Lo que hace este comando es simple de suponer, permite que te saltes las comprobaciones que se realizan, por ejemplo, para saber si estás en banda al entrar en una mazmorra de ese tipo.

Y, si te quieres pasear por la mazmorra, sin que los bichos o mobs, se te estén tirando al cuello todo el rato, usar el comando .invisible , que, como su nombre indica, nos permitirá pasar inadvertidos entre los bichos.

Raúl DJ · 31 Agosto 2008, 22:40 PM

Cita de: Ariath en 31 Agosto 2008, 20:29 PM
P.D 2: Vale, resuelto el tema de las instancias, o eso creo. Me he fijado en que, de las 3 instancias que he probado (Minas de la muerte, Las mazmorras y Karazhan), sólamente me ha salido el mensaje de que tal mazmorra no está disponible en modo normal en la tercera. Da la casualidad, de que es una mazmorra de banda, por lo cual solo se puede entrar en banda... o al menos en teoría.

Y digo en teoría, por que hay un comando muy simple de GM para ahorrarnos ese inconveniente y, por tanto, poder pasear por cualquier mazmorra a nuestra bola.

El comando en cuestión es .cheat triggerpass . Lo que hace este comando es simple de suponer, permite que te saltes las comprobaciones que se realizan, por ejemplo, para saber si estás en banda al entrar en una mazmorra de ese tipo.

Y, si te quieres pasear por la mazmorra, sin que los bichos o mobs, se te estén tirando al cuello todo el rato, usar el comando .invisible , que, como su nombre indica, nos permitirá pasar inadvertidos entre los bichos.

Ajá, se probará...