[PassLab.net]

Originally Posted by djbaxter

Would this do it?

Find:

$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' LIMIT $quantity");

Change to:

$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");
$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]'  AND . TABLE_PREFIX . "usergroup != 20 AND emailDate < '$datetime[lastemail]' LIMIT $quantity");

Originally Posted by C Braithwaite

that is something i never thought of - i will update that in the php later today. cheers

Well guys, I really loved this hack thanks Braithwaite! and thanks djbaxter for your help...

I ve installed this hack last week. I ve just noticed that it still sends e-mails to the banned users...

what should I do? Banned usergroup is 8 in my board and I didnt add them in the AdminCP where it says:

List the usergroups that you wish to send the emails to here. (Seperate by commas) eg. 2,3,4,7

the remindermail.php which I ve got from you is like this:

$result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");
	$vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16 LIMIT $quantity");

how are we gonna fix this?

thanks a million