its for Dmn Webshop, and if you are using Mu Core Vote rewards, instead of memb_credits to add some credits must change to Dmn_shop_credits.
Printable View
This will add you extra credits, for example if you already have 500 credits, after using the query you will have 5500 credits.Code:UPDATE MEMB_INFO SET credits = credits + 5000
your_character_name - input an admin char for exampleQuote:
UPDATE MEMB_Credits SET credits=credits + 5000 where memb___id=your_character_name
try this and go to database tables
1. make sure you remember the credits of that character ( ex. selected character has = 12 credits)
2. run the query upper
3.go to database tables and check for that character
4. if the character has ( ex. selected character has = 5012 credits)
Than next query will definitely work on all characters
Quote:
UPDATE MEMB_Credits SET credits=credits + 5000
To add 5000 credits to all existing users:
use muonline
UPDATE MEMB_Credits
SET credits=credits + 5000
where credits > -1
Ur welcome m8, Happy New Year!