/** * Summary of preItemUpdate * will add or update record in DB * @param CommonDBTM $parm */ static function preItemUpdate(CommonDBTM $parm) { global $DB; if ($parm->getType() == 'User' && isset($parm->input['plugin_timezones_users_timezone'])) { //$query = "REPLACE INTO `glpi_plugin_timezones_users` (`users_id`, `timezone`) VALUES (".$parm->getID().", '".$parm->input['plugin_timezones_users_timezone']."');"; //$DB->query( $query ) ; $tzUser = new self(); $data = array('users_id' => $parm->getID(), 'timezone' => $parm->input['plugin_timezones_users_timezone']); //check if datas already inserted $found = $tzUser->getIDFromUserID($parm->getID()); if (!$found) { $tzUser->add($data); } else { $data['id'] = $found; $tzUser->update($data); } } }