Stian's (?) PayPal script help..

[zieworski denero]

Hello!

I use Stian's (not sure if it's his script but he is the one who gave me it) PayPal script. When people donates, I receive the money but they doesn't get the points automatically...

perhaps there is something wrong in my ipn.php:

<?php
if ($_REQUEST['debug']) {
ini_set("display_errors", True);
error_reporting(E_ALL);
}
$mysql_host = 'localhost'; //Leave at localhost  
$mysql_user = 'root'; //DB User  
$mysql_pass = '***/'; //DB Pass  
$mysql_db = 'test'; //DB Name  
$file = 'paypal.log'; //Paypal Log Name will be placed in the same location as your ipn.php file 
$payer_email = $_REQUEST['payer_email']; 
$ip = $_SERVER['REMOTE_ADDR'];
if($ip != "66.211.170.66" && $ip != "216.113.188.202" && $ip != "216.113.188.203" && $ip != "216.113.188.204") {
	print "Scammer...";
$hak = fopen("scammer.log", "a");
fwrite($hak, "$ip \r\n");
fclose($hak);
die(0);
}
$time = date("F j, Y, g:i a"); 
$paylist = array("12.00" => 20);

// connect db  

$db = mysql_connect($mysql_host, $mysql_user, $mysql_pass);

$custom = stripslashes(ucwords(strtolower(trim($_REQUEST['custom']))));  
$receiver_email = $_REQUEST['receiver_email'];  
$payment_status = $_REQUEST['payment_status'];  
$mc_gross = $_REQUEST['mc_gross']; 
mysql_select_db($mysql_db, $db);  
if ($_REQUEST['debug']){
print $payment_status . '\n';
print (isset($paylist[$mc_gross])) ? 1 : 0 . '\n';
print $receiver_email . '\n';
print $custom . '\n';
}
if ($payment_status == "Completed" && $receiver_email == "[email protected]" && isset($paylist[$mc_gross])) {  

$query = "SELECT premium_points FROM accounts WHERE accounts.name = '$custom'";  

$result = mysql_query($query);  

$prem = mysql_fetch_array($result);  
$somecode = "'$time' '$custom' '$payer_email' '$mc_gross' '$ip'\r\n";

// figure out how much to give
$give = $paylist[$mc_gross];
$points = $prem['premium_points'] + $give;  
// $points = mysql_query($prem)  
$qry2 = "UPDATE accounts SET premium_points = '$points' WHERE accounts.name = '$custom'";  
// Log Paypal Transaction 
$hak = fopen($file, "a"); 
fwrite($hak, $somecode); 
fclose($hak); 

$result2 = mysql_query($qry2);  
}  
else  
 {   
 echo("Error.");  
 }  
?>

or paypal.htm:

<form action="https://www.paypal.com/cgi-bin/webscr" method="post">
<input type="hidden" name="cmd" value="_xclick">
<input type="hidden" name="business" value="hehehehe@hotmail...">
<input type="hidden" name="lc" value="EUR">
<input type="hidden" name="item_name" value="Forgottens Donations">
<b>Account name/login:</b> <input type="text"  name="custom" value="">

<select name="amount">
  <option value="12.00">12 EUR</option>
</select>
<input type="hidden" name="button_subtype" value="products">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="no_shipping" value="1">
<input type="hidden" name="currency_code" value="EUR">
<input type="hidden" name="notify_url" value="http://forgottens.hopto.org/paypal/ipn/ipn.php">
<input type="hidden" name="return" value="http://forgottens.hopto.org/?subtopic=shopsystem">
<input type="hidden" name="rm" value="0">
<input type="hidden" name="bn" value="PP-BuyNowBF:btn_buynowCC_LG.gif:NonHostedGuest">
<input type="image" src="https://www.paypal.com/en_US/i/btn/btn_buynowCC_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>

People donates 12 EUR for 20 points.. I think I have done everything correctly.

 

[Ninja]

Here

<input type="hidden" name="business" value="your email here">

 

[thedigitaltoast]

You should edit the HTML form to set your PayPal address and as well as the price. PayPal is pretty much doing the whole process for you; but certainly, you need a few lines of code to communicate with PayPal's servers.

thanks for the replay but there is a line saying $file = 'paypal.log'; //Paypal Log Name will be placed in the same location as your ipn.php file could it be I have to amke a file called paypal.log and place my paypal email in there?

 

[Nikkster]

thanks for the replay but there is a line saying $file = 'paypal.log'; //Paypal Log Name will be placed in the same location as your ipn.php file could it be I have to amke a file called paypal.log and place my paypal email in there?

Why on earth would you want to write your email address in the paypal.log file? All PayPal asks for is that you fill in your email address in the HTML form in your paypal.html file. Then, your job with that code is to have the form on your website and send the values through POST requests to PayPal's servers. The user is being forwarded to PayPal to login to his PayPal account. Then, PayPal is returning the results of that process to your server. Stian chose to use $_REQUEST - that he is, later on, used to check if everything was correct. If it was, add x points to $user, otherwise show an error message.

Hope I cleared things up.

 

[DextaaH]

My works with auto points

 

[Ninja]

My works with auto points

Because you have configured your settings correctly and enabled IPN