function flair_bot($subreddit)
{
global $db;
$messages = reddit_getUnreadMail();
$data = array();
foreach ($messages as $message) {
$message = $message->data;
if ($message->subject == 'crest') {
$author = $message->author;
if ($message->body == 'none') {
array_push($data, "{$author},,");
} else {
$id = preg_replace('/\\-s\\d+$/', '', $message->body);
$query = $db->query("SELECT name FROM teams WHERE id={$id}");
if (is_object($query)) {
$row = $query->fetch();
$text = $row['name'];
$css_class = preg_replace('/\\-/', ' ', $message->body);
if ($text) {
array_push($data, "{$author},{$text},{$css_class}");
}
}
}
}
}
flair_batch($subreddit, $data);
reddit_clearUnreadMail();
}
function upload_users($subreddit)
{
global $db;
print "Uploading new users...\n";
$data = array();
$query = $db->query("SELECT * FROM uploads");
while ($row = $query->fetch()) {
$user = $row['user'];
$text = $row['text'];
$css_class = $row['css_class'];
array_push($data, "{$user},{$text},{$css_class}");
}
flair_batch($subreddit, $data);
$db->query("DROP TABLE uploads");
$db->query("CREATE TABLE uploads (user TEXT PRIMARY KEY NOT NULL, text TEXT NOT NULL, css_class TEXT NOT NULL)");
print "Users uploaded.\n";
}
