Changeset 2592 for trunk/include

Timestamp:

Sep 26, 2008, 1:01:35 AM (16 years ago)

Author:

plg

Message:

feature 868 added: pwg.images.add checks if the same file has not alread
been uploaded.

File:

• trunk/include/ws_functions.inc.php (modified) (2 diffs)

trunk/include/ws_functions.inc.php

@@ -903 +903 @@
   // fwrite($fh_log, 'input:  '.$params['thumbnail_sum']."\n");
 
+  // does the image already exists ?
+  $query = '
+SELECT
+    COUNT(*) AS counter
+  FROM '.IMAGES_TABLE.'
+  WHERE md5sum = \''.$params['file_sum'].'\'
+;';
+  list($counter) = mysql_fetch_row(pwg_query($query));
+  if ($counter != 0) {
+    return new PwgError(500, 'file already exists');
+  }
+
   // current date
   list($dbnow) = mysql_fetch_row(pwg_query('SELECT NOW();'));
@@ -987 +999 @@
     'width' => $width,
     'height' => $height,
+    'md5sum' => $params['file_sum'],
     );