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"; }