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
<?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ü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();
?>