} } closedir($fp); } if ($zutun == 6) { $snipelist = getWatchlist($db); } else { $snipelist = $db->get_results($auktionenSQL); } if (!empty($snipelist)) { $zaehler = 0; foreach ($snipelist as $snipe) { $artnr = $snipe->artnr; if ($snipe->status >= 0) { statusPruefen($artnr, $db); $text = getLogData($artnr); if ($text != false) { $text = preg_split("/\n/", $text); //in Textarea nicht ben?tigt, nimmt auch \n } else { $text = "<span style=\"color:#FF0000;font-weight:bold;\">Fehler - keine Datei zum Datenbankeintrag gefunden!</span>"; } } else { $text = preg_split("/\n/", $snipe->text); } ?> <tr> <td rowspan="2" style="<?php echo css_gruppenfarbe($snipe->gruppe, $db); ?> "><div style="width:100%; height:100%"></div></td>
function updateEndtime($db) { $sql = "SELECT * FROM snipe WHERE endtime <= 0"; $snipelist = $db->get_results($sql); if (!empty($snipelist)) { foreach ($snipelist as $snipe) { $logData = getLogData($snipe->artnr); $unixtime = auktionEndtime($logData); $sql = "UPDATE snipe SET endtime = " . $unixtime . " WHERE artnr = " . $snipe->artnr; $db->query($sql); } } }