<?php
$blockierte = db_query('SELECT * FROM ' . $db_prefix . '_gebuchte_werbung g LEFT JOIN ' . $db_prefix . '_fb_blacklist f ON f.kid=g.kid AND f.werbeart=g.werbeart WHERE g.werbeart="forcedbanner" AND LOCATE(f.sponsor, g.ziel) AND g.status=1 AND f.kid IS NOT NULL');
head('Von Adscan blockierte Kampagnen');
echo '<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="100%"><B>Gesperrte Forcedbanner Kampangen<B></td>
</tr>
</table>';
while ($blockiert = mysqli_fetch_assoc($blockierte)) {
    echo '
<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="50%">TAN:&nbsp;' . $blockiert ['tan'] . '<br>KID:&nbsp;' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet:&nbsp;' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User:&nbsp;' . number_format($blockiert ['verdienst'], 2, ",", ".") . '</td>
</tr>
<tr bgcolor="#f0f0f0">
<td align="center" colspan="2"><a href="' . $blockiert ['ziel'] . '" target="_blank"><img alt="Sponsorenbanner" src="' . $blockiert ['banner'] . '" border="0" width="468" height="60"></a></td>
</tr>
<tr bgcolor="#f0f0f0">
<td align="center" width="50%">Reload:&nbsp;' . $blockiert ['reload'] / 3600 . ' Std. / Rest:&nbsp;' . number_format($blockiert ['menge'], 0, ",", ".") . '</td>
</tr>
</table>';
}

$blockierte = db_query('SELECT * FROM ' . $db_prefix . '_gebuchte_werbung g LEFT JOIN ' . $db_prefix . '_fb_blacklist f ON f.kid=g.kid AND f.werbeart=g.werbeart WHERE g.werbeart="paidmail" AND LOCATE(f.sponsor, g.ziel) AND g.status=1 AND f.kid IS NOT NULL');

echo '<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="100%"><B>Gesperrte Paidmail Kampangen<B></td>
</tr>
</table>';

while ($blockiert = mysqli_fetch_assoc($blockierte)) {
    echo '<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="50%">TAN:&nbsp;' . $blockiert ['tan'] . '<br>KID:&nbsp;' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet:&nbsp;' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User:&nbsp;' . number_format($blockiert ['verdienst'], 2, ",", ".") . '</td>
</tr>

<tr bgcolor="#f0f0f0">
<td align="center" colspan="2"><a href="' . $blockiert ['ziel'] . '" target="_blank">' . $blockiert ['ziel'] . '</a></td>
</tr>
<tr bgcolor="#f0f0f0">
<td align="center" colspan="2"><textarea style="width:100%">' . $blockiert ['mailtext'] . '</textarea></td>
</tr>

<tr bgcolor="#f0f0f0">
<td align="center" width="50%">Reload:&nbsp;' . $blockiert ['reload'] / 3600 . ' Std. / Rest:&nbsp;' . number_format($blockiert ['menge'], 0, ",", ".") . '</td>
</tr>
</table>';
}

$blockierte = db_query('SELECT * FROM ' . $db_prefix . '_gebuchte_werbung g LEFT JOIN ' . $db_prefix . '_fb_blacklist f ON f.kid=g.kid AND f.werbeart=g.werbeart WHERE g.werbeart="paidlinks" AND LOCATE(f.sponsor, g.ziel) AND g.status=1 AND f.kid IS NOT NULL');

echo '<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="100%"><B>Gesperrte Paidlink Kampangen<B></td>
</tr>
</table>';

while ($blockiert = mysqli_fetch_assoc($blockierte)) {
    echo '<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="50%">TAN:&nbsp;' . $blockiert ['tan'] . '<br>KID:&nbsp;' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet:&nbsp;' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User:&nbsp;' . number_format($blockiert ['verdienst'], 2, ",", ".") . '</td>
</tr>

<tr bgcolor="#f0f0f0">
<td align="center" colspan="2"><a href="' . $blockiert ['ziel'] . '" target="_blank">' . $blockiert ['ziel'] . '</a></td>
</tr>

<tr bgcolor="#f0f0f0">
<td align="center" width="50%">Reload:&nbsp;' . $blockiert ['reload'] / 3600 . ' Std. / Rest:&nbsp;' . number_format($blockiert ['menge'], 0, ",", ".") . '</td>
</tr>
</table>';
}

$blockierte = db_query('SELECT * FROM ' . $db_prefix . '_gebuchte_werbung g LEFT JOIN ' . $db_prefix . '_fb_blacklist f ON f.kid=g.kid AND f.werbeart=g.werbeart WHERE g.werbeart != "paidmail" AND g.werbeart != "forcedbanner" AND g.werbeart !="paidlinks" AND LOCATE(f.sponsor, g.ziel) AND g.status=1 AND f.kid IS NOT NULL');

echo '
<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="100%"><B>Gesperrte Andere Kampangen<B></td>
</tr>
</table>';

while ($blockiert = mysqli_fetch_assoc($blockierte)) {
    echo '<table width="100%" cellpadding="0" cellspacing="1" border="0" bgcolor="#c0c0c0">
<tr bgcolor="#f0f0f0">
<td align="center" width="50%">TAN:&nbsp;' . $blockiert ['tan'] . '<br>KID:&nbsp;' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet:&nbsp;' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User:&nbsp;' . number_format($blockiert ['verdienst'], 2, ",", ".") . '</td>
</tr>

<tr bgcolor="#f0f0f0">
<td align="center" colspan="2"><a href="' . $blockiert ['ziel'] . '" target="_blank">' . $blockiert ['ziel'] . '</a></td>
</tr>

<tr bgcolor="#f0f0f0">
<td align="center" width="50%">Reload:&nbsp;' . $blockiert ['reload'] / 3600 . ' Std. / Rest:&nbsp;' . number_format($blockiert ['menge'], 0, ",", ".") . '</td>
</tr>
</table>';
}

foot();

?>