Is it possible to search for posts made by 'deleted users'?

[Megatr0n]

There's users who I deleted who contributed thousands of posts but forgot to Prune all their posts/threads. They appear as guest now. Anyway you can search for them and delete them? A friend of mine I might be able to execute an SQL command?

Maybe a hack?

[Jase2]

Try:

DELETE FROM post WHERE username='name' AND userid='0';

Run the following after running that query:

Admin CP -> Import & Maintenance -> Update Counters -> Remove Orphan Posts & Rebuild Thread Information

Remember to backup your database before even running the query ;)

[Megatr0n]

Awesome, thanks man. :D

One more thing. How do I turn on the option where you can see which, thread a user is viewing when you click on their profiles? Just like here on vb.org.

[Jase2]

It should do that automatically.

If you're on about the Currently Active Users Viewing This Thread: at the bottom of a thread, then you need enable it be doing the following :

ACP --> vBulletin Options --> Thread Display Options (showthread) --> Show Users Browsing Threads

[Megatr0n]

Jason,

No, when you access someone's profile it tells you what thread they're viewing. For example, when I access your profile (whilst typing this post) it says Viewing Thread Request: Mod Upgrade for 3.7.0 @ 20:55

On my forum when accessing someone's profile it just gives us the time of his/her last activity.

[Jase2]

That is in by default. If it says Last Activity, then that means that haven't been active for a certain period of time.