Changeset 15

Timestamp:

10/18/06 21:22:45 (14 years ago)

Author:

exi

Message:

fixed an sql error in the sync-function

Location:

dev/common

Files:

• admin_sync.php (modified) (1 diff)
• sync_server.php (modified) (1 diff)

dev/common/admin_sync.php

@@ -97 +97 @@
         for ($i = 0; $i<$results; $i++)
         {
-            $update->execute("update kb3_pilots set plt_externalid='".$matches[2][$i]."' where name='".$matches[1][$i]."'");
+            $update->execute("update kb3_pilots set plt_externalid='".$matches[2][$i]."' where plt_name='".$matches[1][$i]."'");
         }
         $html .= "Synchronization complete, got $results new ids from server running version ".$version[0].'.'.$version[1].'.'.$version[2].'.<br>';

dev/common/sync_server.php

@@ -65 +65 @@
         // we dont got that one in our database, update
         // TODO: we don't care about missing pilots yet
-        $update->execute("update kb3_pilots set plt_externalid='".$id."' where name='".$name."'");
+        $update->execute("update kb3_pilots set plt_externalid='".$id."' where plt_name='".$name."'");
     }
     else