ERROR! Password didn't matched. Please check your entry and try again. Thank you!

"; }else{ if($chkIfIDExist > 0){ $sysMessage = "

ERROR! ID Number ".$empID." already exist or being used by another user. Please check your entry and try again. Thank you!

"; }else{ //=============================================== $empPosition = $_POST['empPosition']; $lName = $_POST['lName']; $fName = $_POST['fName']; $mName = $_POST['mName']; $lName = mysql_real_escape_string($lName); $fName = mysql_real_escape_string($fName); $mName = mysql_real_escape_string($mName); $empPosition = mysql_real_escape_string($empPosition); $empMobile = $_POST['empMobile']; $empMobile = mysql_real_escape_string($empMobile); $empGender = $_POST['empGender']; $compName = $_POST['compName']; $deptName = $_POST['deptName']; $dealName = $_POST['dealName']; $companyCode = mysql_result(mysql_query("SELECT `code` FROM `company` WHERE `name` ='$compName'"),0); $dealerCode = mysql_result(mysql_query("SELECT `dcode` FROM `dealers` WHERE `name` ='$dealName'"),0); $deptCode = mysql_result(mysql_query("SELECT `code` FROM `departments` WHERE `name` ='$deptName'"),0); $dealerID = mysql_result(mysql_query("SELECT `id` FROM `dealers` WHERE `dcode`='$dealerCode'"),0); $companyID = mysql_result(mysql_query("SELECT `id` FROM `company` WHERE `code`='$companyCode'"),0); $deptID = mysql_result(mysql_query("SELECT `id` FROM `departments` WHERE `code`='$deptCode'"),0); $passWordA = md5($passWordA); $passWordB = md5($passWordB); $sql="INSERT INTO `employee_list` (`id`,`employee_id`,`ccom_code`,`deal_code`,`dept_code`,`head_id`,`supervisor_id`,`last_name`,`first_name`,`middle_name`,`position`,`gender`,`level`,`mobile_number`,`e_mail`) VALUES('','$empID','$companyCode','$dealerCode','$deptCode','','','$lName','$fName','$mName','$empPosition','$empGender','','$empMobile','$empEmail')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ $sysMessage = "

RECORD SAVED! Record Has been saved. You may now login using your e-mail address as your username and password you have provided. Thank you!

"; } $sql="INSERT INTO `c_users` (`u_id`,`emp_id`,`comp_id`,`deal_id`,`dept_id`,`comp_code`,`deal_code`,`dept_code`,`u_name`,`u_fname`,`u_lname`,`u_mname`,`u_position`,`email`,`u_password`,`u_password2`, `account_type`,`user_only`,`status`) VALUES('','$empID','$companyID','$dealerID','$deptID','$companyCode','$dealerCode','$deptCode','$empEmail','$fName','$lName','$mName','$empPosition','$empEmail','$passWordA','$passWordB','User','true','0')"; if(!mysql_query($sql)){ die('Error: ' . mysql_error()); }else{ echo "

REGISTRATION COMPLETE

Please check your e-mail to activate your account. Thank you!

"; } } //============================================= } }else{ $sysMessage = "

ERROR! ".$empEmail." email is not valid or wrong format. Please check your entry and try again. Thank you!

"; } //EMAIL NOTIFICATION $message = "Hi ".$fName."! Thank you for signing up. Please activate your account by clicking the link below. If link didn't work, copy paste the URL to your browser for automatice activation. Account Details: Username: ".$empEmail." Password: ".$myPassword." http://www.autohubgroup.com/ahgportal/index.php?activate=true&token=".md5($empEmail)."&id=".$empID." Thank you! Autohub Support Group"; mail($empEmail, 'AUTOHUB ACCOUNT REGISTRATION', $message, 'From: support@autohubgroup.com'); } ?>

USERNAME:
                                          Your e-mail address will be your official username:

PASSWORD:
                                          Password must be at least 6 characters long combined with letters and numbers

RE-TYPE PASSWORD:
                                          Validate your password to make sure you type it correctly

". $sysMessage."

";?>