<?php
if ($_GET['tan'] != '' && $_GET['url'] != '') {
    db_query('DELETE FROM ' . $db_prefix . '_adscan_frameset WHERE url="' . $_GET['url'] . '"');
    db_query('DELETE FROM ' . $db_prefix . '_adminblacklist WHERE tan="' . $_GET['tan'] . '"');
}

if ($_GET['blacklist'] != '') {
    db_query('DELETE FROM ' . $db_prefix . '_adminblacklist WHERE tan="' . $_GET['blacklist'] . '"');
    db_query('UPDATE ' . $db_prefix . '_gebuchte_werbung SET status=2 WHERE tan="' . $_GET['blacklist'] . '"');
    db_query('DELETE FROM ' . $db_prefix . '_adscan_userblacklist WHERE tan="' . $_GET['blacklist'] . '"');
}

$intern = db_query('SELECT a.time, a.tan, g.ziel FROM ' . $db_prefix . '_adminblacklist a LEFT JOIN ' . $db_prefix . '_gebuchte_werbung g ON a.tan=g.tan');

head('Gemeldete Kampagnen');
echo '<table width="100%">
<tr>
<td>Tan</td>
<td>KID</td>
<td>Sponsor</td>
<td>Zeit</td>
<td>Gepr&uuml;ft am/um</td>
<td>Aktionen</td>
</tr>';
while ($banner = mysql_fetch_array($intern)) {
    $geprueft = mysql_fetch_assoc(db_query('SELECT time FROM ' . $db_prefix . '_adscan_frameset WHERE url = "' . $banner['ziel'] . '"'));
    echo '<tr>
<td>' . $banner['tan'] . '</td>
<td>' . $banner['kid'] . '</td>
<td>' . $banner['sponsor'] . '</td>
<td>' . date('d.n.y G:i', $banner['time']) . '</td>
<td>' . date('d.n.y G:i', $geprueft['time']) . '</td>
<td><a href="frametest.php?url=' . urlencode($banner['ziel']) . '" target="_blank">Testen</a>
<a href="?content=/adscan/meldungen&tan=' . $banner['tan'] . '&url=' . $banner['ziel'] . '" target="_self">Löschen</a>
<a href="?content=/adscan/meldungen&blacklist=' . $banner['tan'] . '" target="_self">Blacklist</a></td>
</tr>';
}
echo '</table>';
foot();

?>