DonationClaim

The user has all the permissions i can give it in cPanel

 

I found i had to run it on my dedicated rust server
[DOUBLEPOST=1477607159][/DOUBLEPOST]With php and mysql

 

I got this after Oxide and Rust Updated today:

[Oxide] 08:09 [Error] Error while compiling DonationClaim.cs(16,18): error CS0246: The type or namespace name `Ext' could not be found. Are you missing an assembly reference?

 

As per new change:
"Namespace changed, Oxide.Core instead of Oxide.Ext for the database extensions."
Oxide.Ext.MySql => Oxide.Core.MySql

I did change the:
using Oxide.Ext.MySql;
to
using Oxide.Core.MySql;

What do I change this line to? (I did try Core replacing Ext and it failed)
readonly Ext.MySql.Libraries.MySql mySql = new Ext.MySql.Libraries.MySql();
[DOUBLEPOST=1478813756][/DOUBLEPOST]Seen you have updated. Thank you.

 

I had just finished typing it when you updated. Acknowledged at bottom last post.
All working well again, Thanks.

 

You did with paypal and if you try the "Mercado Pago" platform?

 

Can you add a feature which adds to the database which steamid actually claimed the donation? Hard to back track to see who's charging back.

 

@Wulf Please help me, my config is set correctly and so is my database. the IPN handshake gets verified but the database entry is not being made.

EDIT: I fixed everything now and I will be testing ClaimDonation asap

MEGA UPDATE: /claim command results in

Code:

MySqlException: Unable to connect to any of the specified MySQL hosts.

I've been working on this for days. The json config is set, the user has the required privileges. What the heck??

 

PayPal can not be used in our country. How do I get paid with skrill? Is something like this possible ?

 

thanks for the answer
How can I create a VIP system
Do you have any information?

 

I love this plugin

 

Is it possible to put a donator in a certain group (group with permissions) at a certain amount of money? And then give to that group for a certain amount of time?

 

Still dealing with the 2nd step here...



I've blanked out the sensitive information.

Attempted using both versions 5.0 & 5.5 through GoDaddy where super is given by default unless purposefully setup otherwise.
[DOUBLEPOST=1487241536][/DOUBLEPOST]

Create donation packages on PayPal for each amount separately.
Then, try "usergroup add" like I've done here... That might work.
About the certain amount of time thing, that's not a feature of the plugin, but perhaps it can be *cough cough*

Code:

{
  "DatabaseHost": "localhost",
  "DatabaseName": "oxide",
  "DatabasePassword": "PASSWORD",
  "DatabasePort": 3306,
  "DatabaseUser": "root",
  "Packages": {
    "5": [
      "usergroup add {0} donor"
    ],
    "10": [
      "usergroup add {0} donor-2"
    ],
    "15": [
      "usergroup add {0} donor-3"
    ],
    "20": [
      "usergroup add {0} donor-4"
    ],
    "30": [
      "usergroup add {0} donor-5"
    ]
  }
}

 

I don't know where to start with this plug in, I know how to download it into the oxide plug ins but after that I'm lost. Just wondering if someone can give a hand?

 

I get same problem (Mysql 5.7)

Thanks

edit:
work :

Code:

CREATE DEFINER='oxide@localhost' PROCEDURE `oxide.claim_donation`(IN email_address VARCHAR(255))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

 

Code:

SQL query: DocumentationSET @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 ) ;MySQL said: Documentation#1054 - Unknown column 'email_address' in 'where clause' 

;

 

Btw. there is little bug.
Plugin adds users to wrong group.

Code:

[Info] [DonationClaim] Covalence.HurtworldPlayer[7656xxxx,   xxxxx] has claimed donation package svip
[Info] [Timed Permissions] ----> unknown (7656xxxxx) - Added to Group: vip for 29.23:59:59.9266390

Code:

"Packages": {
    "vip": [
      "addgroup {0} vip 30d"
    ],
    "svip": [
      "addgroup {0} svip 30d"
    ],
  }

Changing order of packages fixes the problem