Unmanned 0 Report post Posted June 14, 2014 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? Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 14, 2014 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? Quote Share this post Link to post Share on other sites More sharing options...
MegaZ 0 Report post Posted June 15, 2014 HI just a quick look have you tried adding one item and only put say 100 in stock not 99999999 see if thats the problem MegaZ Quote Share this post Link to post Share on other sites More sharing options...
MegaZ 0 Report post Posted June 15, 2014 HI just a quick look have you tried adding one item and only put say 100 in stock not 99999999 see if thats the problem MegaZ Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 16, 2014 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???????! Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 16, 2014 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???????! Quote Share this post Link to post Share on other sites More sharing options...
MegaZ 0 Report post Posted June 16, 2014 Hi Looking at this a bitdeeper I notice you dont have the Square Brackets at the first item?/ ["Mi24_D",2] 5 [12,"ItemEmerald",1] [1,"ItemBriefcase100oz",1] 0 698 trade_any_vehicle_old Or have you just typed it here wrong? All so you don't have the Item Number after you Class. ie: 1-for magazine - 2- for Vehicles - 3-for Weapons etc MegaZ Quote Share this post Link to post Share on other sites More sharing options...
MegaZ 0 Report post Posted June 16, 2014 Hi Looking at this a bitdeeper I notice you dont have the Square Brackets at the first item?/ ["Mi24_D",2] 5 [12,"ItemEmerald",1] [1,"ItemBriefcase100oz",1] 0 698 trade_any_vehicle_old Or have you just typed it here wrong? All so you don't have the Item Number after you Class. ie: 1-for magazine - 2- for Vehicles - 3-for Weapons etc MegaZ Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 16, 2014 ...? 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. Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 16, 2014 ...? 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. Quote Share this post Link to post Share on other sites More sharing options...
MegaZ 0 Report post Posted June 17, 2014 From your top post first line: (7505, '30Rnd_556x45_StanagSD', 99999999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), 7505 this is your data base id 30Rnd_556x45_StanagSD this is your item ["30Rnd_556x45_StanagSD",1] notice the number 1 at the end 99999999 this is qty in stock [1,"ItemSilverBar10oz",1] is how much you buy for '[5,"ItemSilverBar",1] is how much you sell for 0 is for the order 577 is the tid trade_items is the afile copy of mine 5016 ["30Rnd_556x45_StanagSD",1] 65 [1,"ItemSilverBar10oz",1] [5,"ItemSilverBar",1] 0 478 trade_items I think you are missing the Number here and the Square brackets? MegaZ I not sure how you are logging into the sever to change or add items, But go into control panel and log in via the Database Details there and go into your trader data and items there just add one at the end and follow the same layout as whats already there: Just re read your 2nd post and you have the Brackets and numbers as should be so it should work- Have you added it to the Trader Items Too? IE: 313 30Rnd_556x45_StanagSD 1 Ammo - Rifle trade_items Quote Share this post Link to post Share on other sites More sharing options...
MegaZ 0 Report post Posted June 17, 2014 From your top post first line: (7505, '30Rnd_556x45_StanagSD', 99999999, '[1,"ItemSilverBar10oz",1]', '[5,"ItemSilverBar",1]', 0, 577, 'trade_items'), 7505 this is your data base id 30Rnd_556x45_StanagSD this is your item ["30Rnd_556x45_StanagSD",1] notice the number 1 at the end 99999999 this is qty in stock [1,"ItemSilverBar10oz",1] is how much you buy for '[5,"ItemSilverBar",1] is how much you sell for 0 is for the order 577 is the tid trade_items is the afile copy of mine 5016 ["30Rnd_556x45_StanagSD",1] 65 [1,"ItemSilverBar10oz",1] [5,"ItemSilverBar",1] 0 478 trade_items I think you are missing the Number here and the Square brackets? MegaZ I not sure how you are logging into the sever to change or add items, But go into control panel and log in via the Database Details there and go into your trader data and items there just add one at the end and follow the same layout as whats already there: Just re read your 2nd post and you have the Brackets and numbers as should be so it should work- Have you added it to the Trader Items Too? IE: 313 30Rnd_556x45_StanagSD 1 Ammo - Rifle trade_items Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 17, 2014 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 Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 17, 2014 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 Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 17, 2014 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. Quote Share this post Link to post Share on other sites More sharing options...
Unmanned 0 Report post Posted June 17, 2014 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. Quote Share this post Link to post Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.