getRow(sprintf("SELECT username, password FROM twitter_user WHERE id = '%d'", $_REQUEST['twitter-account']));
$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.
$mtdb->query(
sprintf("INSERT INTO twitter_post (status, user, time, text)VALUES ('scheduled', '%d', FROM_UNIXTIME('%d'), '%s')",
mysqli_real_escape_string($mtdb->link, $_REQUEST['twitter-account']),
$post_at,
mysqli_real_escape_string($mtdb->link, $_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 = $mtdb->getAll("SELECT id, username FROM twitter_user ORDER BY username");
$scheduled = $mtdb->getAll("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 |