Still no email, except this:

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-xxx@localhost' to database 'fictionalley'

mysql error number: 1044

Those references to "fictionalley" were removed from the file about 30 min ago. (I think there were 2 of them.) I had to clear my browser cache for some reason before I'd get the file to download right from vb.org.

ok, cache cleared.

Works great....nice work. :)

Glad to hear it. Thanks for helping me find my slip ups.

Appreciate your help.

kippesp,
We installed your hack on vB 2.2.4, and all was well -- it worked exactly as promised.

But after I upgraded to vB 2.2.5 last week, the hack stopped working -- any idea why? I mean, did I overwrite something that needs to be reinstalled, or is your hack not compatible with 2.2.5?

Also: I would like to set my site default that all users are subscribed to all 8 of my forums when they sign up -- they'd have to go into their CP to unsubscribe. Do you know how I could accomplish this?

hadley,

Is it still not working?

I've gone through this hack again and applyed it to a fresh 2.2.5 vB. It is compatible with 2.2.5. I've also updated my test forum to 2.2.5 and this hack also worked.

Since the hack is mostly contained in one area of newthread.php, I'd start there. (Changes for moderated threads in mod/moderate.php are independent of the changes in newthread.php.) I assume the board still has emails enabled and other emails are working?

As far as forcing subscriptions on a user: Is it okay to hardcode the forumids? Or should the forumid list be controlled through the admin CP? Should users be subscribed on being activated? Or should users be subscribed on registering? If they are subscribed on registering, they will need to be able to access their user CP or you'll have some mightly "T'd" off users who can't unsubscibe themselves.

I'm not sure what this means...

Ditto; sorry. I need to be able to see the list and make changes to it occasionally via the admin CP, but I don't need to assign IDs.

Yes.

No -- I want them to always have the ability to unsubscribe from any or all forums. I currently permit immediate activation -- no validation of email address or COPPA -- but plan to change that as the forums build mass.

Thanks for your help -- and let me know if you want to take this conversation offline -- I wasn't sure...

Won't this potentially create a huge amount of emails? What if you have 8000 users and 50 forums. Say 4000 subsribe to an average of 5 forums. That makes 20,000 subscriptions total. Now let's say each of those forums get's an averge of 10 new threads per day. That would generate 200,000 emails! That's alot of server load on an email server along with bandwidth. Even if you half my numbers in the exmaple it's 100,000 emails! This can be a scary one for active boards...