Vladick 1 Report post Posted September 25, 2014 Anyone know if there is a tutorial or directions for using the Epoch Traders Admin Tool on the server Cpanel? It's not that intuitive (or I'm not that smart) and I'd like to do a couple of things like: Add new helis and some other stuff to the tradersAdd stock to existing items in the trader menu Some players have been getting the message, "insufficient stock" when trying to purchase items that were previously available to be purchased. Anyone know about this stuff? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 25, 2014 Anyone know if there is a tutorial or directions for using the Epoch Traders Admin Tool on the server Cpanel? It's not that intuitive (or I'm not that smart) and I'd like to do a couple of things like: Add new helis and some other stuff to the tradersAdd stock to existing items in the trader menu Some players have been getting the message, "insufficient stock" when trying to purchase items that were previously available to be purchased. Anyone know about this stuff? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 I know of a video that shows you how to add things to the traders and I will link it below: Link: About the stocking, I know you can edit the stocking in the database but that can take hours. I'm not sure but think there might be a way to get it to auto restock on server restart. I'll look around and let you know if I find anything. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 I know of a video that shows you how to add things to the traders and I will link it below: Link: About the stocking, I know you can edit the stocking in the database but that can take hours. I'm not sure but think there might be a way to get it to auto restock on server restart. I'll look around and let you know if I find anything. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 Ok, I have found out how to auto restock the traders on server restarts. It's a bit confusing if I explain it here so I will make a quick video and give you the link in a little bit. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 Ok, I have found out how to auto restock the traders on server restarts. It's a bit confusing if I explain it here so I will make a quick video and give you the link in a little bit. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 Ok, well sorry I can't make a video cause my computer is being weird so I'm going to explain it the best I can. 1. Go into your database via the control panel 2. Go into traders_data 3. At the top click SQL (to the left of search) 4. Click UPDATE at the bottom of the text box (should get something like this: UPDATE `traders_data` SET `id`=[value-1],`item`=[value-2],`qty`=[value-3],`buy`=[value-4],`sell`=[value-5],`order`=[value-6],`tid`=[value-7],`afile`=[value-8] WHERE 1 to appear in the text box) 5. Delete that code 6. Replace with this: UPDATE `traders_data` SET qty=50 WHERE qty<=50; 7. Replace the two 50s' with whatever numbers you want (the first 50 is the qty that the items will be set to in the traders, the second 50 is the qty at which the item has to be below to get reset to the number in the first spot) 8. Hit the Go button at the bottom right 9. Update and restart your server You have to do this everything you want to restock your traders. If you have any questions feel free to ask me and I will try to help. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 Ok, well sorry I can't make a video cause my computer is being weird so I'm going to explain it the best I can. 1. Go into your database via the control panel 2. Go into traders_data 3. At the top click SQL (to the left of search) 4. Click UPDATE at the bottom of the text box (should get something like this: UPDATE `traders_data` SET `id`=[value-1],`item`=[value-2],`qty`=[value-3],`buy`=[value-4],`sell`=[value-5],`order`=[value-6],`tid`=[value-7],`afile`=[value-8] WHERE 1 to appear in the text box) 5. Delete that code 6. Replace with this: UPDATE `traders_data` SET qty=50 WHERE qty<=50; 7. Replace the two 50s' with whatever numbers you want (the first 50 is the qty that the items will be set to in the traders, the second 50 is the qty at which the item has to be below to get reset to the number in the first spot) 8. Hit the Go button at the bottom right 9. Update and restart your server You have to do this everything you want to restock your traders. If you have any questions feel free to ask me and I will try to help. Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 25, 2014 Thanks Cole! I will give it a try and let you know how it goes. BTW, what program do you use to edit the database, just so I am doing it exactly as you are? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 25, 2014 Thanks Cole! I will give it a try and let you know how it goes. BTW, what program do you use to edit the database, just so I am doing it exactly as you are? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 You just go into the database via the control panel. If you click on the IP next to Host: in your control panel at the top under Database Details it should send you to your database. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 25, 2014 You just go into the database via the control panel. If you click on the IP next to Host: in your control panel at the top under Database Details it should send you to your database. Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 25, 2014 Oh cool. I can do this from work. It says 1208 rows were affected. Still need to restart my server though but people are on it. Thanks again! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 25, 2014 Oh cool. I can do this from work. It says 1208 rows were affected. Still need to restart my server though but people are on it. Thanks again! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 26, 2014 Np, anytime, and it's a good thing that many were affected because that means it worked. I had about the same amount affected when I did it. Just remember you have to keep on doing it. If you don't want to have to do it like once a week or something like that just change the numbers to like 500 so it stays affected for longer. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 26, 2014 Np, anytime, and it's a good thing that many were affected because that means it worked. I had about the same amount affected when I did it. Just remember you have to keep on doing it. If you don't want to have to do it like once a week or something like that just change the numbers to like 500 so it stays affected for longer. Quote Share this post Link to post Share on other sites More sharing options...
StealthyMartian 65 Report post Posted September 26, 2014 Your database should have a query in it to auto restock the traders every morning. Quote Share this post Link to post Share on other sites More sharing options...
StealthyMartian 65 Report post Posted September 26, 2014 Your database should have a query in it to auto restock the traders every morning. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 26, 2014 What really? My traders have never restocked until I put in that command. Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 26, 2014 What really? My traders have never restocked until I put in that command. Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 26, 2014 Actually yeah, under events, it has the following query, set to run daily: UPDATE `traders_data` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat' But my out of stock notice continued for days after it started and it didn't stop until I ran Cole's query. Anyone have an idea about that? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 26, 2014 Actually yeah, under events, it has the following query, set to run daily: UPDATE `traders_data` SET qty=10 WHERE qty=0 AND afile<>'trade_any_vehicle' AND afile<>'trade_any_boat' But my out of stock notice continued for days after it started and it didn't stop until I ran Cole's query. Anyone have an idea about that? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
StealthyMartian 65 Report post Posted September 26, 2014 Make sure it is set to enable and also if you have a lot of people buying stuff set that 10 value higher. it will update the trader to more. Quote Share this post Link to post Share on other sites More sharing options...
StealthyMartian 65 Report post Posted September 26, 2014 Make sure it is set to enable and also if you have a lot of people buying stuff set that 10 value higher. it will update the trader to more. Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 26, 2014 It's set to ENABLED so that's good to go, but when I change the number from 10 to whatever it gives me the following error message: One or more errors have occured while processing your request: The following query has failed: "DROP EVENT 'updateStockDaily';" My SQL said: #1539 - Unknown event 'updateStockDaily' Ever seen that one before? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 26, 2014 It's set to ENABLED so that's good to go, but when I change the number from 10 to whatever it gives me the following error message: One or more errors have occured while processing your request: The following query has failed: "DROP EVENT 'updateStockDaily';" My SQL said: #1539 - Unknown event 'updateStockDaily' Ever seen that one before? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 26, 2014 Okay so, I've updated the stock of all of my items in my inventory. But now I want to add that cool Heli (pook_H13_medevac_INS, and maybe all of the pook family) to the Hero Trader to allow players to purchase it. How do I go about doing that? I feel like I should be able to do it in the Epoch Traders Admin tool but I can't figure it out at all. Any idea? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Vladick 1 Report post Posted September 26, 2014 Okay so, I've updated the stock of all of my items in my inventory. But now I want to add that cool Heli (pook_H13_medevac_INS, and maybe all of the pook family) to the Hero Trader to allow players to purchase it. How do I go about doing that? I feel like I should be able to do it in the Epoch Traders Admin tool but I can't figure it out at all. Any idea? Thanks! Vladick Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 26, 2014 Here watch this video, it shows you how to add things to traders: Quote Share this post Link to post Share on other sites More sharing options...
Cole24 0 Report post Posted September 26, 2014 Here watch this video, it shows you how to add things to traders: 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.