GIT.Harvie.CZ / mirrors / Kyberia-bloodline.git / blame
| 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 | ?> |