paidmail_hist.php

<?php
if (!isset($_GET['tan'])) $_GET['tan'] = "";
if (!isset($_GET['loeschen'])) $_GET['loeschen'] = "";

if ($_GET['loeschen'] == 'true') {
    $sql = sql::$db->prepare("DELETE FROM " . _VMS_ . "_paidmails_versendet WHERE tan=?");
    $sql->execute(array($_GET['tan']));
    $sql = sql::$db->prepare("DELETE FROM " . _VMS_ . "_paidmails_empfaenger WHERE tan=?");
    $sql->execute(array($_GET['tan']));
}

$mails = sql::$db->query("SELECT * FROM " . _VMS_ . "_paidmails_versendet ORDER BY gesendet DESC");

while ($history = $mails->fetch() ) {
    head('Paidmail: ' . $history['beschreibung']);
    echo '<b>Tan:</b> ' . $history['tan'] . '<br>
      <b>Menge:</b> ' . $history['menge'] . '<br>
      <b>Bestätigt:</b> ' . $history['bestaedigt'] . ' (' . @round($history['bestaedigt'] / $history['menge'] * 100, 2) . ' %)<br>
      <b>Userverdienst:</b> ' . $history['verdienst'] . '<br>
      <b>Gültig bis:</b> ' . date("d.m.Y - H:i", $history['gueltig']) . '<br>
      <b>Gesendet am:</b> ' . date("d.m.Y - H:i", $history['gesendet']) . '  <br>
      <b>Aufenthalt:</b> ' . $history['aufendhalt'] . ' Sek.<br>
      <p align="center"><textarea style="width:100%">' . $history['mailtext'] . '</textarea></p>';

    if ($history['gueltig'] <= time() or $history['menge'] == $history['bestaedigt']) {
        echo '
      <br><br><a href="?content=/werbesystem/paidmail_hist&amp;tan=' . $history['tan'] . '&amp;loeschen=true"><b>Löschen!</b></a>
      ';
    }
    foot();
}

if ($mails->rowCount() == 0) {
    head("Information");
    echo 'Noch keine Paidmails vorhanden!';
    foot();
}