boxiky/admin/forum_admin.inc

   1
   2
   3 <table><form method='post'>
   4 <tr><td>owner::</td><td><input type='text' name='forum_owner'></td></tr>
   5 <tr><td>nazov fora::</td><td><input type='text' name='forum_text'></td></tr>
   6 <tr><td>zorad podla::</td><td><select name='forum_order'>
   7 <option value='id_asc'>id fora vzostupne (najstarsie)</option>
   8 <option value='id_desc'>id fora zostupne (najnovsie)</option>
   9 <option value='last_submission'>najstarsieho casu posledneho prispevku </option>
  10 <option value='last_owner_access'>najstarsieho pristupu ownera do fora</option>
  11 <option value='submission_count_asc'>poctu prispevkov vzostupne </option>
  12 <option value='submission_count_desc'>poctu prispevkov zostupne </option>
  13 </td></tr>
  14 <tr><td valign='top'>kategoria::</td><td valign='top'>
  15 <?php
  16 $set=$kyberia->query("select * from category order by category_tree");
  17 $selectstring="<select name='forum_category'>";
  18 $selectstring.="<option value='all'>vsetky kategorie</option>";
  19 while ($set->next()) {
  20         $count=substr_count($set->getString('category_tree'),";");
  21         $selectstring.="<option value='".$set->getString('category_id')."'";
  22         if ($forum['forum_category']==$set->getString('category_id')) $selectstring.= " selected ";
  23         $selectstring.= ">";
  24         if ($count) {
  25                 $selectstring.="|";
  26                 for ($i=0;$i<$count;$i++) $selectstring.="----";
  27         }
  28         $selectstring.=$set->getString('category_name')."</option>";
  29 }
  30 $selectstring.="</select>";
  31 echo $selectstring;
  32 ?>
  33 </td></tr><td><td colspan='2' align='center'><input type='submit' name='forum_list' value='list'></tr>
  34 </form></table>
  35 <br><br>
  36 <?php
  37
  38 if (!empty($_POST['forum_list'])) {
  39         $q="select * from forum left join category on forum.forum_category=category.category_id left join user_forum as owner_access on (forum.forum_id=owner_access.forum_id and forum.forum_owner=owner_access.user_id) where 1=1 ";
  40     if (!empty($_POST['forum_owner'])) {
  41         $forum_owner=$_POST['forum_owner'];
  42         if (!Is_numeric($forum_owner)) {
  43                 $set=$kyberia->query("select id from user where login='$forum_owner'");
  44                 $set->next();
  45
  46             $forum_owner_id=$set->getString('id');
  47         }
  48         else $forum_owner_id=$forum_owner;
  49         $q.=" and forum_owner='$forum_owner_id' ";
  50         }
  51
  52     if (!empty($_POST['forum_text'])) {
  53         $q.=" and forum_name like '%".$_POST['forum_text']."%' ";
  54         }
  55
  56     if ($_POST['forum_category']!='all') {
  57         $forum_category=$_POST['forum_category'].";";
  58         $q.="and category_tree like '$forum_category' ";
  59     }
  60
  61    $forum_order=$_POST['forum_order'];
  62     if ($forum_order=="id_desc") {
  63         $q.="order by forum.forum_id desc";
  64     }
  65         if ($forum_order=="id_asc") {
  66         $q.="order by forum.forum_id asc";
  67     }
  68         if ($forum_order=="last_owner_access") {
  69         $q.="order by owner_access.last_visit asc";
  70     }
  71
  72         if ($forum_order=="last_submission") {
  73         $q.="order by last_submission asc";
  74     }
  75         if ($forum_order=="submission_count_asc") {
  76         $q.="order by submission_count asc";
  77     }
  78     if ($forum_order=="submission_count_desc") {
  79         $q.="order by submission_count desc";
  80     }
  81     echo $q;
  82     $set=$kyberia->query($q);
  83
  84     while($set->next()) {
  85         echo "forum::".$set->getString('forum_name')."<br>";
  86         echo "owner::".$set->getString('forum_owner')."<br>";
  87         echo "pocet prispevkov::".$set->getString('forum_submissions')."<Br>";
  88         echo "posledny prispevok::".$set->getString('last_submission')."<br>";
  89         echo "ownerova posledna navsteva fora::".$set->getString('owner_access.last_visit')."<br>";
  90
  91         echo "<br><br>";
  92     }
  93
  94 }
  95
  96 ?>