[Sommaire] [Imprimer]

   1  <?php
   2  /*
   3  + ----------------------------------------------------------------------------+
   4  |     e107 website system
   5  |
   6  |     ©Steve Dunstan 2001-2002
   7  |     http://e107.org
   8  |     jalist@e107.org
   9  |
  10  |     Released under the terms and conditions of the
  11  |     GNU General Public License (http://gnu.org).
  12  |
  13  |     $Source: /cvsroot/e107/e107_0.7/e107_handlers/search/search_event.php,v $
  14  |     $Revision: 1.5 $
  15  |     $Date: 2005/12/28 14:50:24 $
  16  |     $Author: sweetas $
  17  +----------------------------------------------------------------------------+
  18  */
  19      
  20  if (!defined('e107_INIT')) { exit; }
  21  
  22  $query = $tp -> toDB($query);
  23  $results = $sql->db_Select("event", "*", "event_stake REGEXP('".$query."') OR event_ward REGEXP('".$query."') OR event_organisation REGEXP('".$query."') OR event_title REGEXP('".$query."')
  24      OR event_location REGEXP('".$query."') OR event_details REGEXP('".$query."') OR event_thread REGEXP('".$query."') ");
  25  while (list($event_id, $event_stake, $event_ward, $event_organisation, $event_start, $event_end, $event_allday, , , $event_title, $event_location, $event_details, $event_author, $event_contact, $event_category, $event_url ) = $sql->db_Fetch()) {
  26       
  27      $sql2->db_select("event_cat", "event_cat_name, event_cat_icon", "event_cat_id='".$event_category."' ");
  28      list($event_cat_name, $event_cat_icon ) = $sql2->db_Fetch();
  29       
  30      $event_stake_ = parsesearch($event_stake, $query);
  31      if (!$event_stake_) {
  32          $event_stake_ = $event_stake;
  33      }
  34       
  35      $event_ward_ = parsesearch($event_ward, $query);
  36      if (!$event_ward_) {
  37          $event_ward_ = $event_ward;
  38      }
  39       
  40      $event_organisation_ = parsesearch($event_organisation, $query);
  41      if (!$event_organisation_) {
  42          $event_organisation_ = $event_organisation;
  43      }
  44       
  45      $event_title_ = parsesearch($event_title, $query);
  46      if (!$event_title_) {
  47          $event_title_ = $event_title;
  48      }
  49       
  50      $event_details_ = parsesearch($event_details, $query);
  51      if (!$event_details_) {
  52          $event_details_ = $event_details;
  53      }
  54       
  55      $event_cat_name_ = parsesearch($event_cat_name, $query);
  56      if (!$event_cat_name_) {
  57          $event_cat_name_ = $event_cat_name;
  58      }
  59      $event_threat_ = parsesearch($event_threat, $query);
  60      if (!$event_url_) {
  61          $event_threat_ = $event_threat;
  62      }
  63      $text .= "<img src='".THEME_ABS."images/bullet2.gif' alt='bullet' /> <a href=\"event.php?".$event_start."\">{$event_title}</a>{$event_details}<br />";
  64  }
  65  $qtype = LAN_911;
  66  ?>