[ppiper]

Hello Norbs
I am having trouble implementing this, what was your code for that latest comments box.
thanks
Peter

[Norbs]

@ppiper
sorry for the late reply, just saw your question
first, I like to place all these add-on codes in a separate php file and callout the code with an "includes" call (this keeps my page HTML clean HTML. Here is the code (make sure you replace the path in line three according to your site

PHP Code:

<?php

define ('IN_COMMENTICS', '1');

require "/path/to/your/connect.php";





// Start of 'Recent Comments' **********************************************************************************************

$comments = mysql_query("SELECT * FROM `".$mysql_table_prefix."comments` WHERE is_approved = '1' ORDER BY dated DESC LIMIT 4");



while ($comment = mysql_fetch_array($comments)) {



    $page_query = mysql_query("SELECT * FROM `".$mysql_table_prefix."pages` WHERE id = '" . $comment["page_id"] . "'");

    $page = mysql_fetch_assoc($page_query);



    echo $comment["name"] . " <br />on <a href='" . $page["url"] . "'>" . $page["reference"] . "</a> <br />at " . date("g:ia (j-F)", strtotime($comment["dated"]));

    echo "<br />- - -<br />";

    

}

// End of 'Recent Comments' ************************************************************************************************









// Start of 'Most Commented' ***********************************************************************************************

$comments = mysql_query("SELECT page_id, COUNT(page_id) AS total FROM `".$mysql_table_prefix."comments` WHERE is_approved = '1' GROUP BY 'page_id' ORDER BY 'total' DESC LIMIT 3");



while ($comment = mysql_fetch_assoc($comments)) {



    $page_query = mysql_query("SELECT * FROM `".$mysql_table_prefix."pages` WHERE id = '" . $comment["page_id"] . "'");

    $page = mysql_fetch_assoc($page_query);

    

    echo "<p style='font-size:120%; color:#ff0000'>Most commented pages<br /></p>";

    echo "<p />";

    

    echo "<a href='" . $page["url"] . "'>" . $page["reference"] . "</a> (" . $comment["total"] . ")";

    echo "<br />";



}

// End of 'Most Commented' *************************************************************************************************





echo "<p />";





// Start of 'Top Posters' **************************************************************************************************

$names = mysql_query("SELECT name, COUNT(name) AS total FROM `".$mysql_table_prefix."comments` WHERE is_approved = '1' GROUP BY 'name' ORDER BY 'total' DESC LIMIT 2");



while ($name = mysql_fetch_assoc($names)) {

    

    echo $name["name"] . " (" . $name["total"] . ")";

    echo "<br />";



}

// End of 'Top Posters' ****************************************************************************************************

?>