Commit | Line | Data |
---|---|---|
bc13d5d6 H |
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 |