| 1 | <?php |
| 2 | $set=$kyberia->query("select * from category order by category_tree"); |
| 3 | $selectstring="<select name='forum_category'>"; |
| 4 | while ($set->next()) { |
| 5 | $count=substr_count($set->getString('category_tree'),";"); |
| 6 | $selectstring.="<option value='".$set->getString('category_id')."'>"; |
| 7 | if ($count) { |
| 8 | $selectstring.="|"; |
| 9 | for ($i=0;$i<$count;$i++) $selectstring.="----"; |
| 10 | } |
| 11 | $selectstring.=$set->getString('category_name')."</option>"; |
| 12 | } |
| 13 | $selectstring.="</select>"; |
| 14 | |
| 15 | $set=$kyberia->query("select user.login as login,forum.forum_name,forum_info.* from forum_info left join forum on forum_info.forum_id=forum.forum_id left join user on user.id=forum.forum_owner where forum_info.forum_id>500 order by forum_id"); |
| 16 | |
| 17 | echo "<table>"; |
| 18 | while ($set->next()) { |
| 19 | echo "<form action='".SCRIPT."?action=admin' method='post'>"; |
| 20 | echo "<tr>"; |
| 21 | echo "<td valign='top'><input type='text' name='forum_id' value='",$set->getString('forum_id'),"'></td>"; |
| 22 | echo "<td valign='top'><input class='longtext' type='text' name='forum_name' value='",$set->getString('forum_name'),"'></td>"; |
| 23 | |
| 24 | echo "<td valign='top'><input type='text' name='forum_owner' value='",$set->getString('login'),"'></td>"; |
| 25 | echo "<td valign='top'>",strip_tags($set->getString('forum_info')),"'></td>"; |
| 26 | echo "<td>",$set->getString('forum_submissions'),"</td>"; |
| 27 | echo "<td>"; |
| 28 | // if ($set->getString('forum_category')=='' )echo "$selectstring"; |
| 29 | echo "</td>"; |
| 30 | echo "<td><input type='submit' name='event' value='update forum'><input type='hidden' name='forum_id' value='".$set->getString('forum_id')."'>"; |
| 31 | echo "</tr>"; |
| 32 | echo "</form>"; |
| 33 | } |
| 34 | |
| 35 | echo "</table>"; |
| 36 | ?> |