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 getIdTaskByWf($wfid) { $sql = "SELECT `id` FROM {$this->_tbl} WHERE `wf_id`={$wfid} "; $objmysql = new CLS_MYSQL(); $objmysql->Query($sql); $ar = array(); while ($r = $objmysql->Fetch_Assoc()) { $ar[] = $r['id']; } return $ar; }
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 listTableGmem($strwhere = "", $page, $parid, $level) { $star = ($page - 1) * MAX_ROWS; $leng = MAX_ROWS; $sql = "SELECT * FROM `tbl_gmember` WHERE `par_id`=\"{$parid}\" " . $strwhere . " LIMIT {$star},{$leng}"; $objdata = new CLS_MYSQL(); $objdata->Query($sql); $str_space = ""; if ($level != 0) { for ($i = 1; $i < $level; $i++) { $str_space .= " "; } $str_space .= "|--- "; } while ($rows = $objdata->Fetch_Assoc()) { $id = $rows['gmem_id']; $parid = $rows['par_id']; $name = $rows['name']; $intro = stripslashes(uncodeHTML($rows['intro'])); echo "<tr name=\"trow\">"; echo "<td width=\"30\" align=\"center\"><label>"; echo "<input type=\"checkbox\" name=\"chk\" id=\"chk\" onclick=\"docheckonce('chk');\" value=\"{$id}\" />"; echo "</label></td>"; echo "<td width=\"50\" align=\"center\">{$parid}</td>"; echo "<td nowrap=\"nowrap\">\n\t\t\t\t<a href=\"index.php?com=" . COMS . "&task=edit&id={$id}\">{$str_space}{$name}</a>\n\t\t\t</td>"; echo "<td nowrap=\"nowrap\">{$intro} </td>"; echo "<td width=\"50\" align=\"center\">"; echo "<a href=\"index.php?com=" . COMS . "&task=active&id={$id}\">"; showIconFun('publish', $rows["isactive"]); echo "</a>"; echo "</td>"; echo "<td width=\"50\" align=\"center\">"; echo "<a href=\"index.php?com=" . COMS . "&task=edit&id={$id}\">"; showIconFun('edit', ''); echo "</a>"; echo "</td>"; echo "<td width=\"50\" align=\"center\">"; echo "<a href=\"javascript:detele_field('index.php?com=" . COMS . "&task=delete&id={$id}')\">"; showIconFun('delete', ''); echo "</a>"; echo "</td>"; echo "</tr>"; $this->listTableGmem($strwhere, $page, $id, $level + 1); } }
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 getMemberByID($memid) { $sql = "SELECT * FROM `tbl_member` WHERE `mem_id`=\"{$memid}\" "; $objdata = new CLS_MYSQL(); $objdata->Query($sql); if ($objdata->Num_rows() > 0) { $rows = $objdata->Fetch_Assoc(); $this->pro['ID'] = $rows['mem_id']; $this->pro['UserName'] = $rows['username']; $this->pro['Password'] = $rows['password']; $this->pro['FirstName'] = $rows['firstname']; $this->pro['LastName'] = $rows['lastname']; $this->pro['Birthday'] = $rows['birthday']; $this->pro['Gender'] = $rows['gender']; $this->pro['Address'] = $rows['address']; $this->pro['Phone'] = $rows['phone']; $this->pro['Mobile'] = $rows['mobile']; $this->pro['Email'] = $rows['email']; $this->pro['Joindate'] = $rows['joindate']; $this->pro['LastLogin'] = $rows['lastlogin']; $this->pro['Gmember'] = $rows['gmem_id']; $this->pro['isActive'] = $rows['isactive']; } }
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; }
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 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 ''; }
/** * 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'); } }
/** * 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'); }
function localTime($device_id) { $query = CLS_MYSQL::Query("SELECT a.secondsDiff FROM gmt_zones AS a LEFT JOIN user_devices AS b ON a.id=b.offset WHERE b.id='{$device_id}'"); //echo "SELECT a.*,b.* FROM gmt_zones AS a LEFT JOIN user_devices AS b ON a.id=b.offset WHERE b.id='$device_id'"; $result = CLS_MYSQL::GetResultValue($query, 0, 'secondsDiff'); return $result; }
$wf_id = $_REQUEST["wf_id"]; //echo "xxxx $wf_id yyy"; ?> <html> <head> <title>Workflow Display</title> <link rel="stylesheet" href="../common/css/style.css"> <script src="../common/js/jquery-1.9.1.js"></script> <script src="../common/utils.js"></script> <script src="../common/js/base64.js"></script> <script src="js/wfshow.js?8"></script> <?php $sql = "SELECT * FROM tm_workflow WHERE isrun='YES' AND id in(SELECT wf_id FROM tm_workflow_task WHERE isrun in (2,3) AND (user LIKE '%,{$username},%' OR user LIKE '{$username},%'))"; $mysql_task = new CLS_MYSQL(); $objmysql = new CLS_MYSQL(); $objmysql->Query($sql); $wfs = ""; $c = 0; while ($r = $objmysql->Fetch_Assoc()) { $data = $r['data']; if (!($wf_id > 0)) { $wf_id = $r['id']; } $selected = $r['id'] == $wf_id ? "selected" : ""; $wfs .= "<option value='{$r['id']}' {$selected}>{$r['name']}</option>"; $sql = "SELECT id FROM tm_workflow_task WHERE isrun=2 AND (user LIKE '%,{$username},%' OR user LIKE '{$username},%')"; $mysql_task->Query($sql); $c++; } if ($c === 0) { $wf_id = 0;
function checkPoint($lat_ref, $long_ref, $imei, $range) { $query = CLS_MYSQL::Query("SELECT latitude,longitude FROM track_data WHERE imei='{$imei}' 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}',range='{$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',range='$range',out_range='',geo_status='1',read_status='1' WHERE uid='$imei'"); $dataDB['Result']['Data'][0]['Status'] = $query == true ? "geo_fensing success" : "geo_fensing failure"; if ($distance > $range) { $dataDB['Result']['Data'][0]['alert'] = "vehicle out of location"; //echo "me"; } $this->display($dataDB); }
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); }