<?php head("Admin ForcedBanner");

if (!isset($_GET['tan'])) $_GET['tan'] = '';
if (!isset($_GET['loeschen'])) $_GET['loeschen'] = '';

if ($_GET['loeschen'] == 'true' && $_GET['tan']) {
    $sql = sql::$db->prepare("DELETE FROM " . _VMS_ . "_gebuchte_werbung WHERE tan=? and sponsor='administrator' LIMIT 1");
    $sql->execute(array($_GET['tan']));
}

$forcedbanner = sql::$db->query("SELECT * FROM " . _VMS_ . "_gebuchte_werbung WHERE sponsor='administrator' and werbeart = 'forcedbanner' and status = '1' ORDER BY kid ASC");
if ($forcedbanner->rowCount() == 0) {
    echo 'Keine Admin Kampagnen im System.';
}
while ($anzeigen = $forcedbanner->fetch() ) {
    echo '

<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
    <td align="center" width="50%"><b>TAN:</b>&nbsp;' . $anzeigen['tan'] . '</td>
    <td align="center" width="50%"><b>Vergütung:</b>&nbsp;' . number_format($anzeigen['verdienst'], 2, ",", ".") . '</td>
</tr>
<tr bgcolor="#f0f0f0">
    <td align="left" colspan="2"><br><b>Ziel:</b> <a href="' . $anzeigen['ziel'] . '">' . $anzeigen['ziel'] . '</a> <br><b>Banner:</b> <a href="' . $anzeigen['banner'] . '">' . $anzeigen['banner'] . '</a><br><br></td>
</tr>
<tr bgcolor="#f0f0f0">
    <td align="center" width="50%"><b>Reload:</b>&nbsp;' . $anzeigen['reload'] / 3600 . 'h  <b>Rest:</b>&nbsp;' . number_format($anzeigen['menge'], 0, ",", ".") . ' Klicks</td>
    <td align="center" width="50%"><a href="?content=/interfacebanner/admin&amp;loeschen=true&amp;tan=' . $anzeigen['tan'] . '" target="_self">Löschen</a></td>
</tr>
</table>
<br>
';
}

foot();
?>