2 echo "<br><center><b>najohodnotenejsie prispevky za poslednych 24 hodin</b></center><br>";
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>";
9 if ($_GET['offset']) $offset=$_GET['offset'];
11 if ($_GET['karma']) $karma=$_GET['karma'];
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";
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";
24 $set=$kyberia->query($q);
26 $next_offset=$offset+23;
27 $prev_offset=$offset-23;
30 if ($offset) echo "<a href='?action=karma&karma=$karma&offset=$prev_offset'><< predchádzajúúuuuuuuui </a>";
31 echo "<a href='?action=karma&karma=$karma&offset=$next_offset'>ïal
\9aie >></a>";
32 echo "</center></b><br><br>";
34 while ($set->next()) {
35 $submissions=$set->getRecord();
36 if (($submissions['submission_k'])>'1'){
37 echo "<table class='bigitem'><tr><td class='icon'>";
38 // $submissions['submission_text'] = preg_replace ("/<img src=(.*?)>/","obrazok: <a href=\\1>\\1</a>", $submissions['submission_text']);
39 echo "<img alt='",$submissions['user_name'],"' src='/images/users/",strtolower($submissions['user_name']),".gif'>";
40 echo "<center><font color='red'>",$submissions['submission_k']," K</font></center>";
41 echo "</td><td class='item'>";
42 echo "<table class='item'>";
43 echo "<td class='header'>";
44 echo "forum: <a href='?action=forum&node_id=",$submissions['forum_id'],"'>",$submissions['forum_name'],"</a> <br>";
45 echo $submissions['user_name'];
46 if ($submissions['user_mode']=="normal" AND ($submissions['user_action'])) {
47 Showz::showLocation($submissions['user_action'],$submissions['user_action_id'],$submissions['user_action_name']);
49 Showz::showDate($submissions['submission_timestamp']);
53 echo "<tr class='content'><td class='content'>",Stripslashes($submissions['submission_text']),"</td></tr>";
55 echo "</td></tr></table>";