aboutsummaryrefslogtreecommitdiffstats
path: root/include/ws_functions.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'include/ws_functions.inc.php')
-rw-r--r--include/ws_functions.inc.php148
1 files changed, 117 insertions, 31 deletions
diff --git a/include/ws_functions.inc.php b/include/ws_functions.inc.php
index b0ac24362..068cf84b3 100644
--- a/include/ws_functions.inc.php
+++ b/include/ws_functions.inc.php
@@ -92,9 +92,9 @@ function ws_std_image_sql_filter( $params, $tbl_name='' )
{
$clauses[] = $tbl_name.'width/'.$tbl_name.'height<='.$params['f_max_ratio'];
}
- if ( $params['f_with_thumbnail'] )
+ if (is_numeric($params['f_max_level']) )
{
- $clauses[] = $tbl_name.'tn_ext IS NOT NULL';
+ $clauses[] = $tbl_name.'level <= '.$params['f_max_level'];
}
return $clauses;
}
@@ -147,7 +147,7 @@ function ws_std_image_sql_order( $params, $tbl_name='' )
function ws_std_get_urls($image_row)
{
$ret = array();
-
+
$src_image = new SrcImage($image_row);
global $user;
@@ -155,7 +155,7 @@ function ws_std_get_urls($image_row)
{
$ret['element_url'] = get_element_url($image_row);
}
-
+
$derivatives = DerivativeImage::get_all($src_image);
$derivatives_arr = array();
foreach($derivatives as $type=>$derivative)
@@ -179,6 +179,92 @@ function ws_std_get_image_xml_attributes()
);
}
+function ws_getMissingDerivatives($params, &$service)
+{
+ if (!is_admin())
+ {
+ return new PwgError(403, 'Forbidden');
+ }
+
+ if ( empty($params['types']) )
+ {
+ $types = array_keys(ImageStdParams::get_defined_type_map());
+ }
+ else
+ {
+ $types = array_intersect(array_keys(ImageStdParams::get_defined_type_map()), $params['types']);
+ if (count($types)==0)
+ {
+ return new PwgError(WS_ERR_INVALID_PARAM, "Invalid types");
+ }
+ }
+
+ if ( ($max_urls = intval($params['max_urls'])) <= 0)
+ {
+ return new PwgError(WS_ERR_INVALID_PARAM, "Invalid max_urls");
+ }
+
+ list($max_id, $image_count) = pwg_db_fetch_row( pwg_query('SELECT MAX(id)+1, COUNT(*) FROM '.IMAGES_TABLE) );
+ $start_id = intval($params['prev_page']);
+ if ($start_id<=0)
+ {
+ $start_id = $max_id;
+ }
+
+ $uid = '&b='.time();
+ global $conf;
+ $conf['question_mark_in_urls'] = $conf['php_extension_in_urls'] = true;
+ $conf['derivative_url_style']=2; //script
+
+ $qlimit = min(5000, ceil(max($image_count/500, $max_urls/count($types))));
+ $where_clauses = ws_std_image_sql_filter( $params, '' );
+ $where_clauses[] = 'id<start_id';
+
+ $query_model = 'SELECT id, path, representative_ext, width, height
+ FROM '.IMAGES_TABLE.'
+ WHERE '.implode(' AND ', $where_clauses).'
+ ORDER BY id DESC
+ LIMIT '.$qlimit;
+
+ $urls=array();
+ do
+ {
+ $result = pwg_query( str_replace('start_id', $start_id, $query_model));
+ $is_last = pwg_db_num_rows($result) < $qlimit;
+ while ($row=pwg_db_fetch_assoc($result))
+ {
+ $start_id = $row['id'];
+ $src_image = new SrcImage($row);
+ if ($src_image->is_mimetype())
+ continue;
+ foreach($types as $type)
+ {
+ $derivative = new DerivativeImage($type, $src_image);
+ if ($type != $derivative->get_type())
+ continue;
+ if (@filemtime($derivative->get_path())===false)
+ {
+ $urls[] = $derivative->get_url().$uid;
+ }
+ }
+ if (count($urls)>=$max_urls && !$is_last)
+ break;
+ }
+ if ($is_last)
+ {
+ $start_id = 0;
+ }
+ }while (count($urls)<$max_urls && $start_id);
+
+ $ret = array();
+ if ($start_id)
+ {
+ $ret['next_page']=$start_id;
+ }
+ $ret['urls']=$urls;
+ return $ret;
+}
+
/**
* returns PWG version (web service method)
*/
@@ -514,7 +600,7 @@ SELECT id, name, permalink, uppercats, global_rank, id_uppercat,
$categories = array();
$user_representative_updates_for = array();
// management of the album thumbnail -- stops here
-
+
$cats = array();
while ($row = pwg_db_fetch_assoc($result))
{
@@ -552,7 +638,7 @@ SELECT id, name, permalink, uppercats, global_rank, id_uppercat,
);
// management of the album thumbnail -- starts here
- //
+ //
// on branch 2.3, the algorithm is duplicated from
// include/category_cats, but we should use a common code for Piwigo 2.4
//
@@ -603,14 +689,14 @@ SELECT id, name, permalink, uppercats, global_rank, id_uppercat,
}
}
}
-
+
if (isset($image_id))
{
if ($conf['representative_cache_on_subcats'] and $row['user_representative_picture_id'] != $image_id)
{
$user_representative_updates_for[ $user['id'].'#'.$row['id'] ] = $image_id;
}
-
+
$row['representative_picture_id'] = $image_id;
array_push($image_ids, $image_id);
array_push($categories, $row);
@@ -650,31 +736,31 @@ SELECT id, path, representative_ext, level
// * find a random photo matching user permissions
// * register it at user_representative_picture_id
// * set it as the representative_picture_id for the category
-
+
foreach ($categories as &$category)
{
if ($row['id'] == $category['representative_picture_id'])
{
// searching a random representant among elements in sub-categories
$image_id = get_random_image_in_category($category);
-
+
if (isset($image_id) and !in_array($image_id, $image_ids))
{
array_push($new_image_ids, $image_id);
}
-
+
if ($conf['representative_cache_on_level'])
{
$user_representative_updates_for[ $user['id'].'#'.$category['id'] ] = $image_id;
}
-
+
$category['representative_picture_id'] = $image_id;
}
}
unset($category);
}
}
-
+
if (count($new_image_ids) > 0)
{
$query = '
@@ -696,11 +782,11 @@ SELECT id, path, representative_ext
if (!$params['public'] and count($user_representative_updates_for))
{
$updates = array();
-
+
foreach ($user_representative_updates_for as $user_cat => $image_id)
{
list($user_id, $cat_id) = explode('#', $user_cat);
-
+
array_push(
$updates,
array(
@@ -735,7 +821,7 @@ SELECT id, path, representative_ext
unset($cat['count_images']);
unset($cat['count_categories']);
}
- unset($cat);
+ unset($cat);
// management of the album thumbnail -- stops here
if ($params['tree_output'])
@@ -1530,7 +1616,7 @@ function add_file($file_path, $type, $original_sum, $file_sum)
// check dumped thumbnail md5
$dumped_md5 = md5_file($file_path);
- if ($dumped_md5 != $file_sum)
+ if ($dumped_md5 != $file_sum)
{
return new PwgError(500, '[add_file] '.$type.' transfer failed');
}
@@ -1665,16 +1751,16 @@ SELECT
if ($params['resize'])
{
ws_logfile('[pwg.images.add] resize activated');
-
+
// temporary file path
$type = 'file';
$file_path = $conf['upload_dir'].'/buffer/'.$params['original_sum'].'-'.$type;
-
+
merge_chunks($file_path, $params['original_sum'], $type);
chmod($file_path, 0644);
include_once(PHPWG_ROOT_PATH.'admin/include/functions_upload.inc.php');
-
+
$image_id = add_uploaded_file(
$file_path,
$params['original_filename']
@@ -1703,11 +1789,11 @@ SELECT
$random_string = substr($params['file_sum'], 0, 8);
$filename_wo_ext = $date_string.'-'.$random_string;
$file_path = $upload_dir.'/'.$filename_wo_ext.'.jpg';
-
+
// add files
$file_infos = add_file($file_path, 'file', $params['original_sum'], $params['file_sum']);
$thumb_infos = add_file($file_path, 'thumb', $params['original_sum'], $params['thumbnail_sum']);
-
+
if (isset($params['high_sum']))
{
$high_infos = add_file($file_path, 'high', $params['original_sum'], $params['high_sum']);
@@ -1762,7 +1848,7 @@ SELECT
$update[$key] = $params[$key];
}
}
-
+
if (count(array_keys($update)) > 0)
{
single_update(
@@ -1773,7 +1859,7 @@ SELECT
}
$url_params = array('image_id' => $image_id);
-
+
// let's add links between the image and the categories
if (isset($params['categories']))
{
@@ -1781,7 +1867,7 @@ SELECT
if (preg_match('/^\d+/', $params['categories'], $matches)) {
$category_id = $matches[0];
-
+
$query = '
SELECT id, name, permalink
FROM '.CATEGORIES_TABLE.'
@@ -1789,7 +1875,7 @@ SELECT id, name, permalink
;';
$result = pwg_query($query);
$category = pwg_db_fetch_assoc($result);
-
+
$url_params['section'] = 'categories';
$url_params['category'] = $category;
}
@@ -1957,16 +2043,16 @@ function ws_rates_delete($params, &$service)
{
return new PwgError(WS_ERR_INVALID_PARAM, 'Invalid user_id');
}
-
+
$query = '
DELETE FROM '.RATE_TABLE.'
WHERE user_id='.$user_id;
-
+
if (!empty($params['anonymous_id']))
{
$query .= ' AND anonymous_id=\''.$params['anonymous_id'].'\'';
}
-
+
$changes = pwg_db_changes(pwg_query($query));
if ($changes)
{
@@ -3274,7 +3360,7 @@ SELECT id, path, tn_ext, has_high, width, height
{
return new PwgError(403, "image can't be resized");
}
-
+
$hd_path = get_high_path($image);
if (empty($image['has_high']) or !file_exists($hd_path))
@@ -3284,7 +3370,7 @@ SELECT id, path, tn_ext, has_high, width, height
$hd_path = file_path_for_type($image_path, 'high');
$hd_dir = dirname($hd_path);
prepare_directory($hd_dir);
-
+
rename($image_path, $hd_path);
$hd_infos = pwg_image_infos($hd_path);