Thread: From AX to PEQ
View Single Post
  #2  
Old 08-24-2014, 11:48 AM
wolfwalkereci
Discordant
 
Join Date: Dec 2005
Posts: 435
Default

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.
__________________

Reply With Quote