Subversion Repositories svnkaklik

<?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: cat_list.php,v $

// | last update   : $Date: 2005/05/01 14:19:38 $

// | last modifier : $Author: plg $

// | revision      : $Revision: 1.32.2.1 $

// +-----------------------------------------------------------------------+

// | 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/isadmin.inc.php');

// +-----------------------------------------------------------------------+

// |                            initialization                             |

// +-----------------------------------------------------------------------+

$errors = array();

$infos = array();

$categories = array();

$navigation = $lang['home'];

// +-----------------------------------------------------------------------+

// |                    virtual categories management                      |

// +-----------------------------------------------------------------------+

// request to delete a virtual category

if (isset($_GET['delete']) and is_numeric($_GET['delete']))

{

  delete_categories(array($_GET['delete']));

  array_push($infos, $lang['cat_virtual_deleted']);

  ordering();

  update_global_rank();

}

// request to add a virtual category

else if (isset($_POST['submit']))

{

  // is the given category name only containing blank spaces ?

  if (preg_match('/^\s*$/', $_POST['virtual_name']))

  {

    array_push($errors, $lang['cat_error_name']);

  }

  if (!count($errors))

  {

    $parent_id = !empty($_GET['parent_id'])?$_GET['parent_id']:'NULL';

    if ($parent_id != 'NULL')

    {

      $query = '

SELECT id,uppercats,global_rank,visible,status

  FROM '.CATEGORIES_TABLE.'

  WHERE id = '.$parent_id.'

;';

      $row = mysql_fetch_array(pwg_query($query));

      $parent = array('id' => $row['id'],

                      'uppercats' => $row['uppercats'],

                      'visible' => $row['visible'],

                      'status' => $row['status'],

                      'global_rank' => $row['global_rank']);

    }

    // what will be the inserted id ?

    $query = '

SELECT IF(MAX(id)+1 IS NULL, 1, MAX(id)+1)

  FROM '.CATEGORIES_TABLE.'

;';

    list($next_id) = mysql_fetch_array(pwg_query($query));

    $insert = array();

    $insert{'id'} = $next_id++;

    $insert{'name'} = $_POST['virtual_name'];

    $insert{'rank'} = $_POST['rank'];

    $insert{'commentable'} = $conf['newcat_default_commentable'];

    // a virtual category can't be uploadable

    $insert{'uploadable'} = 'false';

    if (isset($parent))

    {

      $insert{'id_uppercat'} = $parent{'id'};

      $insert{'uppercats'}   = $parent{'uppercats'}.','.$insert{'id'};

      $insert{'global_rank'} = $parent{'global_rank'}.'.'.$insert{'rank'};

      // at creation, must a category be visible or not ? Warning : if

      // the parent category is invisible, the category is automatically

      // create invisible. (invisible = locked)

      if ('false' == $parent['visible'])

      {

        $insert{'visible'} = 'false';

      }

      else

      {

        $insert{'visible'} = $conf['newcat_default_visible'];

      }

      // at creation, must a category be public or private ? Warning :

      // if the parent category is private, the category is

      // automatically create private.

      if ('private' == $parent['status'])

      {

        $insert{'status'} = 'private';

      }

      else

      {

        $insert{'status'} = $conf['newcat_default_status'];

      }

    }

    else

    {

      $insert{'visible'} = $conf['newcat_default_visible'];

      $insert{'status'} = $conf['newcat_default_status'];

      $insert{'uppercats'} = $insert{'id'};

      $insert{'global_rank'} = $insert{'rank'};

    }

    $inserts = array($insert);

    // we have then to add the virtual category

    $dbfields = array('id','site_id','name','id_uppercat','rank',

                      'commentable','uploadable','visible','status',

                      'uppercats','global_rank');

    mass_inserts(CATEGORIES_TABLE, $dbfields, $inserts);

    array_push($infos, $lang['cat_virtual_added']);

  }

}

// +-----------------------------------------------------------------------+

// |                           Cache management                            |

// +-----------------------------------------------------------------------+

$query = '

SELECT *

  FROM '.CATEGORIES_TABLE;

if (!isset($_GET['parent_id']))

{

  $query.= '

  WHERE id_uppercat IS NULL';

}

else

{

  $query.= '

  WHERE id_uppercat = '.$_GET['parent_id'];

}

$query.= '

  ORDER BY rank ASC

;';

$result = pwg_query($query);

while ($row = mysql_fetch_assoc($result))

{

  $categories[$row['rank']] = $row;

  $categories[$row['rank']]['nb_subcats'] = 0;

}

// +-----------------------------------------------------------------------+

// |                            Navigation path                            |

// +-----------------------------------------------------------------------+

if (isset($_GET['parent_id']))

{

  $base_url = PHPWG_ROOT_PATH.'admin.php?page=cat_list';

  $navigation = '<a class="" href="'.add_session_id($base_url).'">';

  $navigation.= $lang['home'];

  $navigation.= '</a>';

  $navigation.= $conf['level_separator'];

  $current_category = get_cat_info($_GET['parent_id']);

  $navigation.= get_cat_display_name($current_category['name'],

                                     $base_url.'&parent_id=',

                                     false);

}

// +-----------------------------------------------------------------------+

// |                               rank updates                            |

// +-----------------------------------------------------------------------+

$current_rank = 0;

if (isset($_GET['up']) and is_numeric($_GET['up']))

{

  // 1. searching the id of the category just above at the same level

  while (list ($id,$current) = each($categories))

  {

    if ($current['id'] == $_GET['up'])

    {

      $current_rank = $current['rank'];

      break;

    }

  }

  if ($current_rank > 1)

  {

    // 2. Exchanging ranks between the two categories

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = '.($current_rank-1).'

  WHERE id = '.$_GET['up'].'

;';

    pwg_query($query);

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = '.$current_rank.'

  WHERE id = '.$categories[($current_rank-1)]['id'].'

;';

    pwg_query($query);

    // 3. Updating the cache array

    $categories[$current_rank] = $categories[($current_rank-1)];

    $categories[($current_rank-1)] = $current;

  }

  else

  {

    // 2. Updating the rank of our category to be after the previous max rank

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = '.(count($categories) + 1).'

  WHERE id = '.$_GET['up'].'

;';

    pwg_query($query);

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = rank-1

  WHERE id_uppercat ';

    if (empty($_GET['parent_id']))

    {

      $query.= 'IS NULL';

    }

    else

    {

      $query.= '= '.$_GET['parent_id'];

    }

    $query.= '

;';

    pwg_query($query);

    // 3. Updating the cache array

    array_push($categories, $current);

    array_shift($categories);

  }

  update_global_rank(@$_GET['parent_id']);

}

else if (isset($_GET['down']) and is_numeric($_GET['down']))

{

  // 1. searching the id of the category just above at the same level

  while (list ($id,$current) = each($categories))

  {

    if ($current['id'] == $_GET['down'])

    {

      $current_rank = $current['rank'];

      break;

    }

  }

  if ($current_rank < count($categories))

  {

    // 2. Exchanging ranks between the two categories

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = '.($current_rank+1).'

  WHERE id = '.$_GET['down'].'

;';

    pwg_query($query);

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = '.$current_rank.'

  WHERE id = '.$categories[($current_rank+1)]['id'].'

;';

    pwg_query($query);

    // 3. Updating the cache array

    $categories[$current_rank]=$categories[($current_rank+1)];

    $categories[($current_rank+1)] = $current;

  }

  else 

  {

    // 2. updating the rank of our category to be the first one

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = 0

  WHERE id = '.$_GET['down'].'

;';

    pwg_query($query);

    $query = '

UPDATE '.CATEGORIES_TABLE.'

  SET rank = rank+1

  WHERE id_uppercat ';

    if (empty($_GET['parent_id']))

    {

      $query.= 'IS NULL';

    }

    else

    {

      $query.= '= '.$_GET['parent_id'];

    }

    $query.= '

;';

    pwg_query($query);

    // 3. Updating the cache array

    array_unshift($categories, $current);

    array_pop($categories);

  }

  update_global_rank(@$_GET['parent_id']);

}

reset($categories);

// +-----------------------------------------------------------------------+

// |                       template initialization                         |

// +-----------------------------------------------------------------------+

$template->set_filenames(array('categories'=>'admin/cat_list.tpl'));

$form_action = PHPWG_ROOT_PATH.'admin.php?page=cat_list';

if (isset($_GET['parent_id']))

{

  $form_action.= '&parent_id='.$_GET['parent_id'];

}

if (count($categories) > 0)

{

  $next_rank = max(array_keys($categories)) + 1;

}

else

{

  $next_rank = 1;

}

$template->assign_vars(array(

  'CATEGORIES_NAV'=>$navigation,

  'NEXT_RANK'=>$next_rank,

  'F_ACTION'=>add_session_id($form_action),

  'L_ADD_VIRTUAL'=>$lang['cat_add'],

  'L_SUBMIT'=>$lang['submit'],

  'L_STORAGE'=>$lang['storage'],

  'L_NB_IMG'=>$lang['pictures'],

  'L_MOVE_UP'=>$lang['up'],

  'L_MOVE_DOWN'=>$lang['down'],

  'L_EDIT'=>$lang['edit'],

  'L_INFO_IMG'=>$lang['cat_image_info'],

  'L_DELETE'=>$lang['delete'],

 ));

$tpl = array('cat_first','cat_last');

// +-----------------------------------------------------------------------+

// |                            errors & infos                             |

// +-----------------------------------------------------------------------+

if (count($errors) != 0)

{

  $template->assign_block_vars('errors',array());

  foreach ($errors as $error)

  {

    $template->assign_block_vars('errors.error',array('ERROR'=>$error));

  }

}

if (count($infos) != 0)

{

  $template->assign_block_vars('infos',array());

  foreach ($infos as $info)

  {

    $template->assign_block_vars('infos.info',array('INFO'=>$info));

  }

}

// +-----------------------------------------------------------------------+

// |                          Categories display                           |

// +-----------------------------------------------------------------------+

$ranks = array();

if (count($categories) > 0)

{

  foreach ($categories as $category)

  {

    $ranks[$category['id']] = $category['rank'];

  }

  $query = '

SELECT id_uppercat, COUNT(*) AS nb_subcats

  FROM '. CATEGORIES_TABLE.'

  WHERE id_uppercat IN ('.implode(',', array_keys($ranks)).')

  GROUP BY id_uppercat

;';

  $result = pwg_query($query);

  while ($row = mysql_fetch_array($result))

  {

    $categories[$ranks[$row['id_uppercat']]]['nb_subcats']

      = $row['nb_subcats'];

  }

}

foreach ($categories as $category)

{

  $images_folder = PHPWG_ROOT_PATH.'template/';

  $images_folder.= $user['template'].'/admin/images';

  if ($category['visible'] == 'false')

  {

    $image_src = $images_folder.'/icon_folder_lock.gif';

    $image_alt = $lang['cat_private'];

    $image_title = $lang['cat_private'];

  }

  else if (empty($category['dir']))

  {

    $image_src = $images_folder.'/icon_folder_link.gif';

    $image_alt = $lang['cat_virtual'];

    $image_title = $lang['cat_virtual'];

  }

  else

  {

    if ($category['nb_subcats'] > 0)

    {

      $image_src = $images_folder.'/icon_subfolder.gif';

    }

    else

    {

      $image_src = $images_folder.'/icon_folder.gif';

    }

    $image_alt = '';

    $image_title = '';

  }

  $base_url = PHPWG_ROOT_PATH.'admin.php?page=';

  $cat_list_url = $base_url.'cat_list';

  $self_url = $cat_list_url;

  if (isset($_GET['parent_id']))

  {

    $self_url.= '&parent_id='.$_GET['parent_id'];

  }

  $template->assign_block_vars(

    'category',

    array(

      'CATEGORY_IMG_SRC'=>$image_src,

      'CATEGORY_IMG_ALT'=>$image_alt,

      'CATEGORY_IMG_TITLE'=>$image_title,

      'CATEGORY_NAME'=>$category['name'],

      'CATEGORY_DIR'=>@$category['dir'],

      'CATEGORY_NB_IMG'=>$category['nb_images'],

      'U_CATEGORY'=>

      add_session_id($cat_list_url.'&parent_id='.$category['id']),

      'U_MOVE_UP'=>add_session_id($self_url.'&up='.$category['id']),

      'U_MOVE_DOWN'=>add_session_id($self_url.'&down='.$category['id']),

      'U_CAT_EDIT'=>

      add_session_id($base_url.'cat_modify&cat_id='.$category['id']),

      'U_CAT_DELETE'=>add_session_id($self_url.'&delete='.$category['id']),

      'U_INFO_IMG'

      => add_session_id($base_url.'infos_images&cat_id='.$category['id'])

      ));

  if (!empty($category['dir']))

  {

    $template->assign_block_vars('category.storage' ,array());

  }

  else

  {

    $template->assign_block_vars('category.virtual' ,array());

  }

  if ($category['nb_images'] > 0)

  {

    $template->assign_block_vars('category.image_info' ,array());

  }

  else

  {

    $template->assign_block_vars('category.no_image_info' ,array()); 

  }

}

// +-----------------------------------------------------------------------+

// |                          sending html code                            |

// +-----------------------------------------------------------------------+

$template->assign_var_from_handle('ADMIN_CONTENT', 'categories');

?>