/**
* 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);
}
