PEQ_CLASSIC_058 NOT 059DR2 Compatable

[maveren]

I have only gotten barebones to work with DR2, i cannot get PEQs to work at all.

[Malignus Wingnut]

In order for ANY database to be compatible with 5.9 DR2 you need to source:

aa.sql
aa_levels.sql
aa_timers.sql
altadv_vars.sql
ZONECFG.sql

All of which can be obtained on sourceforge from the cvs repository.

[maveren]

peq still errors
whats does peq offer other than some items over the barebones?

[sotonin]

Live pathing, Live spawns, Live mob stats. Pretty much everything. There's nothing wrong with PEQ database, it boils down to operator error. They made changes to the server, thus requiring .sql files, we have no control over what they change to the db with the new releases. That is the developer's.

[maveren]

i havent seen any mobs yet and explored a few old world zones. am i missing some commands when i first set up the classid db?

[sotonin]

Nope. u didnt do it right then. You source it in. then source in the aa .sql's etc. And you are done. He already posted it above

aa.sql
aa_levels.sql
aa_timers.sql
altadv_vars.sql
ZONECFG.sql

[maveren]

alright dit them in that exact order:
create database eq
use eq
source peq_classic_058.sql
source aa.sql
source AA_levels.sql
source aa_timers.sql (gives table already exist error, nothing is sourced)
source altadv_vars.sql
source zonecfg.sql (gives alot of duplicate column errors, then alot of Query OK 0 rows affected.)

Running World and Boot5 dont show any errors.
Gets through character select screen.
But when autobooting zone the client hangs.

5.9-DR2, Complete Client to Live patch.

I can get it to run the barebones.sql sourced to peq's but no NPCs show up in game unless i #spawn them.

[Arcane]

Try sourcing the barebones first, then PEQ, if you do it the other way around it sounds like you are undoing all the done stuff in the database. That doesn't sound right because you should get errors about this that and the other already existing right?

[sotonin]

aye barebones wipes the db and makes it fresh.... so using it after peq simply deleted everything lol.

[Edgar1898]

alright dit them in that exact order:
create database eq
use eq
source peq_classic_058.sql
source aa.sql
source AA_levels.sql
source aa_timers.sql (gives table already exist error, nothing is sourced)
source altadv_vars.sql
source zonecfg.sql (gives alot of duplicate column errors, then alot of Query OK 0 rows affected.)

Running World and Boot5 dont show any errors.
Gets through character select screen.
But when autobooting zone the client hangs.


Actually, I believe his error is causes by an incorrect Boot5zones.bat file. (assuming he did exactly as he stated above) Note that in the above, zonecfg.sql is not needed since it is already source into that database.

maveren: could you paste your boot5zones.bat?

[finwe]

where can i find barebones.sql??? tks

[Edgar1898]

read the global announcement at the top of your screen.

[maveren]

@echo off

set INTERNAL_IP=192.168.0.2

if NOT exist spells_en.txt goto NOSPELL

for /f "tokens=1-6 usebackq delims=:. " %%a in (`ipconfig ^| find "IP" ^| find "ress" ^| find /v "0.0.0.0" ^| find /v "localhost"`) do set EXTERNAL_IP=%%66.%%94.%%XXX.%%XXX
echo External ip for this system is %66.94.XXX.XXX, internal is localhost

start zone . 66.94.XXX.XXX 7995 localhost
start zone . 66.94.XXX.XXX 7996 localhost
start zone . 66.94.XXX.XXX 7997 localhost
start zone . 66.94.XXX.XXX 7998 localhost
start zone . 66.94.XXX.XXX 7999 localhost

exit
cls

:NOSPELL
echo Copy spells_en.txt into that directory !
[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.9-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction list
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 166 commands loaded
[Status] Entering Sleep mode
Connected to worldserver: localhost:9000

[Muuss]

Maveren, I recognize this boot5zones, its partially the one i submitted a few days ago. Tho, the way you modified it is... mmmh... inadequate.
You'd better use the boot5zones that comes with every eqemu package.

[sotonin]

Yep. 99% chance thats your problem. Not a database issue.

[maveren]

Yep. 99% chance thats your problem. Not a database issue.
Then i dont understand why i can boot up barebones.sql fine but anytime i use peq_classic_058.sql in the source it doesnt work for me.

Try sourcing the barebones first, then PEQ, if you do it the other way around it sounds like you are undoing all the done stuff in the database.
Took some time with errors and such, but after about 2 hours of sourcing I didnt even make it past the autoboot of the zone before it kicked me to server select screen.

Is there a way i can get just the npc groups/pathing and loot tables on a fix.sql for the barebones.sql sourced? Like I said barebones.sql is working but lacks the old world NPC content and a few popular PvP Items. To me it seems like PEQ_CLASSIC_058.sql just doesnt want to run on my server (if others aren't having this issue, and from the looks on the boards here I know for a fact meny are) Ill have to hold out for a new release, or work with somthing to find the issues.
So please let me know what works for you, if you dont mind me trying it out, I at this point dont want a public server, just a base to work from, show some of my friends, and hopefully get some interest in helping me with a project.

In short, I need to show some people how this works, so we can start building, and barebones.sql is exactly that.

[sotonin]

Nope. PEQ database works fine. Nobody else is having issues except for you. when done properly it works great. Sorry you are having trouble. but asking for just the loot and spawns is basically asking for the database. Find somebody running PEQ classic and ask for a full database dump from them.

Also, you might not be compiling your server properly. Some newer features that PEQ uses and barebones doesnt might not be properly done if you changed anything. Usually any problems like this when the majority of ppl have no issues is something you did on your part and since compiling is a huge step it usually happens there or in server setup somewhere.

[maveren]

Nope. PEQ database works fine. Nobody else is having issues except for you.

I wasnt aware of that. thought everybody was having problems, from the numerous post on the boards of people experiancing the kick to server select, and black screen hanging client issues, i was under a different impression. :?
Just thought id take a different approach at getting some questions answered. :oops:
Thanks for the help guys, Ill just work from barebones, untill a later release of 5.9 or 6.0. :idea:
thanks again! :D

[sotonin]

The kick to server screen has nothing to do with the database its the person having the wrong client for what they are connecting too =D

I remember a similar problem on PEQ TGC, but it was solved with code fixes from FNW, ill see if i can dig some more info outa him about it, it's been a while i forget

[Arcane]

I don't remember the exact post; but if you download the additional sql files that are required for 5.9DR2 the PEQ database works with no problems. It is addressed in another post, maybe in the how to forum.

The only problems I had with the database were problems I caused.

If you don't want to find all the sql files to get classic working try the Alpha 1; it requires no extra work http://www.eqemulator.net/forums/viewtopic.php?t=17752

[sotonin]

I remember now what was causing black screen errors on character create. it was a 5.8+ code issue. It has something to do with the server assigning null to the alt_Adv field in the database. We had to wipe all the chars that were created with the field null (black screening) after the code was fixed.

I don't know exactly what was changed, i'm not a coder. FNW did it all. Hopefully we'll be merged with CVS soon. I think fnw wanted to work a bit on full live compat first.

i do have one thing to say about the WR merge. expect a LOT. because that's what you'll get. it's very kick butt

[maveren]

heh, my post got deleted?
well barebones works fine event though my server setup is bad, so i guess ill work from that, gl with peq's