I have a solution. At your own risc!
First we have to add an extra column into the database using myphpadmin. We need to add this extra column, because we have to check if a comment has been checked or not.
so open your myphpadmin, go to SQL statements and copy paste the following line
ALTER TABLE `sys_cmts_profile` ADD cmt_confirmed INT default '0'
Now use DEANOS TOOLS to insert a PHP block anywhere you want .. i have mine on my homepage
and copy paste the code below:
$iProfileID = getID( $_GET['ID'] );
$sNick = getNickname($iId);
$oDb = new BxDolDb();
$sSQLQuery = "SELECT COUNT(*) FROM `sys_cmts_profile` WHERE `cmt_object_id` = $iProfileID AND `cmt_confirmed` = 0";
$result = mysql_query($sSQLQuery);
$num_rows = mysql_fetch_row($result);
if ( $num_rows[0] != 0 ) {
echo "
<form name='form' method='post'> You have $num_rows[0] new comments waiting for you!
<input type='submit' name='button1' value='Click here'/> To read
</form> ";
}
if(isset($_POST['button1'])){
$sSQLQuery = "UPDATE `sys_cmts_profile` SET `cmt_confirmed` = 1 WHERE `cmt_confirmed` = 0 AND `cmt_object_id` = $iProfileID";
$result = mysql_query($sSQLQuery);
header("Location: $sNick");
exit;
}//if isset
Code is AS IS .. NO SUPPORT & NO WARRANTYS
Have fun!