<?php 
if ((isset($_POST['TransStatus'])) && (isset($_POST['PAYID']))&& (isset($_POST['Signature'])))
{
mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
mysql_select_db(DB_NAME);

// $sqltest="INSERT INTO  `gds_test` VALUES ('','".$_POST['Signature']."','".$."')";
// mysql_query($sqltest);

$signature = sha1($_POST['TransStatus'].$_POST['PAYID'].GPG_Password);

if ($_POST['Signature'] == $signature)
  {
	if ($_POST['TransStatus']=='00')
	{
	$sql="UPDATE  `prd_coupons` SET etat='2'  WHERE  `prd_coupons`.`code_cmd` =".$_POST['PAYID'];
	mysql_query($sql);
	
     /* On incrémente le nombre d'achteurs */
	$sql2="SELECT * FROM `prd_coupons`  WHERE  `prd_coupons`.`code_cmd` =".$_POST['PAYID'];
	$req = mysql_query($sql2);
	$data = mysql_fetch_array($req);
	$nb_achteurs =  get_post_meta( $data['id_post'], 'wpcf-nombre-d-acheteurs', true );
	$nb_achteurs = (int) $nb_achteurs + $data['quantite'];
	update_post_meta( $data['id_post'], 'wpcf-nombre-d-acheteurs', $nb_achteurs);
	/*************************************/

	/* On incrémente le solde de clients */
	// $user = get_user_by( 'email', $data['dealer_email'] );
    // $solde = get_user_meta( $user->ID,'solde', true); 
	// if(!($solde)) {$solde = 0;add_user_meta( $user->ID, 'solde', 0);}
	
	// $LPP =  get_post_meta( $data['id_post'], 'lien | prix_promo | prix_reel', true );
    // $infos = explode("|", $LPP); 
	// $prix = $infos['1'];
	
	// if ($prix < 50) {$solde += 1000;}
	// if (($prix >= 50)&&($prix < 100)) {$solde += 1500;}
	// if ($prix >= 100) {$solde += 2000;}
    // update_user_meta( $user->ID, 'solde', $solde);
	/*************************************/
	
	}

	// if ($_POST['TransStatus']=='05')
	if (($_POST['TransStatus']=='05')||($_POST['TransStatus']=='06')||($_POST['TransStatus']=='07'))	
	{
	$sql="UPDATE  `prd_coupons` SET etat='6'  WHERE  `prd_coupons`.`code_cmd` =".$_POST['PAYID'];
	mysql_query($sql);
	}
  }
}
?>