function deleteView() { global $connection; global $DBErrorMsg; $message = 'false'; if (isset($_GET['id']) && isset($_GET['ty'])) { $id = $connection->real_escape_string($_GET['id']); $viewType = $connection->real_escape_string($_GET['ty']); $query = "DELETE FROM...;\n\t\t\t\t\tDELETE FROM...;\n\t\t\t\t\tDELETE FROM..."; if ($result = $connection->multi_query($query)) { //adjust rel_order to fill in any gaps $ordQ = "SELECT..."; $adj = adjustOrder($ordQ, true); if ($adj !== true) { return; } //everything was successful, update message $message = 'true'; } } return $message; }
function editView() { global $connection; global $DBErrorMsg; $message = 'false'; if (isset($_GET['ord']) && isset($_GET['up']) && isset($_GET['ty']) && isset($_GET['def'])) { $order = $connection->real_escape_string($_GET['ord']); $newName = $connection->real_escape_string($_GET['up']); $viewType = $connection->real_escape_string($_GET['ty']); $def = $connection->real_escape_string($_GET['def']); if (isset($_GET['id'])) { $viewId = $connection->real_escape_string($_GET['id']); } else { //create new view and return id $viewId = createView($viewType, $newName, $def); if (!is_int(intval($viewId))) { return; } } if ($order === '_same') { $query = generateQuery($newName, false, $def, $viewId); } elseif ($order === '_last') { //get max relOrder $relOrder; $relQ = "SELECT..."; if ($result = $connection->query($relQ)) { while ($row = $result->fetch_assoc()) { $relOrder = $row['ro']; } $relOrder += 1; $query = generateQuery($newName, $relOrder, $def, $viewId); } else { echo $DBErrorMsg; } } elseif ($order === '_first') { //get list of views to update $ordQ = "SELECT..."; $adj = adjustOrder($ordQ, false); if ($adj === true) { //success, create query $query = generateQuery($newName, 1, $def, $viewId); } } elseif (is_int(intval($order))) { //find what rel_order should be based on the view id $ordQ = "SELECT..."; if ($result = $connection->query($ordQ)) { while ($row = $result->fetch_assoc()) { //if first view was selected then set to 1 instead of going to 0 if ($row['rel_order'] === 1) { $relOrder = 1; } else { $relOrder = $row['rel_order']; } //get list of views to update $ordQ = "SELECT..."; $adj = adjustOrder($ordQ, false); if ($adj === true) { //success, create query $query = generateQuery($newName, $relOrder, $def, $viewId); } } } else { echo $DBErrorMsg; } } //update view being edited if (isset($query)) { //send query if ($result = $connection->query($query)) { //adjust rel_order to fill in any gaps $ordQ = "SELECT..."; $adj = adjustOrder($ordQ, true); if ($adj !== true) { return; } //Success, send back id $message = $viewId; } else { echo $DBErrorMsg; } } } return $message; }