2 function listbookforum($parid){
11 for($j=0;$j<count($f_id);$j++){
12 if ($f_parent[$j]==$parid){
13 echo "\n<br><input size='0' style='border : 0;width : 10;height : 10;' type='checkbox' name='move[]' value='".$f_id[$j]."'> <a href='?action=forum&node_id=",$f_id[$j],"'>",$f_name[$j],"</a>";
14 if ($f_subc[$j]) echo "- <font color='red'>".$f_subc[$j]." NEW</font>";
15 echo " (".$bookcat_name[prevod($parid)].")";
16 if ($f_owner[$j]!=$user_id) {echo "<a href='?action=b00kmarkz&book=1&node_id=",$f_id[$j],"' onClick=\"return confirm('Chces si unbooknut tento klub?')\"> :: unbook</a>";}
19 if ($j>0){echo "<br>";}
21 function listbookforum1($parid){
25 global $bookcat_parent;
34 for($j=0;$j<count($f_id);$j++){
35 if ($f_parent[$j]==$parid){
36 echo "\n<br> <a href='?action=forum&node_id=",$f_id[$j],"'>",$f_name[$j],"</a>";
37 if ($f_subc[$j]) echo "- <font color='red'>".$f_subc[$j]." NEW</font>";
38 echo " (".$bookcat_name[prevod($parid)].")";
39 if ($f_owner[$j]!=$user_id) {echo "<a href='?action=b00kmarkz&book=1&node_id=",$f_id[$j],"' onClick=\"return confirm('Chces si unbooknut tento klub?')\"> :: unbook</a>";}
46 function listbookcat($catid){
49 global $bookcat_parent;
51 for($i=0;$i<=count($bookcat_id);$i++){
52 if ($bookcat_parent[$i]==$catid){
53 echo "\n<a href='?action=b00kedit&editcat=".$bookcat_id[$i]."'>- ".$bookcat_name[$i]."</a>";
55 echo " <a href='?action=b00kedit&editcat=". $bookcat_parent[prevod($i)] ."&movecat=". $bookcat_id[$i] ."&upcat=". $bookcat_id[$lasti] ."'>^UP^</a>";
63 function listbookcat3($catid,$edc){
66 global $bookcat_parent;
69 for($i=0;$i<=count($bookcat_id);$i++){
70 if (($bookcat_parent[$i]==$catid)){
71 echo "<table border='0'><tr><td width='15'> </td><td>";
72 if ($edc==$bookcat_id[$i]){
73 echo "\n<b>- ".$bookcat_name[$i]."</b>";
75 echo "\n<a href='?action=b00kedit&editcat=".$bookcat_id[$i]."'><b>- ".$bookcat_name[$i]."</b></a>";
78 echo " <a href='?action=b00kedit&editcat=". $edc ."&movecat=". $bookcat_id[$i] ."&upcat=". $bookcat_id[$lasti] ."'>^UP^</a>";
80 echo " :: <a href='?action=b00kedit&delete=".$bookcat_id[$i]."'>delete</a>";
82 if(($edc!='0')&&($bookcat_id[$i]==$edc)){
83 echo " :: <input class='bigtextinput' type='text' name='bookcatname'>";
84 echo "<input type='submit' value='pridaj.b00kcat' name='action' class='bigtextinput'>";
86 listbookcat3($bookcat_id[$i],$edc);
87 echo "</td></tr></table>";
94 function listbookforum2($parid){
103 for($j=0;$j<count($f_id);$j++){
104 if ($f_parent[$j]==$parid){
105 echo "\n<br> <a href='?action=forum&node_id=",$f_id[$j],"'>",$f_name[$j],"</a> (".$f_sub[$j]." subz ";
106 if ($f_subc[$j]) echo "- <font color='red'>".$f_subc[$j]." NEW</font>";
108 if ($f_owner[$j]!=$user_id) {echo "<a href='?action=b00kmarkz&book=1&node_id=",$f_id[$j],"' onClick=\"return confirm('Chces si unbooknut tento klub?')\"> :: unbook</a>";}
109 // echo "<a href='?action=b00kmarkz&book=1&node_id=",$f_id[$j],"' onClick=\"return confirm('Chces si unbooknut tento klub?')\"> :: unbook</a>";
115 function listbookcat2($catid){
116 global $bookcat_name;
117 global $bookcat_open;
118 global $bookcat_parent;
120 global $bookcat_subc;
121 for($i=0;$i<=count($bookcat_id);$i++){
122 if (($bookcat_parent[$i]==$catid)){
124 if ($bookcat_open[$i]=="no") {echo "\n<a href='?action=b00kmarkz&openswich=".$bookcat_id[$i]."&swichto=yes'><b>- ".$bookcat_name[$i]."@";}
125 if ($bookcat_open[$i]=="yes") {echo "\n<a href='?action=b00kmarkz&openswich=".$bookcat_id[$i]."&swichto=no'><b>- ".$bookcat_name[$i]."^";}
126 if (($bookcat_subc[$i]>'0') and ($bookcat_open[$i]=="no")){echo "(<font color='red'>".$bookcat_subc[$i]." NEW</font>)";}
128 if (($bookcat_open[$i]=="yes")){
129 listbookforum2($bookcat_id[$i]);
130 listbookcat2($bookcat_id[$i]);
132 echo "</blockquote>";
141 function bookfmove($del_id){
147 for($j=0;$j<count($f_id);$j++){
148 if ($f_parent[$j]==$del_id){
149 if ($if=='0') {$qf.=" (user_id='$user_id' and forum_id='".$f_id[$j]."')";}
150 else{$qf.=" or (user_id='$user_id' and forum_id='".$f_id[$j]."')";}
159 function bookcatdel2($del_id){
161 global $bookcat_parent;
166 for($i=0;$i<=count($bookcat_id);$i++){
167 if (($bookcat_parent[$i]==$del_id)){
168 $qc.=" or (user_id='$user_id' and bookcat_id='$bookcat_id[$i]')";
169 bookfmove($bookcat_id[$i]);
170 bookcatdel2($bookcat_id[$i]);
178 function bookcatdel($del_id){
185 $qf="update user_forum set parent_id='0' where";
187 $qc="delete from user_bookcat where (user_id='$user_id' and bookcat_id='$del_id')";
189 bookcatdel2($del_id);
190 $kyberia->query($qc);
191 if ($if>'0') {$kyberia->query($qf);}
196 function prevod($id){
198 if ($id=='0'){$id='-1';}
199 for($i=0;$i<count($bookcat_id);$i++){
200 if (($bookcat_id[$i])==$id){$id=$i; break;}
207 function readbookdb(){
209 global $bookcat_name;
210 global $bookcat_open;
211 global $bookcat_parent;
221 global $bookcat_subc;
223 $q="select * from user_bookcat where user_id='".$user_id."' order by bookcat_id";
224 $bset=$kyberia->query($q);
226 while ($bset->next()){
227 $bookcat_name[$label]=$bset->getString('bookcat_name');
228 $bookcat_open[$label]=$bset->getString('is_open');
229 $bookcat_parent[$label]=$bset->getString('parent_id');
230 $bookcat_id[$label]=$bset->getString('bookcat_id');
233 $q="SELECT user_forum.submission_count,user_forum.parent_id as fparent_id,user.login,forum.* from forum left join user on forum.forum_owner=user.id left join user_forum on (forum.forum_id=user_forum.forum_id and user_forum.user_id='$user_id')";
234 $q.=" WHERE forum.forum_owner='$user_id'";
235 $q.=" order by forum_name ";
236 $forumset=$kyberia->query($q);
238 while ($forumset->next()){
239 $f_id[$i]=$forumset->getString('forum_id');
240 $f_name[$i]=$forumset->getString('forum_name');
241 $f_login[$i]=$forumset->getString('login');
242 $f_sub[$i]=$forumset->getString('forum_submissions');
243 $f_subc[$i]=$forumset->getString('submission_count');
244 $f_parent[$i]=$forumset->getString('fparent_id');
245 $f_owner[$i]=$forumset->getString('forum_owner');
249 $q="SELECT user_forum.submission_count,user_forum.parent_id as fparent_id,user.login,forum.*";
250 $q.=" from forum left join user on forum.forum_owner=user.id";
251 $q.=" left join user_forum on (forum.forum_id=user_forum.forum_id and user_forum.user_id='$user_id')";
252 $q.=" WHERE user_forum.user_bookmark='yes' and forum.forum_owner != '$user_id'";
253 $q.=" order by forum_name ";
254 $forumset=$kyberia->query($q);
255 while ($forumset->next()){
256 $f_id[$i]=$forumset->getString('forum_id');
257 $f_name[$i]=$forumset->getString('forum_name');
258 $f_login[$i]=$forumset->getString('login');
259 $f_sub[$i]=$forumset->getString('forum_submissions');
260 $f_subc[$i]=$forumset->getString('submission_count');
261 $f_parent[$i]=$forumset->getString('fparent_id');
262 $f_owner[$i]=$forumset->getString('forum_owner');
266 $bookcat_subc['-1']=countnew('0');
269 function countnew($catid){
270 global $bookcat_parent;
272 global $bookcat_subc;
273 global $bookcat_name;
275 for($i=0;$i<=count($bookcat_id);$i++){
276 if (($bookcat_parent[$i]==$catid)){
277 $bookcat_subc[prevod($catid)] += countnew($bookcat_id[$i]);
280 countnewforum($catid);
281 return $bookcat_subc[prevod($catid)];
283 function countnewforum($catid){
288 global $bookcat_subc;
289 global $bookcat_name;
290 for($j=0;$j<count($f_id);$j++){
291 if ($f_parent[$j]==$catid){
292 if ($f_subc[$j]) {$bookcat_subc[prevod($catid)]+=$f_subc[$j];}
295 return $bookcat_subc[prevod($catid)];