Birthday Module / Block

To see it in action, visit www.lipstickgirls.co.uk

<?php

$monthnumber = date(n);
$monthstring = "%\\\"month\\\"\\;s\\:".strlen($monthnumber)."\\:\\\"".$monthnumber."%";

$sql = "SELECT u.uid, u.name, u.created, v.value FROM {users} u INNER JOIN {profile_values} v ON u.uid = v.uid WHERE v.fid = '16' and v.value LIKE '$monthstring'";

$birthdays = db_query($sql);

$users = db_num_rows($birthdays);
$num_bdays = 0;

if ($users > 0) {

for ($count = 1; $count <= $users; $count ++) {

$bdaydata = db_fetch_array($birthdays);

// new code to trap birthday = joined date here

$joinedday = date("j", $bdaydata['created']);
$joinedmonth = date("n", $bdaydata['created']);
$joinedyear = date("Y", $bdaydata['created']);

$joindate = "a:3:{s:5:\"month\";s:".strlen($joinedmonth);
$joindate .= ":\"".$joinedmonth."\";s:3:\"day\";s:";
$joindate .= strlen($joinedday).":\"".$joinedday."\";s:4:";
$joindate .= "\"year\";s:4:\"".$joinedyear."\";}";

if ($joindate != $bdaydata['value']) {

$num_bdays = $num_bdays + 1;

$bday_name[$count] = $bdaydata['name'];

$daystring = $bdaydata['value'];
$bdayarray = explode (";", $daystring);
$bdayday = explode (":", $bdayarray[3]);
$daystring = substr($bdayday[2], 1, strlen($bdayday[2])-2);
$daystring = strtotime($daystring." December 1979");
$bday_day[$count] = date(jS, $daystring);

$bday_uid[$count] = $bdaydata['uid'];

}
}
}

if ($num_bdays > 0) {
array_multisort($bday_day, SORT_ASC, SORT_NUMERIC, $bday_name, $bday_uid);
?>
<table width="100%" cellpadding=5 cols=2>
<?php
for ($output = 0; $output  < count($bday_name); $output++) {
if ($bday_day[$output] == $bday_day[$output-1]) {
$bday_day[$output] = " ";
}
echo "<tr><td width='25%'>".$bday_day[$output]."</td><td><a href='user/".$bday_uid[$output]."'>".$bday_name[$output]."</a></td></tr>\r\n";
}
?>
</table>
<?php

} else {

}
?>

Yes it's a little ugly, but that's because of the string format in which drupal stores dates :/ Had to put some other code in too to bypass the fact that if a user joins up and ignores the "profile_birthday", then it's set to their joined date, which makes them appear on the birthday block when they shouldn't.

To make this work for you, change the v.fid = '16' to whatever the fid is for your birthday field in profile.module.

I'll reply here as several people interested.

Basically, I am in development of both these modules. Countries is nearly finished, just need to add the settings form to add/remove countries and flags from database.

Birthdays module is more complicated. Unfortunately I am very busy at the moment so its been a bit slower, but I am still deciding how to store the dates so that I can make it all work great. Using the unix times doesn't work well for recurring events like birthdays, so I've tried storing the birthdays as day, month and year fields in a database table, but that brings other problems. I will look into it more and write a nice long comment when I have time asking you guys for ideas.

I'm not using the profiles module to store this info. I can see how it could be done by making the settings page point to the field name the user specifies for the country and DOB, but I think they work better as seperate modules. Also, the members module won't show the flags in the list table even if it is in the profile module. I'm kind of hacking my own members module to include the new modules myself. Any input into how I can hook it into the existing modules easily would be great so that I can keep it within the drupal framework and everyone else can use them easily.

Anyway, thanks for all the interest, I am getting it done ASAP as my site is waiting for it before I add all my users and everything else I want! You can post me any specific questions or suggestions here or directly.

Have a look at this http://drupal.org/project/birthdays

Think we are close :D