EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Support::Linux Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=588)
-   -   From AX to PEQ (https://www.eqemulator.org/forums/showthread.php?t=38664)

Digitala 08-24-2014 11:07 AM

From AX to PEQ
 
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:
Code:

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.


All times are GMT -4. The time now is 02:19 PM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.