Changeset 2683

Timestamp:

Oct 8, 2008, 12:01:14 AM (16 years ago)

Author:

plg

Message:

feature 889 added: pwg.images.exist check the existence of a photo in the
database based on its md5sum. (avoid failing on pwg.images.add).

Location:

trunk

Files:

• include/ws_functions.inc.php (modified) (1 diff)
• tools/piwigo_remote.pl (modified) (1 diff)
• ws.php (modified) (1 diff)

trunk/include/ws_functions.inc.php

@@ -1458 +1458 @@
   return $creation_output;
 }
+
+function ws_images_exist($params, &$service)
+{
+  if (!is_admin() or is_adviser())
+  {
+    return new PwgError(401, 'Access denied');
+  }
+
+  // search among photos the list of photos already added, based on md5sum
+  // list
+  $md5sums = preg_split(
+    '/[\s,;\|]/',
+    $params['md5sum_list'],
+    -1,
+    PREG_SPLIT_NO_EMPTY
+    );
+  
+  $query = '
+SELECT
+    id,
+    md5sum
+  FROM '.IMAGES_TABLE.'
+  WHERE md5sum IN (\''.implode("','", $md5sums).'\')  
+;';
+  $id_of_md5 = simple_hash_from_query($query, 'md5sum', 'id');
+
+  $result = array();
+  
+  foreach ($md5sums as $md5sum)
+  {
+    $result[$md5sum] = null;
+    if (isset($id_of_md5[$md5sum]))
+    {
+      $result[$md5sum] = $id_of_md5[$md5sum];
+    }
+  }
+
+  return $result;
+}
 ?>

trunk/tools/piwigo_remote.pl

@@ -174 +174 @@
 }
 
+if ($opt{action} eq 'pwg.images.exist') {
+    $form = {
+        method => $opt{action},
+    };
+
+    foreach my $key (keys %{ $opt{define} }) {
+        $form->{$key} = $opt{define}{$key};
+    }
+
+    my $response = $ua->post(
+        $conf{base_url}.'/ws.php?format=json',
+        $form
+    );
+
+    use Data::Dumper;
+    print Dumper(from_json($response->content)->{result});
+    # print Dumper($response);
+}
+
 $query = pwg_ws_get_query(
     method => 'pwg.session.logout'

trunk/ws.php

@@ -230 +230 @@
     'administration method only'
     );
+
+  $service->addMethod(
+    'pwg.images.exist',
+    'ws_images_exist',
+    array(
+      'md5sum_list'=> array(),
+      ),
+    'check existence of a photo list'
+    );
 }