From 316d89a90b5cd61f41ea3f35112277608c2e2694 Mon Sep 17 00:00:00 2001
From: rvelices <rv-github@modusoptimus.com>
Date: Thu, 9 Mar 2006 01:57:13 +0000
Subject: 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)


git-svn-id: http://piwigo.org/svn/trunk@1071 68402e56-0260-453c-a942-63ccdbb3a9ee
---
 admin.php                                         |  2 +-
 admin/configuration.php                           | 37 ++++++------
 include/page_header.php                           | 16 ++---
 install/config.sql                                |  2 +-
 install/db/13-database.php                        | 73 +++++++++++++++++++++++
 install/phpwebgallery_structure.sql               |  2 +-
 language/en_UK.iso-8859-1/admin.lang.php          |  1 +
 language/en_UK.iso-8859-1/help/configuration.html | 10 ++--
 language/fr_FR.iso-8859-1/admin.lang.php          |  1 +
 language/fr_FR.iso-8859-1/help/configuration.html | 10 ++--
 popuphelp.php                                     |  3 +-
 search_rules.php                                  |  9 +--
 template/yoga/admin/configuration.tpl             | 10 ++--
 template/yoga/header.tpl                          |  5 +-
 14 files changed, 129 insertions(+), 52 deletions(-)
 create mode 100644 install/db/13-database.php

diff --git a/admin.php b/admin.php
index b1070e7ab..4dece56cb 100644
--- a/admin.php
+++ b/admin.php
@@ -57,7 +57,7 @@ $conf_link = $link_start.'configuration&amp;section=';
 $opt_link = $link_start.'cat_options&amp;section=';
 //----------------------------------------------------- template initialization
 $title = l10n('PhpWebGallery Administration'); // for include/page_header.php
-$page['gallery_title'] = l10n('PhpWebGallery Administration');
+$page['page_banner'] = '<h1>'.l10n('PhpWebGallery Administration').'</h1>';
 $page['body_id'] = 'theAdminPage';
 include(PHPWG_ROOT_PATH.'include/page_header.php');
 
diff --git a/admin/configuration.php b/admin/configuration.php
index fdcbabcc4..4d730b953 100644
--- a/admin/configuration.php
+++ b/admin/configuration.php
@@ -50,8 +50,12 @@ while ($row = mysql_fetch_array($result))
   if (isset($_POST[$row['param']]))
   {
     $conf[$row['param']] = $_POST[$row['param']];
+    if ( 'page_banner'==$row['param'] )
+    { // should we do it for all ?
+      $conf[$row['param']] = stripslashes( $conf[$row['param']] );
+    }
   }
-}					   
+}
 //------------------------------ verification and registration of modifications
 if (isset($_POST['submit']))
 {
@@ -105,7 +109,7 @@ if (isset($_POST['submit']))
       break;
     }
   }
-  
+
   // updating configuration if no error found
   if (count($page['errors']) == 0)
   {
@@ -116,16 +120,15 @@ if (isset($_POST['submit']))
       if (isset($_POST[$row['param']]))
       {
         $value = $_POST[$row['param']];
-      
-        if ('gallery_title' == $row['param']
-            or 'gallery_description' == $row['param'])
+
+        if ('gallery_title' == $row['param'])
         {
           if (!$conf['allow_html_descriptions'])
           {
             $value = strip_tags($value);
           }
         }
-        
+
         $query = '
 UPDATE '.CONFIG_TABLE.'
   SET value = \''. str_replace("\'", "''", $value).'\'
@@ -152,7 +155,7 @@ $template->assign_vars(
     'L_RESET'=>$lang['reset'],
 
     'U_HELP' => PHPWG_ROOT_PATH.'/popuphelp.php?page=configuration',
-    
+
     'F_ACTION'=>$action
     ));
 
@@ -161,12 +164,12 @@ switch ($page['section'])
   case 'general' :
   {
     $html_check='checked="checked"';
-    
+
     $history_yes = ($conf['log']=='true')?'checked="checked"':'';
     $history_no  = ($conf['log']=='false')?'checked="checked"':'';
     $lock_yes = ($conf['gallery_locked']=='true')?'checked="checked"':'';
     $lock_no = ($conf['gallery_locked']=='false')?'checked="checked"':'';
-    
+
     $template->assign_block_vars(
       'general',
       array(
@@ -178,7 +181,7 @@ switch ($page['section'])
         ($conf['rate_anonymous']=='true'
              ? 'RATE_ANONYMOUS_YES' : 'RATE_ANONYMOUS_NO')=>$html_check,
         'CONF_GALLERY_TITLE' => $conf['gallery_title'],
-        'CONF_GALLERY_DESCRIPTION' => $conf['gallery_description'],
+        'CONF_PAGE_BANNER' => $conf['page_banner'],
         'CONF_GALLERY_URL' => $conf['gallery_url'],
         ));
     break;
@@ -189,7 +192,7 @@ switch ($page['section'])
     $all_no  = ($conf['comments_forall']=='false')?'checked="checked"':'';
     $validate_yes = ($conf['comments_validation']=='true')?'checked="checked"':'';
     $validate_no = ($conf['comments_validation']=='false')?'checked="checked"':'';
-      
+
     $template->assign_block_vars(
       'comments',
       array(
@@ -207,7 +210,7 @@ switch ($page['section'])
     $show_no = ($conf['show_nb_comments']=='false')?'checked="checked"':'';
     $expand_yes = ($conf['auto_expand']=='true')?'checked="checked"':'';
     $expand_no  = ($conf['auto_expand']=='false')?'checked="checked"':'';
-      
+
     $template->assign_block_vars(
       'default',
       array(
@@ -222,9 +225,9 @@ switch ($page['section'])
         'SHOW_COMMENTS_YES'=>$show_yes,
         'SHOW_COMMENTS_NO'=>$show_no
         ));
-    
+
     $blockname = 'default.language_option';
-    
+
     foreach (get_languages() as $language_code => $language_name)
     {
       if (isset($_POST['submit']))
@@ -241,7 +244,7 @@ switch ($page['section'])
       {
         $selected = '';
       }
-      
+
       $template->assign_block_vars(
         $blockname,
         array(
@@ -269,7 +272,7 @@ switch ($page['section'])
       {
         $selected = '';
       }
-      
+
       $template->assign_block_vars(
         $blockname,
         array(
@@ -280,7 +283,7 @@ switch ($page['section'])
         );
     }
 
- 
+
     break;
   }
 }
diff --git a/include/page_header.php b/include/page_header.php
index 6891787bd..d4c3b9e3d 100644
--- a/include/page_header.php
+++ b/include/page_header.php
@@ -24,7 +24,7 @@
 // | Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, |
 // | USA.                                                                  |
 // +-----------------------------------------------------------------------+
- 
+
 //
 // Start output of page
 //
@@ -38,20 +38,20 @@ $template->assign_vars(
     'GALLERY_TITLE' =>
       isset($page['gallery_title']) ?
         $page['gallery_title'] : $conf['gallery_title'],
-    
-    'GALLERY_DESCRIPTION' =>
-      isset($page['gallery_description']) ?
-        $page['gallery_description'] : $conf['gallery_description'],
-    
+
+    'PAGE_BANNER' =>
+      isset($page['page_banner']) ?
+        $page['page_banner'] : $conf['page_banner'],
+
     'BODY_ID' =>
       isset($page['body_id']) ?
         $page['body_id'] : '',
-    
+
     'CONTENT_ENCODING' => $lang_info['charset'],
     'PAGE_TITLE' => $title,
     'LANG'=>$lang_info['code'],
     'DIR'=>$lang_info['direction'],
-    
+
     'T_STYLE' => $css
     ));
 
diff --git a/install/config.sql b/install/config.sql
index 4371d9fb2..80c572903 100644
--- a/install/config.sql
+++ b/install/config.sql
@@ -15,8 +15,8 @@ INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('auto_expand','fa
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('show_nb_comments','false','Show the number of comments under the thumbnails');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('gallery_locked','false','Lock your gallery temporary for non admin users');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('gallery_title','PhpWebGallery demonstration site','Title at top of each page and for RSS feed');
-INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('gallery_description','My photos web site','Short description displayed with gallery title');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('gallery_url','http://demo.phpwebgallery.net','URL given in RSS feed');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('rate','true','Rating pictures feature is enabled');
 INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('rate_anonymous','true','Rating pictures feature is also enabled for visitors');
+INSERT INTO phpwebgallery_config (param,value,comment) VALUES ('page_banner','<div id=\"theHeader\"><h1>PhpWebGallery demonstration site</h1><p>My photos web site</p></div>','html displayed on the top each page of your gallery');
 
diff --git a/install/db/13-database.php b/install/db/13-database.php
new file mode 100644
index 000000000..ac35cc40c
--- /dev/null
+++ b/install/db/13-database.php
@@ -0,0 +1,73 @@
+<?php
+// +-----------------------------------------------------------------------+
+// | PhpWebGallery - a PHP based picture gallery                           |
+// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
+// | Copyright (C) 2003-2005 PhpWebGallery Team - http://phpwebgallery.net |
+// +-----------------------------------------------------------------------+
+// | branch        : BSF (Best So Far)
+// | file          : $RCSfile$
+// | last update   : $Date: 2005-09-21 00:04:57 +0200 (mer, 21 sep 2005) $
+// | last modifier : $Author: plg $
+// | revision      : $Revision: 870 $
+// +-----------------------------------------------------------------------+
+// | 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.                                                                  |
+// +-----------------------------------------------------------------------+
+
+if (!defined('PHPWG_ROOT_PATH'))
+{
+  die('Hacking attempt!');
+}
+
+$upgrade_description = '#config (gallery_description out page_banner in)';
+
+$query = "
+ALTER TABLE ".PREFIX_TABLE."config MODIFY COLUMN `value` TEXT;";
+pwg_query($query);
+
+
+$query = '
+SELECT value
+  FROM '.PREFIX_TABLE.'config
+  WHERE param=\'gallery_title\'
+;';
+list($t) = array_from_query($query, 'value');
+
+$query = '
+SELECT value
+  FROM '.PREFIX_TABLE.'config
+  WHERE param=\'gallery_description\'
+;';
+list($d) = array_from_query($query, 'value');
+
+$page_banner='<div id="theHeader"><h1>'.$t.'</h1><p>'.$d.'</p></div>';
+$page_banner=addslashes($page_banner);
+$query = '
+INSERT INTO '.PREFIX_TABLE.'config (param,value,comment) VALUES (' .
+"'page_banner','$page_banner','html displayed on the top each page of your gallery');";
+pwg_query($query);
+
+$query = '
+DELETE FROM '.PREFIX_TABLE.'config
+  WHERE param=\'gallery_description\'
+;';
+pwg_query($query);
+
+
+echo
+"\n"
+.'Table '.PREFIX_TABLE.'config updated'
+."\n"
+;
+?>
diff --git a/install/phpwebgallery_structure.sql b/install/phpwebgallery_structure.sql
index 841aed340..e8f07334a 100644
--- a/install/phpwebgallery_structure.sql
+++ b/install/phpwebgallery_structure.sql
@@ -78,7 +78,7 @@ CREATE TABLE `phpwebgallery_comments` (
 DROP TABLE IF EXISTS `phpwebgallery_config`;
 CREATE TABLE `phpwebgallery_config` (
   `param` varchar(40) NOT NULL default '',
-  `value` varchar(255) default NULL,
+  `value` text,
   `comment` varchar(255) default NULL,
   PRIMARY KEY  (`param`)
 ) TYPE=MyISAM COMMENT='configuration table';
diff --git a/language/en_UK.iso-8859-1/admin.lang.php b/language/en_UK.iso-8859-1/admin.lang.php
index 98fdf37a5..0fe6d6606 100644
--- a/language/en_UK.iso-8859-1/admin.lang.php
+++ b/language/en_UK.iso-8859-1/admin.lang.php
@@ -118,6 +118,7 @@ $lang['Permission granted thanks to a group'] = 'Permission granted thanks to a
 $lang['Permission granted'] = 'Permission granted';
 $lang['PhpWebGallery Administration'] = 'PhpWebGallery Administration';
 $lang['PhpWebGallery version'] = 'PhpWebGallery version';
+$lang['Page banner'] = 'Page banner';
 $lang['Picture informations updated'] = 'Picture informations updated';
 $lang['Position'] = 'Position';
 $lang['Preferences'] = 'Preferences';
diff --git a/language/en_UK.iso-8859-1/help/configuration.html b/language/en_UK.iso-8859-1/help/configuration.html
index 4e6a73b5d..3741207e2 100644
--- a/language/en_UK.iso-8859-1/help/configuration.html
+++ b/language/en_UK.iso-8859-1/help/configuration.html
@@ -13,11 +13,11 @@ parameters by theme.</p>
 
 <ul>
 
-  <li><strong>Gallery title</strong>: displayed on top of each public
-  page.</li>
+  <li><strong>Gallery title</strong>: used in RSS feed and notifications by
+email.</li>
 
-  <li><strong>Gallery description</strong>: displayed under gallery
-  title.</li>
+  <li><strong>Page banner</strong>: displayed on top of each public
+page.</li>
 
   <li><strong>Gallery URL</strong>: used for the RSS feed.</li>
 
@@ -33,7 +33,7 @@ parameters by theme.</p>
 
   <li><strong>Rating</strong>: Picture rating feature is enabled.</li>
 
-  <li><strong>Rating by guests</strong>: Even non registered users can 
+  <li><strong>Rating by guests</strong>: Even non registered users can
 rate images.</li>
 
 </ul>
diff --git a/language/fr_FR.iso-8859-1/admin.lang.php b/language/fr_FR.iso-8859-1/admin.lang.php
index c13dfda82..900d412df 100644
--- a/language/fr_FR.iso-8859-1/admin.lang.php
+++ b/language/fr_FR.iso-8859-1/admin.lang.php
@@ -111,6 +111,7 @@ $lang['Options'] = 'Options';
 $lang['Order alphanumerically'] = 'Ordonner alphabético-numériquement';
 $lang['Order by'] = 'Trier selon';
 $lang['Other private categories'] = 'Autres catégories privées';
+$lang['Page banner'] = 'Bannière des pages';
 $lang['Parent category'] = 'Catégorie parente';
 $lang['Path'] = 'Chemin';
 $lang['Permission denied'] = 'Accès interdit';
diff --git a/language/fr_FR.iso-8859-1/help/configuration.html b/language/fr_FR.iso-8859-1/help/configuration.html
index 55b453e83..5de6c9515 100644
--- a/language/fr_FR.iso-8859-1/help/configuration.html
+++ b/language/fr_FR.iso-8859-1/help/configuration.html
@@ -13,11 +13,11 @@ par th
 
 <ul>
 
-  <li><strong>Titre de la galerie</strong>: affiché en haut de chaque page
-de la partie publique.</li>
+  <li><strong>Titre de la galerie</strong>: utilisé pour le flux RSS et
+la notification par email.</li>
 
-  <li><strong>Description de la galerie</strong>: affiché en dessous du
-titre de la galerie.</li>
+  <li><strong>Bannière des pages</strong>: code html affiché en haut des
+pages.</li>
 
   <li><strong>URL de la galerie</strong>: utilisé pour le flux RSS.</li>
 
@@ -33,7 +33,7 @@ galerie.</li>
 
   <li><strong>Notation</strong>: La notation des photos est possible.</li>
 
-  <li><strong>Notation par les visiteurs</strong>: Même les utilisateurs 
+  <li><strong>Notation par les visiteurs</strong>: Même les utilisateurs
 non enregistrés peuvent noter les images.</li>
 
 </ul>
diff --git a/popuphelp.php b/popuphelp.php
index 0c5c205da..888af4258 100644
--- a/popuphelp.php
+++ b/popuphelp.php
@@ -33,7 +33,8 @@ define('PHPWG_ROOT_PATH','./');
 include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
 
 $page['body_id'] = 'thePopuphelpPage';
-$page['gallery_title'] = $title = l10n('PhpWebGallery Help');
+$title = l10n('PhpWebGallery Help');
+$page['page_banner'] = '<h1>'.$title.'</h1>';
 include(PHPWG_ROOT_PATH.'include/page_header.php');
 
 $template->set_filenames(
diff --git a/search_rules.php b/search_rules.php
index 68407fb29..ef51ffe49 100644
--- a/search_rules.php
+++ b/search_rules.php
@@ -45,7 +45,8 @@ define('PHPWG_ROOT_PATH','./');
 include_once( PHPWG_ROOT_PATH.'include/common.inc.php' );
 
 $page['body_id'] = 'thePopuphelpPage';
-$page['gallery_title'] = $title = l10n('PhpWebGallery Help');
+$title = l10n('PhpWebGallery Help');
+$page['page_banner'] = '<h1>'.$title.'</h1>';
 include(PHPWG_ROOT_PATH.'include/page_header.php');
 
 $template->set_filenames(array('search_rules' => 'search_rules.tpl'));
@@ -194,7 +195,7 @@ foreach (array('date_available', 'date_creation') as $datefield)
       array(
         'CONTENT' => sprintf(
           l10n($lang_items['period']),
-          
+
           format_date($search['fields'][ $keys['after'] ]['date']),
           inc_exc_str($search['fields'][ $keys['after'] ]['inc']),
 
@@ -211,7 +212,7 @@ foreach (array('date_available', 'date_creation') as $datefield)
       array(
         'CONTENT' => sprintf(
           l10n($lang_items['before']),
-          
+
           format_date($search['fields'][ $keys['before'] ]['date']),
           inc_exc_str($search['fields'][ $keys['before'] ]['inc'])
           ),
@@ -225,7 +226,7 @@ foreach (array('date_available', 'date_creation') as $datefield)
       array(
         'CONTENT' => sprintf(
           l10n($lang_items['after']),
-          
+
           format_date($search['fields'][ $keys['after'] ]['date']),
           inc_exc_str($search['fields'][ $keys['after'] ]['inc'])
           )
diff --git a/template/yoga/admin/configuration.tpl b/template/yoga/admin/configuration.tpl
index 82982dfd4..0c7c1817d 100644
--- a/template/yoga/admin/configuration.tpl
+++ b/template/yoga/admin/configuration.tpl
@@ -19,12 +19,12 @@
     </li>
 
     <li>
-      <label for="gallery_description"><strong>{lang:Gallery description}</strong></label>
-      <textarea cols="50" rows="5" name="gallery_description" id="gallery_description">{general.CONF_GALLERY_DESCRIPTION}</textarea>
+      <label for="page_banner"><strong>{lang:Page banner}</strong></label>
+      <textarea cols="50" rows="5" name="page_banner" id="page_banner">{general.CONF_PAGE_BANNER}</textarea>
     </li>
 
     <li>
-      <label for="gallery_title"><strong>{lang:Gallery URL}</strong></label>
+      <label for="gallery_url"><strong>{lang:Gallery URL}</strong></label>
       <input type="text" maxlength="255" size="50" name="gallery_url" id="gallery_url" value="{general.CONF_GALLERY_URL}" />
     </li>
 
@@ -40,7 +40,7 @@
       <input type="radio" class="radio" name="gallery_locked" value="false" {general.GALLERY_LOCKED_NO} />{lang:No}
     </li>
   </ul>
-  
+
   <ul>
     <li>
       <label><strong>{lang:Rating}</strong></label>
@@ -139,7 +139,7 @@
   </ul>
 <!-- END default -->
   </fieldset>
-  
+
   <p>
     <input type="submit" name="submit" value="{lang:Submit}">
     <input type="reset" name="reset" value="{lang:Reset}">
diff --git a/template/yoga/header.tpl b/template/yoga/header.tpl
index 9936a1095..ccf80d74f 100644
--- a/template/yoga/header.tpl
+++ b/template/yoga/header.tpl
@@ -27,7 +27,4 @@ the "text/nonsense" prevents gecko based browsers to load it -->
 <body id="{BODY_ID}">
 <div id="the_page">
 
-<div id="theHeader">
-  <h1>{GALLERY_TITLE}</h1>
-  <p>{GALLERY_DESCRIPTION}</p>
-</div>
+{PAGE_BANNER}
-- 
cgit v1.2.3