EqWorldConverter1.0 (converts myseq data to mysql source)

Armanthuz · #1 12-05-2003, 12:01 PM

Well i got bored.....

What this script does is take a text dump from myseq and convert it into mysql sourceable file.

Hats off to myseq@yahoo.com for helping me get a bug fixed in myseq and adding the heading feature to text dump on very short notice... THANKS!

What you need are...

MySeq which can be downloaded from...

http://www.dvolve.net/EQ/MySEQ/

And you can read about it here...

http://seq.sourceforge.net/forums/fo...?s=&forumid=60

ATTENTION!!- Almost every time liveeq patches you will have to change a few settings in myseq for it too work properly.

Youll also need to get and install perl from here....

http://www.perl.com/pub/a/language/info/software.html

Then you need the script from here...

http://www.geocities.com/rlh989/downloads.htm

Install perl, unzip myseq into its own folder, then install eqworldconverter into its own folder also...

Then you start the server module of myseq, log into eqlive, then start client portion of myseq.... Click GO button, and pick save mobs and it will dump a text file to client dir named by the date/time..

(for best results turn off all options but NPCs that myseq scans for)

Now you have a snapshot of all the mobs ina zone, with info.... Copy this text file to you eqworldconverter directory and name it whatever you want.

Open a command prompt and navigate to directory you have eqworldconverter in, and type 'perl eqworldconverter.prl;'

This will start the script it will then ask you for name of file you are converting..... (the text file from myseq) and then it will ask you for the starting number of db.... This means it is asking you for a row number in npc_types AFTER your existing data. Once it has that data it adds 20000 to number for purposes of filling in spawn tables and such.

The output is a *.sql file that you should be able to source directly into you existing database provided you set it up right from above.

This is still in beta phase, you can COUNT on having to run through the *.sql file after words and picking out a few errors here and there because i cant anticipate everything.

I took educated guesses on formulas for setting mobs hp, min dmg max dmg and so on, this WILL change over time most likely...

All i ask is that you SHARE the material you make successfully with this so everyone has a populated server to play on!

*edit*

What this file will convert directly from myseq data...

Name
Class
Race
Level
XYZ coords
Heading of MOB

I take guessimation shots at..

HP
min/max dmg
gender
spellcasting abilities

What i cant get or guess at yet( and this may be possible in near future)..

Size of MOB
Texture
Helm texture
Faction
hp and mana regen

Also some race models are either missing (very few) or everquest has changed the name of them since they have been listed here. If you find a mob that wont go through please find its name/zone/ and rough position and ill work it out...

*disclaimer - yes i am new to perl and it will show in the code, consider this a starting point from which we can build on.*

arkaria · #2 12-05-2003, 05:18 PM

Props to ya if this works

Armanthuz · #3 12-05-2003, 11:11 PM

Proof of concept anyhow... Took me about 30 mins from start to finish to take snapshot, convert it, pick out literally 3-4 lines, and sourced it into my server and ran through it....

http://www.strike9.com/comments.aspx...neofstorms.sql

This was on 5.2dr1 server, but i also tested it on 5.1 servers too, seems fine...

Trumpcard · #4 12-06-2003, 02:35 AM

Thats just pretty darn cool !

Conan · #5 12-08-2003, 05:33 AM

I have tested this and it seems to work. Few bugs need to be worked out though

ERROR 1064: You have an error in your SQL syntax near 'Guard,1,0,5440,2,0,0,0,2,
0,0,0,0,0,93,185,'',0,65,0,0,0,0,0,0,0,0,0,250,250 ,25,2' at line 2
ERROR 1054: Unknown column '126i' in 'field list'
ERROR 1064: You have an error in your SQL syntax near 'Guard,1,0,5440,2,0,0,0,2,
0,0,0,0,0,93,185,'',0,65,0,0,0,0,0,0,0,0,0,250,250 ,25,2' at line 2
ERROR 1064: You have an error in your SQL syntax near 'Guard,1,0,5200,2,0,0,0,2,
0,0,0,0,0,89,177,'',0,65,0,0,0,0,0,0,0,0,0,250,250 ,25,2' at line 2
ERROR 1064: You have an error in your SQL syntax near 'Guard,1,0,5200,2,0,0,0,2,
0,0,0,0,0,89,177,'',0,65,0,0,0,0,0,0,0,0,0,250,250 ,25,2' at line 2
ERROR 1064: You have an error in your SQL syntax near 'Guard,1,0,5200,2,0,0,0,2,
0,0,0,0,0,89,177,'',0,65,0,0,0,0,0,0,0,0,0,250,250 ,25,2' at line 2
ERROR 1054: Unknown column '126i' in 'field list'
ERROR 1064: You have an error in your SQL syntax near 'Guard,1,0,5200,2,0,0,0,2,
0,0,0,0,0,89,177,'',0,65,0,0,0,0,0,0,0,0,0,250,250 ,25,2' at line 2

Seems the Guard is the error in this case =)

INSERT INTO npc_types VALUES
(12366,'a_doomfire_guardian25',68,58 Guard,1,0,5440,2,0,0,0,2,0,0,0,0,0,93,185,'',0,65, 0,0,0,0,0,0,0,0,0,250,250,25,25,25,25,25,0);

Also I got the files yesturday so they are outdated, let me try the new files and see if I get the same error

Can be found in Plane of fire

Armanthuz · #6 12-08-2003, 06:10 AM

redownload the latest script, i added some text that in effect replaces any corpse or player with the term "BOGUS ENTRY" which when you attempt to source it, will be refused by msql. This effectively strips out corpses and players that were taken in snapshot...

a new version of MYSEQ came out this weekend, i am in middle of testing, but at first glance it appears that everything is fine atm if you use the NEW SCRIPT.

Changes to the script and download links were done monday morning by me, so if you got stuff before that redownload BOTH myseq 1.15.13 client and script please

Shredomatic · #7 12-08-2003, 06:13 AM

If this works well I'd be tempted to renew live for a month to collect data.

Armanthuz · #8 12-08-2003, 06:14 AM

The one problem that will crop up with script is that even thou i used an extensive model conversion chart, i still am missing some race numbers for certain models. If you notice problems, try to note what MOB it was and where it can be found and ill try to add it too script.

I hope to have some more realistic HP formulas worked out by this upcoming weekend, and more minor tweaks....

Any feedback or suggestions for features is fine...

Trumpcard · #9 12-08-2003, 06:16 AM

Love it... Very cool utility...

You should organize data gatherers to and release a series of zone upgrade .sql files once you get it tweaked to your hearts content...

Conan · #10 12-08-2003, 06:19 AM

I plan on doing that trump as soon as the bugs are worked out =)

Also in the lastes zip for worldconverter there are 2 pl files do we still use the same one listed above?

Armanthuz · #11 12-08-2003, 10:50 AM

Zip file fixed, only one in there now, my bad...

Plane of Fire bug fixed for solusek ro guardian...

Fixed several more text conversion bugs..

When its a monster gender is set to neutral, when its a playable race its set to male for now ( dont get this info in snapshot yet)

New Zip uploaded 7:40 pm CST

fanoen · #12 12-08-2003, 05:36 PM

U say go to directory and type in perl eqworldconvert.prl;
Well it says perl isnt reconized as a command...

Armanthuz · #13 12-08-2003, 11:11 PM

Did you install perl, and is perl package in your path?

Conan · #14 12-09-2003, 01:22 AM

That is because in his new zip the name is different =) Well that is what I noticed anyways.

Try using pearlconverter.prl

Armanthuz · #15 12-09-2003, 01:33 AM

:P

I double checked this morning, script is named Eqworldconverter.prl.. there was a typo in directions, i corrected that....

Trying to do bug fixes and corrections in between work and school