bury
Active Member
- Joined
- Jul 27, 2008
- Messages
- 421
- Solutions
- 7
- Reaction score
- 25
-------------------------------------- EDIT 26/08/2017 -----------------------------------
Paygol answered me a ticket and they shared me a sourceforge that they did or someone did for them:
sourceforge.net/projects/paygol-open-tibia/files/
It's only the IPN (report) script. It has been made some days ago so I think it's compatible with Gesior 2012 last update and with PHP 7. It's explained in English and Spanish. The problem is that it doesn't add me the points, the rest is working 100% (reports, service_id and secret_key regconizes my account). Ill share without my credentials.
paygol_report.php:
PHP:
<?php
/*
English:
This script will help you to integrate the PayGol payments platform on your Open Tibia server. Your users will be able to pay and get in-game points immediately and automatically, no need to wait hours or even days for manual delivery.
Before starting, you must create an account at https://secure.paygol.com/signup
For full technical documentation, visit https://devs.paygol.com/en
Steps:
1) Upload this file to your server, try to make it a hard to guess path.
2) Enter the full path to this file into the "IPN URL" field, at the "Notifications" section of your Paygol dashboard.
Example: http://www.yoursite.com/dtz7895/paygol.php
Español:
Este código te ayudará a integrar la plataforma de pagos PayGol en tu servidor Open Tibia. Tus usuarios podrán pagar y obtener sus puntos de inmediato y de forma automática, sin necesidad de esperar horas o hasta días por una entrega manual.
Antes de comenzar, debes crear una cuenta en https://secure.paygol.com/signup
Para ver documentacion técnica adicional visita https://devs.paygol.com/es
Pasos:
1) Sube este archivo a tu servidor, intenta que sea una ruta difícil de adivinar.
2) Ingresa la ruta completa de este archivo en el campo "URL de IPN", en la sección "Notificaciones" de tu panel de Paygol.
Ejemplo: http://www.yoursite.com/dtz7895/paygol.php
*/
// Secret Key of your Paygol account
$secret_key = "xxxxxx-xxxx-xxxx-xxxxxxxxxxxx";
// Secret key validation
if ($secret_key != $_GET['key']) {
echo "Validation error";
exit;
}
// Custom parameter
$custom = $_GET['custom'];
// Get price and currency. Price always has a decimal point and 2 decimals (e.g. 10.00 EUR, 9000.00 CLP).
$frmprice = $_GET['frmprice'];
$frmcurrency = $_GET['frmcurrency'];
// Get points based on the price and currency.
switch ($frmprice." ".$frmcurrency){
// Possible prices and their points. You can add as many as you want.
case "xx.00 EUR": $points = yy; break;
case "xx.00 EUR": $points = yy; break;
case "xx.00 EUR": $points = yy; break;
// If the price doesn't match any of the options above, stop script.
default: echo "Price validation failed";
exit;
}
// Replace this information with your database details
$dbhost = "127.0.0.1"; //Your database domain
$dbuser = "xxxxxx"; //Database username
$dbpassword = "xxxxxxxxxx"; //Database password
$db = "xxxxxxxx"; //Database name
// Connect to database
$conn = mysql_connect($dbhost, $dbuser, $dbpassword);
// Select database
mysql_select_db($db);
// Update points
$sql = "UPDATE `accounts`
SET `premium_points` = `premium_points`+$points
WHERE `name` = '".mysql_real_escape_string($custom)."'";
mysql_query($sql);
// Close database connection
mysql_close($conn);
?>Now, my payment button script.
paygol.php:
PHP:
<b>SMS DONATION</b></CENTER><br /><br />
<ol>
<li>Enter your account number.</li>
<li>Choose your payment price.</li>
<li>Click on the red Pay by mobile button.</li>
<li>Follow the instructions.</li>
<li>Your points will be added automatically.</li>
<li><b>DONT FORGET TO PUT IN YOUR ACCOUNT NUMBER! IF YOU DONT DO IT YOU WONT GET ANY POINTS!</li></b>
</ol>
</br>
<center><b>
<li>xx Premium Points for yy EUR</li>
<li>xx Premium Points for yy EUR</li>
<li>xx Premium Points for yy EUR</li>
</center></b>
</br>
<center><form name="pg_frm" method="post" action="https://www.paygol.com/pay" >
Enter account number:<p>
<input type="text" name="pg_custom" value=""><p>
<input type="hidden" name="pg_serviceid" value="xxxxxx">
<input type="hidden" name="pg_currency" value="EUR">
<input type="hidden" name="pg_name" value="xxxxxxxx">
<input type="radio" name="pg_price" value="xx.00"checked>Buy yy premium points 3.00<p>
<input type="radio" name="pg_price" value="yy.00">Buy xx premium points yy.00<p>
<input type="radio" name="pg_price" value="yy.00">Buy xx premium points yy.00<p>
<input type="hidden" name="pg_return_url" value="xxxxxxxxxxxxxx">
<input type="hidden" name="pg_cancel_url" value="">
<input type="image" name="pg_button" src="https://www.paygol.com/pay-now/images/payment-button.png" boder="0" alt="Make payments with PayGol: the easiest way!" title="Make payments with PayGol: the easiest way!">
</form> </center>I dont know WHY it doesn't add the points. The db is well set because I even checked it in config.lua. In the ticket they told me instead of the numerical order in value="x", now you have to write the amount of money with two decimal numbers, for example value="10.00". I did it and it doesn't add the points.
My account is in test mode to test it, and all the reports are arriving without problem. I also write the custom part properly (acc name).
Where is the problem?
I opened a ticket yesterday and I dont know why my account has been removed, obiously they removed it. Also, my configured service is now disabled (tried it through my website). LOL. I dont know if they've closed or what, but why they didn't even answer the tickets?
B.U.M.P
New info about paygol last update in the OP.
B.U.M.P
OP updated, paygol provides me a new report script updated for their last update they've made in August where services and multi-prices (integrated in services) have been removed. Now, for multi-prices you need the report script they've shared with me, but, it doesn't add the points.
Thanks for your help.
Last edited by a moderator:
