Need to log everyone out.
 

Ive done some modifications to my forum, before i re open it i need to log everyone out (including ones with "log me back in when i visit" clicked in the user cp). Is there some sort of query i can run to do this?

can you even do something like this? because as long as they have the cookie aren't they logged in?

Run this query - this will make everyone not have their usernames and passwords remembered - they will have to manually return to their User CP to switch it on, or you can change the 0 to 1 to set them all back on:

Erwin: will that log everyone out with a current session to? BTW thanks for the help :)

BTW:

Im doing this for a april fools joke im ganna pull, my members acused me of running out of ideas so this year im ganna pull a big one ;). Basicly when someone logs in they will get randomly logged in as anthor member, ive set it up so they cant access the user cp/private messages while its on, and they cant log in as admins or super mods/mods. It may sound stupid but i own a forum where everybody knows everybody, we are like a close family :).

Are you serious???!! :) That is one big April Fools joke! Be careful with your hacking!

Im testing it on localhost right now :). I may release it once its working with no errors, id really hate for something like this to log someone in as a admin or something LOL.

LOL! It'll be all good as long as you backup right before. Then even if it all goes wrong you can always restore from backup when the "fun" is over. ;)

Although, couldn't you just use replacements do create a similar effect? Just make a replacement set where "Username1" changes to "Username6" and so on, and when #1 logs in, it will say "Welcome Username6" and all their posts that day will have the names all switched. Then simply delete the replacements and there's no mess to clean up. :)