getOne( 'SELECT MAX(id) FROM strip' ); $next_strip_id += 1; $postmessage = str_replace("#nextcomic", $next_strip_id, $postmessage); if('' == $postmessage) _redirect( ADMIN_PATH . '/post-twitter.php?tweet=missing'); $username = sanitize_username($_REQUEST['twitter_user']); $postasuser = $mtdb->getOne( sprintf('SELECT username FROM twitter_user WHERE username="%s"', mysql_real_escape_string($username))); if( in_array('twitter', $_REQUEST['service']) ) $rc = twitterpost( numeric_entities(utfentities($postmessage)), $postasuser ); if( in_array('rss', $_REQUEST['service']) ) $rc = rsspost( numeric_entities(utfentities($postmessage)), SITE_HOST.SITE_PATH ); if($rc) _redirect( ADMIN_PATH . '/post-twitter.php?tweet=success'); _redirect( ADMIN_PATH . '/post-twitter.php?tweet=fail'); // Shall not pass, all routes lead to redirect. } if( isset($_REQUEST['tweet']) && 'success' == $_REQUEST['tweet'] ) $info.='Status successfully posted to Twitter.'; if( isset($_REQUEST['tweet']) && 'fail' == $_REQUEST['tweet'] ) $info.='Status could not be posted to Twitter. Is it up?'; if( isset($_REQUEST['tweet']) && 'missing' == $_REQUEST['tweet'] ) $error.='Oops~ Looks like you forgot to enter a message.'; $statuses = $mtdb->getAll('SELECT id, position, message FROM twitter_status ORDER BY position, id'); $twitter_users = $mtdb->getAll('SELECT id, username, oauth_token, oauth_token_secret, oauth_access_token FROM twitter_user ORDER BY username'); adminhead('Update Twitter'); adminmenu(); ?>