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