mt-admin
RSS
Remove a stray debug function that snuck in.
Remove a stray debug function that snuck in.
darkmorford - - Load All Authors

File last commit:

3b807424bd87
7fe186c7689f
Show More
character-twitter.php
117 lines | 3.8 KiB | text/x-php | XmlPhpLexer
/ character-twitter.php
History | Source | Raw |Copy content
darkmorford
Add most necessary files for admin interface.
 r1 <?php
require_once('include/admin.inc.php');
auth_redirect(); // Require logged in user to access this page.
#Actual logic. Only trigger if something submitted.
if('post_twitter' == $_REQUEST['action'])
{
check_nonce('new-character-twitter');
darkmorford
Switch to mysqli_* in other php files.
 r5
darkmorford
Add most necessary files for admin interface.
 r1 #Fetch the password from the DB.
darkmorford
Update more admin pages to use DBAL functions.
 r30 $stmt = $dbConnection->executeQuery('SELECT username, password FROM twitter_user WHERE id = ?', array($_REQUEST['twitter-account']));
$acct = $stmt->fetch();
darkmorford
Switch to mysqli_* in other php files.
 r5
darkmorford
Add most necessary files for admin interface.
 r1 $post_at = strtotime($_REQUEST['date18']);
darkmorford
Switch to mysqli_* in other php files.
 r5
darkmorford
Add most necessary files for admin interface.
 r1 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);
darkmorford
Switch to mysqli_* in other php files.
 r5
darkmorford
Add most necessary files for admin interface.
 r1 if($ret)
{
$info.='Update posted to Twitter. <a href="http://www.twitter.com/'.$acct->username.'">View Twitter</a>.';
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.
darkmorford
Update more admin pages to use DBAL functions.
 r30 $dbConnection->executeUpdate('INSERT INTO twitter_post (status, user, time, text) VALUES (\'scheduled\', ?, FROM_UNIXTIME(?), ?)',
array($_REQUEST['twitter-account'], $post_at, $_REQUEST['message']));
darkmorford
Add most necessary files for admin interface.
 r1 $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.';
}
}
darkmorford
Update more admin pages to use DBAL functions.
 r30 $characters = $dbConnection->fetchAll('SELECT id, username FROM twitter_user ORDER BY username');
darkmorford
Add most necessary files for admin interface.
 r1
darkmorford
Update more admin pages to use DBAL functions.
 r30 $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');
darkmorford
Add most necessary files for admin interface.
 r1
adminhead('Manage Character Twitters');
adminmenu();
?>
<h2>Manage Character Twitters</h2>
<form method="post" action="character-twitter.php">
<?php nonce_field('new-character-twitter'); ?>
<input type="hidden" name="action" value="post_twitter" />
<p><select name="twitter-account">
<option value="">Select twitter</option>
<?php foreach($characters as $c) {
printf( '<option value="%s">%s</option>', htmlentities($c->id), htmlentities($c->username) );
} ?>
</select></p>
<p style="padding-bottom:1em;">
<input type="text" name="message" maxlength="140" size="70" />
At: <script type="text/javascript" src="CalendarPopup.js" ></script>
<script type="text/javascript">
var cal18 = new CalendarPopup("testdiv1");
cal18.setCssPrefix("TEST");
</script>
<INPUT TYPE="text" NAME="date18" VALUE="now" SIZE=25>
<A HREF="#" onClick="cal18.select(document.forms[0].date18,'anchor18','yyyy/MM/dd'); return false;" TITLE="cal18.select(document.forms[0].date18,'anchor18','MM/dd/yyyy'); return false;" NAME="anchor18" ID="anchor18">select</A>
<DIV ID="testdiv1" STYLE="position:absolute;visibility:hidden;background-color:white;layer-background-color:white;"></DIV>
<input type="submit" value="Send" />
</p>
</form>
<table class="widefat">
<thead>
<tr>
<th scope="col">User</th>
<th scope="col">Tweet</th>
<th scope="col">Time</th>
<th scope="col"></th>
</tr>
</thead>
<tbody id="the-list">
<?php
$alternate=false;
foreach( $scheduled as $s ) {
$alternate=!$alternate;
?>
<tr <?php if($alternate) echo 'class="alternate"'; ?>>
<td><?php echo $s->username; ?></td>
<td><?php echo $s->text; ?></td>
<td><?php echo htmlentities($s->time); ?></td>
<td style="text-align: center;"><a class="delete" href="delete-tweet.php?tweet_id=<?php echo $s->id; ?>">Delete</a></td>
</tr>
<?php
}
?>
</tbody>
</table>
<script type="text/javascript" src="<?php echo SITE_HOST.SITE_PATH; ?>/resources.js"></script>
<?php
adminfooter();
darkmorford
Switch to mysqli_* in other php files.
 r5 ?>