Contextual Forum Subscriptions Hack

This hack is similar to the "2.0 Email new thread notifictions to subscribed users" hack by chrispadfield. My hack is an enhanced replacement to the Padfield hack.

Without this hack, subscribing to a forum does nothing but add the forum to one's user CP. By installing this hack, an email will be sent with the post's content when a new thread is posted.

The major differences between this hack and the Padfield hack are:[list=1][*]Email notification contains the posted text.[*]When posting a new thread to moderated forums, notification will be delayed until the thread is approved. This also works with Wayne Luke's moderate user hack.[/list=1]This hack has been tested on vBulletin 2.2.1 through 2.2.5.

Post any problems/suggestions here. My users like it as is but would appreciate any improvement.

[Erwin]

This is a great idea. I will install it after work.

[chrispadfield]

Cheers for doing this looks good.

[Smoothie]

installed on ver 2.2.2. Not getting emails to subscribed forums.

[Smoothie]

I did however get an email:

Database error in vBulletin 2.2.2:

Invalid SQL: SELECT user.username,user.email
FROM subscribeforum,fictionalley.user
WHERE subscribeforum.forumid='55'
AND subscribeforum.userid=user.userid
AND user.userid<>'42'
mysql error: Access denied for user: 'xxxx-xxxx@localhost' to database 'fictionalley'

mysql error number: 1044

[kippesp]

YIKES! My board has special queries. Very sorry about that!

I've fixed that now. The new file does not reference a special user database. (My board has userdata in a different DB!) I'll double check my work, but it should work without errors now.

I've also added to the description in case you're unfamilure with the Padfield hack. It won't send notifications of your own posts. And it isn't all posts. Only new threads.

[Smoothie]

ok, I'll give it another shot...

Thanks!

[Smoothie]

# When posting a new thread to moderated forums, notification will be delayed until the thread is approved. This also works with Wayne Luke's moderate user hack

Hi-
Is there a way to avoid this step? In other words is there a way for emails to be sent without first having the thread approved?

[kippesp]

Originally posted by Smoothie
Hi-
Is there a way to avoid this step? In other words is there a way for emails to be sent without first having the thread approved?

Sure. Take out the check for $visual in newthread.php. So what was:
if ($enableemail and $visible) {

now becomes

if ($enableemail) {

If this is how you want to use it, you would not need any of my changes to mod/moderate.php.

[Smoothie]

Thanks again! Installing now.