[Sommaire] [Imprimer]

   1  <?php
   2  if (!isset($gCms)) exit;
   3  
   4  $db =& $this->GetDb();
   5  
   6  $db_prefix = cms_db_prefix();
   7  $dict = NewDataDictionary($db);
   8  $flds= "
   9          id I KEY,
  10          module_name C(100),
  11          content_id I,
  12          extra_attr C(100),
  13          expires " . CMS_ADODB_DT;
  14  
  15  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  16  $sqlarray = $dict->CreateTableSQL(cms_db_prefix().'module_search_items', $flds, $taboptarray);
  17  $dict->ExecuteSQLArray($sqlarray);
  18  
  19  $db->CreateSequence(cms_db_prefix()."module_search_items_seq");
  20  
  21  $sqlarray = $dict->CreateIndexSQL('module_name', $db_prefix."module_search_items", 'module_name');
  22  $dict->ExecuteSQLArray($sqlarray);
  23      
  24  $sqlarray = $dict->CreateIndexSQL('content_id', $db_prefix."module_search_items", 'content_id');
  25  $dict->ExecuteSQLArray($sqlarray);
  26      
  27  $sqlarray = $dict->CreateIndexSQL('extra_attr', $db_prefix."module_search_items", 'extra_attr');
  28  $dict->ExecuteSQLArray($sqlarray);
  29  
  30  $flds= "
  31          item_id I,
  32          word C(255),
  33          count I
  34      ";
  35  
  36  $taboptarray = array('mysql' => 'TYPE=MyISAM');
  37  $sqlarray = $dict->CreateTableSQL(cms_db_prefix().'module_search_index', $flds, $taboptarray);
  38  $dict->ExecuteSQLArray($sqlarray);
  39  
  40  $sqlarray = $dict->CreateIndexSQL('count', $db_prefix."module_search_index", 'count');
  41  $dict->ExecuteSQLArray($sqlarray);
  42      
  43  $this->SetPreference('stopwords', $this->DefaultStopWords());
  44  $this->SetPreference('usestemming', 'false');
  45  $this->SetPreference('searchtext','Enter Search...');
  46      
  47  $this->SetTemplate('displaysearch', $this->GetSearchHtmlTemplate());
  48  $this->SetTemplate('displayresult', $this->GetResultsHtmlTemplate());
  49      
  50  $this->CreateEvent('SearchInitiated');
  51  $this->CreateEvent('SearchCompleted');
  52  $this->CreateEvent('SearchItemAdded');
  53  $this->CreateEvent('SearchItemDeleted');
  54  $this->CreateEvent('SearchAllItemsDeleted');
  55      
  56  $this->RegisterEvents();
  57  
  58  $this->Reindex();
  59  
  60  ?>