myopiclunacy.com

More social networking script goodness – this time with Ping.fm. Ping.fm is a very slick service that allows you to ping, or update all your blogs, social networks or other presence apps at once via the web, IM, SMS, email, and a variety of other ways. For example, you can update your Facebook and Twitter with the same status from IM, post new photo blogs to your Flickr and your Tumble blog from your Cell phone, or update your Blogger, LiveJournal and Wordpress.com blogs via email. It’s extremely flexible and customizable with groups, directives. link tracking and more. It could very well be the glue that keeps all our online identities in sync.

The one hole it does have (that affects me) is the self-hosted Wordpress blog. There are lots of cleaner alternatives to this problem and surely this little code exercise of mine isn’t meant to be a replacement for a good wordpress plugin like Matt Jacob’s Ping.fm WordPress Plugin. It’s just a quick and dirty way to get things working in a hurry.

I cobbled it together based on some code to post to the WP database that I found from DanBrown on SitePoint Forums as well as the Ping.fm Developer docs. It’s a page that also allows for some testing with form inputs. Place it in the root of your Wordpress installation and set up the page link in Ping.fm as a Custom URL. Hope it helps someone!

<?
// Grab message method from Ping.fm - must always be a form post
$method = $_POST["method"];
if($method=='blog' || $method=='microblog' || $method=='status')

{

	// Grab rest of data from Ping.fm
	$titlenew = stripslashes($_POST['title']);
	$postnew = stripslashes($_POST["message"]);
	$location = $_POST["location"];
	$media = $_POST["media"];
	$rawmessage = stripslashes($_POST["raw_message"]);
	$trigger = $_POST["trigger"];

	// If no title, construct one from the message
	if($titlenew == ""){
	  $titlenew = $method . ": " . $postnew;
	  if (strlen($titlenew)>50)
	    $titlenew = substr($titlenew,0,50) . "...";
	}

	// Grab location if it exists
	if($location != ""){
	  $postnew .= "\n\n<b>Location</b>: $location\n";
	}

	// If extra media - append to blog post
	if($media != ""){
	    $postnew .= "\n<hr>\n<b>Extra media variables</b>:";
	    $postnew .= "\n\n<b>Raw Message</b>: $rawmessage\n";
		$postnew .= "\n\n<b>Media URL</b>: $media\n";
	}

	// Get trigger (probably not needed in post, but useful for processing)
	if($trigger != ""){
	  $postnew .= "\n\n<b>Trigger</b>: $trigger";
	}

	// Create an excerpt from the post itself
	$excerpt=strip_tags(trim($postnew));

	// Create a post name by removing non-alphanumerics from the excerpt
	$RemoveChars  = array( "([\40])" , "([^a-zA-Z0-9-])", "(-{2,})" );
	$ReplaceWith = array("-", "", "-");
	$postname= preg_replace($RemoveChars, $ReplaceWith, $titlenew);

	// add HTML to any links
	$postnew = eregi_replace('(((f|ht){1}tp://)[-a-zA-Z0-9@:%_\+.~#?&//=]+)','<a href="\\1">\\1</a>', $postnew);
	$postnew = eregi_replace('([[:space:]()[{}])(www.[-a-zA-Z0-9@:%_\+.~#?&//=]+)','\\1<a href="http://\\2">\\2</a>', $postnew);
	$postnew = eregi_replace('([_\.0-9a-z-]+@([0-9a-z][0-9a-z-]+\.)+[a-z]{2,3})','<a href="mailto:\\1">\\1</a>', $postnew);

	// Prepare fields for DB entry
	$dbpostnew = addslashes($postnew);
	$dbtitlenew = addslashes($titlenew);
	$dbexcerpt = addslashes($excerpt);
	$postcat = "1";
	$postauth = "1";

	// Grab relevant DB and table information from config file
	include("wp-config.php");
	$db_connection = mysql_connect (DB_HOST, DB_USER, DB_PASSWORD) OR die (mysql_error());
	$db_select = mysql_select_db (DB_NAME) or die (mysql_error());
	$db_table = $table_prefix . 'posts';
	$db_cattable = $table_prefix . 'post2cat';

	// Prepare the query
	$query = "INSERT INTO $db_table VALUES (\"\",\"$postauth\",NOW(),NOW(),\"$dbpostnew\",\"$dbtitlenew\",\"$postcat\",\"$dbexcerpt\",\"publish\",\"open\",\"open\",\"\",\"$postname\",\"\",\"\",NOW(),NOW(),\"\",\"\",\"\",\"\",\"post\",\"\",\"\")";

	// Debug
	mail("me@mydomain.com", $titlenew, $query, "From: \"Ping.fm Custom URL Sample\" <support@ping.fm>");

	// Process the SQL and display success/failure
	$result = mysql_query($query);
	if ($result) {
		// Grab the Post ID and add a catagory in the assoc table
		$id = mysql_insert_id();
		$query2 = "INSERT INTO $db_cattable VALUES (\"\",$id,$postcat)";
		$result = mysql_query($query2);
	}

	// Display success/failure of the SQL
	if (!$result) {
		$out = "SQL Error: " . mysql_error() . "<textarea cols=100 rows=10>" . $query . "</textarea><hr>" . $query2;
	} else {
		$out = "Post submitted: $titlenew <br><br><textarea cols=100 rows=10> $postnew </textarea><br><br><textarea cols=100 rows=10> $query </textarea><br><br><a href=\"/?s=";
		$out .= urlencode(preg_replace("/[^a-zA-Z0-9\s]/", " ",$titlenew)) . ">Search</a>";
	}
	echo "<html><head><title>myopiclunacy.com Wordpress / Ping.fm Custom URL Mashup</title></head><body>";
	echo "$out";
	echo "</body></html>";

} else {

	?>
    <html>
    <head>
    <title>myopiclunacy.com Wordpress / Ping.fm Custom URL Mashup</title>
    </head>
    <body>
    <h3>Simulate a Ping.fm Custom URL post here</h3>
	<form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="pingfm">
		Post Method:
		<select name="method">
			<option value="blog">blog</option>
			<option value="microblog">microblog</option>
			<option value="status">status</option>
		</select>
		<br><br>Post Title:
		<input name="title" type="text" id="title" value="title" maxlength="50">
		<br><br>Post Location:
		<input name="location" type="text" id="location" value="" maxlength="40">
		<br><br>Post Media:
		<input name="media" type="text" id="media" value="http://ping.fm/" maxlength="100">
		<br><br>Post Trigger:
		<input name="trigger" type="text" id="trigger" value="" maxlength="12">
		<br><br>Post Content:<br>
		<textarea name="message" cols="100" rows="10" id="message">message http://ping.fm/</textarea>
		<br><br>Raw Post Content (without media links)<br>
		<textarea name="raw_message" cols="100" rows="10" id="raw_message">raw message</textarea>
		<br><br><input type="submit" value="Ping It" name="Submit">
	</form>
	</body>
	</html>

<?

	}

?>

Popularity: unranked [?]