is there a hack for the birthday on the main page?

Ok i want on the main page of the forums juste below :

Welcome to our new......

Happy Birthday to "thename"

where when i click on "thename" i go to a page where i can send him a private message...

Can someone have that?

i wasnt bothered to type it

Originally posted by wajones
I've installed an enhanced version of the birthday hack into vbPortal alpha5 release which will be out by this weekend. It displays both today's events and birthdays and uses it's own templates so you can customize them, I was working on this before, but thanks to Kier and Freddie it finally works.

I'm also porting an e-card script so that you will be able to send a birthday card to the birthday boy or girl... that will take a while longer. Possibly next week to get completed.

Thx Thx you very much
There will be a update script?

[Mr K]

Here is a slight modification of the code above. Basically all it does it checks to see if there are any birthdays ... if not it writes a message saying "No birthdays today"

PHP Code:

<? 
require (".forum/admin/config.php"); // add your details here
$db=mysql_connect($servername,$dbusername,$dbpassword) or die("Can't open connection to MySQL");
mysql_select_db($dbname) or die("Can't select database");

$today = date("m-d",time());
$birthdays = mysql_query("SELECT * FROM user WHERE birthday LIKE('%-$today')",$db) or die (mysql_error());

if ("$birthdays" != ""){
        echo "There are no birthdays today";
        } else {

while ($birthday = mysql_fetch_array($birthdays)) {
    $bd_user = $birthday[username];
    $bd_userid = $birthday[username];
    $datebits = explode("-", $birthday[birthday]);
    $bdage = date("Y") - $datebits[0];
    if ($bdage > 0) $age = "($bdage)";
    else $age = "";
    echo "<b>? </b><a href=\".forum/member.php?action=getinfo&userid=$bd_userid\">$bd_user's birthday</a> $age<br>"; //add your details here
    }
}
?>

simple ... Thanks for the original script !!!