Could someone make a tutorial on how to set this up?
DonationClaim
Moved
Total Downloads: 650 - First Release: May 20, 2016 - Last Update: Nov 10, 2016
- 5/5, 7 likes
-
-
Code:delimiter // CREATE DEFINER=`root`@`localhost` PROCEDURE oxide.claim_donation(IN email_address VARCHAR(255)) BEGINset 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 ;
-
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:"gold": amount (in €): 5 usergroup add {0} bronze "silver": amount (in €): 10 usergroup add {0} silver ...
-
I never really used IPN before. How does this work the user donates, and paypal redirects to ipn.php?
-
-
-
Hi. i just updated my server recently for the first time in awhile and after updating donation claim when someone tries to do /claim (email) i get this error in console.
(13:23:38) | MySql handle raised an exception in 'DonationClaim v1.0.2' plugin (MySqlException: Incorrect number of arguments for PROCEDURE rust.claim_donation; expected 2, got 1)
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] in <filename unknown>:0
at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int64& insertedId) [0x00000] in <filename unknown>:0
(13:23:38) | MySql command callback raised an exception (NullReferenceException: Object reference not set to an instance of an object)
at Oxide.Plugins.DonationClaim+<ChatCommand>c__AnonStorey0.<>m__0 (System.Collections.Generic.List`1 list) [0x00000] in <filename unknown>:0
at Oxide.Core.MySql.Libraries.MySql+MySqlQuery+<>c__DisplayClass24_0.<Handle>b__0 () [0x00000] in <filename unknown>:0 -
Does this plugin allow you to set a claim maximum? Like after 2 months, they can't claim it anymore? I'm asking because our donation kits on my servers are only to be used once a month for two months. After that they have to re-donate.
-
I have a question about this plugin, we're currently using GPay as donation gateway. But does this plugin also allow to grab the buyers' address when they donate? We need something like that for some legal reasons at the moment
-
Hello can you make maybe a tutorial on youtube?
-
I have my database set up and I am successfully testing the IPN connection but mySQL is not getting input from the test. Any suggestions?
-
Work in 2018? i see Last Update: Nov 10, 2016
Im go test. -
Sure would be nice to get a fix for this line 4 error...
Code:Error SQL query:CREATE DEFINER = `root`@`localhost` PROCEDURE oxide.claim_donation(IN email_address VARCHAR( 255 ) ) BEGIN SET email_address = REPLACE( email_address, '@@', '@' ) ;MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4
-
I found part of the problem. You must have ROOT access to the SQL server, without it you will get nowhere. Sites that use shared SQL servers will NOT work! I use Godaddy and they said there is no way they would grant that kind of access to a shared service. I hope this helps a little and saves someone some time... For the folks that cant get this one to work try GPay. It's fairly easy to set up and works well and they worry about all the background workings...