Nefs
Nefs Staff
Hello guys, i have a problem with paypal script, when a player donate, he dont receive his points, and my script is configured perfectly :S why dont work?
<b>Automatic PayPal Donation System.</b><br><br>
The donation costs 4 EUR (incl. VAT).<br>
After the donation you will receive <b>6 points (Tot. 6 points)</b> in your account automatically. <br>Because you donate with PayPal / Creditcard you will receive +2 extra bonus points for free.<br><br>
<b>Here are the steps you need to make:</b> <br>
1. You need a valid creditcard <b>or</b> a PayPal account with a required balance [4 EUR]. <br>
2. Fill in your account number. <br>
3. Click on the donate button. <br>
4. Make a transaction on PayPal. <br>
5. After the transaction 6 points will be automatically added to your account. <br>
6. Go to Item shop and use your points <br> <br> <br> </b>
<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_donations">
<input type="hidden" name="business" value="[email protected]">
<input type="hidden" name="lc" value="GB">
<input type="hidden" name="item_name" value="Nefs 6 points">
<b>Account number:</b> <input type="text" name="custom" value="">
<input type="hidden" name="item_number" value="1">
<input type="hidden" name="amount" value="4.0">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="no_note" value="0">
<input type="hidden" name="no_shipping" value="0">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="notify_url" value="http://www.nefs.es/ipn/ipn.php">
<input type="hidden" name="return" value="http://www.nefs.es">
<input type="hidden" name="rm" value="0">
<input type="hidden" name="bn" value="PP-DonationsBF:btn_donateCC_LG_global.gif:NonHosted">
<input type="image" src="https://www.paypal.com/en_US/i/btn/btn_donate_LG.gif" border="0" name="submit" alt="PayPal - The safer, easier way to pay online.">
<img alt="" border="0" src="https://www.paypal.com/en_US/i/scr/pixel.gif" width="1" height="1">
</form>
<?
$mysql_host = 'localhost'; //Leave at localhost
$mysql_user = 'root'; //DB User
$mysql_pass = 'mypassword'; //DB Pass
$mysql_db = 'mydb'; //DB Name
$custom = stripslashes(ucwords(strtolower(trim($_REQUEST['custom']))));
$receiver_email = $_REQUEST['receiver_email'];
$payment_status = $_REQUEST['payment_status'];
// connect db
$db = mysql_connect($mysql_host, $mysql_user, $mysql_pass);
mysql_select_db($mysql_db, $db);
if ($payment_status == "Completed" & $receiver_email == "[email protected]") {
$query = "SELECT premium_points FROM accounts WHERE accounts.name = '$custom'";
$result = mysql_query($query);
$prem = mysql_fetch_array($result);
$points = $prem['premium_points'] + 12;
// $points = mysql_query($prem)
$qry2 = "UPDATE accounts SET premium_points = '$points' WHERE accounts.name = '$custom'";
$result2 = mysql_query($qry2);
}
else
{
echo("Error.");
}
?>
You will have to give it manual else players can donate like 0.0000000000001 euro and still getting the points for the real amount donation
We can't solve it unless you provide more information.