mt-admin Files · twitter-scheduled.php

Fix a couple of bugs related to posting comics.

darkmorford - - Load All Authors

File last commit:

104fb88d66f8

d30255be3d08

Download file

             twitter-scheduled.php
        
                    40 lines
            
             | 1.2 KiB
            
                | text/x-php
            
             |
                PhpLexer
            
             / twitter-scheduled.php
          
                    History
                
                 |
                  Annotation
                 | Raw
                 |Copy content

      <?php

      require_once('include/admin.inc.php');

      //	First, the quick hack way. May become neccessary to parallelize later.

      $tweets = $dbConnection->fetchAll('SELECT username, password, text, status, tp.id AS id FROM twitter_post tp JOIN twitter_user tu ON tp.user = tu.id ' .

      	'WHERE tp.status = \'scheduled\' AND time >= NOW() AND time < TIMESTAMPADD(?, NOW())', array(RUN_INTERVAL));

      //	Check if we actually have any tweets. If not, bail.

      if(count($tweets) === 0)

      {

      	exit(0);

      }

      //	There are tweets to post. Let's get to work.

      foreach($tweets as $t)

      {

      	//	Lock the tweet

      	$dbConnection->executeUpdate('UPDATE twitter_post SET status = \'locked\' WHERE id = ? AND status = \'scheduled\'', array($t->id));

      	if(twitterpost($t->text, $t->username, $t->password))

      	{

      		//	It worked!

      		adminlog("Scheduled tweet posted for user ".$t->username, MTS_TWITTER, MTA_ADD);

      		$t->status = 'success';

      	}

      	else

      	{

      		//	Well, shit. Something went wrong. Log it.

      		adminlog("Error $ret_code posting scheduled tweet ".$t->id . ' with return value ' . $ret, MTS_TWITTER, MTA_ADD);

      		$t->status = 'error';

      	}

      	//	Unlock tweet, update db.

      	$dbConnection->executeUpdate('UPDATE twitter_post SET status = ? WHERE status = \'locked\' AND id = ?', array($t->status, $t->id));

      }

      ?>

	Site-wide shortcuts
/	Use quick search box
g h	Goto home page
g g	Goto my private gists page
g G	Goto my public gists page
g 0-9	Goto bookmarked items from 0-9
n r	New repository page
n g	New gist page

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings

				<?php

				require_once('include/admin.inc.php');

				// First, the quick hack way. May become neccessary to parallelize later.

				$tweets = $dbConnection->fetchAll('SELECT username, password, text, status, tp.id AS id FROM twitter_post tp JOIN twitter_user tu ON tp.user = tu.id ' .
				'WHERE tp.status = \'scheduled\' AND time >= NOW() AND time < TIMESTAMPADD(?, NOW())', array(RUN_INTERVAL));

				// Check if we actually have any tweets. If not, bail.
				if(count($tweets) === 0)
				{
				exit(0);
				}

				// There are tweets to post. Let's get to work.

				foreach($tweets as $t)
				{
				// Lock the tweet
				$dbConnection->executeUpdate('UPDATE twitter_post SET status = \'locked\' WHERE id = ? AND status = \'scheduled\'', array($t->id));

				if(twitterpost($t->text, $t->username, $t->password))
				{
				// It worked!
				adminlog("Scheduled tweet posted for user ".$t->username, MTS_TWITTER, MTA_ADD);
				$t->status = 'success';
				}
				else
				{
				// Well, shit. Something went wrong. Log it.
				adminlog("Error $ret_code posting scheduled tweet ".$t->id . ' with return value ' . $ret, MTS_TWITTER, MTA_ADD);
				$t->status = 'error';
				}

				// Unlock tweet, update db.
				$dbConnection->executeUpdate('UPDATE twitter_post SET status = ? WHERE status = \'locked\' AND id = ?', array($t->status, $t->id));
				}

				?>