I saw on the code sharing section, that someone made a new mail request....you created a new page and it pops up when you have a new mail....can anyone modify this to make the same thing happen to new friend requst? here is the script. thanks
function Pmessages(){
$User = getNickName($ID);
$SQLselect = mysql_query("SELECT Profiles.ID, Profiles.Headline, Profiles.NickName, sys_messages.New, sys_messages.Recipient
FROM Profiles
INNER JOIN sys_messages
ON Profiles.ID = sys_messages.Recipient
WHERE Profiles.NickName = '$User'
AND sys_messages.New = '1' ORDER BY sys_messages.New");
$alertText = '<span style="color:maroon;font-size:20px;text-shadow:1px 1px 3px #000;">';
$alertTextE = '</span>';
$row = mysql_num_rows($SQLselect);
if($row == 1):
echo MsgBox('<img src="templates/base/images/icons/mails.png"> ' . $alertText . $row . ' New Message' . $alertTextE);
elseif($row >= 2):
echo MsgBox('<img src="templates/base/images/icons/mails.png"> ' . $alertText . $row . ' New Messages' . $alertTextE);
else:
echo '';
endif;
}
//Ends uread messages
