WDDB - Web Design Database

Web Design Resources for the Common Man

Login here · Register · Lost your password?

Forums / PHP and SQL / SQL Help / Shop plugin

 
Hi,

For the shop, people have a habit of glitching (getting 498726582443 moneys) and its a pain to remove. Is there, like a, SQL command line to remove a users id money? Rather then removing all users money?

I wish there was a easy way to manually take alway a users money. (kinda like transfering money to one user, but instead, taking away)
I didn't test this, as I've never installed the plugin.. but..
Code:
UPDATE sed_users
SET money=0
WHERE user_id=1
.. it should work. Change money=0 to money=whateveramount and user_id=whateverid

Backup your database, as always, before applying this.

I can see a potential problem if people have the money banked. We'll see how it goes when you try the above update statement.
It works! Works w/o any errors. Havent tried w/ money banked however.

Thanks.
No problem. Will have to have Dyllon add a way to remove money in the new release he's planning.
New Release? Hope it has some new buyable items. Hope it also has those dang glitchs fixed too lol.
http://www.cotonti.com/forums.php?m=posts&q=1890
Updating my shop plugin
- making it cotonti compatable, as it stands the core hacks required needed to be changed a little.
- adding a new item, bank heist. ;-) more to come soon.
There's one new item. Do you have a suggestion for new items?
Actually, one. Colored names but the color alternates. Kinda like that JavaScript code ive seen. "Rainbow Colors"

Just a suggestion.
Will let Dyllon know about this suggestion.
I believe its in the karma plugin, because ive seen it on a site.


Karma: + 0 -
Group: scout


"Scout" would be alternating colors.
I think it looks nice, and would be a nice buyable item. (I cant seem to get it to work on my site, so I cant show you).

Oh, maybe one more suggestion: You can buy your own forum, how about your own page? idk.

Anyways cant wait for it