<?php

session_start();
$domain ="PenpalAfrica.com";
$sender ="Penpal";
$mfrom ="no-reply@PenpalAfrica.com";
$mfromname="PenpalAfrica";
$gate="1";

$db = new PDO('mysql:host=127.0.0.1;dbname=smartsmsrouter','smsEngine','guEnaR28T');

$palid = $_SESSION['palid'];
$nickname = $_SESSION['nickname'];


if ($palid ==""){
    $mtd =$_GET['mtd'];
  if ($mtd ==""){
header('Location:  ../login.php?err=1');
    die();
  }else {
    $friendpalid =$_GET['id'];
    if($friendpalid != ""){
     $_SESSION['redirectpage']= "onlineprofile.php?id=".$friendpalid;
     header('Location:  ../mobile/index.php');
      //echo $_SESSION['redirectpage'];
     die();
   }else{
     header('Location:  ../mobile/index.php');
         die();
   }
  }
}




if ($nickname ==""){
header('Location:  ../login.php?err=1');
    die();
}


function getQuery1( $query)
{

 $cnt ="#";
 $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
       ///Check connection
 if (mysqli_connect_errno())
 {
         // //echo mysqli_error($con);
         //echo "-1";
         return '#';
         die();
 }
 if(!$result= mysqli_query($con,$query))
 {
       mysqli_close($con);
     return "#";
 }
 else
 {
   while($row = mysqli_fetch_array($result))
   {
     $cnt = $row[0];

   }
   mysqli_close($con);
   return $cnt;
 }


}//getQuery1


function updateQuery( $query)
{

   $cnt ="1";
   $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
   ///Check connection
   if (mysqli_connect_errno())
      {
      // //echo mysqli_error($con);
      //echo "-1";
      return '-2';
      die();
   }



	if(!$result= mysqli_query($con,$query))
	{
  	  echo mysqli_error($con);
  	  //echo "Database error please try again";
   	  mysqli_close($con);
   	  return "-1";
    //echo "james";
	}
	else
	{
		//echo "nosaMary".$query;
	  $cnt= "0";
	  mysqli_close($con);

	}
  return $cnt;
}//updateQuery


function getQuery3( $query)
{

 $cnt ="#";
 $cnt1 ="#";
 $cnt2 ="#";
 $cnt3 ="#";

       $con=mysqli_connect("127.0.0.1","smsEngine","guEnaR28T","smartsmsrouter");
       ///Check connection
 if (mysqli_connect_errno())
 {
         // //echo mysqli_error($con);
         //echo "-1";
         return '#';
         die();
 }
 if(!$result= mysqli_query($con,$query))
 {
       mysqli_close($con);
     return "#";
 }
 else
 {
   while($row = mysqli_fetch_array($result))
   {
     $cnt1 = $row[0];
     $cnt2 = $row[1];
     $cnt3 = $row[2];

   }
   mysqli_close($con);

   if($cnt1 !="#")
   $cnt = $cnt1. ",". $cnt2. ",". $cnt3;
   return $cnt;
 }
}//getQuery3

function getNewExpiryDate($myDate){
  $mdate =  date('Y-m-d H:i:s');
  if ($myDate < $mdate){
 			     //$expdate = date('Y-m-d', strtotime('+2 weeks'));
 				  $myNewDate = date('d-m-Y', strtotime('+2 weeks'));

 		      }
  else{

 	         $add_days = 14;
           $myNewDate = date('d-m-Y',strtotime($myDate.' +'.$add_days.' days'));

 	}




  return $myNewDate;
}

function generateRandom()
 {
    $today = date("YmdHis");
    $rand = strtoupper(substr(uniqid(sha1(time())),0,6));
    $unique = $today . $rand;
    return $unique;
}




  function generateTransID()
   {
      $today = date("YmdHis");
      $rand = strtoupper(substr(uniqid(sha1(time())),0,4));
      $unique = $today . $_SESSION['subtransid'] . $rand;
      return $unique;
}

function removePosion($mstr)
{
      $mstring = str_replace("'","^",$mstr);
      return $mstring;
}

$query = "select vemail from penpalsubscriber where palid  = '$palid'";
$queryresponse = getQuery1($query);
$vemail= $queryresponse;
if ($vemail =="0"){
header('Location:  ../login.php?err=28');
    die();

}

//get expiry date ;
$query = "select date(expirydate) from penpalsubscriber where palid  = '$palid'";
$queryresponse = getQuery1($query);
$expireDate= $queryresponse;

//get photo
$query = "select photo from penpalsubscriber where palid  = '$palid'";
$queryresponse = getQuery1($query);
$photo= $queryresponse;


//$query = "select count(*) as tot from penpalsubscriber where online  = '1' and palid !='".$_SESSION['palid']."'";
$query = "select count(*) as tot from penpalsubscriber where online  = '1'";// and palid !='".$_SESSION['palid']."'";
$queryresponse = getQuery1($query);
$online= $queryresponse;

$query = "select count(*) as tot from penpalchatmessages where palidreceiver = '$palid' and messageread ='0';";
$queryresponse = getQuery1($query);
$messageread= $queryresponse;


$query = "select count(*) as tot from penpalvisitors where palidreceiver = '$palid' and messageread ='0';";
$queryresponse = getQuery1($query);
$visitor= $queryresponse;



$query = "select count(*) as tot from penpallikes where palidreceiver = '$palid' and messageread ='0';";
$queryresponse = getQuery1($query);
$likes= $queryresponse;

//echo $query."nosa";

$query = "select count(*) as tot from penpalsubscriber where sex  = 'F' and photo ='1'";
$queryresponse = getQuery1($query);
$femalepal= $queryresponse;

$query = "select count(*) as tot from penpalsubscriber where sex  = 'M' and photo ='1'";
$queryresponse = getQuery1($query);
$malepal= $queryresponse;


$female =ceil(($femalepal/($femalepal+$malepal))*100);
$male =floor(($malepal/($femalepal+$malepal))*100);;

if (  $_SESSION['redirectpage'] != "")
{

 	$landingPage =  $_SESSION['redirectpage'];
 	 $_SESSION['redirectpage']= "";
	header('Location: '. $landingPage);

	 die();
}

$query = "select billcode from penpalsubscriber where palid  = '$palid'";
$billcode = getQuery1($query);

$query = "select country from penpalsubscriber where palid  = '$palid'";
$mycountry = getQuery1($query);

?>