Commit | Line | Data |
---|---|---|
bc13d5d6 H |
1 | <font color='red'><b>cez vikend bude kyberia.sk vypnuta, bude sa nahadzovat nova verzia a prehadzovat DNS zaznam. dakujem za pochopenie</b></font><br><br> |
2 | <?php | |
3 | if ($category=='change') { | |
4 | $q="update forum set forum_category='$forum_category' where forum_id='$forumid'"; | |
5 | $kyberia->query($q); | |
6 | } | |
7 | ||
8 | ||
9 | function showForumList($kat,$depth) { | |
10 | global $kyberia; | |
11 | global $user_id; | |
12 | global $action; | |
13 | $q="SELECT user_forum.user_bookmark as user_bookmark,user_forum.submission_count,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')"; | |
14 | $q.=" WHERE forum_category='$kat'"; | |
15 | $q.=" order by forum_id desc "; | |
16 | $forumset=$kyberia->query($q); | |
17 | ||
18 | ||
19 | while ($forumset->next()) { | |
20 | echo "<br>"; | |
21 | for ($i=0;$i<=$depth;$i++) echo " "; | |
22 | echo " <a href='?action=forum&node_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a> "; | |
23 | echo "<br>"; | |
24 | for ($i=0;$i<=$depth;$i++) echo " "; | |
25 | echo "(".$forumset->getString('login')." :: ".$forumset->getString('forum_submissions')." submissionz "; | |
26 | ||
27 | if ($forumset->getString('submission_count')) echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>"; | |
28 | echo ")"; | |
29 | /* --> "; | |
30 | if ($forumset->getString('user_bookmark')=='1') echo "<a href='?action=$action&kat=$kat&book=0&node_id=",$forumset->getString('forum_id'),"'>unbook</a>"; | |
31 | else echo "<a href='?action=$action&kat=$kat&book=1&node_id=",$forumset->getString('forum_id'),"'>book</a>"; | |
32 | global $category_parent; | |
33 | */ | |
34 | // if ($user_id==38) echo "<form action='?action=forumlist'><input type='text' name='forum_category'><input type='hidden' name='forumid' value='",$forumset->getString('forum_id'),"'><input type=submit value='change' name='category'></form>"; | |
35 | } | |
36 | echo "<br>"; | |
37 | } | |
38 | ||
39 | function showContent($subset,$pole=false,$depth=0) { | |
40 | global $user_id; | |
41 | $pole=array_unique($pole); | |
42 | foreach($pole as $subcat_id) { | |
43 | ||
44 | while ($subset[$subcat_id]->next()) { | |
45 | $data=$subset[$subcat_id]->getRecord(); | |
46 | unset($parameter); | |
47 | ||
48 | ||
49 | //creating parameter string for href linkz | |
50 | $params=$_GET['kat']; | |
51 | if (Is_array($params)) { | |
52 | $r=0; | |
53 | foreach ($params as $key => $value) { | |
54 | ++$r; | |
55 | if ($value && ($r<=$depth)) $parameter.="&kat[$key]=$value"; | |
56 | } | |
57 | } | |
58 | $pocet=count($pole); | |
59 | $parameter.= '&kat['.$depth.']='.$data['category_id']; | |
60 | ||
61 | //listing subcategories | |
62 | if (Is_array($data)) { | |
63 | echo "<br>"; | |
64 | for ($i=0;$i<=$depth;$i++) echo " "; | |
65 | if($depth) echo "|"; | |
66 | for ($i=0;$i<$depth;$i++) echo "-"; | |
67 | echo "<b><a href='?action=list$parameter'>"; | |
68 | echo $data['category_name']."</a> ("; | |
69 | echo $data['category_forums']; | |
70 | echo " forums :: ".$data['category_subcats']." subcategories)</b>"; | |
71 | } | |
72 | //unset($parameter); | |
73 | ||
74 | //main recursion sophisticated bitch. leave it. it works somehow | |
75 | $flip=array_flip($pole); | |
76 | if ($flip[$data[category_id]]) { | |
77 | //echo "<br>"; | |
78 | for ($i=0;$i<=$depth;$i++) echo " "; | |
79 | $new_depth=$depth+1; | |
80 | ||
81 | $slice=array_slice($pole,1); | |
82 | foreach ($slice as $cid) { | |
83 | $set[$cid]=$subset[$cid]; | |
84 | ||
85 | } | |
86 | ||
87 | showContent($set,$slice,$new_depth); | |
88 | //echo "<br>"; | |
89 | } | |
90 | ||
91 | } | |
92 | ||
93 | global $SHOWN; | |
94 | if ($SHOWN!="yes") { | |
95 | echo "<br>"; | |
96 | showForumList($subcat_id,$depth); | |
97 | ||
98 | if ($depth) { | |
99 | echo "<br>"; | |
100 | for ($i=0;$i<=$depth;$i++) echo " "; | |
101 | $kat=array_pop($_GET[kat]); | |
102 | echo "<a href='".SCRIPT."?action=list&show=newforum&kat=$kat'><b>zalozit nove forum</b></a>"; | |
103 | echo "<br><br>"; | |
104 | } | |
105 | ||
106 | ||
107 | $SHOWN="yes"; | |
108 | $parent=array_pop($pole); | |
109 | /* | |
110 | if ($user_id=='38') { | |
111 | echo "<form method='post' enctype='multipart/form-data' action='/'><input type='hidden' name='category_parent' value='$parent'>"; | |
112 | echo "<table><tr>"; | |
113 | echo "<td align='left'>Nazov kategorie:</td><td align='left'><input class='bigtextinput' type='text' name='category_name'>"; | |
114 | echo "<tr><td></td><td align='left'><input type='submit' value='pridaj.kategoriu' name='action' class='bigtextinput'>"; | |
115 | echo "</table></form>"; | |
116 | } | |
117 | */ | |
118 | } | |
119 | ||
120 | } | |
121 | ||
122 | } | |
123 | ||
124 | if ($show=="newforum") { | |
125 | echo "<br>"; | |
126 | echo "<form method='post' enctype='multipart/form-data' action='".SCRIPT."?action=forumlist'>"; | |
127 | echo "<table><tr>"; | |
128 | echo "<td align='left'>Nazov klubu:</td><td align='left'><input class='bigtextinput' type='text' name='forum_name'>"; | |
129 | echo "<tr><td align='left'>Obrazok klubu:</td><td align='left'><input class='bigtextinput' type='file' name='forum_icon'>"; | |
130 | ||
131 | $set=$kyberia->query("select * from category order by category_tree"); | |
132 | $selectstring="<select name='forum_category'>"; | |
133 | while ($set->next()) { | |
134 | $count=substr_count($set->getString('category_tree'),";"); | |
135 | $selectstring.="<option value='".$set->getString('category_id')."'"; | |
136 | if ($kat==$set->getString('category_id')) $selectstring.=" selected "; | |
137 | $selectstring.=">"; | |
138 | if ($count) { | |
139 | $selectstring.="|"; | |
140 | for ($i=0;$i<$count;$i++) $selectstring.="----"; | |
141 | } | |
142 | $selectstring.=$set->getString('category_name')."</option>"; | |
143 | } | |
144 | $selectstring.="</select>"; | |
145 | echo "<tr><td align='left'>Kategoria :</td><td align='left'>$selectstring</td>"; | |
146 | ||
147 | echo "<tr><td align='left'>Dalsie info:</td><td align='left' valign='top'><textarea rows='10' cols='60' name='forum_info'></textarea>"; | |
148 | echo "<tr><td colspan='2' align='center'>verejne: <input type='radio' name='forum_public' value='public' checked> moderovane:<input type='radio' name='forum_public' value='moderated'> privatne:<input type='radio' name='forum_public' value='private'></td></tr>"; | |
149 | echo "<tr><td colspan='2' align='center'>normal: <input type='radio' name='forum_type' value='flat' checked> threaded:<input type='radio' name='forum_type' value='threaded'></td></tr>"; | |
150 | echo "<tr><td></td><td align='left'><input type='submit' value='pridaj.forum' name='event' class='bigtextinput'>"; | |
151 | $set=$kyberia->query("select * from category order by category_tree"); | |
152 | ||
153 | ||
154 | echo "</table></form>"; | |
155 | ||
156 | } | |
157 | ||
158 | else { | |
159 | if (!Is_array($kat)) $kat=array(); | |
160 | array_unshift($kat,0); | |
161 | ||
162 | if (count($_GET[kat])<1) { | |
163 | /* | |
164 | echo "<b>1. drzte sa temy jednotlivych klubov </b><br>"; | |
165 | echo "<b>2. osobne veci si vybavujte v poste</b><br>"; | |
166 | echo "<b>3. snazte sa ostatnym nieco DAT</b><br>"; | |
167 | echo "<b>4. pouzivajte nahlad a mazte po sebe bravcoviny</b><br>"; | |
168 | echo "<b>5. konecne funguju bookmarky tak ako maju. takk bookojte, boha ;]</b><br>"; | |
169 | echo "<b>6. na chatovacich forach sa chatuje. na diskusnych forach sa diskutuje</b>"; | |
170 | */ | |
171 | ||
172 | // echo "<font color='red'>Z dovodu prilisneho pracovneho a spolocenskeho ;] vytazenia vas administrator dnes nechtiac zmazal cast databaze v ktorej boli ulozene nazvy a majitelia klubov. Preto pokial vam nejake kluby zmizli z bookmarkov, kliknite hore na ADMIN, potom na \"auditko\" a tam sa pokuste vas klub najst podla textu ktory ste k nemu zadali a ktory sa nastastie zachoval. V pripade ze ho nedopatrenim dostal do ruk niekto ini, napiste mu nech vam ho odovzda. Robi sa to jednoducho - prepisanim mena majitela v polozke \"zmen nastavenie\" v danom fore. <b>Takisto prosim umiestnite forum do prislusnej kategorie.</b>. Dakujem & pardonne moi.</font>"; | |
173 | echo "<br><br>"; | |
174 | } | |
175 | ||
176 | //precaching objects for category tree | |
177 | $q="SELECT user.login,category.* from category left join user on category.category_owner=user.id where category_parent=0"; | |
178 | $q.=" order by concat(category_name,category_parent) "; | |
179 | $subset[0]=$kyberia->query($q); | |
180 | foreach ($kat as $subkat) { | |
181 | $q="SELECT user.login,category.* from category left join user on category.category_owner=user.id where category_parent=$subkat"; | |
182 | $q.=" order by category_name "; | |
183 | $subset[$subkat]=$kyberia->query($q); | |
184 | } | |
185 | ||
186 | //recursive category tree bitch | |
187 | showContent($subset,$kat); | |
188 | ||
189 | if (count($_GET[kat])<1) { | |
190 | ?> | |
191 | <br><br><center><b>najnovsie kluby</b></center> | |
192 | <?php | |
193 | $q="SELECT user_forum.submission_count,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')"; | |
194 | $q.=" where forum_public='public' or forum_public='moderated'"; | |
195 | $q.=" order by forum_id desc limit 10 "; | |
196 | $forumset=$kyberia->query($q); | |
197 | while ($forumset->next()) { | |
198 | echo "<a href='?action=forum&node_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a>(".$forumset->getString('login')." :: ".$forumset->getString('forum_submissions')." submissionz "; | |
199 | if ($forumset->getString('submission_count')) echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>"; | |
200 | echo ")<br>"; | |
201 | } | |
202 | ||
203 | ?> | |
204 | <br><br><center><b>najnovsie denniky</b></center> | |
205 | <?php | |
206 | $q="SELECT user_discussion.submission_count as new,dennik.id as id,dennik.nadpis as nadpis,dennik.hits,dennik.prispevky,user.login from dennik left join user on dennik.autor=user.id left join user_discussion on (user_discussion.discussion_id=dennik.id_diskuse and user_id='$user_id')"; | |
207 | $q.=" order by dennik.id desc limit 10 "; | |
208 | //echo $q; | |
209 | $forumset=$kyberia->query($q); | |
210 | while ($forumset->next()) { | |
211 | echo "<a href='?action=journaux&node_id=",$forumset->getString('id'),"'>",$forumset->getString('nadpis'),"</a>(".$forumset->getString('login')." :: ".$forumset->getString('hits')." hitz "; | |
212 | echo "->",$forumset->getString('prispevky'),"submissions"; | |
213 | if ($forumset->getString('new')) echo " - <font color='red'>".$forumset->getString('new')." NEW</font>"; | |
214 | echo ")<br>"; | |
215 | } | |
216 | ||
217 | } | |
218 | } | |
219 | if (AD_BANNER_FORUMLIST) { echo AD_BANNER_FORUMLIST; } | |
220 | ?> |