New Tool: Migrate NPC's (spells/faction/loot/spawn/move/items) from PEQ <=> Cavedude

[sdabbs65]

this is right from the npc file that grabnpc.pl made.
After tinkering with it for a while I noticed this error, maybe it's a parseing error.

mysql> INSERT INTO spawn2 (id, spawngroupID, zone, x, y, z, heading, respawntime
, variance, pathgrid, timeleft, _condition, cond_value) VALUES ("350904","281356
","nexus","0.977219","19.124527","-30.247982","139.125000","1200","0","0","0",);

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1

[sdabbs65]

Originally Posted by sdabbs65

mysql> INSERT INTO spawn2 (id, spawngroupID, zone, x, y, z, heading, respawntime
, variance, pathgrid, timeleft, _condition, cond_value) VALUES ("350904","281356","nexus","0.977219","19.124527", "-30.247982","139.125000","1200","0","0","0",);

after adding 2 more "0","0" at the end of the field it resolved the issue
but now im trying to figgure out how to mass produce that fix.

[Angelox]

Originally Posted by sdabbs65

after adding 2 more "0","0" at the end of the field it resolved the issue
but now im trying to figgure out how to mass produce that fix.

You should better update your sql database - try these out before you try anything else;

ALTER TABLE ground_spawns ADD temp_x float NOT NULL; 
UPDATE ground_spawns SET temp_x=min_x; 
UPDATE ground_spawns SET min_x=min_y; 
UPDATE ground_spawns SET min_y=temp_x; 
UPDATE ground_spawns SET temp_x=max_x; 
UPDATE ground_spawns SET max_x=max_y; 
UPDATE ground_spawns SET max_y=temp_x; 
ALTER TABLE ground_spawns DROP temp_x; 
ALTER TABLE object ADD temp_x float NOT NULL; 
UPDATE object SET temp_x=xpos; 
UPDATE object SET xpos=ypos; 
UPDATE object SET ypos=temp_x; 
ALTER TABLE object DROP temp_x; 
ALTER TABLE npc_types ADD STR MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD STA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD DEX MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD AGI MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD _INT MEDIUMINT UNSIGNED NOT NULL DEFAULT '80'; 
ALTER TABLE npc_types ADD WIS MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types ADD CHA MEDIUMINT UNSIGNED NOT NULL DEFAULT '75'; 
ALTER TABLE npc_types DROP fixedz; 
ALTER TABLE npc_types ADD fixedz  float DEFAULT '0' AFTER luclin_beard; 
ALTER TABLE zone_points DROP keep_x; 
ALTER TABLE zone_points DROP keep_y;

these are a "collection" of updates made to the sql database
If you just add "zeros" , things could get scrambled.

[Angelox]

I just had a thought; You must be using an old version of EqEmu? you'd have to update EqEmu binarys also

[sdabbs65]

Originally Posted by Angelox

I just had a thought; You must be using an old version of EqEmu? you'd have to update EqEmu binarys also

No im converting my database to the new 0.7.0 tables.
I sourced those in and got less errors..but still get a few others.

INSERT INTO spawngroup (id, name, spawn_limit) VALUES ("' at line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')' at
line 1

[sdabbs65]

ok basicly I tried sourceing in your values and everything still didn;t work.
the only way I was able to get it to work was by adding ,"0","0"
to the end of all the spawn2 querys.

yours that don't work makes this.
mysql> INSERT INTO spawn2 (id, spawngroupID, zone, x, y, z, heading, respawntime, variance, pathgrid, timeleft, _condition, cond_value) VALUES ("184093","184094","tutorial","-286.071","-52.3102","33.6032","745","180","0","0","0",);

mine that works
mysql> INSERT INTO spawn2 (id, spawngroupID, zone, x, y, z, heading, respawntime, variance, pathgrid, timeleft, _condition, cond_value) VALUES ("184093","184094","tutorial","-286.071","-52.3102","33.6032","745","180","0","0","0","0","0" );

im not sure what fields are missing but that fixed the issue.

[Angelox]

Originally Posted by sdabbs65

ok basicly I tried sourceing in your values and everything still didn;t work.
the only way I was able to get it to work was by adding ,"0","0"
to the end of all the spawn2 querys.

yours that don't work makes this.
mysql> INSERT INTO spawn2 (id, spawngroupID, zone, x, y, z, heading, respawntime, variance, pathgrid, timeleft, _condition, cond_value) VALUES ("184093","184094","tutorial","-286.071","-52.3102","33.6032","745","180","0","0","0",);

mine that works
mysql> INSERT INTO spawn2 (id, spawngroupID, zone, x, y, z, heading, respawntime, variance, pathgrid, timeleft, _condition, cond_value) VALUES ("184093","184094","tutorial","-286.071","-52.3102","33.6032","745","180","0","0","0","0","0" );

im not sure what fields are missing but that fixed the issue.

These are just off a post I found somewhere in the forums here, and saved - I also recall reading that support would start with a certain version, might have been as of EQEmu-0.6.3 , but maybe the Devs could help you there (i'm not sure).
If you have 0.6.0 and those start at 0.6.3, then you have to figure out what they changed before 0.6.3.

Also you could check the logs at http://www.eqemulator.net/download.php , and see if any lines got left out of what I posted for you.