boxiky/karma.inc

   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 if ($offset) echo "<a href='?action=karma&karma=$karma&offset=$prev_offset'><< predchádzajúúuuuuuuui&nbsp;&nbsp;&nbsp;&nbsp;</a>";
  31 echo "<a href='?action=karma&karma=$karma&offset=$next_offset'>ïal\9aie >></a>";
  32 echo "</center></b><br><br>";
  33
  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:&nbsp;&nbsp;<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']);
  48                 }
  49                 Showz::showDate($submissions['submission_timestamp']);
  50
  51                 echo "</td>";
  52                 echo "</tr>";
  53                 echo "<tr class='content'><td class='content'>",Stripslashes($submissions['submission_text']),"</td></tr>";
  54                 echo "</table>";
  55                 echo "</td></tr></table>";
  56         }
  57 }
  58
  59
  60
  61 ?>