Author Topic: Credits can be minus  (Read 3006 times)

Offline Paun

Credits can be minus
« on: January 30, 2008, 04:49:08 am »
I want to make somebody's credits go to minus.
But when I type how many credits i want it gives 0 credits, not minus 15000

Offline Daniel15

Re: Credits can be minus
« Reply #1 on: February 15, 2008, 08:12:30 am »
Please run this SQL query in phpMyAdmin (on the "SQL" tab):
Code: [Select]
ALTER TABLE `smf_members` CHANGE `money` `money` DECIMAL( 9, 2 ) NOT NULL DEFAULT '0.00'Then it should let you use negative numbers :)

Offline DracoGuard

Re: Credits can be minus
« Reply #2 on: December 06, 2009, 08:58:40 am »
Please run this SQL query in phpMyAdmin (on the "SQL" tab):
Code: [Select]
ALTER TABLE `smf_members` CHANGE `money` `money` DECIMAL( 9, 2 ) NOT NULL DEFAULT '0.00'Then it should let you use negative numbers :)

I don't know what you mean by that.  My table shows this:
"money" "DECIMAL" "30,0" Null: Not Null & Default 0 yet I can't do negative money. What do I change about it?  I need to punish a member for posting several wiki copy and past posts to gain huge amounts of money.  I need to make him have about -20,000 Gold.