collapse

* Simple Portal Archived Forum

This is an Archive Forum.

The content in this forum may be out-of-date or have been superseded by newer information, and links in forum pages to other sites may not work.
This forum contains archives for future reference.

Visit our thread at Simple Machines Forum for current support.

SMF 2.1 users: EhPortal is a ported version of Simple Portal specifically designed for the SMF 2.1 branch.
Please visit web-develop.ca to download EhPortal and for its support.

* User Info

 
 
Welcome, Guest. Please login or register.

* Who's Online

  • Dot Guests: 334
  • Dot Hidden: 0
  • Dot Users: 0

There aren't any users online.

* Shoutbox

Refresh History
  • Shoutbox is not for support!
  • {OCS}MasterSeal: Yup, Still adore SP
    April 21, 2019, 07:08:06 PM
  • {OCS}MasterSeal: STILL love SP :)
    November 24, 2018, 05:05:50 AM
  • ♦ Ninja ZX-10RR ♦: <3 aegersz
    September 13, 2018, 03:36:09 PM
  • aegersz: I STILL <3 LOVE SimplePortal
    September 13, 2018, 07:11:39 AM
  • aegersz: o LOVE you guys - Simple Portal rocks !
    May 09, 2018, 05:18:59 AM
  • Chen Zhen: our apologies for the site being down.. please read server issues topic
    March 22, 2018, 05:32:38 AM
  • {OCS}MasterSeal: LOL PLEASE forget I just posted that. I found the answer in my own dang post back in 2015. lol sorry!
    July 04, 2017, 10:47:55 PM
  • {OCS}MasterSeal: I know this SB isnt' for support, but I just have a general question. Who would I contact to find out where SP stores its block info? Is it DB driven or files? I searched the site but came up with nothing. probably my fault any insight is appreciated.
    July 04, 2017, 10:43:36 PM
  • ♦ Ninja ZX-10RR ♦: Excuse me but what does Simpleportal have to deal with that?
    February 05, 2017, 08:21:14 PM
  • WhiteEagle: of course IMHO that site appears to be dead :(
    February 04, 2017, 01:08:05 PM
  • WhiteEagle: If I can get that, then I'll use it for that site...
    February 04, 2017, 01:07:35 PM
  • WhiteEagle: decided to not use SMF for any projects, unless I can get a copy of the premium version of the fanfiction archive plugin
    February 04, 2017, 01:06:54 PM
  • expertdecisions: cloudflare
    January 28, 2017, 08:01:47 AM
  • aegersz: SM release 2.0.13 !
    January 12, 2017, 06:00:13 AM
  • raffo: Tks Emanuele, even if I didn't understand the fix :D
    November 07, 2016, 02:01:20 AM
  • emanuele: [link]
    November 01, 2016, 12:43:50 PM
  • emanuele: raffo: the English support board is a good place. ;)
    November 01, 2016, 12:43:38 PM
  • raffo: Where can I find the fix for the shoutbox?
    November 01, 2016, 05:06:09 AM
  • {OCS}MasterSeal: To the SP team, I make a point to come here and thank you as much as possible for your work.  so again, THANK YOU!
    October 28, 2016, 10:38:05 AM
  • emanuele: That's indeed funny, the limit is present only in the patch and not the full install.
    October 22, 2016, 06:14:58 PM

* Recent Posts

Adding Forums Button to Nav bar by jirapon
[August 01, 2019, 09:07:12 AM]


Re: Board Icons by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 04:03:41 PM]


MOVED: Czech translation???? by ♦ Ninja ZX-10RR ♦
[July 30, 2019, 03:04:51 PM]


Board Icons by jirapon
[July 30, 2019, 07:28:44 AM]


Re: Thankyou Simpleportal, by ♦ Ninja ZX-10RR ♦
[July 29, 2019, 09:41:29 AM]

Installation errors? Mod incompatibilities? Upgrade problems? Make your way over to the Install and Upgrade Support board for all your solutions!

Author Topic: Show Today's Birthday Block  (Read 18699 times)

0 Members and 1 Guest are viewing this topic.

Offline joeylc

  • Semi Newbie
  • *
  • Posts: 6
  • Gender: Male
    • New Life Games LLC
Show Today's Birthday Block
« on: October 10, 2008, 08:55:32 PM »
Is there anyway way to add a Today's Birthdays to a block?  8)

One which has a link to the users profile and shows a cake? something like this.

(if no Birthdays it just says) No Birthday's Today with a grayed out cake


Thanks Joeylc
I Have gone to find myself, and if I get back before I return, keep me here!  ?-?-?

Offline Aw06

  • Full Member
  • ***
  • Posts: 238
  • Gender: Male
    • www.ShopinJA.com
  • SMF Version: 1.1.13
  • SP Version: 2.3.2
Re: Show Today's Birthday Block
« Reply #1 on: October 10, 2008, 09:07:46 PM »
Nide Idea .. also calender events

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Show Today's Birthday Block
« Reply #2 on: October 10, 2008, 11:39:13 PM »
Which version of SMF are you using?
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Show Today's Birthday Block
« Reply #3 on: October 10, 2008, 11:41:38 PM »
Add this code into a new 'PHP' block.

For SMF 2 Beta:
Code: [Select]
global $scripturl, $modSettings, $user_info;

$eventOptions = array(
'include_birthdays' => true,
'num_days_shown' => 1,
);
$return = cache_quick_get('calendar_index_offset_' . ($user_info['time_offset'] + $modSettings['time_offset']), 'Subs-Calendar.php', 'cache_getRecentEvents', array($eventOptions));

foreach ($return['calendar_birthdays'] as $member)
echo '
<a href="', $scripturl, '?action=profile;u=', $member['id'], '">' . $member['name'] . (isset($member['age']) ? ' (' . $member['age'] . ')' : '') . '</a>' . (!$member['is_last'] ? ', ' : '');

For SMF 1.1.x:
Code: [Select]
global $context, $scripturl;

if (!smf_loadCalendarInfo() || empty($context['calendar_birthdays']))
return array();

foreach ($context['calendar_birthdays'] as $member)
echo '
<a href="', $scripturl, '?action=profile;u=', $member['id'], '">' . $member['name'] . (isset($member['age']) ? ' (' . $member['age'] . ')' : '') . '</a>' . (!$member['is_last'] ? ', ' : '');
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline ccbtimewiz

  • Hero Member
  • *****
  • Posts: 2185
  • Gender: Male
  • $("div.content:dd").hide();
  • SMF Version: None
  • SP Version: None
  • Elkarte Version: None
  • EhPortal Version: None
Re: Show Today's Birthday Block
« Reply #4 on: October 11, 2008, 12:56:36 AM »
Damn it L, you beat me to it!

Offline joeylc

  • Semi Newbie
  • *
  • Posts: 6
  • Gender: Male
    • New Life Games LLC
Re: Show Today's Birthday Block
« Reply #5 on: October 11, 2008, 06:12:32 PM »
hmmmm this is what we got with SMF 1.1.6

Code: [Select]
Fatal error: Call to undefined function smf_loadCalendarInfo() in /home/newlife/public_html/nlg/Sources/SPortal.php(1586) : eval()'d code on line 3
I Have gone to find myself, and if I get back before I return, keep me here!  ?-?-?

Offline Aw06

  • Full Member
  • ***
  • Posts: 238
  • Gender: Male
    • www.ShopinJA.com
  • SMF Version: 1.1.13
  • SP Version: 2.3.2
Re: Show Today's Birthday Block
« Reply #6 on: October 12, 2008, 08:28:03 AM »
hmmmm this is what we got with SMF 1.1.6

Code: [Select]
Fatal error: Call to undefined function smf_loadCalendarInfo() in /home/newlife/public_html/nlg/Sources/SPortal.php(1586) : eval()'d code on line 3

Getting the same error, except mine is on line 1584

Code: [Select]
Fatal error: Call to undefined function: smf_loadcalendarinfo() in /home/adrianw/public_html/forum/Sources/SPortal.php(1584) : eval()'d code on line 3

Offline joeylc

  • Semi Newbie
  • *
  • Posts: 6
  • Gender: Male
    • New Life Games LLC
Re: Show Today's Birthday Block
« Reply #7 on: October 15, 2008, 06:51:33 PM »
 :) any news on this ???
I Have gone to find myself, and if I get back before I return, keep me here!  ?-?-?

Offline Nathaniel

  • Comrade
  • *
  • Posts: 5203
  • Gender: Male
    • Verbtest.com
  • SMF Version: 2 RC4
  • SP Version: 2.3.3
Re: Show Today's Birthday Block
« Reply #8 on: October 16, 2008, 01:53:44 AM »
Try the code below:
Code: [Select]
global $context, $scripturl, $boarddir;

require_once($boarddir.'/SSI.php');

if (!smf_loadCalendarInfo() || empty($context['calendar_birthdays']))
return array();

foreach ($context['calendar_birthdays'] as $member)
echo '
<a href="', $scripturl, '?action=profile;u=', $member['id'], '">' . $member['name'] . (isset($member['age']) ? ' (' . $member['age'] . ')' : '') . '</a>' . (!$member['is_last'] ? ', ' : '');
SMF Friend (Former Support Specialist) | SimplePortal DeveloperMy SMF Mods | SimplePortal"Quis custodiet ipsos custodes?" - Who will Guard the Guards?Please don't send me ANY support related PMs. I will just delete them.

Offline Aw06

  • Full Member
  • ***
  • Posts: 238
  • Gender: Male
    • www.ShopinJA.com
  • SMF Version: 1.1.13
  • SP Version: 2.3.2
Re: Show Today's Birthday Block
« Reply #9 on: October 16, 2008, 12:53:45 PM »
Kool thanks, that works  ;D

ONly problem is thou, can you make it that it only displays when there is infact a birthday, casue the way it is now it shows upcoming birthdays which may get confusing if a user doesnt know birthdays are in bold

or split it into

Upcoming Birthdays
Name Name Name Name

Today's Birthdays
Name Name Name

Offline Aw06

  • Full Member
  • ***
  • Posts: 238
  • Gender: Male
    • www.ShopinJA.com
  • SMF Version: 1.1.13
  • SP Version: 2.3.2
Re: Show Today's Birthday Block
« Reply #10 on: October 23, 2008, 09:24:42 AM »
OK big problem ... in the birthday block, it does not show people birthday in bold when its actually their birthday  :bandaged:

Offline ???1031

  • ... feel not as a dev at the moment ...
  • Comrade
  • *
  • Posts: 789
  • Gender: Male
  • Overworked <<
  • SMF Version: None
  • SP Version: None
Re: Show Today's Birthday Block
« Reply #11 on: October 24, 2008, 01:20:21 AM »
Code: [Select]
global $context, $scripturl, $boarddir;

require_once($boarddir.'/SSI.php');

if (!smf_loadCalendarInfo() || empty($context['calendar_birthdays'])) {
echo 'No Upcoming Birthdays.';
return array();
}

//The problem is to detect todays birthday on all versions, but smf give some informations about this since smf 1.1
$context['todays_birthdays'] = array();
$context['future_birthdays'] = array();
foreach ($context['calendar_birthdays'] as $member) {
if($member['is_today'])
$context['todays_birthdays'] = '<a href="', $scripturl, '?action=profile;u=', $member['id'], '">' . $member['name'] . (isset($member['age']) ? ' (' . $member['age'] . ')' : '') . '</a>';
else
$context['future_birthdays'] = '<a href="', $scripturl, '?action=profile;u=', $member['id'], '">' . $member['name'] . (isset($member['age']) ? ' (' . $member['age'] . ')' : '') . '</a>';
}

//Output it :)
if(!empty($context['todays_birthdays']))
echo '
Today\'s Birthdays:<br />'.
implode(',', $context['todays_birthdays']).'<br /><br />';

if(!empty($context['future_birthdays']))
echo '
Upcoming Birthdays:<br />'.
implode(',', $context['future_birthdays']).'<br />';

Bye
DIN1031
Again... I'm having time problems...Normal Monday to Friday I'm at office from 6:00-16:00 (On my local time ;P).

Offline Aw06

  • Full Member
  • ***
  • Posts: 238
  • Gender: Male
    • www.ShopinJA.com
  • SMF Version: 1.1.13
  • SP Version: 2.3.2
Re: Show Today's Birthday Block
« Reply #12 on: October 24, 2008, 09:43:46 AM »
Getting error now

Code: [Select]
Parse error: syntax error, unexpected ',' in /home/adrianw/public_html/forum/Sources/SPortal.php(1584) : eval()'d code on line 15

Offline ibm450

  • Semi Newbie
  • *
  • Posts: 49
  • Gender: Male
    • yarrie health & safety
Re: Show Today's Birthday Block
« Reply #13 on: October 25, 2008, 09:02:53 AM »
Getting error now

Code: [Select]
Parse error: syntax error, unexpected ',' in /home/adrianw/public_html/forum/Sources/SPortal.php(1584) : eval()'d code on line 15



same error

Offline ???1031

  • ... feel not as a dev at the moment ...
  • Comrade
  • *
  • Posts: 789
  • Gender: Male
  • Overworked <<
  • SMF Version: None
  • SP Version: None
Re: Show Today's Birthday Block
« Reply #14 on: October 28, 2008, 05:35:14 AM »
Strange okay try this

Code: [Select]
global $context, $scripturl, $boarddir;

require_once($boarddir.'/SSI.php');

if (!smf_loadCalendarInfo() || empty($context['calendar_birthdays'])) {
echo 'No Upcoming Birthdays.';
return array();
}

//The problem is to detect todays birthday on all versions, but smf give some informations about this since smf 1.1
$context['todays_birthdays'] = array();
$context['future_birthdays'] = array();
foreach ($context['calendar_birthdays'] as $member) {
if($member['is_today'])
$context['todays_birthdays'] = '<a href="'.$scripturl.'?action=profile;u='.$member['id'].'">'.$member['name'].(isset($member['age']) ? ' (' . $member['age'].')' : '').'</a>';
else
$context['future_birthdays'] = '<a href="'.$scripturl.'?action=profile;u='.$member['id'].'">'.$member['name'].(isset($member['age']) ? ' (' . $member['age'].')' : '').'</a>';
}

//Output it :)
if(!empty($context['todays_birthdays']))
echo '
Today\'s Birthdays:<br />'.
implode(', ', $context['todays_birthdays']).'<br /><br />';

if(!empty($context['future_birthdays']))
echo '
Upcoming Birthdays:<br />'.
implode(', ', $context['future_birthdays']).'<br />';

(I should test my php codes *drop*).

Bye
DIN1031
Again... I'm having time problems...Normal Monday to Friday I'm at office from 6:00-16:00 (On my local time ;P).

Offline ibm450

  • Semi Newbie
  • *
  • Posts: 49
  • Gender: Male
    • yarrie health & safety
Re: Show Today's Birthday Block
« Reply #15 on: October 28, 2008, 07:48:33 AM »
not working, put in dummy dates, not showing

Offline ibm450

  • Semi Newbie
  • *
  • Posts: 49
  • Gender: Male
    • yarrie health & safety
Re: Show Today's Birthday Block
« Reply #16 on: October 28, 2008, 08:28:52 AM »
cant remember where i got this from as i closed of the page i was reading but this works, also grabs members avartar

Code: [Select]
$current_date = getdate();
$month_number = sprintf("%02d", $current_date['mon']);

$justify = 'left'; // Valid options: 'left', 'center', or 'right'
$limit = 0; // Integer value for length of list

$avatar_on = true; // Use avatar in output: true or false
$avatar_height = '45'; // Set height of avatar
$avatar_width = '45'; // Set width of avatar
$blank_image = 'http://www.abcdefghijklmnop/images/blank_1x1.gif'; // URL to where you placed the blank avatar file...

$display_age = true; // Display member's age: true or false

// Warranty void if edited past this line!  ;)

if(!empty($_GET['justify'])) $justify = $_GET['justify'];
if(!empty($_GET['limit'])) $limit = $_GET['limit'];
if(!empty($_GET['month'])) $month_number = $_GET['month'];
if(!empty($_GET['day'])) $current_date['mday'] = $_GET['day'];

if($limit == 0) $count = -1;

global $db_prefix, $scripturl;

    $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 birthdate ASC", __FILE__, __LINE__);

while (($row = mysql_fetch_array($query)) && ($count < $limit))
{
if($limit != 0) $count++;

if(empty($row['birthdate'])) return;

$dob_year = strtok($row['birthdate'], '-');
$dob_month = strtok('-');
$dob_day = strtok('-');
$age = sprintf("%2d", ($current_date['year'] - $dob_year));

if($current_date['mday'] <= $dob_day)
{
if($current_date['mday'] == $dob_day)
{
$class = 'highlight';
}
else
{
$class = '';
}

$current_ID = $row['ID_MEMBER'];

$avatar = '';

if($avatar_on) // query to retrieve member's avatar # in attachment directory; bypass if avatar_on = false
{

$avatar = '<img src="' . $blank_image . '" height="' . $avatar_height . '" width=" '. $avatar_width . '" border="0" />';

$query2 = db_query(
"SELECT ID_ATTACH
FROM {$db_prefix}attachments
WHERE ID_MEMBER = '$current_ID'", __FILE__, __LINE__);

$result = mysql_fetch_array($query2);

if(!empty($result['ID_ATTACH']))
{
$avatar = '<img src="' . $scripturl . '?action=dlattach;attach=' . $result['ID_ATTACH'] .
';type=avatar" height="' . $avatar_height . '" width=" '. $avatar_width . '" border="0" />';
}
else
{
$query3 = db_query(
"SELECT avatar
FROM {$db_prefix}members
WHERE ID_MEMBER = '$current_ID'", __FILE__, __LINE__);

$result = mysql_fetch_array($query3);

if(!empty($result['avatar']))
{
$avatar = '<img src="' . $modSettings['avatar_url'] . '/' . $result['avatar'] . '" height="' .
$avatar_height . '" width=" '. $avatar_width . '" border="0" />';
}
}
}

$link = '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">';

if($display_age)
{
$age = ' (' . $age . ') ';
}
else
{
$age = ' ';
}

if(strtolower($justify) == 'left')
{
echo'<div class="smalltext" align="left"><span class="'.$class.'">';
echo $link . $avatar . '</a>' . $age . $link . $row['memberName'] . '</a>';
echo '</span></div>';
}
elseif(strtolower($justify) == 'right')
{
echo'<div class="smalltext" align="right"><span class="'.$class.'">';
echo $link . $row['memberName'] . '</a>';
echo $age . $link . $avatar . '</a></span></div>';
}
elseif(strtolower($justify) == 'center')
{
echo'<div class="smalltext" align="center"><span class="'.$class.'">';
echo $link . $avatar . '</a> ' . $link . $row['memberName'] . '</a>';
echo $age . '</span></div>';
}
else
{
echo '<b>Invalid justification specified: ("'.$justify.'")</b><br>';
echo 'Use "left", "center", or "right" for script.<hr>';
die();
}
}
}

but it shouldnt be this complex as all the codes are within your ssi, but it dosnt grab appropiate queries unless it points in the root directory of where your ssi is. i mean you can run your ssi_example at any given time through your browser and it lists / displays / runs all available queries for your smf  :ill:

Offline Burke Knight

  • Sr. Member
  • ****
  • Posts: 394
  • Gender: Male
  • I tell it how I see it. Don't like it? Hit Alt+F4
    • BurkeKnight Enterprises
  • SMF Version: None
  • SP Version: None
  • Elkarte Version: None
Re: Show Today's Birthday Block
« Reply #17 on: October 28, 2008, 09:46:54 AM »
ibm450,

Thanks for that. It's great.
Just wish it did something for when there are no birthdays for the day.
As a quick fix, I just did the block title as:

Birthdays: (Blank=None)

Hey, it works....LOL

Offline Aw06

  • Full Member
  • ***
  • Posts: 238
  • Gender: Male
    • www.ShopinJA.com
  • SMF Version: 1.1.13
  • SP Version: 2.3.2
Re: Show Today's Birthday Block
« Reply #18 on: October 28, 2008, 11:11:19 AM »
ibm450,

Thanks for that. It's great.
Just wish it did something for when there are no birthdays for the day.
As a quick fix, I just did the block title as:

Birthdays: (Blank=None)

Hey, it works....LOL

Will you be able to constantly edit this when necessary ??
« Last Edit: October 28, 2008, 11:37:41 AM by Aw06 »

Offline Burke Knight

  • Sr. Member
  • ****
  • Posts: 394
  • Gender: Male
  • I tell it how I see it. Don't like it? Hit Alt+F4
    • BurkeKnight Enterprises
  • SMF Version: None
  • SP Version: None
  • Elkarte Version: None
Re: Show Today's Birthday Block
« Reply #19 on: October 28, 2008, 04:46:26 PM »
Why edit it? If there are no birthdays, it tells them in the title.
If there are, then why pay attention to the title, when the block shows a birthday? ;)

Offline Aw06

  • Full Member
  • ***
  • Posts: 238
  • Gender: Male
    • www.ShopinJA.com
  • SMF Version: 1.1.13
  • SP Version: 2.3.2
Re: Show Today's Birthday Block
« Reply #20 on: October 28, 2008, 04:50:18 PM »
Why edit it? If there are no birthdays, it tells them in the title.
If there are, then why pay attention to the title, when the block shows a birthday? ;)

lol, ok kool, i get what your sayinng  :headphones:

Offline CvH

  • Newbie
  • Posts: 4
Re: Show Today's Birthday Block
« Reply #21 on: October 28, 2008, 07:13:47 PM »
I´ve tested all the posted code and only the LHVWB code works.

the others gave me
Code: [Select]
Fatal error: Call to undefined function db_query() in /htdocs/Sources/SPortal2.php(1609) : eval()'d code on line 25perhaps because i´ve use SMF 2.0b4.

I´ve got an working pice of code from my TinyPortal phpbox. But it wont work at my 2.0b4.
My coding skills are to low to see the problem ... hope someone can fit it or port it to SMF 2.0b4.

Code: [Select]
global $db_prefix, $scripturl;

//number of days before birthday is shown
$number_of_days = 30;

$last_year = date('U') - (365 * 24 * 60 * 60);

$low_date = strftime('%Y-%m-%d', forum_time(false) - 24 * 3600);
$high_date = strftime('%Y-%m-%d', forum_time(false) + $number_of_days * 24 * 3600);

if (substr($low_date, 0, 4) != substr($high_date, 0, 4))
  $allyear_part = "birthdate BETWEEN '0004" . substr($low_date, 4) . "' AND '0004-12-31'
                   OR birthdate BETWEEN '0004-01-01' AND '0004" . substr($high_date, 4) . "'";
else
  $allyear_part = "birthdate BETWEEN '0004" . substr($low_date, 4) . "' AND '0004" . substr($high_date, 4) . "'";

$year_low = (int) substr($low_date, 0, 4);
$year_high = (int) substr($high_date, 0, 4);

$query= db_query("
                           SELECT ID_MEMBER, realName, YEAR(birthdate) AS birthYear, birthdate
                           FROM {$db_prefix}members
                           WHERE YEAR(birthdate) != '0001'
                           AND ($allyear_part
                           OR DATE_FORMAT(birthdate, '{$year_low}-%m-%d') BETWEEN '$low_date' AND '$high_date'" . ($year_low == $year_high ? '' : "
                           OR DATE_FORMAT(birthdate, '{$year_high}-%m-%d') BETWEEN '$low_date' AND '$high_date'") . ")
                           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);
    $month = substr($row['birthdate'],5,2);
    $birthdays[$row['realName']] =  $month . $day;
    $member[$row['realName']] =  $row['ID_MEMBER'];
  }
  echo '<table>';
  asort($birthdays);
  $yesterday = 0;
  foreach ($birthdays as $key => $value)
  {
    if ($value <> $yesterday)
    {
      if (substr($value,0,2) == date("m"))
        $showdate = date("M") . ' ' . substr($value,2,2);
      else
        $showdate = date("M",time() + ($number_of_days * 24 * 3600)) . ' ' .  substr($value,2,2);
      if ($yesterday > 0)
        echo '</td></tr>';
      echo '<tr valign="top"><td>' , $showdate , '</td><td>';
    }
    echo '<a class="normaltext" href="' . $scripturl . '?action=profile;u=' . $member[$key] . '">' . htmlspecialchars_decode($key) . '</a><br />';
    $yesterday = $value;
  }
  echo '</td></tr></table>';
}
else
  echo 'No birthdays in the next ' . $number_of_days . 'days';

Offline ???1031

  • ... feel not as a dev at the moment ...
  • Comrade
  • *
  • Posts: 789
  • Gender: Male
  • Overworked <<
  • SMF Version: None
  • SP Version: None
Re: Show Today's Birthday Block
« Reply #22 on: October 29, 2008, 08:02:31 AM »
Code: [Select]
global $context, $scripturl, $boarddir, $txt;
global $db_prefix, $scripturl, $modSettings;

require_once($boarddir.'/SSI.php');

$current_date = getdate();
$month_number = sprintf("%02d", $current_date['mon']);

$justify = 'left'; // Valid options: 'left', 'center', or 'right'
$limit = 0; // Integer value for length of list

$avatar_on = true; // Use avatar in output: true or false
$avatar_height = '45'; // Set height of avatar
$avatar_width = '45'; // Set width of avatar
$blank_image = 'http://www.abcdefghijklmnop/images/blank_1x1.gif'; // URL to where you placed the blank avatar file...

$display_age = true; // Display member's age: true or false

// Warranty void if edited past this line!  ;)

if(!empty($_GET['justify']))
$justify = $_GET['justify'];
if(!empty($_GET['limit']))
$limit = $_GET['limit'];
if(!empty($_GET['month']))
$month_number = $_GET['month'];
if(!empty($_GET['day']))
$current_date['mday'] = $_GET['day'];

if($limit == 0)
$count = -1;

$query = db_query(
"SELECT ID_MEMBER, memberName, birthdate
FROM {$db_prefix}members
WHERE birthdate LIKE '%-%{$month_number}%-%'
AND birthdate != '0001-01-01' AND birthdate != '0000-00-00'
ORDER BY birthdate ASC", __FILE__, __LINE__);

while (($row = mysql_fetch_array($query)) && ($count < $limit))
{
if($limit != 0) $count++;

if(empty($row['birthdate'])) return;

$dob_year = strtok($row['birthdate'], '-');
$dob_month = strtok('-');
$dob_day = strtok('-');
$age = sprintf("%2d", ($current_date['year'] - $dob_year));

if($current_date['mday'] <= $dob_day)
{
if($current_date['mday'] == $dob_day)
{
$class = 'highlight';
}
else
{
$class = '';
}

$current_ID = $row['ID_MEMBER'];

$avatar = '';

if($avatar_on) // query to retrieve member's avatar # in attachment directory; bypass if avatar_on = false
{

$avatar = '<img src="' . $blank_image . '" height="' . $avatar_height . '" width=" '. $avatar_width . '" border="0" />';

$query2 = db_query(
"SELECT ID_ATTACH
FROM {$db_prefix}attachments
WHERE ID_MEMBER = '$current_ID'", __FILE__, __LINE__);

$result = mysql_fetch_array($query2);

if(!empty($result['ID_ATTACH']))
{
$avatar = '<img src="' . $scripturl . '?action=dlattach;attach=' . $result['ID_ATTACH'] .
';type=avatar" height="' . $avatar_height . '" width=" '. $avatar_width . '" border="0" />';
}
else
{
$query3 = db_query(
"SELECT avatar
FROM {$db_prefix}members
WHERE ID_MEMBER = '$current_ID'", __FILE__, __LINE__);

$result = mysql_fetch_array($query3);

if(!empty($result['avatar']))
{
$avatar = '<img src="' . $modSettings['avatar_url'] . '/' . $result['avatar'] . '" height="' .
$avatar_height . '" width=" '. $avatar_width . '" border="0" />';
}
}
}

$link = '<a href="' . $scripturl . '?action=profile;u=' . $row['ID_MEMBER'] . '">';

if($display_age)
{
$age = ' (' . $age . ') ';
}
else
{
$age = ' ';
}

if(strtolower($justify) == 'left')
{
echo'<div class="smalltext" align="left"><span class="'.$class.'">';
echo $link . $avatar . '</a>' . $age . $link . $row['memberName'] . '</a>';
echo '</span></div>';
}
elseif(strtolower($justify) == 'right')
{
echo'<div class="smalltext" align="right"><span class="'.$class.'">';
echo $link . $row['memberName'] . '</a>';
echo $age . $link . $avatar . '</a></span></div>';
}
elseif(strtolower($justify) == 'center')
{
echo'<div class="smalltext" align="center"><span class="'.$class.'">';
echo $link . $avatar . '</a> ' . $link . $row['memberName'] . '</a>';
echo $age . '</span></div>';
}
else
{
echo '<b>Invalid justification specified: ("'.$justify.'")</b><br>';
echo 'Use "left", "center", or "right" for script.<hr>';
die();
}
}
}

This should normal work ;).

Code: [Select]
global $context, $scripturl, $boarddir, $txt;
global $db_prefix;

require_once($boarddir.'/SSI.php');

//number of days before birthday is shown
$number_of_days = 30;

$last_year = date('U') - (365 * 24 * 60 * 60);

$low_date = strftime('%Y-%m-%d', forum_time(false) - 24 * 3600);
$high_date = strftime('%Y-%m-%d', forum_time(false) + $number_of_days * 24 * 3600);

if (substr($low_date, 0, 4) != substr($high_date, 0, 4))
  $allyear_part = "birthdate BETWEEN '0004" . substr($low_date, 4) . "' AND '0004-12-31'
                   OR birthdate BETWEEN '0004-01-01' AND '0004" . substr($high_date, 4) . "'";
else
  $allyear_part = "birthdate BETWEEN '0004" . substr($low_date, 4) . "' AND '0004" . substr($high_date, 4) . "'";

$year_low = (int) substr($low_date, 0, 4);
$year_high = (int) substr($high_date, 0, 4);

$query= db_query("
                           SELECT ID_MEMBER, realName, YEAR(birthdate) AS birthYear, birthdate
                           FROM {$db_prefix}members
                           WHERE YEAR(birthdate) != '0001'
                           AND ({$allyear_part}
                           OR DATE_FORMAT(birthdate, '{$year_low}-%m-%d') BETWEEN '$low_date' AND '$high_date'" . ($year_low == $year_high ? '' : "
                           OR DATE_FORMAT(birthdate, '{$year_high}-%m-%d') BETWEEN '$low_date' AND '$high_date'") . ")
                           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);
    $month = substr($row['birthdate'],5,2);
    $birthdays[$row['realName']] =  $month . $day;
    $member[$row['realName']] =  $row['ID_MEMBER'];
  }
  echo '<table>';
  asort($birthdays);
  $yesterday = 0;
  foreach ($birthdays as $key => $value)
  {
    if ($value <> $yesterday)
    {
      if (substr($value,0,2) == date("m"))
        $showdate = date("M") . ' ' . substr($value,2,2);
      else
        $showdate = date("M",time() + ($number_of_days * 24 * 3600)) . ' ' .  substr($value,2,2);
      if ($yesterday > 0)
        echo '</td></tr>';
      echo '<tr valign="top"><td>' , $showdate , '</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 in the next ' . $number_of_days . 'days';

Work now, too.

Bye
DIN1031
« Last Edit: October 29, 2008, 08:52:06 AM by ???1031 »
Again... I'm having time problems...Normal Monday to Friday I'm at office from 6:00-16:00 (On my local time ;P).

Offline CvH

  • Newbie
  • Posts: 4
Re: Show Today's Birthday Block
« Reply #23 on: November 09, 2008, 06:30:32 PM »
@ ???1031
First give me on SMF 2.0b4
Fatal error: Call to undefined function db_query() in /var/www/htdocs/Sources/SPortal2.php(1609) : eval()'d code on line 33

Second
Fatal error: Call to undefined function db_query() in /var/www/htdocs/Sources/SPortal2.php(1609) : eval()'d code on line 23

Offline ???1031

  • ... feel not as a dev at the moment ...
  • Comrade
  • *
  • Posts: 789
  • Gender: Male
  • Overworked <<
  • SMF Version: None
  • SP Version: None
Re: Show Today's Birthday Block
« Reply #24 on: November 10, 2008, 12:59:10 AM »
@ ???1031
First give me on SMF 2.0b4
Fatal error: Call to undefined function db_query() in /var/www/htdocs/Sources/SPortal2.php(1609) : eval()'d code on line 33

Second
Fatal error: Call to undefined function db_query() in /var/www/htdocs/Sources/SPortal2.php(1609) : eval()'d code on line 23
Both are not compatible with SMF 2.0 Beta. I thought i wrote this :x. (But it seams i did it not xD).
Again... I'm having time problems...Normal Monday to Friday I'm at office from 6:00-16:00 (On my local time ;P).