<?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);
}
}
}
?>