New Feature "User Group" Expire

[MagNaMan]

Hi ALL

What I'm looking for is expire feature.

Two Fields would need to be added to user database
"Expire_Date" and "Expire_to_group"

When setting up new user, set "User Group", Set "Expire_to_date" and "Expire_to_group"

Every time user visits site, expire date is checked against
current date, if current date <= expire date then "User Group" is changed to value of "Expire_to_group"

Anyone up to the task?

MagNaMan

[MagNaMan]

Does anyone know if something like this already exists?

[trafix]

hmmm, i wouldnt mind this hack either......i dont know if i can build it but

[MagNaMan]

well here's sql code to create extra fields

alter table `user`
add column usergroupexpire date not null default '00/00/00' after usergroupid,
add column usergroupexpireid int(5) unsigned not null default 0 after usergroupexire, type=myISAM

[MagNaMan]

When a person first visits bulletin, where is the best place to put code to check?

And change usergroup, etc before completing login

[trafix]

I was thinking more along the line of a premium paid usergroup, when the 12 month period has expired then they will be automaticly downgraded to a lower level (admin set) usergroup. that way i dont have to keep checking manually....maybe an auto pm to member and admin informing them of the downgrade would also be an advantage.

[MagNaMan]

Yep.. Quit reading my mind

[MagNaMan]

So anyone got an idea where I can place code?

I need to know where is a good place to put it. I'm assuming where cookies are read or something like that.

[trafix]

ive got an idea where to put the code ..... but no idae how to code it.....

[trafix]

I can start this hack...

Requires a new column in user table called memexpire

When a member is shifted to the nominated premium user group the date of upgrade will be added to this column.....thats the easy part......

However I have no idea how to code the script to automaticly down grade them at the end of a 12 month period and pm'ing both the member and the admin upon this action.

Not sure but would it be better to add date plus 12 months upon upgradeing to the memexpire column.....not sure how this is done either but when i get time i will have a play with some coding.