Quote:
Originally Posted by y2krazy
I was also wondering how I could give new members a certain amount of "default" points when they register. I tried searching for this in the thread, but found it asked by 2 people with no response. Forgive me if I missed it, but if anyone can help, I would surely appreciate it! 
|
Just run this query:
PHP Code:
ALTER TABLE `user` CHANGE `uttpoints` `uttpoints` VARCHAR( 20 ) DEFAULT '100' NOT NULL;
Change the '100' to however many points you want them to start out with. Don't for get to put your table prefix before 'user' if you use a prefix. And if you are using a feild other than 'uttpoints' (like me -- I'm using 'storep' because I was using Lesanne's hack before), be sure to change that part of the query too.