From 0ec91d8b4834d63c65dcbef6ac49ab5a8f68ddd1 Mon Sep 17 00:00:00 2001 From: z0rglub Date: Tue, 1 Jul 2003 09:27:20 +0000 Subject: *** empty log message *** git-svn-id: http://piwigo.org/svn/trunk@21 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/cat_list.php | 293 +++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 293 insertions(+) create mode 100644 admin/cat_list.php (limited to 'admin/cat_list.php') diff --git a/admin/cat_list.php b/admin/cat_list.php new file mode 100644 index 000000000..a0c7696b7 --- /dev/null +++ b/admin/cat_list.php @@ -0,0 +1,293 @@ + * + * * + ***************************************************************************/ + +/*************************************************************************** + * * + * 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; * + * * + ***************************************************************************/ +include_once( './include/isadmin.inc.php' ); +//----------------------------------------------------- template initialization +$sub = $vtp->Open( '../template/'.$user['template'].'/admin/cat_list.vtp' ); +// language +$vtp->setGlobalVar( $sub, 'cat_edit', $lang['cat_edit'] ); +$vtp->setGlobalVar( $sub, 'cat_up', $lang['cat_up'] ); +$vtp->setGlobalVar( $sub, 'cat_down', $lang['cat_down'] ); +$vtp->setGlobalVar( $sub, 'cat_image_info', $lang['cat_image_info'] ); +$vtp->setGlobalVar( $sub, 'cat_permission', $lang['cat_permission'] ); +$vtp->setGlobalVar( $sub, 'cat_update', $lang['cat_update'] ); +//--------------------------------------------------------------- rank updates +if ( isset( $_GET['up'] ) && is_numeric( $_GET['up'] ) ) +{ + // 1. searching level (id_uppercat) + // and rank of the category to move + $query = 'SELECT id_uppercat,rank'; + $query.= ' FROM '.PREFIX_TABLE.'categories'; + $query.= ' WHERE id = '.$_GET['up']; + $query.= ';'; + $row = mysql_fetch_array( mysql_query( $query ) ); + $level = $row['id_uppercat']; + $rank = $row['rank']; + // 2. searching the id and the rank of the category + // just above at the same level + $query = 'SELECT id,rank'; + $query.= ' FROM '.PREFIX_TABLE.'categories'; + $query.= ' WHERE rank < '.$rank; + if ( $level == '' ) + { + $query.= ' AND id_uppercat IS NULL'; + } + else + { + $query.= ' AND id_uppercat = '.$level; + } + $query.= ' ORDER BY rank DESC'; + $query.= ' LIMIT 0,1'; + $query.= ';'; + $row = mysql_fetch_array( mysql_query( $query ) ); + $new_rank = $row['rank']; + $replaced_cat = $row['id']; + // 3. exchanging ranks between the two categories + $query = 'UPDATE '.PREFIX_TABLE.'categories'; + $query.= ' SET rank = '.$new_rank; + $query.= ' WHERE id = '.$_GET['up']; + $query.= ';'; + mysql_query( $query ); + $query = 'UPDATE '.PREFIX_TABLE.'categories'; + $query.= ' SET rank = '.$rank; + $query.= ' WHERE id = '.$replaced_cat; + $query.= ';'; + mysql_query( $query ); +} +if ( isset( $_GET['down'] ) && is_numeric( $_GET['down'] ) ) +{ + // 1. searching level (id_uppercat) + // and rank of the category to move + $query = 'SELECT id_uppercat,rank'; + $query.= ' FROM '.PREFIX_TABLE.'categories'; + $query.= ' WHERE id = '.$_GET['down']; + $query.= ';'; + $row = mysql_fetch_array( mysql_query( $query ) ); + $level = $row['id_uppercat']; + $rank = $row['rank']; + // 2. searching the id and the rank of the category + // just below at the same level + $query = 'SELECT id,rank'; + $query.= ' FROM '.PREFIX_TABLE.'categories'; + $query.= ' WHERE rank > '.$rank; + if ( $level == '' ) + { + $query.= ' AND id_uppercat is null'; + } + else + { + $query.= ' AND id_uppercat = '.$level; + } + $query.= ' ORDER BY rank ASC'; + $query.= ' LIMIT 0,1'; + $query.= ';'; + $row = mysql_fetch_array( mysql_query( $query ) ); + $new_rank = $row['rank']; + $replaced_cat = $row['id']; + // 3. exchanging ranks between the two categories + $query = 'UPDATE '.PREFIX_TABLE.'categories'; + $query.= ' SET rank = '.$new_rank; + $query.= ' WHERE id = '.$_GET['down']; + $query.= ';'; + mysql_query( $query ); + $query = 'UPDATE '.PREFIX_TABLE.'categories'; + $query.= ' SET rank = '.$rank; + $query.= ' WHERE id = '.$replaced_cat; + $query.= ';'; + mysql_query( $query ); +} +//------------------------------------------------------------------ reordering +function ordering( $id_uppercat ) +{ + $rank = 1; + + $query = 'SELECT id'; + $query.= ' FROM '.PREFIX_TABLE.'categories'; + if ( !is_numeric( $id_uppercat ) ) + { + $query.= ' WHERE id_uppercat IS NULL'; + } + else + { + $query.= ' WHERE id_uppercat = '.$id_uppercat; + } + $query.= ' ORDER BY rank ASC, dir ASC'; + $query.= ';'; + $result = mysql_query( $query ); + while ( $row = mysql_fetch_array( $result ) ) + { + $query = 'UPDATE '.PREFIX_TABLE.'categories'; + $query.= ' SET rank = '.$rank; + $query.= ' WHERE id = '.$row['id']; + $query.= ';'; + mysql_query( $query ); + $rank++; + ordering( $row['id'] ); + } +} + +ordering( 'NULL' ); +//----------------------------------------------------affichage de la page +function display_cat_manager( $id_uppercat, $indent, + $uppercat_visible, $level ) +{ + global $lang,$conf,$sub,$vtp; + + // searching the min_rank and the max_rank of the category + $query = 'SELECT MIN(rank) AS min, MAX(rank) AS max'; + $query.= ' FROM '.PREFIX_TABLE.'categories'; + if ( !is_numeric( $id_uppercat ) ) + { + $query.= ' WHERE id_uppercat IS NULL'; + } + else + { + $query.= ' WHERE id_uppercat = '.$id_uppercat; + } + $query.= ';'; + $result = mysql_query( $query ); + $row = mysql_fetch_array( $result ); + $min_rank = $row['min']; + $max_rank = $row['max']; + + // will we use or lines ? + $td = 'td'; + $class = ''; + if ( $level > 0 ) + { + $class = 'row'.$level; + } + else + { + $td = 'th'; + } + + $query = 'SELECT id,name,dir,nb_images,status,rank,site_id,visible'; + $query.= ' FROM '.PREFIX_TABLE.'categories'; + if ( !is_numeric( $id_uppercat ) ) + { + $query.= ' WHERE id_uppercat IS NULL'; + } + else + { + $query.= ' WHERE id_uppercat = '.$id_uppercat; + } + $query.= ' ORDER BY rank ASC'; + $query.= ';'; + $result = mysql_query( $query ); + while ( $row = mysql_fetch_array( $result ) ) + { + $subcat_visible = true; + + $vtp->addSession( $sub, 'cat' ); + $vtp->setVar( $sub, 'cat.td', $td ); + $vtp->setVar( $sub, 'cat.class', $class ); + $vtp->setVar( $sub, 'cat.indent', $indent ); + if ( $row['name'] == '' ) + { + $name = str_replace( '_', ' ', $row['dir'] ); + } + else + { + $name = $row['name']; + } + $vtp->setVar( $sub, 'cat.name', $name ); + $vtp->setVar( $sub, 'cat.dir', $row['dir'] ); + if ( $row['visible'] == 'false' or !$uppercat_visible ) + { + $subcat_visible = false; + $vtp->setVar( $sub, 'cat.invisible', $lang['cat_invisible'] ); + } + if ( $row['status'] == 'private' ) + { + $vtp->setVar( $sub, 'cat.private', $lang['private'] ); + } + $vtp->setVar( $sub, 'cat.nb_picture', $row['nb_images'] ); + $url = add_session_id( './admin.php?page=cat_modify&cat='.$row['id'] ); + $vtp->setVar( $sub, 'cat.edit_url', $url ); + if ( $row['rank'] != $min_rank ) + { + $vtp->addSession( $sub, 'up' ); + $url = add_session_id( './admin.php?page=cat&up='.$row['id'] ); + $vtp->setVar( $sub, 'up.up_url', $url ); + $vtp->closeSession( $sub, 'up' ); + } + else + { + $vtp->addSession( $sub, 'no_up' ); + $vtp->closeSession( $sub, 'no_up' ); + } + if ( $row['rank'] != $max_rank ) + { + $vtp->addSession( $sub, 'down' ); + $url = add_session_id( './admin.php?page=cat&down='.$row['id'] ); + $vtp->setVar( $sub, 'down.down_url', $url ); + $vtp->closeSession( $sub, 'down' ); + } + else + { + $vtp->addSession( $sub, 'no_down' ); + $vtp->closeSession( $sub, 'no_down' ); + } + if ( $row['nb_images'] > 0 ) + { + $vtp->addSession( $sub, 'image_info' ); + $url = add_session_id( './admin.php?page=infos_images&cat_id=' + .$row['id'] ); + $vtp->setVar( $sub, 'image_info.image_info_url', $url ); + $vtp->closeSession( $sub, 'image_info' ); + } + else + { + $vtp->addSession( $sub, 'no_image_info' ); + $vtp->closeSession( $sub, 'no_image_info' ); + } + if ( $row['status'] == 'private' ) + { + $vtp->addSession( $sub, 'permission' ); + $url=add_session_id('./admin.php?page=cat_perm&cat_id='.$row['id']); + $vtp->setVar( $sub, 'permission.url', $url ); + $vtp->closeSession( $sub, 'permission' ); + } + else + { + $vtp->addSession( $sub, 'no_permission' ); + $vtp->closeSession( $sub, 'no_permission' ); + } + if ( $row['site_id'] == 1 ) + { + $vtp->addSession( $sub, 'update' ); + $url = add_session_id('./admin.php?page=update&update='.$row['id']); + $vtp->setVar( $sub, 'update.update_url', $url ); + $vtp->closeSession( $sub, 'update' ); + } + else + { + $vtp->addSession( $sub, 'no_update' ); + $vtp->closeSession( $sub, 'no_update' ); + } + + $vtp->closeSession( $sub, 'cat' ); + + display_cat_manager( $row['id'], $indent.str_repeat( ' ', 4 ), + $subcat_visible, $level + 1 ); + } +} +display_cat_manager( 'NULL', str_repeat( ' ', 4 ), true, 0 ); +//----------------------------------------------------------- sending html code +$vtp->Parse( $handle , 'sub', $sub ); +?> \ No newline at end of file -- cgit v1.2.3