Top 10 topics by views()

[pege]

Is there already a function for the top 10 topics by views (currently used on the stats page) that I could hack into the SSI.php?  If so, where?

Thanks

[Spaceman-Spiff]

it's not currently in SSI.php, but u can hack it yourself, just copy the source code from the stats page.. (Stats.php)

[adRIAmYCin]

Create this code as stat2.php and add this file into Source directory.

<?php
$statsphpver ="YaBB SE 1.4.1";
function display_stats2() {
global $txt, $color,$yytitle,$boardurl,$yyheaderdone,$settings,$months,$db_prefix,$username,$REMOTE_ADDR,$REQUEST_URI,$modSettings,$imagesdir,$mbname,$sourcedir,$totalt,$totalm,$messnum, $scripturl;
// Topic replies top 10
$topic_reply_result = mysql_query("SELECT {$db_prefix}topics.*,m.* FROM {$db_prefix}topics,{$db_prefix}messages as m, {$db_prefix}messages as mes WHERE (m.ID_MSG={$db_prefix}topics.ID_FIRST_MSG && mes.ID_MSG={$db_prefix}topics.ID_LAST_MSG) ORDER BY {$db_prefix}topics.numReplies DESC LIMIT 10");
while ($row_topic_reply = mysql_fetch_array($topic_reply_result))
{
  echo "<a href=\"index.php?board=$row_topic_reply[ID_BOARD];action=display;threadid=$row_topic_reply[ID_TOPIC];start=0\" target=\"_blank\">$row_topic_reply[subject]&nbsp;[$row_topic_reply[numReplies]]</a><br>";
}
EOT;
}
?>

And then insert this code in the page that you want to show top ten topic

<? { include_once "$sourcedir/Stats2.php"; display_stats2(); } ?>

[pege]

kewl guys...thanks.