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:
Thanks in advance. - Kim
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
Thanks in advance. - Kim
Comment