Posted on: 10/15/02 06:28pm
By: MLimburg
PHP 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 ...
$tpl->set_var( 'toptenlinks', phpblock_toptenlinks() );
... will give you the ability to place that info pretty much anywhere!
Happy Hacking.
Posted on: 06/09/05 11:55pm
By: ScurvyDawg
Posted on: 06/09/05 11:57pm
By: redneck
Posted on: 06/10/05 02:41am
By: machinari
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.
Posted on: 06/10/05 11:14am
By: ScurvyDawg
Posted on: 06/10/05 04:40pm
By: redneck
Posted on: 06/10/05 05:17pm
By: machinari
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.
Posted on: 06/10/05 10:10pm
By: redneck
Posted on: 06/10/05 11:45pm
By: Anonymous (mach)
Posted on: 06/11/05 12:13pm
By: redneck
Posted on: 06/11/05 12:38pm
By: redneck