login(); $user->loadEmail(); if( !$user->admin ) { echo "You need to be logged in as an admin user!"; exit(); } $Spammer = DB::query("SELECT * from pl_users WHERE spamblocked=1"); $Abuses = DB::query("SELECT * FROM `pl_abuse`WHERE `read` =:1",0); $newComments = DB::query( 'SELECT c.id, c.content, u.name, u.avatar, UNIX_TIMESTAMP(c.created) AS created, i.keyword FROM '.TABLE_COMMENTS.' c LEFT JOIN '.TABLE_USERS.' u ON u.id = c.userId LEFT JOIN '.TABLE_IMAGES.' i ON i.id = c.imageId ORDER BY c.created DESC LIMIT 100' ); include( 'templates/header.tpl.php' ); ?>
Spammer / Abuse:
0){ echo '

Newest Spammer:

'; foreach( $Spammer as $u ) {?>
ID: / Images: / Website: 0 ){ echo "/ Bis:".date('Y-m-d H:i:s', $u["time"]); echo("
Grund: ".$u["spam_reason"]);} if ($user->id == 11 || $user->id == 1 ){ ?> / ">Unblock
No Spammer atm'; }?>		 0){ echo '

Newest Abuses:

'; foreach( $Abuses as $a ) { $Image = DB::getRow("SELECT *,UNIX_TIMESTAMP(logged) AS loggedTS FROM pl_images WHERE id=:1",$a["imageid"]); if ($Image != NULL && $a["imageid"] != 0){ ?>
"/>
Reason: / Email: User:'.$username["name"].''); } echo('
Delete Abuse'); ?>
"> >> Zum Thread
'); echo(''.$a["imagelink"].'
'); echo('Reason: '.$a['reason'].' / Email: '.$a['email'].''); echo(''); echo('
'); echo('Löschen'); echo('
'); } } }else{echo '

No Abuses

';}?>