Birthday list way too long

Hello,

is there any mod out there for vB3.6 which shows only birthdays from users with >250 posts?

On Big Boards the list is way too long imo.

It may be an easy mod, but I don't know where to look for...

Thanks,
-Tom

[andrewkhunn]

One way you could accomplish this is to make a separate usergroup that forum members with >250 posts get promoted to. Then turn off birthday display for forum members and turn it on for the promoted group.

[Ted S]

Should be simple enough to hack in...

Pop open includes/functions_databuild.php

Find

$bdays = $vbulletin->db->query_read_slave("
  SELECT username, userid, birthday, showbirthday
  FROM " . TABLE_PREFIX . "user
  WHERE (birthday LIKE '$todayneggmt-%' OR birthday LIKE '$todayposgmt-%')
  AND usergroupid IN ($usergroupids)
  AND showbirthday IN (2, 3)
  $activitycut
 ");

And replace it with

$bdays = $vbulletin->db->query_read_slave("
  SELECT username, userid, birthday, showbirthday
  FROM " . TABLE_PREFIX . "user
  WHERE (birthday LIKE '$todayneggmt-%' OR birthday LIKE '$todayposgmt-%')
  AND usergroupid IN ($usergroupids)
  AND showbirthday IN (2, 3)
  AND posts > 250
  $activitycut
 ");

You'll either have to wait for the birthday list to recompile or you can manually update it. You should be able to do by running this script:

<?php
error_reporting(E_ALL & ~E_NOTICE);
require_once('./global.php');
require_once(DIR . '/includes/functions_databuild.php');
$birthdaystore = build_birthdays();
DEVDEBUG('Updated Birthdays');
echo "Done";
?>

Just save it as birthday.php in your main directory and run.

Note: This is untested so please test it before going live.

[Thomas P]

Good one - many thanks mate