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
Old 12-02-2018
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.
 

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... (0 Replies)
Discussion started by: LivinFree
0 Replies

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:... (2 Replies)
Discussion started by: rocker40
2 Replies

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 Replies)
Discussion started by: rocker40
4 Replies

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... (10 Replies)
Discussion started by: thebytegrill
10 Replies

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... (0 Replies)
Discussion started by: Neo
0 Replies

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... (2 Replies)
Discussion started by: SkySmart
2 Replies

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.... (2 Replies)
Discussion started by: digipak
2 Replies

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... (3 Replies)
Discussion started by: Neo
3 Replies
assert_wait_mesg(9r)													      assert_wait_mesg(9r)

NAME
assert_wait_mesg - General: Asserts that the current kernel thread is about to block (sleep) SYNOPSIS
void assert_wait_mesg( vm_offset_t event, boolean_t interruptible, char *message ); ARGUMENTS
Specifies the event associated with the current kernel thread. Specifies a Boolean value that indicates how the kernel thread is awakened. You can pass one of the following values: The current kernel thread is interruptible. This value means that a signal can awaken the current kernel thread. The current kernel thread is not interruptible. This value means that only the specified event can awaken the current ker- nel thread. Specifies a mnemonic for the type of wait. The ps command uses this mnemonic to print out more meaningful messages about a process. DESCRIPTION
The assert_wait_mesgroutine asserts that the current kernel thread is about to block (sleep) until the specified event occurs. This routine sets a thread wait bit in the pointer to the thread structure associated with the current kernel thread. This bit signifies that this ker- nel thread is on the appropriate wait hash queue, waiting for a wakeup call. To actually block (put to sleep) the current kernel thread, call thread_block. To issue a wakeup call on the specified event, call the thread_wakeup_prim or clear_wait routine. CAUTIONS
You must not call assert_wait_mesg from a device driver's interrupt handler. The reason for this is that at interrupt context there is no process to be put to sleep. RETURN VALUES
None SEE ALSO
Data Structures: thread(9s) Routines: clear_wait(9r), current_thread(9r), thread_block(9r) Reference Pages Section 1: ps assert_wait_mesg(9r)
All times are GMT -4. The time now is 05:35 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy