Hy i use 11.11.82 files with sql 2000.
How can i add for example 500 credit points for each user?
Printable View
Hy i use 11.11.82 files with sql 2000.
How can i add for example 500 credit points for each user?
try with SCF Editor or something
You need to run a query for the existing users, but for future users you can do the following step. Enterprise manager --> MuOnline --> Tables --> right click MEMB_INFO and click Design, find the column for credits and change the default value to 500 :)
can you give a query for that?
The following command should give 5000 credits for all existing account, haven't tested it but it should work.
Code:UPDATE MEMB_INFO SET credits=5000
I what to know for sure if this points will be added on existing for example one user has 30 credits after it will have 5030 ?
Nope it sets a standard value for everyone.Quote:
Originally Posted by mytzu
theres an error and when i checked MEMB_INFO there was no credits in column?!Quote:
Originally Posted by Cryingsoul
do i need to create one?
also "credits" column is in MEMB_CREDITS,
All credits is in the MEMB_Credits table
Code:UPDATE MEMB_Credits SET credits=5000
i think for having extra 5000 credits this should be.
Quote:
UPDATE MEMB_Credits SET credits=credits + 5000
I just want to add to all members bonus credits as christmas gift.
So can anyone tell me for sure if: UPDATE MEMB_Credits SET credits=credits + 5000 would work? or what query i need to run for adding 5000 extra credit for all users?
I really need this fast. Thank you !
Yes, this is query works as it should (will add 5k credits). Also, I'm not sure what actual use will your players get from credits. My current credit table is empty and I saw no use for it, even the cash shop doesn't use it...Quote:
Originally Posted by mytzu
how bout in DmN_Shop_Credits?
Not sure what that is lol. Haven't seen any similar table name or collumn in my db.Quote:
Originally Posted by daezugun
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.Quote:
Originally Posted by Darkisss
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
Thats working fine. Use it with trust. Thank You!Quote:
Originally Posted by S37uP!Update
Ur welcome m8, Happy New Year!