Problems I ran into and resolutions.

[kai4785]

peq-luclin-release
From http://projecteq.net/downloads.php
I've also tried the peq-ykesha-beta1 database. both are behaving identically.

[Angelox]

Use the newest, I think is peq-ykesha-beta1 database then get the newest source, and read the logs posted there, there's still at least one update you have to make, I think;

Required SQL:

alter table npc_faction add column ignore_primary_assist tinyint(3) not null default 0;

And don't forget to use the newest opcodes

[kai4785]

Where did you find the updates? I don't see where you want me to go get new opcodes either...

I got further though. It doesn't pop the error right away, and it looks like my client is busy loading, but logs show:

[Status] Booting rivervale
Map header: 21658 faces, 217 nodes, 29875 facelists
Loaded map: 64974 vertices, 21658 faces
Map BB: (-673.72 -> 203.91, -431.81 -> 511.78, -47.97 -> 599.75)
Map ./Maps/rivervale.map loaded.
Path File ./Maps/rivervale.path not found.
[Debug] The next weather check for zone: rivervale will be in 5660 seconds.
Error loading NPCs from database. Bad query: #1054: Unknown column 'npc_types.trackable' in 'field list'
[Status] Loading spawn conditions...
[Status] Loading static zone points...
[Status] Loading spawn groups...
[Status] Loading spawn2 points...
[Status] Loading player corpses...
[Status] Loading traps...
[Status] Loading ground spawns...
[Status] Loading Ground Spawns from DB...
[Status] Loading World Objects from DB...
[Status] Loading Objects from DB...
[Status] Loading doors for rivervale ...
[Status] Loading Doors from database...
[Status] Loading AA information...
[Error] Error in GetAASkillVars 'SELECT cost, max_level, hotkey_sid, hotkey_sid2, title_sid, desc_sid, type, prereq_skill, prereq_minpoints, spell_type, spell_refresh, classes, berserker,spellid,class_type,name,cost_inc FROM altadv_vars WHERE skill_id=2': #1054: Unknown column 'cost_inc' in 'field list'
tail: zone-dynamic_05.log: file truncated

Then it spits the same error to my client again.

[kai4785]

http://projecteq.net/phpBB2/viewtopi...9ca262804e9b8d

This is exactly my problem here as well.

Do you have a link for me to download your Database Angelox? I tried looking, but couldn't find the link.

[kai4785]

http://projecteq.net/phpBB2/viewtopi...9ca262804e9b8d

found it here....

I'm in!

alter table altadv_vars add column cost_inc tinyint(4) not null default 0;

Needed to run just that one sql statement.

Ok I'm going to rebuild from source and write up a walkthrough.

[Angelox]

My database is posted for download at Rathe Forums;
http://eq.ismg.ch/mirkwood/news.php
You have to be a member there so you can see and download files (no strings attached). You shouldn't have to do anything for the ax_classic database to work.
Actually, You can also download PEQs newest from CVS and it sould all work too.

[kai4785]

Alright! I'm up and running! I can't believe how difficult it was to get a database that would work properly! Just incase anybody else is new and needs help, here's how you get the latest PEQ database:

cvs -d :pserver:anonymous@peq.cvs.sourceforge.net:/cvsroot/peq checkout peq_db

I made my own ~/cvs/ folder to keep all these sql files. Once you've done that, you simply need to import the load_players.sql and load_system.sql and I'm golden!

time to learn how to customize!