$hrDevice['hrDeviceType'], 'hrDeviceDescr' => $hrDevice['hrDeviceDescr'], 'hrDeviceStatus' => $hrDevice['hrDeviceStatus'], 'hrDeviceErrors' => $hrDevice['hrDeviceErrors'] ]; if ($hrDevice['hrDeviceType'] === "hrDeviceProcessor") { $update_array['hrProcessorLoad'] = $hrDevice['hrProcessorLoad']; } else { $update_array['hrProcessorLoad'] = ['NULL']; } dbUpdate($update_array, 'hrDevice', 'device_id = ? AND hrDeviceIndex = ?', [$device['device_id'], $hrDevice['hrDeviceIndex']]); // FIXME -- check if it has updated, and print a U instead of a . echo("."); } else { $inserted = dbInsert(['hrDeviceIndex' => $hrDevice['hrDeviceIndex'], 'device_id' => $device['device_id'], 'hrDeviceType' => $hrDevice['hrDeviceType'], 'hrDeviceDescr' => $hrDevice['hrDeviceDescr'], 'hrDeviceStatus' => $hrDevice['hrDeviceStatus'], 'hrDeviceErrors' => $hrDevice['hrDeviceErrors']], 'hrDevice'); echo("+"); } $valid_hrDevice[$hrDevice['hrDeviceIndex']] = 1; } } foreach (dbFetchRows('SELECT * FROM `hrDevice` WHERE `device_id` = ?', [$device['device_id']]) as $test_hrDevice) { if (!$valid_hrDevice[$test_hrDevice['hrDeviceIndex']]) { $deleted = dbDelete('hrDevice', '`hrDevice_id` = ?', [$test_hrDevice['hrDevice_id']]); echo("-"); if (OBS_DEBUG > 1) { print_vars($test_hrDevice); echo($deleted . " deleted"); } } } unset($valid_hrDevice); // EOF