Looking For Birthday Hack

[Xenon]

hmm try this.
open admin/functions.php
find:

PHP Code:

// ##################### Save birthdays into template ###################
function getbirthdays() {
  global $timeoffset, $DB_site;

  $btoday = date("Y-m-d",time()+(-12-$timeoffset)*3600) . '|||';
  $btoday .= date("Y-m-d",time()+(12-$timeoffset)*3600) . '|||';

  $todayneggmt = date("m-d",time()+(-12-$timeoffset)*3600);
  $todayposgmt = date("m-d",time()+(12-$timeoffset)*3600);

  $bdays = $DB_site->query("SELECT username,userid,birthday
                            FROM user
                            WHERE birthday LIKE '%-$todayneggmt'
                              OR birthday LIKE '%-$todayposgmt'"); 


and change to:

PHP Code:

// ##################### Save birthdays into template ###################
function getbirthdays() {
  global $timeoffset, $DB_site;

  $btoday = date("Y-m-d",time()+(-12-$timeoffset)*3600) . '|||';
  $btoday .= date("Y-m-d",time()+(12-$timeoffset)*3600) . '|||';

  $todayneggmt = date("Y-m-d",time()+(-12-$timeoffset)*3600);
  $todayposgmt = date("Y-m-d",time()+(12-$timeoffset)*3600);

  $bdays = $DB_site->query("SELECT username,userid,birthday
                            FROM user
                            WHERE birthday = '$todayneggmt'
                              OR birthday = '$todayposgmt'"); 


[pifemaster]

Xenon,

I made the change, when I went to my calendar the date still shows up under "each year". When I went to my profile & attempted to change my date to "February 18, 2003" it gave me the following error message:

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT username,userid,birthday
FROM user
WHERE birthday = 2003-02-17'
OR birthday = 2003-02-18'
mysql error: You have an error in your SQL syntax near ''
OR birthday = 2003-02-18'' at line 3

mysql error number: 1064

Any ideas.

Thank you,
Robert Pfeifer

[pifemaster]

Xenon,

I reinstalled the "original" backup I made of "admin/functions.php" and the error goes away. But date shows up on home page of forum & on calendar for every year.

Thank you,
Robert Pfeifer

[Xenon]

you've made an mistake and deletete the single ' in front of the $today...

[pifemaster]

Xenon,

You were very correct. I did screw up & miss the '

I uploaded the new file & now the birthdate does not show up on the home page at all (even if the year is current) & still shows up on the calendar for each year.

Thank you,
Robert Pfeifer

[Xenon]

hmm weird...

don't have any further ideas..