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 303028206 by Neo on Wednesday 2nd of January 2019 04:48:09 AM
Old 01-02-2019
Hey Ravinder, we can do your badge about monthly thanks based on this query!!

No need to add more backend PHP code or DB fields!

Examples:

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

Code:
mysql> select SUM(post_thanks_amount) from post where userid=302122727 and dateline > (UNIX_TIMESTAMP() -3600*24*30);
+-------------------------+
| SUM(post_thanks_amount) |
+-------------------------+
|                      29 |
+-------------------------+
1 row in set (0.00 sec)

You did not have this table:

Code:
mysql> describe post;
+--------------------+----------------------+------+-----+---------+----------------+
| Field              | Type                 | Null | Key | Default | Extra          |
+--------------------+----------------------+------+-----+---------+----------------+
| postid             | int(10) unsigned     | NO   | PRI | NULL    | auto_increment |
| threadid           | int(10) unsigned     | NO   | MUL | 0       |                |
| username           | varchar(100)         | NO   |     |         |                |
| userid             | int(10) unsigned     | NO   | MUL | 0       |                |
| title              | varchar(250)         | NO   | MUL |         |                |
| dateline           | int(11)              | NO   | MUL | 0       |                |
| pagetext           | mediumtext           | YES  |     | NULL    |                |
| allowsmilie        | smallint(6)          | NO   |     | 0       |                |
| showsignature      | smallint(6)          | NO   |     | 0       |                |
| ipaddress          | varchar(45)          | NO   | MUL | NULL    |                |
| iconid             | smallint(5) unsigned | NO   |     | 0       |                |
| visible            | smallint(6)          | NO   | MUL | 0       |                |
| topic              | int(3)               | NO   |     | 0       |                |
| parentid           | int(10) unsigned     | NO   |     | 0       |                |
| attach             | smallint(5) unsigned | NO   |     | 0       |                |
| infraction         | smallint(5) unsigned | NO   |     | 0       |                |
| reportthreadid     | int(10) unsigned     | NO   |     | 0       |                |
| post_thanks_amount | int(10) unsigned     | NO   |     | 0       |                |
| b8rating           | float                | YES  |     | NULL    |                |
| postkeywords       | varchar(128)         | YES  |     | NULL    |                |
| description        | varchar(256)         | YES  |     | NULL    |                |
| googlebotlastvisit | int(11)              | NO   |     | 0       |                |
| bingbotlastvisit   | int(11)              | NO   |     | 0       |                |
+--------------------+----------------------+------+-----+---------+----------------+
23 rows 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

LEARN ABOUT DEBIAN

mysqmail-courier-logger

mysqmail-logger(8)					      System Manager's Manual						mysqmail-logger(8)

NAME

       mysqmail-courier-logger - logs courier-imap traffic to a mysql database

SYNOPSIS

       mysqmail-courier-logger subprogram [ args ...  ]

DESCRIPTION

       mysqmail-courier-logger reads the syslog using tail -F, and for each dovecot lines of POP3 and IMAP corresponding to a disconnection, mysq-
       mail-courier-logger writes the total used bandwidth corresponding to the username. Configuration is read from /etc/mysqmail.conf.

       mysqmail-courier-logger uses a table corresponding to this one:

       CREATE TABLE IF NOT EXISTS pop_access (
	 id varchar(32) NOT NULL default '',
	 uid int(11) NOT NULL default '65534',
	 gid int(11) NOT NULL default '65534',
	 home varchar(255) NOT NULL default '',
	 shell varchar(255) NOT NULL default '',
	 mbox_host varchar(120) NOT NULL default '',
	 crypt varchar(50) NOT NULL default '',
	 passwd varchar(50) NOT NULL default '',
	 active int(11) NOT NULL default '1',
	 start_date date NOT NULL default '0000-00-00',
	 expire_date date NOT NULL default '0000-00-00',
	 quota_size int(11) NOT NULL default '0',
	 type varchar(20) NOT NULL default 'default',
	 memo text,du bigint(20) NOT NULL default '0',
	 another_perso varchar(5) NOT NULL default 'no',
	 redirect1 varchar(255) default NULL,
	 redirect2 varchar(255) default NULL,
	 localdeliver varchar(10) NOT NULL default 'yes',
	 pop3_login_count int(9) NOT NULL default '0',
	 pop3_transfered_bytes int(14) NOT NULL default '0',
	 imap_login_count int(9) NOT NULL default '0',
	 imap_transfered_bytes int(14) NOT NULL default '0',
	 last_login int(14) NOT NULL default '0',
	 PRIMARY KEY  (id,mbox_host) ) TYPE=MyISAM

       To have mysqmail-courier-logger working, you should have issued	mkfifo	/var/log/courier.fifo  to  create  the	fifo  and  use	nohup  cat
       /var/log/courier.fifo | /usr/bin/mysqmail-courier-logger > /dev/null 2>&1 & to launch it.

VERSION

       This documentation describes mysqmail-courier-logger version 0.1.4.  See http://gplhost.com/softwares-mysqmail.html for updates.

SEE ALSO

       qmail-send(3), syslog(3), logger(8)

																mysqmail-logger(8)
All times are GMT -4. The time now is 06:04 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy