##############################################################
## MOD Title:  B-day Caching Add-on
## MOD Author: easygo < webmaster@net4seven.de >
## MOD Description: Just another Add-on for the Birthday MOD by Niels
##  which is made to improve forum speed on Index / and ezPortal too
##
## MOD Version: 1.07
##
## Installation Level: easy
## Installation Time:  2 minutes
## Files To Edit: 2
##                index.php
##                includes/functions.php
##
##############################################################
## For security purposes, please check: http://www.net4seven.de/
## for the latest version of this MOD. Downloading this MOD from other
## sites could cause malicious code to enter into your forums.
##############################################################
## Before adding this MOD to your forums, you should back up all files related to this MOD
##############################################################
#
# At first you have to create folders named /cache (if not already exist) and /cache/bday
# Make sure that your server get write access to both (ex: CHMOD 777)
#
#-----[ OPEN ]------------------------------------------------
#
index.php

#
#-----[ FIND ]------------------------------------------------
#
// Birthday Mod, Show users with birthday

#
#-----[ BEFORE, ADD ]-----------------------------------------
#
/*

#
#-----[ FIND ]------------------------------------------------
#
      if ($birthday_today_list) $birthday_today_list[ strlen( $birthday_today_list)-1] = ' ';
      if ($birthday_week_list) $birthday_week_list[ strlen( $birthday_week_list)-1] = ' ';
   }
   $db->sql_freeresult($result);
}

#
#-----[ AFTER, ADD ]-----------------------------------------
#
*/
// -- add mod : B-day Caching to show users with birthday on Index / Portal -------------------
$cache_bday_file = $phpbb_root_path . "cache/bday/bday_" . $board_config['board_timezone'] . ".php";
$time_now = time(); // if already present you should remove this line

if ( @file_exists($cache_bday_file) )
{
   $last_update_time = @filemtime($cache_bday_file);
   $newest_regdate = $newest_userdata['user_regdate'];
   if (!isset($newest_userdata['user_regdate']) || $newest_regdate == 0)
   {
      $sql = "SELECT user_regdate FROM " . USERS_TABLE . "
         WHERE user_id <> " . ANONYMOUS . " AND user_active = 1
      ORDER BY user_id DESC LIMIT 0,1";
      if (!$result = $db->sql_query($sql))
      {
         message_die(GENERAL_ERROR, 'Could not obtain regdate information', '', __LINE__, __FILE__, $sql);
      }
      while ($row = $db->sql_fetchrow($result))
      {
         $newest_regdate = $row['user_regdate'];
      }
      $db->sql_freeresult($result);
   }
   $valid = ( ((date('Yz',$time_now) - date('Yz',$last_update_time)) == 0) && (($time_now - $newest_regdate) > ($time_now - $last_update_time)) ) ? true : false;
} else {
   $valid = false;
}

if ($valid )
{
   include ($cache_bday_file);
   $birthday_today_list = stripslashes($birthday_today_list);
   $birthday_week_list = stripslashes($birthday_week_list);
} else {
   $sql = ($board_config['birthday_check_day']) ? "SELECT user_id, username, user_birthday, user_level FROM " . USERS_TABLE. " WHERE user_birthday <> 999999 AND user_active=1 ORDER BY username" : "";
   if($result = $db->sql_query($sql))
   {
      if (!empty($result))
      {
         $this_year = create_date('Y', $time_now, $board_config['board_timezone']);
         $date_today = create_date('Ymd', $time_now, $board_config['board_timezone']);
         $date_forward = create_date('Ymd', $time_now+($board_config['birthday_check_day']*86400), $board_config['board_timezone']);
         while ($birthdayrow = $db->sql_fetchrow($result))
         {
            $user_birthday2 = $this_year.($user_birthday = realdate("md",$birthdayrow['user_birthday'] ));
            if ( $user_birthday2 < $date_today )
            {
               $user_birthday2 += 10000;
            }
            if ( $user_birthday2 > $date_today  && $user_birthday2 <= $date_forward )
            {
               // user are having birthday within the next days
               $user_age = ( $this_year.$user_birthday < $date_today ) ? $this_year - realdate ('Y',$birthdayrow['user_birthday'])+1 : $this_year- realdate ('Y',$birthdayrow['user_birthday']);
               $style_color = ( $birthdayrow['user_level'] == ADMIN ) ? 'style="color:#' . $theme['fontcolor3'] . '"' : (( $birthdayrow['user_level'] == MOD ) ? 'style="color:#' . $theme['fontcolor2'] . '"' : '');
               $birthday_week_list .= ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $birthdayrow['user_id']) . '"' . $style_color .'>' . $birthdayrow['username'] . ' ('.$user_age.')</a>,';
            }
            else if ( $user_birthday2 == $date_today )
            {
               //user have birthday today
               $user_age = $this_year - realdate ( 'Y',$birthdayrow['user_birthday'] );
               $style_color = ( $birthdayrow['user_level'] == ADMIN ) ? 'style="color:#' . $theme['fontcolor3'] . '"' : (( $birthdayrow['user_level'] == MOD ) ? 'style="color:#' . $theme['fontcolor2'] . '"' : '');
               $birthday_today_list .= ' <a href="' . append_sid("profile.$phpEx?mode=viewprofile&amp;" . POST_USERS_URL . "=" . $birthdayrow['user_id']) . '"' . $style_color .'>' . $birthdayrow['username'] . ' ('.$user_age.')</a>,';
            }
         }
         if ($birthday_today_list)
         {
            $birthday_today_list[strlen($birthday_today_list)-1] = ' ';
         }
         if ($birthday_week_list)
         {
            $birthday_week_list[strlen($birthday_week_list)-1] = ' ';
         }
      }
      $db->sql_freeresult($result);

      if ($fp = fopen($cache_bday_file, "w"))
      {
         // stores the data set in a cache file
         $bday = "<?php\n";
         $bday .='$birthday_today_list = \'' . addslashes($birthday_today_list) . "';\n";
         $bday .='$birthday_week_list = \'' . addslashes($birthday_week_list) . "';\n?>";
         fwrite($fp, $bday);
         fclose($fp);
         @chmod($cache_bday_file, 0777);
      }
   }
}
// -- fin : B-day Caching ---------------------------------------------------------------------

#
#-----[ OPEN ]------------------------------------------------
# (notice: next part is not really needed but useful)
#
includes/functions.php

#
#-----[ FIND ]------------------------------------------------
#
      case 'newestuser':
         $sql = "SELECT user_id, username

#
#-----[ IN-LINE FIND ]----------------------------------------
#
username

#
#-----[ IN-LINE AFTER, ADD ]----------------------------------
#
, user_regdate

#
#-----[ SAVE/CLOSE ALL FILES ]--------------------------------
#
# EoM

##############################################################
## MOD Title: User Age in Profiles
## MOD Author: easygo < webmaster@net4seven.de >
## MOD Description: This hack will display only the Age in user profiles.
## MOD Version: 1.07
##
## Note: Birthday MOD by Niels required
##
## Installation Level: easy
## Installation Time: 2-3 minutes
## Files To Edit: 4
##                includes/usercp_viewprofile.php
##                templates/subSilver/profile_view_body.tpl
##                language/lang_english/lang_main.php
##                language/lang_german/lang_main.php
##
##############################################################
## For security purposes, please check: http://www.net4seven.de/
## for the latest version of this MOD. Downloading this MOD from other
## sites could cause malicious code to enter into your forums.
##############################################################
## Before adding this MOD to your forums, you should back up all files related to this MOD.
##############################################################
## MOD History:
##
##   2005-07-14 - Initial Release
##   2005-07-18 - Bugfixing
##
##############################################################

#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_viewprofile.php

#
#-----[ FIND ]------------------------------------------
#
// Start add - Birthday MOD
if ($profiledata['user_birthday']!=999999)
{
   $user_birthday = realdate($lang['DATE_FORMAT'], $profiledata['user_birthday']);
}
else
{
   $user_birthday = $lang['No_birthday_specify'];
}
// End add - Birthday MOD

#
#-----[ REPLACE WITH ]-----------------------------------
#
// Start add - Birthday MOD
if ($profiledata['user_birthday']!=999999)
{
   //$user_birthday = realdate($lang['DATE_FORMAT'], $profiledata['user_birthday']);
   $user_birthdate = realdate('md', $profiledata['user_birthday']);
   $this_year = create_date('Y', time(), $board_config['board_timezone']);
   $this_date = create_date('md', time(), $board_config['board_timezone']);
   $user_age = $this_year - realdate('Y', $profiledata['user_birthday']);
   if ( $this_date < $user_birthdate ) $user_age--;
}
else
{
   //$user_birthday = $lang['No_birthday_specify'];
   $user_age = '';
}
// End add - Birthday MOD

#
#-----[ FIND ]-------------------------------------------
#
   'BIRTHDAY' => $user_birthday,

#
#-----[ REPLACE WITH ]-----------------------------------
#
   //'BIRTHDAY' => $user_birthday,
   'L_AGE' => $lang['Age'],
   'L_YEARS' => $lang['Years'],
   'USER_AGE' => $user_age,

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/profile_view_body.tpl

#
#-----[ FIND ]------------------------------------------
#
      <tr>
         <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_BIRTHDAY}:</span></td>
         <td><b><span class="gen">{BIRTHDAY}</span></b></td>
      </tr>

#
#-----[ REPLACE WITH ]-----------------------------------
#
      <tr>
         <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_AGE}:</span></td>
         <td><b><span class="gen">{USER_AGE}{L_Years}</span></b></td>
      </tr>

#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!

#
#-----[ BEFORE, ADD ]-----------------------------------
#
// mod: User Age in Profile
$lang['Years'] = ' Years';

#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!

#
#-----[ BEFORE, ADD ]-----------------------------------
#
// mod: User Age in Profile
$lang['Years'] = ' Jahre';

#
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------
#
# EoM

##############################################################
## MOD Title:  Toggle B-day Show
## MOD Author: easygo < webmaster@net4seven.de >
## MOD Description: This Add-on gives you a choice of enabling/disabling
##  users age viewable to others when viewing posts or user profiles.
##
## MOD Version: 1.0
##
## Note: Birthday MOD by Niels required
##
## Installation Level: easy
## Installation Time:  3-4 minutes
## Files To Edit: 7
##                admin/admin_board.php
##                includes/page_header.php
##                templates/subSilver/viewtopic_body.tpl
##                templates/subSilver/profile_view_body.tpl
##                templates/subSilver/admin/board_config_body.tpl
##                language/lang_english/lang_admin.php
##                language/lang_german/lang_admin.php
##
##############################################################
## For security purposes, please check: http://www.net4seven.de/
## for the latest version of this MOD. Downloading this MOD from other
## sites could cause malicious code to enter into your forums.
##############################################################
## Before adding this MOD to your forums, you should back up all files related to this MOD
##############################################################
#
#-----[ SQL ]------------------------------------------
#
INSERT INTO phpbb_config VALUES ('bday_show', '1');

#
#-----[ OPEN ]------------------------------------------
#
admin/admin_board.php

#
#-----[ FIND ]------------------------------------------
#
$override_user_style_no = ( !$new['override_user_style'] ) ? "checked=\"checked\"" : "";

#
#-----[ AFTER, ADD ]------------------------------------------
#
// Toggle B-day show
$bday_show_yes = ( $new['bday_show'] ) ? "checked=\"checked\"" : "";
$bday_show_no = ( !$new['bday_show'] ) ? "checked=\"checked\"" : "";

#
#-----[ FIND ]------------------------------------------
#
   "L_OVERRIDE_STYLE_EXPLAIN" => $lang['Override_style_explain'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
   // Toggle B-day show
   "L_BDAY_SHOW" => $lang['bday_show'],
   "L_BDAY_SHOW_EXPLAIN" => $lang['bday_show_explain'],

#
#-----[ FIND ]------------------------------------------
#
   "OVERRIDE_STYLE_NO" => $override_user_style_no,

#
#-----[ AFTER, ADD ]------------------------------------------
#
   // Toggle B-day show
   "BDAY_SHOW_YES" => $bday_show_yes,
   "BDAY_SHOW_NO" => $bday_show_no,

#
#-----[ OPEN ]------------------------------------------------
#
includes/page_header.php

#
#-----[ FIND ]------------------------------------------------
#
//
// Login box?

#
#-----[ BEFORE, ADD ]-----------------------------------------
#
if ($board_config['bday_show'])
{
   $template->assign_block_vars('switch_enable_bday_show', array());
}

#
#-----[ OPEN ]------------------------------------------------
#
templates/subSilver/viewtopic_body.tpl

#
#-----[ FIND ]------------------------------------------------
#
      <td width="150" align="left" valign="top" class="{postrow.ROW_CLASS}"><span class="name"><a name="{postrow.U_POST_ID}"></a>

#
#-----[ IN-LINE FIND ]----------------------------------------
#
<br />{postrow.POSTER_AGE}<br />{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}</span><br /></td>

#
#-----[ IN-LINE REPLACE WITH ]---------------------------------
#
<br />
<!-- BEGIN switch_enable_bday_show -->
{postrow.POSTER_AGE}<br />
<!-- END switch_enable_bday_show -->
{postrow.POSTER_JOINED}<br />{postrow.POSTER_POSTS}<br />{postrow.POSTER_FROM}</span><br /></td>

#
#-----[ OPEN ]------------------------------------------------
#
templates/subSilver/profile_view_body.tpl

#
#-----[ FIND ]------------------------------------------------
#
<!-- Start add - Birthday MOD -->
      <tr>
        <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_BIRTHDAY}:</span></td>
        <td><b><span class="gen">{BIRTHDAY}</span></b></td>
      </tr>
<!-- End add - Birthday MOD -->

#
#-----[ REPLACE WITH ]-----------------------------------------
#
      <!-- BEGIN switch_enable_bday_show -->
      <tr>
        <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_BIRTHDAY}:</span></td>
        <td><b><span class="gen">{BIRTHDAY}</span></b></td>
      </tr>
      <!-- END switch_enable_bday_show -->

#
#-----[ OPEN ]------------------------------------------------
#
templates/yourStyle/admin/board_config_body.tpl

#
#-----[ FIND ]------------------------------------------
#
   <tr>
      <td class="row1">{L_BIRTHDAY_LOOKFORWARD}<br /><span class="gensmall">{L_BIRTHDAY_LOOKFORWARD_EXPLAIN}</span></td>
      <td class="row2"><input class="post" type="text" size="3" maxlength="3" name="birthday_check_day" value="{BIRTHDAY_LOOKFORWARD}" /></td>
   </tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
   <tr>
      <td class="row1">{L_BDAY_SHOW}<br /><span class="gensmall">{L_BDAY_SHOW_EXPLAIN}</span></td>
      <td class="row2"><input type="radio" name="bday_show" value="1" {BDAY_SHOW_YES} />{L_YES}  <input type="radio" name="bday_show" value="0" {BDAY_SHOW_NO} />{L_NO}</td>
   </tr>

#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Toggle B-day show
$lang['bday_show'] = "Toggle B-day show";
$lang['bday_show_explain'] = "Make birthday data viewable in user profiles";

#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#
//
// That's all Folks!

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Toggle B-day show
$lang['bday_show'] = "Toggle B-day show";
$lang['bday_show_explain'] = "Geburtsdaten in Benutzerprofilen sichtbar machen";

#
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------
#
# EoM

##############################################################
## MOD Title: User Age in Profiles SR7
## MOD Author: easygo < webmaster@net4seven.de >
## MOD Description: This hack was especially made for www.net4seven.de to display
##  the Age and a text-based Birthdate without the Year in all user profiles.
## MOD Version: 1.07+
##
## Note: Birthday MOD by Niels required
##
## Installation Level: easy
## Installation Time: 2-3 minutes
## Files To Edit: 4
##                includes/usercp_viewprofile.php
##                templates/subSilver/profile_view_body.tpl
##                language/lang_english/lang_main.php
##                language/lang_german/lang_main.php
##
##############################################################
## For security purposes, please check: http://www.net4seven.de/
## for the latest version of this MOD. Downloading this MOD from other
## sites could cause malicious code to enter into your forums.
##############################################################
## Before adding this MOD to your forums, you should back up all files related to this MOD.
##############################################################
## MOD History:
##
##   2005-09-25 - NeT4SeVeN + Special Release
##   2005-07-14 - Initial Release
##   2005-07-18 - Bugfixing
##
##############################################################
#
#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_viewprofile.php

#
#-----[ FIND ]------------------------------------------
#
// Start add - Birthday MOD
if ($profiledata['user_birthday']!=999999)
{
   $user_birthday = realdate($lang['DATE_FORMAT'], $profiledata['user_birthday']);
}
else
{
   $user_birthday = $lang['No_birthday_specify'];
}
// End add - Birthday MOD

#
#-----[ REPLACE WITH ]----------------------------------
#
// Start add - Birthday MOD
if ($profiledata['user_birthday']!=999999)
{
   $this_year = create_date('Y', time(), $board_config['board_timezone']);
   $this_date = create_date('md', time(), $board_config['board_timezone']);
   $user_birthdate = realdate('md', $profiledata['user_birthday']);
   $user_age = $this_year - realdate('Y', $profiledata['user_birthday']);
   if ( $this_date < $user_birthdate ) $user_age--;
   $user_birthday = realdate('j. F', $profiledata['user_birthday']);
}
else
{
   $user_age = '';
   $user_birthday = $lang['No_birthday_specify'];
}
// End add - Birthday MOD

#
#-----[ FIND ]------------------------------------------
#
   'BIRTHDAY' => $user_birthday,

#
#-----[ REPLACE WITH ]----------------------------------
#
   'BIRTHDAY' => sprintf($lang['Born_on'], $user_birthday),
   'L_AGE' => $lang['Age'],
   'USER_AGE' => $user_age,

#
#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/profile_view_body.tpl

#
#-----[ FIND ]------------------------------------------
#
      <tr>
         <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_BIRTHDAY}:</span></td>
         <td><b><span class="gen">{BIRTHDAY}</span></b></td>
      </tr>

#
#-----[ REPLACE WITH ]----------------------------------
#
      <tr>
         <td valign="top" align="right" nowrap="nowrap"><span class="gen">{L_AGE}:</span></td>
         <td><b><span class="gen">{USER_AGE}</span></b><span class="genmed"> [{BIRTHDAY}]</span></td>
      </tr>

#
#
#-----[ OPEN ]------------------------------------------
#
language/lang_english/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
$lang['Age'] = 'Age';

#
#-----[ AFTER, ADD ]------------------------------------
#
$lang['Born_on'] = 'Born on %s';

#
#
#-----[ OPEN ]------------------------------------------
#
language/lang_german/lang_main.php

#
#-----[ FIND ]------------------------------------------
#
$lang['Age'] = 'Alter';

#
#-----[ AFTER, ADD ]------------------------------------
#
$lang['Born_on'] = 'Geboren am %s';

#
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------
#
# EoM

##############################################################
## MOD Title: Static Birth Date
## MOD Author: easygo < webmaster@net4seven.de >
## MOD Description: This hack was especially made for www.net4seven.de
##  to prevent that users change their date of birth afterwards.
## MOD Version: 1.07
##
## Note: Birthday MOD by Niels required
##
## Installation Level: easy
## Installation Time: 1 minute
## Files To Edit: 1
##                includes/usercp_register.php
##
##############################################################
## For security purposes, please check: http://www.net4seven.de/
## for the latest version of this MOD. Downloading this MOD from other
## sites could cause malicious code to enter into your forums.
##############################################################
## Before adding this MOD to your forums, you should back up all files related to this MOD.
##############################################################
## MOD History:
##
##  2006/08/04 - First Public Release
##  2005/09/28 - Initial Release
##
##############################################################
#
#
#-----[ OPEN ]------------------------------------------
#
includes/usercp_register.php

#
#-----[ FIND ]------------------------------------------
#
   } else
   {
      if ($board_config['birthday_required'])

#
#-----[ BEFORE, ADD ]-----------------------------------
#
   }
   else if ($mode == 'editprofile' && $userdata['user_birthday']!=999999)
   {
      $birthday = intval($userdata['user_birthday']);
      $next_birthday_greeting = $userdata['user_next_birthday_greeting'];

#
#-----[ FIND ]------------------------------------------
#
      'S_BIRTHDAY' => $s_birthday,

#
#-----[ REPLACE WITH ]----------------------------------
#
      'S_BIRTHDAY' => ($mode == 'register' || ($mode == 'editprofile' && $userdata['user_birthday']==999999)) ? $s_birthday : '<span class="genmed"><b>' . $birthday . '</b></span>',

#
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------
#
# EoM