public static function modify($server_) { Logger::debug('main', 'Starting Abstract_Server::modify for \'' . $server_->fqdn . '\''); $SQL = SQL::getInstance(); $fqdn = $server_->fqdn; if (!Abstract_Server::load($fqdn)) { Logger::error('main', 'Abstract_Server::modify(' . $server_->fqdn . ') failed to load server'); return false; } $SQL->DoQuery('UPDATE @1 SET @2=%3,@4=%5,@6=%7,@8=%9,@10=%11,@12=%13,@14=%15,@16=%17,@18=%19,@20=%21,@22=%23 WHERE @24 = %25 LIMIT 1', $SQL->prefix . 'servers', 'status', $server_->status, 'registered', (int) $server_->registered, 'locked', (int) $server_->locked, 'type', $server_->type, 'version', $server_->version, 'cpu_model', $server_->cpu_model, 'cpu_nb_cores', $server_->cpu_nb_cores, 'cpu_load', (int) ($server_->cpu_load * 100), 'ram_total', $server_->ram_total, 'ram_used', $server_->ram_used, 'timestamp', time(), 'fqdn', $fqdn); $properties = Abstract_Server::loadProperties($server_); foreach (Abstract_Server::$server_properties as $object_property => $db_property) { Abstract_Server::saveProperty($server_, $object_property, $db_property, isset($properties[$object_property]) ? $properties[$object_property] : NULL); } return true; }