// The email address assigned to your Posterous account ...
define('IMPORT_SITE_PASSWORD', 'PASSWORD');
// The password assigned to your Posterous account ...
define('DB_NAME', 'Database Name');
define('DB_URL', 'Database URL or IP Address');
define('DB_USER', 'Database username');
define('DB_PASSWORD', 'Database password');
$batchSize = 100;
$totalRecsProcessed = 0;
$currentRecord = 0;
// SHOW ITEM BY DEFAULT on Posterous Website
$private_item = 1;
echo "Welcome. This process will attempt to move your items from SweetCron to Posterous<br/><br/>";
$db = new DataAccessLayer(DB_URL, DB_USER, DB_PASSWORD, DB_NAME);
$db->debug = false;
$totalRows = $db->nonQuery("select * FROM items where item_status = 'publish' limit 0,10");
while ($totalRows > 0) {
$currentRecord = 0;
if ($totalRecsProcessed > 100) {
break;
}
echo "<h1>Processing " . $totalRecordsProcessed . " through " . $totalRecordsProcessed + $batchSize . "</h1>";
$sql = "SELECT f.feed_title, f.feed_url, f.feed_domain, f.feed_icon, f.feed_data, i.* FROM items i " . " inner join feeds f on f.feed_id = i.item_feed_id " . " where i.item_status = 'publish' " . " limit 0," . $batchSize;
$items = $db->query($sql);
while ($obj = $items->fetch_object()) {
$dmp = unserialize($obj->item_data);
// load up the serialized item_data
echo "<h3>Importing " . $obj->ID . " - " . $obj->item_title . "</h3>";
echo "Original Date: " . $obj->item_date . "<br/>";
echo "Item Title: " . $dmp["title"] . "<br/>";
$itemContent = "From: " . $obj->feed_domain . "<br/>" . $dmp["content"] . "<br/>Permalink: <a href='" . $obj->item_permalink . "'>" . $obj->item_permalink . "</a><br/>";
