| \n"
."$top "._BESTRATEDSTORIES." \n"; $lugar=1; while ($row3 = $db->sql_fetchrow($result3)) { $sid = intval($row3['sid']); $title = filter($row3['title'], "nohtml"); $score = intval($row3['score']); $ratings = intval($row3['ratings']); if($score>0) { $rate = substr($score / $ratings, 0, 4); echo "· $lugar: $title - ($rate "._POINTS.") \n"; $lugar++; } } echo " |
| \n"
."$top "._COMMENTEDSTORIES." \n"; $lugar=1; while ($row4 = $db->sql_fetchrow($result4)) { $sid = intval($row4['sid']); $title = filter($row4['title'], "nohtml"); $comments = intval($row4['comments']); if($comments>0) { echo "· $lugar: $title - ($comments "._COMMENTS.") \n"; $lugar++; } } echo " |
| \n"
."$top "._ACTIVECAT." \n"; $lugar=1; while ($row5 = $db->sql_fetchrow($result5)) { $catid = intval($row5['catid']); $title = filter($row5['title'], "nohtml"); $counter = intval($row5['counter']); if($counter>0) { echo "· $lugar: $title - ($counter "._HITS.") \n"; $lugar++; } } echo " |
| \n"
."$top "._NEWSSUBMITTERS." \n"; $lugar=1; while ($row7 = $db->sql_fetchrow($result7)) { $uname = filter($row7['username'], "nohtml"); $counter = intval($row7['counter']); if($counter>0) { echo "· $lugar: $uname - ($counter "._NEWSSENT.") \n"; $lugar++; } } echo " |
| \n"
."$top "._VOTEDPOLLS." \n"; $lugar = 1; $result9 = $db->sql_query("SELECT pollID, pollTitle, timeStamp, voters FROM ".$prefix."_poll_desc $queryplang order by voters DESC limit 0,$top"); $counter = 0; while($row9 = $db->sql_fetchrow($result9)) { $resultArray[$counter] = array($row9['pollID'], $row9['pollTitle'], $row9['timeStamp'], $row9['voters']); $counter++; } for ($count = 0; $count < count($resultArray); $count++) { $id = $resultArray[$count][0]; $pollTitle = $resultArray[$count][1]; $voters = $resultArray[$count][3]; for($i = 0; $i < 12; $i++) { $result10 = $db->sql_query("SELECT optionCount FROM ".$prefix."_poll_data WHERE (pollID='$id') AND (voteID='$i')"); $row10 = $db->sql_fetchrow($result10); $optionCount = $row10['optionCount']; $sum = (int)$sum+$optionCount; } $pollTitle = filter($pollTitle, "nohtml"); echo "· $lugar: $pollTitle - ($sum "._LVOTES.") \n"; $lugar++; $sum = 0; } echo " |