Achmed Posted October 20, 2013 Report Share Posted October 20, 2013 I want to see about changing the sell price of items on my server, what sql code would i need to change just the sell price? would this work? SET sell = '[1,"ItemGoldBar",1]', sell = [3,"ItemSilverBar10oz",1]; i have no clue so its prob wrong so dont recommend anyone try it lol Link to comment Share on other sites More sharing options...
0 Kind-Sir Posted October 21, 2013 Report Share Posted October 21, 2013 I want to see about changing the sell price of items on my server, what sql code would i need to change just the sell price? would this work? SET sell = '[1,"ItemGoldBar",1]', sell = [3,"ItemSilverBar10oz",1]; i have no clue so its prob wrong so dont recommend anyone try it lol UPDATE traders_data SET buy='[9001,"ItemBriefcase100oz",1]', sell='[4500,"ItemBriefcase100oz",1]' WHERE item='["AW159_Lynx_BAF",2]'; UPDATE - modify existing data in a table traders_data - the table you want to modify SET - the action you want to run buy='xxx' - the argument WHERE - for every occurance of item='xxx' - where the item name = xxx http://dev.mysql.com/doc/refman/5.0/en/update.html FunkFest 1 Link to comment Share on other sites More sharing options...
0 Achmed Posted October 21, 2013 Author Report Share Posted October 21, 2013 thanks. i had googled but didnt find anything i could understand :( As i only want to change the sell price across the board (lowering the sell price to the buy price) would this work and change all [1,"ItemGoldBar",1] to [3,"ItemSilverBar10oz",1]? UPDATE traders_data SET sell='[3,"ItemSilverBar10oz",1]' WHERE sell='[1,"ItemGoldBar",1]'; Link to comment Share on other sites More sharing options...
0 Achmed Posted October 21, 2013 Author Report Share Posted October 21, 2013 just tested this on my test mysql and it works fine :) thanks for your help Link to comment Share on other sites More sharing options...
0 Achmed Posted October 21, 2013 Author Report Share Posted October 21, 2013 well i ended up killing my server :(can anyone see a problem with this code?UPDATE traders_data SET sell='[1,"ItemCopperBar",1]' WHERE buy='[4,"ItemCopperBar",1]';UPDATE traders_data SET sell='[1,"ItemCopperBar",1]' WHERE buy='[5,"ItemCopperBar",1]';UPDATE traders_data SET sell='[2,"ItemCopperBar",1]' WHERE buy='[6,"ItemCopperBar",1]';UPDATE traders_data SET sell='[2,"ItemCopperBar",1]' WHERE buy='[8,"ItemCopperBar",1]';UPDATE traders_data SET sell='[3,"ItemCopperBar",1]' WHERE buy='[1,"ItemCopperBar10oz",1]';UPDATE traders_data SET sell='[5,"ItemCopperBar",1]' WHERE buy='[2,"ItemCopperBar10oz",1]';UPDATE traders_data SET sell='[8,"ItemCopperBar",1]' WHERE buy='[1,"ItemSilverBar",1]';UPDATE traders_data SET sell='[2,"ItemCopperBar10oz",1]' WHERE buy='[2,"ItemSilverBar",1]';UPDATE traders_data SET sell='[1,"ItemSilverBar",1]' WHERE buy='[4,"ItemSilverBar",1]';UPDATE traders_data SET sell='[1,"ItemSilverBar",1]' WHERE buy='[5,"ItemSilverBar",1]';UPDATE traders_data SET sell='[4,"ItemCopperBar10oz",1]' WHERE buy='[6,"ItemSilverBar",1]';UPDATE traders_data SET sell='[2,"ItemSilverBar",1]' WHERE buy='[8,"ItemSilverBar",1]';UPDATE traders_data SET sell='[3,"ItemSilverBar",1]' WHERE buy='[1,"ItemSilverBar10oz",1]';UPDATE traders_data SET sell='[5,"ItemSilverBar",1]' WHERE buy='[2,"ItemSilverBar10oz",1]';UPDATE traders_data SET sell='[8,"ItemSilverBar",1]' WHERE buy='[1,"ItemGoldBar",1]';UPDATE traders_data SET sell='[2,"ItemSilverBar10oz",1]' WHERE buy='[2,"ItemGoldBar",1]';UPDATE traders_data SET sell='[2,"ItemSilverBar10oz",1]' WHERE buy='[3,"ItemGoldBar",1]';UPDATE traders_data SET sell='[1,"ItemGoldBar",1]' WHERE buy='[4,"ItemGoldBar",1]';UPDATE traders_data SET sell='[1,"ItemGoldBar",1]' WHERE buy='[5,"ItemGoldBar",1]';UPDATE traders_data SET sell='[4,"ItemSilverBar10oz",1]' WHERE buy='[6,"ItemGoldBar",1]';UPDATE traders_data SET sell='[4,"ItemSilverBar10oz",1]' WHERE buy='[7,"ItemGoldBar",1]';UPDATE traders_data SET sell='[2,"ItemGoldBar",1]' WHERE buy='[8,"ItemGoldBar",1]';UPDATE traders_data SET sell='[3,"ItemGoldBar",1]' WHERE buy='[9,"ItemGoldBar",1]';UPDATE traders_data SET sell='[3,"ItemGoldBar",1]' WHERE buy='[1,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[5,"ItemGoldBar",1]' WHERE buy='[2,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[8,"ItemGoldBar",1]' WHERE buy='[3,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[1,"ItemGoldBar10oz",1]' WHERE buy='[4,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[12,"ItemGoldBar",1]' WHERE buy='[5,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[12,"ItemGoldBar",1]' WHERE buy='[6,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[12,"ItemGoldBar",1]' WHERE buy='[7,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[2,"ItemGoldBar10oz",1]' WHERE buy='[8,"ItemGoldBar10oz",1]';UPDATE traders_data SET sell='[3,"ItemGoldBar10oz",1]' WHERE buy='[1,"ItemBriefcase100oz",1]';UPDATE traders_data SET sell='[5,"ItemGoldBar10oz",1]' WHERE buy='[2,"ItemBriefcase100oz",1]';UPDATE traders_data SET sell='[8,"ItemGoldBar10oz",1]' WHERE buy='[3,"ItemBriefcase100oz",1]';UPDATE traders_data SET sell='[1,"ItemBriefcase100oz",1]' WHERE buy='[4,"ItemBriefcase100oz",1]';UPDATE traders_data SET sell='[12,"ItemGoldBar10oz",1]' WHERE buy='[5,"ItemBriefcase100oz",1]';UPDATE traders_data SET sell='[2,"ItemBriefcase100oz",1]' WHERE buy='[8,"ItemBriefcase100oz",1]';UPDATE traders_data SET sell='[3,"ItemBriefcase100oz",1]' WHERE buy='[12,"ItemBriefcase100oz",1]'; Link to comment Share on other sites More sharing options...
0 Achmed Posted October 24, 2013 Author Report Share Posted October 24, 2013 Bump Link to comment Share on other sites More sharing options...
0 Bags2247 Posted October 24, 2013 Report Share Posted October 24, 2013 Nah not me Link to comment Share on other sites More sharing options...
0 Kind-Sir Posted October 27, 2013 Report Share Posted October 27, 2013 Splice the query into parts of like 5 updates per query. It may be that your MySQL server has a limit to the amount of commands you can pass in a query. Link to comment Share on other sites More sharing options...
0 axeman Posted October 27, 2013 Report Share Posted October 27, 2013 You can use CASE with mysql update queries.http://www.headfirstlabs.com/sql_hands_on/hf24.htm Take a backup first ;) Link to comment Share on other sites More sharing options...
Question
Achmed
I want to see about changing the sell price of items on my server, what sql code would i need to change just the sell price?
would this work?
i have no clue so its prob wrong so dont recommend anyone try it lol
Link to comment
Share on other sites
8 answers to this question
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now