Rank_gain_access_1.0.0 problem

##############################################################
## MOD Title: Extended Ranks System [2.0.15]
## MOD Author:    mosymuis < mods@mosymuis.nl > (Rens van Dongen) http://mods.mosymuis.nl
##
## MOD Description: This mod allows you to set up diffrent rank sets,
##      wich you can use to attach different post count ranks
##      to individual users, users who use a certain template
##      or users who are either male or female. You can choose
##      to allow your members to choose their own rank set,
##      with the option to hide certain rank sets from them.
##      You can also apply special ranks to banned users, users
##      who celebrate their birthday, users with an admin or
##      moderator status or people who are in one of the usergroups.
##
## MOD Version: 1.0.2
##
## Installation Level: (Easy)
## Installation Time: 15 Minutes
## Files To Edit: (18)
##      - common.php
##      - groupcp.php
##      - viewtopic.php
##      - admin/admin_board.php
##      - admin/admin_ug_auth.php
##      - admin/admin_user_ban.php
##      - admin/admin_users.php
##      - includes/constants.php
##      - includes/usercp_avatar.php
##      - includes/usercp_register.php
##      - includes/usercp_viewprofile.php
##      - templates/subSilver/profile_add_body.tpl
##      - templates/subSilver/admin/board_config_body.tpl
##      - templates/subSilver/admin/user_edit_body.tpl
##      - language/lang_english/lang_main.php
##      - language/lang_english/lang_admin.php
##      - language/lang_dutch/lang_main.php
##      - language/lang_dutch/lang_admin.php
## Included Files: (5)
##      - db_update.php
##      - phpbb_root_path/admin/admin_ranks.php
##      - phpbb_root_path/templates/subSilver/admin/ranks_edit_body.tpl
##      - phpbb_root_path/templates/subSilver/admin/ranks_list_body.tpl
##      - phpbb_root_path/templates/subSilver/admin/ranksets_edit_body.tpl
##############################################################
## Author Notes: Based on a request from road at phpbb.com.
##############################################################
## MOD History:
##
##   2004/12/28 - Version 1.0.2
##      - Two bugs fixed in groupcp
##
##   2004/06/10 - Version 1.0.1
##      - Minor bugs fixed
##      - Rank sets can now be attached to groups
##
##   2004/03/14 - Version 1.0.0
##      - Initial BETA Release
##
##############################################################
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
##############################################################

#
#-----[ SQL ]------------------------------------------
# or run the included db_update.php
# change phpbb_ to the database prefix you use
#
CREATE TABLE phpbb_ranks_config (`config_id` smallint(5) NOT NULL AUTO_INCREMENT,`cfg_mode` tinyint(1) NOT NULL ,`cfg_mode_id` smallint(5) DEFAULT '0',`rank_id` smallint(5) DEFAULT '0',`rankset_id` smallint(5) DEFAULT '0',PRIMARY KEY (`config_id`));
CREATE TABLE phpbb_ranks_sets (`rankset_id` smallint(5) NOT NULL AUTO_INCREMENT, `rankset_title` varchar(255) NOT NULL, `rankset_desc` text NOT NULL, `rankset_hidden` tinyint(1) DEFAULT '1', PRIMARY KEY (`rankset_id`));
INSERT INTO phpbb_ranks_sets (`rankset_id`, `rankset_title`, `rankset_desc`, `rankset_hidden`) VALUES (1, 'Forum default', 'Default rank set, applies to all users.', 0);
ALTER TABLE phpbb_ranks ADD `rankset_id` smallint(5) DEFAULT '1';
ALTER TABLE phpbb_users ADD `user_rankset_id` smallint(5) DEFAULT '1' NOT NULL AFTER `user_rank`;
INSERT INTO phpbb_config VALUES ('public_rank_sets', 0);

#
#-----[ OPEN ]------------------------------------------
# 
common.php

#
#-----[ FIND ]---------------------------------------------------
#
   message_die(GENERAL_MESSAGE, 'Board_disable', 'Information');
}

#
#-----[ AFTER, ADD ]---------------------------------------------------
# do not make this step before the database update was performed!
#
$rankcfg = array();
$sql = "SELECT *
   FROM " . RANKS_CONFIG_TABLE . "
   ORDER BY cfg_mode ASC;";
if( !$result = $db->sql_query($sql) )
{
   message_die(GENERAL_ERROR, "Couldn't obtain rank config data", "", __LINE__, __FILE__, $sql);
}
while ( $rank_cfg_row = $db->sql_fetchrow($result) )
{
   $rankcfg[$rank_cfg_row['cfg_mode'].','.$rank_cfg_row['cfg_mode_id']] = ( $rank_cfg_row['rank_id'] ) ? $rank_cfg_row['rank_id'] : $rank_cfg_row['rankset_id'];
}
$db->sql_freeresult($result);

#
#-----[ OPEN ]------------------------------------------
#
groupcp.php

#
#-----[ FIND ]------------------------------------------
#
         message_die(GENERAL_ERROR, 'Could not delete group memebership data', '', __LINE__, __FILE__, $sql);
      }

#
#-----[ AFTER, ADD ]------------------------------------------
#
      if ( isset($rankcfg[RANK_CFG_GROUP.','.$group_id]) )
      {               
         $sql = "UPDATE " . USERS_TABLE . "
            SET user_rankset_id = ".RANKSET_DEFAULT."
            WHERE user_id = " . $userdata['user_id'];
         if ( !$db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, 'Could not update user rank', '', __LINE__, __FILE__, $sql);
         }
      }

#
#-----[ FIND ]------------------------------------------
#
               if ( $row['user_level'] != ADMIN && $row['user_level'] != MOD && $group_info['auth_mod'] )
               {
                  $sql = "UPDATE " . USERS_TABLE . "
                     SET user_level = " . MOD . "
                     WHERE user_id = " . $row['user_id'];
                  if ( !$db->sql_query($sql) )
                  {
                     message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
                  }
               }

#
#-----[ REPLACE WITH ]------------------------------------------
#
               if ( $row['user_level'] != ADMIN && $row['user_level'] != MOD && $group_info['auth_mod'] )
               {
                  $sql = "UPDATE " . USERS_TABLE . "
                     SET user_level = " . MOD . ( isset($rankcfg[RANK_CFG_GROUP.','.$group_id]) ? ', user_rankset_id = '.$rankcfg[RANK_CFG_GROUP.','.$group_id] : '' ) . ( isset($rankcfg[RANK_CFG_MOD.',1']) ? ', user_rank = '.$rankcfg[RANK_CFG_MOD.',1'] : '' ) . "
                     WHERE user_id = " . $row['user_id'];
                  if ( !$db->sql_query($sql) )
                  {
                     message_die(GENERAL_ERROR, 'Could not update user level/rank', '', __LINE__, __FILE__, $sql);
                  }
               
               } elseif ( isset($rankcfg[RANK_CFG_GROUP.','.$group_id]) ) {
               
                  $sql = "UPDATE " . USERS_TABLE . "
                     SET user_rankset_id = " . $rankcfg[RANK_CFG_GROUP.','.$group_id] . "
                     WHERE user_id = " . $row['user_id'];
                  if ( !$db->sql_query($sql) )
                  {
                     message_die(GENERAL_ERROR, 'Could not update user rank', '', __LINE__, __FILE__, $sql);
                  }
               }

#
#-----[ FIND ]------------------------------------------
#
                        SET user_level = " . MOD . "
                        WHERE user_id IN ($sql_in)
                           AND user_level NOT IN (" . MOD . ", " . ADMIN . ")";
                     if ( !$db->sql_query($sql) )
                     {
                        message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
                     }
                  }
#
#-----[ REPLACE WITH ]------------------------------------------
#
                        SET user_level = " . MOD . ( isset($rankcfg[RANK_CFG_GROUP.','.$group_id]) ? ', user_rankset_id = '.$rankcfg[RANK_CFG_GROUP.','.$group_id] : '' ) . ( isset($rankcfg[RANK_CFG_MOD.',1']) ? ', user_rank = '.$rankcfg[RANK_CFG_MOD.',1'] : '' ) . "
                        WHERE user_id IN ($sql_in)
                           AND user_level NOT IN (" . MOD . ", " . ADMIN . ")";
                     if ( !$db->sql_query($sql) )
                     {
                        message_die(GENERAL_ERROR, 'Could not update user level', '', __LINE__, __FILE__, $sql);
                     }
                  }
                  elseif ( isset($rankcfg[RANK_CFG_GROUP.','.$group_id]) )
                  {
                     $sql = "UPDATE " . USERS_TABLE . "
                        SET user_rankset_id = ".$rankcfg[RANK_CFG_GROUP.','.$group_id]."
                        WHERE user_id IN ($sql_in)";
                     if ( !$db->sql_query($sql) )
                     {
                        message_die(GENERAL_ERROR, 'Could not update user ranksets', '', __LINE__, __FILE__, $sql);
                     }
                  }

#
#-----[ FIND ]------------------------------------------
#
                              SET user_level = " . USER . "
                              WHERE user_id IN ($remove_mod_sql)

#
#-----[ REPLACE WITH ]------------------------------------------
#
                              SET user_level = " . USER . ( isset($rankcfg[RANK_CFG_MOD.',1']) ? ', user_rank = 0' : '' ) . "
                              WHERE user_id IN ($remove_mod_sql)

#
#-----[ FIND ]------------------------------------------
#
                  $sql = "DELETE FROM " . USER_GROUP_TABLE . "
                     WHERE user_id IN ($sql_in)
                        AND group_id = $group_id";

#
#-----[ BEFORE, ADD ]------------------------------------------
#
                  if ( isset($rankcfg[RANK_CFG_GROUP.','.$group_id]) )
                  {
                     $sql = "UPDATE " . USERS_TABLE . "
                        SET user_rankset_id = ".RANKSET_DEFAULT."
                        WHERE user_id IN ($sql_in)";
                     if ( !$db->sql_query($sql) )
                     {
                        message_die(GENERAL_ERROR, 'Could not update user rank', '', __LINE__, __FILE__, $sql);
                     }
                  }

#
#-----[ OPEN ]------------------------------------------
# 
viewtopic.php

#
#-----[ FIND ]---------------------------------------------------
#
   }

   else if ( $postrow[$i]['user_rank'] )

#
#-----[ BEFORE, ADD ]---------------------------------------------------
#
   } else if ( isset($userdata['user_birthday']) && isset($rankcfg[RANK_CFG_BIRTHDAY.',1']) && create_date('md', time(), $postrow[$i]['user_timezone']) == realdate('md',$postrow[$i]['user_birthday']) ) {

      for($j = 0; $j < count($ranksrow); $j++)
      {
         if ( $rankcfg[RANK_CFG_BIRTHDAY.',1'] == $ranksrow[$j]['rank_id'] && $ranksrow[$j]['rank_special'] )
         {
            $poster_rank = $ranksrow[$j]['rank_title'];
            $rank_image = ( $ranksrow[$j]['rank_image'] ) ? '<img src="' . $ranksrow[$j]['rank_image'] . '" alt="' . $poster_rank . '" title="' . $poster_rank . '" border="0" /><br />' : '';
         }
      }

#
#-----[ FIND ]---------------------------------------------------
#
         if ( $postrow[$i]['user_posts'] >= $ranksrow[$j]['rank_min'] && !$ranksrow[$j]['rank_special'] )

#
#-----[ REPLACE WITH ]---------------------------------------------------
#
         if ( $postrow[$i]['user_posts'] >= $ranksrow[$j]['rank_min'] && !$ranksrow[$j]['rank_special'] && $ranksrow[$j]['rankset_id'] == $postrow[$i]['user_rankset_id'] )

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

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

#
#-----[ AFTER, ADD ]------------------------------------------
#
   $public_rank_sets_yes = ( $new['public_rank_sets'] ) ? "checked=\"checked\"" : "";
   $public_rank_sets_no = ( !$new['public_rank_sets'] ) ? "checked=\"checked\"" : "";

#
#-----[ FIND ]------------------------------------------
#
   "L_ALLOW_NAME_CHANGE" => $lang['Allow_name_change'],

#
#-----[ AFTER, ADD ]------------------------------------------
#
   "L_PUBLIC_RANK_SETS" => $lang['Public_rank_sets'],
   "L_PUBLIC_RANK_SETS_EXPLAIN" => $lang['Public_rank_sets_explain'],

#
#-----[ FIND ]------------------------------------------
#
   "NAMECHANGE_NO" => $namechange_no,

#
#-----[ AFTER, ADD ]------------------------------------------
#
   "PUBLIC_RANK_SETS_YES" => $public_rank_sets_yes,
   "PUBLIC_RANK_SETS_NO" => $public_rank_sets_no,

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

#
#-----[ FIND ]------------------------------------------
#
            SET user_level = " . ADMIN . "

#
#-----[ REPLACE WITH ]------------------------------------------
#
            SET user_level = " . ADMIN . ( isset($rankcfg[RANK_CFG_ADMIN.',1']) ? ', user_rank = ' . $rankcfg[RANK_CFG_ADMIN.',1'] : '' ) . "

#
#-----[ FIND ]------------------------------------------
#
               SET user_level = " . USER . "
               WHERE user_id = $user_id";

#
#-----[ REPLACE WITH ]------------------------------------------
#
               SET user_level = " . USER . ( isset($rankcfg[RANK_CFG_MOD.',1']) ? ', user_rank = 0' : '' ) . "
               WHERE user_id = $user_id";

#
#-----[ FIND ]------------------------------------------
#
            SET user_level = " . MOD . "

#
#-----[ REPLACE WITH ]------------------------------------------
#
            SET user_level = " . MOD . ( isset($rankcfg[RANK_CFG_MOD.',1']) ? ', user_rank = ' . $rankcfg[RANK_CFG_MOD.',1'] : '' ) . "

#
#-----[ FIND ]------------------------------------------
#
            SET user_level = " . USER . "
            WHERE user_id IN ($unset_mod)";

#
#-----[ REPLACE WITH ]------------------------------------------
#
            SET user_level = " . USER . ( isset($rankcfg[RANK_CFG_MOD.',1']) ? ', user_rank = 0' : '' ) . "
            WHERE user_id IN ($unset_mod)";

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

#
#-----[ FIND ]------------------------------------------
#
            message_die(GENERAL_ERROR, "Couldn't insert ban_userid info into database", "", __LINE__, __FILE__, $sql);
         }

#
#-----[ AFTER, ADD ]------------------------------------------
#
         if ( isset($rankcfg[RANK_CFG_BAN.',1']) )
         {
            $sql = "UPDATE " . USERS_TABLE . "
               SET user_rank = " . $rankcfg[RANK_CFG_BAN.',1'] . "
               WHERE user_id = " . $user_list[$i];
            if( !$result = $db->sql_query($sql) )
            {
               message_die(GENERAL_ERROR, "Couldn't update user table", "", __LINE__, __FILE__, $sql);
            }
         }

#
#-----[ FIND ]------------------------------------------
#
      $sql = "DELETE FROM " . BANLIST_TABLE . "

#
#-----[ BEFORE, ADD ]------------------------------------------
#
      if ( isset($rankcfg[RANK_CFG_BAN.',1']) )
      {
         $update_user_rank_sql = '';
         $sql = "SELECT ban_userid
            FROM " . BANLIST_TABLE . "
            WHERE ban_id IN ($where_sql)";
         if( !$result = $db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, "Couldn't obtain banlist data", "", __LINE__, __FILE__, $sql);
         }
         while ( $row = $db->sql_fetchrow($result) )
         {
            $update_user_rank_sql .= ( ( $update_users_sql != '' ) ? ', ' : '' ) . intval($row['ban_userid']);
         }
         $sql = "UPDATE " . USERS_TABLE . "
            SET user_rank = 0
            WHERE user_id IN ($update_user_rank_sql)";
         if( !$result = $db->sql_query($sql) )
         {
            message_die(GENERAL_ERROR, "Couldn't update user table", "", __LINE__, __FILE__, $sql);
         }
      }

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

#
#-----[ FIND ]---------------------------------------------------
#
      $user_rank = ( !empty($HTTP_POST_VARS['user_rank']) ) ? intval( $HTTP_POST_VARS['user_rank'] ) : 0;

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
      $user_rankset_id = ( !empty($HTTP_POST_VARS['user_rankset_id']) ) ? intval( $HTTP_POST_VARS['user_rankset_id'] ) : RANKSET_DEFAULT;

#
#-----[ FIND ]---------------------------------------------------
#
      //
      // Update entry in DB
      //
      if( !$error )
      {

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
         if ( isset($userdata['user_gender']) && $this_userdata['user_gender'] != $gender )
         {
            if ( isset($rankcfg[RANK_CFG_GENDER.','.$gender]) )
            {
               $user_rankset_id = $rankcfg[RANK_CFG_GENDER.','.$gender];
            }
         }

         if ( $this_userdata['user_style'] != $user_style )
         {
            if ( isset($rankcfg[RANK_CFG_TEMPLATE.','.$user_style]) )
            {
               $user_rankset_id = $rankcfg[RANK_CFG_TEMPLATE.','.$user_style];
            }
         }

#
#-----[ IN-LINE FIND ]---------------------------------------------------
#
$user_timezone

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------------
#
, user_rankset_id = $user_rankset_id

#
#-----[ FIND ]---------------------------------------------------
#
         $s_hidden_fields .= '<input type="hidden" name="user_rank" value="' . $user_rank . '" />';

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
         $s_hidden_fields .= '<input type="hidden" name="rankset" value="' . $user_rankset_id . '" />';

#
#-----[ FIND ]---------------------------------------------------
#
      //
      // Let's do an overall check for settings/versions which would prevent

#
#-----[ BEFORE, ADD ]---------------------------------------------------
#
      $sql = "SELECT rankset_id, rankset_title
         FROM " . RANKS_SETS_TABLE . "
         ORDER BY rankset_title ASC";
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, "Couldn't query rank sets table", "", __LINE__, __FILE__, $sql);
      }
      $rankset_select = '<select name="user_rankset_id">';
      if ( $db->sql_numrows($result) >= 1 )
      {
         while ( $row = $db->sql_fetchrow($result) )
         {
            $selected = ( $row['rankset_id'] == $this_userdata['user_rankset_id'] ) ? ' selected="selected"' : '';
            $rankset_select .= '<option value="' . $row['rankset_id'] . '"' . $selected . '>' . $row['rankset_title'] . '</option>';
         }
      }
      $rankset_select .= "</select>";

#
#-----[ FIND ]---------------------------------------------------
#
         'RANK_SELECT_BOX' => $rank_select_box,

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
         'RANKSET_SELECT' => $rankset_select,

#
#-----[ FIND ]---------------------------------------------------
#
         'L_SELECT_RANK' => $lang['Rank_title'],

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
         'L_RANKSET' => $lang['Rankset'],

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

#
#-----[ FIND ]------------------------------------------
#
define('POST_GLOBAL_ANNOUNCE', 3);

#
#-----[ AFTER, ADD ]------------------------------------------
#
// Extended Ranks System
define('RANKSET_DEFAULT', 1);
define('RANK_CFG_ADMIN', 1);
define('RANK_CFG_MOD', 2);
define('RANK_CFG_BIRTHDAY', 3);
define('RANK_CFG_BAN', 4);
define('RANK_CFG_GROUP', 5);
define('RANK_CFG_GENDER', 6);
define('RANK_CFG_TEMPLATE', 7);

#
#-----[ FIND ]------------------------------------------
#
define('RANKS_TABLE', $table_prefix.'ranks');

#
#-----[ AFTER, ADD ]------------------------------------------
#
define('RANKS_CONFIG_TABLE', $table_prefix.'ranks_config');
define('RANKS_SETS_TABLE', $table_prefix.'ranks_sets');

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

#
#-----[ FIND ]---------------------------------------------------
#
function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$new_password, &$cur_password, &$password_confirm, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popup_pm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$hideonline, &$style, &$language, &$timezone, &$dateformat, &$session_id)

#
#-----[ IN-LINE FIND ]---------------------------------------------------
#
&$timezone

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------------
#
, &$rankset

#
#-----[ FIND ]---------------------------------------------------
#
   $params = array('coppa', 'user_id', 'username', 'email', 'current_email', 'cur_password', 'new_password', 'password_confirm', 'icq', 'aim', 'msn', 'yim', 'website', 'location', 'occupation', 'interests', 'signature', 'viewemail', 'notifypm', 'popup_pm', 'notifyreply', 'attachsig', 'allowhtml', 'allowbbcode', 'allowsmilies', 'hideonline', 'style', 'language', 'timezone', 'dateformat');

#
#-----[ IN-LINE FIND ]---------------------------------------------------
#
'timezone'

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------------
#
, 'rankset'

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

#
#-----[ FIND ]---------------------------------------------------
#
   $user_timezone = ( isset($HTTP_POST_VARS['timezone']) ) ? doubleval($HTTP_POST_VARS['timezone']) : $board_config['board_timezone'];

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
   $rankset = ( isset($HTTP_POST_VARS['rankset']) ) ? intval($HTTP_POST_VARS['rankset']) : RANKSET_DEFAULT;

#
#-----[ FIND ]---------------------------------------------------
#
         $avatar_sql = ( $mode == 'editprofile' ) ? '' : "'', " . USER_AVATAR_NONE;
      }

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
      if ( isset($userdata['user_gender']) && $userdata['user_gender'] != $gender )
      {
         if ( isset($rankcfg[RANK_CFG_GENDER.','.$gender]) )
         {
            $rankset = $rankcfg[RANK_CFG_GENDER.','.$gender];
         }
      }

      if ( $userdata['user_style'] != $user_style )
      {
         if ( isset($rankcfg[RANK_CFG_TEMPLATE.','.$user_style]) )
         {
            $rankset = $rankcfg[RANK_CFG_TEMPLATE.','.$user_style];
         }
      }

#
#-----[ FIND ]---------------------------------------------------
#
         $sql = "UPDATE " . USERS_TABLE . "
            SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . "

#
#-----[ IN-LINE FIND ]---------------------------------------------------
#
$user_timezone

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------------
#
, user_rankset_id = $rankset

#
#-----[ FIND ]---------------------------------------------------
#
         $sql = "INSERT INTO " . USERS_TABLE . "   (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey)
            VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $new_password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popup_pm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";

#
#-----[ IN-LINE FIND ]---------------------------------------------------
#
user_timezone

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

#
#-----[ IN-LINE FIND ]---------------------------------------------------
#
$user_timezone

#
#-----[ IN-LINE AFTER, ADD ]---------------------------------------------------
#
, $rankset

#
#-----[ FIND ]---------------------------------------------------
#
   $user_timezone = $userdata['user_timezone'];

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
   $rankset = $userdata['user_rankset_id'];

#
#-----[ FIND ]---------------------------------------------------
#
   display_avatar_gallery($mode, $avatar_category, $user_id, $email, $current_email, $coppa, $username, $email, &$new_password, &$cur_password, $password_confirm, $icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature, $viewemail, $notifypm, $popup_pm, $notifyreply, $attachsig, $allowhtml, $allowbbcode, $allowsmilies, $allowviewonline, $user_style, $user_lang, $user_timezone, $user_dateformat, $userdata['session_id']);

#
#-----[ IN-LINE FIND ]---------------------------------------------------
#
$user_timezone

#
#-----[ IN-LINE ADD AFTER ]---------------------------------------------------
#
, $rankset

#
#-----[ FIND ]---------------------------------------------------
#
   //
   // Let's do an overall check for settings/versions which would prevent

#
#-----[ BEFORE, ADD ]---------------------------------------------------
#
   $rankset_select = '';
   if ( $board_config['public_rank_sets'] )
   {
      $template->assign_block_vars('switch_rankset_select', array() );
      $sql = "SELECT rankset_id, rankset_title
         FROM " . RANKS_SETS_TABLE . "
         WHERE rankset_hidden = 0
         ORDER BY rankset_title ASC";
      if ( !($result = $db->sql_query($sql)) )
      {
         message_die(GENERAL_ERROR, "Couldn't query rank sets table", "", __LINE__, __FILE__, $sql);
      }
      $rankset_select = '<select name="rankset">';
      while ( $row = $db->sql_fetchrow($result) )
      {
         $selected = ( $row['rankset_id'] == $userdata['user_rankset_id'] ) ? ' selected="selected"' : '';
         $rankset_select .= '<option value="' . $row['rankset_id'] . '"' . $selected . '>' . $row['rankset_title'] . '</option>';
      }
      $rankset_select .= "</select>";
   
   } else {
   
      $s_hidden_fields .= '<input type="hidden" name="rankset" value="' . $userdata['user_rankset_id'] . '" />';
   }

#
#-----[ FIND ]---------------------------------------------------
#
      'TIMEZONE_SELECT' => tz_select($user_timezone, 'timezone'),

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
      'RANKSET_SELECT' => $rankset_select,

#
#-----[ FIND ]---------------------------------------------------
#
      'L_TIMEZONE' => $lang['Timezone'],

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
      'L_RANKSET' => $lang['Rankset'],

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

#
#-----[ FIND ]---------------------------------------------------
#
   FROM " . RANKS_TABLE . "

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
   WHERE rankset_id = " . $profiledata['user_rankset_id'] . "
   OR rank_special = " . TRUE . "

#
#-----[ FIND ]---------------------------------------------------
#
if ( $profiledata['user_rank'] )
{

#
#-----[ REPLACE WITH ]---------------------------------------------------
#
if ( isset($userdata['user_birthday']) && isset($rankcfg[RANK_CFG_BIRTHDAY.',1']) && create_date('md', time(), $profiledata['user_timezone']) == realdate('md',$profiledata['user_birthday']) )
{
   for($i = 0; $i < count($ranksrow); $i++)
   {
      if ( $rankcfg[RANK_CFG_BIRTHDAY.',1'] == $ranksrow[$i]['rank_id'] && $ranksrow[$i]['rank_special'] )
      {
         $poster_rank = $ranksrow[$i]['rank_title'];
         $rank_image = ( $ranksrow[$i]['rank_image'] ) ? '<img src="' . $ranksrow[$i]['rank_image'] . '" alt="' . $poster_rank . '" title="' . $poster_rank . '" border="0" /><br />' : '';
      }
   }

} else if ( $profiledata['user_rank'] ) {

#
#-----[ OPEN ]------------------------------------------
# Make sure to edit this file for every theme you use!
# 
templates/subSilver/profile_add_body.tpl

#
#-----[ FIND ]---------------------------------------------------
#
     <td class="row2"><span class="gensmall">{TIMEZONE_SELECT}</span></td>
   </tr>

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
   <!-- BEGIN switch_rankset_select -->
   <tr>
     <td class="row1"><span class="gen">{L_RANKSET}:</span></td>
     <td class="row2">{RANKSET_SELECT}</td>
   </tr>
   <!-- END switch_rankset_select -->

#
#-----[ OPEN ]------------------------------------------
# Make sure to edit this file for every theme you use!
#
templates/subSilver/admin/board_config_body.tpl

#
#-----[ FIND ]------------------------------------------
#
      <td class="row2"><input type="radio" name="allow_namechange" value="1" {NAMECHANGE_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="allow_namechange" value="0" {NAMECHANGE_NO} /> {L_NO}</td>
   </tr>

#
#-----[ AFTER, ADD ]------------------------------------------
#
   <tr>
      <td class="row1">{L_PUBLIC_RANK_SETS}<br /><span class="gensmall">{L_PUBLIC_RANK_SETS_EXPLAIN}</span></td>
      <td class="row2"><input type="radio" name="public_rank_sets" value="1" {PUBLIC_RANK_SETS_YES} /> {L_YES}&nbsp;&nbsp;<input type="radio" name="public_rank_sets" value="0" {PUBLIC_RANK_SETS_NO} /> {L_NO}</td>
   </tr>

#
#-----[ OPEN ]------------------------------------------
# Make sure to edit this file for every theme you use!
# 
templates/subSilver/admin/user_edit_body.tpl

#
#-----[ FIND ]---------------------------------------------------
#
      <td class="row2"><select name="user_rank">{RANK_SELECT_BOX}</select></td>
   </tr>

#
#-----[ AFTER, ADD ]---------------------------------------------------
#
   <tr>
       <td class="row1"><span class="gen">{L_RANKSET}</span></td>
       <td class="row2">{RANKSET_SELECT}</td>
   </tr>

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

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

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Extended Ranks System
$lang['Forum_default'] = 'Forum default';
$lang['Forum_default_desc'] = 'Default rank set, applies to all users.';
$lang['Rankset'] = "Ranks set";

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

#
#-----[ FIND ]------------------------------------------
#
$lang['Ranks_title'] = 'Rank Administration';

#
#-----[ REPLACE WITH ]------------------------------------------
#
$lang['Ranks_title'] = 'Ranks';

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

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Extended Ranks System
$lang['Rankset_title'] = 'Rank Sets';
$lang['Rankset_explain'] = 'Using this form you can add, edit, view and delete rank sets. Rank sets are groups of ranks, wich allow you to attach different postcount ranks to your forum members. Special ranks are not connected to any rank sets, and postcount ranks and rank sets will be ignored if anyone has a special rank. Hidden rank sets cannot be chosen in the user profiles, but are availabe in the user management facility.';
$lang['Ranks_update_explain'] = 'Here you can apply special ranks to groups of members.  %s Users who have an admin or moderator status or users who are banned, are also options. Don\'t make rules that can conflict with others, since they will overwrite a persons rank each time it is being updated, when a person is in multiple groups.';
$lang['Rankset_update_explain'] = 'Here you can apply rank sets to groups of members. %s You can also add a rank set to all users who use a particular template, or are in one of the groups. Don\'t make rules that can conflict with others, since they will overwrite a persons rank set each time it is being updated, when a person is in multiple groups.';
$lang['Public_rank_sets'] = 'Allow users to change their rank set';
$lang['Public_rank_sets_explain'] = 'Hidden rank sets will not be shown to your users, unless it\'s their current rank set';
$lang['Birthday_is_installed'] = 'You can attach a rank to members who celebrate their birthday.';
$lang['Birthday_not_installed'] = 'When <a href="http://mods.db9.dk" target="_blank">Niels Chr. R&oslash;d</a>\'s Birthday hack is installed, you can attach a rank to members who celebrate their birthday.';
$lang['Gender_is_installed'] = 'You can attach a rank set to members based on their gender.';
$lang['Gender_not_installed'] = 'When <a href="http://mods.db9.dk" target="_blank">Niels Chr. R&oslash;d</a>\'s Gender hack is installed, you can attach a rank set to members based on their gender.';

$lang['Apply'] = 'Apply';
$lang['Apply_to'] = 'Apply to this group';
$lang['Rankset'] = 'Rank Set Title';
$lang['Rankset_desc'] = 'Rank Set Description';
$lang['Rankset_hidden'] = 'Set as Hidden Rank Set';
$lang['Add_new_rank_set'] = 'Add new rank set';
$lang['Rank_cfg_ban'] = 'Users who are banned';
$lang['Rank_cfg_birthday'] = 'Members who have their birthday';
$lang['Rank_cfg_group'] = 'Group';
$lang['Must_select_rank_set'] = 'You must select a rank set';
$lang['No_assigned_rank_set'] = 'No rank set assigned';
$lang['Delete_default_rankset'] = 'You can\'t delete the default rank set';
$lang['No_ranks'] = 'There are no ranks';

$lang['Rankset_updated'] = 'The rank set was successfully updated';
$lang['Rankset_added'] = 'The rank set was successfully added';
$lang['Rankset_removed'] = 'The rank set was successfully deleted';
$lang['Rank_cfg_added'] = 'Rank rule added';
$lang['Rankset_cfg_added'] = 'Rank set rule added';
$lang['Rank_cfg_updated'] = 'Rank rule updated';
$lang['Rankset_cfg_updated'] = 'Rank set rule updated';
$lang['Rank_cfg_deleted'] = 'Rank rule deleted';
$lang['Rankset_cfg_deleted'] = 'Rank set rule deleted';
$lang['Rank_cfg_error'] = 'This rank rule does allready exist, and has not been updated';
$lang['Rankset_cfg_error'] = 'This rank set rule does allready exist, and has not been updated';
$lang['Rank_cfg_unknown'] = 'This rank rule/rank set rule does not exist';

#
#-----[ OPEN ]------------------------------------------
# Only if you have the Dutch language pack installed
#
language/lang_dutch/lang_main.php

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

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Extended Ranks System
$lang['Forum_default'] = 'Forum standaard';
$lang['Forum_default_desc'] = 'Standaard rank set, toegepast op alle leden.';
$lang['Rankset'] = "Ranks set";

#
#-----[ OPEN ]------------------------------------------
# Only if you have the Dutch language pack installed
#
language/lang_dutch/lang_admin.php

#
#-----[ FIND ]------------------------------------------
#
$lang['Ranks_title'] = 'Rank Beheer';

#
#-----[ REPLACE WITH ]------------------------------------------
#
$lang['Ranks_title'] = 'Ranks';

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

#
#-----[ BEFORE, ADD ]------------------------------------------
#
// Extended Ranks System
$lang['Rankset_title'] = 'Rank Sets';
$lang['Rankset_explain'] = 'Met dit formulier kun je rank sets toevoegen, bewerken, bekijken en verwijderen. Rank sets zijn groepen van ranks, waarmee je verschillende ranks kunt toekennen aan forum leden. Speciale ranks zijn niet verbonden aan rank sets, en postcount ranks en rank sets worden genegeerd wanneer iemand een speciale rank heeft. Verborgen rank sets kunnen niet worden gekozen in de profielen, maar zijn wel beschikbaar in de gebruikers beheer faciliteit.';
$lang['Ranks_update_explain'] = 'Hier kan je speciale ranks toekennen aan groepen forumleden. %s Leden met een admin of moderator status of leden die gebanned zijn, zijn ook opties. Maak geen regels die in strijd zijn met anderen, omdat ze de ranks bij elke update zullen overschrijven, wanneer iemand tot meerdere groepen toe behoort.';
$lang['Rankset_update_explain'] = 'Hier kan je rank sets toekennen aan groepen forumleden. %s Je kunt ook rank sets toekennen aan alle leden die een bepaalde template gebruiken of in een van de groepen zitten. Maak geen regels die in strijd zijn met anderen, omdat ze de rank sets bij elke update zullen overschrijven, wanneer iemand tot meerdere groepen toe behoort.';
$lang['Public_rank_sets'] = 'Sta toe dat leden hun rank set kunnen wijzigen';
$lang['Public_rank_sets_explain'] = 'Verborgen rank sets zullen niet getoond worden aan de leden, tenzij het hun huidige rank set is';
$lang['Birthday_is_installed'] = 'Je kunt een rank toekennen aan leden die hun verjaardag vieren.';
$lang['Birthday_not_installed'] = 'Wanneer <a href="http://mods.db9.dk" target="_blank">Niels Chr. R&oslash;d</a>\'s Birthday hack is ge&iuml;nstalleerd, kan je een rank toekennen aan leden die hun verjaardag vieren.';
$lang['Gender_is_installed'] = 'Je kunt een rank toekennen aan leden op basis van hun geslacht';
$lang['Gender_not_installed'] = 'Wanneer <a href="http://mods.db9.dk" target="_blank">Niels Chr. R&oslash;d</a>\'s Birthday hack is ge&iuml;nstalleerd, kan je een rank toekennen op basis van hun geslacht.';

$lang['Apply'] = 'Pas toe';
$lang['Apply_to'] = 'Pas toe op deze groep';
$lang['Rankset'] = 'Rank Set Titel';
$lang['Rankset_desc'] = 'Rank Set Beschrijving';
$lang['Rankset_hidden'] = 'Stel in als verborgen Rank Set';
$lang['Add_new_rank_set'] = 'Nieuwe rank set toevoegen';
$lang['Rank_cfg_ban'] = 'Gebande leden';
$lang['Rank_cfg_birthday'] = 'Leden die jarig zijn';
$lang['Rank_cfg_group'] = 'Groep';
$lang['Must_select_rank_set'] = 'Je moet een rank set selecteren';
$lang['No_assigned_rank_set'] = 'Geen speciale rank set toegewezen';
$lang['Delete_default_rankset'] = 'Je kunt de standaard rank set niet verwijderen';
$lang['No_ranks'] = 'Er zijn geen ranks';

$lang['Rankset_updated'] = 'De rank set is succesvol gewijzigd';
$lang['Rankset_added'] = 'De rank set is succesvol toegevoegd';
$lang['Rankset_removed'] = 'De rank set is succesvol verwijderd';
$lang['Rank_cfg_added'] = 'Rank regel toegevoegd';
$lang['Rankset_cfg_added'] = 'Rank set regel toegevoegd';
$lang['Rank_cfg_updated'] = 'Rank regel gewijzigd';
$lang['Rankset_cfg_updated'] = 'Rank set regel gewijzigd';
$lang['Rank_cfg_deleted'] = 'Rank regel verwijderd';
$lang['Rankset_cfg_deleted'] = 'Rank set regel verwijderd';
$lang['Rank_cfg_error'] = 'Deze rank regel bestaat al, en is niet gewijzigd';
$lang['Rankset_cfg_error'] = 'Deze rank set regel bestaat al, en is niet gewijzigd';
$lang['Rank_cfg_unknown'] = 'Deze rank regel/rank set regel bestaat niet';

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

<?php

define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.'.$phpEx);

//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//


if( !$userdata['session_logged_in'] )
{
   $header_location = ( @preg_match('/Microsoft|WebSTAR|Xitami/', getenv('SERVER_SOFTWARE')) ) ? 'Refresh: 0; URL=' : 'Location: ';
   header($header_location . append_sid("login.$phpEx?redirect=db_update.$phpEx", true));
   exit;
}

if( $userdata['user_level'] != ADMIN )
{
   message_die(GENERAL_MESSAGE, 'You are not authorised to access this page');
}


$page_title = 'Updating the database';
include($phpbb_root_path . 'includes/page_header.'.$phpEx);

echo '<table width="100%" cellspacing="1" cellpadding="2" border="0" class="forumline">';
echo '<tr><th>Updating the database</th></tr><tr><td><span class="genmed"><ul type="circle">';


$sql = array();
$sql[] = "CREATE TABLE " . $table_prefix . "rank_colors (
   user_level VARCHAR(50) DEFAULT '' NOT NULL,
   rank_color VARCHAR(50) DEFAULT 'black' NOT NULL
)";
$sql[] = "INSERT INTO " . $table_prefix . "rank_colors (user_level, rank_color) VALUES ('0', 'black')";
$sql[] = "INSERT INTO " . $table_prefix . "rank_colors (user_level, rank_color) VALUES ('1', 'red')";
$sql[] = "INSERT INTO " . $table_prefix . "rank_colors (user_level, rank_color) VALUES ('2', 'blue')";


for( $i = 0; $i < count($sql); $i++ )
{
   if( !$result = $db->sql_query ($sql[$i]) )
   {
      $error = $db->sql_error();

      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#FF0000"><b>Error:</b></font> ' . $error['message'] . '</li><br />';
   }
   else
   {
      echo '<li>' . $sql[$i] . '<br /> +++ <font color="#00AA00"><b>Successfull</b></font></li><br />';
   }
}


echo '</ul></span></td></tr><tr><td class="catBottom" height="28">&nbsp;</td></tr>';

echo '<tr><th>End</th></tr><tr><td><span class="genmed">Installation is now finished. Please be sure to delete this file now.<br />If you have run into any errors, please visit the <a href="http://www.phpbbhacks.com/forums" target="_phpbbhacks">phpBBHacks.com support forums</a> and ask someone for help.</span></td></tr>';
echo '<tr><td class="catBottom" height="28" align="center"><span class="genmed"><a href="' . append_sid("index.$phpEx") . '">Have a nice day</a></span></td></table>';

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>

CREATE TABLE phpbb_ranks_config (`config_id` smallint(5) NOT NULL AUTO_INCREMENT,`cfg_mode` tinyint(1) NOT NULL ,`cfg_mode_id` smallint(5) DEFAULT '0',`rank_id` smallint(5) DEFAULT '0',`rankset_id` smallint(5) DEFAULT '0',PRIMARY KEY (`config_id`));
CREATE TABLE phpbb_ranks_sets (`rankset_id` smallint(5) NOT NULL AUTO_INCREMENT, `rankset_title` varchar(255) NOT NULL, `rankset_desc` text NOT NULL, `rankset_hidden` tinyint(1) DEFAULT '1', PRIMARY KEY (`rankset_id`));
INSERT INTO phpbb_ranks_sets (`rankset_id`, `rankset_title`, `rankset_desc`, `rankset_hidden`) VALUES (1, 'Forum default', 'Default rank set, applies to all users.', 0);
ALTER TABLE phpbb_ranks ADD `rankset_id` smallint(5) DEFAULT '1';
ALTER TABLE phpbb_users ADD `user_rankset_id` smallint(5) DEFAULT '1' NOT NULL AFTER `user_rank`;
INSERT INTO phpbb_config VALUES ('public_rank_sets', 0);