Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides
Register
FAQ
It is currently Tue Jun 06, 2023 7:59 am

ROOT ‹ Website Development and Databases ‹ PHP and other web technologies ‹ Phpbb: How to list the most/least viewed topics

Post a reply

Phpbb: How to list the most/least viewed topics

« Previous topic | Next topic »
Author Message
mandrei99
Post  Post subject: Phpbb: How to list the most/least viewed topics  |  Posted: Fri Jan 23, 2015 7:43 pm

Joined: Tue Aug 04, 2009 9:16 am
Posts: 250

Offline
 

Phpbb: How to list the most/least viewed topics

Two mysql SELECT queries using select on "topic_views" column will show the most or the least viewed articles in the forum.

List most viewed articles in phpbb forum:


Code:
SELECT topic_id,topic_title,from_unixtime(topic_last_post_time) AS Post_date ,topic_views FROM phpbb_topics WHERE (topic_approved='1' AND topic_reported='0') ORDER BY topic_views DESC LIMIT 0, 40;


List most viewed articles in phpbb forum:


Code:
SELECT topic_id,topic_title,from_unixtime(topic_last_post_time) AS Post_date ,topic_views FROM phpbb_topics WHERE (topic_approved='1' AND topic_reported='0') ORDER BY topic_views ASC LIMIT 0, 40;



Top
Display posts from previous:  Sort by  
 E-mail friendPrint view
Post a reply

Topics related to - "Phpbb: How to list the most/least viewed topics"
 Topics   Author   Replies   Views   Last post 
There are no new unread posts for this topic. Google reCaptcha not showing in phpbb 3 after moving from HTTP to HTTPS

mandrei99

4

6728

Sat Feb 28, 2015 8:19 am

Abraham12li View the latest post

There are no new unread posts for this topic. PHPBB-SEO sets canonical URL to http when server protocol is set to HTTPS

mandrei99

0

3013

Mon Feb 16, 2015 3:51 pm

mandrei99 View the latest post

 

Who is online
Users browsing this forum: No registered users and 0 guests
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum
Jump to:  
News News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list


ROOT ‹ Website Development and Databases ‹ PHP and other web technologies
Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]



phpBB SEO