function flair_list($subreddit)
{
$list = reddit_flairlist($subreddit);
foreach ($list as $entry) {
echo $entry->user . ',' . $entry->flair_text . ',' . $entry->flair_css_class . "\n";
}
}
function download_users($subreddit)
{
global $db;
print "Creating users table...\n";
$db->query("DROP TABLE users");
$db->query("CREATE TABLE users (user TEXT NOT NULL, team INTEGER NOT NULL)");
print "Fetching data from reddit...\n";
$list = reddit_flairlist($subreddit);
print "Populating users table...\n";
$query = $db->prepare("INSERT INTO users (user, team) VALUES (?,?)");
$db->beginTransaction();
foreach ($list as $entry) {
$user = $entry->user;
$teamId = preg_replace('/\\s+s\\d+$/', '', $entry->flair_css_class);
$query->execute(array($user, $teamId));
}
$db->commit();
print "User table created.\n";
print "Generating team counts...\n";
$query = $db->query("SELECT id FROM teams");
$users = $db->prepare("SELECT COUNT(*) AS count FROM users WHERE team=?");
$setCount = $db->prepare("UPDATE teams SET count=? WHERE id=?");
$db->beginTransaction();
while ($row = $query->fetch()) {
$teamId = $row['id'];
$users->execute(array($teamId));
$team = $users->fetch();
if ($team) {
$count = $team['count'];
$setCount->execute(array($count, $teamId));
}
}
$db->commit();
print "Team counts generated.\n";
}
