<?php 
require_once('pdoconfig.php');
include('_mail_fire.php');
$name=$_REQUEST['name'];
$mail=$_REQUEST['mail'];
$pass=$_REQUEST['pass'];
$cntct=$_REQUEST['cntct'];
$address=$_REQUEST['address'];
$state=$_REQUEST['state'];
$city=$_REQUEST['city'];
$usr_id=$_REQUEST['poster_id'];



if ($usr_id=='0')
{

		 /*$sqls="select * from aa_user_master where email='$mail'";   
	     $ress=$action->select($sqls);*/

	   $sqls="select * from aa_user_master where email= :email ";
	   	$email = array('email'=>$mail);
	    $ress=$action->selectp($sqls,$email);

				   if(count($ress)>0)
				   {
					    ?>
						    <script>
						        alert("User id already exist!");
						        window.location.href="http://www.tarangglobal.com/wp/update_profile/?id=0";				    
						    </script>
						<?php
		
				 }
	else{


$sql1="insert into aa_user_master set name=?,email=?,pass=?,contact=?,address=?,state=?,city=?,approve=?";
$arr=array($name,$mail,$pass,$cntct,$address,$state,$city,0);
$res=$action->insertp($sql1,$arr); 
     if($res>0)
	       {
	            $enq_id=$res;
	            $mailtype='register';
				$mailsubject="Tarang Registration Intimation";
				$mailtoken=$enq_id;
				$mailto=$mail;
				mail_reg($mailto,$mailsubject,$mailtype,$mailtoken);

               echo "<script> alert('Successfully Registered');</script>";
	      echo "<script> window.location.href='http://www.tarangglobal.com/wp/sign-in/';</script>";
	     
	       }
	      else
	          {
	              echo "<script> alert('Registration Failed');</script>";
	          }
}
}

else{
$sql="update aa_user_master set name=?,email=?,pass=?,contact=?,address=?,state=?,city=? where usr_id=$usr_id";


$arr=array($name,$mail,$pass,$cntct,$address,$state,$city);
$res1=$action->updatep($sql,$arr);
}


              if(count($res1)>0)
	       {
               echo "<script> alert('Profile Updated Successfully ');</script>";
	      echo "<script> window.location.href='http://www.tarangglobal.com/wp/user_dashboard/';</script>";
	       }
	      else
	          {
	              echo "<script> alert('Profile Updation Failed');</script>";
	          }
	          
?>