Default points for registering addon to store hack

[ChurchMedia]

This is an addon for Lesane's Store Hack. It will give a new forum member a default amount of points for registering.

In register.php find:

PHP Code:

// activate account 


Under that add:

PHP Code:

// add points for registering
$DB_site->query("UPDATE user SET storep=storep+100 where userid='$userinfo[userid]'"); 


Change the "100" to however many points you want them to start out with.

Easy!

-------Update--------

As mentioned below, you could also just make the default for storep what ever you want by changing the table....

[alanvo]

very cool
let me try

[alanvo]

very nice! worked perfectly...

[John]

Or you could just set a default value for storep in the database - it would be one less query...

[Chris M]

By that john, do you mean adding it to the "INSERT INTO user" query?

If so, then that would be better

Satan

[Link14716]

As john said, you could just run this query instead of editing register.php:

[sql]ALTER TABLE `user` CHANGE `storep` `storep` SMALLINT(5) DEFAULT 'X';[/sql]

Change X to what you want.

[ChurchMedia]

Yeah, I guess that does work better.

OT - when I try to run queries like that in phpMyAdmin I always get an error. I usually have to do something like that manually, using the program. Any ideas why?

[Davey]

Would be nice if you could release this in the options part so you can set a default value .

Dave.

PS: Cheers, I've been looking(/hoping) for this for ages now lol.

[EcpHosting]

Great Hack! Thanks!

[EcpHosting]

Originally posted by Davey
Would be nice if you could release this in the options part so you can set a default value .

Dave.

PS: Cheers, I've been looking(/hoping) for this for ages now lol.

Yes, I like this idea as well. Better organization here.