Newer
Older
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
<?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: ' . $blockiert ['tan'] . '<br>KID: ' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet: ' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User: ' . 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: ' . $blockiert ['reload'] / 3600 . ' Std. / Rest: ' . 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: ' . $blockiert ['tan'] . '<br>KID: ' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet: ' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User: ' . 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: ' . $blockiert ['reload'] / 3600 . ' Std. / Rest: ' . 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: ' . $blockiert ['tan'] . '<br>KID: ' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet: ' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User: ' . 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: ' . $blockiert ['reload'] / 3600 . ' Std. / Rest: ' . 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: ' . $blockiert ['tan'] . '<br>KID: ' . $blockiert ['kid'] . ' (' . $blockiert ['sponsor'] . ')</td>
<td align="center" width="50%">Bet: ' . number_format($blockiert ['preis'], 2, ",", ".") . ' / User: ' . 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: ' . $blockiert ['reload'] / 3600 . ' Std. / Rest: ' . number_format($blockiert ['menge'], 0, ",", ".") . '</td>
</tr>
</table>';
}
foot();
?>