boxiky/admin/forums.inc

   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 ?>