The Arcive of vBulletin Modifications Site. |
|
Details »»
|
|||||||||||||||||||||||||
I have set up the option to allow you to get an email with each thread that you are subscribed to or get just the one as it is set to as the default with vBulletin.
I have already set up the user table with new row called notifyall and have this as an option in the modifyoptions template. sendnotification function of the functions.php file you have Code:
$useremails=$DB_site->query("SELECT user.*
FROM subscribethread,user
WHERE subscribethread.threadid='$threadid'
AND subscribethread.userid=user.userid
AND user.userid<>'$userid'
AND user.lastactivity>'$lastposttime[dateline]'");
Code:
if ($bbuserinfo['notifyall']!=0) {
$useremails=$DB_site->query("SELECT user.*
FROM subscribethread,user
WHERE subscribethread.threadid='$threadid'
AND subscribethread.userid=user.userid
AND user.userid<>'$userid'");
} else {
$useremails=$DB_site->query("SELECT user.*
FROM subscribethread,user
WHERE subscribethread.threadid='$threadid'
AND subscribethread.userid=user.userid
AND user.userid<>'$userid'
AND user.lastactivity>'$lastposttime[dateline]'");
}
As it is though the above doesn't see the first check of if ($bbuserinfo['notifyall']!=0) { so that it can run the if/else so..........I was wondering what I should use in here to check the user table for notifyall to see if it is set to 1 or 0 and $useremails works as selected by this choice. Thanks, Parker Show Your Support
|
|||||||||||||||||||||||||
![]() |
|
|