- Timestamp:
- 01/17/07 09:02:44 (16 years ago)
- Location:
- mods/Sync_Server
- Files:
-
- 2 modified
Legend:
- Unmodified
- Added
- Removed
-
mods/Sync_Server/globals.php
r161 r180 2 2 // current version: major.minor.sub 3 3 // unpair numbers for minor = development version 4 define('KB_VERSION', '1. 2.2');4 define('KB_VERSION', '1.4.1'); 5 5 6 6 // set the running-server for id-syncs here -
mods/Sync_Server/sync_server.php
r161 r180 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])."')"); 94 94 } 95 unset($matches); 95 96 } 96 97 unset($data); … … 129 130 130 131 $data_array = $data_values = array(); 132 $lastname = ''; 131 133 $qry->execute('select itm_name, itm_externalid, itm_value from kb3_item_stats order by itm_name asc, itm_value asc'); 132 134 while ($data = $qry->getRow()) 133 135 { 136 // looks like we hit the memory limit so median extraction has to happen here 137 if ($lastname != $data['itm_name']) 138 { 139 // check for lastname due to initialisation 140 if ($lastname) 141 { 142 // get the median value for the item 143 $val_cnt = count($data_values[$lastname]); 144 $val_cnt = min(ceil($val_cnt/2), $val_cnt)-1; 145 $value = $data_values[$lastname][$val_cnt]; 146 147 $data_array[$lastname]['itm_value'] = $data; 148 unset($data_values[$lastname]); 149 } 150 $lastname = $data['itm_name']; 151 } 134 152 $data_array[$data['itm_name']] = $data; 135 153 $data_values[$data['itm_name']][] = $data['itm_value']; 136 154 } 155 unset($data_values); 137 156 138 157 $content_file .= 'ITEMS_START'; 139 158 foreach ($data_array as $data) 140 159 { 141 // get the median value for every item 142 $val_cnt = count($data_values[$data['itm_name']]); 143 $val_cnt = min(ceil($val_cnt/2), $val_cnt)-1; 144 $value = $data_values[$data['itm_name']][$val_cnt]; 145 146 $content_file .= '§'.$data['itm_name'].'|'.$data['itm_externalid'].'|'.$value.'-'; 160 $content_file .= '§'.$data['itm_name'].'|'.$data['itm_externalid'].'|'.$data['itm_value'].'-'; 147 161 } 162 unset($data_array); 148 163 149 164 // return the compressed data back to the client