DonationClaim

Players can claim rewards for automatic PayPal donations

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

5/5, 6 likes
  1. Swat1801

    Swat1801 Wood Hoarder Plugin Developer

    Could someone make a tutorial on how to set this up?
     
  2. Earth2Luke

    Earth2Luke Scavenger

    Shouldn't it say 'usergroup add' and not 'addgroup' ?
     
  3. Ludo

    Ludo Naked Wanderer

    Try that for 5.7:

    Code (Text):
    delimiter //
    CREATE DEFINER=`root`@`localhost` PROCEDURE oxide.claim_donation(IN email_address VARCHAR(255))
    BEGIN

    set email_address = REPLACE(email_address,'@@','@');

    set @ID = (
    select    IBN.id
    from    oxide.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 oxide.ibn_table
    SET    claimed = 1, claim_date = NOW()
    WHERE id = @ID;

    select    IBN.item_name
    from    oxide.ibn_table as IBN
    where    IBN.id = @ID;

    END;//
    delimiter ;