[ PHPXref.com ] [ Generated: Sun Jul 20 17:05:41 2008 ] [ Coppermine 1.4.5 ]
[ Index ]     [ Variables ]     [ Functions ]     [ Classes ]     [ Constants ]     [ Statistics ]

title

Body

[close]

/ -> upgrade-1.0-to-1.2.php (source)

   1  <?php
   2  /*************************

   3    Coppermine Photo Gallery

   4    ************************

   5    Copyright (c) 2003-2006 Coppermine Dev Team

   6    v1.1 originally written by Gregory DEMAR

   7  

   8    This program is free software; you can redistribute it and/or modify

   9    it under the terms of the GNU General Public License as published by

  10    the Free Software Foundation; either version 2 of the License, or

  11    (at your option) any later version.

  12    ********************************************

  13    Coppermine version: 1.4.5

  14    $Source: /cvsroot/coppermine/stable/upgrade-1.0-to-1.2.php,v $

  15    $Revision: 1.14 $

  16    $Author: gaugau $

  17    $Date: 2006/03/02 08:17:43 $

  18  **********************************************/
  19  
  20  define('IN_COPPERMINE', true);
  21  define('ADMIN_PHP', true);
  22  
  23  require  "include/init.inc.php";
  24  
  25  if (!GALLERY_ADMIN_MODE) cpg_die(ERROR, $lang_errors['access_denied'], __FILE__, __LINE__);
  26  
  27  $db10 = ""; // DB in which Coppermine 1.0 tables resides (leave blank is same DB as v1.2)

  28  $prefix10 = "CPG_"; // The prefix used for the Coppermine 1.0 tables

  29  $prefix10 = ($db10 ? $db10 . '.' : '') . $prefix10;
  30  
  31  $CPG_pictures = $prefix10 . "pictures";
  32  $CPG_albums = $prefix10 . "albums";
  33  $CPG_comments = $prefix10 . "comments";
  34  
  35  $cpg11_pictures = $CONFIG['TABLE_PICTURES'];
  36  $cpg11_albums = $CONFIG['TABLE_ALBUMS'];
  37  $cpg11_comments = $CONFIG['TABLE_COMMENTS'];
  38  
  39  echo "Upgrading Coppermine 1.0 tables to 1.1<br />";
  40  echo "Prefix used for 1.0 tables : $prefix10<br /><br />";
  41  // Upgrade for the picture table

  42  $sql = "INSERT INTO $cpg11_pictures " . "(approved, pid, aid, caption, filepath, filename, filesize, pwidth, pheight, hits, mtime," . " ctime) " . "SELECT 'yes' as approved, p.pid, aid, msg_body AS caption, filepath, filename, filesize, " . "pwidth, pheight, hits, mtime, UNIX_TIMESTAMP(ctime)" . "FROM $CPG_pictures AS p " . "LEFT JOIN $CPG_comments AS c ON p.caption = c.msg_id ";
  43  cpg_db_query($sql);
  44  echo "Picture table upgraded<br />";
  45  // Get the list of comments that are used a image captions

  46  $sql = "SELECT msg_id FROM $CPG_pictures AS p, $CPG_comments AS c " . "WHERE p.caption = c.msg_id";
  47  $result = cpg_db_query($sql);
  48  $msg_id_set = '';
  49  if ((mysql_num_rows($result))) {
  50      $set = '';
  51      while ($comment = mysql_fetch_array($result)) {
  52          $set .= $comment['msg_id'] . ',';
  53      } // while

  54      $msg_id_set = 'AND msg_id NOT IN (' . substr($set, 0, -1) . ') ';
  55  }
  56  mysql_free_result($result);
  57  // Upgrade the comment table

  58  $sql = "INSERT INTO $cpg11_comments " . "(pid, msg_id, msg_author, msg_body, msg_date)" . "SELECT pid, msg_id, msg_author, msg_body, msg_date " . "FROM $CPG_comments " . "WHERE 1 $msg_id_set";
  59  cpg_db_query($sql);
  60  echo "Comment table upgraded<br />";
  61  // Upgrade the album table

  62  $sql = "INSERT INTO $cpg11_albums " . "(aid, title, description, uploads, pos)" . "SELECT aid, title, description, uploads, UNIX_TIMESTAMP(date) " . "FROM $CPG_albums";
  63  cpg_db_query($sql);
  64  echo "Album table upgraded<br />";
  65  echo "<br />First step of upgrade completed!<br />";
  66  
  67  echo "<a href='update.php'>Click Here</a> to complete the 1.2 upgrade.</P>";
  68  
  69  ?>


[ Powered by PHPXref - Served by Debian GNU/Linux ]