solved...
Quote:
but now im trying to figgure out how to mass produce that fix. |
Quote:
Code:
ALTER TABLE ground_spawns ADD temp_x float NOT NULL; If you just add "zeros" , things could get scrambled. |
I just had a thought; You must be using an old version of EqEmu? you'd have to update EqEmu binarys also
|
0.5.7 database
Quote:
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 |
Final thing...
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. |
Quote:
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. |
Sdabbs65 -
I just noticed something about the ouput you're getting from this post: Quote:
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. |
...
Quote:
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. |
I know this post is a bit old and I dislike bringing back an old thread, but does anyone have this tool still they could send me a link too as I'm not seeing it in the thread.
Thanks. |
If the purpose of this tool was to transfer data between my old db and PEQ's, then it is no longer needed. When I took over PEQ I slowly merged the two together and at this point the merger is pretty much done.
|
This'll be a noob question (sorry, been out of it a while), but how does one get their hands on the latest-greatest PEQ.db? The link on ProjectEQ is the Luclin final release, and I think the /sql is just the schema... Is there a CVS or other downloadable source just for the current PEQ DB work?
|
I understand that cavedude.. but I was wondering if it would be useful for importing some info from ax's database and the peq database into a new database.. I've been moving a few things by hand, but was hoping this old tool might still be around just to see if it would be of help.
and to answer John.. yes there is a CVS setup that if you check the latest server setup howto on the wiki will give you all the info on downloading it from cvs. cheers! |
Perhaps this is the file you need
http://66.159.225.58/eqemu/grabnpc.zip If not I have about everyfile emu related from 2002 GeorgeS |
Thanks! That's what I needed.
|
expired
Does this file still work?
I am wondering if I could use this to create an sql data file of an npc from the peq database? Then I could make changes to the npc file and source it in place of the current npc. I figured this way I could make my own changes and keep both npc files as backup. Hopefully it's not an inane question I've barely gotten started here and there's lots more to come. |
All times are GMT -4. The time now is 06:19 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.