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?

... and if you want a version for a non-vB page, use this:

<?php
require ("./forums/admin/config.php");
$db = mysql_connect('$servername','dbusername','$dbpassword');
mysql_select_db('$dbname',$db);

$today = date("m-d",time());
$birthdays = mysql_query("SELECT * FROM user WHERE birthday LIKE('%-$today')",$db) or die (mysql_error());
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><font size=1><a href=\"./forums/member.php?action=getinfo&userid=$bd_userid\">$bd_user's birthday</a> $age</font></b><br>";
	}
?>

... remembering to change the path to the forums directory (shown in red).

Thx you very much Kier!

Kier.. Im gonna learn to play the fiddle so I can write you a song Thanks again!

Originally posted by Bane
Kier.. Im gonna learn to play the fiddle so I can write you a song Thanks again!

hehe

Hmmm...too damn fast...I haven't even looked at the code yet..hehehehe

Damn. I had a meeting and I so wanted to be first...

Isn't Kier two-headed?

Originally posted by PeF
Damn. I had a meeting and I so wanted to be first...

Isn't Kier two-headed?

lol
too late

I found a bug

It only lists one birthday -- I have 8 birthdays for today, and it is only listing the last one of the list from the calendar, not all 8

I have verified this on my smaller board too where there are only 5 birthdays -- it is only one person (the last on the list on the calendar.php)

Originally posted by Me2Be
I found a bug

It only lists one birthday -- I have 8 birthdays for today, and it is only listing the last one of the list from the calendar, not all 8

I have verified this on my smaller board too where there are only 5 birthdays -- it is only one person (the last on the list on the calendar.php)

Hum.........will ask kier ok?

That shouldn't be too bad. You just need a variable in there that will concatenate the formatted birthdays as it finds them. What if you change the $todaysbirthdays variable to $currentbirthday or something and then after the "eval" line, just make:

$todaysbirthdays .= "$currentbirthday, "

...or something like that? You'd just have to have to figure out the first or last time you went through the list and adjust so you don't have a comma in there at the beginning or the end.

Originally posted by Me2Be
I found a bug

It only lists one birthday -- I have 8 birthdays for today, and it is only listing the last one of the list from the calendar, not all 8

I have verified this on my smaller board too where there are only 5 birthdays -- it is only one person (the last on the list on the calendar.php)