Merge branch 'stable-3.1'

Marius Burkard

2016-07-10 e1ceb050e19c7574bca146a8da7047ee4ff456b5

 interface/web/login/index.php

@@ -1,7 +1,7 @@
<?php

/*
Copyright (c) 2005, Till Brehm, projektfarm Gmbh
Copyright (c) 2005 - 2015, Till Brehm, ISPConfig UG
All rights reserved.

Redistribution and use in source and binary forms, with or without modification,
@@ -28,232 +28,333 @@
EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
*/

//
require_once '../../lib/config.inc.php';
require_once '../../lib/app.inc.php';

class login_index {
// Check if we have an active users ession and no login_as.
if($_SESSION['s']['user']['active'] == 1 && @$_POST['login_as'] != 1) {
   header('Location: /index.php');
   die();
}

   public $status = '';
   private $target = '';
   private $app;
   private $conf;
	
   public function render() {
		
      global $app, $conf;
		
      /* Redirect to page, if login form was NOT send */
      if(count($_POST) == 0) {
         if(isset($_SESSION['s']['user']) && is_array($_SESSION['s']['user']) && is_array($_SESSION['s']['module'])) {
            die('HEADER_REDIRECT:'.$_SESSION['s']['module']['startpage']);
         }
      }
		
      $app->uses('tpl');
      $app->tpl->newTemplate('form.tpl.htm');
	    
       $error = '';
		
      $app->load_language_file('web/login/lib/lang/'.$conf["language"].'.lng');
		
      // Maintenance mode
      $maintenance_mode = false;
      $maintenance_mode_error = '';
      $app->uses('ini_parser,getconf');
      $server_config_array = $app->getconf->get_global_config('misc');
      if($server_config_array['maintenance_mode'] == 'y'){
         $maintenance_mode = true;
         $maintenance_mode_error = $app->lng('error_maintenance_mode');
      }
	
      //* Login Form was send
      if(count($_POST) > 0) {
			
         //** Check variables
         if(!preg_match("/^[\w\.\-\_\@]{1,128}$/", $_POST['username'])) $error = $app->lng('user_regex_error');
         if(!preg_match("/^.{1,64}$/i", $_POST['passwort'])) $error = $app->lng('pw_error_length');
			
           //** iporting variables
           $ip      = $app->db->quote(ip2long($_SERVER['REMOTE_ADDR']));
           $username = $app->db->quote($_POST['username']);
           $passwort = $app->db->quote($_POST['passwort']);
         $loginAs  = false;
         $time = time();
	
           if($username != '' && $passwort != '' && $error == '') {
$app->uses('tpl');
$app->tpl->newTemplate('main_login.tpl.htm');
$app->tpl->setInclude('content_tpl', 'templates/index.htm');

$error = '';

$app->load_language_file('web/login/lib/lang/'.$conf["language"].'.lng');

// Maintenance mode
$maintenance_mode = false;
$maintenance_mode_error = '';
$app->uses('ini_parser,getconf');
$server_config_array = $app->getconf->get_global_config('misc');
if($server_config_array['maintenance_mode'] == 'y'){
   $maintenance_mode = true;
   $maintenance_mode_error = $app->lng('error_maintenance_mode');
}

//* Login Form was sent
if(count($_POST) > 0) {

   //** Check variables
   if(!preg_match("/^[\w\.\-\_\@]{1,128}$/", $_POST['username'])) $error = $app->lng('user_regex_error');
   if(!preg_match("/^.{1,256}$/i", $_POST['password'])) $error = $app->lng('pw_error_length');

   //** importing variables
   $ip    = ip2long($_SERVER['REMOTE_ADDR']);
   $username = $_POST['username'];
   $password = $_POST['password'];
   $loginAs  = false;
   $time = time();

   if($username != '' && $password != '' && $error == '') {
      /*
       *  Check, if there is a "login as" instead of a "normal" login
       */
      if (isset($_SESSION['s']['user']) && $_SESSION['s']['user']['active'] == 1){
         /*
          * only the admin or reseller can "login as" so if the user is NOT an admin or reseller, we
          * open the startpage (after killing the old session), so the user
          * is logout and has to start again!
          */
         if ($_SESSION['s']['user']['typ'] != 'admin' && !$app->auth->has_clients($_SESSION['s']['user']['userid'])) {
            /*
             *  Check, if there is a "login as" instead of a "normal" login
             * The actual user is NOT a admin or reseller, but maybe he
             * has logged in as "normal" user before...
             */
            if (isset($_SESSION['s']['user']) && $_SESSION['s']['user']['active'] == 1){
               /*
                * only the admin can "login as" so if the user is NOT a admin, we
                * open the startpage (after killing the old session), so the user
                * is logout and has to start again!
				
            if (isset($_SESSION['s_old'])&& ($_SESSION['s_old']['user']['typ'] == 'admin' || $app->auth->has_clients($_SESSION['s_old']['user']['userid']))){
               /* The "old" user is admin or reseller, so everything is ok
                * if he is reseller, we need to check if he logs in to one of his clients
                */
               if ($_SESSION['s']['user']['typ'] != 'admin') {
                  /*
                   * The actual user is NOT a admin, but maybe the admin
                   * has logged in as "normal" user bevore...
                   */
                  if (isset($_SESSION['s_old'])&& ($_SESSION['s_old']['user']['typ'] == 'admin')){
                     /* The "old" user is admin, so everything is ok */
               if($_SESSION['s_old']['user']['typ'] != 'admin') {
						
                  /* this is the one currently logged in (normal user) */
                  $old_client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
                  $old_client = $app->db->queryOneRecord("SELECT client.client_id, client.parent_client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $old_client_group_id);
						
                  /* this is the reseller, that shall be re-logged in */
                  $sql = "SELECT * FROM sys_user WHERE USERNAME = ? and PASSWORT = ?";
                  $tmp = $app->db->queryOneRecord($sql, $username, $password);
                  $client_group_id = $app->functions->intval($tmp['default_group']);
                  $tmp_client = $app->db->queryOneRecord("SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $client_group_id);
						
                  if(!$tmp_client || $old_client["parent_client_id"] != $tmp_client["client_id"] || $tmp["default_group"] != $_SESSION["s_old"]["user"]["default_group"] ) {
                     die("You don't have the right to 'login as' this user!");
                  }
                  else {
                     die("You don't have the right to 'login as'!");
                  }
                  unset($old_client);
                  unset($tmp_client);
                  unset($tmp);
               }
               $loginAs = true;
            }
            else {
               /* normal login */
               $loginAs = false;
               die("You don't have the right to 'login as'!");
            }
         } elseif($_SESSION['s']['user']['typ'] != 'admin' && (!isset($_SESSION['s_old']['user']) || $_SESSION['s_old']['user']['typ'] != 'admin')) {
            /* a reseller wants to 'login as', we need to check if he is allowed to */
            $res_client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]);
            $res_client = $app->db->queryOneRecord("SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $res_client_group_id);
				
            /* this is the user the reseller wants to 'login as' */
            $sql = "SELECT * FROM sys_user WHERE USERNAME = ? and PASSWORT = ?";
            $tmp = $app->db->queryOneRecord($sql, $username, $password);
            $tmp_client = $app->db->queryOneRecord("SELECT client.client_id, client.parent_client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = ?", $tmp["default_group"]);
				
            if(!$tmp || $tmp_client["parent_client_id"] != $res_client["client_id"]) {
               die("You don't have the right to login as this user!");
            }
            unset($res_client);
            unset($tmp);
            unset($tmp_client);
         }
         $loginAs = true;
			
      } else {
         /* normal login */
         $loginAs = false;
      }
		
      //* Check if there are already wrong logins
      $sql = "SELECT * FROM `attempts_login` WHERE `ip`= ? AND  `login_time` > (NOW() - INTERVAL 1 MINUTE) LIMIT 1";
      $alreadyfailed = $app->db->queryOneRecord($sql, $ip);
		
      //* too many failedlogins
      if($alreadyfailed['times'] > 5) {
         $error = $app->lng('error_user_too_many_logins');
      } else {

              //* Check if there are already wrong logins
              $sql = "SELECT * FROM `attempts_login` WHERE `ip`= '{$ip}' AND  `login_time` > (NOW() - INTERVAL 1 MINUTE) LIMIT 1";
              $alreadyfailed = $app->db->queryOneRecord($sql);
              //* login to much wrong
              if($alreadyfailed['times'] > 5) {
                 $error = $app->lng('error_user_too_many_logins');
              } else {
	        		
               if ($loginAs){
                    $sql = "SELECT * FROM sys_user WHERE USERNAME = '$username' and PASSWORT = '". $passwort. "'";
                  $user = $app->db->queryOneRecord($sql);
               } else {
                  if(stristr($username,'@')) {
                     //* mailuser login
                     $sql = "SELECT * FROM mail_user WHERE login = '$username'";
                     $mailuser = $app->db->queryOneRecord($sql);
                     $user = false;
                     if($mailuser) {
                        $saved_password = stripslashes($mailuser['password']);
                        $salt = '$1$'.substr($saved_password,3,8).'$';
                        //* Check if mailuser password is correct
                        if(crypt(stripslashes($passwort),$salt) == $saved_password) {
                           //* we build a fake user here which has access to the mailuser module only and userid 0
                           $user = array();
                           $user['userid'] = 0;
                           $user['active'] = 1;
                           $user['startmodule'] = 'mailuser';
                           $user['modules'] = 'mailuser';
                           $user['typ'] = 'user';
                           $user['email'] = $mailuser['email'];
                           $user['username'] = $username;
                           $user['language'] = $conf['language'];
                           $user['theme'] = $conf['theme'];
                           $user['mailuser_id'] = $mailuser['mailuser_id'];
                           $user['default_group'] = $mailuser['sys_groupid'];
                        }
         if ($loginAs){
            $sql = "SELECT * FROM sys_user WHERE USERNAME = ? and PASSWORT = ?";
            $user = $app->db->queryOneRecord($sql, $username, $password);
         } else {
			
            if(stristr($username, '@')) {
               //* mailuser login
               $sql = "SELECT * FROM mail_user WHERE login = ? or email = ?";
               $mailuser = $app->db->queryOneRecord($sql, $username, $username);
               $user = false;
               if($mailuser) {
                  $saved_password = stripslashes($mailuser['password']);
                  //* Check if mailuser password is correct
                  if(crypt(stripslashes($password), $saved_password) == $saved_password) {
                     //* we build a fake user here which has access to the mailuser module only and userid 0
                     $user = array();
                     $user['userid'] = 0;
                     $user['active'] = 1;
                     $user['startmodule'] = 'mailuser';
                     $user['modules'] = 'mailuser';
                     $user['typ'] = 'user';
                     $user['email'] = $mailuser['email'];
                     $user['username'] = $username;
                     $user['language'] = $conf['language'];
                     $user['theme'] = $conf['theme'];
                     $user['app_theme'] = $conf['theme'];
                     $user['mailuser_id'] = $mailuser['mailuser_id'];
                     $user['default_group'] = $mailuser['sys_groupid'];
                  }
               }
            } else {
               //* normal cp user login
               $sql = "SELECT * FROM sys_user WHERE USERNAME = ?";
               $user = $app->db->queryOneRecord($sql, $username);
               if($user) {
                  $saved_password = stripslashes($user['passwort']);
                  if(substr($saved_password, 0, 1) == '$') {
                     //* The password is encrypted with crypt
                     if(crypt(stripslashes($password), $saved_password) != $saved_password) {
                        $user = false;
                     }
							
                  } else {
                     //* normal cp user login
                     $sql = "SELECT * FROM sys_user WHERE USERNAME = '$username'";
                     $user = $app->db->queryOneRecord($sql);
							
                     if($user) {
                        $saved_password = stripslashes($user['passwort']);
							
                        if(substr($saved_password,0,3) == '$1$') {
                           //* The password is crypt-md5 encrypted
                           $salt = '$1$'.substr($saved_password,3,8).'$';
								
                           if(crypt(stripslashes($passwort),$salt) != $saved_password) {
                              $user = false;
                           }
                        } else {
								
                           //* The password is md5 encrypted
                           if(md5($passwort) != $saved_password) {
                              $user = false;
                           }
                        }
                     } else {
                     //* The password is md5 encrypted
                     if(md5($password) != $saved_password) {
                        $user = false;
                     }
                  }
               } else {
                  $user = false;
               }
		            
                  if($user) {
                      if($user['active'] == 1) {
                     // Maintenance mode - allow logins only when maintenance mode is off or if the user is admin
                     if(!$maintenance_mode || $user['typ'] == 'admin'){
                        // User login right, so attempts can be deleted
                        $sql = "DELETE FROM `attempts_login` WHERE `ip`='{$ip}'";
                        $app->db->query($sql);
                        $user = $app->db->toLower($user);
							
                        if ($loginAs) $oldSession = $_SESSION['s'];
                        $_SESSION = array();
                        if ($loginAs) $_SESSION['s_old'] = $oldSession; // keep the way back!
                        $_SESSION['s']['user'] = $user;
                        $_SESSION['s']['user']['theme'] = isset($user['app_theme']) ? $user['app_theme'] : 'default';
                        $_SESSION['s']['language'] = $user['language'];
                        $_SESSION["s"]['theme'] = $_SESSION['s']['user']['theme'];
										
                        if(is_file($_SESSION['s']['user']['startmodule'].'/lib/module.conf.php')) {
                           include_once($_SESSION['s']['user']['startmodule'].'/lib/module.conf.php');
                           $_SESSION['s']['module'] = $module;
                        }
							
                        $app->plugin->raiseEvent('login',$this);
							
                        /*
                        * We need LOGIN_REDIRECT instead of HEADER_REDIRECT to load the
                        * new theme, if the logged-in user has another
                        */
                        echo 'LOGIN_REDIRECT:'.$_SESSION['s']['module']['startpage'];
										
                        exit;
                     }
                      } else {
                         $error = $app->lng('error_user_blocked');
                      }
                 } else {
                    if(!$alreadyfailed['times'] )
                    {
                       //* user login the first time wrong
                       $sql = "INSERT INTO `attempts_login` (`ip`, `times`, `login_time`) VALUES ('{$ip}', 1, NOW())";
                       $app->db->query($sql);
                    } elseif($alreadyfailed['times'] >= 1) {
                       //* update times wrong
                       $sql = "UPDATE `attempts_login` SET `times`=`times`+1, `login_time`=NOW() WHERE `login_time` >= '{$time}' LIMIT 1";
                       $app->db->query($sql);
                    }
                     //* Incorrect login - Username and password incorrect
                      $error = $app->lng('error_user_password_incorrect');
                      if($app->db->errorMessage != '') $error .= '<br />'.$app->db->errorMessage != '';
            }
         }
			
         if($user) {
            if($user['active'] == 1) {
               // Maintenance mode - allow logins only when maintenance mode is off or if the user is admin
               if(!$maintenance_mode || $user['typ'] == 'admin'){
                  
                  $app->plugin->raiseEvent('login_failed',$this);	
                    }
              }
            } else {
                //* Username or password empty
               if($error == '') $error = $app->lng('error_user_password_empty');
				
            $app->plugin->raiseEvent('login_empty',$this);
           }
      }
		
      // Maintenance mode - show message when people try to log in and also when people are forcedly logged off
      if($maintenance_mode_error != '') $error = '<strong>'.$maintenance_mode_error.'</strong><br><br>'.$error;
      if($error != ''){
           $error = '<div class="box box_error"><h1>Error</h1>'.$error.'</div>';
      }
	
      $app->tpl->setVar('error', $error);
      $app->tpl->setVar('username_txt', $app->lng('username_txt'));
      $app->tpl->setVar('password_txt', $app->lng('password_txt'));
      $app->tpl->setVar('login_button_txt', $app->lng('login_button_txt'));
      $app->tpl->setInclude('content_tpl','login/templates/index.htm');
      $app->tpl_defaults();
		
      $this->status = 'OK';
		
      return $app->tpl->grab();
		
   } // << end function
                  // User login right, so attempts can be deleted
                  $sql = "DELETE FROM `attempts_login` WHERE `ip`=?";
                  $app->db->query($sql, $ip);
                  $user = $app->db->toLower($user);
						
                  if ($loginAs) $oldSession = $_SESSION['s'];
                  // Session regenerate causes login problems on some systems, have to find a better way. see Issue #3827
                  //if (!$loginAs) session_regenerate_id(true);
                  $_SESSION = array();
                  if ($loginAs) $_SESSION['s_old'] = $oldSession; // keep the way back!
                  $_SESSION['s']['user'] = $user;
                  $_SESSION['s']['user']['theme'] = isset($user['app_theme']) ? $user['app_theme'] : 'default';
                  $_SESSION['s']['language'] = $user['language'];
                  $_SESSION["s"]['theme'] = $_SESSION['s']['user']['theme'];
                  if ($loginAs) $_SESSION['s']['plugin_cache'] = $_SESSION['s_old']['plugin_cache'];
						
                  if(is_file(ISPC_WEB_PATH . '/' . $_SESSION['s']['user']['startmodule'].'/lib/module.conf.php')) {
                     include_once ISPC_WEB_PATH . '/' . $_SESSION['s']['user']['startmodule'].'/lib/module.conf.php';
                     $menu_dir = ISPC_WEB_PATH.'/' . $_SESSION['s']['user']['startmodule'] . '/lib/menu.d';
                        if (is_dir($menu_dir)) {
                        if ($dh = opendir($menu_dir)) {
                           //** Go through all files in the menu dir
                           while (($file = readdir($dh)) !== false) {
                              if ($file != '.' && $file != '..' && substr($file, -9, 9) == '.menu.php' && $file != 'dns_resync.menu.php') {
                                 include_once $menu_dir . '/' . $file;
                              }
                           }
                        }
                     }
                     $_SESSION['s']['module'] = $module;
                  }
                     // check if the user theme is valid
                  if($_SESSION['s']['user']['theme'] != 'default') {
                     $tmp_path = ISPC_THEMES_PATH."/".$_SESSION['s']['user']['theme'];
                     if(!@is_dir($tmp_path) || !@file_exists($tmp_path."/ispconfig_version") || trim(file_get_contents($tmp_path."/ispconfig_version")) != ISPC_APP_VERSION) {
                        // fall back to default theme if this one is not compatible with current ispc version
                        $_SESSION['s']['user']['theme'] = 'default';
                        $_SESSION['s']['theme'] = 'default';
                        $_SESSION['show_error_msg'] = $app->lng('theme_not_compatible');
                     }
                  }
						
                  $app->plugin->raiseEvent('login', $this);
						
                  //* Save successfull login message to var
                  $authlog = 'Successful login for user \''. $username .'\' from '. long2ip($ip) .' at '. date('Y-m-d H:i:s');
                  $authlog_handle = fopen($conf['ispconfig_log_dir'].'/auth.log', 'a');
                  fwrite($authlog_handle, $authlog ."\n");
                  fclose($authlog_handle);
						
                  /*
                  * We need LOGIN_REDIRECT instead of HEADER_REDIRECT to load the
                  * new theme, if the logged-in user has another
                  */
						
                  if ($loginAs){
                     echo 'LOGIN_REDIRECT:'.$_SESSION['s']['module']['startpage'];
                     exit;
                  } else {
                     header('Location: ../index.php');
                     die();
                  }
               }
            } else {
               $error = $app->lng('error_user_blocked');
            }
         } else {
            if(!$alreadyfailed['times'] )
            {
               //* user login the first time wrong
               $sql = "INSERT INTO `attempts_login` (`ip`, `times`, `login_time`) VALUES (?, 1, NOW())";
               $app->db->query($sql, $ip);
            } elseif($alreadyfailed['times'] >= 1) {
               //* update times wrong
               $sql = "UPDATE `attempts_login` SET `times`=`times`+1, `login_time`=NOW() WHERE `ip` = ? AND `login_time` < NOW() ORDER BY `login_time` DESC LIMIT 1";
               $app->db->query($sql, $ip);
            }
            //* Incorrect login - Username and password incorrect
            $error = $app->lng('error_user_password_incorrect');
            if($app->db->errorMessage != '') $error .= '<br />'.$app->db->errorMessage != '';

} // << end class
            $app->plugin->raiseEvent('login_failed', $this);
            //* Save failed login message to var
            $authlog = 'Failed login for user \''. $username .'\' from '. long2ip($ip) .' at '. date('Y-m-d H:i:s');
            $authlog_handle = fopen($conf['ispconfig_log_dir'].'/auth.log', 'a');
            fwrite($authlog_handle, $authlog ."\n");
            fclose($authlog_handle);
         }
      }
      } else {
      //* Username or password empty
      if($error == '') $error = $app->lng('error_user_password_empty');
         $app->plugin->raiseEvent('login_empty', $this);
   }
}

?>
// Maintenance mode - show message when people try to log in and also when people are forcedly logged off
if($maintenance_mode_error != '') $error = '<strong>'.$maintenance_mode_error.'</strong><br><br>'.$error;
if($error != ''){
   $error = '<div class="box box_error">'.$error.'</div>';
}

$app->load('getconf');
$sys_config = $app->getconf->get_global_config('misc');

$security_config = $app->getconf->get_security_config('permissions');
if($security_config['password_reset_allowed'] == 'yes') {
   $app->tpl->setVar('pw_lost_show', 1);
} else {
   $app->tpl->setVar('pw_lost_show', 0);
}
		
$app->tpl->setVar('error', $error);
$app->tpl->setVar('error_txt', $app->lng('error_txt'));
$app->tpl->setVar('login_txt', $app->lng('login_txt'));
$app->tpl->setVar('pw_lost_txt', $app->lng('pw_lost_txt'));
$app->tpl->setVar('username_txt', $app->lng('username_txt'));
$app->tpl->setVar('password_txt', $app->lng('password_txt'));
$app->tpl->setVar('stay_logged_in_txt', $app->lng('stay_logged_in_txt'));
$app->tpl->setVar('login_button_txt', $app->lng('login_button_txt'));
$app->tpl->setVar('session_timeout', $server_config_array['session_timeout']);
$app->tpl->setVar('session_allow_endless', $server_config_array['session_allow_endless']);
//$app->tpl->setInclude('content_tpl', 'login/templates/index.htm');
$app->tpl->setVar('current_theme', isset($_SESSION['s']['theme']) ? $_SESSION['s']['theme'] : 'default');
//die(isset($_SESSION['s']['theme']) ? $_SESSION['s']['theme'] : 'default');

// Logo
$logo = $app->db->queryOneRecord("SELECT * FROM sys_ini WHERE sysini_id = 1");
if($logo['custom_logo'] != ''){
   $base64_logo_txt = $logo['custom_logo'];
} else {
   $base64_logo_txt = $logo['default_logo'];
}
$tmp_base64 = explode(',', $base64_logo_txt, 2);
$logo_dimensions = $app->functions->getimagesizefromstring(base64_decode($tmp_base64[1]));
$app->tpl->setVar('base64_logo_width', $logo_dimensions[0].'px');
$app->tpl->setVar('base64_logo_height', $logo_dimensions[1].'px');
$app->tpl->setVar('base64_logo_txt', $base64_logo_txt);

// Title
if (!empty($sys_config['company_name'])) {
   $app->tpl->setVar('company_name', $sys_config['company_name']. ' :: ');
}

// Custom Login
if ($sys_config['custom_login_text'] != '') {
    $custom_login = @($sys_config['custom_login_link'] != '')?'<a href="'.$sys_config['custom_login_link'].'" target="_blank">'.$sys_config['custom_login_text'].'</a>':$sys_config['custom_login_text'];
}
$app->tpl->setVar('custom_login', $custom_login);

$app->tpl_defaults();

$app->tpl->pparse();

?>