Is there a tutorial available for a complete nub who has no idea how to set it up?
DonationClaim
Moved
Total Downloads: 650 - First Release: May 20, 2016 - Last Update: Nov 10, 2016
- 5/5, 7 likes
-
Wulf Community Admin
-
Okay mate thanks, I'll have a bash tomorrow, much appreciated
-
Hello, firstly, sorry for my english, i'm french, so it's normal if i made a lot of mistakes... I hope you'll understand me !
So, I have an error on my sending request, for the seconde request. This is the code i try to send to my database (database name : 98245_sql, database user : w_98245) :
Code:CREATE DEFINER=`w_98245`@`localhost` PROCEDURE 98245_sql.claim_donation(IN email_address VARCHAR(255)) BEGINset email_address = REPLACE(email_address,'@@','@');set @ID = ( select IBN.id from 98245_sql.ibn_table as IBN where IBN.iemail = email_address and IBN.claimed = 0 and IBN.claim_date IS NULL and IBN.ipaymentstatus = "Completed" ORDER BY IBN.itransaction_date DESC LIMIT 1);UPDATE 98245_sql.ibn_table SET claimed = 1, claim_date = NOW() WHERE id = @ID;select IBN.item_name from 98245_sql.ibn_table as IBN where IBN.id = @ID;END
Code:CREATE DEFINER=`w_98245`@`localhost` PROCEDURE 98245_sql.claim_donation(IN email_address VARCHAR(255))
PS : i change my delimiter to $$ instead ;
Any help possible ? Thank you
Tita Leingue
EDIT : The request probably works with this line :
Code:CREATE DEFINER=`w_98245`@`%` PROCEDURE 98245_sql.claim_donation(IN email_address VARCHAR(255))
For informations, i test to send a simulation with IPNSimulator with my IPN Handler URL = http://rustofstrangers.mtxserv.fr/ipn.php but doesn't workLast edited by a moderator: Aug 22, 2016 -
For the webserver does this have to be on my server's website or can I make a localhost webserver in windows server 2012 and it will still work?
-
Last edited by a moderator: Aug 24, 2016
-
Ok! I have my Buy Now button, but where do i put the button ? Yes i know kinda noob lol.
Hope someone can help me out. -
You just paste it in the html body
-
I have read the overview to fast I do not have a business account with paypal -
You can simply upgrade to either premiere or business. Premier is basically for 1 person business and business is for organisation. To do so follow the following:
1. Change to classic view
2. Go under my account
3. Click upgrade -
I am from europe - the netherlands and normal we need to fill in tons of information if we want a business accounts.
Thanks!
[DOUBLEPOST=1472076922][/DOUBLEPOST]
Thats in the ipn.php right ?
Before or after the php code ?Last edited by a moderator: Aug 24, 2016 -
When i am edit the button do i need to
Add advanced variables ?
Example
address_override=1notify_url=https://www.mywebsite.com/PayPal_IPN
Thats where i point to the ipn.php right ?
In that way i only have to put the html button on my website! -
Wait I think I am wrong I think it gets linked to the ipn on your PayPal. Anyway I am going to try set this up either tonight or tomorrow and I will let you know how you go.Last edited by a moderator: Aug 25, 2016 -
Did everyting but now i am stuck again.
Code:IPN was not sent, and the handshake was not verified. Please review your information.
Last edited by a moderator: Aug 26, 2016 -
Hey Wulf !
I have one problem with this mod
My server is with MySQL 5.5
I have a syntax problem with the first request without information about error :/
Can i do a tutorial in French when it's ok ?
If you want, i can explain with my words in English too -
Cause you will need to add `
Code:CREATE TABLE IF NOT EXISTS `oxide.ibn_table` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `itransaction_id` VARCHAR(60) NOT NULL, `ipayerid` VARCHAR(60) NOT NULL, `iname` VARCHAR(60) NOT NULL, `iemail` VARCHAR(60) NOT NULL, `itransaction_date` DATETIME NOT NULL, `ipaymentstatus` VARCHAR(60) NOT NULL, `ieverything_else` TEXT NOT NULL, `item_name` VARCHAR(255) DEFAULT NULL, `claimed` INT(11) NOT NULL DEFAULT '0', `claim_date` DATETIME DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MYISAM AUTO_INCREMENT=9 DEFAULT CHARSET=LATIN1;
-
I add it
Syntax error for stored procedureLast edited by a moderator: Aug 27, 2016 -
-
So you confirm my bug ?
-
Wulf Community Admin