[Sommaire] [Imprimer]

   1  <?php
   2  if (!isset($gCms)) exit;
   3  
   4  $current_version = $oldversion;
   5  $db =& $this->GetDb();
   6  
   7  switch($current_version)
   8  {
   9      case "1.0":
  10          $dict = NewDataDictionary($db);
  11          $sqlarray = $dict->AddColumnSQL(cms_db_prefix()."module_news", "start_time " . CMS_ADODB_DT . ", end_time " . CMS_ADODB_DT . ", icon C(255)");
  12          $dict->ExecuteSQLArray($sqlarray);
  13          $current_version = "1.1";
  14      case "1.1":
  15      case "1.2":
  16      case "1.3":
  17      case "1.4":
  18      case "1.5":
  19          $dict = NewDataDictionary($db);
  20          $sqlarray = $dict->AddColumnSQL(cms_db_prefix()."module_news", "news_cat C(255)");
  21          $dict->ExecuteSQLArray($sqlarray);
  22          $current_version = "1.6";
  23      case "1.6":
  24          $this->SetTemplate('displaysummary', $this->GetSummaryHtmlTemplate());
  25          $this->SetTemplate('displaydetail', $this->GetDetailHtmlTemplate());
  26  
  27          $current_version = "1.7";
  28      case '1.7':
  29          #Makey new tables....
  30  
  31          $dict = NewDataDictionary($db);
  32          $sqlarray = $dict->AddColumnSQL(cms_db_prefix()."module_news", "status C(25)");
  33          $dict->ExecuteSQLArray($sqlarray);
  34  
  35          $sqlarray = $dict->AddColumnSQL(cms_db_prefix()."module_news", "summary X");
  36          $dict->ExecuteSQLArray($sqlarray);
  37  
  38          $sqlarray = $dict->AddColumnSQL(cms_db_prefix()."module_news", "news_category_id I");
  39          $dict->ExecuteSQLArray($sqlarray);
  40  
  41          $query = "UPDATE ".cms_db_prefix()."module_news SET summary = ?, status = ?";
  42          $db->Execute($query, array('', 'published'));
  43  
  44          $flds = "
  45              news_category_id I KEY,
  46              news_category_name C(255),
  47              parent_id I,
  48              hierarchy C(255),
  49              long_name X,
  50              create_date " . CMS_ADODB_DT . ",
  51              modified_date " . CMS_ADODB_DT
  52          ;
  53          $dict = NewDataDictionary($db);
  54  
  55          $taboptarray = array('mysql' => 'TYPE=MyISAM');
  56          $sqlarray = $dict->CreateTableSQL(cms_db_prefix()."module_news_categories", 
  57                  $flds, $taboptarray);
  58          $dict->ExecuteSQLArray($sqlarray);
  59  
  60          $db->CreateSequence(cms_db_prefix()."module_news_categories_seq");
  61  
  62          $query = "SELECT DISTINCT news_cat FROM ".cms_db_prefix()."module_news WHERE news_cat IS NOT NULL";
  63          $dbresult = $db->Execute($query);
  64          while ($dbresult && $row = $dbresult->FetchRow())
  65          {
  66              $catid = $db->GenID(cms_db_prefix()."module_news_categories_seq");
  67              $query = "INSERT INTO ".cms_db_prefix()."module_news_categories (news_category_id, news_category_name, parent_id, hierarchy, long_name, create_date, modified_date) VALUES (?,?,?,?,?,".$db->DBTimeStamp(time()).",".$db->DBTimeStamp(time()).")";
  68              $db->Execute($query,array($catid, $row['news_cat'], -1, '', ''));
  69  
  70              $query = "UPDATE ".cms_db_prefix()."module_news SET news_category_id = ? WHERE news_cat = ?";
  71              $db->Execute($query, array($catid, $row['news_cat']));
  72          }
  73  
  74          # Setup summary template
  75          $this->SetTemplate('displaysummary', $this->GetSummaryHtmlTemplate());
  76  
  77          # Setup detail template
  78          $this->SetTemplate('displaydetail', $this->GetDetailHtmlTemplate());
  79  
  80          $this->UpdateHierarchyPositions();
  81  
  82          $current_version = "2.0";
  83  
  84      case '2.0':
  85      case '2.0.1':
  86      case '2.0.2':
  87          $dict = NewDataDictionary($db);
  88          $sqlarray = $dict->AddColumnSQL(cms_db_prefix()."module_news", "author_id I");
  89          $dict->ExecuteSQLArray($sqlarray);
  90          $current_version = "2.0.3";
  91      case '2.0.3':
  92          #Setup events
  93          $this->CreateEvent('NewsArticleAdded');
  94          $this->CreateEvent('NewsArticleEdited');
  95          $this->CreateEvent('NewsArticleDeleted');
  96          $this->CreateEvent('NewsCategoryAdded');
  97          $this->CreateEvent('NewsCategoryEdited');
  98          $this->CreateEvent('NewsCategoryDeleted');
  99          $current_version = '2.1';
 100  }
 101  
 102  ?>