PDA

View Full Version : From AX to PEQ


Digitala
08-24-2014, 11:07 AM
Hello!
Me and a friend of mine are setting up a server and we are going somewhat for the classic content.
From my understanding AX has the best database for classic. But PEQ is over all better? And also has a really good editor with it.

So!
My question is...
Is there a way to move spawns from AX into PEQ.
Like the old Lavastorm zone for example.

Any information is useful.
Thank you!

wolfwalkereci
08-24-2014, 11:48 AM
http://dev.mysql.com/doc/refman/5.6/en/select-into.html

Grab the fields you know will match up with PEQ DB.
Dirty example and someone else can prob give a better example:
SELECT npc_types.name, npc_types.level, npc_types.race INTO OUTFILE 'C:/npc_types_test.txt'
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\n'
FROM npc_types;If there are major differences in the table columns it will be kinda meh to figure it out to import correctly BUT you basically need the spawn info.
The basic mobs with lvl/hp should be correct for your needs so look at the tables referencing the spawn stuff and just export that. XYZ of spawn point etc. Look at the pathing grid info.
Could end up being more work then you want.

Lets see if someone that has actually touched eq in the last year has better advice.