4 replies to this topic

[Tecca]

Hello,

The donation tracker is exactly what I'm looking for, however, I have one question:

I currently have 40 users that are in a "donator" kind of group. I want to be able to demote them in 1 year starting from a set date (the day I install this mod). Is this possible, without them having to donate again? This is the most important aspect at the moment for me.

[Michael]

Tecca, on 20 May 2010 - 04:07 PM, said:

Hello,

The donation tracker is exactly what I'm looking for, however, I have one question:

I currently have 40 users that are in a "donator" kind of group. I want to be able to demote them in 1 year starting from a set date (the day I install this mod). Is this possible, without them having to donate again? This is the most important aspect at the moment for me.

The donation tracker does have an auto demote function but this can't be applied retrospectively to your current donators. The donations need to be made through the donation tracker because that's when it sets up the auto demote database. The only to get around this would be to manually add your current donators into the auto demote database via the SQL Toolbox. I can provide an example sql query if you need it.

[Tecca]

If you could, that would be great and I could make this purchase.

[Michael]

Tecca, on 21 May 2010 - 05:37 AM, said:

If you could, that would be great and I could make this purchase.

You'll need to insert each member into the database.

INSERT INTO ibf_donate_demote VALUES (NULL, '#1', '#2', '#3', '#4', '#5', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+31536000);

#1 = Member Id
#2 = Members Name
#3 = Previous Group
#4 = Current Group
#5 = Group they'll be demoted to.

Here is an example if my account was in the admin group but I wanted to demote it back to the members in group at the current time + 1 year.

INSERT INTO ibf_donate_demote VALUES (NULL, '1', 'Michael', '3', '4', '3', UNIX_TIMESTAMP(), UNIX_TIMESTAMP()+31536000);

UNIX_TIMESTAMP() is basically the exact date this second that you run the query and the second instance UNIX_TIMESTAMP()+31536000 is the exact date this second plus 1 year.

[Tecca]

Awesome, thank you. Expect a purchase within the next few days. =)