[Sommaire] [Imprimer]

   1  <?php
   2  
   3  //$doupgrade = false;
   4  
   5  /*
   6  $query = "SELECT version from ".$config["db_prefix"]."version";
   7  $result = $db->query($query);
   8  while($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
   9      if ($row["version"] == $current_version) {
  10          $doupgrade = true;
  11      }
  12  }
  13  mysql_free_result($result);
  14  
  15  if ($doupgrade) {
  16  */
  17  
  18      echo "<p>Added item_order to existing items... ";
  19  
  20      $count = 1;
  21      $oldsection_id = -1;
  22      $query = "SELECT page_id, section_id FROM ".$config["db_prefix"]."pages ORDER BY section_id, page_title";
  23      $result = $db->Execute($query);
  24  
  25      #foreach loop
  26      if ($result)
  27      {
  28          while($row = $result->FetchRow()) {
  29              if ($oldsection_id != $row["section_id"]) {
  30                  $oldsection_id = $row["section_id"];
  31                  $count = 1;
  32              }
  33              $query = "UPDATE ".$config["db_prefix"]."pages SET item_order = $count WHERE page_id = " . $row["page_id"];
  34              $db->Execute($query);
  35  
  36              $count++;
  37          }
  38      }
  39  
  40      echo "[done]</p>";
  41  
  42      echo "<p>Creating additional_users table... ";
  43  
  44      $query  = "CREATE TABLE ".$config["db_prefix"]."additional_users (";
  45      $query .= "  additional_users_id int(11) NOT NULL auto_increment,";
  46      $query .= "  user_id int(11) default NULL,";
  47      $query .= "  page_id int(11) default NULL,";
  48      $query .= "  PRIMARY KEY (additional_users_id)";
  49      $query .= ") TYPE=MyISAM";
  50  
  51      $db->Execute($query);
  52  
  53      echo "[done]</p>";
  54  
  55      echo "<p>Updating schema version... ";
  56  
  57      $query = "UPDATE ".$config["db_prefix"]."version SET version = 2";
  58      $db->Execute($query);
  59  
  60      echo "[done]</p>";
  61  //}
  62  
  63  # vim:ts=4 sw=4 noet
  64  ?>