Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 30 Aug 2017, 17:42
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Question Finding all sticky posts

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
Reply With Quote
  #2  
Old 30 Aug 2017, 17:50
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
Pretty simple to do:


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

__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #3  
Old 30 Aug 2017, 19:18
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Thumbs up

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?
Reply With Quote
  #4  
Old 30 Aug 2017, 20:24
Dave Dave is offline
 
Join Date: Jun 2010
Real name: Dave
It should already list that, try:


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

__________________
https://technidev.com - security, development, exploits, vBulletin
dave[at]technidev[dot]com

Contact me for custom vBulletin 3/4 work & server/website management.
Reply With Quote
  #5  
Old 30 Aug 2017, 20:29
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Question

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

--------------- Added 31 Aug 2017 at 16: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 ?
Reply With Quote
  #6  
Old 01 Sep 2017, 00:52
Simon Lloyd's Avatar
Simon Lloyd Simon Lloyd is offline
 
Join Date: Aug 2008
Real name: Simon
Try this
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Kind regards,
Simon Microsoft Office Help
My Mods: Find my modifications here
Please do not pm me for support unless i have invited you to!
Reply With Quote
  #7  
Old 01 Sep 2017, 16:14
kgroneman's Avatar
kgroneman kgroneman is offline
 
Join Date: Aug 2007
Thumbs up

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.
Reply With Quote
Reply

Similar Threads
Thread Thread Starter Forum Replies Last Post
Forum Display Enhancements Separate Sticky Threads\Non Sticky Threads MARCO1 vBulletin 3.8 Add-ons 14 03 Apr 2009 05:41


Tags
sql query, sticky


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

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

Layout Options | Width: Wide Color: