Donation Coins

[Joe9099]

Hey guys, just wanting some help with something kinda annoying..
Right i have got the Paypal script from Asumi, which so far works great EXCEPT one thing, it dont send the coins to the account once bought..

It Does however get to the success.php page and show that you have bought them etc and gives that code blalbalba, but the coins just dont send...

I use the Login table and have a column called euCoins, in which i think this script already (Default) updates that column with the coins..

Anyone know my problem?
Thanks.

[MentaL]

[Tyler]

May I see the script?

[Joe9099]

u can download it somewhere lawl, search paypal and you get a topic made by asumi and its there...

But yea, anyone know the problem?

[mikethemak]

It's easier if you just list the script. You need to add somehwere (Where you want it to add the coins, ie: After you get the success message) a php script giving mssql to update your coins.


Example:

mssql_query("UPDATE Account SET euCoins= euCoins + 1 WHERE UserID='".$_SESSION['username']."'");

(I didnt test that, nor is it perfect, but its the base of what you need, you should be able to figure it out from that.)

[Joe9099]

mssql_query("UPDATE Login SET euCoins='euCoins + $amount' WHERE UserID='$account'");

Dont work lol its in the ipn_success.php

[Linear88]

mssql_query("UPDATE Login SET euCoins='euCoins + $amount' WHERE UserID='$account'");

Dont work lol its in the ipn_success.php

/** Fix by Linear88. Please do not remove. **/
mssql_query("UPDATE Login SET euCoins=euCoins + '$amount' WHERE UserID='$account'");

Try this one.

[Joe9099]

Strange, nothing still works, anyone else got this problem with asumi's buy coins script?

Anyone wanna test it for me lawl?

Thanks anyway linear, <3