Current time: 11-25-2024, 01:02 AM Hello There, Guest! (Login — Register)


Announcement
We have the biggest collection of MyBB Plugins here on the Net. We have currently 175+ MyBB Exclusive Plugins, 80+ MyBB Compatible MyCodes and 16+ MyBB 1.4.x Themes (Some are still under construction...) Thus, we provide you the largest MyBB Stuff on the net including tutorials. Stay with us, you will find out some more to come.
Now you can easily create your own buttons set for MyBB! Click here to have a look...
*** You cannot do your registration behind any Proxies anymore! ***
Welcome Guest[3.138.122.90], connected from
MyBB Codes Babjusi's Previous Forum General Stuff General Support
Myps Denomination
Post Reply 
 
Thread Rating:
  • 0 Votes - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Myps Denomination
08-24-2010, 01:47 AM
Post: #1
Mobius Offline
Diablo Mentor
***
Mobius's Info Posts: 59
Joined: Dec 2009
Reputation:0 - Rate Me
Pese: 64
Country: United Kingdom

Add to buddy
Myps Denomination
Hi, is it possible, to devide all myps for all users by 10, for example, if user has 1000 myps, after this denomination he will have 100 myps etc....

Dont know if its possible, maybe some database rule or something.. its very important to me, exdiogene helpBig Grin
Mobius's signature [Image: dsuserbar.png]
Visit this user's website Find all posts by this user
Quote this message in a reply
08-24-2010, 03:10 PM
Post: #2
exdiogene Offline
Software/Hardware engineering
*******
Administrators
exdiogene's Info Posts: 862
Joined: Nov 2009
Reputation:21 - Rate Me
Pese: 457
Country: Canada

Add to buddy
RE: Myps Denomination
Using a query in PHPmyAdmin you can easily achieve this. First select your "users" table and in the SQL query box, type this :

UPDATE `mybb_users` SET `myps`=`myps` / 10

Make sure you have backed up your database just in case before altering it. Better be cautious than sorry!
exdiogene's signature MyBBCodes.com administrator
Cool " It is not what you know that matters, it is what you do or do not do!"
Visit this user's website Find all posts by this user
Quote this message in a reply
08-25-2010, 01:26 AM
Post: #3
Mobius Offline
Diablo Mentor
***
Mobius's Info Posts: 59
Joined: Dec 2009
Reputation:0 - Rate Me
Pese: 64
Country: United Kingdom

Add to buddy
RE: Myps Denomination
thank you for help Rej, I will try this on saturdayWink
Mobius's signature [Image: dsuserbar.png]
Visit this user's website Find all posts by this user
Quote this message in a reply
0 member(s) viewed this thread in the last 365 days :
Post Reply 


Was This Thread Useful ?
Please Link To Us
URL
BBCode
HTML

Forum Jump:

 
New To Site ?
Some Useful Links
  • Help

  • You Might Need To Register

  • Forum Statistics

  • Mark All Forums Read

  • Forum Staff

  • Log Out
    		•
  • Contact Us

  • Mybbcodes

  • Return to Top

  • Return to Content

  • Lite (Archive) Mode

  • RSS Syndication
    		•
    Powered By MyBB, © 2002-2024 MyBB Group.
    Golden Crown - Designed and Published by ghazal & exdiogene of MyBBCodes.
    Hosting provided by WWWHostingServer.com