Geeklog France

Next seven stories block

function phpblock_nextSeven()
{
    global $_TABLES, $_CONF;
    $result = DB_query("SELECT sid,title FROM {$_TABLES['stories']}
        WHERE (draft_flag = 0) AND (date <= NOW()) AND (frontpage='1')"
        . COM_getPermSQL ('AND') . " ORDER BY date desc LIMIT 10");
    $nrows  = DB_numRows($result);
 
    if( $nrows > 0 ){
        $string = '';
        $seven = array();
 
        for( $i = 0; $i < $nrows; $i++ ){
            $A = DB_fetchArray( $result );
            if ($i >= 3){
                $string .= $seven . '<br>';
                $seven[] = '<a href="' . COM_buildUrl( $_CONF['site_url']
                        . '/article.php?story=' . $A['sid'] ) . '">' . $A['title']
                        . '</a>';
            }
        }
        if( !empty( $seven )){
            $sevenlist = COM_makeList( $seven, 'list-next7-stories' );
        }
    }
    return $sevenlist;
}
Connecté en tant que : Guest (Guest)
blocks/nextsevenstories.txt · Dernière modification: 2009/01/16 19:16 par ::Ben
 

Download geeklog

Last version 1.8.1

Espace Membre





Devenir membre
Enregistrez-vous

Mot de passe oublié ?

Change language

Categories

  • Geeklog (38)
  • Plugins (53)
  • Thèmes (17)
  • My cart

    Votre panier (0 article)

    Votre panier est vide!

    0.00 EUR

    Visual Theme Switcher

    Test out available themes by selecting from one of the 6 available themes or give the Visual Switcher a try:

    Follow us on twitter

    En ligne

    Visiteurs: 9