1) { $error = "mozes dat maximalne 1K"; } else { $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'"; $set=$kyberia->query($q); $set->next(); $amount=$set->getInt('amount'); if (abs($amount)>=1) { $error="tomuto prispevku uz si pridelil maximalny mozny pocet 1 K!"; } else { $set2=$kyberia->query("SELECT autor FROM dennik WHERE id='$node_id'"); $set2->next(); $acceptor_id=$set2->getString('autor'); if ($acceptor_id == $user_id) { $error="egotrip?"; } else { $set3=$kyberia->query("select user_k from user where id='$user_id'"); $set3->next(); if ($set3->getInt('user_k') < abs($k_amount)) { $error="bohuzial dnes uz ti zostava ".$set3->getString('user_k')." K. zadel menej alebo pockaj do polnoci"; } else { $kyberia->query("update user set user_k=user_k-".abs($k_amount)." where id='$user_id'"); $kyberia->query("update user set user_karma=user_karma+$k_amount where id='$acceptor_id'"); $kyberia->query("update dennik set karma=karma+$k_amount where id='$node_id'"); $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'"); }}}}} if ($error) echo "
$error

"; else { // header("Location: $_SERVER[REQUEST_URI]"); // exit(); } } if ($delete) { $set = $kyberia->getDennik($delete); $set->next(); if ($user_id != $set->getInt('autor')) die('wo co go??'); $diskusiaID = $set->getInt('id_diskuse'); $kyberia->update("delete from prispevky where id_diskuse='$diskusiaID'"); $kyberia->update("delete from diskuse where id_diskuse='$diskusiaID'"); $kyberia->update("delete from dennik where id='$delete'"); header("Location: ".SCRIPT."?action=journaux"); exit(); } function showJournaux() { global $kyberia; global $set; global $user_id; global $node_id; echo "
"; echo " ",$set->getString("nadpis")," ( ",$set->getString("autorname")," ) ".$set->getString('cas'); if ($set->getInt('autor') == $user_id) { echo "
zmazat"; } $karma = $set->getInt('karma'); if ($karma) { echo "
{$karma}K"; } echo "

"; echo $set->getString("zapis"); echo "

"; $set2=$kyberia->query("select user_k from user where id='$user_id'"); $set2->next(); $kamount="Este mas ".$set2->getString('user_k')." K."; echo "
$kamount
"; $dd=new DiskuseDesign(); if ($set->getString("id_diskuse")==0) { $discussion_id=$dd->createDiskuse(); $kyberia->createDennikDiskuse($set->getString("id"),$discussion_id); $dd->printDiskuse($discussion_id); } else { $discussion_id=$set->getString('id_diskuse'); $dd->printDiskuse($discussion_id); } $q="SELECT user_id from user_discussion where user_id='$user_id' and discussion_id='$discussion_id'"; $discset=$kyberia->query($q); if ($discset->getNumRows()) { $q="UPDATE user_discussion set submission_count=0,last_visit=NOW() where discussion_id='$discussion_id' and user_id='$user_id'"; $rows=$kyberia->update($q); } else $kyberia->query("INSERT INTO user_discussion set submission_count=0,discussion_id='$discussion_id',user_id='$user_id',last_visit=NOW()"); echo "
"; } $posun=23; if (!IsSet($offset)) $offset=0; $dd=new DiskuseDesign(); $string = new String(); if ($user_id) echo "

novy dennik"; // karmu ukazovat iba v zozname a registrovanym userom (ok, som lenivy to robit pre neregistrovanych) if (!isset($node_id) && $user_id) echo " | posledne karmove | top karma"; echo "


"; if (is_numeric($node_id)) { $set=$kyberia->getDennik($node_id); $set->next(); echo "
"; echo "
"; if (($set->getString('type')=='kyberia' or $set->getString('private')) and !$user_id) { echo "

Nemate opravnenie na prezeranie tohto denniku.
"; } elseif (($set->getString('type')=='private') and ($user_id!=$set->getString('autor'))) { $q="select * from node_access where user_id='$user_id' and node_id='$node_id' and access_type='access'"; $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'"); if ($controlset->getNumRows()) { showJournaux(); } else { echo "

Tento dennik je sukromny, nemas opravnenie na jeho prezeranie.
"; } } else { showJournaux(); echo "
"; } return; } elseif (is_numeric($dennik_user)) { $offset=$_GET['offset']; if ($offset==NULL) $offset=0; $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')"; $q.=" where dennik.autor='$dennik_user' "; if ($_GET['karmatop']) $q .= " AND karma != 0 ORDER BY dennik.karma DESC LIMIT $offset, 23"; elseif ($_GET['karmalast']) $q .= " AND karma != 0 ORDER BY datum DESC LIMIT $offset, 23"; else $q .= " order by dennik.id desc limit $offset,23 "; if ($user_id) $set=$kyberia->query($q); 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 where dennik.autor='$dennik_user' order by dennik.id desc limit $offset,23"); } else { $offset=$_GET['offset']; if ($offset==NULL) $offset=0; $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')"; if ($_GET['karmatop']) $q .= " WHERE dennik.karma <> 0 ORDER BY dennik.karma DESC LIMIT $offset,23"; elseif ($_GET['karmalast']) $q .= " WHERE dennik.karma <> 0 ORDER BY datum DESC LIMIT $offset, 23"; else $q.=" order by dennik.id desc limit $offset,23 "; if ($user_id) $set=$kyberia->query($q); 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"); } // vypis zoznam while($set->next()) { echo ""; echo "
"; echo " ",$set->getString("nadpis")," ( ",$set->getString("autorname")," ) ".$set->getString('cas'); echo "--->"; echo "",$set->getString("hits")," hits --> "; echo "",$set->getString("prispevky")," prispevok"; $karma = $set->getInt('karma'); if ($karma) { echo "
{$karma}K"; } echo "

"; if(($set->getString('type')=='private') and ($user_id!=$set->getString('autor'))) echo "

Tento dennik je sukromny, nemas opravnenie na jeho prezeranie.
"; else echo $string->cutString($set->getString("zapis"),423); echo "
Viac...
"; echo "

"; } // strankovanie $url1 = isset($dennik_user) ? "&dennik_user=$dennik_user" : ""; $url1 .= $_GET['karmatop'] ? "&karmatop={$_GET[karmatop]}" : ""; $url1 .= $_GET['karmalast'] ? "&karmalast={$_GET[karmalast]}" : ""; echo ""; if ($offset) echo ""; if ($set->_numRows>$cislo) echo ""; echo "
<-- Predchadzajuce dennikyDalsie denniky -->

"; ?>