niti
New Member
- Joined
- Nov 22, 2009
- Messages
- 258
- Reaction score
- 2
Hello OTland! I got it all right in my database and so on, but I think there's a missing table in the PMA. So could any1 tell me all the tables I need so they can recieve their points? I'll give rep+
eace: THIS IS ZAYPAY
This is my config
<?php
$price_setting_id = ******; // Id
$price_setting_key = '********************************'; // Hash
$points_to_give = 15; // Points to give after to have paid
$message_to_guests = "You have to login before use this payment!";
$message_on_paid = "You have paid!";
$show_native = 0; // Longer language name, but easier for people without English knowledge
$noIPCheck = 0; // If true, then the default settings will be used instead of IP check
$defaultCountry = 'en-SE'; // format is languageCode-countryCode
$message_to_guests = "You MUST be logged in!";
$redirect = "127.0.0.1";
?>
This is my config
and that one is my report<?php
/*-----------------------------------------------------------------------
Name : report.php
Version : 1.2-PHP5
Description : Retrieve payment information, when triggerd by Zaypay
Date : June 2009, Amsterdam, The Netherlands
By : Zaypay International B.V. 2008 - 2009 (RDF)
Last changes : Made class easier to use and understand
-----------------------------------------------------------------------*/
require_once('includes/config.php');
require_once('includes/Zaypay.class.php');
require_once('includes/database.php');
$Zaypay = New Zaypay($price_setting_id, $price_setting_key);
if (isset($_GET['payment_id'])) {
$zaypay_info = $Zaypay->show_payment($_GET['payment_id']);
$payment_id = $zaypay_info['payment']['id'];
$payment_status = $zaypay_info['payment']['status'];
// Get the ID
$result = mysql_query("SELECT * FROM zaypay_payment WHERE payID='{$payment_id}' LIMIT 1");
$array = mysql_fetch_assoc($result);
// Get current amount of points
$pp = mysql_query("SELECT premium_points FROM accounts WHERE accounts.id = '{$array['account_id']}'");
$points = mysql_fetch_assoc($pp);
$point = $points["premium_points"] + $points_to_give;
// Update to new status in database
mysql_query("UPDATE zaypay_payment SET status = '{$payment_status}' WHERE payID = '{$payment_id}'");
// Only give points if the status is "paid"
if ($payment_status == "paid" && $array["status"] != "paid") {
// Update points in account table
mysql_query("UPDATE accounts SET premium_points = '$point' WHERE accounts.id = '{$array['account_id']}'");
}
}
die ('*ok*');
?>
Last edited: