function snipeEinstellen($artnr, $bid, $db)
{
$bid = str_replace(",", ".", $bid);
$sql = "SELECT * FROM snipe WHERE artnr=" . $artnr;
$snipe = $db->get_row($sql);
if (empty($snipe)) {
genAuctionfile($artnr, $bid);
//PID auslesen und in Datenbank schreiben
$pid = startEsniper($artnr);
$sql = "INSERT INTO snipe (artnr,bid,pid,status) VALUES (\"{$artnr}\",\"{$bid}\",\"{$pid}\",0)";
$db->query($sql);
} else {
//Snipe bereits in Datenbank vorhanden
if ($bid != $snipe->bid) {
killSniper($artnr, $db);
genAuctionfile($artnr, $bid);
$pid = startEsniper($artnr);
$sql = "UPDATE snipe SET bid = " . $bid . ",pid = " . $pid . ",status = 0 WHERE artnr = " . $snipe->artnr;
$db->query($sql);
} elseif (!snipeRunCheck($snipe->pid)) {
genAuctionfile($artnr, $bid);
$pid = startEsniper($artnr);
$sql = "UPDATE snipe SET pid = " . $pid . " WHERE artnr = " . $artnr;
$db->query($sql);
}
}
exec("./updateDB.php &");
//Nach 10 Sekunden aus den Logs die Endtime in der DB updaten - multi Thread
}
$artnr = $match[1];
}
} else {
$artnr = "";
}
$bid = array_key_exists("bid", $_GET) ? preg_match('/^[0-9]*[,\\.]?[0-9]{1,2}$/', $_GET["bid"]) ? $_GET["bid"] : "" : "";
$delete = array_key_exists("delete", $_GET) ? preg_match('/^[0-9]+$/', $_GET["delete"]) ? $_GET["delete"] : "" : "";
$gruppe = array_key_exists("gruppe", $_GET) ? preg_match('/^[0-9]+$/', $_GET["gruppe"]) ? $_GET["gruppe"] : "" : "";
$filtergruppe = array_key_exists("fitlergruppe", $_GET) ? preg_match('/^[0-9]+$/', $_GET["filtergruppe"]) ? $_GET["filtergruppe"] : "" : "";
//Eintrag erstellen
$auktionenSQL = "SELECT * FROM snipe ORDER BY status,endtime ASC";
//Standard
switch ($zutun) {
case 1:
//Artikel l?schen
killSniper($delete, $db);
$sql = "DELETE FROM snipe WHERE artnr=" . $delete;
$snipe = $db->get_row($sql);
break;
case 2:
$sql = "UPDATE snipe SET gruppe = " . $gruppe . " WHERE artnr = " . $artnr;
$db->query($sql);
break;
case 3:
//Aufr?umen
$sql = "DELETE FROM snipe WHERE status != 0";
$db->query($sql);
break;
case 4:
//Auktionsliste nach Gruppe filtern
if ($filtergruppe == -1) {
