07-03-2009, 05:56 PM
|
#2 (permalink)
|
|
The Addict
Join Date: May 2009
Posts: 287
Thanks: 5
|
I don't see an API, if they have one it would be the answer to this question.
*EDIT*
Alright This should get you started.
PHP Code:
<?php
// Set the detauls
$hostname = "db1932.perfora.net";
$dbname = "db291144085";
$username = "dbo291144085";
$password = "qNwx9kTX";
// Now grab the lastest item
$connect = mysql_connect($hostname, $username, $password);
mysql_select_db($dbname);
// build the query.
$sql = "SELECT * FROM items ORDER BY id DESC LIMIT 1";
$query = mysql_query($sql);
// Now make it an array
$query = mysql_fetch_array($query, MYSQL_ASSOC);
// A Little Debugging
// print_r($query);
// Now we can take the query and treat it like an array
echo "Title: <a href='" . $query["item_permalink"] . "'>" . $query[item_title] . "</a><br />";
echo "Content: " . $query["item_content"] . "<br />";
echo "Time: " . $query["item_date"] . "<br />";
?>
A sample response is:
Code:
Array
(
[ID] => 1
[item_date] => 1246652528
[item_content] => Whats up?
[item_title] => Hello World
[item_permalink] =>
[item_status] => publish
[item_name] => hello-world
[item_parent] => 0
[item_data] => a:0:{}
[item_feed_id] => 0
)
Example: http://open.ashannon.us/junk/sweetcr...-sweetcron.php
*Notes*
I have to give the guy who created this a LOT of credit, he has tons of features. I think that he lost interest or didn't have and visible support so he stopped this project, but it's a great system. I would recommend it if you like the demo.
Last edited by adamdecaf : 07-05-2009 at 11:28 PM.
|
|
|
|
Join the friendly bunch on IRC...
Linear Mode
