public function forgotPassword($email)
 {
     //var_dump($email);exit();
     $query = CLS_MYSQL::Query("SELECT user_name,user_mail FROM users WHERE user_mail='{$email}'");
     //echo "SELECT user_name,user_mail FROM users WHERE user_mail='$email'";
     //var_dump($query);exit();
     $count = CLS_MYSQL::GetResultNumber($query);
     if ($count == 0) {
         $data = "Email does not exist";
         $this->display($data);
     } else {
         $user_name = CLS_MYSQL::GetResultValue($query, 0, 'user_name');
         $string = $this->random_string();
         //var_dump($string);
         //var_dump($rand);
         //echo sha1($string);
         //echo "9011d6581a45b82e5f559063c4aa6d367e5c3ac5";
         //var_dump(sha1($string));exit();
         $this->resetPasscode($string, $email);
         //exit();
         $Email = new VTSMail();
         $Email->setName($user_name);
         //To name
         $Email->setMail($email);
         //To e-mail
         $Email->setSubject("Registration");
         //Subject
         $Email->setMessage("Password Reset Successful\n Your Passcode:{$string}");
         $Email->sendMail();
         $this->display('Password reset successful');
     }
 }
 public function enquiry($user_id)
 {
     $name = $_REQUEST[name];
     $phone = $_REQUEST[phone];
     $email = $_REQUEST[email];
     $message = $_REQUEST[message];
     $admin = "*****@*****.**";
     $sub = "VTS Enquiry";
     $this->enquiryFields($name, $email, $phone, $message);
     $Email = new VTSMail();
     $Email->setName($name);
     $Email->setMail($admin);
     $Email->setSubject("VTS Enquiry");
     $Email->setMessage("{$name},{$phone},{$email},{$message}");
     $Email->sendMail();
     $Recipient = new VTSMail();
     $Recipient->setName($sub);
     $Recipient->setMail($email);
     $Recipient->setSubject("VTS Enquiry");
     $Recipient->setMessage("Thank You for Contacting Us, will revert back soon");
     $Recipient->sendMail();
     //var_dump($Email);
     $this->display('Enquiry sent');
 }
 /**
  * Register user in the database
  *
  * The user form data needed is: user_name, user_pass, user_confirm_pass, user_mail, user_confirm_mail
  */
 public function setUserRegistration()
 {
     if (!$this->databaseUsersTable) {
         $this->getMessage('Users table in the database is not specified. Please specify it before any other operation using the method setDatabaseUserTable();', '', '', 'true');
     }
     $user_name = $this->setEscape($_REQUEST['user_name']);
     $user_pass = $_REQUEST['user_pass'];
     $uid = $_REQUEST['uid'];
     $mobile = $_REQUEST['mobile'];
     $offset = $_REQUEST['offset'];
     $alias = $_REQUEST['alias'];
     //$user_confirm_pass=$_POST['user_confirm_pass'];
     $user_mail = $_REQUEST['user_mail'];
     // $user_confirm_mail=$_POST['user_confirm_mail'];
     $user_crypted_pass = $this->setCrypt($user_pass);
     $query = CLS_MYSQL::Query("SELECT a.*,b.* FROM" . " " . $this->databaseUsersTable . " AS a LEFT JOIN user_devices AS b on a.user_id=b.user_id WHERE a.user_name='{$user_name}'");
     // $result_user_mail=CLS_MYSQL::Query("SELECT * FROM"." ".$this->databaseUsersTable." "."WHERE user_mail='$user_mail'");
     $result_user_name = CLS_MYSQL::GetResultValue($query, 0, 'user_name');
     //$uid==CLS_MYSQL::GetResultValue($query,0,'uid');
     //var_dump($uid);
     if ($uid == CLS_MYSQL::GetResultValue($query, 0, 'uid')) {
         $this->display('device id already exist');
     } elseif (strlen($user_name) < 6 or strlen($user_name) > 16) {
         $this->display('Entered username length must be of 6 to 16 characters');
     } elseif (strlen($user_pass) < 6 or strlen($user_pass) > 16) {
         $this->display('Entered password length must be of 8 to 16 characters');
     } elseif (!preg_match("/^([a-zA-Z0-9_\\.\\-])+\\@(([a-zA-Z0-9\\-]{4,})+\\.)+([a-zA-Z0-9]{2,})+\$/", $user_mail)) {
         $this->display('Email address entered is not valid');
     } else {
         if (CLS_MYSQL::Execute("INSERT INTO" . " " . $this->databaseUsersTable . " " . "(user_name, user_pass, user_mail) VALUES ('{$user_name}', '{$user_crypted_pass}', '{$user_mail}')")) {
             $insert_id = mysql_insert_id();
         }
         CLS_MYSQL::Execute("INSERT INTO user_devices (user_id, mobile, offset, uid, alias) VALUES ('{$insert_id}','{$mobile}','{$offset}','{$uid}','{$alias}')");
         $Email = new VTSMail();
         $Email->setName($user_name);
         //To name
         $Email->setMail($user_mail);
         //To e-mail
         $Email->setSubject("Registration");
         //Subject
         $Email->setMessage("VTS Registration Successful \n username:{$user_name} \n password:{$user_pass}");
         $Email->sendMail();
         $this->display('Registration was successful');
     }
 }