From 0245e00a7670a0c76962a95d2152c0962634bef1 Mon Sep 17 00:00:00 2001 From: z0rglub Date: Tue, 16 Sep 2003 21:32:30 +0000 Subject: Adding the name when inserting a remote category in the database. $name becomes $dir (even if named "name" in the XML file) git-svn-id: http://piwigo.org/svn/trunk@126 68402e56-0260-453c-a942-63ccdbb3a9ee --- admin/update.php | 12 +++++++----- 1 file changed, 7 insertions(+), 5 deletions(-) (limited to 'admin/update.php') diff --git a/admin/update.php b/admin/update.php index 493b9d563..a808af9a2 100644 --- a/admin/update.php +++ b/admin/update.php @@ -355,18 +355,18 @@ function insert_remote_category( $xml_dir, $site_id, $id_uppercat, $level ) { // is the category already existing ? $category_id = ''; - $name = getAttribute( $list_dirs[$i], 'name' ); - $categories[$i] = $name; + $dir = getAttribute( $list_dirs[$i], 'name' ); + $categories[$i] = $dir; $src = '../template/'.$user['template'].'/admin/images/puce.gif'; $output.= '>'; - $output.= ''.$name.''; + $output.= ''.$dir.''; $output.= '
'; $query = 'SELECT id'; $query.= ' FROM '.PREFIX_TABLE.'categories'; $query.= ' WHERE site_id = '.$site_id; - $query.= " AND dir = '".$name."'"; + $query.= " AND dir = '".$dir."'"; if ( $id_uppercat == 'NULL' ) { $query.= ' AND id_uppercat IS NULL'; @@ -379,9 +379,11 @@ function insert_remote_category( $xml_dir, $site_id, $id_uppercat, $level ) $result = mysql_query( $query ); if ( mysql_num_rows( $result ) == 0 ) { + $name = str_replace( '_', ' ', $dir ); // we have to create the category $query = 'INSERT INTO '.PREFIX_TABLE.'categories'; - $query.= " (dir,site_id,id_uppercat) VALUES ('".$name."',".$site_id; + $query.= ' (name,dir,site_id,id_uppercat) VALUES '; + $query.= "('".$name."','".$dir."',".$site_id; if ( !is_numeric( $id_uppercat ) ) { $query.= ',NULL'; -- cgit v1.2.3