executeQuery('SELECT username, password FROM twitter_user WHERE id = ?', array($_REQUEST['twitter-account']));
$acct = $stmt->fetch();
$post_at = strtotime($_REQUEST['date18']);
if($post_at)
{
if($post_at <= strtotime('now'))
{
#If we can post immediately, do so. Bypass the scheduler whenever possible.
#Treat a date/time in the past as immediate.
$ret = twitterpost($_REQUEST['message'], $acct->username, $acct->password);
if($ret)
{
$info.='Update posted to Twitter. View Twitter.';
adminlog('New manual post to Twitter for user '. $acct->username .'.', MTS_TWITTER, MTA_ADD);
}
else
{
$error.='There was an error posting to Twitter.';
}
}
else
{
#No luck, gotta schedule.
$dbConnection->executeUpdate('INSERT INTO twitter_post (status, user, time, text) VALUES (\'scheduled\', ?, FROM_UNIXTIME(?), ?)',
array($_REQUEST['twitter-account'], $post_at, $_REQUEST['message']));
$info .= "Your tweet for user " . htmlentities($acct->username) . " has been scheduled.";
adminlog('Tweet for account ' . $acct->username . ' has been scheduled.', MTS_TWITTER, MTA_ADD);
}
}
else
{
$error .= 'Could not make sense of your designated time/date. Please try again.';
}
}
$characters = $dbConnection->fetchAll('SELECT id, username FROM twitter_user ORDER BY username');
$scheduled = $dbConnection->fetchAll('SELECT username, text, status, twitter_post.id AS id, time ' .
'FROM twitter_post JOIN twitter_user ON twitter_post.user = twitter_user.id ' .
'WHERE twitter_post.status = \'scheduled\' ORDER BY time');
adminhead('Manage Character Twitters');
adminmenu();
?>
Manage Character Twitters
| User |
Tweet |
Time |
|
>
| username; ?> |
text; ?> |
time); ?> |
Delete |