Thread: Automatically suspend old profiles ?

Hi all,

i'm interested in a way to automatically suspend or reject profiles which were not logged in for the last x days. Perhaps with a cronjob which checks it every day ?

Would something like this be possible ?
Thanks !

I got help from Boo***'s AntonLV:

PHP Code:

$res = db_res("SELECT `ID` FROM `Profiles` WHERE TO_DAYS(NOW()) - TO_DAYS(`LastLoggedIn`) >= 2");
while($arr = mysql_fetch_assoc($res)) db_res("UPDATE `Profiles` SET `Status` = 'Suspended' WHERE `ID` = '{$arr['ID']}'"); 


But it suspends all profiles which where not logged in for the last 2 days!

Can i use the GetMemberMembershipInfo function to just suspend the standard membership? Or is there a better way ?

It could look like:

PHP Code:

$memlev = getMemberMembershipInfo( $member['ID'] );
if ( $memlev['ID'] != MEMBERSHIP_ID_STANDARD ) 


Thanks for your ideas !

Ok, this is how it works :

PHP Code:

$res = db_res("SELECT `ID` FROM `Profiles` WHERE `Status` = 'Active' AND (TO_DAYS(NOW()) - TO_DAYS(`LastLoggedIn`)) >= 7");
while($arr = mysql_fetch_assoc($res))
{
    $memlev_standard = getMemberMembershipInfo( $arr['ID'] );
    if ( $memlev_standard['ID'] == MEMBERSHIP_ID_STANDARD )
    db_res("UPDATE `Profiles` SET `Status` = 'Suspended' WHERE `ID` = '{$arr['ID']}'");
} 


Where did you install this code ?

Thanks!!!

Ashley

I put this code in my periodic/notifies.php under

PHP Code:

set_time_limit( 36000 );
ignore_user_abort(); 


I set up a cronjob every 5 minutes, so my "old" standard profiles are checked every 5 minutes. I did that because i don't want "standards" to be shown on my site