<?php
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filename: search_news_include.php
| Author: Robert Gaudyn (Wooya)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licen... Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
if (!defined("IN_FUSION")) { die("Access Denied"); }

include LOCALE.LOCALESET."search/news.php";

if ($_GET['stype'] == "news" || $_GET['stype'] == "all") {
   if ($_GET['sort'] == "datestamp") {
      $sortby = "filmai_date";
   } else if ($_GET['sort'] == "subject") {
      $sortby = "filmai_pav";
   } else if ($_GET['sort'] == "author") {
      $sortby = "news_name";
   }
   $ssubject = search_querylike("filmai_pav");
   $smessage = search_querylike("filmai_apr");
   $sextended = search_querylike("filmai_kat0");
   if ($_GET['fields'] == 0) {
      $fieldsvar = search_fieldsvar($ssubject);
   } else if ($_GET['fields'] == 1) {
      $fieldsvar = search_fieldsvar($smessage, $sextended);
   } else if ($_GET['fields'] == 2) {
      $fieldsvar = search_fieldsvar($ssubject, $smessage, $sextended);
   } else {
      $fieldsvar = "";
   }
   if ($fieldsvar) {
      $result = dbquery("SELECT * FROM ".DB_PREFIX."filmai WHERE ".$fieldsvar);   
      $rows = dbrows($result);
   } else {
      $rows = 0;
   }
   if ($rows != 0) {
      $items_count .= THEME_BULLET."&nbsp;<a href='".FUSION_SELF."?stype=news&stext=".$_GET['stext']."&".$composevars."'>".$rows." ".($rows == 1 ? $locale['n401'] : $locale['n402'])." ".$locale['522']."</a><br />\n";
      $result = dbquery(
         "SELECT * FROM ".DB_PREFIX."filmai tn
         WHERE ".$fieldsvar." ORDER BY ".$sortby." ".($_GET['order'] == 1 ? "ASC" : "DESC").($_GET['stype'] != "all" ? " LIMIT ".$_GET['rowstart'].",10" : "")
      );
      while ($data = dbarray($result)) {
         $search_result = "";
         $text_all = $data['filmai_apr']." ".$data['filmai_kat0'];
         $text_all = search_striphtmlbbcodes($text_all);
         $text_frag = search_textfrag($text_all);
         // $text_frag = highlight_words($swords, $text_frag);
         $subj_c = search_stringscount($data['filmai_pav']);
         $text_c = search_stringscount($data['filmai_apr']);
         $text_c2 = search_stringscount($data['filmai_kat0']);

         $search_result .= "<a href='".BASEDIR."filmai.php?filmas_id=".$data['filmai_id']."'>".$data['filmai_pav']."</a>"."<br /><br />\n";

         // $search_result .= "<a href='news.php?readmore=".$data['filmai_id']."'>".highlight_words($swords, $data['filmai_pav'])."</a>"."<br /><br />\n";
         $search_result .= "<div class='quote' style='width:auto;height:auto;overflow:auto'>".$text_frag."</div><br />";
         $search_result .= "<span class='small2'>".$locale['global_070'].$data['filmai_kalba']."\n";
         $search_result .= $locale['global_071'].$data['filmai_metai']."</span><br />\n";
         $search_result .= "<span class='small'>".$subj_c." ".($subj_c == 1 ? $locale['520'] : $locale['521'])." ".$locale['n403']." ".$locale['n404'].", ";
         $search_result .= $text_c." ".($text_c == 1 ? $locale['520'] : $locale['521'])." ".$locale['n403']." ".$locale['n405'].", ";
         $search_result .= $text_c2." ".($text_c2 == 1 ? $locale['520'] : $locale['521'])." ".$locale['n403']." ".$locale['n406']."</span><br /><br />\n";
         search_globalarray($search_result);
      }
   } else {
      $items_count .= THEME_BULLET."&nbsp;0 ".$locale['n402']." ".$locale['522']."<br />\n";
   }
   $navigation_result = search_navigation($rows);
}
?>