Welcome to Geeklog Wednesday, August 21 2019 @ 11:34 am EDT

Geeklog Forums

Top Ten Links


Status: offline

MLimburg

Forum User
Chatty
Registered: 17/12/01
Posts: 35
Location:Adelaide, AU
I'm hacking away at the code for a bunch of addons that knuckles wants .. so I thought I'd add a few of them in here for us all to use. The following is a function for lib-custom.php which allows you to shop the top ten links in a block. Open lib-custom.php and insert the following:

PHP Code

PHP Formatted Code
function phpblock_toptenlinks()
{
    global $_CONF, $_TABLES, $LANG10;

    $result = DB_query( "SELECT lid,url,title,hits from {$_TABLES['links']} WHERE hits > 0 ORDER BY hits desc LIMIT 10" );
    $nrows = DB_numRows( $result );

    $stat_templates = new Template( $_CONF['path_layout'] . 'stats' );
    $stat_templates->set_file( array(
        'itemstats'=>'itemstatistics.thtml',
        'statrow'=>'singlestat.thtml'
        ));
       
    if( $nrows > 0 )
    {
        $stat_templates->set_var( 'item_label', $LANG10[19] );
        $stat_templates->set_var( 'stat_name', $LANG10[20] );

        for( $i = 0; $i < $nrows; $i++ )
        {
            $A = DB_fetchArray( $result );

            $stat_templates->set_var( 'item_url', $_CONF['site_url'] . '/portal.php?url=' . $A['url'] . '&what=link&item=' . $A['lid'] );
            $stat_templates->set_var( 'item_text', stripslashes( str_replace( '$', '$', $A['title'] )));
            $stat_templates->set_var( 'item_stat', $A['hits'] );

            $stat_templates->parse( 'stat_row', 'statrow', true );
        }

        $stat_templates->parse( 'output', 'itemstats' );
           
        $retval .= $stat_templates->finish( $stat_templates->get_var( 'output' ));
    }
    else
    {
        $retval .= $LANG10[21];
    }
    return $retval;
}
 

This will allow you to call phpblock_toptenlinks as a block. In addition (and indeed, the reason it was written in the first place), you can code a template placemarker to get this info. Something like ...

PHP Formatted Code
    $tpl->set_var( 'toptenlinks', phpblock_toptenlinks() );

... will give you the ability to place that info pretty much anywhere!

Happy Hacking.


Friends help you move. Real friends help you move bodies.

Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 06/11/02
Posts: 523
Anyone have an up to date version of this block?

Status: offline

redneck

Forum User
Junior
Registered: 11/04/05
Posts: 24
Looking Myself. Thanks for any help.

Redneck

Status: offline

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
try this:
PHP Formatted Code

function phpblock_topTenLinks(){
    global $_TABLES, $_CONF;

    $result = DB_query ("SELECT lid,url,title,description,hits FROM {$_TABLES['links']} WHERE (hits > 0)" . COM_getPermSQL ('AND') . " ORDER BY hits DESC LIMIT 10");
    $nrows  = DB_numRows ($result);
    if ($nrows > 0) {
        $retval = '<ul>' . LB;
        for ($i = 0; $i < $nrows; $i++) {
            $A = DB_fetchArray ($result);
            $retval .= '<li><a href="'
                . COM_buildUrl ($_CONF['site_url']
                . '/portal.php?what=link&item=' . $A['lid'])
                . '" title="' . $A['url'] . '">'
                . stripslashes($A['title']) . '</a>'
                . ' (' . $A['hits'] . ')</li>' . LB;
        }
        $retval .= '</ul>' . LB;
    }
    return $retval;
}

 
I left out the description for the sake of space as well as the "edit" link just because.

Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 06/11/02
Posts: 523
Thanks

I was actually asking for Redneck as we were discussing this over IM.

I appreciate your quick response Machinari

Status: offline

redneck

Forum User
Junior
Registered: 11/04/05
Posts: 24
What part of the code do I edit just to show the links, not the amount of hits. It is making my table to wide and pushing my page off to the left.

www.erazz.com

Redneck

Status: offline

machinari

Forum User
Full Member
Registered: 22/03/04
Posts: 1512
modified version here:
PHP Formatted Code

function phpblock_topTenLinks(){
    global $_TABLES, $_CONF;

    $result = DB_query ("SELECT lid,url,title,description,hits FROM {$_TABLES['links']} WHERE (hits > 0)" . COM_getPermSQL ('AND') . " ORDER BY hits DESC LIMIT 10");
    $nrows  = DB_numRows ($result);
    if ($nrows > 0) {
        $retval = '<ul>' . LB;
        for ($i = 0; $i < $nrows; $i++) {
            $A = DB_fetchArray ($result);
            $retval .= '<li><a href="'
                . COM_buildUrl ($_CONF['site_url']
                . '/portal.php?what=link&item=' . $A['lid'])
                . '" title="' . $A['url'] . '">'
                . stripslashes($A['title']) . '</a>'
                //. ' (' . $A['hits'] . ')'
                . '</li>' . LB;
        }
        $retval .= '</ul>' . LB;
    }
    return $retval;
}

 
just uncomment the obvious line to reintroduce "hits" if ever you want to do so.

Status: offline

redneck

Forum User
Junior
Registered: 11/04/05
Posts: 24
Thanks that worked great, now can I left justify the list? it is still too far to the right.

Redneck

mach

Anonymous
add style to your <li>, setting padding and margin to "0", for example: <li style="padding-left: 0; margin-left: 0;">

Status: offline

redneck

Forum User
Junior
Registered: 11/04/05
Posts: 24
That did not seem to work.

Status: offline

redneck

Forum User
Junior
Registered: 11/04/05
Posts: 24
Fixed it. It works great on the
    not the
  • .

    Thanks,
    Redneck

All times are EDT. The time is now 11:34 am.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content