Commit | Line | Data |
---|---|---|
bc13d5d6 H |
1 | <?php |
2 | if ($_POST['type']=='forum') { | |
3 | echo "<br><center><b>na.na.na.siel[siel{siel}] som tieto fora</b></center>"; | |
4 | $q="SELECT forum_info.forum_info,user_forum.submission_count,user.login,forum.* from forum left join forum_info on forum_info.forum_id=forum.forum_id left join user on forum.forum_owner=user.id left join user_forum on (forum.forum_id=user_forum.forum_id and user_forum.user_id='$user_id')"; | |
5 | $q.=" where (forum_name like '%$query%' or forum_info like '%$query%')"; | |
6 | $q.=" order by forum_id desc "; | |
7 | $forumset=$kyberia->query($q); | |
8 | while ($forumset->next()) { | |
9 | echo "<br><a href='?action=forum&node_id=",$forumset->getString('forum_id'),"'>",$forumset->getString('forum_name'),"</a><br>(".$forumset->getString('login')." :: ".$forumset->getString('forum_submissions')." submissionz "; | |
10 | if ($forumset->getString('submission_count')) echo "- <font color='red'>".$forumset->getString('submission_count')." NEW</font>"; | |
11 | echo ")<br>"; | |
12 | } | |
13 | } | |
14 | ||
15 | elseif ($_POST['type']=='user') { | |
16 | $q="SELECT * from user"; | |
17 | $q.=" where login like '%$query%'"; | |
18 | $q.=" order by login"; | |
19 | $forumset=$kyberia->query($q); | |
20 | echo "<br><center><b>na.na.na.siel[siel{siel}] som tychto u.u.uzivatelov</b></center>"; | |
21 | while ($forumset->next()) { | |
22 | echo "<br><a href='?action=userinfo&node_id=",$forumset->getString('id'),"'>",$forumset->getString('login'),"</a>"; | |
23 | } | |
24 | } | |
25 | ||
26 | elseif ($_POST['type']=='journaux') { | |
27 | $q="SELECT dennik.*,user.login from dennik left join user on user.id=dennik.autor"; | |
28 | $q.=" where nadpis like '%$query%'"; | |
29 | $q.=" order by id desc"; | |
30 | $dennikset1=$kyberia->query($q); | |
31 | if ($dennikset1->getNumRows()) { | |
32 | echo "<br><center><b>\"$query\" sa vyskytuje v nadpisoch tychto dennikov</b></center>"; | |
33 | while ($dennikset1->next()) { | |
34 | echo "<br><a href='?action=journaux&node_id=",$dennikset1->getString('id'),"'>",$dennikset1->getString('nadpis'),"</a> (",$dennikset1->getString('login')," :: ",$dennikset1->getString('hits')," hitz )"; | |
35 | } | |
36 | } | |
37 | ||
38 | $q="SELECT dennik.*,user.login from dennik left join user on user.id=dennik.autor"; | |
39 | $q.=" where zapis like '%$query%'"; | |
40 | $q.=" order by id desc"; | |
41 | ||
42 | $dennikset2=$kyberia->query($q); | |
43 | if ($dennikset2->getNumRows()) { | |
44 | echo "<br><center><b>\"$query\" sa vyskytuje v texte tychto dennikov</b></center>"; | |
45 | while ($dennikset2->next()) { | |
46 | echo "<br><a href='?action=journaux&node_id=",$dennikset2->getString('id'),"'>",$dennikset2->getString('nadpis'),"</a> (",$dennikset2->getString('login')," :: ",$dennikset2->getString('hits')," hitz )"; | |
47 | } | |
48 | } | |
49 | ||
50 | } | |
51 | ||
52 | if ($_POST['type']=='article') { | |
53 | if ($query=="") echo "<center><br>Nezadali ste ziadne slovo na vyhladavanie!!<br><br><br></center>"; | |
54 | else { $clanky=$kyberia->Search($query); | |
55 | if ($clanky->_numRows==0) echo "<br><center><br>Zadane slovo $query sa nevyskytuje v ziadnom clanku!</center><br>"; | |
56 | else { | |
57 | echo "<br><center><br>Slovo $query sa vyskytuje v ",$clanky->_numRows,". clankoch!<br><br></center>"; | |
58 | while ($clanky->next()) { | |
59 | echo "<table cellpadding=5 width=100% class=box>"; | |
60 | echo "<tr><td><img src='"; | |
61 | if ($clanky->getString('title_image')=="") echo "/images/rubriky/",$kyberia->putTitleImage($clanky->getInt("id_rubrika")); | |
62 | else echo $kyberia->TitleImageDir.$clanky->getString('title_image'); | |
63 | echo "' hspace=5 vspace=5 align=left>"; | |
64 | echo "<a class=nazev href='".SCRIPT."?action=article&id=",$clanky->getString("id_article"),"'>",$clanky->getString('nazov'),"</a><br>"; | |
65 | echo $clanky->getString('short_desc'); | |
66 | echo "</td></tr></table><br>"; | |
67 | } | |
68 | } | |
69 | } | |
70 | } | |
71 | ?> |