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;
}
