najohodnotenejsie prispevky za poslednych 24 hodin
"; echo "Kazdy den o polnoci bude kazdemu userovi pridane 3 K. Tieto K moze uzivatel pridelovat jednotlivym prispevkom (zaklikne \"mazaci\" stvorcek pri prispevku) a stlaci K!. Jednemu prispevku moze kazdy uzivatel celkovo pridelit maximalne 1 K. Cely system sluzi na \"zvecnovanie\" kvalitnejsich prispevkov v kope balastu.

"; if ($_GET['offset']) $offset=$_GET['offset']; else $offset=0; if ($_GET['karma']) $karma=$_GET['karma']; else $karma='good'; if($karma=='good') { $q="select submissions.*,user.login as user_name,forum.forum_name as forum_name from submissions left join forum on submissions.forum_id=forum.forum_id left join user on submissions.submission_owner=user.id where unix_timestamp(submissions.submission_timestamp)>(unix_timestamp(NOW())-84400) and submissions.submission_k>0"; $q.=" ORDER BY submission_k DESC LIMIT $offset,23"; } //do not discriminate bad guys with evil karma ;) elseif($karma=='bad') { $q="select submissions.*,user.login as user_name,forum.forum_name as forum_name from submissions left join forum on submissions.forum_id=forum.forum_id left join user on submissions.submission_owner=user.id where unix_timestamp(submissions.submission_timestamp)>(unix_timestamp(NOW())-84400) and submissions.submission_k>0"; $q.=" ORDER BY submission_k asc LIMIT $offset,23"; } $set=$kyberia->query($q); $next_offset=$offset+23; $prev_offset=$offset-23; echo ""; if ($offset) echo "<< predchádzajúúuuuuuuui    "; echo "ïalšie >>"; echo "

"; while ($set->next()) { $submissions=$set->getRecord(); if (($submissions['submission_k'])>'1'){ echo "

"; // $submissions['submission_text'] = preg_replace ("//","obrazok: \\1", $submissions['submission_text']); echo ""; echo "",$submissions['submission_k']," K"; echo "

"; echo ""; echo ""; echo ""; echo ""; echo " "; echo "forum:  ",$submissions['forum_name']," "; echo $submissions['user_name']; if ($submissions['user_mode']=="normal" AND ($submissions['user_action'])) { Showz::showLocation($submissions['user_action'],$submissions['user_action_id'],$submissions['user_action_name']); } Showz::showDate($submissions['submission_timestamp']); echo " ",Stripslashes($submissions['submission_text'])," "; echo "

"; } } ?>