Profile voting allows users to vote multiple times on a single profile

[jbk]

Optimally votes should be kept in a seperate table with the headers: voting_userid (int), profile_userid (int), vote (tinyint) where vote is either +1 or -1

Triggers can be used to update the existing table via selects like UPDATE user_profile SET recommend = (SELECT sum(vote) from profile_votes WHERE vote = 1 AND profile_userid = 12351) WHERE user = 12351

(Roughly sketched queries)

[Nicolas]

Does profile voting do anything useful?

[Ageless]

Hasn't this always been the case? I can't remember it being any else. And added to that, I still don't know what voting for a profile does, will it make you UotD?

[Christian Beer]

No, it will just tell the admin who approves the profiles for UotD how valueable this profile is.