query to run
 

My guess:

DELETE FROM forumsubscription WHERE userid = 250

Stupid server time is messed up. :(

to unsubscribe a user from a certain forum? Example, userid=250, forumid=64. For some reason a former mod is still subscribed to our mod forum and is receiving email notification of new posts. Even though he has been removed as a mod from all forums.

[sql]
DELETE FROM forumsubscription WHERE userid = 250 AND forumid = 64;
[/sql]

Is there a way to do this forumwide, instead of having to do it for each forum?

I thought that might be it, but I wanted confirmation just to be sure. Thank you, sir. ;)

LOL I almost missed this message. When I clicked on the link in the email notification, the message I was taken to was my last one. Good thing I scrolled up. ;)

Yep, the server time was messed up for a few minutes. Thankfully not much longer than that.

Hmm, got this after I ran the query;

Ah well, I just went into the table subscribeforum and manually deleted the userid from that forumid.

How did you do that? I just went into phpmyadmin, but I don't know how to get inside the table to delete anything.

table subscribeforum, click browse. Sort by userid or forumid.