birthday block

open · #1 20th August 2011, 11:41

Hello I research a birthday for a block version 5.6TS
thank you I wait for a response from you.:sorry:

x360zone · #2 21st August 2011, 09:23

have you tried this then added the plugin yourself ive not tested it yet as ben busy?

PHP Code:


			
<?php
require_once('global.php');

gzip();
dbconn(true);
maxsysop();

?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
  "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-type" content="text/html; charset=utf-8" />
<title>Happy Birthday</title>

</head>
<body>
<?php
if($CURUSER){
    
    define ('SKIP_CACHE_MESSAGE', true);
    require_once INC_PATH . '/functions_cache2.php';
    $no_cache = false;
    if (!$showbday = cache_check2 ('tsf_bday'))
    {
      $no_cache = true;
    }

    if ($no_cache)
    {
      $todaybday = date ('j-n');
      $query = sql_query ('' . 'SELECT u.id,u.username,u.birthday,g.namestyle FROM users u LEFT JOIN usergroups g ON (u.usergroup=g.gid) WHERE u.birthday REGEXP \'^' . $todaybday . '-([1-9][0-9][0-9][0-9])\' AND u.enabled = \'yes\' AND u.status=\'confirmed\' AND u.usergroup != ' . UC_BANNED);
      $bdaycount = mysql_num_rows ($query);
      
      if (0 < $bdaycount)
      {
      
        while ($bday = mysql_fetch_assoc ($query))
        {
          $userbday = explode ('-', $bday['birthday']);
          $yearsold = date ('Y') - $userbday[2];
          $showbday .= ' <a href="' . tsf_seo_clean_text ($bday['username'], 'u', $bday['id'], '', 'ts') . '" target="_top">' . get_user_color ($bday['username'], $bday['namestyle']) . '</a> (<b>' . $yearsold . '</b>) ';
        }
      }else{
      $showbday .= '<center><b> No birthdays today!</b></center>';
      }
      cache_save2 ('tsf_bday', $showbday, '</td></tr>');
    }

    if (($cachesystem != 'yes' OR $no_cache))
    {
      $showbday .= '</td></tr>';
    }
   ?>
   <?php echo $showbday; ?>
</body>
</html>
<?php
}
?>

The Following User Says Thank You to x360zone For This Useful Post:
peiratikos (14th November 2011)