using peqdb_rev1549.sql with EQEmuLoginServer
Is the EQEmuLoginServer and EQEmu-Rev1535.zip you download from http://code.google.com/p/projecteqemu/downloads/list compatible with peqdb_rev1549.sql (which from memory i got by following the wiki) or should i dump that database and use another one (but i can't see another to use?)
I am starting again with a clean system, when i sourced the db it didn't give me any errors and i'm getting up to the point of creating a new character with my Sof client. I'm just worried about the log below; it looks like the items are wrong for some reason. [Debug] Starting Log: logs/eqemu_debug_world_2204.log [Debug] [WORLD__INIT] Loading server configuration.. [Debug] [WORLD__INIT] Log settings loaded from log.ini [Debug] [WORLD__INIT] CURRENT_WORLD_VERSION:EQEmulator 0.8.0 [Debug] [WORLD__INIT] Added loginserver 127.0.0.1:5998 [Debug] [WORLD__INIT] Connecting to MySQL... [Status] Starting Log: logs/eqemu_world_2204.log [Status] Using database 'peq' at 127.0.0.1:3306 [Debug] [WORLD__INIT] HTTP world service disabled. [Debug] [WORLD__INIT] Loading variables.. [Debug] [WORLD__INIT] Loading zones.. [Debug] [WORLD__INIT] Clearing groups.. [Debug] [WORLD__INIT] Clearing raids.. [Debug] [WORLD__INIT] Loading items.. [Status] EMuShareMem loaded [Status] Loading items from database: count=83375 [Error] Starting Log: logs/eqemu_error_world_2204.log [Error] DBLoadItems query 'select source,`itemclass`,`name`,`lore`,`idfile`,`id` ,`weight`,`norent`,`nodrop`,`size`,`slots`,`price` ,`icon`,`UNK012`,`UNK013`,`ben efitflag`,`tradeskills`,`cr`,`dr`,`pr`,`mr`,`fr`,` astr`,`asta`,`aagi`,`adex`,`ac ha`,`aint`,`awis`,`hp`,`mana`,`ac`,`deity`,`skillm odvalue`,`UNK033`,`skillmodtyp e`,`banedmgrace`,`banedmgamt`,`banedmgbody`,`magic `,`casttime_`,`reqlevel`,`bard type`,`bardvalue`,`light`,`delay`,`reclevel`,`recs kill`,`elemdmgtype`,`elemdmgam t`,`range`,`damage`,`color`,`classes`,`races`,`UNK 054`,`maxcharges`,`itemtype`,` material`,`sellrate`,`UNK059`,`casttime`,`UNK061`, `procrate`,`combateffects`,`sh ielding`,`stunresist`,`strikethrough`,`extradmgski ll`,`extradmgamt`,`spellshield `,`avoidance`,`accuracy`,`charmfileid`,`factionmod 1`,`factionmod2`,`factionmod3` ,`factionmod4`,`factionamt1`,`factionamt2`,`factio namt3`,`factionamt4`,`charmfil e`,`augtype`,`augslot1type`,`augslot1visible`,`aug slot2type`,`augslot2visible`,` augslot3type`,`augslot3visible`,`augslot4type`,`au gslot4visible`,`augslot5type`, `augslot5visible`,`ldontheme`,`ldonprice`,`ldonsol d`,`bagtype`,`bagslots`,`bagsi ze`,`bagwr`,`book`,`booktype`,`filename`,`banedmgr aceamt`,`augrestrict`,`loregro up`,`pendingloreflag`,`artifactflag`,`summonedflag `,`favor`,`fvnodrop`,`endur`,` dotshielding`,`attack`,`regen`,`manaregen`,`endura nceregen`,`haste`,`damageshiel d`,`recastdelay`,`recasttype`,`guildfavor`,`augdis tiller`,`UNK123`,`UNK124`,`att uneable`,`nopet`,`UNK127`,`pointtype`,`potionbelt` ,`potionbeltslots`,`stacksize` ,`notransfer`,`stackable`,`UNK134`,`clickeffect`,` clicktype`,`clicklevel`,`click level2`,`proceffect`,`proctype`,`proclevel`,`procl evel2`,`worneffect`,`worntype` ,`wornlevel`,`wornlevel2`,`focuseffect`,`focustype `,`focuslevel`,`focuslevel2`,` scrolleffect`,`scrolltype`,`scrolllevel`,`scrollle vel2`,`svcorruption`,`purity`, `backstabdmg`,`dsmitigation`,`heroic_str`,`heroic_ int`,`heroic_wis`,`heroic_agi` ,`heroic_dex`,`heroic_sta`,`heroic_cha`,`heroic_mr `,`heroic_fr`,`heroic_cr`,`her oic_dr`,`heroic_pr`,`heroic_svcorrup`,`healamt`,`s pelldmg`,updated from items or der by id', #1054: Unknown column 'UNK061' in 'field list' [Error] If you got boat loads of errors, make sure you sourced all sql updates! Error: EMuShareMem: DLLLoadItems: !cbDBLoadItems [Debug] [WORLD__INIT_ERR] Error: Could not load item data. But ignoring [Debug] [WORLD__INIT] Loading guilds.. [Debug] [WORLD__INIT] Loaded default rule set 'default' [Debug] [WORLD__INIT] Clearing temporary merchant lists.. [Debug] [WORLD__INIT] Loading EQ time of day.. [Error] Could not load EQTime file eqtime.cfg [Debug] [WORLD__INIT_ERR] Unable to load eqtime.cfg [Debug] [WORLD__INIT] Loading launcher list.. [Debug] [WORLD__INIT] Reboot zone modes ON [Debug] [WORLD__INIT] Deleted 0 stale player corpses from database [Debug] [WORLD__INIT] Deleted 0 stale player backups from database [Debug] [WORLD__INIT] Loading adventures... [Debug] [WORLD__INIT] Purging expired instances [Debug] [WORLD__INIT] Zone (TCP) listener started. [Debug] [WORLD__INIT] Client (UDP) listener started. [Debug] [NET__IDENTIFY] Registered patch 6.2 [Debug] [NET__IDENTIFY] Registered patch Titanium [Debug] [NET__IDENTIFY] Registered patch SoF [Debug] [NET__IDENTIFY] Registered patch SoD [Debug] [NET__IDENTIFY] Registered patch Live [Debug] [WORLD__LS] Connecting to login server: 127.0.0.1:5998 [Debug] [WORLD__LS] Connected to Loginserver: 127.0.0.1:5998 [Debug] [WORLD__ZONE] New TCP connection from 127.0.0.1:1132 [Debug] [WORLD__CONSOLE] New launcher from 127.0.0.1:1132 [Debug] [WORLD__LAUNCH] Adding pending launcher 1 [Debug] [WORLD__LAUNCH] Launcher Identified itself as 'zone'. Loading zone list. [Debug] [WORLD__LAUNCH] Removing pending launcher 1. Adding zone to active list. [Debug] [WORLD__LAUNCH] zone: dynamic_01 reported state STARTED (1 starts) [Debug] [WORLD__LAUNCH] zone: dynamic_02 reported state STARTED (1 starts) [Debug] [WORLD__LAUNCH] zone: dynamic_03 reported state STARTED (1 starts) [Debug] [WORLD__LAUNCH] zone: dynamic_04 reported state STARTED (1 starts) [Debug] [WORLD__LAUNCH] zone: dynamic_05 reported state STARTED (1 starts) |
|
Not Found
The requested URL /p/projecteqdb/downloads/detail?name=peqdatabase-Rev1535.zip was not found on this server. |
maybe it was removed accidentally or someone thought the EQEmu-Rev you download is more recent than it is?
|
Ah, you're right. He deletes the zip files. Looks like you're better off compiling your own then.
|
ah no!! I couldn't get it working even this far when i did that :(
|
Well, its either that or modify your database to revert 1542 and 1548
|
(*sobs quietly*) but when i built my own, they wouldn't even talk to each other! (*parp*). I'm using the same xml and ini files as before (ok, i changed the world name) but back then i was getting this http://www.eqemulator.org/forums/showthread.php?t=31529
I don't suppose you can post a working build that you know works with that db? |
he said redundantly, ah well, better get sleep, 3.13 am
|
there are some pre-packed binaries and DB's floating around. AX Classic come to mind. You may want to see if that has what your looking for.
|
My understanding of the axclassic is that it doesn't support that db, and that the db for axclassic is focused on classic zones only, but if i can't get this sorted out soon i'll have to use that anyway. I'd love to use the current peq db, the changes sound very exciting. I'll have another go with the files i compiled before.
|
Compiling your binaries isn't too bad and we have a decent guide for it here:
http://www.eqemulator.net/wiki/wikka.php?wakka=VS2008 |
I followed that guide before and found the executables weren't connecting to the database. At the time i thought it must be my ini or xml files, but they were working with the downloaded binaries fine.
Using the compiled binaries, i get[Debug] [06.28.10 - 19:10:48] Logging System Init. [Debug] [06.28.10 - 19:10:48] Config System Init. [Debug] [06.28.10 - 19:10:48] MySQL Database Init. [Debug] [06.28.10 - 19:10:48] Encryption Initialize. [Debug] [06.28.10 - 19:10:48] Encryption Loaded Successfully. [Debug] [06.28.10 - 19:10:48] Server Manager Initialize. [Network] [06.28.10 - 19:10:48] ServerManager listening on port 5998 [Debug] [06.28.10 - 19:10:48] Client Manager Initialize. [Network] [06.28.10 - 19:10:48] ClientManager listening on Titanium stream. [Network] [06.28.10 - 19:10:48] ClientManager listening on SoD stream. [Debug] [06.28.10 - 19:10:48] Server Started. [Network] [06.28.10 - 19:10:55] New world server connection from 127.0.0.1:1283 [Database] [06.28.10 - 19:10:55] Mysql query failed: SELECT WSR.ServerID, WSR.Se rverTagDescription, WSR.ServerTrusted, SLT.ServerListTypeID, SLT.ServerListTypeD escription, WSR.ServerAdminID FROM tblWorldServerRegistration AS WSR JOIN tblSer verListType AS SLT ON WSR.ServerListTypeID = SLT.ServerListTypeID WHERE WSR.Serv erLongName = 'soloman' AND WSR.ServerShortName = 'soloman' [World] [06.28.10 - 19:10:55] Server soloman(soloman) attempted to log in but da tabase couldn't find an entry but unregistered servers are allowed. [Database] [06.28.10 - 19:10:55] Mysql query failed: SELECT max(ServerID) FROM t blWorldServerRegistration [Database] [06.28.10 - 19:10:55] Mysql query failed: UPDATE tblWorldServerRegist ration SET ServerLastLoginDate = now(), ServerLastIPAddr = '127.0.0.1' where Ser verID = 0 [Network] [06.28.10 - 19:11:58] New Titanium client connection from 127.0.0.1:12 95 [Network] [06.28.10 - 19:11:58] Application packet recieved from client (size 14 ) [Network] [06.28.10 - 19:11:58] Session ready recieved from client. [Network] [06.28.10 - 19:11:59] Application packet recieved from client (size 28 ) [Network] [06.28.10 - 19:11:59] Login recieved from client. [Client] [06.28.10 - 19:11:59] User: Eski [Client] [06.28.10 - 19:11:59] Hash: bdf454a5f43b1ef5751a6a56f615f59a2868d110 [Database] [06.28.10 - 19:11:59] Mysql query failed: SELECT LoginServerID, Accou ntPassword FROM tblLoginServerAccounts WHERE AccountName = 'Eski' [Client Error] [06.28.10 - 19:11:59] Error logging in, user Eski does not exist in the database. [Network] [06.28.10 - 19:12:06] Client disconnected from the server, removing cl ient. [Network] [06.28.10 - 19:12:06] New Titanium client connection from 127.0.0.1:12 96 [Network] [06.28.10 - 19:12:06] Application packet recieved from client (size 14 ) [Network] [06.28.10 - 19:12:06] Session ready recieved from client. [Network] [06.28.10 - 19:12:07] Application packet recieved from client (size 28 ) [Network] [06.28.10 - 19:12:07] Login recieved from client. [Client] [06.28.10 - 19:12:07] User: Eski [Client] [06.28.10 - 19:12:07] Hash: bdf454a5f43b1ef5751a6a56f615f59a2868d110 [Database] [06.28.10 - 19:12:07] Mysql query failed: SELECT LoginServerID, Accou ntPassword FROM tblLoginServerAccounts WHERE AccountName = 'Eski' [Client Error] [06.28.10 - 19:12:07] Error logging in, user Eski does not exist in the database. [Network] [06.28.10 - 19:12:08] Client disconnected from the server, removing cl ient. I don't know why it seems blind to the server name and to the account names. |
Oh well, been working on this for a while and i'm going in circles, time to give up and move on. One suggestion might be to make a bundled package with everything in it, including a generator for the ini files, so that there's no fiddling with the passwords or world names or port numbers or what have you, i can kind of see how to do it in vb.net except for the encryption bit that is used to insert a password into tblloginserveraccounts.
Thanks for your help guys and good luck with this project! |
Quote:
http://www.eqemulator.org/forums/showthread.php?t=28190 |
All times are GMT -4. The time now is 10:54 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.