<?php
/*
 * This program is free software; you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation; either version 2 of the License, or
 * (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 */
?>
<?php
/* vim: set ts=4 sw=4 et : */

require_once __DIR__ . "/check_auth.php";
require_once __DIR__ . "/../includes/common.php";

if (!isset($_POST['id']) || !is_numeric($_POST['id']) || intval($_POST['id'] < 1)) {
    echo "Ungültiger Aufruf (@1).";
    exit(0);
}
if (!isset($_POST['what'])) {
    echo "Ungültiger Aufruf (@2).";
    exit(0);
}
$what = $_POST['what'];

if ($what === 'orga') {
    $sql = "DELETE FROM Personen_Organisationen WHERE Person=? LIMIT 20;";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("i", $_POST['id']);
    $stmt->execute();
    echo $mysqli->affected_rows;
    $stmt->reset();
} else if ($what === 'event') {
    $sql = "DELETE FROM event_participants WHERE persid=? LIMIT 500;";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("i", $_POST['id']);
    $stmt->execute();
    echo $mysqli->affected_rows;
    $stmt->reset();
} else if ($what === 'email') {
    $sql = "DELETE FROM mails WHERE persid=? LIMIT 1000;";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("i", $_POST['id']);
    $stmt->execute();
    echo $mysqli->affected_rows;
    $stmt->reset();
} else if ($what === 'emailrewrite') {
    $sql = "UPDATE mails SET persid=NULL WHERE persid=? LIMIT 1000;";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("i", $_POST['id']);
    $stmt->execute();
    echo $mysqli->affected_rows;
    $stmt->reset();
} else if ($what === 'person') {
    $sql = "DELETE FROM Personen WHERE ID=? LIMIT 1;";
    $stmt = $mysqli->prepare($sql);
    $stmt->bind_param("i", $_POST['id']);
    $stmt->execute();
    echo $mysqli->affected_rows;
    $stmt->reset();
} else {
    echo "Ungültiger Aufruf (@2).";
}

exit(0);
?>