[1075] | 1 | <?php |
---|
| 2 | // +-----------------------------------------------------------------------+ |
---|
[8728] | 3 | // | Piwigo - a PHP based photo gallery | |
---|
[2297] | 4 | // +-----------------------------------------------------------------------+ |
---|
[8728] | 5 | // | Copyright(C) 2008-2011 Piwigo Team http://piwigo.org | |
---|
[2297] | 6 | // | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net | |
---|
| 7 | // | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick | |
---|
| 8 | // +-----------------------------------------------------------------------+ |
---|
| 9 | // | This program is free software; you can redistribute it and/or modify | |
---|
| 10 | // | it under the terms of the GNU General Public License as published by | |
---|
| 11 | // | the Free Software Foundation | |
---|
| 12 | // | | |
---|
| 13 | // | This program is distributed in the hope that it will be useful, but | |
---|
| 14 | // | WITHOUT ANY WARRANTY; without even the implied warranty of | |
---|
| 15 | // | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU | |
---|
| 16 | // | General Public License for more details. | |
---|
| 17 | // | | |
---|
| 18 | // | You should have received a copy of the GNU General Public License | |
---|
| 19 | // | along with this program; if not, write to the Free Software | |
---|
| 20 | // | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, | |
---|
| 21 | // | USA. | |
---|
| 22 | // +-----------------------------------------------------------------------+ |
---|
[1075] | 23 | |
---|
| 24 | function check_upgrade() |
---|
| 25 | { |
---|
[2836] | 26 | if (defined('PHPWG_IN_UPGRADE')) |
---|
[1075] | 27 | { |
---|
[2836] | 28 | return PHPWG_IN_UPGRADE; |
---|
[1075] | 29 | } |
---|
[2836] | 30 | return false; |
---|
[1075] | 31 | } |
---|
| 32 | |
---|
[2096] | 33 | // concerning upgrade, we use the default tables |
---|
| 34 | function prepare_conf_upgrade() |
---|
| 35 | { |
---|
[2104] | 36 | global $prefixeTable; |
---|
[1075] | 37 | |
---|
[2104] | 38 | // $conf is not used for users tables |
---|
| 39 | // define cannot be re-defined |
---|
| 40 | define('CATEGORIES_TABLE', $prefixeTable.'categories'); |
---|
| 41 | define('COMMENTS_TABLE', $prefixeTable.'comments'); |
---|
| 42 | define('CONFIG_TABLE', $prefixeTable.'config'); |
---|
| 43 | define('FAVORITES_TABLE', $prefixeTable.'favorites'); |
---|
| 44 | define('GROUP_ACCESS_TABLE', $prefixeTable.'group_access'); |
---|
| 45 | define('GROUPS_TABLE', $prefixeTable.'groups'); |
---|
| 46 | define('HISTORY_TABLE', $prefixeTable.'history'); |
---|
| 47 | define('HISTORY_SUMMARY_TABLE', $prefixeTable.'history_summary'); |
---|
| 48 | define('IMAGE_CATEGORY_TABLE', $prefixeTable.'image_category'); |
---|
| 49 | define('IMAGES_TABLE', $prefixeTable.'images'); |
---|
| 50 | define('SESSIONS_TABLE', $prefixeTable.'sessions'); |
---|
| 51 | define('SITES_TABLE', $prefixeTable.'sites'); |
---|
| 52 | define('USER_ACCESS_TABLE', $prefixeTable.'user_access'); |
---|
| 53 | define('USER_GROUP_TABLE', $prefixeTable.'user_group'); |
---|
| 54 | define('USERS_TABLE', $prefixeTable.'users'); |
---|
| 55 | define('USER_INFOS_TABLE', $prefixeTable.'user_infos'); |
---|
| 56 | define('USER_FEED_TABLE', $prefixeTable.'user_feed'); |
---|
| 57 | define('RATE_TABLE', $prefixeTable.'rate'); |
---|
| 58 | define('USER_CACHE_TABLE', $prefixeTable.'user_cache'); |
---|
| 59 | define('USER_CACHE_CATEGORIES_TABLE', $prefixeTable.'user_cache_categories'); |
---|
| 60 | define('CADDIE_TABLE', $prefixeTable.'caddie'); |
---|
| 61 | define('UPGRADE_TABLE', $prefixeTable.'upgrade'); |
---|
| 62 | define('SEARCH_TABLE', $prefixeTable.'search'); |
---|
| 63 | define('USER_MAIL_NOTIFICATION_TABLE', $prefixeTable.'user_mail_notification'); |
---|
| 64 | define('TAGS_TABLE', $prefixeTable.'tags'); |
---|
| 65 | define('IMAGE_TAG_TABLE', $prefixeTable.'image_tag'); |
---|
| 66 | define('PLUGINS_TABLE', $prefixeTable.'plugins'); |
---|
| 67 | define('OLD_PERMALINKS_TABLE', $prefixeTable.'old_permalinks'); |
---|
[5387] | 68 | define('THEMES_TABLE', $prefixeTable.'themes'); |
---|
| 69 | define('LANGUAGES_TABLE', $prefixeTable.'languages'); |
---|
[2096] | 70 | } |
---|
| 71 | |
---|
[2815] | 72 | // Deactivate all non-standard plugins |
---|
| 73 | function deactivate_non_standard_plugins() |
---|
| 74 | { |
---|
| 75 | global $page; |
---|
| 76 | |
---|
| 77 | $standard_plugins = array( |
---|
| 78 | 'admin_multi_view', |
---|
| 79 | 'c13y_upgrade', |
---|
| 80 | 'event_tracer', |
---|
| 81 | 'language_switch', |
---|
| 82 | 'LocalFilesEditor' |
---|
| 83 | ); |
---|
| 84 | |
---|
| 85 | $query = ' |
---|
| 86 | SELECT id |
---|
| 87 | FROM '.PREFIX_TABLE.'plugins |
---|
[6654] | 88 | WHERE state = \'active\' |
---|
[6550] | 89 | AND id NOT IN (\'' . implode('\',\'', $standard_plugins) . '\') |
---|
[2815] | 90 | ;'; |
---|
| 91 | |
---|
| 92 | $result = pwg_query($query); |
---|
| 93 | $plugins = array(); |
---|
[4325] | 94 | while ($row = pwg_db_fetch_assoc($result)) |
---|
[2815] | 95 | { |
---|
| 96 | array_push($plugins, $row['id']); |
---|
| 97 | } |
---|
| 98 | |
---|
| 99 | if (!empty($plugins)) |
---|
| 100 | { |
---|
| 101 | $query = ' |
---|
| 102 | UPDATE '.PREFIX_TABLE.'plugins |
---|
[6654] | 103 | SET state=\'inactive\' |
---|
[6550] | 104 | WHERE id IN (\'' . implode('\',\'', $plugins) . '\') |
---|
[2815] | 105 | ;'; |
---|
[2884] | 106 | pwg_query($query); |
---|
[2815] | 107 | |
---|
[2819] | 108 | array_push($page['infos'], |
---|
[5021] | 109 | l10n('As a precaution, following plugins have been deactivated. You must check for plugins upgrade before reactiving them:').'<p><i>'.implode(', ', $plugins).'</i></p>'); |
---|
[2815] | 110 | } |
---|
| 111 | } |
---|
| 112 | |
---|
[9597] | 113 | // Deactivate all non-standard themes |
---|
| 114 | function deactivate_non_standard_themes() |
---|
| 115 | { |
---|
[10426] | 116 | global $page, $conf; |
---|
[9597] | 117 | |
---|
| 118 | $standard_themes = array( |
---|
| 119 | 'clear', |
---|
| 120 | 'Sylvia', |
---|
| 121 | 'dark', |
---|
| 122 | ); |
---|
| 123 | |
---|
| 124 | $query = ' |
---|
| 125 | SELECT |
---|
| 126 | id, |
---|
| 127 | name |
---|
| 128 | FROM '.PREFIX_TABLE.'themes |
---|
| 129 | WHERE id NOT IN (\''.implode("','", $standard_themes).'\') |
---|
| 130 | ;'; |
---|
| 131 | $result = pwg_query($query); |
---|
| 132 | $theme_ids = array(); |
---|
| 133 | $theme_names = array(); |
---|
| 134 | while ($row = pwg_db_fetch_assoc($result)) |
---|
| 135 | { |
---|
| 136 | array_push($theme_ids, $row['id']); |
---|
| 137 | array_push($theme_names, $row['name']); |
---|
| 138 | } |
---|
| 139 | |
---|
| 140 | if (!empty($theme_ids)) |
---|
| 141 | { |
---|
| 142 | $query = ' |
---|
| 143 | DELETE |
---|
| 144 | FROM '.PREFIX_TABLE.'themes |
---|
| 145 | WHERE id IN (\''.implode("','", $theme_ids).'\') |
---|
| 146 | ;'; |
---|
| 147 | pwg_query($query); |
---|
| 148 | |
---|
| 149 | array_push($page['infos'], |
---|
| 150 | l10n('As a precaution, following themes have been deactivated. You must check for themes upgrade before reactiving them:').'<p><i>'.implode(', ', $theme_names).'</i></p>'); |
---|
[10426] | 151 | |
---|
| 152 | // what is the default theme? |
---|
| 153 | $query = ' |
---|
| 154 | SELECT theme |
---|
| 155 | FROM '.PREFIX_TABLE.'user_infos |
---|
| 156 | WHERE user_id = '.$conf['default_user_id'].' |
---|
| 157 | ;'; |
---|
| 158 | list($default_theme) = pwg_db_fetch_row(pwg_query($query)); |
---|
| 159 | |
---|
| 160 | // if the default theme has just been deactivated, let's set another core theme as default |
---|
| 161 | if (in_array($default_theme, $theme_ids)) |
---|
| 162 | { |
---|
| 163 | $query = ' |
---|
| 164 | UPDATE '.PREFIX_TABLE.'user_infos |
---|
| 165 | SET theme = \'Sylvia\' |
---|
| 166 | WHERE user_id = '.$conf['default_user_id'].' |
---|
| 167 | ;'; |
---|
| 168 | pwg_query($query); |
---|
| 169 | } |
---|
[9597] | 170 | } |
---|
| 171 | } |
---|
| 172 | |
---|
[2836] | 173 | // Check access rights |
---|
[6110] | 174 | function check_upgrade_access_rights() |
---|
[2836] | 175 | { |
---|
[6110] | 176 | global $conf, $page, $current_release; |
---|
[2836] | 177 | |
---|
[6110] | 178 | if (version_compare($current_release, '2.0', '>=') and isset($_COOKIE[session_name()])) |
---|
| 179 | { |
---|
| 180 | // Check if user is already connected as webmaster |
---|
| 181 | session_start(); |
---|
| 182 | if (!empty($_SESSION['pwg_uid'])) |
---|
| 183 | { |
---|
| 184 | $query = ' |
---|
| 185 | SELECT status |
---|
| 186 | FROM '.USER_INFOS_TABLE.' |
---|
| 187 | WHERE user_id = '.$_SESSION['pwg_uid'].' |
---|
| 188 | ;'; |
---|
| 189 | pwg_query($query); |
---|
| 190 | |
---|
| 191 | $row = pwg_db_fetch_assoc(pwg_query($query)); |
---|
| 192 | if (isset($row['status']) and $row['status'] == 'webmaster') |
---|
| 193 | { |
---|
| 194 | define('PHPWG_IN_UPGRADE', true); |
---|
| 195 | return; |
---|
| 196 | } |
---|
| 197 | } |
---|
| 198 | } |
---|
| 199 | |
---|
| 200 | if (!isset($_POST['username']) or !isset($_POST['password'])) |
---|
| 201 | { |
---|
| 202 | return; |
---|
| 203 | } |
---|
| 204 | |
---|
[6131] | 205 | $username = $_POST['username']; |
---|
[6110] | 206 | $password = $_POST['password']; |
---|
| 207 | |
---|
[4006] | 208 | if(!@get_magic_quotes_gpc()) |
---|
[2838] | 209 | { |
---|
[4325] | 210 | $username = pwg_db_real_escape_string($username); |
---|
[2838] | 211 | } |
---|
| 212 | |
---|
[2900] | 213 | if (version_compare($current_release, '2.0', '<')) |
---|
[2836] | 214 | { |
---|
[2900] | 215 | $username = utf8_decode($username); |
---|
| 216 | $password = utf8_decode($password); |
---|
| 217 | } |
---|
| 218 | |
---|
| 219 | if (version_compare($current_release, '1.5', '<')) |
---|
| 220 | { |
---|
[2836] | 221 | $query = ' |
---|
| 222 | SELECT password, status |
---|
[2838] | 223 | FROM '.USERS_TABLE.' |
---|
[6550] | 224 | WHERE username = \''.$username.'\' |
---|
[2836] | 225 | ;'; |
---|
| 226 | } |
---|
| 227 | else |
---|
| 228 | { |
---|
| 229 | $query = ' |
---|
| 230 | SELECT u.password, ui.status |
---|
[4280] | 231 | FROM '.USERS_TABLE.' AS u |
---|
[2838] | 232 | INNER JOIN '.USER_INFOS_TABLE.' AS ui |
---|
| 233 | ON u.'.$conf['user_fields']['id'].'=ui.user_id |
---|
[6550] | 234 | WHERE '.$conf['user_fields']['username'].'=\''.$username.'\' |
---|
[2836] | 235 | ;'; |
---|
| 236 | } |
---|
[4325] | 237 | $row = pwg_db_fetch_assoc(pwg_query($query)); |
---|
[2836] | 238 | |
---|
| 239 | if (!isset($conf['pass_convert'])) |
---|
| 240 | { |
---|
| 241 | $conf['pass_convert'] = create_function('$s', 'return md5($s);'); |
---|
| 242 | } |
---|
| 243 | |
---|
[2900] | 244 | if ($row['password'] != $conf['pass_convert']($password)) |
---|
[2836] | 245 | { |
---|
[5021] | 246 | array_push($page['errors'], l10n('Invalid password!')); |
---|
[2836] | 247 | } |
---|
| 248 | elseif ($row['status'] != 'admin' and $row['status'] != 'webmaster') |
---|
| 249 | { |
---|
| 250 | array_push($page['errors'], l10n('You do not have access rights to run upgrade')); |
---|
| 251 | } |
---|
| 252 | else |
---|
| 253 | { |
---|
| 254 | define('PHPWG_IN_UPGRADE', true); |
---|
| 255 | } |
---|
| 256 | } |
---|
[3136] | 257 | |
---|
| 258 | /** |
---|
| 259 | * which upgrades are available ? |
---|
| 260 | * |
---|
| 261 | * @return array |
---|
| 262 | */ |
---|
| 263 | function get_available_upgrade_ids() |
---|
| 264 | { |
---|
| 265 | $upgrades_path = PHPWG_ROOT_PATH.'install/db'; |
---|
| 266 | |
---|
| 267 | $available_upgrade_ids = array(); |
---|
| 268 | |
---|
| 269 | if ($contents = opendir($upgrades_path)) |
---|
| 270 | { |
---|
| 271 | while (($node = readdir($contents)) !== false) |
---|
| 272 | { |
---|
| 273 | if (is_file($upgrades_path.'/'.$node) |
---|
| 274 | and preg_match('/^(.*?)-database\.php$/', $node, $match)) |
---|
| 275 | { |
---|
| 276 | array_push($available_upgrade_ids, $match[1]); |
---|
| 277 | } |
---|
| 278 | } |
---|
| 279 | } |
---|
| 280 | natcasesort($available_upgrade_ids); |
---|
| 281 | |
---|
| 282 | return $available_upgrade_ids; |
---|
| 283 | } |
---|
| 284 | |
---|
| 285 | |
---|
| 286 | /** |
---|
| 287 | * returns true if there are available upgrade files |
---|
| 288 | */ |
---|
| 289 | function check_upgrade_feed() |
---|
| 290 | { |
---|
| 291 | // retrieve already applied upgrades |
---|
| 292 | $query = ' |
---|
| 293 | SELECT id |
---|
| 294 | FROM '.UPGRADE_TABLE.' |
---|
| 295 | ;'; |
---|
| 296 | $applied = array_from_query($query, 'id'); |
---|
| 297 | |
---|
| 298 | // retrieve existing upgrades |
---|
| 299 | $existing = get_available_upgrade_ids(); |
---|
| 300 | |
---|
| 301 | // which upgrades need to be applied? |
---|
| 302 | return (count(array_diff($existing, $applied)) > 0); |
---|
| 303 | } |
---|
| 304 | |
---|
[5387] | 305 | function upgrade_db_connect() |
---|
| 306 | { |
---|
| 307 | global $conf; |
---|
| 308 | |
---|
| 309 | try |
---|
| 310 | { |
---|
[5982] | 311 | $pwg_db_link = pwg_db_connect($conf['db_host'], $conf['db_user'], $conf['db_password'], $conf['db_base']); |
---|
| 312 | if ($pwg_db_link) |
---|
| 313 | { |
---|
| 314 | pwg_db_check_version(); |
---|
| 315 | } |
---|
[5387] | 316 | } |
---|
| 317 | catch (Exception $e) |
---|
| 318 | { |
---|
| 319 | my_error(l10n($e->getMessage()), true); |
---|
| 320 | } |
---|
| 321 | } |
---|
[3136] | 322 | ?> |
---|