Commit | Line | Data |
---|---|---|
bc13d5d6 H |
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 | ?> |