Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Notes with Ravinder on Badging System Development Part II
Top Forums Web Development Notes with Ravinder on Badging System Development Part II Post 303028207 by Neo on Wednesday 2nd of January 2019 04:59:49 AM
Old 01-02-2019
Ravinder, maybe we can badge this "posts in the last month, or week) query;

What do you think?

Code:
mysql> select COUNT(postid) from post where userid=1 and dateline > (UNIX_TIMESTAMP() -3600*24*30);
+---------------+
| COUNT(postid) |
+---------------+
|           378 |
+---------------+
1 row in set (0.01 sec)

Code:
mysql> select COUNT(postid) from post where userid=302093876 and dateline > (UNIX_TIMESTAMP() -3600*24*30);
+---------------+
| COUNT(postid) |
+---------------+
|             7 |
+---------------+
1 row in set (0.01 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

LEARN ABOUT DEBIAN

swatch::threshold

Swatch::Threshold(3pm)					User Contributed Perl Documentation				    Swatch::Threshold(3pm)

NAME

	 Swatch::Threshold - Perl extension for thresholding in swatch(1)

SYNOPSIS

	 use Swatch::Threshold;

	 &Swatch::threshold(   SWID => <int>,
			       TYPE => <limit|threshold|both>,
			       TRACK_BY => <key>, # like an IP addr
			       COUNT => <int>,
			       SECONDS => <int>
			       );

SWATCH SYNTAX

	 threshold track_by=<key>,
	    type=<limit|threshold|both>,
	    count=<int>,
	    seconds=<int>

DESCRIPTION

	 SWID is swatch's internal ID number for the watchfor block

	 TYPE can be limit, threshold, or both

	       Limit - Alert on the 1st COUNT events during the time interval,
		  then ignore events for the rest of the time interval.

	       Threshold - Alert every COUNT times we see this event during the
		  time interval.

	       Both
		  Alert once per time interval after seeing COUNT occurrences of the
		  event, then ignore any additional events during the time interval.

	 SECONDS is the time interval

AUTHOR

       E. Todd Atkins, todd.atkins@stanfordalumni.org

SEE ALSO

       perl(1), swatch(1).

perl v5.10.0							    2006-07-21						    Swatch::Threshold(3pm)
All times are GMT -4. The time now is 07:07 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy