public static function replace_temp_uri($temp_uri, $class_uri, $uri_prefix = "") { global $dbh; if ($uri_prefix) { $class_uri = $uri_prefix; } $last_uri = ""; $max = 1; //On cherche le max des id + 1 $query = 'SELECT MAX(uri_id)+1 FROM onto_uri'; $result = pmb_mysql_query($query, $dbh); if (pmb_mysql_num_rows($result)) { $max = pmb_mysql_result($result, 0, 0); } $query = 'SELECT 1 FROM onto_uri WHERE uri="' . addslashes($class_uri . $max) . '"'; $result = pmb_mysql_query($query, $dbh); if (!pmb_mysql_error($dbh) && !pmb_mysql_num_rows($result)) { $last_uri = $class_uri . $max; } else { do { $max++; $query = 'SELECT 1 FROM onto_uri WHERE uri="' . addslashes($class_uri . $max) . '"'; $result = pmb_mysql_query($query, $dbh); } while (pmb_mysql_num_rows($result)); } $last_uri = $class_uri . $max; $query = 'update onto_uri SET uri="' . addslashes($last_uri) . '" where uri="' . $temp_uri . '"'; pmb_mysql_query($query, $dbh); //On initialise last_uri. self::$last_uri = $last_uri; return self::$last_uri; }