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!

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!

Thank you so much the stuff that i have tried has worked. Thank you for your help!!!

Thank you so much the stuff that i have tried has worked. Thank you for your help!!!

I have searched the entire internert and cannot find any working tutorials on adding addons to my epoch chernarus server. Every time i try it just corrupts my server. Is there anywhere i can learn? i don't want to just have someone do it for me i want to learn to do it myself... also i don't really have any money.

I have searched the entire internert and cannot find any working tutorials on adding addons to my epoch chernarus server. Every time i try it just corrupts my server. Is there anywhere i can learn? i don't want to just have someone do it for me i want to learn to do it myself... also i don't really have any money.

I think it said to put it on the mission file so i tried that but it didn't work either

I think it said to put it on the mission file so i tried that but it didn't work either

It seems no matter what i add to the serverfunctions.SQF file it doesnt do anthing. I have looked into how to turn off plot poles, decay and make a custom loadout. I read to turn off plot poles you add DZE_requireplot = 0; anywhere (not in a function). But it did nothing. I also read you can make a custom loadout, so you put a simple function in serverfunctions with DefaultMagazines = ["ItemBandage","ItemPainkiller"]; DefaultWeapons = ["ItemFlashlight"]; DefaultBackpack = ""; DefaultBackpackWeapon = ""; then you can edit what you will spawn with. This did nothing either. Am i missing something? or does this not do anything in the first place.

It seems no matter what i add to the serverfunctions.SQF file it doesnt do anthing. I have looked into how to turn off plot poles, decay and make a custom loadout. I read to turn off plot poles you add DZE_requireplot = 0; anywhere (not in a function). But it did nothing. I also read you can make a custom loadout, so you put a simple function in serverfunctions with DefaultMagazines = ["ItemBandage","ItemPainkiller"]; DefaultWeapons = ["ItemFlashlight"]; DefaultBackpack = ""; DefaultBackpackWeapon = ""; then you can edit what you will spawn with. This did nothing either. Am i missing something? or does this not do anything in the first place.

Is there somewhere i can download a new mission and server PBO because mine is meesed up beyond repair.(dont ask)