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);
}
