Kyberia v1.0

[mirrors/Kyberia-bloodline.git] / boxiky / karma.inc

<?php
echo "<br><center><b>najohodnotenejsie prispevky za poslednych 24 hodin</b></center><br>";

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.<br><br>";

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 "<center><b>";