Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #!/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);
- ?>
Add Comment
Please, Sign In to add comment