<?php

include "general.php";
include "connect.php";


if ($_SERVER['REQUEST_METHOD'] == 'OPTIONS') {
    header('Access-Control-Allow-Origin : *');
    header('Access-Control-Allow-Methods : POST, GET, OPTIONS, PUT, DELETE');
    header('Access-Control-Allow-Headers : *');
    exit;
}


$email=$_POST["email"];
$domain =$_POST["domain"];


 $query= "select message_count_u from penpalfriends where email_u ='$email' and deleteaccount ='0' and unmatch='0'";
 

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

 }

 //second query
 $query= "select message_count_f from penpalfriends where email_f ='$email' and deleteaccount ='0' and unmatch ='0'";

 if(!$result= mysqli_query($con,$query))
 {
       mysqli_close($con);
     return "#";
 }
 else
 {

  
   while($row = mysqli_fetch_array($result))
   {
     	
    $total1= $total1+$row[0];
   }
 

   mysqli_close($con);
   
 }


echo $total1;


?>