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. 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 ;
     
  4. Cataclysme

    Cataclysme Shack Builder

    Hi,

    When I used /claim myadress

    Plugin return two @ at my email adress so I can't claim rewards

    Someone can add amount of a donation ? Like that:

    Code (Text):
    "gold":
                  amount (in €): 5
                  usergroup add {0} bronze
    "silver":
                   amount (in €): 10
                   usergroup add {0} silver
    ...