";
echo "window.location = '".$url."';";
echo "";
}
function checkDomain(){
/* if($_SERVER['SERVER_NAME']=="trackingexperts.com"){
//gotopage("http://trackingexperts.com/");
}*/
if(strstr($_SERVER['HTTP_USER_AGENT'],"MSIE 7.0") && $_SERVER['SERVER_NAME']=="www.trackingexperts.com"){
gotopage("http://trackingexperts.com/");
exit;
}
if($_SERVER['SERVER_NAME']=="www.infinityshoppingworld.com" or $_SERVER['SERVER_NAME']=="infinityshoppingworld.com"){
gotopage("http://infinityshoppingworld.com:8080/infinity/");
exit;
}
//if($_SERVER['SERVER_NAME']=="www.trackingexperts.com" or $_SERVER['SERVER_NAME']=="trackingexperts.com"){
//echo "Since 4.30 PM this evening we have experienced a problem with the Server so site will be down for next few hours. We are extremely sorry for the downtime and doing //everything possible to resume normal service. Our Applogies ITGC";
//exit;
//gotopage("http://212.25.5.138:8080/VehicleTracking_demo/");
//exit;
//}
}
checkDomain();
include("db_connect_inc.php");
include("lang_check.php");
$_SESSION["homeurl"] = $homeurl;
function connectdb()
{
// Not Working
mysql_connect($hostname,$username,$password);
@mysql_select_db($databasename) or die("Unable to select database $databaseName");
}
function disconnectdb()
{
mysql_close();
}
function debug($str){
if ($str != ""){
//echo $str;
} else {
//echo "I am Here";
}
exit;
}
function firequery($strQuery){
if (!mysql_query($strQuery)){
//print mysql_error();
}
}
function ReturnAnyValue($Ssql){
//firequery($Ssql);
$TempRst = mysql_query($Ssql);
if (!mysql_query($Ssql))
{
//debug("ReturnAnyValue: Error - ".$Ssql."");
}
//$EOF = mysql_num_rows($TempRst);
// done by jat on 31 march 11
if (($TempRst) && (mysql_num_rows($TempRst)>0) )
{
$TempRow = mysql_fetch_row($TempRst);
$Retun = $TempRow[0];
}
else
{
$Retun = "";
}
return $Retun;
}
function ReturnRow($Ssql){
//firequery($Ssql);
$TempRst = mysql_query($Ssql);
// $EOF = mysql_num_rows($TempRst);
// if ($EOF != 0){
if(mysql_error() != ''){
//echo mysql_error();
//echo "Error: - ".$Ssql."
";
debug (mysql_error());
}
$TempRow = mysql_fetch_array($TempRst);
$Retun = $TempRow;
// echo $TempRow['qualificationid'];
// }else{
// $Retun = "";
// }
return $Retun;
}
function AutoLoginForUser($userid){
// echo "select email , sex, loginusermaster.firstname from loginusermaster join user_general using (userid) where loginusermaster.userid = ".$userid."";
$rst_autologin = mysql_query("select email , sex, loginusermaster.nickname from loginusermaster join user_general using (userid) where loginusermaster.userid = ".$userid."");
$row_autologin = mysql_fetch_array($rst_autologin);
$_SESSION["userid"] = $userid;
$_SESSION["emailaddress"] = $row_autologin['emailaddress'];
$_SESSION["user_sex"] = $row_autologin['sex'];
$_SESSION["membername"] = $row_autologin['nickname']; //$row_autologin['firstname'];
if($row_autologin["is_expired"]=="1"){
$_SESSION['ispaidmember'] = false;
} else {
$_SESSION['ispaidmember'] = true;
}
}
$ispaymentenable = 1;
function fnlnemal($userid){
$sqls="select * from loginusermaster where userid='$userid'";
$rst=mysql_query($sqls);
$Row=mysql_fetch_array($rst);
$fname=$Row['firstname'];
$lname=$Row['lastname'];
$email=$Row['email'];
$array = $fname.",".$lname.",".$email;
return $array;
}
function select_query($query,$condition=0){
global $dblink;
$hostname = "203.115.101.62";
$username = "website11";
$password = "web@web1234";
$databasename = "matrix";
$dblink = mysql_connect($hostname,$username,$password) ;
if($condition==1){
//echo "
".$query."
";
}
$qry=@mysql_query($query);// or die( $query . " ". mysql_error());
$num=@mysql_num_rows($qry);
$num_field=@mysql_num_fields($qry);
for($i=0;$i<$num_field;$i++)
{
$fname[]=@mysql_field_name($qry,$i);
}
for($i=0;$i<$num;$i++){
$result=mysql_fetch_array($qry);
foreach($fname as $key => $value ) {
$arr[$i][$value]=$result[$value];
}
}
//mysql_close();
return $arr;
}
function select_query_staging($query,$condition=0){
$hostname = "203.115.101.51";
$username = "from62";
$password = "123456From62";
$databasename = "matrix";
/*$hostname = "103.16.141.201";
$username = "test";
$password = "testmanas";
$databasename = "matrix";;*/
$dblink = mysql_connect($hostname,$username,$password) ;
$qry=@mysql_query($query,$dblink);// or die( $query . " ". mysql_error());
$num=@mysql_num_rows($qry);
$num_field=@mysql_num_fields($qry);
for($i=0;$i<$num_field;$i++)
{
$fname[]=@mysql_field_name($qry,$i);
}
for($i=0;$i<$num;$i++){
$result=mysql_fetch_array($qry);
foreach($fname as $key => $value ) {
$arr[$i][$value]=$result[$value];
}
}
//mysql_close();
return $arr;
}
function select_Procedure($query){
/*$connection = mysqli_connect("localhost", "vineet", "Sensex@#123", "matrix");
$qry=@mysqli_query($connection,$query);// or die( $query . " ". mysql_error());
$num=@mysqli_num_rows($qry);
$num_field=@mysqli_num_fields($qry);
for($i=0;$i<$num_field;$i++)
{
$fname[]=@mysqli_field_name($qry,$i);
}
for($i=0;$i<$num;$i++){
$result=mysqli_fetch_array($qry);
foreach($fname as $key => $value ) {
$arr[$i][$value]=$result[$value];
}
}*/
try {
$conn = new PDO("mysql:host=203.115.101.50;dbname=livetrack",
"from62", "123456From62");
// execute the stored procedure
//$sql = 'CALL NearestGeoAddress()';
$sql = $query;
$q = $conn->query($sql);
$q->setFetchMode(PDO::FETCH_ASSOC);
} catch (PDOException $pe) {
die();
//die("Error occurred:" . $pe->getMessage());
}
$r[] = $q->fetch();
//$connection = mysqli_connect("hostname", "user", "password", "db", "port");
//run the store proc
//$result = mysqli_query($connection,
// "CALL StoreProcName") or die("Query fail: " . mysqli_error());
//loop the result set
// while ($row = mysqli_fetch_array($result)){
// echo $row[0] . " - " . + $row[1];
// }
return $r;
}
////////////////////////////////////////////////////Remove Block Word
?>