loadEmail();
$user->login();
$counter = 0;
echo("Login OK
");
$id = $_GET["id"];
$userinfo = DB::query("SELECT image,score,fame,id,logged,keyword,thumb FROM pl_images WHERE fame = 0 AND score < 10 ORDER BY logged ASC LIMIT 50",$id);
foreach($userinfo as $keyword){
$splitter = split("/",$keyword["keyword"]);
$counter++;
echo $counter." - ".$splitter[0]."/".$splitter[1]."/".$keyword["image"];
if (file_exists("data/images/".$splitter[0]."/".$splitter[1]."/".$keyword["image"])){
if (unlink("data/images/".$splitter[0]."/".$splitter[1]."/".$keyword["image"])){ echo(" -> Bild deleted"."
");}else{echo(" -> failed"."
");}
}
if (file_exists("data/thumbs/".$splitter[0]."/".$splitter[1]."/128x128/".$keyword["thumb"])){
if (unlink("data/thumbs/".$splitter[0]."/".$splitter[1]."/128x128/".$keyword["thumb"])){ echo(" -> 128x128 deleted"."
");}else{echo(" -> failed"."
");}
}
if (file_exists("data/thumbs/".$splitter[0]."/".$splitter[1]."/192x192/".$keyword["thumb"])){
if (unlink("data/thumbs/".$splitter[0]."/".$splitter[1]."/192x192/".$keyword["thumb"])){ echo(" -> 192x192 deleted"."
");}else{echo(" -> failed"."
");}
}
if (file_exists("data/thumbs/".$splitter[0]."/".$splitter[1]."/64x64/".$keyword["thumb"])){
if (unlink("data/thumbs/".$splitter[0]."/".$splitter[1]."/64x64/".$keyword["thumb"])){ echo(" -> 64x64 deleted"."
");}else{echo(" -> failed"."
");}
}
$u = DB::getRow("DELETE FROM pl_comments WHERE imageId=:1",$keyword["id"]);
$u = DB::getRow("DELETE FROM pl_unread WHERE imageid=:1",$keyword["id"]);
$u = DB::getRow("DELETE FROM pl_fav WHERE imageId=:1",$keyword["id"]);
}
$u = DB::query("DELETE FROM pl_images WHERE fame = 0 AND score < 10 ORDER BY logged ASC LIMIT 50",$keyword["id"]);
echo "Bilder entfernt aus der DB
";
?>