Sponsored Content
Top Forums Web Development Notes with Ravinder on Badging System Development Part II Post 303028208 by Neo on Wednesday 2nd of January 2019 05:02:17 AM
Old 01-02-2019
Or maybe this query, the number of threads started in the past month:

Code:
mysql> select COUNT(threadid) from thread where postuserid=1 and dateline > (UNIX_TIMESTAMP() -3600*24*30);
+-----------------+
| COUNT(threadid) |
+-----------------+
|              49 |
+-----------------+
1 row in set (0.00 sec)

 

3 More Discussions You Might Find Interesting

1. What is on Your Mind?

New Badging System - Badges Prototype Beta 1 (Badges Only)

Today I mapped out the new badging system using FA icons, Beta 1 in no particular order except a 6 x 8 grid: https://www.unix.com/members/1-albums215-picture991.png The prototype HTML code for this layout: <style> .fa-badge-grid { font-size: 1.5em; } .row { ... (38 Replies)
Discussion started by: Neo
38 Replies

2. What is on Your Mind?

Status of Badging System - Beta 1

Dear All, Here is the current status of the badging system: The Beta 1 phase of the new badging system is close to completion. 42 prototype badges have been "allocated" 6 prototype badge slots are held in reserve The "alert you have new badges" prototype is running and is currently... (4 Replies)
Discussion started by: Neo
4 Replies

3. What is on Your Mind?

Badging System: UNIX.COM Bug Hunter Badge (New)

I have moved the bug badge out of reserve and into the main stream. Basically, I will assign a color level like the others, based on who has made a good actionable bug report for UNIX.COM. "Good" means screenshots, links, and even details from web dev tools our the HTML source code. So far,... (0 Replies)
Discussion started by: Neo
0 Replies
NOTMUCH-COUNT(1)					      General Commands Manual						  NOTMUCH-COUNT(1)

NAME
notmuch-count - Count messages matching the given search terms. SYNOPSIS
notmuch count [options... ] <search-term>... DESCRIPTION
Count messages matching the search terms. The number of matching messages (or threads) is output to stdout. With no search terms, a count of all messages (or threads) in the database will be displayed. See notmuch-search-terms(7) for details of the supported syntax for <search-terms>. Supported options for count include --output=(messages|threads) messages Output the number of matching messages. This is the default. threads Output the number of matching threads. --exclude=(true|false) Specify whether to omit messages matching search.tag_exclude from the count (the default) or not. SEE ALSO
notmuch(1), notmuch-config(1), notmuch-dump(1), notmuch-hooks(5), notmuch-new(1), notmuch-reply(1), notmuch-restore(1), notmuch-search(1), notmuch-search-terms(7), notmuch-show(1), notmuch-tag(1) Notmuch 0.13.2 2012-06-01 NOTMUCH-COUNT(1)
All times are GMT -4. The time now is 02:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy