sorry,
here is the part:
verify_paypal_email.php
Code:
<?php
include("./lib/customer.defines.php");
include("./lib/epayment/includes/verification.php");
getpost_ifset(array('vcode'));
$error_message = "";
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." ============ PAYPAL EMAIL VERIFICATION process ============== ");
$continue_proc = false;
$verifystatus = false;
if (!isset($vcode)) {
/* no validation code found */
$continue_proc = false;
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." ERROR: vcode NOT FOUND ");
} else {
$continue_proc = true;
}
if ($continue_proc == true) {
/* check vcode */
$transdata = vh_extract_vcode($vcode);
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." vcode = $vcode");
if ($transdata['key'] != "") {
$continue_proc = true;
} else {
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." ERROR NO VERIFICATION KEY");
$continue_proc = false;
}
}
include ("./lib/Form/Class.FormHandler.inc.php");
include ("./lib/epayment/classes/payment.php");
include ("./lib/epayment/classes/order.php");
include ("./lib/epayment/classes/currencies.php");
include ("./lib/epayment/includes/general.php");
include ("./lib/epayment/includes/html_output.php");
include ("./lib/epayment/includes/configure.php");
include ("./lib/epayment/includes/loadconfiguration.php");
$DBHandle_max = DbConnect();
if ($continue_proc == true) {
/* check the transaction */
$QUERY = "SELECT id, customers_id, orders_amount, orders_status, date_purchased FROM cc_payments WHERE verification_code = '".$transdata['key']."' AND date_purchased = '".$transdata['transdate']."'";
$tb_payments = new Table("cc_payments");
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." QUERY: ". $QUERY);
$list_payments = $tb_payments->SQLExec($DBHandle_max, $QUERY);
if (!is_array($list_payments)) {
$continue_proc = false;
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." ERROR PAYMENT NOT FOUND \n". print_r($transdata,1));
}
if ($continue_proc == true && count($list_payments) == 0) {
$continue_proc = false;
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." ERROR PAYMENT NOT FOUND \n". print_r($transdata,1));
} elseif ($continue_proc == true && count($list_payments) > 0) {
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." payment found \n". print_r($list_payments,1));
}
}
/* check transaction status */
if ($continue_proc == true && $list_payments[0]['orders_status'] != 0) {
/* status is not pending ... maybe user have clicked before */
$error_message = "You may have already verify this transaction.";
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." STATUS ERROR: not Pending");
$continue_proc = false;
}
/* check user */
if ($continue_proc == true) {
$tb_card = new Table("cc_card");
$QUERY = "SELECT * FROM cc_card WHERE id='".$list_payments[0]['customers_id']."'";
$list_card = $tb_card->SQLExec($DBHandle_max,$QUERY);
if (!is_array($list_card)) {
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." ERROR CARD NOT FOUND :".$FG_TB_CLAUSE);
$continue_proc = false;
} else {
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." CARD DATA FOUND \n".print_r($list_card,1));
}
}
/* add credit */
if ($continue_proc == true) {
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." adding credit: ".$list_payments[0]['orders_amount']);
$amount_paid = $list_payments[0]['orders_amount'];
$id = $list_payments[0]['customers_id'];
/* update credit on cc_card */
$card_table = new Table("cc_card");
$QUERY = "UPDATE `cc_card` SET `credit`=`credit`+'".$amount_paid."' WHERE `id`='".$id."'";
$db_creditupdate = $card_table->SQLExec($DBHandle_max, $QUERY, 1);
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." QUERY: ".$QUERY);
/* update cc_payments: change status to 2 */
$payment_table = new Table("cc_payments");
$QUERY = "UPDATE `cc_payments` SET `orders_status`='2' WHERE `id`='".$list_payments[0]['id']."'";
$db_paymentupdate = $payment_table->SQLExec($DBHandle_max, $QUERY, 1);
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." QUERY: ".$QUERY);
/* insert logrefill */
$logrefill_table = new Table("cc_logrefill");
$QUERY = "INSERT INTO `cc_logrefill` (date, credit, card_id, refill_by) VALUES ('".$list_payments[0]['date_purchased']."','".$amount_paid."','".$id."','paypal')";
$db_logrefilladd = $logrefill_table->SQLExec($DBHandle_max, $QUERY, 1);
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." QUERY: ".$QUERY);
/* insert logpayment */
$logpayment_table = new Table("cc_logpayment");
$QUERY = "INSERT INTO `cc_logpayment` (date, payment, card_id) VALUES ('".$list_payments[0]['date_purchased']."', '".$amount_paid."', '".$id."')";
$db_logpaymentadd = $logpayment_table->SQLExec($DBHandle_max, $QUERY, 1);
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." QUERY: ".$QUERY);
$verifystatus = true;
}
/*---- end add credit -----*/
include ("./lib/customer.smarty.php");
// #### HEADER SECTION
$smarty->display('main_empty.tpl');
/* if failed */
if ($verifystatus == false) {
vh_showfailed($error_message);
} else {
/* if success */
vh_showsuccess();
}
// #### FOOTER SECTION
$smarty->display('footer.tpl');
write_log(LOGFILE_EPAYMENT, basename(__FILE__).' line:'.__LINE__." =============== PAYPAL EMAIL VERIFICATION end ==================");
?>