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.
Threaded Mode
