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

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

[zephyr325]

Sdabbs65 -

I just noticed something about the ouput you're getting from this post:

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",);

Each of those lines is 80 characters long. Also, things are getting truncated at exactly 80 characters as the "MYSQL> " prompt shortens up what the program output was to get 80 characters (7 chars as a "mysql> " and 73 "INSERT into" characters). I have double checked and there is nothing in the grabnpc.pl program that will generate a linefeed or carriage return at that point, so I'm interested in seeing an actual file that the program generates.

For example, you'd ge this kind of output if you did a "type 1001-npcname.sql" in a dos box that was 80 characters long and that's how you grabbed what you posted to us. Check out the file that it creates in some sort of text editor that will let you go longer than 80 characters in width (i.e., notepad) and see if the output from the program looks different.

Also, are you sure you're using version 0.5.6 of the grabnpc.pl program? You can tell the version number by editing it and looking at the first few lines. One of the recent changes I made was to make sure to put a set of quotes around every field for every line it outputs so that a blank/null character wouldn't produce a bad insert statement.

[sdabbs65]

Originally Posted by zephyr325

Sdabbs65 -

I just noticed something about the ouput you're getting from this post:

Each of those lines is 80 characters long. Also, things are getting truncated at exactly 80 characters as the "MYSQL> " prompt shortens up what the program output was to get 80 characters (7 chars as a "mysql> " and 73 "INSERT into" characters). I have double checked and there is nothing in the grabnpc.pl program that will generate a linefeed or carriage return at that point, so I'm interested in seeing an actual file that the program generates.

For example, you'd ge this kind of output if you did a "type 1001-npcname.sql" in a dos box that was 80 characters long and that's how you grabbed what you posted to us. Check out the file that it creates in some sort of text editor that will let you go longer than 80 characters in width (i.e., notepad) and see if the output from the program looks different.

Also, are you sure you're using version 0.5.6 of the grabnpc.pl program? You can tell the version number by editing it and looking at the first few lines. One of the recent changes I made was to make sure to put a set of quotes around every field for every line it outputs so that a blank/null character wouldn't produce a bad insert statement.

they stop at 80 because vBulletin truncated the lines.
as far as asking for help...... AH-HAH-HAHAH-HaHA...
your funny when your drunk dude.
I got it working thanks for the info it helped out a bit.