View in topic context
3 Replies
Feb 24

Re: Database changes

February 24, 2013, 15:26:15 | by Nightwish

Code: (mysql)
ALTER TABLE {$db_prefix}membergroups ADD rating_pool int(10) unsigned NOT NULL default '0';

Add rating points pool to member groups. A rating may or may not cost a given number of points and the pool specifies the number of points a member can spend on rating posts within a given period of time (usually, one day).

Rating costs are totally optional - ratings can have their costs set to 0 in which case they can be used without any limitations, but costs may be useful to avoid "rating abuse" in any form.

If a user is member in multiple member groups, the highest pool value of these groups is the effective one.

Ratings which cost more points than the member currently can spend, cannot be used.

NOTE: This is WIP, not everything works (yet).
Last Edit: February 24, 2013, 15:30:13} by Nightwish