diff options
Diffstat (limited to 'BSF/upgrade_feed.php')
| -rw-r--r-- | BSF/upgrade_feed.php | 93 |
1 files changed, 93 insertions, 0 deletions
diff --git a/BSF/upgrade_feed.php b/BSF/upgrade_feed.php new file mode 100644 index 000000000..44ccbe5db --- /dev/null +++ b/BSF/upgrade_feed.php @@ -0,0 +1,93 @@ +<?php +// +-----------------------------------------------------------------------+ +// | Piwigo - a PHP based picture gallery | +// +-----------------------------------------------------------------------+ +// | Copyright(C) 2008 Piwigo Team http://piwigo.org | +// | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net | +// | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick | +// +-----------------------------------------------------------------------+ +// | This program is free software; you can redistribute it and/or modify | +// | it under the terms of the GNU General Public License as published by | +// | the Free Software Foundation | +// | | +// | This program is distributed in the hope that it will be useful, but | +// | WITHOUT ANY WARRANTY; without even the implied warranty of | +// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | +// | General Public License for more details. | +// | | +// | You should have received a copy of the GNU General Public License | +// | along with this program; if not, write to the Free Software | +// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | +// | USA. | +// +-----------------------------------------------------------------------+ + +define('PHPWG_ROOT_PATH', './'); + +include_once(PHPWG_ROOT_PATH.'include/functions.inc.php'); +include_once(PHPWG_ROOT_PATH.'admin/include/functions.php'); +include_once(PHPWG_ROOT_PATH.'admin/include/functions_upgrade.php'); +include(PHPWG_ROOT_PATH.'include/mysql.inc.php'); + +// +-----------------------------------------------------------------------+ +// | Check Access and exit when it is not ok | +// +-----------------------------------------------------------------------+ +check_upgrade(); + +prepare_conf_upgrade(); + +define('PREFIX_TABLE', $prefixeTable); +define('UPGRADES_PATH', PHPWG_ROOT_PATH.'install/db'); + +// +-----------------------------------------------------------------------+ +// | Database connection | +// +-----------------------------------------------------------------------+ + +mysql_connect($cfgHote, $cfgUser, $cfgPassword) +or die("Could not connect to database server"); +mysql_select_db($cfgBase) +or die("Could not connect to database"); + +// +-----------------------------------------------------------------------+ +// | Upgrades | +// +-----------------------------------------------------------------------+ + +// retrieve already applied upgrades +$query = ' +SELECT id + FROM '.PREFIX_TABLE.'upgrade +;'; +$applied = array_from_query($query, 'id'); + +// retrieve existing upgrades +$existing = get_available_upgrade_ids(); + +// which upgrades need to be applied? +$to_apply = array_diff($existing, $applied); + +echo '<pre>'; +echo count($to_apply).' upgrades to apply'; + +foreach ($to_apply as $upgrade_id) +{ + unset($upgrade_description); + + echo "\n\n"; + echo '=== upgrade '.$upgrade_id."\n"; + + // include & execute upgrade script. Each upgrade script must contain + // $upgrade_description variable which describe briefly what the upgrade + // script does. + include(UPGRADES_PATH.'/'.$upgrade_id.'-database.php'); + + // notify upgrade + $query = ' +INSERT INTO '.PREFIX_TABLE.'upgrade + (id, applied, description) + VALUES + (\''.$upgrade_id.'\', NOW(), \''.$upgrade_description.'\') +;'; + pwg_query($query); +} + +echo '</pre>'; +?> |