Changeset 176 for dev/common/admin_sync.php

Timestamp:

01/12/07 17:06:34 (14 years ago)

Author:

exi

Message:

Changes to sync_server.php to reduce the memory load during script execution.

Files:

• dev/common/admin_sync.php (modified) (3 diffs)

dev/common/admin_sync.php

@@ -16 +16 @@
     {
         $html .= "Could not connect to Server:<br/>\n";
-        $html .= $http-getError();
+        $html .= $http->getError();
 
         $page->addContext($menubox->generate());
@@ -79 +79 @@
             unset($data);
             $results = count($matches[1]);
+            if (isset($_REQUEST['itm_overwrite']))
+            {
+                $add_qrystr = '';
+            }
+            else
+            {
+                $add_qrystr = ' AND itm_value=0';
+            }
+
             for ($i = 0; $i<$results; $i++)
             {
-                $update->execute("update kb3_items set itm_externalid='".addslashes($matches[2][$i])."', itm_value='".addslashes($matches[3][$i])."' where itm_name='".addslashes($matches[1][$i])."' limit 1");
+                $update->execute("update kb3_items set itm_externalid='".addslashes($matches[2][$i])."', itm_value='".addslashes($matches[3][$i])."' where itm_name='".addslashes($matches[1][$i])."'".$add_qrystr." limit 1");
             }
             if ($results == 0)
@@ -129 +138 @@
     $html .= "<tr><td width=120><b>Update item values</b></td><td><input type=checkbox name=itm_update id=itm_update";
     $html .= " checked=\"checked\"></td></tr>";
+    $html .= "<tr><td width=120><b>Overwrite local values</b></td><td><input type=checkbox name=itm_overwrite id=itm_overwrite";
+    $html .= " checked=\"checked\">(If disabled only values with 0 will be overwritten)</td></tr>";
     $html .= '<input type="hidden" name="do" value="sync">';
     $html .= '<tr><td width=120></td><td><input type=submit name=submit value="Synchronize now"></td></tr></table></form>';