boxiky/searchforum.inc

   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')."&nbsp;&nbsp;::&nbsp;&nbsp;".$forumset->getString('forum_submissions')."&nbsp;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 ?>