Unmanned

also lemme say, the problem that i am having in the first place is, i added these items with the Insert tool, and it broke my server. It doesnt make any sense. 999999 should have worked for the quantity because it tells you if the number is too high.

also lemme say, the problem that i am having in the first place is, i added these items with the Insert tool, and it broke my server. It doesnt make any sense. 999999 should have worked for the quantity because it tells you if the number is too high.

Ah i see what you mean, my first post does not have brackets or numbers. And the way i add items is, I login to my SQL database via control panel, and try to add the items via Insert tool. But you see, when i try to add INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES(7495, '["AKS_GOLD",3]', 15, '[5,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 0, 485, 'trade_weapons'), via console, it says #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 '' at line 1 and yes i am posotive that it is in my trader items database

Ah i see what you mean, my first post does not have brackets or numbers. And the way i add items is, I login to my SQL database via control panel, and try to add the items via Insert tool. But you see, when i try to add INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES(7495, '["AKS_GOLD",3]', 15, '[5,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 0, 485, 'trade_weapons'), via console, it says #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 '' at line 1 and yes i am posotive that it is in my trader items database

...? not sure what you are looking at. There is brackets and there is a 3 for the ak, and there are 1's for the briefcases. Also i copied and pasted that exaclty from the line of code that the insert tool gave me. soo its not like its typed wrong. how could it be? i didnt even type it, the program did. im just so confused i have a million different things on my mind atm. All i know is, i put in the variables into the insert tool, the corrisponding item is also in trader items, i copied and pasted the codes into this forum from the line of code it wrote for me, and aparently i am an idiot because i cant figure this out.

...? not sure what you are looking at. There is brackets and there is a 3 for the ak, and there are 1's for the briefcases. Also i copied and pasted that exaclty from the line of code that the insert tool gave me. soo its not like its typed wrong. how could it be? i didnt even type it, the program did. im just so confused i have a million different things on my mind atm. All i know is, i put in the variables into the insert tool, the corrisponding item is also in trader items, i copied and pasted the codes into this forum from the line of code it wrote for me, and aparently i am an idiot because i cant figure this out.

yes i have tried that, i have also looked very closely at it comparing it to some the stuff that does work, and its ITENTICAL i dont understand and im really mad. this was the last thing i needed to do to my server. INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES(7495, '["AKS_GOLD",3]', 15, '[5,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 0, 485, 'trade_weapons'), i tried entering this into the SQL console, just as an example for you, this line did not work either. i also tried removing the id, because i saw other lines without it, so it would look like INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES('["AKS_GOLD",3]', 15, '[5,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 0, 485, 'trade_weapons because one of the files i added look exactly like that and it worked. i just dont understand. i didnt even write this, i used the tool SS has, so how can it not work???????!

yes i have tried that, i have also looked very closely at it comparing it to some the stuff that does work, and its ITENTICAL i dont understand and im really mad. this was the last thing i needed to do to my server. INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES(7495, '["AKS_GOLD",3]', 15, '[5,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 0, 485, 'trade_weapons'), i tried entering this into the SQL console, just as an example for you, this line did not work either. i also tried removing the id, because i saw other lines without it, so it would look like INSERT INTO `traders_data` (`id`, `item`, `qty`, `buy`, `sell`, `order`, `tid`, `afile`) VALUES('["AKS_GOLD",3]', 15, '[5,"ItemGoldBar",1]', '[3,"ItemGoldBar",1]', 0, 485, 'trade_weapons because one of the files i added look exactly like that and it worked. i just dont understand. i didnt even write this, i used the tool SS has, so how can it not work???????!

I have added these lines of code to my SQL trader data database. (7505, '30Rnd_556x45_StanagSD', 99999999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7506, '30Rnd_556x45_G36', 2147483647, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7507, '30Rnd_556x45_G36SD', 99999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7508, '10Rnd_127x99_M107', 99999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7509, 'M1A1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7510, 'T55_TK_GUE_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7511, 'BMP2_Ambul_CDF', 99999, '[3,"ItemBriefcase100oz",1]', '[3,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7512, 'T90', 99999, '[3,"ItemBriefcase100oz",1]', '[3,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7513, 'T72_INS', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7514, 'Mi17_Civilian', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7515, 'UH1Y', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7516, 'UH60M_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7517, 'UH1H_TK_GUE_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7518, 'UH60M_MEV_EP', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7519, 'UralReammo_TK_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 534, 'trade_vehicles'), (7520, 'UralRefuel_TK_EP1', 99999, '[2,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 534, 'trade_vehicles'), (7521, 'UralRepair_TK_EP1', 999999, '[2,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 534, 'trade_vehicles'), (7522, 'Ural_TK_CIV_EP1', 999999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'), (7523, 'V3S_Open_TK_EP1', 99999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'), (7524, 'V3S_Repair_TK_GUE_EP1', 999999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'), (7525, 'V3S_Reammo_TK_GUE_EP1', 999999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'); After i added these, i would get stuck on the loading screen at "waiting for server to start authentication" I am pretty sure all these are also added in the "trader_items section aswell. do the tid's i entered not exist? i got them from my server_traders.sqf in my mission pbo. In fact, whenever i try to add anything it breaks my server. even cinder blocks broke it. am i entering something wrong?

I have added these lines of code to my SQL trader data database. (7505, '30Rnd_556x45_StanagSD', 99999999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7506, '30Rnd_556x45_G36', 2147483647, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7507, '30Rnd_556x45_G36SD', 99999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7508, '10Rnd_127x99_M107', 99999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), (7509, 'M1A1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7510, 'T55_TK_GUE_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7511, 'BMP2_Ambul_CDF', 99999, '[3,"ItemBriefcase100oz",1]', '[3,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7512, 'T90', 99999, '[3,"ItemBriefcase100oz",1]', '[3,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7513, 'T72_INS', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 569, 'trade_vehicles'), (7514, 'Mi17_Civilian', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7515, 'UH1Y', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7516, 'UH60M_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7517, 'UH1H_TK_GUE_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7518, 'UH60M_MEV_EP', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 512, 'trade_vehicles'), (7519, 'UralReammo_TK_EP1', 99999, '[3,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 534, 'trade_vehicles'), (7520, 'UralRefuel_TK_EP1', 99999, '[2,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 534, 'trade_vehicles'), (7521, 'UralRepair_TK_EP1', 999999, '[2,"ItemBriefcase100oz",1]', '[1,"ItemBriefcase100oz",1]', 0, 534, 'trade_vehicles'), (7522, 'Ural_TK_CIV_EP1', 999999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'), (7523, 'V3S_Open_TK_EP1', 99999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'), (7524, 'V3S_Repair_TK_GUE_EP1', 999999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'), (7525, 'V3S_Reammo_TK_GUE_EP1', 999999, '[1,"ItemBriefcase100oz",1]', '[5,"ItemGoldBar10oz",1]', 0, 534, 'trade_vehicles'); After i added these, i would get stuck on the loading screen at "waiting for server to start authentication" I am pretty sure all these are also added in the "trader_items section aswell. do the tid's i entered not exist? i got them from my server_traders.sqf in my mission pbo. In fact, whenever i try to add anything it breaks my server. even cinder blocks broke it. am i entering something wrong?

Thank you MegaZ, i added the trader data to my database but for some reason it kept saying that the trader items were duplicates. No matter, thank you for saving me some time

Thank you MegaZ, i added the trader data to my database but for some reason it kept saying that the trader items were duplicates. No matter, thank you for saving me some time

How long ago did you pay for it? because i think it could take a couple days for them to add it in. Could i have a little more information?

How long ago did you pay for it? because i think it could take a couple days for them to add it in. Could i have a little more information?

Is there somewhere i can get trader_data and Trader_items files so i don't have to add every single item myself? because I'm only one person and the server keeps messing up just trying to add simple things like cinder blocks. Is there somewhere i can find these to download? or can someone send me a copy of yours? i would GREATLY appreciate it!