• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

Not recieving their points when they donate?

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+ :peace: THIS IS ZAYPAY

<?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

<?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*');

?>
and that one is my report
 
Last edited:
Oh god did you installed everything properly?
First file what you give is config.
And in include folder, theres another config to database. You should fill it too. With user, password and database name.
 
Back
Top