[Hialls]

Hmm i didn't find where contrib was added while users paid to a subscription...

so i changed the code slightly if anyone else wants it here is what to do..

Replace:

PHP Code:

$getusers = $DB_site->query("
        SELECT userid,username
        FROM user
        WHERE contrib = '1'
    "); 


With:

PHP Code:

$getusers = $DB_site->query("
        SELECT userid,username
        FROM user
        WHERE (usergroupid IN (7) OR CONCAT(',', membergroupids, ',') LIKE '%,7,%')
    "); 


Where 7 is the usergroup users are added to when they subscribe.