
Originally Posted by
zmoos
The problem was that it seems to take a minimum of 3-4 votes before it is considered a "leader"... and that was hard to make happen since you can only vote once per 24 hourse, but we found where to temporarily change that duplicate voting limitation, and started rating the profiles over and over, then it worked.
BxDolVotingQuery.php
Code:
function getTopVotedItem ($iDays, $sJoinTable = '', $sJoinField = '', $sWhere = '')
Code:
return $this->getOne ("SELECT $sTable.`{$sPre}id`, COUNT($sTable.`{$sPre}id`) AS `voting_count` FROM {$sTable} $sJoin WHERE TO_DAYS(NOW()) - TO_DAYS($sTable.`{$sPre}date`) <= $iDays $sWhere GROUP BY $sTable.`{$sPre}id` HAVING `voting_count` > 2 ORDER BY `voting_count` DESC LIMIT 1");
The
Code:
HAVING `voting_count` > 2
Bookmarks