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 getFullGmtData($split) { $query = CLS_MYSQL::Query("SELECT * FROM gmt_zones"); $count = CLS_MYSQL::GetResultNumber($query); //echo"<pre>"; //var_dump($query); for ($i = 0; $i < $count; $i++) { $data['Result']['Data'][$i]['gmt_id'] = CLS_MYSQL::GetResultValue($query, $i, 'id'); $data['Result']['Data'][$i]['gmt'] = CLS_MYSQL::GetResultValue($query, $i, 'gmt'); $data['Result']['Data'][$i]['secondsDiff'] = CLS_MYSQL::GetResultValue($query, $i, 'secondsDiff'); //$data['Result']['Data'][$i]['Location']=CLS_MYSQL::GetResultValue($query,$i,'Location'); //print_r($location); //$spl=preg_split('/(,(?: ))/', $location); $location = CLS_MYSQL::GetResultValue($query, $i, 'Location'); /*if($split==1) { $data['Result']['Data'][$i]['Location']=preg_split('/(,(?: ))/', $location); } else { $data['Result']['Data'][$i]['Location']=$location; }*/ $data['Result']['Data'][$i]['Location'] = $split == 1 ? preg_split('/(,(?: ))/', $location) : $location; //print_r($spl); //exit(); } $this->display($data); }
public function fetchFaq() { $query = CLS_MYSQL::Query("SELECT * FROM faq"); $count = CLS_MYSQL::GetResultNumber($query); for ($i = 0; $i < $count; $i++) { $dataDB['Result']['Data'][$i]['Faq'] = CLS_MYSQL::GetResultValue($query, $i, 'faq'); } $this->display($dataDB); }
public function getFullApnData() { $query = CLS_MYSQL::Query("SELECT * FROM apn_settings"); $count = CLS_MYSQL::GetResultNumber($query); //echo"<pre>"; //var_dump($query); for ($i = 0; $i < $count; $i++) { $data['Result']['Data'][$i]['apn_id'] = CLS_MYSQL::GetResultValue($query, $i, 'id'); $data['Result']['Data'][$i]['apn_settings'] = CLS_MYSQL::GetResultValue($query, $i, 'apn_settings'); $data['Result']['Data'][$i]['network'] = CLS_MYSQL::GetResultValue($query, $i, 'network'); $data['Result']['Data'][$i]['country'] = CLS_MYSQL::GetResultValue($query, $i, 'country'); } $this->display($data); }
function vehicleDetails($user_id) { $query = CLS_MYSQL::Query("SELECT * FROM user_devices WHERE user_id='{$user_id}'"); $count = CLS_MYSQL::GetResultNumber($query); if ($count == 0) { $dataDB['Result']['Data'][0]['Status'] = "no vehicle"; } else { for ($i = 0; $i < $count; $i++) { $dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($query, $i, 'uid'); $dataDB['Result']['Data'][$i]['alias'] = CLS_MYSQL::GetResultValue($query, $i, 'alias'); } } $this->display($dataDB); }
function getDevices($id) { $query = CLS_MYSQL::Query("SELECT b. *\r\nFROM users AS a\r\nLEFT JOIN user_devices AS b ON a.user_id = b.user_id\r\nWHERE a.user_id = '{$id}'"); $count = CLS_MYSQL::GetResultNumber($query); for ($i = 0; $i < $count; $i++) { $dataDB['Result']['Data'][$i]['device_id'] = CLS_MYSQL::GetResultValue($query, $i, 'id'); $dataDB['Result']['Data'][$i]['mobile_num'] = CLS_MYSQL::GetResultValue($query, $i, 'mobile'); //$dataDB['Result']['Data'][$i]['offset']=CLS_MYSQL::GetResultValue($query,$i,'offset'); $dataDB['Result']['Data'][$i]['imei'] = CLS_MYSQL::GetResultValue($query, $i, 'imei'); $dataDB['Result']['Data'][$i]['alias'] = CLS_MYSQL::GetResultValue($query, $i, 'alias'); } //$dataDB['Result']['id']=session_id(); $dataDB['Result']['user_id'] = $id; $dataDB['Result']['Status'] = "Successfully logged in"; $this->display($dataDB); }
function logDetails($date1, $time1, $date2, $time2, $imei) { //$uid='12'; $Timestamp1 = $this->makeTimestamp($date1, $time1); $Timestamp2 = $this->makeTimestamp($date2, $time2); $query = CLS_MYSQL::Query("SELECT * FROM track_data where activity BETWEEN '{$Timestamp1}' AND '{$Timestamp2}' AND imei='{$imei}'"); $count = CLS_MYSQL::GetResultNumber($query); //echo $count; if ($count == 0) { $dataDB['Result']['Data'][0]['Status'] = "No data"; } else { for ($i = 0; $i < $count; $i++) { //$dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($this->query,$i,'uid'); $latitude[$i] = CLS_MYSQL::GetResultValue($query, $i, 'latitude'); $longitude[$i] = CLS_MYSQL::GetResultValue($query, $i, 'longitude'); // $dataDB['Result']['Data'][$i]['date_time'] = CLS_MYSQL::GetResultValue($query,$i,'date_time'); } } //var_dump($latitude); $this->traceRoute($latitude, $longitude, $count); }
function currentLocation($imei) { //var_dump($imei); $delay = 19800; $query = CLS_MYSQL::Query("SELECT latitude,longitude,activity,velocity FROM track_data WHERE imei='{$imei}' ORDER BY activity DESC LIMIT 1"); //var_dump($query); $count = CLS_MYSQL::GetResultNumber($query); //echo $count; if ($count == 0) { $dataDB['Result']['Data'][0]['Status'] = "No data"; } else { //imei latitude longitude activity velocity for ($i = 0; $i < $count; $i++) { $data['result'][$i]['latitude'] = CLS_MYSQL::GetResultValue($query, 0, 'latitude'); $data['result'][$i]['longitude'] = CLS_MYSQL::GetResultValue($query, 0, 'longitude'); //$geo_status = CLS_MYSQL::GetResultValue($query,0,'geo_status'); //$out_range = CLS_MYSQL::GetResultValue($query,0,'out_range'); //$read_status = CLS_MYSQL::GetResultValue($query,0,'read_status'); //$alias = CLS_MYSQL::GetResultValue($query,0,'alias'); //$range = CLS_MYSQL::GetResultValue($query,0,'range'); $data['result'][$i]['velocity'] = CLS_MYSQL::GetResultValue($query, 0, 'velocity'); $current = $delay + CLS_MYSQL::GetResultValue($query, 0, 'activity'); $data['result'][$i]['last_update'] = date("D-M-Y H:i:s", $current); } } //$this->traceRoute($latitude,$longitude,$count); if ($data == '') { $data['result'][0]['status'] = "No data"; $this->display($data); } $this->display($data); }
public function setUserRegistration($user_id) { if (!$this->databaseUsersTable) { $this->getMessage('contact nuthan', '', '', 'true'); } $imei = $_REQUEST['imei']; //var_dump($imei); $admin_mob = $_REQUEST['admin_mob']; $apn = $_REQUEST['apn']; $mobile = $_REQUEST['mobile']; $offset = $_REQUEST['offset']; $alias = $_REQUEST['alias']; $this->checkFields($imei, $mobile, $offset, $alias, $admin_mob, $apn); //$user_id=$_SESSION['user_id']; //$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 * FROM user_devices WHERE imei='{$imei}'"); $count = CLS_MYSQL::GetResultNumber($query); // $result_user_mail=CLS_MYSQL::Query("SELECT * FROM"." ".$this->databaseUsersTable." "."WHERE user_mail='$user_mail'"); $count = CLS_MYSQL::GetResultNumber($query); //var_dump($count); //$imei=CLS_MYSQL::GetResultValue($query,0,'imei'); //$uid==CLS_MYSQL::GetResultValue($query,0,'uid'); //var_dump($uid) if ($count == 1) { $this->display('device id already exist'); } else { $query = CLS_MYSQL::Query("SELECT * FROM users WHERE user_id='{$user_id}'"); $user_name = CLS_MYSQL::GetResultValue($query, 0, 'user_name'); $user_mail = CLS_MYSQL::GetResultValue($query, 0, 'user_mail'); $user_pass = CLS_MYSQL::GetResultValue($query, 0, 'user_pass'); if (CLS_MYSQL::Execute("INSERT INTO user_devices (user_id, mobile, offset, imei, alias) VALUES ('{$user_id}','{$mobile}','{$offset}','{$imei}','{$alias}')")) { $Email = new VTSMail(); } $Email->setName($user_name); //To name $Email->setMail($user_mail); //To e-mail $Email->setSubject("VTS Registration"); //Subject $Email->setMessage("VTS Registration for Device IMEI:{$imei}"); $Email->sendMail(); //var_dump($Email); $this->display('Registration was successful'); } }
function getDeviceList($user_id) { //var_dump($user_id); $query = CLS_MYSQL::Query("SELECT id FROM user_devices WHERE user_id='{$user_id}'"); $count = CLS_MYSQL::GetResultNumber($query); //echo $count; for ($i = 0; $i < $count; $i++) { $devices[$i] = CLS_MYSQL::GetResultValue($query, $i, 'id'); } //print_r($uids); return $devices; //print_r($uid); }
/** * Defines the class variable required for conversion * Dont call this function. It is used internally */ private function setZoneSecDiff() { if (empty($this->zoneId)) { $this->zoneSecDiff = 0; return; } $query = CLS_MYSQL::Query('SELECT secondsDiff FROM gmt_zones WHERE id = ' . $this->zoneId); //if(!$this->dbH) //$this->connectDB(); //$recordSet = mysql_query($query, $this->dbH); $recordSet = CLS_MYSQL::GetResultNumber($query); if ($recordSet != 1) { die('Error : Invalid zone id'); } //$this->zoneSecDiff = mysql_result($recordSet, 0); $this->zoneSecDiff = CLS_MYSQL::GetResultValue($recordSet, 0, 'secondsDiff'); }
public function verifyPasscode($passcode, $user_id) { $query = CLS_MYSQL::Query("SELECT user_name FROM users WHERE user_active='{$passcode}' and user_id='{$user_id}'"); $count = CLS_MYSQL::GetResultNumber($query); return $count; }
function logDetails($date1, $time1, $date2, $time2, $uid) { $Timestamp1 = $this->makeTimestamp($date1, $time1); //echo $Timestamp1;echo "<br/>"; $Timestamp2 = $this->makeTimestamp($date2, $time2); //echo $Timestamp2;echo "<br/>"; $this->query = CLS_MYSQL::Query("SELECT gid,uid, latitude, longitude,FROM_UNIXTIME(UTC) AS date_time FROM gprs where UTC BETWEEN '{$Timestamp1}' AND '{$Timestamp2}' AND uid='12'"); //08-07-2011&time1=06:01:07 //echo mktime(06,01,07,07,08,2011); //echo date("Y-m-d H:i:s",1310130067); $a = "SELECT gid,uid, latitude, longitude,FROM_UNIXTIME(UTC) AS date_time FROM gprs where UTC BETWEEN '{$Timestamp1}' AND '{$Timestamp2}' AND uid='12'"; //echo $a; $this->count = CLS_MYSQL::GetResultNumber($this->query); if ($this->count == 0) { $dataDB['Result']['Data'][0]['Status'] = "No data"; } else { for ($i = 0; $i < $this->count; $i++) { // $dataDB['Result']['Data'][$i]['gid'] = CLS_MYSQL::GetResultValue($this->query,$i,'gid'); // $dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($this->query,$i,'uid'); $dataDB['Result']['Data'][$i]['latitude'] = CLS_MYSQL::GetResultValue($this->query, $i, 'latitude'); $dataDB['Result']['Data'][$i]['longitude'] = CLS_MYSQL::GetResultValue($this->query, $i, 'longitude'); $dataDB['Result']['Data'][$i]['date_time'] = CLS_MYSQL::GetResultValue($this->query, $i, 'date_time'); } } $this->display($dataDB); }
function geoFencing($device_id, $out_range, $range) { //$query=CLS_MYSQL::Query("SELECT range,out_range FROM user_devices WHERE uid='$uid'"); //$range=CLS_MYSQL::GetResultValue($query,0,'range'); //$out_range=CLS_MYSQL::GetResultValue($query,0,'out_range'); //var_dump($out_range); if ($out_range != 0) { $query = CLS_MYSQL::Query("SELECT out_range\n\t\t\t\tFROM user_devices WHERE id = '{$device_id}'"); $count = CLS_MYSQL::GetResultNumber($query); if ($count == 0) { $dataDB['Result']['Data'][0]['Status'] = "no data"; } else { for ($i = 0; $i < $count; $i++) { //$dataDB[$i]['lat_ref']=CLS_MYSQL::GetResultValue($query,0,'lat_ref'); //$dataDB[$i]['long_ref']=CLS_MYSQL::GetResultValue($query,0,'long_ref'); //$dataDB[$i]['lat_set']=CLS_MYSQL::GetResultValue($query,0,'lat_set'); //$dataDB[$i]['long_set']=CLS_MYSQL::GetResultValue($query,0,'long_set'); //$dataDB[$i]['preset_range']=CLS_MYSQL::GetResultValue($query,0,'range'); $dataDB['out_range'] = CLS_MYSQL::GetResultValue($query, 0, 'out_range'); } } return $dataDB; //$this->display($dataDB); } //return ''; }
function logDetails($date1, $time1, $date2, $time2, $id) { //$uid='12'; $delay = $this->localTime($id); //$delay=19800; $Timestamp1 = $this->makeTimestamp($date1, $time1); $Timestamp2 = $this->makeTimestamp($date2, $time2); $Timestamp1 = $Timestamp1 + $delay; $Timestamp2 = $Timestamp2 + $delay; $query = CLS_MYSQL::Query("SELECT * FROM track_data where activity BETWEEN '{$Timestamp1}' AND '{$Timestamp2}' AND device_id='{$id}'"); //echo "SELECT * FROM track_data where activity BETWEEN '$Timestamp1' AND '$Timestamp2' AND device_id='$id'"; //exit(); $count = CLS_MYSQL::GetResultNumber($query); //echo $count; if ($count == 0) { $dataDB['Result']['Data'][0]['Status'] = "No data"; // echo "alert('No history');</script>"; echo "jAlert('No history', 'Alert');</script>"; exit; } else { for ($i = 0; $i < $count; $i++) { //$dataDB['Result']['Data'][$i]['uid'] = CLS_MYSQL::GetResultValue($this->query,$i,'uid'); $latitude[$i] = CLS_MYSQL::GetResultValue($query, $i, 'latitude'); $longitude[$i] = CLS_MYSQL::GetResultValue($query, $i, 'longitude'); // $dataDB['Result']['Data'][$i]['date_time'] = CLS_MYSQL::GetResultValue($query,$i,'date_time'); } } //var_dump($latitude); $this->traceRoute($latitude, $longitude, $count); }