Changes to the Forums (Pages and Stats) Post: 303026707

Sponsored Content

The Lounge What is on Your Mind? Changes to the Forums (Pages and Stats) Post 303026707 by Neo on Sunday 2nd of December 2018 02:48:33 AM

12-02-2018

Administrator

Update:

MySQL query for homepage featured thread is now:

Code:

SELECT * FROM thread WHERE forumid IN (160,30) AND visible=1 AND replycount > 3 ORDER BY lastpost DESC LIMIT 1

where forumid 160 is the beginners forum and forumid 30 is the shell scripting forum. I will likely add more forum ids to this query in the near future.

I may also use a random number and select the forum or even the order of the query based on one or more random numbers; but for now I'm going to order by lastpost and select from an array of forumids. The reason for this is I want the most recent thread with an updated post, from the array of forumid shown the home page.

Also, I plan to add some VueJS reactive code with some new features, later this year or early in 2019, to the home page. As always, the "original home page" will be available via a link in the menu bar.

Nothing has changed that much, except I created a new page and made the new page the "home page" and moved the "old forum home page" to the navbar link.

We need a more dynamic, front page and the "stats on the front page" created too many links and these links cause all major search engines to complain which in turn hurts our home page SEO. Plus, when visit the home page, I prefer to see the latest, hottest discussion.

In addition, the 15 similar thread links for dynamically changing discussions on the home page will keep the forum interesting and will keep the links changing for search engines. www.unix.com has moved from #4 to the middle of the third page on Google SERP for keyword unix and I want to see if having more dynamic content on the home page will improve this and get us back the page #1.

Update: Added the forumid of the the solaris forum to the home page featured discussion mix:

Code:

SELECT * FROM thread WHERE forumid IN (160,30,43) AND visible=1 AND replycount > 3 ORDER BY lastpost DESC LIMIT 1

I am also thinking it is good for members to have their posts featured on the home page so directly and prominently. I may increase the replycount limit to > 4 in the future. Let's see.

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

8 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

I/O Stats Metrics

What do others use for measuring I/O statistics? I'd like something versatile, as in being able to watch (like iostat, but easier to trend), generate load (like iozone, but more realistic), and perform somewhat generalized benchmarks (like bonnie, but more current.) It would scale from a few...

2. AIX

system stats

I recieved this out put below soemhow. Unfortunatly I did not write down the command I used to get it. Can someone tell me what command I use to gather these stats? OS = AIX 5.3 64Bit System Model: IBM,7026-6H1 Machine Serial Number:...

3. AIX

IO Stats

Aix 5.3 I am trying to view the IO stats. I do the sar 5 5 but that is the WIO and si different than the IO stats right? I am just blanking on this. I know there is a command that I used to run that brings up a whole bunch of live stats that run live such as mem and so on just can't rememeber...

4. AIX

can I use ps to log overall system stats.

Hi I'm writing a script to get overall system memory and cpu utilization in percentages, much like in top or with AIX's topas. Could I use 'ps' to get the same, I know I can get such results for a particular or group of PIDs but I haven't been able to figure out how I could use 'ps' to give me...

5. What is on Your Mind?

Tapatalk Stats for Forums (Android v. iPhone)

Interesting... for both the iPhone and Andriod phones, so far browsing forums using the Tapatalk apps is rare. Seems folks like the web (browser) format better. With new tablets coming out, I think this trend (browser on tablets v. special apps) will continue. I was surprised, however, that...

6. Shell Programming and Scripting

Using Stats in Php

So, I have a php program that i need to delete ALL files in a directory that are older than a certain age. <?php /* Get file stat */ $stat = stat('/apps/security/ajaba'); This is as far as I've been able to get. I know in shell programming you can easily do something like this. but I'm...

7. Linux

Stats on subdirectories

Please help me with a shell script to get the stats on many subdirectories (sub1), (sub2) etc under a mother directory (big) /big | |_______sub1 |_______sub2 |_______sub3 --------- I want to know 1. What is the last file accessed in each subdirectory with date and by whom 2....

8. What is on Your Mind?

Moved Advanced Stats to Search Results Pages

FYI, today I moved the "Advanced Stats" page from the forum home page to the search results pages. This means that at the top of the search results like "Today's Post" and "New Posts" and keyword searches, the stats will appear at the top of that page instead of the home page. The reason of...

LEARN ABOUT SUSE

sql::statement::termfactory

SQL::Statement::TermFactory(3)				User Contributed Perl Documentation			    SQL::Statement::TermFactory(3)

NAME

       SQL::Statement::TermFactory - Factory for SQL::Statement::Term instances

SYNOPSIS

	 my $termFactory = SQL::Statement::TermFactory->new($stmt);
	 my $whereTerms = $termFactory->buildCondition( $stmt->{where_clause} );
	 my $col = $termFactory->buildCondition( $stmt->{col_obj}->{$name}->{content} );

DESCRIPTION

       This package implements a factory to create type and operation based terms.  Those terms are used to access data from the table(s) - either
       when evaluating the where clause or returning column data.

       The concept of a factory can be studied in Design Patterns by the Gang of Four. The concept of using polymophism instead of conditions is
       suggested by Martin Fowler in his book Refactoring.

METHODS

   buildCondition
       Builds a condition object from a given (part of a) where clause. This method calls itself recursively for predicates.

AUTHOR AND COPYRIGHT

       Copyright (c) 2001,2005 by Jeff Zucker: jzuckerATcpan.org Copyright (c) 2008-2010 by Jens Rehsack: rehsackATcpan.org

       Portions Copyright (C) 1998 by Jochen Wiedmann: jwiedATcpan.org

       All rights reserved.

       You may distribute this module under the terms of either the GNU General Public License or the Artistic License, as specified in the Perl
       README file.

perl v5.12.1							    2010-05-06					    SQL::Statement::TermFactory(3)