![]() |
Is it possible to search for posts made by 'deleted users'?
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? |
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 ;) |
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. |
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 |
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. |
That is in by default. If it says Last Activity, then that means that haven't been active for a certain period of time.
|
All times are GMT. The time now is 11:33 PM. |
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|