Need some help importing Overpoch sql

jtech32

New Member
I've been trying to figure this out for about 7 hours ( kinda feel ashamed just realizing ive been sitting here that long with no progress). Everytime i try to import an SQL it throws me an error. Ive tried changing the SQL format many times and still no luck. Im using the sql list that sheep has posted up.
http://opendayz.net/threads/need-help-adding-overwatch-weapons-to-traders-paying.20229/#post-104694

Some assistance here would be great, i use Vert Hosting for my server if that helps, and here is what the error is saying.

Error
SQL query:



REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES (10039,'["Drive_Stun",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES (10040,'["DDOPP_X26",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES (10041,'["DDOPP_X26_b",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES (10042,'["DDOPP_X3",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES (10043,'["DDOPP_X3_b",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order[...]



MySQL said:

#1064 - 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 'REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`' at line 2
 
Use it better this way
Code:
REPLACE INTO `traders_data`(`id`,`item`,`qty`,`buy`,`sell`,`order`,`tid`,`afile`) VALUES
(10039,'["Drive_Stun",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
(10040,'["DDOPP_X26",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
(10041,'["DDOPP_X26_b",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
(10042,'["DDOPP_X3",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
(10043,'["DDOPP_X3_b",3]',50,'[2,"ItemGoldBar",1]','[1,"ItemGoldBar",1]',0,708,'trade_weapons'),
.
.
.
.
(10043,'["LastWeapon",3]',50,'[2,"with ; ",1]','[1,"at the END",1]',0,708,'trade_weapons');
 
Back
Top