source: trunk/install/db/13-database.php @ 1584

Last change on this file since 1584 was 1071, checked in by rvelices, 19 years ago

bug 255: parameter values in #config limited to 255 chars (value becomes text)

feature 303: page banner moved from combination of gallery_title,
gallery_description and template to database (simplifies user customization)

  • Property svn:eol-style set to native
File size: 2.7 KB
RevLine 
[1071]1<?php
2// +-----------------------------------------------------------------------+
3// | PhpWebGallery - a PHP based picture gallery                           |
4// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
5// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net |
6// +-----------------------------------------------------------------------+
7// | branch        : BSF (Best So Far)
8// | file          : $RCSfile$
9// | last update   : $Date: 2005-09-21 00:04:57 +0200 (mer, 21 sep 2005) $
10// | last modifier : $Author: plg $
11// | revision      : $Revision: 870 $
12// +-----------------------------------------------------------------------+
13// | This program is free software; you can redistribute it and/or modify  |
14// | it under the terms of the GNU General Public License as published by  |
15// | the Free Software Foundation                                          |
16// |                                                                       |
17// | This program is distributed in the hope that it will be useful, but   |
18// | WITHOUT ANY WARRANTY; without even the implied warranty of            |
19// | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU      |
20// | General Public License for more details.                              |
21// |                                                                       |
22// | You should have received a copy of the GNU General Public License     |
23// | along with this program; if not, write to the Free Software           |
24// | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
25// | USA.                                                                  |
26// +-----------------------------------------------------------------------+
27
28if (!defined('PHPWG_ROOT_PATH'))
29{
30  die('Hacking attempt!');
31}
32
33$upgrade_description = '#config (gallery_description out page_banner in)';
34
35$query = "
36ALTER TABLE ".PREFIX_TABLE."config MODIFY COLUMN `value` TEXT;";
37pwg_query($query);
38
39
40$query = '
41SELECT value
42  FROM '.PREFIX_TABLE.'config
43  WHERE param=\'gallery_title\'
44;';
45list($t) = array_from_query($query, 'value');
46
47$query = '
48SELECT value
49  FROM '.PREFIX_TABLE.'config
50  WHERE param=\'gallery_description\'
51;';
52list($d) = array_from_query($query, 'value');
53
54$page_banner='<div id="theHeader"><h1>'.$t.'</h1><p>'.$d.'</p></div>';
55$page_banner=addslashes($page_banner);
56$query = '
57INSERT INTO '.PREFIX_TABLE.'config (param,value,comment) VALUES (' .
58"'page_banner','$page_banner','html displayed on the top each page of your gallery');";
59pwg_query($query);
60
61$query = '
62DELETE FROM '.PREFIX_TABLE.'config
63  WHERE param=\'gallery_description\'
64;';
65pwg_query($query);
66
67
68echo
69"\n"
70.'Table '.PREFIX_TABLE.'config updated'
71."\n"
72;
73?>
Note: See TracBrowser for help on using the repository browser.