#!/usr/bin/env php
<?php
$filesDir = "";
$user = "";
$pass = "";
$database = "";
$host = "localhost";

$conn = mysql_connect($host, $user, $pass);
mysql_select_db($database);

$usersQuery = "SELECT a.userID, u.username, a.url FROM users u INNER JOIN artists a ON u.userID = a.userID WHERE a.upload_check = 1 ORDER BY userID ASC";
$users = mysql_query($usersQuery);
while ($usersRow = mysql_fetch_assoc($users))
{
        $filesQuery = "SELECT s.filename FROM artists_songs s WHERE industry = 'true' AND userID = ".$usersRow['userID']." UNION SELECT i.filename FROM artists_images i WHERE isIndustry = true AND userID = ".$usersRow['userID'];
        $files = mysql_query($filesQuery);
        while ($filesRow = mysql_fetch_assoc($files))
        {
                $path = sprintf("%s/%s/%s", $filesDir, $usersRow['url'], $filesRow['filename']);
                if (!@stat($path))
                {
                        print $usersRow['username']."\n";
                        $active++;
                        break;
                } else {
                        $unactive++;
                }
        }
}
print "Active: {$active}\nUnactive: {$unactive}\n";
mysql_close($conn);
?>