source: trunk/admin/configuration.php @ 1865

<?php
// +-----------------------------------------------------------------------+
// | PhpWebGallery - a PHP based picture gallery                           |
// | Copyright (C) 2002-2003 Pierrick LE GALL - pierrick@phpwebgallery.net |
// | Copyright (C) 2003-2007 PhpWebGallery Team - http://phpwebgallery.net |
// +-----------------------------------------------------------------------+
// | branch        : BSF (Best So Far)
// | file          : $RCSfile$
// | last update   : $Date: 2007-02-28 00:16:53 +0000 (Wed, 28 Feb 2007) $
// | last modifier : $Author: rvelices $
// | revision      : $Revision: 1865 $
// +-----------------------------------------------------------------------+
// | 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!");
}

include_once(PHPWG_ROOT_PATH.'admin/include/functions.php');

// +-----------------------------------------------------------------------+
// | Check Access and exit when user status is not ok                      |
// +-----------------------------------------------------------------------+
check_status(ACCESS_ADMINISTRATOR);

//-------------------------------------------------------- sections definitions
if (!isset($_GET['section']))
{
  $page['section'] = 'general';
}
else
{
  $page['section'] = $_GET['section'];
}

$general_checkboxes = array(
    'log',
    'history_admin',
    'history_guest',
    'email_admin_on_new_user',
    'allow_user_registration',
   );

$comments_checkboxes = array(
    'comments_forall',
    'comments_validation',
    'email_admin_on_comment',
    'email_admin_on_comment_validation',
  );

//------------------------------ verification and registration of modifications
if (isset($_POST['submit']) and !is_adviser())
{
  $int_pattern = '/^\d+$/';
  switch ($page['section'])
  {
    case 'general' :
    {
      if ( !url_is_remote($_POST['gallery_url']) )
      {
        array_push($page['errors'], $lang['conf_gallery_url_error']);
      }
      foreach( $general_checkboxes as $checkbox)
      {
        $_POST[$checkbox] = empty($_POST[$checkbox])?'false':'true';
      }
      break;
    }
    case 'comments' :
    {
      // the number of comments per page must be an integer between 5 and 50
      // included
      if (!preg_match($int_pattern, $_POST['nb_comment_page'])
           or $_POST['nb_comment_page'] < 5
           or $_POST['nb_comment_page'] > 50)
      {
        array_push($page['errors'], $lang['conf_nb_comment_page_error']);
      }
      foreach( $comments_checkboxes as $checkbox)
      {
        $_POST[$checkbox] = empty($_POST[$checkbox])?'false':'true';
      }
      break;
    }
    case 'default' :
    {
      // periods must be integer values, they represents number of days
      if (!preg_match($int_pattern, $_POST['recent_period'])
          or $_POST['recent_period'] <= 0)
      {
        array_push($page['errors'], $lang['periods_error']);
      }
      // maxwidth
      if (isset($_POST['default_maxwidth'])
          and !empty($_POST['default_maxwidth'])
          and (!preg_match($int_pattern, $_POST['default_maxwidth'])
               or $_POST['default_maxwidth'] < 50))
      {
        array_push($page['errors'], $lang['maxwidth_error']);
      }
      // maxheight
      if (isset($_POST['default_maxheight'])
          and !empty($_POST['default_maxheight'])
          and (!preg_match($int_pattern, $_POST['default_maxheight'])
               or $_POST['default_maxheight'] < 50))
      {
        array_push($page['errors'], $lang['maxheight_error']);
      }
      break;
    }
  }

  // updating configuration if no error found
  if (count($page['errors']) == 0)
  {
    //echo '<pre>'; print_r($_POST); echo '</pre>';
    $result = pwg_query('SELECT param FROM '.CONFIG_TABLE);
    while ($row = mysql_fetch_array($result))
    {
      if (isset($_POST[$row['param']]))
      {
        $value = $_POST[$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).'\'
  WHERE param = \''.$row['param'].'\'
;';
        pwg_query($query);
      }
    }
    array_push($page['infos'], $lang['conf_confirmation']);
  }

  //------------------------------------------------------ $conf reinitialization
  load_conf_from_db();
}

if ( $page['section']=='comments' and !is_adviser() )
{
  if (isset($_POST['falsify'])
      and isset($_POST['cat_true'])
      and count($_POST['cat_true']) > 0)
  {
      $query = '
UPDATE '.CATEGORIES_TABLE.'
  SET commentable = \'false\'
  WHERE id IN ('.implode(',', $_POST['cat_true']).')
;';
      pwg_query($query);
  }
  if (isset($_POST['trueify'])
         and isset($_POST['cat_false'])
         and count($_POST['cat_false']) > 0)
  {
      $query = '
UPDATE '.CATEGORIES_TABLE.'
  SET commentable = \'true\'
  WHERE id IN ('.implode(',', $_POST['cat_false']).')
;';
      pwg_query($query);
  }
}

//----------------------------------------------------- template initialization
$template->set_filenames( array('config'=>'admin/configuration.tpl') );

$action = PHPWG_ROOT_PATH.'admin.php?page=configuration';
$action.= '&amp;section='.$page['section'];

$template->assign_vars(
  array(
    'L_YES'=>$lang['yes'],
    'L_NO'=>$lang['no'],
    'L_SUBMIT'=>$lang['submit'],
    'L_RESET'=>$lang['reset'],

    'U_HELP' => PHPWG_ROOT_PATH.'popuphelp.php?page=configuration',

    'F_ACTION'=>$action
    ));

$html_check='checked="checked"';

switch ($page['section'])
{
  case 'general' :
  {
    $lock_yes = ($conf['gallery_locked']==true)?'checked="checked"':'';
    $lock_no = ($conf['gallery_locked']==false)?'checked="checked"':'';

    $template->assign_block_vars(
      'general',
      array(
        'GALLERY_LOCKED_YES'=>$lock_yes,
        'GALLERY_LOCKED_NO'=>$lock_no,
        ($conf['rate']==true?'RATE_YES':'RATE_NO')=>$html_check,
        ($conf['rate_anonymous']==true
             ? 'RATE_ANONYMOUS_YES' : 'RATE_ANONYMOUS_NO')=>$html_check,
        'CONF_GALLERY_TITLE' => $conf['gallery_title'],
        'CONF_PAGE_BANNER' => $conf['page_banner'],
        'CONF_GALLERY_URL' => $conf['gallery_url'],
        ));

    foreach( $general_checkboxes as $checkbox)
    {
      $template->merge_block_vars(
          'general',
          array(
            strtoupper($checkbox) => ($conf[$checkbox]==true)?$html_check:''
            )
        );
    }
    break;
  }
  case 'comments' :
  {
    $template->assign_block_vars(
      'comments',
      array(
        'NB_COMMENTS_PAGE'=>$conf['nb_comment_page'],
        ));

    foreach( $comments_checkboxes as $checkbox)
    {
      $template->merge_block_vars(
          'comments',
          array(
            strtoupper($checkbox) => ($conf[$checkbox]==true)?$html_check:''
            )
        );
    }
    
    $query_true = '
SELECT id,name,uppercats,global_rank
  FROM '.CATEGORIES_TABLE.'
  WHERE commentable = \'true\'
;';
    $query_false = '
SELECT id,name,uppercats,global_rank
  FROM '.CATEGORIES_TABLE.'
  WHERE commentable = \'false\'
;';
    display_select_cat_wrapper($query_true,array(),'comments.category_option_true');
    display_select_cat_wrapper($query_false,array(),'comments.category_option_false');
    break;
  }
  case 'default' :
  {
    $show_yes = ($conf['show_nb_comments']==true)?'checked="checked"':'';
    $show_no = ($conf['show_nb_comments']==false)?'checked="checked"':'';
    $hits_yes = ($conf['show_nb_hits']==true)?'checked="checked"':'';
    $hits_no = ($conf['show_nb_hits']==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(
        'NB_IMAGE_LINE'=>$conf['nb_image_line'],
        'NB_ROW_PAGE'=>$conf['nb_line_page'],
        'CONF_RECENT'=>$conf['recent_period'],
        'NB_COMMENTS_PAGE'=>$conf['nb_comment_page'],
        'MAXWIDTH'=>$conf['default_maxwidth'],
        'MAXHEIGHT'=>$conf['default_maxheight'],
        'EXPAND_YES'=>$expand_yes,
        'EXPAND_NO'=>$expand_no,
        'SHOW_COMMENTS_YES'=>$show_yes,
        'SHOW_COMMENTS_NO'=>$show_no,
        'SHOW_HITS_YES'=>$hits_yes,
        'SHOW_HITS_NO'=>$hits_no,
        ));

    $blockname = 'default.language_option';

    foreach (get_languages() as $language_code => $language_name)
    {
      if (isset($_POST['submit']))
      {
        $selected =
          $_POST['default_language'] == $language_code
            ? 'selected="selected"' : '';
      }
      else if ($conf['default_language'] == $language_code)
      {
        $selected = 'selected="selected"';
      }
      else
      {
        $selected = '';
      }

      $template->assign_block_vars(
        $blockname,
        array(
          'VALUE'=> $language_code,
          'CONTENT' => $language_name,
          'SELECTED' => $selected
          ));
    }

    $blockname = 'default.template_option';

    foreach (get_pwg_themes() as $pwg_template)
    {
      if (isset($_POST['submit']))
      {
        $selected =
          $_POST['default_template'] == $pwg_template
            ? 'selected="selected"' : '';
      }
      else if ($conf['default_template'] == $pwg_template)
      {
        $selected = 'selected="selected"';
      }
      else
      {
        $selected = '';
      }

      $template->assign_block_vars(
        $blockname,
        array(
          'VALUE'=> $pwg_template,
          'CONTENT' => $pwg_template,
          'SELECTED' => $selected
          )
        );
    }


    break;
  }
}
//----------------------------------------------------------- sending html code
$template->assign_var_from_handle('ADMIN_CONTENT', 'config');
?>