[Summary view] [Print] [Text view]

   1  <?php
   2  /** 
   3  *
   4  * @package ucp
   5  * @version $Id: ucp_resend.php,v 1.18 2006/11/03 21:04:10 acydburn Exp $
   6  * @copyright (c) 2005 phpBB Group 
   7  * @license http://opensource.org/licenses/gpl-license.php GNU Public License 
   8  *
   9  */
  10  
  11  /**
  12  * ucp_resend
  13  * Resending activation emails
  14  * @package ucp
  15  */
  16  class ucp_resend
  17  {
  18      var $u_action;
  19  
  20  	function main($id, $mode)
  21      {
  22          global $config, $phpbb_root_path, $phpEx;
  23          global $db, $user, $auth, $template;
  24  
  25          $username    = request_var('username', '', true);
  26          $email        = request_var('email', '');
  27          $submit        = (isset($_POST['submit'])) ? true : false;
  28  
  29          if ($submit)
  30          {
  31              $sql = 'SELECT user_id, group_id, username, user_email, user_type, user_lang, user_actkey
  32                  FROM ' . USERS_TABLE . "
  33                  WHERE user_email = '" . $db->sql_escape($email) . "'
  34                      AND username_clean = '" . $db->sql_escape(utf8_clean_string($username)) . "'";
  35              $result = $db->sql_query($sql);
  36              $user_row = $db->sql_fetchrow($result);
  37              $db->sql_freeresult($result);
  38  
  39              if (!$user_row)
  40              {
  41                  trigger_error('NO_EMAIL_USER');
  42              }
  43  
  44              if (!$user_row['user_actkey'])
  45              {
  46                  trigger_error('ACCOUNT_ALREADY_ACTIVATED');
  47              }
  48  
  49              // Determine coppa status on group (REGISTERED(_COPPA))
  50              $sql = 'SELECT group_name, group_type
  51                  FROM ' . GROUPS_TABLE . '
  52                  WHERE group_id = ' . $user_row['group_id'];
  53              $result = $db->sql_query($sql);
  54              $row = $db->sql_fetchrow($result);
  55              $db->sql_freeresult($result);
  56  
  57              if (!$row)
  58              {
  59                  trigger_error('NO_GROUP');
  60              }
  61  
  62              $coppa = ($row['group_name'] == 'REGISTERED_COPPA' && $row['group_type'] == GROUP_SPECIAL) ? true : false;
  63  
  64              include_once($phpbb_root_path . 'includes/functions_messenger.' . $phpEx);
  65              $messenger = new messenger(false);
  66  
  67              if ($config['require_activation'] == USER_ACTIVATION_SELF || $coppa)
  68              {
  69                  $messenger->template(($coppa) ? 'coppa_resend_inactive' : 'user_resend_inactive', $user_row['user_lang']);
  70  
  71                  $messenger->replyto($config['board_contact']);
  72                  $messenger->to($user_row['user_email'], $user_row['username']);
  73  
  74                  $messenger->headers('X-AntiAbuse: Board servername - ' . $config['server_name']);
  75                  $messenger->headers('X-AntiAbuse: User_id - ' . $user->data['user_id']);
  76                  $messenger->headers('X-AntiAbuse: Username - ' . $user->data['username']);
  77                  $messenger->headers('X-AntiAbuse: User IP - ' . $user->ip);
  78  
  79                  $messenger->assign_vars(array(
  80                      'WELCOME_MSG'    => htmlspecialchars_decode(sprintf($user->lang['WELCOME_SUBJECT'], $config['sitename'])),
  81                      'USERNAME'        => htmlspecialchars_decode($user_row['username']),
  82                      'U_ACTIVATE'    => generate_board_url() . "/ucp.$phpEx?mode=activate&u={$user_row['user_id']}&k={$user_row['user_actkey']}")
  83                  );
  84  
  85                  if ($coppa)
  86                  {
  87                      $messenger->assign_vars(array(
  88                          'FAX_INFO'        => $config['coppa_fax'],
  89                          'MAIL_INFO'        => $config['coppa_mail'],
  90                          'EMAIL_ADDRESS'    => $user_row['user_email'])
  91                      );
  92                  }
  93  
  94                  $messenger->send(NOTIFY_EMAIL);
  95              }
  96  
  97              if ($config['require_activation'] == USER_ACTIVATION_ADMIN)
  98              {
  99                  // Grab an array of user_id's with a_user permissions ... these users can activate a user
 100                  $admin_ary = $auth->acl_get_list(false, 'a_user', false);
 101  
 102                  $sql = 'SELECT user_id, username, user_email, user_lang, user_jabber, user_notify_type
 103                      FROM ' . USERS_TABLE . '
 104                      WHERE ' . $db->sql_in_set('user_id', $admin_ary[0]['a_user']);
 105                  $result = $db->sql_query($sql);
 106  
 107                  while ($row = $db->sql_fetchrow($result))
 108                  {
 109                      $messenger->template('admin_activate', $row['user_lang']);
 110                      $messenger->replyto($config['board_contact']);
 111                      $messenger->to($row['user_email'], $row['username']);
 112                      $messenger->im($row['user_jabber'], $row['username']);
 113  
 114                      $messenger->assign_vars(array(
 115                          'USERNAME'        => htmlspecialchars_decode($user_row['username']),
 116                          'U_ACTIVATE'    => generate_board_url() . "/ucp.$phpEx?mode=activate&u={$user_row['user_id']}&k={$user_row['user_actkey']}")
 117                      );
 118  
 119                      $messenger->send($row['user_notify_type']);
 120                  }
 121                  $db->sql_freeresult($result);
 122              }
 123  
 124              meta_refresh(3, append_sid("{$phpbb_root_path}index.$phpEx"));
 125  
 126              $message = $user->lang['ACTIVATION_EMAIL_SENT'] . '<br /><br />' . sprintf($user->lang['RETURN_INDEX'],  '<a href="' . append_sid("{$phpbb_root_path}index.$phpEx") . '">', '</a>');
 127              trigger_error($message);
 128          }
 129  
 130          $template->assign_vars(array(
 131              'USERNAME'            => $username,
 132              'EMAIL'                => $email,
 133              'S_PROFILE_ACTION'    => append_sid($phpbb_root_path . 'ucp.' . $phpEx, 'mode=resend_act'))
 134          );
 135  
 136          $this->tpl_name = 'ucp_resend';
 137          $this->page_title = 'UCP_RESEND';
 138      }
 139  }
 140  
 141  ?>