DonationClaim

Moved

Total Downloads: 650 - First Release: May 20, 2016 - Last Update: Nov 10, 2016

5/5, 7 likes
  1. Is there a tutorial available for a complete nub who has no idea how to set it up? :)
     
  2. Wulf

    Wulf Community Admin

    Pretty much what is on the Overview and tips provided in this thread. It's not a simple setup really, hopefully I can whip up an easier one soon.
     
  3. Okay mate thanks, I'll have a bash tomorrow, much appreciated :)
     
  4. 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
    Is this w_98245 and localhost in first line ?
    Code:
    CREATE DEFINER=`w_98245`@`localhost` PROCEDURE 98245_sql.claim_donation(IN email_address VARCHAR(255))
    This is the error i get : #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

    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))
    Now, i don't understand what i must do with the IPN Listener, and which file i can change to create a donation form on my website... Need help pls, i think i'm a newbi.

    For informations, i test to send a simulation with IPNSimulator with my IPN Handler URL = http://rustofstrangers.mtxserv.fr/ipn.php but doesn't work
     
    Last edited by a moderator: Aug 22, 2016
  5. 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?
     
  6. Should work on both, cause it connects with your MYSQL
     
    Last edited by a moderator: Aug 24, 2016
  7. 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.
     
  8. You just paste it in the html body
     
  9. Thanks for the information.
    I have read the overview to fast I do not have a business account with paypal :(
     
  10. 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
     
  11. Wow i did not know that was so easy.
    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]
    To come back on this.
    Thats in the ipn.php right ?

    Before or after the php code ?
     
    Last edited by a moderator: Aug 24, 2016
  12. 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!
     
  13. Yeah I believe so but you can also set the return URL in the settings of your PayPal.
    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
  14. Did everyting but now i am stuck again.
    Code:
    IPN was not sent, and the handshake was not verified. Please review your information.
    Anyone who have got the whole thing working 100% and want to help me out ?
     
    Last edited by a moderator: Aug 26, 2016
  15. 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
     
  16. Do you mean to create the database table ?
    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;
     
  17. I add it
    Syntax error for stored procedure
     
    Last edited by a moderator: Aug 27, 2016
  18. I am trying for days to get everthing to work, but still no luck!
     
  19. So you confirm my bug ?
     
  20. Wulf

    Wulf Community Admin

    There are some tips in the previous pages to get it working 100%.