Taken from the coming staticpage what's new block function, here is the phpblock version.
This block allow you to show in a block (or a staticpage) the list of the new staticpages
Text Formatted Code
function phpblock_new_staticpages ()
{
global $_CONF, $_TABLES, $_SP_CONF, $LANG_STATIC;
$newstaticpagesinterval = 1209600;
$includephp = 0;
$includecenterblocks = 0;
$retval = '';
$extra_sql = "";
if ($includecenterblocks == 0) {
$extra_sql =' AND sp_centerblock = 0';
}
if ($includephp == 0) {
$extra_sql .=' AND sp_php = 0';
}
$sql = "SELECT sp_id, sp_title
FROM {$_TABLES['staticpage']}
WHERE NOT ISNULL(sp_content) AND (sp_date >= (DATE_SUB(NOW(), INTERVAL {$newstaticpagesinterval} SECOND)))
{$extra_sql}
" . COM_getPermSQL( 'AND' ) . "
ORDER BY sp_date DESC LIMIT 15";
$result = DB_query( $sql );
$nrows = DB_numRows( $result );
if( $nrows > 0)
{
$newstaticpages = array();
for( $x = 0; $x < $nrows; $x++ )
{
$A = DB_fetchArray( $result );
$url = COM_buildUrl( $_CONF['site_url']
. '/staticpages/index.php?page=' . $A['sp_id'] );
$title = COM_undoSpecialChars( stripslashes( $A['sp_title'] ));
$titletouse = COM_truncate( $title, $_SP_CONF['title_trim_length'],
'...' );
if( $title != $titletouse )
{
$attr = array('title' => htmlspecialchars($title));
}
else
{
$attr = array();
}
$astaticpage = str_replace( '$', '$', $titletouse );
$astaticpage = str_replace( ' ', ' ', $astaticpage );
$newstaticpages[] = COM_createLink($astaticpage, $url, $attr);
}
$retval .= COM_makeList( $newstaticpages, 'list-new-comments' );
}
else
{
$retval .= $LANG_STATIC['no_new_pages'] . '<br' . XHTML . '>' . LB;
}
return $retval;
}