Help with paypal script

[Keiro]

ok...so i configured the paypal script on the gesior acc 0.3.6 as it explain in this thread

http://otland.net/f118/paypal-script-release-24188/#post242798


i did the sandbox test , and i can donate correctly , the transaction is done , but no premmium points are added to the account

i wonder why

pass, db name....are correct

 

[chojrak]

3. Setup the connection at ipn/ipn.php to MySQL

Did you fill variables?

 

[Keiro]

i filled them like this

$mysql_host = 'localhost'; //Leave at localhost
$mysql_user = 'root'; //DB User
$mysql_pass = 'mysqlpass'; //DB Pass
$mysql_db = 'mydbname'; //DB Name

 

[chojrak]

Try using my script:

<?PHP
	$config = array("host" => "localhost", "user" => "root", "password" => "pass123", "database" => "ots", "email" => "PayPal Login", "mc_gross" => 5.00, "points" => 200);
	mysql_connect($config["host"], $config["user"], $config["password"]) or die(mysql_error());
	mysql_select_db($config["database"]) or die(mysql_error());

	if ($_REQUEST['payment_status'] == "Completed" && $_REQUEST['receiver_email'] == $config["email"] && $_REQUEST["mc_gross"] == $config["mc_gross"])
	{
		mysql_query("UPDATE `accounts` SET `premium_points` = `premium_points` + ".$config['points']." WHERE `name` = ".strtolower($_REQUEST['custom']).";");
		$log = fopen("./PayPal.log.txt", "a");
		fwrite($log, ">> ".date('d m Y - g:i A')." | Account: ".$_REQUEST['custom']);
		fclose($log);
		echo "<!-- Realized :) -->";
	}
	else
		echo "An error occured!";
?>

 

[Keiro]

"email" => "PayPal Login"

what should i put there? my email acc? or nothing?

ill try..and btw, if u can explain me exactly how to do the sandbox test ..would be cool, cuz maybe i did smth wrong, and the script doesnt get the "confirmed transaction" so it does not add the points


edit: typo +


i tryied it , same thing, i guess i do the sandbox test wrong.....

<form action="https://www.sandbox.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="Premium 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="10.0">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="no_note" value="0">
<input type="hidden" name="no_shipping" value="0">
<input type="hidden" name="currency_code" value="USD">
<input type="hidden" name="notify_url" value="http://localhost/ipn/ipn.php">
<input type="hidden" name="return" value="http://localhost/">
<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>

 

[frankfarmer]

Change
<input type="hidden" name="notify_url" value="http://localhost/ipn/ipn.php">

To
<input type="hidden" name="notify_url" value="http://localhost/paypal/ipn/ipn.php">

:ninja:

 

[Keiro]

y tryied it, even before u say it ;P but nothing T_T

 

[Keiro]

bump

 

[Kiman]

What TFS version are you using ?

 

[Keiro]

tfs 0.3.6
gesior 0.3.6

 

[exique]

It's not automatic...
It's annoying.. yes.

"You'd just have to add like "Send an email with your character name and paypal email to [[email protected]]."

 

[Kiman]

Try this one, This worked for me 100% People are recieving their points auto

http://otland.net/f118/fixed-paypal-script-38407/

 

[exique]

Don't believe u :S

 

[Kiman]

If you want proof, you should donate to my OT and see for yourself :ninja: