/** * Delete a Categorie in DB * parameters = POST: Categorie ID */ public function deleteKategorien() { require 'classes/SQL.php'; $sql = new SQL(); $sql->connect(); $id = mysql_real_escape_string($_POST['id']); if (is_numeric($id)) { $sql->doThat('DELETE FROM quizCategories WHERE id=' . $id); } }
/** * Remove Question in DB * parameters = POST: QuestionID */ public function deleteQuestion() { require 'classes/SQL.php'; $sql = new SQL(); $sql->connect(); $id = mysql_real_escape_string($_POST['id']); if (is_numeric($gameID)) { $sql->doThat('DELETE FROM quizQuestions WHERE id=' . mysql_real_escape_string($id)); } }
/** * Delete Highscore Row in DB * @return boolean */ public function deleteCol() { $success = false; require_once 'classes/SQL.php'; $sql = new SQL(); $sql->connect(); $gameID = mysql_real_escape_string($_POST['id']); if (person::getPermissionName() == 'admin' && is_numeric($gameID)) { $sql->doThat("DELETE FROM quizGames WHERE id=" . $gameID); } return $success; }
/** * Sets The End-Date in DB-Row Game */ public function EndGame() { $query = "UPDATE quizGames SET stop=now() WHERE id=" . $_SESSION['gameID']; require_once 'classes/SQL.php'; $sql = new SQL(); $sql->connect(); $sql->doThat($query); }