Looking for Birthday Code

[JPDeni]

Okay. I think this will do what you want:

Code Select Expand

global $db_prefix, $scripturl;

$title = date('F') . ' Birthdays';
echo '
<div class="tborder" style="margin-bottom: 5px;">
  <div class="catbg2" style="padding: 4px; font-weight: bold;">';
echo $title;
echo '
  </div>
  <div class="windowbg" style="padding: 4px; ">';
      $month = date('m');
      $month_number = '-' . $month . '-';
      $query = db_query(
    "SELECT ID_MEMBER, memberName, birthdate
     FROM {$db_prefix}members
     WHERE birthdate LIKE '%$month_number%'
     AND birthdate NOT LIKE '0001-01-01'
     ORDER BY memberName", __FILE__, __LINE__);
  if(db_affected_rows() != 0)
  {
    $birthdays = array();
    $member = array();
    while ($row = mysql_fetch_assoc($query))
    {
       $day = substr($row['birthdate'],8,2);
       $birthdays[$row['memberName']] =  $day;
       $member[$row['memberName']] = $row['ID_MEMBER'];
    }
    asort($birthdays);
    foreach ($birthdays as $key => $value)
    {
      echo '<a class="normaltext" href="' . $scripturl . '?action=profile;u=' . $member[$key] . '">' . $key . '</a> (' . $value . '.' . $month . ')<br />';
   }
}
else
  echo 'No birthdays this month';
echo'  </div>
</div> ';

[JPDeni]

I did another version of this:

• The dates are in a table (see attached screenshot). I think it looks neater.
• Uses the title and formatting from the block. It wasn't lining up nicely with the other blocks on the side.
• Only shows birthdays for those who have logged into the forum within the past year.

Anyway, here's the code. I don't get any errors from it. YMMV. 

Code Select Expand

global $db_prefix, $scripturl;

$last_year = date('U') - (365 * 24 * 60 * 60);
$month = date('m');
$month_number = '-' . $month . '-';
$query = db_query(
    "SELECT ID_MEMBER, memberName, birthdate
     FROM {$db_prefix}members
     WHERE birthdate LIKE '%$month_number%'
     AND birthdate NOT LIKE '0001-01-01'
     AND lastLogin > '$last_year'
     ORDER BY memberName", __FILE__, __LINE__);

if(db_affected_rows() != 0)
{
  $birthdays = array();
  $member = array();
  while ($row = mysql_fetch_assoc($query))
  {
    $day = substr($row['birthdate'],8,2);
    $birthdays[$row['memberName']] =  $day;
    $member[$row['memberName']] = $row['ID_MEMBER'];
  }
  asort($birthdays);
  echo '<table>';
  $yesterday = 0;
  foreach ($birthdays as $key => $value)
  {
    if ($value <> $yesterday)
    {
      if ($yesterday > 0)
        echo '</td></tr>';
      echo '<tr valign="top"><td>' , $value , '</td><td>';
    }
    echo '<a class="normaltext" href="' . $scripturl . '?action=profile;u=' . $member[$key] . '">' . $key . '</a><br />';
    $yesterday = $value;
  }
  echo '</td></tr></table>';
}
else
  echo 'No birthdays this month';

[RoarinRow]

That's cool!  :up:

[Gargoyle]

Very nice...

[Rocket]

Awesome, is there a way to limit this to a particular member group or multiple member groups?

[rebelrose]

Can we add an image to this, like on top of the list?

[JPDeni]

Rocket, yeah, I'm sure it can be done. Seems like a lot of work for just a list of birthdays. Don't all your members have birthdays?

RebelRose, it would be easy enough to put an image before the list starts. Just put your image tag before

Code Select Expand

echo '<table>';

[rebelrose]

What code would I use exactly, sorry JPDeni, not great with code but I am trying.

[JPDeni]

Sorry.

Hmmmm. I guess it depends on where your image is. If you always want to use the same image, no matter what theme the user has active, just use

Code Select Expand

echo '<img src="http://yourdomain.com/url/to/image.gif">';

If the image is in the theme image directories

Code Select Expand

echo '<img src="', $settings['images_url'], '/image.gif" alt="Happy birthday!" />';
With this second one, you'll also want to change the first line of the code to

Code Select Expand

global $db_prefix, $scripturl, $settings;

[rebelrose]

Sorry.

Hmmmm. I guess it depends on where your image is. If you always want to use the same image, no matter what theme the user has active, just use

Code Select Expand

echo '<img src="http://yourdomain.com/url/to/image.gif">';

If the image is in the theme image directories

Code Select Expand

echo '<img src="', $settings['images_url'], '/image.gif" alt="Happy birthday!" />';
With this second one, you'll also want to change the first line of the code to

Code Select Expand

global $db_prefix, $scripturl, $settings;

Thank you very much.