Geeklog France
 

For filemgmt plugin 1.5+

function phpblock_topdl()
{
    //For filemgmt plugin >= 1.5
    global $_DB_table_prefix, $_USER;
 
    $poplist = '';
 
    $_FM_TABLES['filemgmt_cat']             = $_DB_table_prefix . 'filemgmt_category';
    $_FM_TABLES['filemgmt_filedetail']      = $_DB_table_prefix . 'filemgmt_filedetail';
 
    $query  = "SELECT f.* FROM {$_FM_TABLES['filemgmt_filedetail']} AS f
                LEFT JOIN {$_FM_TABLES['filemgmt_cat']} AS c
                ON c.cid = f.cid
                ";
 
    if (isset($_USER['uid']) AND $_USER['uid'] > 1) {
        $uid = $_USER['uid'];
    } else {
        $uid = 1;
    }
 
    $_GROUPS = SEC_getUserGroups($uid);
 
    $groupsql = '';
 
    if (count($_GROUPS) == 1) {
        $groupsql .= " WHERE c.grp_access = '" . current($_GROUPS) ."'";
    } else {
        $groupsql .= " WHERE c.grp_access IN (" . implode(',',array_values($_GROUPS)) .")";
    }
 
    $query  .= $groupsql;
 
    //Files limit is 5. Change it if you need
    $query .= " ORDER BY hits DESC LIMIT 0 , 5";
 
    $result = DB_query($query);
 
    $nrows  = DB_numRows($result);
 
    if( $nrows > 0 ){
        $string = '';
        $popular = array();
 
        for( $i = 0; $i < $nrows; $i++ ){
            $A = DB_fetchArray( $result );
            $string .= $poplist . '';
            $popular[] = '<a href="' . $_CONF['site_url']
                    . '/filemgmt/index.php?id=' . $A['lid']  . '">' . $A['title']
                    . '</a> (' . $A['hits'] . ')';
        }
        if( !empty( $popular )){
            $poplist = COM_makeList( $popular, 'list-popular-stories' );
        }
    }
    return $poplist;
}
Connecté en tant que : Guest (Guest)
blocks/topdl.txt · Dernière modification: 2011/07/05 19:19 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: 6