• 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!

Solved Paygol PROBLEM (Points)

killing

killing

Member
Joined
Feb 23, 2012
Messages
815
Reaction score
11
Location
BIH
Hi all i have BIG PROBLEM with my PayGOL
When player buy's Points i well get his Money but player wont get any Points. <_<

I use Znote AAc 1.4
and uniserver.

paygol_ipn.lua
Lua: 
<?php
    // Require the functions to connect to database and fetch config values
	require 'config.php';
	require 'engine/database/connect.php';
	
	// Fetch paygol configurations
	$paygol = $config['paygol'];

	// check that the request comes from PayGol server 
	if(!in_array($_SERVER['REMOTE_ADDR'],
	  array('109.70.3.48', '109.70.3.146', '109.70.3.58', '31.45.23.9'))) {
	  header("HTTP/1.0 403 Forbidden");
	  die("Error: Unknown IP");
	}

	// get the variables from PayGol system
	$message_id	= $_GET['message_id'];
	$service_id	= $_GET['service_id'];
	$shortcode	= $_GET['shortcode'];
	$keyword	= $_GET['keyword'];
	$message	= $_GET['message'];
	$sender	 = $_GET['sender'];
	$operator	= $_GET['operator'];
	$country	= $_GET['country'];
	$custom	 = $_GET['custom'];
	$points	 = $_GET['points'];
	$price	 = $_GET['price'];
	$currency	= $_GET['currency'];
	
	// FUNCTIONS
	function sanitize($data)/* Security reasons */ {
		return htmlentities(strip_tags(mysql_real_escape_string($data)));
	}
	function user_data($user_id)/* account data */ {
		$data = array();
		$user_id = sanitize($user_id);
		
		$func_num_args = func_num_args();
		$func_get_args = func_get_args();
		
		if ($func_num_args > 1)  {
			unset($func_get_args[0]);
			
			$fields = '`'. implode('`, `', $func_get_args) .'`';
			$data = mysql_fetch_assoc(mysql_query("SELECT $fields FROM `accounts` WHERE `id` = $user_id;"));
			return $data;
		}
	}
	// Since only paygol.com is able to communicate with this script, we will blindly trust them until proven othervise.
	if ($service_id == $paygol['serviceID']) {
		$new_points = (int)$paygol['points'];{
		
		$data = user_data($custom, 'name');
		if ($data['name']) {
			// Sanitize all data: (ok, we do not completely trust them blindly. D:)
			$message_id	= sanitize($message_id);
			$service_id	= sanitize($service_id);
			$shortcode	= sanitize($shortcode);
			$keyword	= sanitize($keyword);
			$message	= sanitize($message);
			$sender	 = sanitize($sender);
			$operator	= sanitize($operator);
			$country	= sanitize($country);
			$custom	 = sanitize($custom);
			$points	 = sanitize($points);
			$price	 = sanitize($price);
			$currency	= sanitize($currency);
			
			// Update logs:
			$log_query = mysql_query("INSERT INTO `znote_paygol` VALUES ('', '$custom', '$price', '$new_points', '$message_id', '$service_id', '$shortcode', '$keyword', '$message', '$sender', '$operator', '$country', '$currency')")or die("Log paygol SQL ERROR");
			
			// Give points to user
			$old_points = mysql_result(mysql_query("SELECT `points` FROM `znote_accounts` WHERE `account_id`='$custom';"), 0, 'points');
			echo 'Custom: '. $custom .'<br>';
			echo "Query: SELECT `points` FROM `znote_accounts` WHERE `account_id`='$custom';<br>";
			echo 'Old points: '. $old_points .'<br>';
			$new_points += $old_points;
			echo 'New points: '. $new_points .'<br>';
			$update_account = mysql_query("UPDATE `znote_accounts` SET `points`='$new_points' WHERE `account_id`='$custom'")or die(mysql_error());
			echo 'Account id 2 shold be updated now!';
			
		} else echo ' character data false';
	
	} else echo 'service id wrong';
	
	// PayGol Form using Post method 
   <form name="pg_frm" method="post" action="http://www.paygol.com/micropayment/paynow" >
       <input type="hidden" name="pg_serviceid" value="68048">
       <input type="hidden" name="pg_currency" value="EUR">
       <input type="hidden" name="pg_name" value="PointS">
       <input type="hidden" name="pg_custom" value="">
       <input type="hidden" name="pg_price" value="1">
       <input type="hidden" name="pg_return_url" value="http://www.paygol.com/micropayment/implementation">
       <input type="hidden" name="pg_cancel_url" value="">
       <input type="image" name="pg_button" src="http://www.paygol.com/micropayment/img/buttons/150/black_en_pbm.png" border="0" alt="Make payments with PayGol: the easiest way!" title="Make payments with PayGol: the easiest way!" >     
    </form>
?>

buypoints.lua
Lua: 
<?php require_once 'engine/init.php';
protect_page();
include 'layout/overall/header.php'; 

// Import from config:
$paypal = $config['paypal'];
$prices = $config['paypal_prices'];

if ($paypal['enabled']) {
?>

<h1><center>Buy Points</center></h1>
<h1><center>!BEFORE YOU DECIDE TO BUY POINTS READ THIS!</center></h1>
<p><center> Our OTs is not responsible for any loss of items and / or money in any way, we only offer the service to keep our server online. All the money goes to server maintenance and not for personal use</center></p>
<h2><center>Buy points using Paypal or PayGol</center></h2>
<h2><center>~Paypal~</center></h2>
<table id="buypointsTable">
	<tr class="yellow">
		<td>Price:</td>
		<td>Points:</td>
		<?php if ($paypal['showBonus']) { ?>
			<td>Bonus:</td>
		<?php } ?>
		<td>Action:</td>
	</tr>
		<?php
		foreach ($prices as $price => $points) {
		echo '<tr class="special">';
		echo '<td>'. $price .'('. $paypal['currency'] .')</td>';
		echo '<td>'. $points .'</td>';
		if ($paypal['showBonus']) echo '<td>'. calculate_discount(($paypal['points_per_currency'] * $price), $points) .' bonus</td>';
		?>
		<td>
			<form action="https://www.paypal.com/cgi-bin/webscr" method="POST">
				<input type="hidden" name="cmd" value="_xclick">
				<input type="hidden" name="business" value="<?php echo $paypal['email']; ?>">
				<input type="hidden" name="item_name" value="<?php echo $points .' shop points on '. $config['site_title']; ?>">
				<input type="hidden" name="item_number" value="1">
				<input type="hidden" name="amount" value="<?php echo $price; ?>">
				<input type="hidden" name="no_shipping" value="1">
				<input type="hidden" name="no_note" value="1">
				<input type="hidden" name="currency_code" value="<?php echo $paypal['currency']; ?>">
				<input type="hidden" name="lc" value="GB">
				<input type="hidden" name="bn" value="PP-BuyNowBF">
				<input type="hidden" name="return" value="<?php echo $paypal['success']; ?>">
				<input type="hidden" name="cancel_return" value="<?php echo $paypal['failed']; ?>">
				<input type="hidden" name="rm" value="2">
				<input type="hidden" name="notify_url" value="<?php echo $paypal['ipn']; ?>" />
				<input type="hidden" name="custom" value="<?php echo sanitize($_SESSION['user_id']).'!'.$price.'!'.$points; ?>">
				<input type="submit" value="  PURCHASE  ">
			</form>
		</td>
		<?php
		echo '</tr>';
		}
		?>
</table>
<?php } ?>

<?php
if ($config['paygol']['enabled'] == true) {
?>
<!-- PayGol Form using Post method -->
<h2><center>~Paygol~</center></h2>
<?php $paygol = $config['paygol']; ?>
<p><center>Please Select An Option : </center></p>
<form name="pg_frm" method="post" action="http://www.paygol.com/micropayment/paynow" >
	<center><input type="hidden" name="pg_serviceid" value="<?php echo $paygol['serviceID']; ?>"></center>
	<center><input type="hidden" name="pg_currency" value="<?php echo $paygol['currency']; ?>"></center>
	<center><input type="hidden" name="pg_name" value="<?php echo $paygol['name']; ?>"></center>
	<center><input type="hidden" name="pg_custom" value="<?php echo $session_user_id; ?>"></center>
	<center><input type="radio" name="pg_price" value="1"checked>100 Points 3 EUR<p></center>
	<center><input type="radio" name="pg_price" value="2">200 Points 5 EUR<p></center>
	<center><input type="radio" name="pg_price" value="3">250 Points 10 EUR<p></center>
	<center><input type="radio" name="pg_price" value="4">1000 Points 50 EUR<p></center>
	<center><input type="hidden" name="pg_return_url" value="<?php echo $paygol['returnURL']; ?>"></center>
	<center><input type="hidden" name="pg_cancel_url" value="<?php echo $paygol['cancelURL']; ?>"></center>
	<center><input type="hidden" name="pg_notify" value="<?php echo $paygol['ipnURL']; ?>"></center>
	<center><input type="image" name="pg_button" src="http://www.paygol.com/micropayment/img/buttons/150/black_en_pbm.png" border="0" alt="Make payments with PayGol: the easiest way!" title="Make payments with PayGol: the easiest way!" ></center>
</form>
<h2><center>IF YOU HAVE ANY QUESTION'S CONTACT OWNER</center></h2>
<p><center>With this Email! [email][email protected][/email]</center></p>
<?php }

if (!$config['paypal']['enabled'] && !$config['paygol']['enabled']) echo '<h1>Buy Points system disabled.</h1><p>Sorry, this functionality is disabled.</p>';
include 'layout/overall/footer.php'; ?>

- - - Updated - - -

- - - Updated - - -

Problem is Solved thanks to Raggaer!!
 
Last edited:
Sort by date Sort by votes

Similar threads

ralke
  • Question
AAC Paypal automatic payments doesn't load points on ZnoteAAC
Replies
4
Views
753
ralke
ralke
ghunalma
  • Question
AAC [Znote AAC] admin_news dont upload images
Replies
3
Views
329
ghunalma
ghunalma
ralke
  • Question
AAC ZnoteAAC show killing assists at characterprofile deathlist
Replies
0
Views
177
ralke
ralke
D
  • Question
i cant pass step 5 gesior on ubuntu 18.04
Replies
3
Views
328
diegoknight95
D
Back
Top