[1927] | 1 | <?php |
---|
| 2 | // +-----------------------------------------------------------------------+ |
---|
[8728] | 3 | // | Piwigo - a PHP based photo gallery | |
---|
[1932] | 4 | // +-----------------------------------------------------------------------+ |
---|
[26461] | 5 | // | Copyright(C) 2008-2014 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 | // +-----------------------------------------------------------------------+ |
---|
[1927] | 23 | |
---|
| 24 | /** |
---|
| 25 | * Upgrade from 1.3.x (x >= 1) to 1.4.0 |
---|
| 26 | */ |
---|
| 27 | |
---|
| 28 | if (!defined('PHPWG_ROOT_PATH')) |
---|
| 29 | { |
---|
| 30 | die ('This page cannot be loaded directly, load upgrade.php'); |
---|
| 31 | } |
---|
| 32 | else |
---|
| 33 | { |
---|
| 34 | if (!defined('PHPWG_IN_UPGRADE') or !PHPWG_IN_UPGRADE) |
---|
| 35 | { |
---|
| 36 | die ('Hacking attempt!'); |
---|
| 37 | } |
---|
| 38 | } |
---|
| 39 | |
---|
| 40 | // save data before deletion |
---|
| 41 | $query = ' |
---|
| 42 | SELECT prefix_thumbnail, mail_webmaster |
---|
| 43 | FROM '.PREFIX_TABLE.'config |
---|
| 44 | ;'; |
---|
[4325] | 45 | $save = pwg_db_fetch_assoc(pwg_query($query)); |
---|
[1927] | 46 | |
---|
| 47 | $queries = array( |
---|
| 48 | " |
---|
| 49 | DROP TABLE phpwebgallery_config |
---|
| 50 | ;", |
---|
| 51 | |
---|
| 52 | " |
---|
| 53 | CREATE TABLE phpwebgallery_config ( |
---|
| 54 | param varchar(40) NOT NULL default '', |
---|
| 55 | value varchar(255) default NULL, |
---|
| 56 | comment varchar(255) default NULL, |
---|
| 57 | PRIMARY KEY (param) |
---|
[9086] | 58 | ) ENGINE=MyISAM COMMENT='configuration table' |
---|
[1927] | 59 | ;", |
---|
| 60 | |
---|
| 61 | " |
---|
| 62 | ALTER TABLE phpwebgallery_categories |
---|
| 63 | CHANGE COLUMN site_id site_id tinyint(4) unsigned default '1' |
---|
| 64 | ;", |
---|
| 65 | |
---|
| 66 | " |
---|
| 67 | ALTER TABLE phpwebgallery_categories |
---|
| 68 | ADD COLUMN commentable enum('true','false') NOT NULL default 'true' |
---|
| 69 | ;", |
---|
[2306] | 70 | |
---|
[1927] | 71 | " |
---|
| 72 | ALTER TABLE phpwebgallery_categories |
---|
| 73 | ADD COLUMN global_rank varchar(255) default NULL |
---|
| 74 | ;", |
---|
| 75 | |
---|
| 76 | " |
---|
| 77 | ALTER TABLE phpwebgallery_categories |
---|
| 78 | ADD INDEX categories_i2 (id_uppercat) |
---|
| 79 | ;", |
---|
| 80 | |
---|
| 81 | " |
---|
| 82 | ALTER TABLE phpwebgallery_comments |
---|
| 83 | ADD COLUMN date_temp int(11) unsigned |
---|
| 84 | ;", |
---|
| 85 | |
---|
| 86 | " |
---|
| 87 | UPDATE phpwebgallery_comments |
---|
| 88 | SET date_temp = date |
---|
| 89 | ;", |
---|
[2306] | 90 | |
---|
[1927] | 91 | " |
---|
| 92 | ALTER TABLE phpwebgallery_comments |
---|
| 93 | CHANGE COLUMN date date datetime NOT NULL default '0000-00-00 00:00:00' |
---|
| 94 | ;", |
---|
| 95 | |
---|
| 96 | " |
---|
| 97 | UPDATE phpwebgallery_comments |
---|
| 98 | SET date = FROM_UNIXTIME(date_temp) |
---|
| 99 | ;", |
---|
| 100 | |
---|
| 101 | " |
---|
| 102 | ALTER TABLE phpwebgallery_comments |
---|
| 103 | DROP COLUMN date_temp |
---|
| 104 | ;", |
---|
| 105 | |
---|
| 106 | " |
---|
| 107 | ALTER TABLE phpwebgallery_favorites |
---|
| 108 | DROP INDEX user_id |
---|
| 109 | ;", |
---|
| 110 | |
---|
| 111 | " |
---|
| 112 | ALTER TABLE phpwebgallery_favorites |
---|
| 113 | ADD PRIMARY KEY (user_id,image_id) |
---|
| 114 | ;", |
---|
| 115 | |
---|
| 116 | " |
---|
| 117 | ALTER TABLE phpwebgallery_history |
---|
| 118 | ADD COLUMN date_temp int(11) unsigned |
---|
| 119 | ;", |
---|
| 120 | |
---|
| 121 | " |
---|
| 122 | UPDATE phpwebgallery_history |
---|
| 123 | SET date_temp = date |
---|
| 124 | ;", |
---|
[2306] | 125 | |
---|
[1927] | 126 | " |
---|
| 127 | ALTER TABLE phpwebgallery_history |
---|
| 128 | CHANGE COLUMN date date datetime NOT NULL default '0000-00-00 00:00:00' |
---|
| 129 | ;", |
---|
| 130 | |
---|
| 131 | " |
---|
| 132 | UPDATE phpwebgallery_history |
---|
| 133 | SET date = FROM_UNIXTIME(date_temp) |
---|
| 134 | ;", |
---|
| 135 | |
---|
| 136 | " |
---|
| 137 | ALTER TABLE phpwebgallery_history |
---|
| 138 | DROP COLUMN date_temp |
---|
| 139 | ;", |
---|
| 140 | |
---|
| 141 | " |
---|
| 142 | ALTER TABLE phpwebgallery_history |
---|
| 143 | ADD INDEX history_i1 (date) |
---|
| 144 | ;", |
---|
| 145 | |
---|
| 146 | " |
---|
| 147 | ALTER TABLE phpwebgallery_image_category |
---|
| 148 | ADD INDEX image_category_i1 (image_id), |
---|
| 149 | ADD INDEX image_category_i2 (category_id) |
---|
| 150 | ;", |
---|
| 151 | |
---|
| 152 | " |
---|
| 153 | ALTER TABLE phpwebgallery_images |
---|
| 154 | CHANGE COLUMN tn_ext tn_ext varchar(4) default '' |
---|
| 155 | ;", |
---|
| 156 | |
---|
| 157 | " |
---|
| 158 | ALTER TABLE phpwebgallery_images |
---|
| 159 | ADD COLUMN path varchar(255) NOT NULL default '' |
---|
| 160 | ;", |
---|
| 161 | |
---|
| 162 | " |
---|
| 163 | ALTER TABLE phpwebgallery_images |
---|
| 164 | ADD COLUMN date_metadata_update date default NULL |
---|
| 165 | ;", |
---|
| 166 | |
---|
| 167 | " |
---|
| 168 | ALTER TABLE phpwebgallery_images |
---|
| 169 | ADD COLUMN average_rate float(5,2) unsigned default NULL |
---|
| 170 | ;", |
---|
| 171 | |
---|
| 172 | " |
---|
| 173 | ALTER TABLE phpwebgallery_images |
---|
| 174 | ADD COLUMN representative_ext varchar(4) default NULL |
---|
| 175 | ;", |
---|
| 176 | |
---|
| 177 | " |
---|
| 178 | ALTER TABLE phpwebgallery_images |
---|
| 179 | DROP INDEX storage_category_id |
---|
| 180 | ;", |
---|
| 181 | |
---|
| 182 | " |
---|
| 183 | ALTER TABLE phpwebgallery_images |
---|
| 184 | ADD INDEX images_i1 (storage_category_id) |
---|
| 185 | ;", |
---|
| 186 | |
---|
| 187 | " |
---|
| 188 | ALTER TABLE phpwebgallery_images |
---|
| 189 | ADD INDEX images_i2 (date_available) |
---|
| 190 | ;", |
---|
| 191 | |
---|
| 192 | " |
---|
| 193 | ALTER TABLE phpwebgallery_images |
---|
| 194 | ADD INDEX images_i3 (average_rate) |
---|
| 195 | ;", |
---|
| 196 | |
---|
| 197 | " |
---|
| 198 | ALTER TABLE phpwebgallery_images |
---|
| 199 | ADD INDEX images_i4 (hit) |
---|
| 200 | ;", |
---|
| 201 | |
---|
| 202 | " |
---|
| 203 | ALTER TABLE phpwebgallery_images |
---|
| 204 | ADD INDEX images_i5 (date_creation) |
---|
| 205 | ;", |
---|
[2306] | 206 | |
---|
[1927] | 207 | " |
---|
| 208 | ALTER TABLE phpwebgallery_sessions |
---|
| 209 | DROP COLUMN ip |
---|
| 210 | ;", |
---|
| 211 | |
---|
| 212 | " |
---|
| 213 | ALTER TABLE phpwebgallery_sessions |
---|
| 214 | ADD COLUMN expiration_temp int(11) unsigned |
---|
| 215 | ;", |
---|
| 216 | |
---|
| 217 | " |
---|
| 218 | UPDATE phpwebgallery_sessions |
---|
| 219 | SET expiration_temp = expiration |
---|
| 220 | ;", |
---|
[2306] | 221 | |
---|
[1927] | 222 | " |
---|
| 223 | ALTER TABLE phpwebgallery_sessions |
---|
| 224 | CHANGE COLUMN expiration expiration datetime NOT NULL default '0000-00-00 00:00:00' |
---|
| 225 | ;", |
---|
| 226 | |
---|
| 227 | " |
---|
| 228 | UPDATE phpwebgallery_sessions |
---|
| 229 | SET expiration = FROM_UNIXTIME(expiration_temp) |
---|
| 230 | ;", |
---|
| 231 | |
---|
| 232 | " |
---|
| 233 | ALTER TABLE phpwebgallery_sessions |
---|
| 234 | DROP COLUMN expiration_temp |
---|
| 235 | ;", |
---|
[2306] | 236 | |
---|
[1927] | 237 | " |
---|
| 238 | ALTER TABLE phpwebgallery_sites |
---|
| 239 | DROP INDEX galleries_url |
---|
| 240 | ;", |
---|
| 241 | |
---|
| 242 | " |
---|
| 243 | ALTER TABLE phpwebgallery_sites |
---|
| 244 | ADD UNIQUE sites_ui1 (galleries_url) |
---|
| 245 | ;", |
---|
| 246 | |
---|
| 247 | " |
---|
| 248 | DROP TABLE phpwebgallery_user_category |
---|
| 249 | ;", |
---|
[2306] | 250 | |
---|
[1927] | 251 | " |
---|
| 252 | ALTER TABLE phpwebgallery_users |
---|
| 253 | DROP COLUMN long_period |
---|
| 254 | ;", |
---|
| 255 | |
---|
| 256 | " |
---|
| 257 | ALTER TABLE phpwebgallery_users |
---|
| 258 | DROP COLUMN short_period |
---|
| 259 | ;", |
---|
| 260 | |
---|
| 261 | " |
---|
| 262 | ALTER TABLE phpwebgallery_users |
---|
| 263 | ADD COLUMN recent_period tinyint(3) unsigned NOT NULL default '7' |
---|
| 264 | ;", |
---|
| 265 | |
---|
| 266 | " |
---|
| 267 | ALTER TABLE phpwebgallery_users |
---|
| 268 | DROP INDEX username |
---|
| 269 | ;", |
---|
| 270 | |
---|
| 271 | " |
---|
| 272 | ALTER TABLE phpwebgallery_users |
---|
| 273 | ADD UNIQUE users_ui1 (username) |
---|
| 274 | ;", |
---|
[2306] | 275 | |
---|
[1927] | 276 | " |
---|
| 277 | CREATE TABLE phpwebgallery_rate ( |
---|
| 278 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
| 279 | element_id mediumint(8) unsigned NOT NULL default '0', |
---|
| 280 | rate tinyint(2) unsigned NOT NULL default '0', |
---|
| 281 | PRIMARY KEY (user_id,element_id) |
---|
[9086] | 282 | ) ENGINE=MyISAM |
---|
[1927] | 283 | ;", |
---|
| 284 | |
---|
| 285 | " |
---|
| 286 | CREATE TABLE phpwebgallery_user_forbidden ( |
---|
| 287 | user_id smallint(5) unsigned NOT NULL default '0', |
---|
| 288 | need_update enum('true','false') NOT NULL default 'true', |
---|
| 289 | forbidden_categories text, |
---|
| 290 | PRIMARY KEY (user_id) |
---|
[9086] | 291 | ) ENGINE=MyISAM |
---|
[1927] | 292 | ;", |
---|
| 293 | |
---|
| 294 | " |
---|
| 295 | UPDATE phpwebgallery_users |
---|
| 296 | SET language = 'en_UK.iso-8859-1' |
---|
| 297 | , template = 'default' |
---|
| 298 | ;", |
---|
| 299 | |
---|
| 300 | " |
---|
| 301 | DELETE FROM phpwebgallery_user_access |
---|
| 302 | ;", |
---|
| 303 | |
---|
| 304 | " |
---|
| 305 | DELETE FROM phpwebgallery_group_access |
---|
| 306 | ;" |
---|
| 307 | |
---|
| 308 | ); |
---|
| 309 | |
---|
| 310 | foreach ($queries as $query) |
---|
| 311 | { |
---|
| 312 | $query = str_replace('phpwebgallery_', PREFIX_TABLE, $query); |
---|
| 313 | pwg_query($query); |
---|
| 314 | } |
---|
| 315 | |
---|
| 316 | // |
---|
| 317 | // check indexes |
---|
| 318 | // |
---|
| 319 | $indexes_of = array( |
---|
| 320 | 'categories' => array( |
---|
| 321 | 'categories_i2' => array( |
---|
| 322 | 'columns' => array('id_uppercat'), |
---|
| 323 | 'unique' => false, |
---|
| 324 | ) |
---|
| 325 | ), |
---|
| 326 | 'image_category' => array( |
---|
| 327 | 'image_category_i1' => array( |
---|
| 328 | 'columns' => array('image_id'), |
---|
| 329 | 'unique' => false, |
---|
| 330 | ), |
---|
| 331 | 'image_category_i2' => array( |
---|
| 332 | 'columns' => array('category_id'), |
---|
| 333 | 'unique' => false, |
---|
| 334 | ), |
---|
| 335 | ), |
---|
| 336 | ); |
---|
| 337 | |
---|
| 338 | foreach (array_keys($indexes_of) as $table) |
---|
| 339 | { |
---|
| 340 | $existing_indexes = array(); |
---|
[2306] | 341 | |
---|
[1927] | 342 | $query = ' |
---|
| 343 | SHOW INDEX |
---|
| 344 | FROM '.PREFIX_TABLE.$table.' |
---|
| 345 | ;'; |
---|
| 346 | $result = pwg_query($query); |
---|
[4325] | 347 | while ($row = pwg_db_fetch_assoc($result)) |
---|
[1927] | 348 | { |
---|
| 349 | if ($row['Key_name'] != 'PRIMARY') |
---|
| 350 | { |
---|
| 351 | if (!in_array($row['Key_name'], array_keys($indexes_of[$table]))) |
---|
| 352 | { |
---|
| 353 | $query = ' |
---|
| 354 | ALTER TABLE '.PREFIX_TABLE.$table.' |
---|
| 355 | DROP INDEX '.$row['Key_name'].' |
---|
| 356 | ;'; |
---|
| 357 | pwg_query($query); |
---|
| 358 | } |
---|
| 359 | else |
---|
| 360 | { |
---|
| 361 | array_push($existing_indexes, $row['Key_name']); |
---|
| 362 | } |
---|
| 363 | } |
---|
| 364 | } |
---|
| 365 | |
---|
| 366 | foreach ($indexes_of[$table] as $index_name => $index) |
---|
| 367 | { |
---|
| 368 | if (!in_array($index_name, $existing_indexes)) |
---|
| 369 | { |
---|
| 370 | $query = ' |
---|
| 371 | ALTER TABLE '.PREFIX_TABLE.$table.' |
---|
| 372 | ADD '.($index['unique'] ? 'UNIQUE' : 'INDEX').' ' |
---|
| 373 | .$index_name.' ('.implode(',', $index['columns']).') |
---|
| 374 | ;'; |
---|
| 375 | pwg_query($query); |
---|
| 376 | } |
---|
| 377 | } |
---|
| 378 | } |
---|
| 379 | |
---|
| 380 | // |
---|
| 381 | // insert params in new configuration table |
---|
| 382 | // |
---|
| 383 | $params = array( |
---|
| 384 | array( |
---|
| 385 | 'param' => 'prefix_thumbnail', |
---|
| 386 | 'value' => $save['prefix_thumbnail'], |
---|
| 387 | 'comment' => 'thumbnails filename prefix' |
---|
| 388 | ), |
---|
| 389 | array( |
---|
| 390 | 'param' => 'mail_webmaster', |
---|
| 391 | 'value' => $save['mail_webmaster'], |
---|
| 392 | 'comment' => 'webmaster mail' |
---|
| 393 | ), |
---|
| 394 | array( |
---|
| 395 | 'param' => 'default_language', |
---|
| 396 | 'value' => 'en_UK.iso-8859-1', |
---|
| 397 | 'comment' => 'Default gallery language' |
---|
| 398 | ), |
---|
| 399 | array( |
---|
| 400 | 'param' => 'default_template', |
---|
| 401 | 'value' => 'default', |
---|
| 402 | 'comment' => 'Default gallery style' |
---|
| 403 | ), |
---|
| 404 | array( |
---|
| 405 | 'param' => 'default_maxwidth', |
---|
| 406 | 'value' => '', |
---|
| 407 | 'comment' => 'maximum width authorized for displaying images' |
---|
| 408 | ), |
---|
| 409 | array( |
---|
| 410 | 'param' => 'default_maxheight', |
---|
| 411 | 'value' => '', |
---|
| 412 | 'comment' => 'maximum height authorized for the displaying images' |
---|
| 413 | ), |
---|
| 414 | array( |
---|
| 415 | 'param' => 'nb_comment_page', |
---|
| 416 | 'value' => '10', |
---|
| 417 | 'comment' => 'number of comments to display on each page' |
---|
| 418 | ), |
---|
| 419 | array( |
---|
| 420 | 'param' => 'upload_maxfilesize', |
---|
| 421 | 'value' => '150', |
---|
| 422 | 'comment' => 'maximum filesize for the uploaded pictures' |
---|
| 423 | ), |
---|
| 424 | array( |
---|
| 425 | 'param' => 'upload_maxwidth', |
---|
| 426 | 'value' => '800', |
---|
| 427 | 'comment' => 'maximum width authorized for the uploaded images' |
---|
| 428 | ), |
---|
| 429 | array( |
---|
| 430 | 'param' => 'upload_maxheight', |
---|
| 431 | 'value' => '600', |
---|
| 432 | 'comment' => 'maximum height authorized for the uploaded images' |
---|
| 433 | ), |
---|
| 434 | array( |
---|
| 435 | 'param' => 'upload_maxwidth_thumbnail', |
---|
| 436 | 'value' => '150', |
---|
| 437 | 'comment' => 'maximum width authorized for the uploaded thumbnails' |
---|
| 438 | ), |
---|
| 439 | array( |
---|
| 440 | 'param' => 'upload_maxheight_thumbnail', |
---|
| 441 | 'value' => '100', |
---|
| 442 | 'comment' => 'maximum height authorized for the uploaded thumbnails' |
---|
| 443 | ), |
---|
| 444 | array( |
---|
| 445 | 'param' => 'log', |
---|
| 446 | 'value' => 'false', |
---|
| 447 | 'comment' => 'keep an history of visits on your website' |
---|
| 448 | ), |
---|
| 449 | array( |
---|
| 450 | 'param' => 'comments_validation', |
---|
| 451 | 'value' => 'false', |
---|
| 452 | 'comment' => 'administrators validate users comments before becoming visible' |
---|
| 453 | ), |
---|
| 454 | array( |
---|
| 455 | 'param' => 'comments_forall', |
---|
| 456 | 'value' => 'false', |
---|
| 457 | 'comment' => 'even guest not registered can post comments' |
---|
| 458 | ), |
---|
| 459 | array( |
---|
| 460 | 'param' => 'mail_notification', |
---|
| 461 | 'value' => 'false', |
---|
| 462 | 'comment' => 'automated mail notification for adminsitrators' |
---|
| 463 | ), |
---|
| 464 | array( |
---|
| 465 | 'param' => 'nb_image_line', |
---|
| 466 | 'value' => '5', |
---|
| 467 | 'comment' => 'Number of images displayed per row' |
---|
| 468 | ), |
---|
| 469 | array( |
---|
| 470 | 'param' => 'nb_line_page', |
---|
| 471 | 'value' => '3', |
---|
| 472 | 'comment' => 'Number of rows displayed per page' |
---|
| 473 | ), |
---|
| 474 | array( |
---|
| 475 | 'param' => 'recent_period', |
---|
| 476 | 'value' => '7', |
---|
| 477 | 'comment' => 'Period within which pictures are displayed as new (in days)' |
---|
| 478 | ), |
---|
| 479 | array( |
---|
| 480 | 'param' => 'auto_expand', |
---|
| 481 | 'value' => 'false', |
---|
| 482 | 'comment' => 'Auto expand of the category tree' |
---|
| 483 | ), |
---|
| 484 | array( |
---|
| 485 | 'param' => 'show_nb_comments', |
---|
| 486 | 'value' => 'false', |
---|
| 487 | 'comment' => 'Show the number of comments under the thumbnails' |
---|
| 488 | ), |
---|
| 489 | array( |
---|
| 490 | 'param' => 'use_iptc', |
---|
| 491 | 'value' => 'false', |
---|
| 492 | 'comment' => 'Use IPTC data during database synchronization with files metadata' |
---|
| 493 | ), |
---|
| 494 | array( |
---|
| 495 | 'param' => 'use_exif', |
---|
| 496 | 'value' => 'false', |
---|
| 497 | 'comment' => 'Use EXIF data during database synchronization with files metadata' |
---|
| 498 | ), |
---|
| 499 | array( |
---|
| 500 | 'param' => 'show_iptc', |
---|
| 501 | 'value' => 'false', |
---|
| 502 | 'comment' => 'Show IPTC metadata on picture.php if asked by user' |
---|
| 503 | ), |
---|
| 504 | array( |
---|
| 505 | 'param' => 'show_exif', |
---|
| 506 | 'value' => 'true', |
---|
| 507 | 'comment' => 'Show EXIF metadata on picture.php if asked by user' |
---|
| 508 | ), |
---|
| 509 | array( |
---|
| 510 | 'param' => 'authorize_remembering', |
---|
| 511 | 'value' => 'true', |
---|
| 512 | 'comment' => 'Authorize users to be remembered, see $conf{remember_me_length}' |
---|
| 513 | ), |
---|
| 514 | array( |
---|
| 515 | 'param' => 'gallery_locked', |
---|
| 516 | 'value' => 'false', |
---|
| 517 | 'comment' => 'Lock your gallery temporary for non admin users' |
---|
| 518 | ), |
---|
| 519 | ); |
---|
| 520 | |
---|
| 521 | mass_inserts( |
---|
| 522 | CONFIG_TABLE, |
---|
| 523 | array_keys($params[0]), |
---|
| 524 | $params |
---|
| 525 | ); |
---|
| 526 | |
---|
| 527 | // refresh calculated datas |
---|
| 528 | update_global_rank(); |
---|
| 529 | update_category(); |
---|
| 530 | |
---|
| 531 | // update calculated field "images.path" |
---|
| 532 | $cat_ids = array(); |
---|
| 533 | |
---|
| 534 | $query = ' |
---|
| 535 | SELECT DISTINCT(storage_category_id) AS unique_storage_category_id |
---|
| 536 | FROM '.IMAGES_TABLE.' |
---|
| 537 | ;'; |
---|
| 538 | $result = pwg_query($query); |
---|
[4325] | 539 | while ($row = pwg_db_fetch_assoc($result)) |
---|
[1927] | 540 | { |
---|
| 541 | array_push($cat_ids, $row['unique_storage_category_id']); |
---|
| 542 | } |
---|
| 543 | $fulldirs = get_fulldirs($cat_ids); |
---|
| 544 | |
---|
| 545 | foreach ($cat_ids as $cat_id) |
---|
| 546 | { |
---|
| 547 | $query = ' |
---|
| 548 | UPDATE '.IMAGES_TABLE.' |
---|
| 549 | SET path = CONCAT(\''.$fulldirs[$cat_id].'\',\'/\',file) |
---|
| 550 | WHERE storage_category_id = '.$cat_id.' |
---|
| 551 | ;'; |
---|
| 552 | pwg_query($query); |
---|
| 553 | } |
---|
| 554 | |
---|
| 555 | // all sub-categories of private categories become private |
---|
| 556 | $cat_ids = array(); |
---|
| 557 | |
---|
| 558 | $query = ' |
---|
| 559 | SELECT id |
---|
| 560 | FROM '.CATEGORIES_TABLE.' |
---|
| 561 | WHERE status = \'private\' |
---|
| 562 | ;'; |
---|
| 563 | $result = pwg_query($query); |
---|
[4325] | 564 | while ($row = pwg_db_fetch_assoc($result)) |
---|
[1927] | 565 | { |
---|
| 566 | array_push($cat_ids, $row['id']); |
---|
| 567 | } |
---|
| 568 | |
---|
| 569 | if (count($cat_ids) > 0) |
---|
| 570 | { |
---|
| 571 | $privates = get_subcat_ids($cat_ids); |
---|
| 572 | |
---|
| 573 | $query = ' |
---|
| 574 | UPDATE '.CATEGORIES_TABLE.' |
---|
| 575 | SET status = \'private\' |
---|
| 576 | WHERE id IN ('.implode(',', $privates).') |
---|
| 577 | ;'; |
---|
| 578 | pwg_query($query); |
---|
| 579 | } |
---|
| 580 | |
---|
[2838] | 581 | // load the config file |
---|
[5213] | 582 | $config_file = PHPWG_ROOT_PATH.'local/config/database.inc.php'; |
---|
[2838] | 583 | $config_file_contents = @file_get_contents($config_file); |
---|
| 584 | if ($config_file_contents === false) |
---|
| 585 | { |
---|
| 586 | die('CANNOT LOAD '.$config_file); |
---|
| 587 | } |
---|
| 588 | $php_end_tag = strrpos($config_file_contents, '?'.'>'); |
---|
| 589 | if ($php_end_tag === false) |
---|
| 590 | { |
---|
| 591 | die('CANNOT FIND PHP END TAG IN '.$config_file); |
---|
| 592 | } |
---|
| 593 | if (!is_writable($config_file)) |
---|
| 594 | { |
---|
| 595 | die('FILE NOT WRITABLE '.$config_file); |
---|
| 596 | } |
---|
| 597 | |
---|
[5213] | 598 | // changes to write in database.inc.php |
---|
[2863] | 599 | array_push($mysql_changes, 'define(\'PHPWG_INSTALLED\', true);'); |
---|
[2838] | 600 | |
---|
| 601 | // Send infos |
---|
[1927] | 602 | $page['infos'] = array_merge( |
---|
| 603 | $page['infos'], |
---|
| 604 | array( |
---|
[7024] | 605 | l10n('All sub-albums of private albums become private'), |
---|
[5021] | 606 | l10n('User permissions and group permissions have been erased'), |
---|
| 607 | l10n('Only thumbnails prefix and webmaster mail address have been saved from previous configuration') |
---|
[1927] | 608 | ) |
---|
| 609 | ); |
---|
| 610 | |
---|
| 611 | // now we upgrade from 1.4.0 |
---|
| 612 | include_once(PHPWG_ROOT_PATH.'install/upgrade_1.4.0.php'); |
---|
[7024] | 613 | ?> |
---|