Commit | Line | Data |
---|---|---|
bc13d5d6 H |
1 | <?php |
2 | echo "<br><center><b>najohodnotenejsie prispevky za poslednych 24 hodin</b></center><br>"; | |
3 | ||
4 | echo "Kazdy den o polnoci bude kazdemu userovi pridane 3 K. Tieto K moze uzivatel pridelovat jednotlivym prispevkom (zaklikne | |
5 | \"mazaci\" stvorcek pri prispevku) a stlaci K!. Jednemu | |
6 | prispevku moze kazdy uzivatel celkovo pridelit maximalne 1 K. Cely system sluzi na \"zvecnovanie\" kvalitnejsich prispevkov | |
7 | v kope balastu.<br><br>"; | |
8 | ||
9 | if ($_GET['offset']) $offset=$_GET['offset']; | |
10 | else $offset=0; | |
11 | if ($_GET['karma']) $karma=$_GET['karma']; | |
12 | else $karma='good'; | |
13 | ||
14 | if($karma=='good') { | |
15 | $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"; | |
16 | $q.=" ORDER BY submission_k DESC LIMIT $offset,23"; | |
17 | } | |
18 | ||
19 | //do not discriminate bad guys with evil karma ;) | |
20 | elseif($karma=='bad') { | |
21 | $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"; | |
22 | $q.=" ORDER BY submission_k asc LIMIT $offset,23"; | |
23 | } | |
24 | $set=$kyberia->query($q); | |
25 | ||
26 | $next_offset=$offset+23; | |
27 | $prev_offset=$offset-23; | |
28 | ||
29 | echo "<center><b>"; | |
30 | Content-type: text/html