LiveStreet CMS

<span class="total" title="<b>проголосовало</b>: {$oTopic->getCountVote()}">...

$iDeltaRating=$iValue;
                if ($skill>=100 and $skill<250) {
                        $iDeltaRating=$iValue*2;
                } elseif ($skill>=250 and $skill<400) {
                        $iDeltaRating=$iValue*3;
                } elseif ($skill>=400) {
                        $iDeltaRating=$iValue*4;
                }

"SELECT count(v.topic_id) as v_count, JOIN count(c.comment_id) as c_count, count(t.topic_id) as t_count, count(tc.comment_id) as tc_count
FROM ".DB_TABLE_TOPIC_VOTE." AS v
LEFT JOIN ".DB_TABLE_TOPIC_COMMENT_VOTE." AS c ON c.user_id = v.user_id
LEFT JOIN ".DB_TABLE_TOPIC." AS t ON t.user_id = v.user_id
LEFT JOIN ".DB_TABLE_TOPIC_COMMENT." AS tc ON tc.user_id = v.user_id
WHERE v.user_id = ?d";