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) {