| 
      1
     | 
    
      <?php
 
     | 
  
  
    | 
      2
     | 
    
      /**
 
     | 
  
  
    | 
      3
     | 
    
       *
 
     | 
  
  
    | 
      4
     | 
    
       * @category        backend
 
     | 
  
  
    | 
      5
     | 
    
       * @package         login
 
     | 
  
  
    | 
      6
     | 
    
       * @author          WebsiteBaker Project
 
     | 
  
  
    | 
      7
     | 
    
       * @copyright       2004-2009, Ryan Djurovich
 
     | 
  
  
    | 
      8
     | 
    
       * @copyright       2009-2010, Website Baker Org. e.V.
 
     | 
  
  
    | 
      9
     | 
    
       * @link			http://www.websitebaker2.org/
 
     | 
  
  
    | 
      10
     | 
    
       * @license         http://www.gnu.org/licenses/gpl.html
 
     | 
  
  
    | 
      11
     | 
    
       * @platform        WebsiteBaker 2.8.x
 
     | 
  
  
    | 
      12
     | 
    
       * @requirements    PHP 4.3.4 and higher
 
     | 
  
  
    | 
      13
     | 
    
       * @version         $Id: class.login.php 1289 2010-02-10 15:13:21Z kweitzel $
 
     | 
  
  
    | 
      14
     | 
    
       * @filesource		$HeadURL: svn://isteam.dynxs.de/wb-archiv/trunk/wb/framework/class.login.php $
 
     | 
  
  
    | 
      15
     | 
    
       * @lastmodified    $Date: 2010-02-10 16:13:21 +0100 (Wed, 10 Feb 2010) $
 
     | 
  
  
    | 
      16
     | 
    
       *
 
     | 
  
  
    | 
      17
     | 
    
       */
 
     | 
  
  
    | 
      18
     | 
    
      
 
     | 
  
  
    | 
      19
     | 
    
      // Stop this file from being accessed directly
 
     | 
  
  
    | 
      20
     | 
    
      if(!defined('WB_URL')) {
     | 
  
  
    | 
      21
     | 
    
      	header('Location: ../index.php');
     | 
  
  
    | 
      22
     | 
    
      	exit(0);
 
     | 
  
  
    | 
      23
     | 
    
      }
 
     | 
  
  
    | 
      24
     | 
    
      
 
     | 
  
  
    | 
      25
     | 
    
      define('LOGIN_CLASS_LOADED', true);
     | 
  
  
    | 
      26
     | 
    
      
 
     | 
  
  
    | 
      27
     | 
    
      // Load the other required class files if they are not already loaded
 
     | 
  
  
    | 
      28
     | 
    
      require_once(WB_PATH."/framework/class.admin.php");
 
     | 
  
  
    | 
      29
     | 
    
      // Get WB version
 
     | 
  
  
    | 
      30
     | 
    
      require_once(ADMIN_PATH.'/interface/version.php');
 
     | 
  
  
    | 
      31
     | 
    
      
 
     | 
  
  
    | 
      32
     | 
    
      class login extends admin {
     | 
  
  
    | 
      33
     | 
    
      	function login($config_array) {
     | 
  
  
    | 
      34
     | 
    
      		// Get language vars
 
     | 
  
  
    | 
      35
     | 
    
      		global $MESSAGE;
 
     | 
  
  
    | 
      36
     | 
    
      		$this->wb();
 
     | 
  
  
    | 
      37
     | 
    
      		// Get configuration values
 
     | 
  
  
    | 
      38
     | 
    
      		$this->USERS_TABLE = $config_array['USERS_TABLE'];
 
     | 
  
  
    | 
      39
     | 
    
      		$this->GROUPS_TABLE = $config_array['GROUPS_TABLE'];
 
     | 
  
  
    | 
      40
     | 
    
      		$this->username_fieldname = $config_array['USERNAME_FIELDNAME'];
 
     | 
  
  
    | 
      41
     | 
    
      		$this->password_fieldname = $config_array['PASSWORD_FIELDNAME'];
 
     | 
  
  
    | 
      42
     | 
    
      		$this->remember_me_option = $config_array['REMEMBER_ME_OPTION'];
 
     | 
  
  
    | 
      43
     | 
    
      		$this->max_attemps = $config_array['MAX_ATTEMPS'];
 
     | 
  
  
    | 
      44
     | 
    
      		$this->warning_url = $config_array['WARNING_URL'];
 
     | 
  
  
    | 
      45
     | 
    
      		$this->login_url = $config_array['LOGIN_URL'];
 
     | 
  
  
    | 
      46
     | 
    
      		$this->template_dir = $config_array['TEMPLATE_DIR'];
 
     | 
  
  
    | 
      47
     | 
    
      		$this->template_file = $config_array['TEMPLATE_FILE'];
 
     | 
  
  
    | 
      48
     | 
    
      		$this->frontend = $config_array['FRONTEND'];
 
     | 
  
  
    | 
      49
     | 
    
      		$this->forgotten_details_app = $config_array['FORGOTTEN_DETAILS_APP'];
 
     | 
  
  
    | 
      50
     | 
    
      		$this->max_username_len = $config_array['MAX_USERNAME_LEN'];
 
     | 
  
  
    | 
      51
     | 
    
      		$this->max_password_len = $config_array['MAX_PASSWORD_LEN'];
 
     | 
  
  
    | 
      52
     | 
    
      		if (array_key_exists('REDIRECT_URL',$config_array))
     | 
  
  
    | 
      53
     | 
    
      			$this->redirect_url = $config_array['REDIRECT_URL'];
 
     | 
  
  
    | 
      54
     | 
    
      		else
 
     | 
  
  
    | 
      55
     | 
    
      			$this->redirect_url = '';
 
     | 
  
  
    | 
      56
     | 
    
      		// Get the supplied username and password
 
     | 
  
  
    | 
      57
     | 
    
      		if ($this->get_post('username_fieldname') != ''){
     | 
  
  
    | 
      58
     | 
    
      			$username_fieldname = $this->get_post('username_fieldname');
     | 
  
  
    | 
      59
     | 
    
      			$password_fieldname = $this->get_post('password_fieldname');
     | 
  
  
    | 
      60
     | 
    
      		} else {
     | 
  
  
    | 
      61
     | 
    
      			$username_fieldname = 'username';
 
     | 
  
  
    | 
      62
     | 
    
      			$password_fieldname = 'password';
 
     | 
  
  
    | 
      63
     | 
    
      		}
 
     | 
  
  
    | 
      64
     | 
    
      		$this->username = $this->add_slashes(strtolower($this->get_post($username_fieldname)));
 
     | 
  
  
    | 
      65
     | 
    
      		$this->password = $this->get_post($password_fieldname);
 
     | 
  
  
    | 
      66
     | 
    
      		// Figure out if the "remember me" option has been checked
 
     | 
  
  
    | 
      67
     | 
    
      		if($this->get_post('remember') == 'true') {
     | 
  
  
    | 
      68
     | 
    
      			$this->remember = $this->get_post('remember');
     | 
  
  
    | 
      69
     | 
    
      		} else {
     | 
  
  
    | 
      70
     | 
    
      			$this->remember = false;
 
     | 
  
  
    | 
      71
     | 
    
      		}
 
     | 
  
  
    | 
      72
     | 
    
      		// Get the length of the supplied username and password
 
     | 
  
  
    | 
      73
     | 
    
      		if($this->get_post($username_fieldname) != '') {
     | 
  
  
    | 
      74
     | 
    
      			$this->username_len = strlen($this->username);
 
     | 
  
  
    | 
      75
     | 
    
      			$this->password_len = strlen($this->password);
 
     | 
  
  
    | 
      76
     | 
    
      		}
 
     | 
  
  
    | 
      77
     | 
    
      		// If the url is blank, set it to the default url
 
     | 
  
  
    | 
      78
     | 
    
      		$this->url = $this->get_post('url');
     | 
  
  
    | 
      79
     | 
    
      		if ($this->redirect_url!='') {
     | 
  
  
    | 
      80
     | 
    
      			$this->url = $this->redirect_url;
 
     | 
  
  
    | 
      81
     | 
    
      		}		
 
     | 
  
  
    | 
      82
     | 
    
      		if(strlen($this->url) < 2) {
     | 
  
  
    | 
      83
     | 
    
      			$this->url = $config_array['DEFAULT_URL'];
 
     | 
  
  
    | 
      84
     | 
    
      		}
 
     | 
  
  
    | 
      85
     | 
    
      		if($this->is_authenticated() == true) {
     | 
  
  
    | 
      86
     | 
    
      			// User already logged-in, so redirect to default url
 
     | 
  
  
    | 
      87
     | 
    
      			header('Location: '.$this->url);
     | 
  
  
    | 
      88
     | 
    
      			exit();
 
     | 
  
  
    | 
      89
     | 
    
      		} elseif($this->is_remembered() == true) {
     | 
  
  
    | 
      90
     | 
    
      			// User has been "remembered"
 
     | 
  
  
    | 
      91
     | 
    
      			// Get the users password
 
     | 
  
  
    | 
      92
     | 
    
      			$database = new database();
 
     | 
  
  
    | 
      93
     | 
    
      			$query_details = $database->query("SELECT * FROM ".$this->USERS_TABLE." WHERE user_id = '".$this->get_safe_remember_key()."' LIMIT 1");
     | 
  
  
    | 
      94
     | 
    
      			$fetch_details = $query_details->fetchRow();
 
     | 
  
  
    | 
      95
     | 
    
      			$this->username = $fetch_details['username'];
 
     | 
  
  
    | 
      96
     | 
    
      			$this->password = $fetch_details['password'];
 
     | 
  
  
    | 
      97
     | 
    
      			// Check if the user exists (authenticate them)
 
     | 
  
  
    | 
      98
     | 
    
      			if($this->authenticate()) {
     | 
  
  
    | 
      99
     | 
    
      				// Authentication successful
 
     | 
  
  
    | 
      100
     | 
    
      				header("Location: ".$this->url);
     | 
  
  
    | 
      101
     | 
    
      				exit(0);
 
     | 
  
  
    | 
      102
     | 
    
      			} else {
     | 
  
  
    | 
      103
     | 
    
      				$this->message = $MESSAGE['LOGIN']['AUTHENTICATION_FAILED'];
 
     | 
  
  
    | 
      104
     | 
    
      				$this->increase_attemps();
 
     | 
  
  
    | 
      105
     | 
    
      			}
 
     | 
  
  
    | 
      106
     | 
    
      		} elseif($this->username == '' AND $this->password == '') {
     | 
  
  
    | 
      107
     | 
    
      			$this->message = $MESSAGE['LOGIN']['BOTH_BLANK'];
 
     | 
  
  
    | 
      108
     | 
    
      			$this->increase_attemps();
 
     | 
  
  
    | 
      109
     | 
    
      		} elseif($this->username == '') {
     | 
  
  
    | 
      110
     | 
    
      			$this->message = $MESSAGE['LOGIN']['USERNAME_BLANK'];
 
     | 
  
  
    | 
      111
     | 
    
      			$this->increase_attemps();
 
     | 
  
  
    | 
      112
     | 
    
      		} elseif($this->password == '') {
     | 
  
  
    | 
      113
     | 
    
      			$this->message = $MESSAGE['LOGIN']['PASSWORD_BLANK'];
 
     | 
  
  
    | 
      114
     | 
    
      			$this->increase_attemps();
 
     | 
  
  
    | 
      115
     | 
    
      		} elseif($this->username_len < $config_array['MIN_USERNAME_LEN']) {
     | 
  
  
    | 
      116
     | 
    
      			$this->message = $MESSAGE['LOGIN']['USERNAME_TOO_SHORT'];
 
     | 
  
  
    | 
      117
     | 
    
      			$this->increase_attemps();
 
     | 
  
  
    | 
      118
     | 
    
      		} elseif($this->password_len < $config_array['MIN_PASSWORD_LEN']) {
     | 
  
  
    | 
      119
     | 
    
      			$this->message = $MESSAGE['LOGIN']['PASSWORD_TOO_SHORT'];
 
     | 
  
  
    | 
      120
     | 
    
      			$this->increase_attemps();
 
     | 
  
  
    | 
      121
     | 
    
      		} elseif($this->username_len > $config_array['MAX_USERNAME_LEN']) {
     | 
  
  
    | 
      122
     | 
    
      			$this->message = $MESSAGE['LOGIN']['USERNAME_TOO_LONG'];
 
     | 
  
  
    | 
      123
     | 
    
      			$this->increase_attemps();
 
     | 
  
  
    | 
      124
     | 
    
      		} elseif($this->password_len > $config_array['MAX_PASSWORD_LEN']) {
     | 
  
  
    | 
      125
     | 
    
      			$this->message = $MESSAGE['LOGIN']['PASSWORD_TOO_LONG'];
 
     | 
  
  
    | 
      126
     | 
    
      			$this->increase_attemps();
 
     | 
  
  
    | 
      127
     | 
    
      		} else {
     | 
  
  
    | 
      128
     | 
    
      			// Check if the user exists (authenticate them)
 
     | 
  
  
    | 
      129
     | 
    
      			$this->password = md5($this->password);
 
     | 
  
  
    | 
      130
     | 
    
      			if($this->authenticate()) {
     | 
  
  
    | 
      131
     | 
    
      				// Authentication successful
 
     | 
  
  
    | 
      132
     | 
    
      				//echo $this->url;exit();
 
     | 
  
  
    | 
      133
     | 
    
      				header("Location: ".$this->url);
     | 
  
  
    | 
      134
     | 
    
      				exit(0);
 
     | 
  
  
    | 
      135
     | 
    
      			} else {
     | 
  
  
    | 
      136
     | 
    
      				$this->message = $MESSAGE['LOGIN']['AUTHENTICATION_FAILED'];
 
     | 
  
  
    | 
      137
     | 
    
      				$this->increase_attemps();
 
     | 
  
  
    | 
      138
     | 
    
      			}
 
     | 
  
  
    | 
      139
     | 
    
      		}
 
     | 
  
  
    | 
      140
     | 
    
      	}
 
     | 
  
  
    | 
      141
     | 
    
      	
 
     | 
  
  
    | 
      142
     | 
    
      	// Authenticate the user (check if they exist in the database)
 
     | 
  
  
    | 
      143
     | 
    
      	function authenticate() {
     | 
  
  
    | 
      144
     | 
    
      		// Get user information
 
     | 
  
  
    | 
      145
     | 
    
      		$database = new database();
 
     | 
  
  
    | 
      146
     | 
    
      		$query = "SELECT * FROM ".$this->USERS_TABLE." WHERE username = '".$this->username."' AND password = '".$this->password."' AND active = '1'";
 
     | 
  
  
    | 
      147
     | 
    
      		$results = $database->query($query);
 
     | 
  
  
    | 
      148
     | 
    
      		$results_array = $results->fetchRow();
 
     | 
  
  
    | 
      149
     | 
    
      		$num_rows = $results->numRows();
 
     | 
  
  
    | 
      150
     | 
    
      		if($num_rows) {
     | 
  
  
    | 
      151
     | 
    
      			$user_id = $results_array['user_id'];
 
     | 
  
  
    | 
      152
     | 
    
      			$this->user_id = $user_id;
 
     | 
  
  
    | 
      153
     | 
    
      			$_SESSION['USER_ID'] = $user_id;
 
     | 
  
  
    | 
      154
     | 
    
      			$_SESSION['GROUP_ID'] = $results_array['group_id'];
 
     | 
  
  
    | 
      155
     | 
    
      			$_SESSION['GROUPS_ID'] = $results_array['groups_id'];
 
     | 
  
  
    | 
      156
     | 
    
      			$_SESSION['USERNAME'] = $results_array['username'];
 
     | 
  
  
    | 
      157
     | 
    
      			$_SESSION['DISPLAY_NAME'] = $results_array['display_name'];
 
     | 
  
  
    | 
      158
     | 
    
      			$_SESSION['EMAIL'] = $results_array['email'];
 
     | 
  
  
    | 
      159
     | 
    
      			$_SESSION['HOME_FOLDER'] = $results_array['home_folder'];
 
     | 
  
  
    | 
      160
     | 
    
      			// Run remember function if needed
 
     | 
  
  
    | 
      161
     | 
    
      			if($this->remember == true) {
     | 
  
  
    | 
      162
     | 
    
      				$this->remember($this->user_id);
 
     | 
  
  
    | 
      163
     | 
    
      			}
 
     | 
  
  
    | 
      164
     | 
    
      			// Set language
 
     | 
  
  
    | 
      165
     | 
    
      			if($results_array['language'] != '') {
     | 
  
  
    | 
      166
     | 
    
      				$_SESSION['LANGUAGE'] = $results_array['language'];
 
     | 
  
  
    | 
      167
     | 
    
      			}
 
     | 
  
  
    | 
      168
     | 
    
      			// Set timezone
 
     | 
  
  
    | 
      169
     | 
    
      			if($results_array['timezone'] != '-72000') {
     | 
  
  
    | 
      170
     | 
    
      				$_SESSION['TIMEZONE'] = $results_array['timezone'];
 
     | 
  
  
    | 
      171
     | 
    
      			} else {
     | 
  
  
    | 
      172
     | 
    
      				// Set a session var so apps can tell user is using default tz
 
     | 
  
  
    | 
      173
     | 
    
      				$_SESSION['USE_DEFAULT_TIMEZONE'] = true;
 
     | 
  
  
    | 
      174
     | 
    
      			}
 
     | 
  
  
    | 
      175
     | 
    
      			// Set date format
 
     | 
  
  
    | 
      176
     | 
    
      			if($results_array['date_format'] != '') {
     | 
  
  
    | 
      177
     | 
    
      				$_SESSION['DATE_FORMAT'] = $results_array['date_format'];
 
     | 
  
  
    | 
      178
     | 
    
      			} else {
     | 
  
  
    | 
      179
     | 
    
      				// Set a session var so apps can tell user is using default date format
 
     | 
  
  
    | 
      180
     | 
    
      				$_SESSION['USE_DEFAULT_DATE_FORMAT'] = true;
 
     | 
  
  
    | 
      181
     | 
    
      			}
 
     | 
  
  
    | 
      182
     | 
    
      			// Set time format
 
     | 
  
  
    | 
      183
     | 
    
      			if($results_array['time_format'] != '') {
     | 
  
  
    | 
      184
     | 
    
      				$_SESSION['TIME_FORMAT'] = $results_array['time_format'];
 
     | 
  
  
    | 
      185
     | 
    
      			} else {
     | 
  
  
    | 
      186
     | 
    
      				// Set a session var so apps can tell user is using default time format
 
     | 
  
  
    | 
      187
     | 
    
      				$_SESSION['USE_DEFAULT_TIME_FORMAT'] = true;
 
     | 
  
  
    | 
      188
     | 
    
      			}
 
     | 
  
  
    | 
      189
     | 
    
      			// Get group information
 
     | 
  
  
    | 
      190
     | 
    
      //			$query = "SELECT * FROM ".$this->GROUPS_TABLE." WHERE group_id = '".$this->get_session('GROUP_ID')."'";
     | 
  
  
    | 
      191
     | 
    
      //			$results = $database->query($query);
 
     | 
  
  
    | 
      192
     | 
    
      //			$results_array = $results->fetchRow();
 
     | 
  
  
    | 
      193
     | 
    
      //			$_SESSION['GROUP_NAME'] = $results_array['name'];
 
     | 
  
  
    | 
      194
     | 
    
      //			// Set system permissions
 
     | 
  
  
    | 
      195
     | 
    
      //			if($results_array['system_permissions'] != '') {
     | 
  
  
    | 
      196
     | 
    
      //				$_SESSION['SYSTEM_PERMISSIONS'] = explode(',', $results_array['system_permissions']);
     | 
  
  
    | 
      197
     | 
    
      //			} else {
     | 
  
  
    | 
      198
     | 
    
      //				$_SESSION['SYSTEM_PERMISSIONS'] = array();
 
     | 
  
  
    | 
      199
     | 
    
      //			}
 
     | 
  
  
    | 
      200
     | 
    
      //			// Set module permissions
 
     | 
  
  
    | 
      201
     | 
    
      //			if($results_array['module_permissions'] != '') {
     | 
  
  
    | 
      202
     | 
    
      //				$_SESSION['MODULE_PERMISSIONS'] = explode(',', $results_array['module_permissions']);
     | 
  
  
    | 
      203
     | 
    
      //			} else {
     | 
  
  
    | 
      204
     | 
    
      //				$_SESSION['MODULE_PERMISSIONS'] = array();
 
     | 
  
  
    | 
      205
     | 
    
      //			}
 
     | 
  
  
    | 
      206
     | 
    
      //			// Set template permissions
 
     | 
  
  
    | 
      207
     | 
    
      //			if($results_array['template_permissions'] != '') {
     | 
  
  
    | 
      208
     | 
    
      //				$_SESSION['TEMPLATE_PERMISSIONS'] = explode(',', $results_array['template_permissions']);
     | 
  
  
    | 
      209
     | 
    
      //			} else {
     | 
  
  
    | 
      210
     | 
    
      //				$_SESSION['TEMPLATE_PERMISSIONS'] = array();
 
     | 
  
  
    | 
      211
     | 
    
      //			}
 
     | 
  
  
    | 
      212
     | 
    
      
 
     | 
  
  
    | 
      213
     | 
    
      			$_SESSION['SYSTEM_PERMISSIONS'] = array();
 
     | 
  
  
    | 
      214
     | 
    
      			$_SESSION['MODULE_PERMISSIONS'] = array();
 
     | 
  
  
    | 
      215
     | 
    
      			$_SESSION['TEMPLATE_PERMISSIONS'] = array();
 
     | 
  
  
    | 
      216
     | 
    
      			$_SESSION['GROUP_NAME'] = array();
 
     | 
  
  
    | 
      217
     | 
    
      
 
     | 
  
  
    | 
      218
     | 
    
      			$first_group = true;
 
     | 
  
  
    | 
      219
     | 
    
      			foreach (explode(",", $this->get_session('GROUPS_ID')) as $cur_group_id)
     | 
  
  
    | 
      220
     | 
    
                  {
     | 
  
  
    | 
      221
     | 
    
      				$query = "SELECT * FROM ".$this->GROUPS_TABLE." WHERE group_id = '".$cur_group_id."'";
 
     | 
  
  
    | 
      222
     | 
    
      				$results = $database->query($query);
 
     | 
  
  
    | 
      223
     | 
    
      				$results_array = $results->fetchRow();
 
     | 
  
  
    | 
      224
     | 
    
      				$_SESSION['GROUP_NAME'][$cur_group_id] = $results_array['name'];
 
     | 
  
  
    | 
      225
     | 
    
      				// Set system permissions
 
     | 
  
  
    | 
      226
     | 
    
      				if($results_array['system_permissions'] != '') {
     | 
  
  
    | 
      227
     | 
    
      					$_SESSION['SYSTEM_PERMISSIONS'] = array_merge($_SESSION['SYSTEM_PERMISSIONS'], explode(',', $results_array['system_permissions']));
     | 
  
  
    | 
      228
     | 
    
      				}
 
     | 
  
  
    | 
      229
     | 
    
      				// Set module permissions
 
     | 
  
  
    | 
      230
     | 
    
      				if($results_array['module_permissions'] != '') {
     | 
  
  
    | 
      231
     | 
    
      					if ($first_group) {
     | 
  
  
    | 
      232
     | 
    
                	$_SESSION['MODULE_PERMISSIONS'] = explode(',', $results_array['module_permissions']);
     | 
  
  
    | 
      233
     | 
    
                } else {
     | 
  
  
    | 
      234
     | 
    
                	$_SESSION['MODULE_PERMISSIONS'] = array_intersect($_SESSION['MODULE_PERMISSIONS'], explode(',', $results_array['module_permissions']));
     | 
  
  
    | 
      235
     | 
    
      					}
 
     | 
  
  
    | 
      236
     | 
    
      				}
 
     | 
  
  
    | 
      237
     | 
    
      				// Set template permissions
 
     | 
  
  
    | 
      238
     | 
    
      				if($results_array['template_permissions'] != '') {
     | 
  
  
    | 
      239
     | 
    
      					if ($first_group) {
     | 
  
  
    | 
      240
     | 
    
                	$_SESSION['TEMPLATE_PERMISSIONS'] = explode(',', $results_array['template_permissions']);
     | 
  
  
    | 
      241
     | 
    
                } else {
     | 
  
  
    | 
      242
     | 
    
                	$_SESSION['TEMPLATE_PERMISSIONS'] = array_intersect($_SESSION['TEMPLATE_PERMISSIONS'], explode(',', $results_array['template_permissions']));
     | 
  
  
    | 
      243
     | 
    
      					}
 
     | 
  
  
    | 
      244
     | 
    
      				}
 
     | 
  
  
    | 
      245
     | 
    
      				$first_group = false;
 
     | 
  
  
    | 
      246
     | 
    
      			}	
 
     | 
  
  
    | 
      247
     | 
    
      
 
     | 
  
  
    | 
      248
     | 
    
      			// Update the users table with current ip and timestamp
 
     | 
  
  
    | 
      249
     | 
    
      			$get_ts = time();
 
     | 
  
  
    | 
      250
     | 
    
      			$get_ip = $_SERVER['REMOTE_ADDR'];
 
     | 
  
  
    | 
      251
     | 
    
      			$query = "UPDATE ".$this->USERS_TABLE." SET login_when = '$get_ts', login_ip = '$get_ip' WHERE user_id = '$user_id'";
 
     | 
  
  
    | 
      252
     | 
    
      			$database->query($query);
 
     | 
  
  
    | 
      253
     | 
    
      		}
 
     | 
  
  
    | 
      254
     | 
    
      		// Return if the user exists or not
 
     | 
  
  
    | 
      255
     | 
    
      		return $num_rows;
 
     | 
  
  
    | 
      256
     | 
    
      	}
 
     | 
  
  
    | 
      257
     | 
    
      	
 
     | 
  
  
    | 
      258
     | 
    
      	// Increase the count for login attemps
 
     | 
  
  
    | 
      259
     | 
    
      	function increase_attemps() {
     | 
  
  
    | 
      260
     | 
    
      		if(!isset($_SESSION['ATTEMPS'])) {
     | 
  
  
    | 
      261
     | 
    
      			$_SESSION['ATTEMPS'] = 0;
 
     | 
  
  
    | 
      262
     | 
    
      		} else {
     | 
  
  
    | 
      263
     | 
    
      			$_SESSION['ATTEMPS'] = $this->get_session('ATTEMPS')+1;
     | 
  
  
    | 
      264
     | 
    
      		}
 
     | 
  
  
    | 
      265
     | 
    
      		$this->display_login();
 
     | 
  
  
    | 
      266
     | 
    
      	}
 
     | 
  
  
    | 
      267
     | 
    
      	
 
     | 
  
  
    | 
      268
     | 
    
      	// Function to set a "remembering" cookie for the user
 
     | 
  
  
    | 
      269
     | 
    
      	function remember($user_id) {
     | 
  
  
    | 
      270
     | 
    
      		$remember_key = '';
 
     | 
  
  
    | 
      271
     | 
    
      		// Generate user id to append to the remember key
 
     | 
  
  
    | 
      272
     | 
    
      		$length = 11-strlen($user_id);
 
     | 
  
  
    | 
      273
     | 
    
      		if($length > 0) {
     | 
  
  
    | 
      274
     | 
    
      			for($i = 1; $i <= $length; $i++) {
     | 
  
  
    | 
      275
     | 
    
      				$remember_key .= '0';
 
     | 
  
  
    | 
      276
     | 
    
      			}
 
     | 
  
  
    | 
      277
     | 
    
      		}
 
     | 
  
  
    | 
      278
     | 
    
      		// Generate remember key
 
     | 
  
  
    | 
      279
     | 
    
      		$remember_key .= $user_id.'_';
 
     | 
  
  
    | 
      280
     | 
    
      		$salt = "abchefghjkmnpqrstuvwxyz0123456789";
 
     | 
  
  
    | 
      281
     | 
    
      		srand((double)microtime()*1000000);
 
     | 
  
  
    | 
      282
     | 
    
      		$i = 0;
 
     | 
  
  
    | 
      283
     | 
    
      		while ($i <= 10) {
     | 
  
  
    | 
      284
     | 
    
      			$num = rand() % 33;
 
     | 
  
  
    | 
      285
     | 
    
      			$tmp = substr($salt, $num, 1);
 
     | 
  
  
    | 
      286
     | 
    
      			$remember_key = $remember_key . $tmp;
 
     | 
  
  
    | 
      287
     | 
    
      			$i++;
 
     | 
  
  
    | 
      288
     | 
    
      		}
 
     | 
  
  
    | 
      289
     | 
    
      		$remember_key = $remember_key;
 
     | 
  
  
    | 
      290
     | 
    
      		// Update the remember key in the db
 
     | 
  
  
    | 
      291
     | 
    
      		$database = new database();
 
     | 
  
  
    | 
      292
     | 
    
      		$database->query("UPDATE ".$this->USERS_TABLE." SET remember_key = '$remember_key' WHERE user_id = '$user_id' LIMIT 1");
     | 
  
  
    | 
      293
     | 
    
      		if($database->is_error()) {
     | 
  
  
    | 
      294
     | 
    
      			return false;
 
     | 
  
  
    | 
      295
     | 
    
      		} else {
     | 
  
  
    | 
      296
     | 
    
      			// Workout options for the cookie
 
     | 
  
  
    | 
      297
     | 
    
      			$cookie_name = 'REMEMBER_KEY';
 
     | 
  
  
    | 
      298
     | 
    
      			$cookie_value = $remember_key;
 
     | 
  
  
    | 
      299
     | 
    
      			$cookie_expire = time()+60*60*24*30;
 
     | 
  
  
    | 
      300
     | 
    
      			// Set the cookie
 
     | 
  
  
    | 
      301
     | 
    
      			if(setcookie($cookie_name, $cookie_value, $cookie_expire, '/')) {
     | 
  
  
    | 
      302
     | 
    
      				return true;
 
     | 
  
  
    | 
      303
     | 
    
      			} else {
     | 
  
  
    | 
      304
     | 
    
      				return false;
 
     | 
  
  
    | 
      305
     | 
    
      			}
 
     | 
  
  
    | 
      306
     | 
    
      		}
 
     | 
  
  
    | 
      307
     | 
    
      	}
 
     | 
  
  
    | 
      308
     | 
    
      	
 
     | 
  
  
    | 
      309
     | 
    
      	// Function to check if a user has been remembered
 
     | 
  
  
    | 
      310
     | 
    
      	function is_remembered() {
     | 
  
  
    | 
      311
     | 
    
      		if(isset($_COOKIE['REMEMBER_KEY']) AND $_COOKIE['REMEMBER_KEY'] != '') {
     | 
  
  
    | 
      312
     | 
    
      			// Check if the remember key is correct
 
     | 
  
  
    | 
      313
     | 
    
      			$database = new database();
 
     | 
  
  
    | 
      314
     | 
    
      			$sql = "SELECT `user_id` FROM `" . $this->USERS_TABLE . "` WHERE `remember_key` = '";
 
     | 
  
  
    | 
      315
     | 
    
      			$sql .= $this->get_safe_remember_key() . "' LIMIT 1";
 
     | 
  
  
    | 
      316
     | 
    
      			$check_query = $database->query($sql);
 
     | 
  
  
    | 
      317
     | 
    
      
 
     | 
  
  
    | 
      318
     | 
    
      			if($check_query->numRows() > 0) {
     | 
  
  
    | 
      319
     | 
    
      				$check_fetch = $check_query->fetchRow();
 
     | 
  
  
    | 
      320
     | 
    
      				$user_id = $check_fetch['user_id'];
 
     | 
  
  
    | 
      321
     | 
    
      				// Check the remember key prefix
 
     | 
  
  
    | 
      322
     | 
    
      				$remember_key_prefix = '';
 
     | 
  
  
    | 
      323
     | 
    
      				$length = 11-strlen($user_id);
 
     | 
  
  
    | 
      324
     | 
    
      				if($length > 0) {
     | 
  
  
    | 
      325
     | 
    
      					for($i = 1; $i <= $length; $i++) {
     | 
  
  
    | 
      326
     | 
    
      						$remember_key_prefix .= '0';
 
     | 
  
  
    | 
      327
     | 
    
      					}
 
     | 
  
  
    | 
      328
     | 
    
      				}
 
     | 
  
  
    | 
      329
     | 
    
      				$remember_key_prefix .= $user_id.'_';
 
     | 
  
  
    | 
      330
     | 
    
      				$length = strlen($remember_key_prefix);
 
     | 
  
  
    | 
      331
     | 
    
      				if(substr($_COOKIE['REMEMBER_KEY'], 0, $length) == $remember_key_prefix) {
     | 
  
  
    | 
      332
     | 
    
      					return true;
 
     | 
  
  
    | 
      333
     | 
    
      				} else {
     | 
  
  
    | 
      334
     | 
    
      					return false;
 
     | 
  
  
    | 
      335
     | 
    
      				}
 
     | 
  
  
    | 
      336
     | 
    
      			} else {
     | 
  
  
    | 
      337
     | 
    
      				return false;
 
     | 
  
  
    | 
      338
     | 
    
      			}
 
     | 
  
  
    | 
      339
     | 
    
      		} else {
     | 
  
  
    | 
      340
     | 
    
      			return false;
 
     | 
  
  
    | 
      341
     | 
    
      		}
 
     | 
  
  
    | 
      342
     | 
    
      	}
 
     | 
  
  
    | 
      343
     | 
    
      	
 
     | 
  
  
    | 
      344
     | 
    
      	// Display the login screen
 
     | 
  
  
    | 
      345
     | 
    
      	function display_login() {
     | 
  
  
    | 
      346
     | 
    
      		// Get language vars
 
     | 
  
  
    | 
      347
     | 
    
      		global $MESSAGE;
 
     | 
  
  
    | 
      348
     | 
    
      		global $MENU;
 
     | 
  
  
    | 
      349
     | 
    
      		global $TEXT;
 
     | 
  
  
    | 
      350
     | 
    
      		// If attemps more than allowed, warn the user
 
     | 
  
  
    | 
      351
     | 
    
      		if($this->get_session('ATTEMPS') > $this->max_attemps) {
     | 
  
  
    | 
      352
     | 
    
      			$this->warn();
 
     | 
  
  
    | 
      353
     | 
    
      		}
 
     | 
  
  
    | 
      354
     | 
    
      		// Show the login form
 
     | 
  
  
    | 
      355
     | 
    
      		if($this->frontend != true) {
     | 
  
  
    | 
      356
     | 
    
      			require_once(WB_PATH.'/include/phplib/template.inc');
 
     | 
  
  
    | 
      357
     | 
    
      			$template = new Template($this->template_dir);
 
     | 
  
  
    | 
      358
     | 
    
      			$template->set_file('page', $this->template_file);
     | 
  
  
    | 
      359
     | 
    
      			$template->set_block('page', 'mainBlock', 'main');
     | 
  
  
    | 
      360
     | 
    
      			if($this->remember_me_option != true) {
     | 
  
  
    | 
      361
     | 
    
      				$template->set_var('DISPLAY_REMEMBER_ME', 'display: none;');
     | 
  
  
    | 
      362
     | 
    
      			} else {
     | 
  
  
    | 
      363
     | 
    
      				$template->set_var('DISPLAY_REMEMBER_ME', '');
     | 
  
  
    | 
      364
     | 
    
      			}
 
     | 
  
  
    | 
      365
     | 
    
      			$template->set_var(array(
 
     | 
  
  
    | 
      366
     | 
    
      											'ACTION_URL' => $this->login_url,
 
     | 
  
  
    | 
      367
     | 
    
      											'ATTEMPS' => $this->get_session('ATTEMPS'),
     | 
  
  
    | 
      368
     | 
    
      											'USERNAME' => $this->username,
 
     | 
  
  
    | 
      369
     | 
    
      											'USERNAME_FIELDNAME' => $this->username_fieldname,
 
     | 
  
  
    | 
      370
     | 
    
      											'PASSWORD_FIELDNAME' => $this->password_fieldname,
 
     | 
  
  
    | 
      371
     | 
    
      											'MESSAGE' => $this->message,
 
     | 
  
  
    | 
      372
     | 
    
      											'INTERFACE_DIR_URL' =>  ADMIN_URL.'/interface',
 
     | 
  
  
    | 
      373
     | 
    
      											'MAX_USERNAME_LEN' => $this->max_username_len,
 
     | 
  
  
    | 
      374
     | 
    
      											'MAX_PASSWORD_LEN' => $this->max_password_len,
 
     | 
  
  
    | 
      375
     | 
    
      											'WB_URL' => WB_URL,
 
     | 
  
  
    | 
      376
     | 
    
      											'THEME_URL' => THEME_URL,
 
     | 
  
  
    | 
      377
     | 
    
                                                  'VERSION' => VERSION,
 
     | 
  
  
    | 
      378
     | 
    
                                                  'REVISION' => REVISION,
 
     | 
  
  
    | 
      379
     | 
    
      											'LANGUAGE' => strtolower(LANGUAGE),
 
     | 
  
  
    | 
      380
     | 
    
      											'FORGOTTEN_DETAILS_APP' => $this->forgotten_details_app,
 
     | 
  
  
    | 
      381
     | 
    
      											'TEXT_FORGOTTEN_DETAILS' => $TEXT['FORGOTTEN_DETAILS'],
 
     | 
  
  
    | 
      382
     | 
    
      											'TEXT_USERNAME' => $TEXT['USERNAME'],
 
     | 
  
  
    | 
      383
     | 
    
      											'TEXT_PASSWORD' => $TEXT['PASSWORD'],
 
     | 
  
  
    | 
      384
     | 
    
      											'TEXT_REMEMBER_ME' => $TEXT['REMEMBER_ME'],
 
     | 
  
  
    | 
      385
     | 
    
      											'TEXT_LOGIN' => $TEXT['LOGIN'],
 
     | 
  
  
    | 
      386
     | 
    
      											'TEXT_HOME' => $TEXT['HOME'],
 
     | 
  
  
    | 
      387
     | 
    
      											'PAGES_DIRECTORY' => PAGES_DIRECTORY,
 
     | 
  
  
    | 
      388
     | 
    
      											'SECTION_LOGIN' => $MENU['LOGIN']
 
     | 
  
  
    | 
      389
     | 
    
      											)
 
     | 
  
  
    | 
      390
     | 
    
      									);
 
     | 
  
  
    | 
      391
     | 
    
      			if(defined('DEFAULT_CHARSET')) {
     | 
  
  
    | 
      392
     | 
    
      				$charset=DEFAULT_CHARSET;
 
     | 
  
  
    | 
      393
     | 
    
      			} else {
     | 
  
  
    | 
      394
     | 
    
      				$charset='utf-8';
 
     | 
  
  
    | 
      395
     | 
    
      			}
 
     | 
  
  
    | 
      396
     | 
    
      			
 
     | 
  
  
    | 
      397
     | 
    
      			$template->set_var('CHARSET', $charset);	
     | 
  
  
    | 
      398
     | 
    
      									
 
     | 
  
  
    | 
      399
     | 
    
      									
 
     | 
  
  
    | 
      400
     | 
    
      			$template->parse('main', 'mainBlock', false);
     | 
  
  
    | 
      401
     | 
    
      			$template->pparse('output', 'page');
     | 
  
  
    | 
      402
     | 
    
      		}
 
     | 
  
  
    | 
      403
     | 
    
      	}
 
     | 
  
  
    | 
      404
     | 
    
      
 
     | 
  
  
    | 
      405
     | 
    
      	// sanities the REMEMBER_KEY cookie to avoid SQL injection
 
     | 
  
  
    | 
      406
     | 
    
      	function get_safe_remember_key() {
     | 
  
  
    | 
      407
     | 
    
      		if (!((strlen($_COOKIE['REMEMBER_KEY']) == 23) && (substr($_COOKIE['REMEMBER_KEY'], 11, 1) == '_'))) return '';
 
     | 
  
  
    | 
      408
     | 
    
      		// create a clean cookie (XXXXXXXXXXX_YYYYYYYYYYY) where X:= numeric, Y:= hash
 
     | 
  
  
    | 
      409
     | 
    
      		$clean_cookie = sprintf('%011d', (int) substr($_COOKIE['REMEMBER_KEY'], 0, 11)) . substr($_COOKIE['REMEMBER_KEY'], 11);
     | 
  
  
    | 
      410
     | 
    
      		return ($clean_cookie == $_COOKIE['REMEMBER_KEY']) ? $this->add_slashes($clean_cookie) : '';
 
     | 
  
  
    | 
      411
     | 
    
      	}
 
     | 
  
  
    | 
      412
     | 
    
      	
 
     | 
  
  
    | 
      413
     | 
    
      	// Warn user that they have had to many login attemps
 
     | 
  
  
    | 
      414
     | 
    
      	function warn() {
     | 
  
  
    | 
      415
     | 
    
      		header('Location: '.$this->warning_url);
     | 
  
  
    | 
      416
     | 
    
      		exit(0);
 
     | 
  
  
    | 
      417
     | 
    
      	}
 
     | 
  
  
    | 
      418
     | 
    
      	
 
     | 
  
  
    | 
      419
     | 
    
      }
 
     | 
  
  
    | 
      420
     | 
    
      
 
     | 
  
  
    | 
      421
     | 
    
      ?>
 
     |