View Single Post
  #11  
Old 01-05-2010, 10:52 PM
Thovar
Sarnak
 
Join Date: Nov 2009
Posts: 41
Default Error in SQL.

Well not a "real" error, but each of the line you made Secrets all have an extra space in them, which in turn makes mysql think the name of the object and zone is "OBJ_LIFT_" instead of just "OBJ_LIFT" so if anyone is going to copy and paste the above, take out the spaces in all the names. I still say "thank you" for making these easy for everyone to input into their own DB's

Notice all the spaces...

Code:
(13220, 4, 'crescent ', 0, 'OBJ_GEARSB ', -1299.59, -1541.26, -93.25, 0, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 184, 100, 0);
so they should all be...

Code:
(13220,4,'crescent',0,'OBJ_GEARSB',-1299.59,-1541.26,-93.25,0,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,184,100,0);
They will work if you take out the spaces. in ALL of them.

Once Again, thank you Trevius AND secrets!!!
__________________
~Thovar
GM of http://www.beradingoldbeard.info/
Reply With Quote