query("SELECT user_code, user_login_cookies FROM system_user WHERE user_name = '".$user."' AND user_trash = '0' LIMIT 1") ; // check if username exists if ($mysqli_user->num_rows > 0){ // set query in variable $row_user = $mysqli_user->fetch_array(MYSQLI_ASSOC) ; // encode password with md5 + code $code = $row_user['user_code'] ; $password = md5(md5($password).$code) ; $login_cookies = $row_user['user_login_cookies'] ; $login_cookies = (trim($login_cookies) != '' ? $login_cookies : rand(100000,999999)) ; if ($system_login_cookies == $login_cookies && trim($system_login_cookies) != ''){ $query = '' ; $boolean_status = false ; } // check user login $mysqli_user = $mysqli->query("SELECT user_id, user_name, user_fullname, user_code, user_permission, user_branch, user_verification_type, user_visit_count FROM system_user WHERE user_name = '".$user."' AND user_password = '".$password."' ".$query." AND user_trash = '0' LIMIT 1") ; // check if username exists if ($mysqli_user->num_rows > 0){ // set query in variable $row_user = $mysqli_user->fetch_array(MYSQLI_ASSOC) ; // user id $user_id = $row_user['user_id'] ; $user_code = $row_user['user_code'] ; $visit_count = $row_user['user_visit_count'] ; $user_verification_type = $row_user['user_verification_type'] ; $visit_count++ ; $get_client_ip = get_client_ip() ; $get_user_agent = userAgent($_SERVER['HTTP_USER_AGENT']) ; // get user last login coordinates $latitude = escapeString($_POST['latitude']) ; $longtitude = escapeString($_POST['longtitude']) ; // check status if ($boolean_status){ $_SESSION['system_temp_user_name'] = $user ; // name $_SESSION['system_temp_password'] = $password2 ; // password $_SESSION['system_temp_remember'] = $remember ; // remember me $_SESSION['system_temp_access'] = 3 ; // verification access times | 3 $_SESSION['system_temp_bool_verify'] = $user_verification_type ; // verification boolean if( $user_verification_type == 'yes' ){ // generate rand number $rand = rand(100000,999999) ; // update login form $mysqli->query( "UPDATE system_user SET user_verification = '".$rand."', user_verification_date = '".TODAYDATE."' WHERE user_id = '".$user_id."'") ; // send verifcation code to owner emailVerifcationCode($mysqli, system_user, COMPANY, EMAILSYSTEM, $row_user, $rand) ; }else{ // update login form $mysqli->query("UPDATE system_user SET user_login_cookies = '".$login_cookies."', user_visit_count = '".$visit_count."', user_last_latitude = '".$latitude."', user_last_longtitude = '".$longtitude."', user_last_device = '".$get_user_agent."', user_last_ip = '".$get_client_ip."', user_last_login = '".TODAYDATE."' WHERE user_id = '".$user_id."'") ; // unset temporary session unset($_SESSION['system_temp_user_name']) ; unset($_SESSION['system_temp_password']) ; unset($_SESSION['system_temp_remember']) ; unset($_SESSION['system_temp_access']) ; unset($_SESSION['system_temp_bool_verify']) ; // get the customer information $_SESSION['system_id'] = $user_id ; $_SESSION['system_name'] = $row_user['user_name'] ; $_SESSION['system_branch'] = $row_user['user_branch'] ; $_SESSION['system_permission'] = $row_user['user_permission'] ; // set cookies $expired_time = (time() + 60 * 60 * 24 * 365 * 5) ; setcookie("system_login_cookies", $login_cookies, $expired_time, "/") ; if ($remember){ setcookie("system_id", $_SESSION['system_id'], $expired_time, "/") ; setcookie("system_name", $_SESSION['system_name'], $expired_time, "/") ; setcookie("system_branch", $_SESSION['system_branch'], $expired_time, "/") ; setcookie("system_permission", $_SESSION['system_permission'], $expired_time, "/") ; }else{ $expired_time = (time() - 3600) ; setcookie("system_id", $_SESSION['system_id'], $expired_time, "/") ; setcookie("system_name", $_SESSION['system_name'], $expired_time, "/") ; setcookie("system_branch", $_SESSION['system_branch'], $expired_time, "/") ; setcookie("system_permission", $_SESSION['system_permission'], $expired_time, "/") ; } // redirect page header('Location: main.php') ; exit ; } }else{ // update login form $mysqli->query("UPDATE system_user SET user_verification = '', user_login_cookies = '".$login_cookies."', user_visit_count = '".$visit_count."', user_last_latitude = '".$latitude."', user_last_longtitude = '".$longtitude."', user_last_device = '".$get_user_agent."', user_last_ip = '".$get_client_ip."', user_last_login = '".TODAYDATE."' WHERE user_id = '".$user_id."'") ; // unset temporary session unset($_SESSION['system_temp_user_name']) ; unset($_SESSION['system_temp_password']) ; unset($_SESSION['system_temp_remember']) ; unset($_SESSION['system_temp_access']) ; unset($_SESSION['system_temp_bool_verify']) ; // get the customer information $_SESSION['system_id'] = $user_id ; $_SESSION['system_name'] = $row_user['user_name'] ; $_SESSION['system_branch'] = $row_user['user_branch'] ; $_SESSION['system_permission'] = $row_user['user_permission'] ; // set cookies $expired_time = (time() + 60 * 60 * 24 * 365 * 5) ; setcookie("system_login_cookies", $login_cookies, $expired_time, "/") ; if ($remember){ setcookie("system_id", $_SESSION['system_id'], $expired_time, "/") ; setcookie("system_name", $_SESSION['system_name'], $expired_time, "/") ; setcookie("system_branch", $_SESSION['system_branch'], $expired_time, "/") ; setcookie("system_permission", $_SESSION['system_permission'], $expired_time, "/") ; }else{ $expired_time = (time() - 3600) ; setcookie("system_id", $_SESSION['system_id'], $expired_time, "/") ; setcookie("system_name", $_SESSION['system_name'], $expired_time, "/") ; setcookie("system_branch", $_SESSION['system_branch'], $expired_time, "/") ; setcookie("system_permission", $_SESSION['system_permission'], $expired_time, "/") ; } // redirect page header('Location: main.php') ; exit ; } }else{ $warning_verfication = 'error_verifcation' ; $access-- ; if ($access == 0){ // unset temporary session unset($_SESSION['system_temp_user_name']) ; unset($_SESSION['system_temp_password']) ; unset($_SESSION['system_temp_remember']) ; unset($_SESSION['system_temp_access']) ; unset($_SESSION['system_temp_bool_verify']) ; }else{ $_SESSION['system_temp_access'] = $access-- ; } } } } } // check status if ($_SESSION['system_temp_user_name'] != '' && $_SESSION['system_temp_password'] != ''){ if( $_SESSION['system_temp_bool_verify'] == 'yes' ){ $boolean_verifcation = true ; }else{ $boolean_verifcation = false ; } }else{ $boolean_verifcation = false ; } // token session $_SESSION['system_token'] = md5(uniqid()) ; // body onload script $show_map_library = true ; $show_map_script = true ; $body_onload = true ; // start header here include 'requires/page_header.php' ; ?>

'.$lang['please_get_the_verification_code_from_the_owner'].'

'.($warning_verfication == 'error_verifcation' ? '

'.$lang['sorry_please_provide_a_correct_verification_code'].$lang['you_still_can_try'].$_SESSION['system_temp_access'].$lang['times'].'

' : '').'
' ; }else{ echo '
'.$lang['remember_me'].'
' ; } ?>
$v ){ $new_download[] = ''.$v.'' ; } echo implode( ' / ', $new_download ) ; } ?>


IPS Software Sdn. Bhd.