Changeset 180 for mods

Timestamp:

01/17/07 09:02:44 (14 years ago)

Author:

exi

Message:

Copied potential fix for the sync error from devtree.

Location:

mods/Sync_Server

Files:

• globals.php (modified) (1 diff)
• sync_server.php (modified) (2 diffs)

mods/Sync_Server/globals.php

@@ -2 +2 @@
 // current version: major.minor.sub
 // unpair numbers for minor = development version
-define('KB_VERSION', '1.2.2');
+define('KB_VERSION', '1.4.1');
 
 // set the running-server for id-syncs here

mods/Sync_Server/sync_server.php

@@ -93 +93 @@
         $qry->execute("replace into kb3_item_stats (itm_name,kb_host,itm_externalid,itm_value) VALUES ('".addslashes($matches[1][$i])."','".$hostid."','".addslashes($matches[2][$i])."','".addslashes($matches[3][$i])."')");
     }
+    unset($matches);
 }
 unset($data);
@@ -129 +130 @@
 
 $data_array = $data_values = array();
+$lastname = '';
 $qry->execute('select itm_name, itm_externalid, itm_value from kb3_item_stats order by itm_name asc, itm_value asc');
 while ($data = $qry->getRow())
 {
+    // looks like we hit the memory limit so median extraction has to happen here
+    if ($lastname != $data['itm_name'])
+    {
+        // check for lastname due to initialisation
+        if ($lastname)
+        {
+            // get the median value for the item
+            $val_cnt = count($data_values[$lastname]);
+            $val_cnt = min(ceil($val_cnt/2), $val_cnt)-1;
+            $value = $data_values[$lastname][$val_cnt];
+
+            $data_array[$lastname]['itm_value'] = $data;
+            unset($data_values[$lastname]);
+        }
+        $lastname = $data['itm_name'];
+    }
     $data_array[$data['itm_name']] = $data;
     $data_values[$data['itm_name']][] = $data['itm_value'];
 }
+unset($data_values);
 
 $content_file .= 'ITEMS_START';
 foreach ($data_array as $data)
 {
-    // get the median value for every item
-    $val_cnt = count($data_values[$data['itm_name']]);
-    $val_cnt = min(ceil($val_cnt/2), $val_cnt)-1;
-    $value = $data_values[$data['itm_name']][$val_cnt];
-
-    $content_file .= '§'.$data['itm_name'].'|'.$data['itm_externalid'].'|'.$value.'-';
+    $content_file .= '§'.$data['itm_name'].'|'.$data['itm_externalid'].'|'.$data['itm_value'].'-';
 }
+unset($data_array);
 
 // return the compressed data back to the client