DonationClaim

Players can claim rewards for automatic PayPal donations

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

5/5, 6 likes
  1. Rainbow™

    Rainbow™ Wood Hoarder

    Is there a tutorial available for a complete nub who has no idea how to set it up? :)
     
  2. Wulf

    Wulf Community Admin Community Admin Oxide Developer

    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. Rainbow™

    Rainbow™ Wood Hoarder

    Okay mate thanks, I'll have a bash tomorrow, much appreciated :)
     
  4. Tita LeDingue

    Tita LeDingue Naked Wanderer

    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 (Text):
    CREATE DEFINER=`w_98245`@`localhost` PROCEDURE 98245_sql.claim_donation(IN email_address VARCHAR(255))
    BEGIN

    set 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 (Text):
    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 (Text):
    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: Aug 22, 2016
  5. 4lex

    4lex Wood Hoarder

    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. RDBGaming

    RDBGaming Scavenger

    Should work on both, cause it connects with your MYSQL
     
    Last edited: Aug 24, 2016
  7. RDBGaming

    RDBGaming Scavenger

    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. 4lex

    4lex Wood Hoarder

    You just paste it in the html body
     
  9. RDBGaming

    RDBGaming Scavenger

    Thanks for the information.
    I have read the overview to fast I do not have a business account with paypal :(
     
  10. 4lex

    4lex Wood Hoarder

    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
     
    RDBGaming likes this.
  11. RDBGaming

    RDBGaming Scavenger

    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!
    --- Double Post Merged, Aug 25, 2016 ---
    To come back on this.
    Thats in the ipn.php right ?

    Before or after the php code ?
     
    Last edited: Aug 25, 2016
  12. RDBGaming

    RDBGaming Scavenger

    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. 4lex

    4lex Wood Hoarder

    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: Aug 25, 2016
  14. RDBGaming

    RDBGaming Scavenger

    Did everyting but now i am stuck again.
    Code (Text):
    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: Aug 26, 2016
  15. Cataclysme

    Cataclysme Shack Builder

    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. RDBGaming

    RDBGaming Scavenger

    Do you mean to create the database table ?
    Cause you will need to add `

    Code (Text):
    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. Cataclysme

    Cataclysme Shack Builder

    I add it
    Syntax error for stored procedure
     
    Last edited: Aug 27, 2016
  18. RDBGaming

    RDBGaming Scavenger

    I am trying for days to get everthing to work, but still no luck!
     
  19. Cataclysme

    Cataclysme Shack Builder

    So you confirm my bug ?
     
  20. Wulf

    Wulf Community Admin Community Admin Oxide Developer

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