Someone in the forum asked for this. And I though, nice challenge lets see if i can do it :-)
I managed to program it, however this needs modification in the database .. so At your own risc!
What will this program do? It will check if someone left a comment on your profile. If so, it will show the member how many comments, and a button to go directly to his profile.
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!
