function verifyDeviceToken($device_token, $id) { $qry = CLS_MYSQL::Query("SELECT devicetoken FROM apns_devices WHERE devicetoken='{$device_token}'"); $count = CLS_MYSQL::GetResultNumber($qry); if ($count == 0) { $dataDB['Result']['Data'][0]['Status'] = "Invalid Token"; $this->display($dataDB); exit; } else { $token = CLS_MYSQL::Execute("UPDATE apns_devices SET user_id='{$id}' WHERE devicetoken='{$device_token}'"); } }
public function changePassword($password, $user_id, $passcode) { $this->parameterCheck($password, $passcode); //echo $rand; $count = $this->verifyPasscode($passcode, $user_id); if ($count == 0) { $data = "Incorrect passcode"; } else { $this->setCryptMethod('sha1'); $rand = $this->setCrypt($password); $query = CLS_MYSQL::Execute("UPDATE users SET user_pass='******',user_active='0' WHERE user_active='{$passcode}'"); $data = "Password changed"; } $this->display($data); }
public function updateDetails() { if (!$this->databaseUsersTable) { $this->getMessage('contact nuthan', '', '', 'true'); } $admin_mob = $_REQUEST['admin_mob']; $apn = $_REQUEST['apn']; $mobile = $_REQUEST['mobile']; $offset = $_REQUEST['offset']; $alias = $_REQUEST['alias']; $device_id = $_REQUEST['device_id']; $this->updateFields($mobile, $offset, $alias, $admin_mob, $apn, $device_id); $query = CLS_MYSQL::Execute("UPDATE user_devices SET admin_mob='{$admin_mob}',apn_settings='{$apn}',mobile='{$mobile}',offset='{$offset}',alias='{$alias}' WHERE id='{$device_id}'"); //$count=CLS_MYSQL::GetResultNumber($query); $rows = CLS_MYSQL::AffectedRows($query); if ($rows == 1) { $Email = new VTSMail(); $Email->setName($user_name); //To name $Email->setMail($user_mail); //To e-mail $Email->setSubject("VTS Updation"); //Subject $Email->setMessage("VTS Updation for Device"); $Email->sendMail(); //var_dump($Email); $this->display('Updation was successful'); } else { $this->display('Fields Remain same'); } }
function checkPoint($lat_ref, $long_ref, $id, $range) { /*$query=CLS_MYSQL::Query("SELECT latitude,longitude FROM track_data WHERE device_id='$id' ORDER BY activity DESC LIMIT 1"); $latitude=CLS_MYSQL::GetResultValue($query,0,'latitude'); $longitude=CLS_MYSQL::GetResultValue($query,0,'longitude'); $distance=$this->distance($latitude,$longitude,$lat_ref,$long_ref,'M');*/ //echo $distance; //echo $range; //var_dump($imei); //echo "UPDATE user_devices SET lat_ref='$lat_ref',long_ref='$long_ref',ranged='$range',out_range='',geo_status='1',read_status='1' WHERE uid='$imei'"; $query = CLS_MYSQL::Execute("UPDATE user_devices SET lat_ref='{$lat_ref}',long_ref='{$long_ref}',ranged='{$range}',out_range='',geo_status='1',read_status='1' WHERE id='{$id}'"); $dataDB['Result']['Data'][0]['Status'] = $query == true ? "geo_fencing success" : "geo_fencing failure"; /*if($distance>$range) { $dataDB['Result']['Data'][0]['alert']="vehicle out of location"; //echo "me"; }*/ $this->display($dataDB); }
function InsertToken($app_id, $device_token) { $query = CLS_MYSQL::Execute("INSERT INTO apns (app_id,device_token) VALUES('{$app_id}','{$device_token}')"); $dataDB['Result']['Data'][0]['Status'] = $query == true ? "Success" : "Failure"; $this->display($dataDB); }
function trackFleet($uid, $latitude, $longitude, $timestamp, $velocity) { //date1=30-06-11&time1=10:10:11&date2=30-06-11&time2=16:10:10&UID=12 $local = $timestamp + 19800; $track = CLS_MYSQL::Execute("insert into gprs(uid,latitude,longitude,UTC,Local_activity,velocity) values('{$uid}','{$latitude}','{$longitude}','{$timestamp}','{$local}','{$velocity}')"); if ($track == true) { $dataDB['Result']['Data'][0]['Status'] = "Success"; } else { $dataDB['Result']['Data'][0]['Status'] = "Not updated"; } $this->display($dataDB); }
function checkBeyondRange($latitude, $longitude, $device_id) { $query = CLS_MYSQL::Query("SELECT id,lat_ref,long_ref,range FROM user_devices WHERE id='{$device_id}'"); $lat_ref = CLS_MYSQL::GetResultValue($query, 0, 'lat_ref'); $long_ref = CLS_MYSQL::GetResultValue($query, 0, 'long_ref'); $range = CLS_MYSQL::GetResultValue($query, 0, 'range'); //$user_device_id=CLS_MYSQL::GetResultValue($query,0,'id'); //$latitude=$this->latitude; //$longitude=$this->longitude; //var_dump($latitude); //$distance1=($this->distance($latitude[0],$longitude[0],$lat_ref,$long_ref,'M'))-$range; $distance = $this->distance($latitude, $longitude, $lat_ref, $long_ref, 'M'); //var_dump($distance1); //$distance2=($this->distance($latitude[1],$longitude[1],$lat_ref,$long_ref,'M'))-$range; //var_dump($distance2); //echo $distance; //if($distance2>0 && $distance1<0) //{ //CLS_MYSQL::Execute("INSERT INTO geo_fencing(user_device_id,lat_cur,long_cur,out_range,read_status) VALUES('$user_device_id','$latitude','$longitude','$distance','0')"); //CLS_MYSQL::Execute("UPDATE user_devices SET lat_set='$latitude[0]',long_set='$longitude[0]',out_range='$distance2',read_status='2' WHERE uid='$uid'"); CLS_MYSQL::Execute("UPDATE user_devices SET lat_set='{$latitude}',long_set='{$longitude}',out_range='{$distance}',read_status='1' WHERE id='{$device_id}'"); //var_dump($distance); //echo "out"; //} //var_dump($distance); }
/** * 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'); } }
public function resetPasscode($string, $email) { //$this->setCryptMethod('sha1'); //$rand=$this->setCrypt($string); CLS_MYSQL::Execute("UPDATE users SET user_active='{$string}' WHERE user_mail='{$email}'"); }
function customMessage($uid, $message) { //$message=mysql_real_escape_string($message); $query = CLS_MYSQL::Execute("UPDATE user_devices SET message='{$message}',ack='1' WHERE uid='{$uid}'"); $dataDB['Result']['Data'][0]['Status'] = $query == true ? "message tracked" : "message track failure"; $this->display($dataDB); }