// 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/>";