YesNoOk
View in topic context
3 Replies
Feb 24
2013

Re: Database changes

February 24, 2013, 15:26:15 | by Nightwish
https://github.com/silvercircle/SMF/commit/79dad0a832024a19e3cc01c7cc11f5144e40fe2b

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