boxiky/journaux.inc

   1 <?php
   2
   3 if ($_POST['k_amount']) {
   4         if (!is_numeric($k_amount)) {
   5                 $error = "karma je ciselna";
   6         } else {
   7
   8         if ($k_amount<-1) {
   9                 $error="ale rydaj sa PREC tam kam siel hitler a diablov MEC ti odrazi hlavu ;) ale fakt nevymyslaj bravcoviny karle, oko bez viecka vidi vsecko ;)";
  10         } elseif ($k_amount > 1) {
  11                 $error = "mozes dat maximalne 1K";
  12         } else {
  13
  14         $q="select sum(k_amount) as amount from k_logs where donor_id='$user_id' and node_id='$_GET[node_id]' and node_type='dennik'";
  15         $set=$kyberia->query($q);
  16         $set->next();
  17         $amount=$set->getInt('amount');
  18
  19         if (abs($amount)>=1) {
  20                 $error="tomuto prispevku uz si pridelil maximalny mozny pocet 1 K!";
  21         } else {
  22
  23         $set2=$kyberia->query("SELECT autor FROM dennik WHERE id='$node_id'");
  24         $set2->next();
  25         $acceptor_id=$set2->getString('autor');
  26
  27         if ($acceptor_id == $user_id) {
  28                 $error="egotrip?";
  29         } else {
  30
  31         $set3=$kyberia->query("select user_k from user where id='$user_id'");
  32         $set3->next();
  33         if ($set3->getInt('user_k') < abs($k_amount)) {
  34                 $error="bohuzial dnes uz ti zostava ".$set3->getString('user_k')." K. zadel menej alebo pockaj do polnoci";
  35         } else {
  36
  37         $kyberia->query("update user set user_k=user_k-".abs($k_amount)." where id='$user_id'");
  38         $kyberia->query("update user set user_karma=user_karma+$k_amount where id='$acceptor_id'");
  39         $kyberia->query("update dennik set karma=karma+$k_amount where id='$node_id'");
  40         $kyberia->query("insert into k_logs set donor_id='$user_id',acceptor_id='$acceptor_id',k_amount='$k_amount',node_id='$node_id',node_type='dennik'");
  41 }}}}}
  42
  43         if ($error)
  44                 echo "<center><font color=red><b>$error</b></font></center><p>";
  45         else {
  46         //      header("Location: $_SERVER[REQUEST_URI]");
  47         //      exit();
  48         }
  49 }
  50
  51 if ($delete) {
  52         $set = $kyberia->getDennik($delete);
  53         $set->next();
  54
  55         if ($user_id != $set->getInt('autor'))
  56                 die('wo co go??');
  57
  58         $diskusiaID = $set->getInt('id_diskuse');
  59         $kyberia->update("delete from prispevky where id_diskuse='$diskusiaID'");
  60         $kyberia->update("delete from diskuse where id_diskuse='$diskusiaID'");
  61         $kyberia->update("delete from dennik where id='$delete'");
  62
  63         header("Location: ".SCRIPT."?action=journaux");
  64         exit();
  65 }
  66
  67
  68
  69
  70 function showJournaux() {
  71         global $kyberia;
  72         global $set;
  73         global $user_id;
  74         global $node_id;
  75         echo "<table><tr><td>";
  76         echo "<b><font color=white> ",$set->getString("nadpis"),"</font> ( <a href='".SCRIPT."?action=journaux&dennik_user=",$set->getString("autor"),"'>",$set->getString("autorname"),"</a> )</b> ".$set->getString('cas');
  77
  78         if ($set->getInt('autor') == $user_id) {
  79                 echo "<br><b><a href=\"".SCRIPT,"?action=journaux&delete=$node_id\" onClick=\"return confirm('Zmazat tento dennik??')\">zmazat</a></b>";
  80         }
  81         $karma = $set->getInt('karma');
  82         if ($karma) {
  83                 echo "<br><font color=red>{$karma}K</font>";
  84         }
  85         echo "<br><br>";
  86
  87         echo $set->getString("zapis");
  88         echo "<br><br>";
  89
  90         $set2=$kyberia->query("select user_k from user where id='$user_id'");
  91         $set2->next();
  92         $kamount="Este mas ".$set2->getString('user_k')." K.";
  93         echo "<form action=\"\" method=\"post\">$kamount <input type=\"text\" name=\"k_amount\" size=\"5\"> <input type=\"submit\" value=\"K!\"></form>";
  94
  95
  96                 $dd=new DiskuseDesign();
  97
  98                 if ($set->getString("id_diskuse")==0) {
  99                         $discussion_id=$dd->createDiskuse();
 100                         $kyberia->createDennikDiskuse($set->getString("id"),$discussion_id);
 101                         $dd->printDiskuse($discussion_id);
 102                 }
 103                 else {
 104
 105                         $discussion_id=$set->getString('id_diskuse');
 106                         $dd->printDiskuse($discussion_id);
 107
 108                 }
 109         $q="SELECT user_id from user_discussion where user_id='$user_id' and discussion_id='$discussion_id'";
 110         $discset=$kyberia->query($q);
 111         if ($discset->getNumRows()) {
 112                 $q="UPDATE user_discussion set submission_count=0,last_visit=NOW() where discussion_id='$discussion_id' and user_id='$user_id'";
 113                 $rows=$kyberia->update($q);
 114         }
 115         else $kyberia->query("INSERT INTO user_discussion set submission_count=0,discussion_id='$discussion_id',user_id='$user_id',last_visit=NOW()");
 116         echo "</td></tr></table>";
 117 }
 118
 119
 120
 121 $posun=23;
 122 if (!IsSet($offset)) $offset=0;
 123 $dd=new DiskuseDesign();
 124 $string = new String();
 125
 126 if ($user_id) echo "<center><b><a href='index.php?action=dennikadd'>novy dennik</a>";
 127 // karmu ukazovat iba v zozname a registrovanym userom (ok, som lenivy to robit pre neregistrovanych)
 128 if (!isset($node_id) && $user_id)
 129         echo " | <a href='index.php?action={$_GET[action]}&karmalast=1&dennik_user=$dennik_user'>posledne karmove</a> | <a
 130 href='index.php?action={$_GET[action]}&karmatop=1&dennik_user=$dennik_user'>top karma</a>";
 131 echo "</b></center><br><br>";
 132
 133
 134 if (is_numeric($node_id)) {
 135         $set=$kyberia->getDennik($node_id);
 136         $set->next();
 137
 138         echo "<br><table class=box width='100%'>";
 139         echo "<tr><td>";
 140         if (($set->getString('type')=='kyberia' or $set->getString('private')) and !$user_id) {
 141                 echo "<br><br><center><font color='red'><b>Nemate opravnenie na prezeranie tohto denniku.</font></b></center>";
 142         }
 143
 144         elseif (($set->getString('type')=='private') and ($user_id!=$set->getString('autor'))) {
 145                 $q="select * from node_access where user_id='$user_id' and node_id='$node_id' and access_type='access'";
 146                 $controlset=$kyberia->query("select * from node_access where user_id='$user_id' and node_id='$node_id' and access_type='access' and node_type='journaux'");
 147                 if ($controlset->getNumRows()) {
 148                         showJournaux();
 149                 }
 150                 else {
 151                         echo "<br><br><center><font color='red'><b>Tento dennik je sukromny, nemas opravnenie na jeho prezeranie.</font></b></center>";
 152                 }
 153         }
 154
 155         else {
 156                 showJournaux();
 157                 echo "</table>";
 158         }
 159
 160         return;
 161 }
 162
 163 elseif (is_numeric($dennik_user)) {
 164         $offset=$_GET['offset'];
 165         if ($offset==NULL) $offset=0;
 166         $q="SELECT DATE_FORMAT(dennik.datum,'%k:%i:%s %e.%c.%Y') as cas ,user_discussion.submission_count as new,dennik.id as id,dennik.nadpis as nadpis,dennik.hits,dennik.prispevky,dennik.*,user.login as autorname from dennik left join user on dennik.autor=user.id left join user_discussion on (user_discussion.discussion_id=dennik.id_diskuse and user_discussion.user_id='$user_id')";
 167         $q.=" where dennik.autor='$dennik_user' ";
 168         if ($_GET['karmatop'])
 169                 $q .= " AND karma != 0 ORDER BY dennik.karma DESC LIMIT $offset, 23";
 170         elseif ($_GET['karmalast'])
 171                 $q .= " AND karma != 0 ORDER BY datum DESC LIMIT $offset, 23";
 172         else
 173                 $q .= " order by dennik.id  desc limit $offset,23 ";
 174         if ($user_id) $set=$kyberia->query($q);
 175         else
 176                 $set=$kyberia->query("SELECT dennik.id as id,dennik.nadpis as nadpis,dennik.hits,dennik.prispevky,dennik.*,user.login as autorname from dennik left join user on dennik.autor=user.id  where dennik.autor='$dennik_user' order by dennik.id  desc limit $offset,23");
 177 }
 178 else {
 179         $offset=$_GET['offset'];
 180         if ($offset==NULL) $offset=0;
 181         $q="SELECT DATE_FORMAT(dennik.datum,'%k:%i:%s %e.%c.%Y') as cas ,user_discussion.submission_count as new,dennik.id as id,dennik.nadpis as nadpis,dennik.hits,dennik.prispevky,dennik.*,user.login as autorname from dennik left join user on dennik.autor=user.id left join user_discussion on (user_discussion.discussion_id=dennik.id_diskuse and user_discussion.user_id='$user_id')";
 182         if ($_GET['karmatop'])
 183                 $q .= " WHERE dennik.karma <> 0 ORDER BY dennik.karma DESC LIMIT $offset,23";
 184         elseif ($_GET['karmalast'])
 185                 $q .= " WHERE dennik.karma <> 0 ORDER BY datum DESC LIMIT $offset, 23";
 186         else
 187                 $q.=" order by dennik.id  desc limit $offset,23 ";
 188         if ($user_id) $set=$kyberia->query($q);
 189         else $set=$kyberia->query("SELECT dennik.id as id,dennik.nadpis as nadpis,dennik.hits,dennik.prispevky,dennik.*,user.login as autorname from dennik left join user on dennik.autor=user.id  order by dennik.id  desc limit $offset,23");
 190
 191 }
 192
 193 // vypis zoznam
 194 while($set->next()) {
 195                 echo "<table class=box width='100%'>";
 196                 echo "<tr><td><img src='/images/users/".strtolower($set->getString('autorname')).".gif' border='0' align='left'>";
 197                 echo "<b><font color=white> ",$set->getString("nadpis"),"</font> ( <a href='".SCRIPT."?action=journaux&dennik_user=",$set->getString("autor"),"'>",$set->getString("autorname"),"</a> )</b> ".$set->getString('cas');
 198                 echo "--->";
 199                 echo "<a href='".SCRIPT."?action=journaux&node_id=",$set->getString("id"),"'>",$set->getString("hits")," hits --> ";
 200                 echo "<a href='".SCRIPT."?action=journaux&node_id=",$set->getString("id"),"'>",$set->getString("prispevky")," prispevok</a>";
 201                 $karma = $set->getInt('karma');
 202                 if ($karma) {
 203                         echo "<br><font color=red>{$karma}K</font>";
 204                 }
 205                 echo "<br><Br>";
 206
 207                 if(($set->getString('type')=='private') and ($user_id!=$set->getString('autor'))) echo "<br><br><center><font color='red'><b>Tento dennik je sukromny, nemas opravnenie na jeho prezeranie.</font></b></center>";
 208                 else echo $string->cutString($set->getString("zapis"),423);
 209                 echo "<div align=right><a href='".SCRIPT."?action=journaux&node_id=",$set->getString("id"),"'>Viac...</div>";
 210                 echo "</td></tr></table><br>";
 211         }
 212
 213 // strankovanie
 214 $url1 = isset($dennik_user) ? "&dennik_user=$dennik_user" : "";
 215 $url1 .= $_GET['karmatop'] ? "&karmatop={$_GET[karmatop]}" : "";
 216 $url1 .= $_GET['karmalast'] ? "&karmalast={$_GET[karmalast]}" : "";
 217 echo "<table width=100%><tr>";
 218         if ($offset) echo "<td align=left><a href=$PHP_SELF","?action=journaux&offset=",$offset-$posun,$katlink,"$url1><-- Predchadzajuce denniky</a></td>";
 219         if ($set->_numRows>$cislo) echo "<td align=right><a href='".SCRIPT."?action=journaux&offset=",$offset+$posun,$katlink,"$url1' >Dalsie denniky --></a></td>";
 220         echo "</tr></table><br>";
 221 ?>
 222
 223
 224