diff options
Diffstat (limited to 'BSF/admin/include/functions.php')
| -rw-r--r-- | BSF/admin/include/functions.php | 1872 |
1 files changed, 0 insertions, 1872 deletions
diff --git a/BSF/admin/include/functions.php b/BSF/admin/include/functions.php deleted file mode 100644 index 328a36ab7..000000000 --- a/BSF/admin/include/functions.php +++ /dev/null @@ -1,1872 +0,0 @@ -<?php -// +-----------------------------------------------------------------------+ -// | Piwigo - a PHP based picture gallery | -// +-----------------------------------------------------------------------+ -// | Copyright(C) 2008 Piwigo Team http://piwigo.org | -// | Copyright(C) 2003-2008 PhpWebGallery Team http://phpwebgallery.net | -// | Copyright(C) 2002-2003 Pierrick LE GALL http://le-gall.net/pierrick | -// +-----------------------------------------------------------------------+ -// | 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. | -// +-----------------------------------------------------------------------+ - -include(PHPWG_ROOT_PATH.'admin/include/functions_metadata.php'); - - -// The function delete_site deletes a site and call the function -// delete_categories for each primary category of the site -function delete_site( $id ) -{ - // destruction of the categories of the site - $query = ' -SELECT id - FROM '.CATEGORIES_TABLE.' - WHERE site_id = '.$id.' -;'; - $result = pwg_query($query); - $category_ids = array(); - while ($row = mysql_fetch_array($result)) - { - array_push($category_ids, $row['id']); - } - delete_categories($category_ids); - - // destruction of the site - $query = ' -DELETE FROM '.SITES_TABLE.' - WHERE id = '.$id.' -;'; - pwg_query($query); -} - - -// The function delete_categories deletes the categories identified by the -// (numeric) key of the array $ids. It also deletes (in the database) : -// - all the elements of the category (delete_elements, see further) -// - all the links between elements and this category -// - all the restrictions linked to the category -// The function works recursively. -function delete_categories($ids) -{ - if (count($ids) == 0) - { - return; - } - - // add sub-category ids to the given ids : if a category is deleted, all - // sub-categories must be so - $ids = get_subcat_ids($ids); - - // destruction of all the related elements - $query = ' -SELECT id - FROM '.IMAGES_TABLE.' - WHERE storage_category_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - $result = pwg_query($query); - $element_ids = array(); - while ($row = mysql_fetch_array($result)) - { - array_push($element_ids, $row['id']); - } - delete_elements($element_ids); - - // destruction of the links between images and this category - $query = ' -DELETE FROM '.IMAGE_CATEGORY_TABLE.' - WHERE category_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the access linked to the category - $query = ' -DELETE FROM '.USER_ACCESS_TABLE.' - WHERE cat_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - $query = ' -DELETE FROM '.GROUP_ACCESS_TABLE.' - WHERE cat_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the category - $query = ' -DELETE FROM '.CATEGORIES_TABLE.' - WHERE id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - $query=' -DELETE FROM '.OLD_PERMALINKS_TABLE.' - WHERE cat_id IN ('.implode(',',$ids).')'; - pwg_query($query); - - trigger_action('delete_categories', $ids); -} - -// The function delete_elements deletes the elements identified by the -// (numeric) values of the array $ids. It also deletes (in the database) : -// - all the comments related to elements -// - all the links between categories and elements -// - all the favorites associated to elements -function delete_elements($ids) -{ - if (count($ids) == 0) - { - return; - } - - // destruction of the comments on the image - $query = ' -DELETE FROM '.COMMENTS_TABLE.' - WHERE image_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the links between images and this category - $query = ' -DELETE FROM '.IMAGE_CATEGORY_TABLE.' - WHERE image_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the links between images and tags - $query = ' -DELETE FROM '.IMAGE_TAG_TABLE.' - WHERE image_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the favorites associated with the picture - $query = ' -DELETE FROM '.FAVORITES_TABLE.' - WHERE image_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the rates associated to this element - $query = ' -DELETE FROM '.RATE_TABLE.' - WHERE element_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the rates associated to this element - $query = ' -DELETE FROM '.CADDIE_TABLE.' - WHERE element_id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - // destruction of the image - $query = ' -DELETE FROM '.IMAGES_TABLE.' - WHERE id IN ( -'.wordwrap(implode(', ', $ids), 80, "\n").') -;'; - pwg_query($query); - - trigger_action('delete_elements', $ids); -} - -// The delete_user function delete a user identified by the $user_id -// It also deletes : -// - all the access linked to this user -// - all the links to any group -// - all the favorites linked to this user -// - calculated permissions linked to the user -// - all datas about notifications for the user -function delete_user($user_id) -{ - global $conf; - $tables = array( - // destruction of the access linked to the user - USER_ACCESS_TABLE, - // destruction of data notification by mail for this user - USER_MAIL_NOTIFICATION_TABLE, - // destruction of data RSS notification for this user - USER_FEED_TABLE, - // deletion of calculated permissions linked to the user - USER_CACHE_TABLE, - // deletion of computed cache data linked to the user - USER_CACHE_CATEGORIES_TABLE, - // destruction of the group links for this user - USER_GROUP_TABLE, - // destruction of the favorites associated with the user - FAVORITES_TABLE, - // destruction of the caddie associated with the user - CADDIE_TABLE, - // deletion of piwigo specific informations - USER_INFOS_TABLE, - ); - - foreach ($tables as $table) - { - $query = ' -DELETE FROM '.$table.' - WHERE user_id = '.$user_id.' -;'; - pwg_query($query); - } - - // destruction of the user - $query = ' -DELETE FROM '.SESSIONS_TABLE.' - WHERE data LIKE "pwg_uid|i:'.(int)$user_id.';%" -;'; - pwg_query($query); - - // destruction of the user - $query = ' -DELETE FROM '.USERS_TABLE.' - WHERE '.$conf['user_fields']['id'].' = '.$user_id.' -;'; - pwg_query($query); - - trigger_action('delete_user', $user_id); -} - -/** - * Verifies that the representative picture really exists in the db and - * picks up a random represantive if possible and based on config. - * - * @param mixed category id - * @returns void - */ -function update_category($ids = 'all') -{ - global $conf; - - if ($ids=='all') - { - $where_cats = '1=1'; - } - elseif ( !is_array($ids) ) - { - $where_cats = '%s='.$ids; - } - else - { - if (count($ids) == 0) - { - return false; - } - $where_cats = '%s IN('.wordwrap(implode(', ', $ids), 120, "\n").')'; - } - - // find all categories where the setted representative is not possible : - // the picture does not exist - $query = ' -SELECT DISTINCT c.id - FROM '.CATEGORIES_TABLE.' AS c LEFT JOIN '.IMAGES_TABLE.' AS i - ON c.representative_picture_id = i.id - WHERE representative_picture_id IS NOT NULL - AND '.sprintf($where_cats, 'c.id').' - AND i.id IS NULL -;'; - $wrong_representant = array_from_query($query, 'id'); - - if (count($wrong_representant) > 0) - { - $query = ' -UPDATE '.CATEGORIES_TABLE.' - SET representative_picture_id = NULL - WHERE id IN ('.wordwrap(implode(', ', $wrong_representant), 120, "\n").') -;'; - pwg_query($query); - } - - if (!$conf['allow_random_representative']) - { - // If the random representant is not allowed, we need to find - // categories with elements and with no representant. Those categories - // must be added to the list of categories to set to a random - // representant. - $query = ' -SELECT DISTINCT id - FROM '.CATEGORIES_TABLE.' INNER JOIN '.IMAGE_CATEGORY_TABLE.' - ON id = category_id - WHERE representative_picture_id IS NULL - AND '.sprintf($where_cats, 'category_id').' -;'; - $to_rand = array_from_query($query, 'id'); - if (count($to_rand) > 0) - { - set_random_representant($to_rand); - } - } -} - -/** - * returns an array containing sub-directories which can be a category, - * recursive by default - * - * directories nammed "thumbnail", "pwg_high" or "pwg_representative" are - * omitted - * - * @param string $basedir - * @return array - */ -function get_fs_directories($path, $recursive = true) -{ - $dirs = array(); - - if (is_dir($path)) - { - if ($contents = opendir($path)) - { - while (($node = readdir($contents)) !== false) - { - if (is_dir($path.'/'.$node) - and $node != '.' - and $node != '..' - and $node != '.svn' - and $node != 'thumbnail' - and $node != 'pwg_high' - and $node != 'pwg_representative') - { - array_push($dirs, $path.'/'.$node); - if ($recursive) - { - $dirs = array_merge($dirs, get_fs_directories($path.'/'.$node)); - } - } - } - } - } - - return $dirs; -} - -/** - * inserts multiple lines in a table - * - * @param string table_name - * @param array dbfields - * @param array inserts - * @return void - */ -function mass_inserts($table_name, $dbfields, $datas) -{ - if (count($datas) != 0) - { - $first = true; - - $query = 'SHOW VARIABLES LIKE \'max_allowed_packet\';'; - list(, $packet_size) = mysql_fetch_row(pwg_query($query)); - $packet_size = $packet_size - 2000; // The last list of values MUST not exceed 2000 character*/ - $query = ''; - - foreach ($datas as $insert) - { - if (strlen($query) >= $packet_size) - { - $query .= ' -;'; - pwg_query($query); - $first = true; - } - - if ($first) - { - $query = ' -INSERT INTO '.$table_name.' - ('.implode(',', $dbfields).') - VALUES'; - $first = false; - } - else - { - $query .= ' - , '; - } - - $query .= '('; - foreach ($dbfields as $field_id => $dbfield) - { - if ($field_id > 0) - { - $query .= ','; - } - - if (!isset($insert[$dbfield]) or $insert[$dbfield] === '') - { - $query .= 'NULL'; - } - else - { - $query .= "'".$insert[$dbfield]."'"; - } - } - $query .= ')'; - } - - $query .= ' -;'; - pwg_query($query); - } -} - -/** - * updates multiple lines in a table - * - * @param string table_name - * @param array dbfields - * @param array datas - * @return void - */ -function mass_updates($tablename, $dbfields, $datas) -{ - if (count($datas) != 0) - { - // depending on the MySQL version, we use the multi table update or N - // update queries - if (count($datas) < 10 or version_compare(mysql_get_server_info(), '4.0.4') < 0) - { - // MySQL is prior to version 4.0.4, multi table update feature is not - // available - foreach ($datas as $data) - { - $query = ' -UPDATE '.$tablename.' - SET '; - $is_first = true; - foreach ($dbfields['update'] as $key) - { - if (!$is_first) - { - $query.= ",\n "; - } - $query.= $key.' = '; - if (isset($data[$key]) and $data[$key] != '') - { - $query.= '\''.$data[$key].'\''; - } - else - { - $query.= 'NULL'; - } - $is_first = false; - } - $query.= ' - WHERE '; - - $is_first = true; - foreach ($dbfields['primary'] as $key) - { - if (!$is_first) - { - $query.= ' AND '; - } - if ( isset($data[$key]) ) - { - $query.= $key.' = \''.$data[$key].'\''; - } - else - { - $query.= $key.' IS NULL'; - } - $is_first = false; - } - $query.= ' -;'; - pwg_query($query); - } - } - else - { - // creation of the temporary table - $query = ' -SHOW FULL COLUMNS FROM '.$tablename.' -;'; - $result = pwg_query($query); - $columns = array(); - $all_fields = array_merge($dbfields['primary'], $dbfields['update']); - while ($row = mysql_fetch_array($result)) - { - if (in_array($row['Field'], $all_fields)) - { - $column = $row['Field']; - $column.= ' '.$row['Type']; - - $nullable = true; - if (!isset($row['Null']) or $row['Null'] == '' or $row['Null']=='NO') - { - $column.= ' NOT NULL'; - $nullable = false; - } - if (isset($row['Default'])) - { - $column.= " default '".$row['Default']."'"; - } - elseif ($nullable) - { - $column.= " default NULL"; - } - if (isset($row['Collation']) and $row['Collation'] != 'NULL') - { - $column.= " collate '".$row['Collation']."'"; - } - array_push($columns, $column); - } - } - - $temporary_tablename = $tablename.'_'.micro_seconds(); - - $query = ' - CREATE TABLE '.$temporary_tablename.' - ( - '.implode(",\n", $columns).', - UNIQUE KEY the_key ('.implode(',', $dbfields['primary']).') - ) -;'; - - pwg_query($query); - mass_inserts($temporary_tablename, $all_fields, $datas); - // update of images table by joining with temporary table - $query = ' -UPDATE '.$tablename.' AS t1, '.$temporary_tablename.' AS t2 - SET '. - implode( - "\n , ", - array_map( - create_function('$s', 'return "t1.$s = t2.$s";'), - $dbfields['update'] - ) - ).' - WHERE '. - implode( - "\n AND ", - array_map( - create_function('$s', 'return "t1.$s = t2.$s";'), - $dbfields['primary'] - ) - ).' - ;'; - pwg_query($query); - $query = ' -DROP TABLE '.$temporary_tablename.' -;'; - pwg_query($query); - } - } -} - -/** - * order categories (update categories.rank and global_rank database fields) - * so that rank field are consecutive integers starting at 1 for each child - * @return void - */ -function update_global_rank() -{ - $query = ' -SELECT id, if(id_uppercat is null,\'\',id_uppercat) AS id_uppercat, uppercats, rank, global_rank - FROM '.CATEGORIES_TABLE.' - ORDER BY id_uppercat,rank,name -;'; - - $cat_map = array(); - - $current_rank = 0; - $current_uppercat = ''; - - $result = pwg_query($query); - while ($row = mysql_fetch_array($result)) - { - if ($row['id_uppercat'] != $current_uppercat) - { - $current_rank = 0; - $current_uppercat = $row['id_uppercat']; - } - ++$current_rank; - $cat = - array( - 'rank' => $current_rank, - 'rank_changed' =>$current_rank!=$row['rank'], - 'global_rank' => $row['global_rank'], - 'uppercats' => $row['uppercats'], - ); - $cat_map[ $row['id'] ] = $cat; - } - - $datas = array(); - - foreach( $cat_map as $id=>$cat ) - { - $new_global_rank = preg_replace( - '/(\d+)/e', - "\$cat_map['$1']['rank']", - str_replace(',', '.', $cat['uppercats'] ) - ); - if ( $cat['rank_changed'] - or $new_global_rank!=$cat['global_rank'] - ) - { - $datas[] = array( - 'id' => $id, - 'rank' => $cat['rank'], - 'global_rank' => $new_global_rank, - ); - } - } - - mass_updates( - CATEGORIES_TABLE, - array( - 'primary' => array('id'), - 'update' => array('rank', 'global_rank') - ), - $datas - ); - return count($datas); -} - -/** - * change the visible property on a set of categories - * - * @param array categories - * @param string value - * @return void - */ -function set_cat_visible($categories, $value) -{ - if (!in_array($value, array('true', 'false'))) - { - return false; - } - - // unlocking a category => all its parent categories become unlocked - if ($value == 'true') - { - $uppercats = get_uppercat_ids($categories); - $query = ' -UPDATE '.CATEGORIES_TABLE.' - SET visible = \'true\' - WHERE id IN ('.implode(',', $uppercats).') -;'; - pwg_query($query); - } - // locking a category => all its child categories become locked - if ($value == 'false') - { - $subcats = get_subcat_ids($categories); - $query = ' -UPDATE '.CATEGORIES_TABLE.' - SET visible = \'false\' - WHERE id IN ('.implode(',', $subcats).') -;'; - pwg_query($query); - } -} - -/** - * change the status property on a set of categories : private or public - * - * @param array categories - * @param string value - * @return void - */ -function set_cat_status($categories, $value) -{ - if (!in_array($value, array('public', 'private'))) - { - return false; - } - - // make public a category => all its parent categories become public - if ($value == 'public') - { - $uppercats = get_uppercat_ids($categories); - $query = ' -UPDATE '.CATEGORIES_TABLE.' - SET status = \'public\' - WHERE id IN ('.implode(',', $uppercats).') -;'; - pwg_query($query); - } - // make a category private => all its child categories become private - if ($value == 'private') - { - $subcats = get_subcat_ids($categories); - $query = ' -UPDATE '.CATEGORIES_TABLE.' - SET status = \'private\' - WHERE id IN ('.implode(',', $subcats).') -;'; - pwg_query($query); - } -} - -/** - * returns all uppercats category ids of the given category ids - * - * @param array cat_ids - * @return array - */ -function get_uppercat_ids($cat_ids) -{ - if (!is_array($cat_ids) or count($cat_ids) < 1) - { - return array(); - } - - $uppercats = array(); - - $query = ' -SELECT uppercats - FROM '.CATEGORIES_TABLE.' - WHERE id IN ('.implode(',', $cat_ids).') -;'; - $result = pwg_query($query); - while ($row = mysql_fetch_array($result)) - { - $uppercats = array_merge($uppercats, - explode(',', $row['uppercats'])); - } - $uppercats = array_unique($uppercats); - - return $uppercats; -} - -/** - * set a new random representant to the categories - * - * @param array categories - */ -function set_random_representant($categories) -{ - $datas = array(); - foreach ($categories as $category_id) - { - $query = ' -SELECT image_id - FROM '.IMAGE_CATEGORY_TABLE.' - WHERE category_id = '.$category_id.' - ORDER BY RAND() - LIMIT 0,1 -;'; - list($representative) = mysql_fetch_array(pwg_query($query)); - - array_push( - $datas, - array( - 'id' => $category_id, - 'representative_picture_id' => $representative, - ) - ); - } - - mass_updates( - CATEGORIES_TABLE, - array( - 'primary' => array('id'), - 'update' => array('representative_picture_id') - ), - $datas - ); -} - -/** - * returns the fulldir for each given category id - * - * @param array cat_ids - * @return array - */ -function get_fulldirs($cat_ids) -{ - if (count($cat_ids) == 0) - { - return array(); - } - - // caching directories of existing categories - $query = ' -SELECT id, dir - FROM '.CATEGORIES_TABLE.' - WHERE dir IS NOT NULL -;'; - $result = pwg_query($query); - $cat_dirs = array(); - while ($row = mysql_fetch_array($result)) - { - $cat_dirs[$row['id']] = $row['dir']; - } - - // caching galleries_url - $query = ' -SELECT id, galleries_url - FROM '.SITES_TABLE.' -;'; - $result = pwg_query($query); - $galleries_url = array(); - while ($row = mysql_fetch_array($result)) - { - $galleries_url[$row['id']] = $row['galleries_url']; - } - - // categories : id, site_id, uppercats - $categories = array(); - - $query = ' -SELECT id, uppercats, site_id - FROM '.CATEGORIES_TABLE.' - WHERE id IN ( -'.wordwrap(implode(', ', $cat_ids), 80, "\n").') -;'; - $result = pwg_query($query); - while ($row = mysql_fetch_array($result)) - { - array_push($categories, $row); - } - - // filling $cat_fulldirs - $cat_fulldirs = array(); - foreach ($categories as $category) - { - $uppercats = str_replace(',', '/', $category['uppercats']); - $cat_fulldirs[$category['id']] = $galleries_url[$category['site_id']]; - $cat_fulldirs[$category['id']].= preg_replace('/(\d+)/e', - "\$cat_dirs['$1']", - $uppercats); - } - - return $cat_fulldirs; -} - -/** - * returns an array with all file system files according to - * $conf['file_ext'] - * - * @param string $path - * @param bool recursive - * @return array - */ -function get_fs($path, $recursive = true) -{ - global $conf; - - // because isset is faster than in_array... - if (!isset($conf['flip_picture_ext'])) - { - $conf['flip_picture_ext'] = array_flip($conf['picture_ext']); - } - if (!isset($conf['flip_file_ext'])) - { - $conf['flip_file_ext'] = array_flip($conf['file_ext']); - } - - $fs['elements'] = array(); - $fs['thumbnails'] = array(); - $fs['representatives'] = array(); - $subdirs = array(); - - if (is_dir($path)) - { - if ($contents = opendir($path)) - { - while (($node = readdir($contents)) !== false) - { - if (is_file($path.'/'.$node)) - { - $extension = get_extension($node); - -// if (in_array($extension, $conf['picture_ext'])) - if (isset($conf['flip_picture_ext'][$extension])) - { - if (basename($path) == 'thumbnail') - { - array_push($fs['thumbnails'], $path.'/'.$node); - } - else if (basename($path) == 'pwg_representative') - { - array_push($fs['representatives'], $path.'/'.$node); - } - else - { - array_push($fs['elements'], $path.'/'.$node); - } - } -// else if (in_array($extension, $conf['file_ext'])) - else if (isset($conf['flip_file_ext'][$extension])) - { - array_push($fs['elements'], $path.'/'.$node); - } - } - else if (is_dir($path.'/'.$node) - and $node != '.' - and $node != '..' - and $node != 'pwg_high' - and $recursive) - { - array_push($subdirs, $node); - } - } - } - closedir($contents); - - foreach ($subdirs as $subdir) - { - $tmp_fs = get_fs($path.'/'.$subdir); - - $fs['elements'] = array_merge($fs['elements'], - $tmp_fs['elements']); - - $fs['thumbnails'] = array_merge($fs['thumbnails'], - $tmp_fs['thumbnails']); - - $fs['representatives'] = array_merge($fs['representatives'], - $tmp_fs['representatives']); - } - } - return $fs; -} - -/** - * stupidly returns the current microsecond since Unix epoch - */ -function micro_seconds() -{ - $t1 = explode(' ', microtime()); - $t2 = explode('.', $t1[0]); - $t2 = $t1[1].substr($t2[1], 0, 6); - return $t2; -} - -/** - * synchronize base users list and related users list - * - * compares and synchronizes base users table (USERS_TABLE) with its child - * tables (USER_INFOS_TABLE, USER_ACCESS, USER_CACHE, USER_GROUP) : each - * base user must be present in child tables, users in child tables not - * present in base table must be deleted. - * - * @return void - */ -function sync_users() -{ - global $conf; - - $query = ' -SELECT '.$conf['user_fields']['id'].' AS id - FROM '.USERS_TABLE.' -;'; - $base_users = array_from_query($query, 'id'); - - $query = ' -SELECT user_id - FROM '.USER_INFOS_TABLE.' -;'; - $infos_users = array_from_query($query, 'user_id'); - - // users present in $base_users and not in $infos_users must be added - $to_create = array_diff($base_users, $infos_users); - - if (count($to_create) > 0) - { - create_user_infos($to_create); - } - - // users present in user related tables must be present in the base user - // table - $tables = array( - USER_MAIL_NOTIFICATION_TABLE, - USER_FEED_TABLE, - USER_INFOS_TABLE, - USER_ACCESS_TABLE, - USER_CACHE_TABLE, - USER_CACHE_CATEGORIES_TABLE, - USER_GROUP_TABLE - ); - - foreach ($tables as $table) - { - $query = ' -SELECT DISTINCT user_id - FROM '.$table.' -;'; - $to_delete = array_diff( - array_from_query($query, 'user_id'), - $base_users - ); - - if (count($to_delete) > 0) - { - $query = ' -DELETE - FROM '.$table.' - WHERE user_id in ('.implode(',', $to_delete).') -;'; - pwg_query($query); - } - } -} - -/** - * updates categories.uppercats field based on categories.id + - * categories.id_uppercat - * - * @return void - */ -function update_uppercats() -{ - $query = ' -SELECT id, id_uppercat, uppercats - FROM '.CATEGORIES_TABLE.' -;'; - $cat_map = hash_from_query($query, 'id'); - - $datas = array(); - foreach ($cat_map as $id => $cat) - { - $upper_list = array(); - - $uppercat = $id; - while ($uppercat) - { - array_push($upper_list, $uppercat); - $uppercat = $cat_map[$uppercat]['id_uppercat']; - } - - $new_uppercats = implode(',', array_reverse($upper_list)); - if ($new_uppercats != $cat['uppercats']) - { - array_push( - $datas, - array( - 'id' => $id, - 'uppercats' => $new_uppercats - ) - ); - } - } - $fields = array('primary' => array('id'), 'update' => array('uppercats')); - mass_updates(CATEGORIES_TABLE, $fields, $datas); -} - -/** - * update images.path field - * - * @return void - */ -function update_path() -{ - $query = ' -SELECT DISTINCT(storage_category_id) - FROM '.IMAGES_TABLE.' -;'; - $cat_ids = array_from_query($query, 'storage_category_id'); - $fulldirs = get_fulldirs($cat_ids); - - foreach ($cat_ids as $cat_id) - { - $query = ' -UPDATE '.IMAGES_TABLE.' - SET path = CONCAT(\''.$fulldirs[$cat_id].'\',\'/\',file) - WHERE storage_category_id = '.$cat_id.' -;'; - pwg_query($query); - } -} - -/** - * update images.average_rate field - * param int $element_id optional, otherwise applies to all - * @return void - */ -function update_average_rate( $element_id=-1 ) -{ - $query = ' -SELECT element_id, - ROUND(AVG(rate),2) AS average_rate - FROM '.RATE_TABLE; - if ( $element_id != -1 ) - { - $query .= ' WHERE element_id=' . $element_id; - } - $query .= ' GROUP BY element_id;'; - - $result = pwg_query($query); - - $datas = array(); - - while ($row = mysql_fetch_array($result)) - { - array_push( - $datas, - array( - 'id' => $row['element_id'], - 'average_rate' => $row['average_rate'] - ) - ); - } - - mass_updates( - IMAGES_TABLE, - array( - 'primary' => array('id'), - 'update' => array('average_rate') - ), - $datas - ); - - $query=' -SELECT id FROM '.IMAGES_TABLE .' - LEFT JOIN '.RATE_TABLE.' ON id=element_id - WHERE element_id IS NULL AND average_rate IS NOT NULL'; - if ( $element_id != -1 ) - { - $query .= ' AND id=' . $element_id; - } - $to_update = array_from_query( $query, 'id'); - - if ( !empty($to_update) ) - { - $query=' -UPDATE '.IMAGES_TABLE .' - SET average_rate=NULL - WHERE id IN (' . implode(',',$to_update) . ')'; - pwg_query($query); - } -} - -/** - * change the parent category of the given categories. The categories are - * supposed virtual. - * - * @param array category identifiers - * @param int parent category identifier - * @return void - */ -function move_categories($category_ids, $new_parent = -1) -{ - global $page; - - if (count($category_ids) == 0) - { - return; - } - - $new_parent = $new_parent < 1 ? 'NULL' : $new_parent; - - $categories = array(); - - $query = ' -SELECT id, id_uppercat, status, uppercats - FROM '.CATEGORIES_TABLE.' - WHERE id IN ('.implode(',', $category_ids).') -;'; - $result = pwg_query($query); - while ($row = mysql_fetch_array($result)) - { - $categories[$row['id']] = - array( - 'parent' => empty($row['id_uppercat']) ? 'NULL' : $row['id_uppercat'], - 'status' => $row['status'], - 'uppercats' => $row['uppercats'] - ); - } - - // is the movement possible? The movement is impossible if you try to move - // a category in a sub-category or itself - if ('NULL' != $new_parent) - { - $query = ' -SELECT uppercats - FROM '.CATEGORIES_TABLE.' - WHERE id = '.$new_parent.' -;'; - list($new_parent_uppercats) = mysql_fetch_row(pwg_query($query)); - - foreach ($categories as $category) - { - // technically, you can't move a category with uppercats 12,125,13,14 - // into a new parent category with uppercats 12,125,13,14,24 - if (preg_match('/^'.$category['uppercats'].'/', $new_parent_uppercats)) - { - array_push( - $page['errors'], - l10n('You cannot move a category in its own sub category') - ); - return; - } - } - } - - $tables = - array( - USER_ACCESS_TABLE => 'user_id', - GROUP_ACCESS_TABLE => 'group_id' - ); - - $query = ' -UPDATE '.CATEGORIES_TABLE.' - SET id_uppercat = '.$new_parent.' - WHERE id IN ('.implode(',', $category_ids).') -;'; - pwg_query($query); - - update_uppercats(); - update_global_rank(); - - // status and related permissions management - if ('NULL' == $new_parent) - { - $parent_status = 'public'; - } - else - { - $query = ' -SELECT status - FROM '.CATEGORIES_TABLE.' - WHERE id = '.$new_parent.' -;'; - list($parent_status) = mysql_fetch_row(pwg_query($query)); - } - - if ('private' == $parent_status) - { - foreach ($categories as $cat_id => $category) - { - switch ($category['status']) - { - case 'public' : - { - set_cat_status(array($cat_id), 'private'); - break; - } - case 'private' : - { - $subcats = get_subcat_ids(array($cat_id)); - - foreach ($tables as $table => $field) - { - $query = ' -SELECT '.$field.' - FROM '.$table.' - WHERE cat_id = '.$cat_id.' -;'; - $category_access = array_from_query($query, $field); - - $query = ' -SELECT '.$field.' - FROM '.$table.' - WHERE cat_id = '.$new_parent.' -;'; - $parent_access = array_from_query($query, $field); - - $to_delete = array_diff($parent_access, $category_access); - - if (count($to_delete) > 0) - { - $query = ' -DELETE FROM '.$table.' - WHERE '.$field.' IN ('.implode(',', $to_delete).') - AND cat_id IN ('.implode(',', $subcats).') -;'; - pwg_query($query); - } - } - break; - } - } - } - } - - array_push( - $page['infos'], - l10n_dec( - '%d category moved', '%d categories moved', - count($categories) - ) - ); -} - -/** - * create a virtual category - * - * @param string category name - * @param int parent category id - * @return array with ('info' and 'id') or ('error') key - */ -function create_virtual_category($category_name, $parent_id=null) -{ - global $conf; - - // is the given category name only containing blank spaces ? - if (preg_match('/^\s*$/', $category_name)) - { - return array('error' => l10n('cat_error_name')); - } - - $parent_id = !empty($parent_id) ? $parent_id : 'NULL'; - - $query = ' -SELECT MAX(rank) - FROM '.CATEGORIES_TABLE.' - WHERE id_uppercat '.(is_numeric($parent_id) ? '= '.$parent_id : 'IS NULL').' -;'; - list($current_rank) = mysql_fetch_array(pwg_query($query)); - - $insert = array( - 'name' => $category_name, - 'rank' => ++$current_rank, - 'commentable' => boolean_to_string($conf['newcat_default_commentable']), - 'uploadable' => 'false', - ); - - if ($parent_id != 'NULL') - { - $query = ' -SELECT id, uppercats, global_rank, visible, status - FROM '.CATEGORIES_TABLE.' - WHERE id = '.$parent_id.' -;'; - $parent = mysql_fetch_array(pwg_query($query)); - - $insert{'id_uppercat'} = $parent{'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'} = boolean_to_string($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'} = boolean_to_string($conf['newcat_default_visible']); - $insert{'status'} = $conf['newcat_default_status']; - $insert{'global_rank'} = $insert{'rank'}; - } - - // we have then to add the virtual category - mass_inserts( - CATEGORIES_TABLE, - array( - 'site_id', 'name', 'id_uppercat', 'rank', 'commentable', - 'uploadable', 'visible', 'status', 'global_rank', - ), - array($insert) - ); - - $inserted_id = mysql_insert_id(); - - $query = ' -UPDATE - '.CATEGORIES_TABLE.' - SET uppercats = \''. - (isset($parent) ? $parent{'uppercats'}.',' : ''). - $inserted_id. - '\' - WHERE id = '.$inserted_id.' -;'; - pwg_query($query); - - return array( - 'info' => l10n('cat_virtual_added'), - 'id' => $inserted_id, - ); -} - -/** - * Set tags to an image. Warning: given tags are all tags associated to the - * image, not additionnal tags. - * - * @param array tag ids - * @param int image id - * @return void - */ -function set_tags($tags, $image_id) -{ - $query = ' -DELETE - FROM '.IMAGE_TAG_TABLE.' - WHERE image_id = '.$image_id.' -;'; - pwg_query($query); - - if (count($tags) > 0) - { - $inserts = array(); - foreach ($tags as $tag_id) - { - array_push( - $inserts, - array( - 'tag_id' => $tag_id, - 'image_id' => $image_id - ) - ); - } - mass_inserts( - IMAGE_TAG_TABLE, - array_keys($inserts[0]), - $inserts - ); - } -} - -/** - * Add new tags to a set of images. - * - * @param array tag ids - * @param array image ids - * @return void - */ -function add_tags($tags, $images) -{ - if (count($tags) == 0 or count($tags) == 0) - { - return; - } - - // we can't insert twice the same {image_id,tag_id} so we must first - // delete lines we'll insert later - $query = ' -DELETE - FROM '.IMAGE_TAG_TABLE.' - WHERE image_id IN ('.implode(',', $images).') - AND tag_id IN ('.implode(',', $tags).') -;'; - pwg_query($query); - - $inserts = array(); - foreach ($images as $image_id) - { - foreach ($tags as $tag_id) - { - array_push( - $inserts, - array( - 'image_id' => $image_id, - 'tag_id' => $tag_id, - ) - ); - } - } - mass_inserts( - IMAGE_TAG_TABLE, - array_keys($inserts[0]), - $inserts - ); -} - -function tag_id_from_tag_name($tag_name) -{ - global $page; - - $tag_name = trim($tag_name); - if (isset($page['tag_id_from_tag_name_cache'][$tag_name])) - { - return $page['tag_id_from_tag_name_cache'][$tag_name]; - } - - // does the tag already exists? - $query = ' -SELECT id - FROM '.TAGS_TABLE.' - WHERE name = \''.$tag_name.'\' -;'; - $existing_tags = array_from_query($query, 'id'); - - if (count($existing_tags) == 0) - { - mass_inserts( - TAGS_TABLE, - array('name', 'url_name'), - array( - array( - 'name' => $tag_name, - 'url_name' => str2url($tag_name), - ) - ) - ); - - $page['tag_id_from_tag_name_cache'][$tag_name] = mysql_insert_id(); - } - else - { - $page['tag_id_from_tag_name_cache'][$tag_name] = $existing_tags[0]; - } - - return $page['tag_id_from_tag_name_cache'][$tag_name]; -} - -function set_tags_of($tags_of) -{ - if (count($tags_of) > 0) - { - $query = ' -DELETE - FROM '.IMAGE_TAG_TABLE.' - WHERE image_id IN ('.implode(',', array_keys($tags_of)).') -;'; - pwg_query($query); - - $inserts = array(); - - foreach ($tags_of as $image_id => $tag_ids) - { - foreach ($tag_ids as $tag_id) - { - array_push( - $inserts, - array( - 'image_id' => $image_id, - 'tag_id' => $tag_id, - ) - ); - } - } - - mass_inserts( - IMAGE_TAG_TABLE, - array_keys($inserts[0]), - $inserts - ); - } -} - -/** - * Do maintenance on all PWG tables - * - * @return nono - */ -function do_maintenance_all_tables() -{ - global $prefixeTable; - - $all_tables = array(); - - // List all tables - $query = 'SHOW TABLES LIKE \''.$prefixeTable.'%\';'; - $result = pwg_query($query); - while ($row = mysql_fetch_array($result)) - { - array_push($all_tables, $row[0]); - } - - // Repair all tables - $query = 'REPAIR TABLE '.implode(', ', $all_tables).';'; - pwg_query($query); - - // Re-Order all tables - foreach ($all_tables as $table_name) - { - $all_primary_key = array(); - - $query = 'DESC '.$table_name.';'; - $result = pwg_query($query); - while ($row = mysql_fetch_array($result)) - { - if ($row['Key'] == 'PRI') - { - array_push($all_primary_key, $row['Field']); - } - } - - if (count($all_primary_key) != 0) - { - $query = 'ALTER TABLE '.$table_name.' ORDER BY '.implode(', ', $all_primary_key).';'; - pwg_query($query); - } - } - - // Optimize all tables - $query = 'OPTIMIZE TABLE '.implode(', ', $all_tables).';'; - pwg_query($query); - -} - -/** - * Associate a list of images to a list of categories. - * - * The function will not duplicate links - * - * @param array images - * @param array categories - * @return void - */ -function associate_images_to_categories($images, $categories) -{ - if (count($images) == 0 - or count($categories) == 0) - { - return false; - } - - $query = ' -DELETE - FROM '.IMAGE_CATEGORY_TABLE.' - WHERE image_id IN ('.implode(',', $images).') - AND category_id IN ('.implode(',', $categories).') -;'; - pwg_query($query); - - $inserts = array(); - foreach ($categories as $category_id) - { - foreach ($images as $image_id) - { - array_push( - $inserts, - array( - 'image_id' => $image_id, - 'category_id' => $category_id, - ) - ); - } - } - - mass_inserts( - IMAGE_CATEGORY_TABLE, - array_keys($inserts[0]), - $inserts - ); - - update_category($categories); -} - -/** - * Associate images associated to a list of source categories to a list of - * destination categories. - * - * @param array sources - * @param array destinations - * @return void - */ -function associate_categories_to_categories($sources, $destinations) -{ - if (count($sources) == 0) - { - return false; - } - - $query = ' -SELECT image_id - FROM '.IMAGE_CATEGORY_TABLE.' - WHERE category_id IN ('.implode(',', $sources).') -;'; - $images = array_from_query($query, 'image_id'); - - associate_images_to_categories($images, $destinations); -} - -/** - * Create an XML file with Piwigo informations about a list of - * pictures. - * - * The goal of the export feature is to make easier the reading of - * informations related to pictures outside of Piwigo. - * - * @param array image_ids - */ -function export_pwg_data($image_ids) -{ - global $conf; - - if (count($image_ids) == 0) - { - return; - } - - $fp = fopen($conf['export_file'], 'w'); - $xml_string = '<export>'."\n"; - - $query = ' -SELECT tag_id, - image_id - FROM '.IMAGE_TAG_TABLE.' - WHERE image_id IN ('.implode(',', $image_ids).') -;'; - $result = pwg_query($query); - $tags_of = array(); - $all_tag_ids = array(); - $tag_name_of = array(); - - if (mysql_num_rows($result)) - { - while ($row = mysql_fetch_array($result)) - { - array_push($all_tag_ids, $row['tag_id']); - - if (!isset($tags_of[ $row['image_id'] ])) { - $tags_of[ $row['image_id'] ] = array(); - } - - array_push( - $tags_of[ $row['image_id'] ], - $row['tag_id'] - ); - } - - $all_tag_ids = array_unique($all_tag_ids); - - $query = ' -SELECT id, - name - FROM '.TAGS_TABLE.' - WHERE id IN ('.implode(',', $all_tag_ids).') -;'; - $result = pwg_query($query); - - while ($row = mysql_fetch_array($result)) - { - $tag_name_of[ $row['id'] ] = $row['name']; - } - } - - $query = ' -SELECT id, - path - FROM '.IMAGES_TABLE.' - WHERE id IN ('.implode(',', $image_ids).') -;'; - $result = pwg_query($query); - - while ($row = mysql_fetch_array($result)) - { - $xml_string.= " <photo>\n"; - $xml_string.= " <id>".$row['id']."</id>\n"; - $xml_string.= " <path>".$row['path']."</path>\n"; - - foreach ($tags_of[ $row['id'] ] as $tag_id) - { - $xml_string.= " <tag>".$tag_name_of[$tag_id]."</tag>\n"; - } - - $xml_string.= " </photo>\n"; - } - - $xml_string.= '</export>'; - fwrite($fp, $xml_string); - fclose($fp); -} - -/** - * Refer main Piwigo URLs (currently PHPWG_DOMAIN domain) - * - * @param void - * @return array like $conf['links'] - */ -function pwg_URL() -{ - global $lang_info; - $urls = array( - 'WIKI' => 'http://'.PHPWG_DOMAIN.'/doc/', - 'HOME' => 'http://'.PHPWG_DOMAIN.'/', - 'DEMO' => 'http://demo.'.PHPWG_DOMAIN.'/', - 'FORUM' => 'http://forum.'.PHPWG_DOMAIN.'/', - 'BUGS' => 'http://bugs.'.PHPWG_DOMAIN.'/', - 'EXTENSIONS' => 'http://'.PHPWG_DOMAIN.'/ext', - ); - if ( isset($lang_info['code']) and - in_array($lang_info['code'], array('fr','en')) ) - { /* current wiki languages are French or English */ - $urls['WIKI'] .= 'doku.php?id='.$lang_info['code'].':start'; - $urls['HOME'] .= '?lang='.$lang_info['code']; - } - return $urls; -} - -/** - * Invalidates cahed data (permissions and category counts) for all users. - */ -function invalidate_user_cache() -{ - $query = ' -UPDATE '.USER_CACHE_TABLE.' - SET need_update = \'true\' -;'; - pwg_query($query); - trigger_action('invalidate_user_cache'); -} - -/** - * adds the caracter set to a create table sql query. - * all CREATE TABLE queries must call this function - * @param string query - the sql query - */ -function create_table_add_character_set($query) -{ - defined('DB_CHARSET') or die('create_table_add_character_set DB_CHARSET undefined'); - if ('DB_CHARSET'!='') - { - if ( version_compare(mysql_get_server_info(), '4.1.0', '<') ) - { - return $query; - } - $charset_collate = " DEFAULT CHARACTER SET ".DB_CHARSET; - if ('DB_COLLATE'!='') - { - $charset_collate .= " COLLATE ".DB_COLLATE; - } - $query=trim($query); - $query=trim($query, ';'); - if (preg_match('/^CREATE\s+TABLE/i',$query)) - { - $query.=$charset_collate; - } - $query .= ';'; - } - return $query; -} - -/** - * Returns array use on template with html_options method - * @param Min and Max access to use - * @return array of user access level - */ -function get_user_access_level_html_options($MinLevelAccess = ACCESS_FREE, $MaxLevelAccess = ACCESS_CLOSED) -{ - $tpl_options = array(); - for ($level = $MinLevelAccess; $level <= $MaxLevelAccess; $level++) - { - $tpl_options[$level] = l10n(sprintf('ACCESS_%d', $level)); - } - return $tpl_options; -} - -?>
\ No newline at end of file |