function renameExisitingRt($rtyName, $rty_ID, $cnt)
{
global $mysqli;
$row = mysqli__select_array($mysqli, "select rty_ID from defDetailTypes where rty_Name = '" . mysql_real_escape_string($rtyName) . "'");
if ($row && $row[0]) {
//found
if (strpos($rtyName, "_deprecated") > 0) {
$rtyName = $rtyName . "_" . $cnt;
} else {
$rtyName = $rtyName . "_deprecated";
}
renameExisitingRt($rtyName, $rty_ID > 0 ? $rty_ID : $row[0], $cnt + 1);
} else {
if ($rty_ID > 0) {
$query = "UPDATE defDetailTypes set rty_Name=? where rty_ID=" . $rty_ID;
$stmt = $mysqli->prepare($query);
$stmt->bind_param('s', $rtyName);
if (!$stmt->execute()) {
//sql error
print "<div style='color:red'>'Cannot rename Record type {$rty_ID}. MySQL error: " . $mysqli->error . "</div>";
} else {
print "<div style='color:purple'>Existing Record type " . $row[0] . " was renamed to " . $rtyName . "</div>";
}
}
}
}
function mysqli__select_value($mysqli, $query)
{
$row = mysqli__select_array($mysqli, $query);
if ($row && @$row[0]) {
$result = $row[0];
} else {
$result = null;
}
return $result;
}