Jump to content
  • 0
Sign in to follow this  
tmav94

How to wipe all MvP cards on database?

Question

2 answers to this question

Recommended Posts

  • 0

 

 

DELETE FROM `auction`,`cart_inventory`,`guild_storage`,`inventory`,`mail`,`storage` WHERE nameid = 4430;UPDATE `inventory` SET card0=0 WHERE card0 = 4430;UPDATE `inventory` SET card1=0 WHERE card1 = 4430;UPDATE `inventory` SET card2=0 WHERE card2 = 4430;UPDATE `inventory` SET card3=0 WHERE card3 = 4430; 

 

Share this post


Link to post
Share on other sites
  • 0

 

 

 

DELETE FROM `auction`,`cart_inventory`,`guild_storage`,`inventory`,`mail`,`storage` WHERE nameid = 4430;UPDATE `inventory` SET card0=0 WHERE card0 = 4430;UPDATE `inventory` SET card1=0 WHERE card1 = 4430;UPDATE `inventory` SET card2=0 WHERE card2 = 4430;UPDATE `inventory` SET card3=0 WHERE card3 = 4430; 

 

 

 

Ok, but why i need to do a update? And how to implement for all MvP?

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.