vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=325556

Finding all sticky posts
by kgroneman
30 Aug 2017 18:42

I've got a lot of forums and a lot of moderators. Sometimes they forget about a sticky post and it gets out of date and needs to be unstuck.

This sql query will show all sticky posts: SELECT * FROM `vb_thread` WHERE sticky = 1

However, it doesn't give me the information in easily readable format I'm looking for. What I want is a query that will show me:
  • The specific forum
  • The title of the sticky post
  • The author of the post
Would someone that knows a lot more about querying be able to help me refine my query to show that information? I would be very appreciative.

Thanks in advance. - Kim

Dave 30 Aug 2017 18:50

Pretty simple to do:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


kgroneman 30 Aug 2017 20:18

Quote:

Pretty simple to do:
Simple for you anyway. Thanks!

I tried that and it gives me the thread.title and the thread.postusername, but not the forum.title. Can it easily be tweaked a bit to list the forum too?

Dave 30 Aug 2017 21:24

It should already list that, try:


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


kgroneman 30 Aug 2017 21:29

Yes! Thank you. It works as I had hoped. :up:

--------------- Added 31 Aug 2017 at 17:23 ---------------

One more question if I may. I added the option to sort by date:

Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Is there a way to have it display a readable date instead of the unix timestamp such as YYYY-MM-DD ?

Simon Lloyd 01 Sep 2017 01:52

Try this
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.


kgroneman 01 Sep 2017 17:14

Thanks Simon and Dave. You've just made managing sticky posts across a lot of forums a lot easier. I sincerely appreciate the time you've taken to assist me. :up: :up: :up:


All times are GMT. The time now is 05:07.

Powered by vBulletin® Version 3.8.14
Copyright © 2020, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.