[Sommaire] [Imprimer]

   1  <?php
   2  if (!isset($gCms)) exit;
   3  
   4  if ($oldversion == '1.0')
   5  {
   6      $this->CreateEvent('SearchInitiated');
   7      $this->CreateEvent('SearchCompleted');
   8      $this->CreateEvent('SearchItemAdded');
   9      $this->CreateEvent('SearchItemDeleted');
  10      $this->CreateEvent('SearchAllItemsDeleted');
  11  
  12      $this->RegisterEvents();
  13  
  14      $oldversion = '1.0.1';
  15  }
  16  
  17  if ($oldversion = '1.0.1')
  18  {
  19      $this->SetTemplate('displaysearch', $this->GetSearchHtmlTemplate());
  20      $this->SetTemplate('displayresult', $this->GetResultsHtmlTemplate());
  21  
  22      $oldversion = '1.0.2';
  23  }
  24  
  25  if ($oldversion = '1.0.2')
  26  {
  27      $this->AddEventHandler('Core','ModuleUninstalled',false);
  28      $this->SetPreference('searchtext','Enter Search...');
  29      $oldversion = '1.0.3';
  30  }
  31  
  32  if ($oldversion = '1.0.3')
  33  {
  34      $oldversion = '1.0.4';
  35  }
  36  
  37  if ($oldversion = '1.0.4')
  38  {
  39      $db =& $this->GetDb();
  40      $dict = NewDataDictionary($db);
  41  
  42      $sqlarray = $dict->DropTableSQL(cms_db_prefix().'module_search_items');
  43      $dict->ExecuteSQLArray($sqlarray);
  44      $db->DropSequence(cms_db_prefix().'module_search_items_seq');    
  45      
  46      $flds= "
  47              id I KEY,
  48              module_name C(100),
  49              content_id I,
  50              extra_attr C(100),
  51              expires " . CMS_ADODB_DT;
  52  
  53      $taboptarray = array('mysql' => 'TYPE=MyISAM');
  54      $sqlarray = $dict->CreateTableSQL(cms_db_prefix().'module_search_items', $flds, $taboptarray);
  55      $dict->ExecuteSQLArray($sqlarray);
  56  
  57      $db->CreateSequence(cms_db_prefix()."module_search_items_seq");
  58  
  59      $sqlarray = $dict->CreateIndexSQL('module_name', cms_db_prefix()."module_search_items", 'module_name');
  60      $dict->ExecuteSQLArray($sqlarray);
  61  
  62      $sqlarray = $dict->CreateIndexSQL('content_id', cms_db_prefix()."module_search_items", 'content_id');
  63      $dict->ExecuteSQLArray($sqlarray);
  64  
  65      $sqlarray = $dict->CreateIndexSQL('extra_attr', cms_db_prefix()."module_search_items", 'extra_attr');
  66      $dict->ExecuteSQLArray($sqlarray);
  67  
  68  
  69      $sqlarray = $dict->DropTableSQL(cms_db_prefix().'module_search_index');
  70      $dict->ExecuteSQLArray($sqlarray);
  71  
  72      $flds= "
  73              item_id I,
  74              word C(255),
  75              count I
  76          ";
  77  
  78      $taboptarray = array('mysql' => 'TYPE=MyISAM');
  79      $sqlarray = $dict->CreateTableSQL(cms_db_prefix().'module_search_index', $flds, $taboptarray);
  80      $dict->ExecuteSQLArray($sqlarray);
  81  
  82      $sqlarray = $dict->CreateIndexSQL('count', cms_db_prefix()."module_search_index", 'count');
  83      $dict->ExecuteSQLArray($sqlarray);
  84      
  85      $oldversion = '1.1';
  86  }
  87  
  88  $this->Reindex();
  89  
  90  ?>