Changeset 2099 for branches

Timestamp:

Sep 20, 2007, 3:00:16 AM (17 years ago)

Author:

rvelices

Message:

• fix very rare sql error (duplicate key) for rating

File:

• branches/branch-1_7/include/functions_rate.inc.php (modified) (4 diffs)

branches/branch-1_7/include/functions_rate.inc.php

@@ -51 +51 @@
   }
 
+  $ip_components = explode('.', $_SERVER["REMOTE_ADDR"]);
+  if (count($ip_components) > 3)
+  {
+    array_pop($ip_components);
+  }
+  $anonymous_id = implode ('.', $ip_components);
+
   if ($user_anonymous)
   {
-    $ip_components = explode('.', $_SERVER["REMOTE_ADDR"]);
-    if (count($ip_components) > 3)
-    {
-      array_pop($ip_components);
-    }
-    $anonymous_id = implode ('.', $ip_components);
-
     if (isset($_COOKIE['pwg_anonymous_rater']))
     {
@@ -79 +79 @@
   WHERE user_id = '.$user['id'].'
     AND anonymous_id = \''.$_COOKIE['pwg_anonymous_rater'].'\'
-    AND element_id NOT IN ('.implode(',', $already_there).')
+    AND element_id IN ('.implode(',', $already_there).')
 ;';
            pwg_query($query);
@@ -117 +117 @@
   AND user_id = '.$user['id'].'
 ';
-  if (isset($anonymous_id))
+  if (isset($user_anonymous))
   {
     $query.= ' AND anonymous_id = \''.$anonymous_id.'\'';
@@ -129 +129 @@
   ('
     .$user['id'].','
-    .(isset($anonymous_id) ? '\''.$anonymous_id.'\'' : "''").','
+    .'\''.$anonymous_id.'\','
     .$image_id.','
     .$rate