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