EqWorldConverter1.0 (converts myseq data to mysql source)

[fanoen]

found it, downloaded the wrong one lol.

[Conan]

Looking forwards to some more updates. Tonight or tomarrow i will trying to generate

Pofire, Poair, Powater, Poearth A, Potorment, Potatics, Solro Tower,
Hoha, Hohb and potranquil =) so I might have some bugs if any for ya.

Conan

[Armanthuz]

Great,

In the future * i dont know at all when * there will be some more features added to myseq. The guy that programs it is just great, hes been accessable, fun to talk too, and is really enthusiastic about adding things to his code that will help eqemu out...


Most of what hes adding to snapshot data we will have should clear up quite a few areas that ive had to guess on.


I plan working out better hp formula this weekend, and commenting out script better so people can emss with it easier..

[fanoen]

Ok i source it and some zones dont have the mobs up. but in fqadmin the mobs are there.

[Conan]

I had no problems sourceing in mine. Must be something that you are doing.

[cybermax]

This seems very kewl indeed.. Ill see if i can take a look at it..

At the moment i am using "Myradb" wich has a lot of zones spawned, but not the PoP zones. So.. if anyone got a crude pop zone populate DB, you think it would be possible to post it somewhere?

[Conan]

I am currently setting up spawns for pop on my server. Makeing them extra hard though because mine is semi legit. =)

[cybermax]

Tried the script just now.. Got some error about "Error 1064: You have an error in your SQL syntax..."

And a helluva lot of "Error 1136: Column count doesn't match value count at row 1"..

I am using 0.5.2 database (Myradb).

Any updates? Table structure changes perhaps, so the script needs to be updated?

[Conan]

I am not sure where you are getting the errors, I am useing tcs latest database and there are a few problems for example some of the models are entered with a name instead of a value make sure you take a look at these. Which zone are you trying to do and I can take a look at the zone?

[cybermax]

I am in no way so familiar with the table structure that i can change whatever.. hehe..

Oki.. example.. this is from MySEQ :

Muzzrap_Dirtdigger00 70 Warrior Gnome Humanoid Visible 0 75 2226 -1362 -715,75 260,1563

Now.. this will turn in to the 4 lines here :

INSERT INTO npc_types VALUES (190001,'Muzzrap_Dirtdigger00',70,12,1,0,5600,0,0, 0,0,2,0,0,0,0,0,96,191,'',0,65,0,0,0,0,0,0,0,0,0,2 50,250,25,25,25,25,25,0);
INSERT INTO spawn2 VALUES (210001,210001,'potranquility',2226,-1362,-715,260,600,1,0,0);
INSERT INTO spawnentry VALUES (210001,190001,1);
INSERT INTO spawngroup VALUES (210001,'spawn210001');

And this resulting in the "npc_types" "Error 1136: Column count does... blablabla"

The other 3 lines parse just fine.

So.. any hint what is missing or not in the npc_types?

Btw.. i am using MyraDB atm.

An example of how a similar line looks in that DB is here :
INSERT INTO npc_types VALUES (1,'Aagron',NULL,35,1,1,1,2010,0,3,3,0,0,6,5,0,0,1 ,14,73,'',0,65,1,6,0,0,0,0,0,0,0,250,250,18,18,18, 18,18,0);

Well.. a bone to chew on.. cos i am too much of a n00b to figure that out :P

[Trumpcard]

log into your mysql.

Type 'use eq';
Type 'describe npc_types';

Look at the column list, match it up to your insert, figure out what youre missing and add it.

[cybermax]

Thankies MyraDB did not use the same structure as TCS, so i guess there is where the culprit lies

[Scorpious2k]

MyraDB uses the latest db.sql format.

One thing I see you're missing is lastname.

[cybermax]

Yeah.. the script is prolly not updated to the latest structure me thinks..

[Armanthuz]

New script is up... should be compatible with 5.2 release DB


If you want to use with tcs DB or older DB, just edit script with notepad and look down about 1/3 way through script and remove the word NULL, and the comma to the RIGHT of it.

Save it and should be ready


New Things in latest script are..

Weeds out invisible trigger spots, teleport pads, and stuff like that cause otherwise they show up as humans in world.

Improved weeding out of corpses, players

Corrected a handful of translation errors



i have NOT had time to FULLY test this yet, but it seems to translate scripts pretty well that i can see by eye, ill try to load up 5.2 db table this week and play with it some. Plz let me know if theres problems.