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 "