blacklistro Posted May 9, 2015 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 17 Reputation: 2 Joined: 04/24/15 Last Seen: November 22, 2018 Share Posted May 9, 2015 how to reset , only hair , hairstyle , cloth color in phpmyadmin??update char set hair = '0'update char set hair_color = '0'update char set clothes_color = '0'like this ? Quote Link to comment Share on other sites More sharing options...
ocelote Posted May 9, 2015 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 52 Reputation: 7 Joined: 01/02/12 Last Seen: July 3, 2015 Share Posted May 9, 2015 but add - where char_id = '"+getcharid(0)+"' Quote Link to comment Share on other sites More sharing options...
blacklistro Posted May 9, 2015 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 17 Reputation: 2 Joined: 04/24/15 Last Seen: November 22, 2018 Author Share Posted May 9, 2015 but add - where char_id = '"+getcharid(0)+"' if i want all ID/ Char in my SQL database. Quote Link to comment Share on other sites More sharing options...
ocelote Posted May 9, 2015 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 52 Reputation: 7 Joined: 01/02/12 Last Seen: July 3, 2015 Share Posted May 9, 2015 but add - where char_id = '"+getcharid(0)+"' if i want all ID/ Char in my SQL database. where hair > '0' and etc Quote Link to comment Share on other sites More sharing options...
EL Dragon Posted May 9, 2015 Group: Members Topic Count: 86 Topics Per Day: 0.02 Content Count: 591 Reputation: 146 Joined: 06/19/12 Last Seen: December 10, 2016 Share Posted May 9, 2015 here UPDATE `char` SET hair = 0, hair_color = 0, clothes_color = 0; Quote Link to comment Share on other sites More sharing options...
Elsa Mist Posted May 9, 2015 Group: Members Topic Count: 23 Topics Per Day: 0.01 Content Count: 387 Reputation: 60 Joined: 10/08/13 Last Seen: July 14, 2022 Share Posted May 9, 2015 (edited) how to reset , only hair , hairstyle , cloth color in phpmyadmin?? update char set hair = '0' update char set hair_color = '0' update char set clothes_color = '0' like this ? If you want to reset all dye in php you will need to reset at the guild table too. update `char` set hair =1, hair_color =1, clothes_color=1; update `guild_member` set hair =1, hair_color =1, just paste query the code on your php. Edited May 9, 2015 by Elsa Mist Quote Link to comment Share on other sites More sharing options...
Question
blacklistro
how to reset , only hair , hairstyle , cloth color in phpmyadmin??
update char set hair = '0'
update char set hair_color = '0'
update char set clothes_color = '0'
like this ?
Link to comment
Share on other sites
5 answers to this question
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.