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-postfix-logger

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

NAME

       mysqmail-postfix-logger - logs smtp traffic to a mysql database

SYNOPSIS

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

DESCRIPTION

       mysqmail-postfix-logger	reads the syslog using tail -F and for each lines, does an action in a selected table in the selected mysql server
       (configuration done using /etc/mysqmail.conf). All messages that have been delivered are marqued as so in the from and in the to  field	of
       the smtp traffic table.

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

       CREATE TABLE  IF NOT EXISTS smtp_logs (
	 id int(11) NOT NULL auto_increment,
	 newmsg_id bigint(20) default NULL,
	 bounce_qp int(11) default NULL,
	 bytes int(11) NOT NULL default '0',
	 sender_user varchar(128) NOT NULL default '',
	 sender_domain varchar(128) NOT NULL default '',
	 delivery_id bigint(20) default NULL,
	 delivery_user varchar(128) NOT NULL default '',
	 delivery_domain varchar(128) NOT NULL default '',
	 delivery_success enum('yes','no') NOT NULL default 'no',
	 time_stamp timestamp(14) NOT NULL,
	 PRIMARY KEY  (id),
	 UNIQUE KEY bounce_qp (bounce_qp),
	 UNIQUE KEY newmsg_id (newmsg_id),
	 KEY sender_domain (sender_domain),
	 KEY delivery_domain (delivery_domain) ) TYPE=MyISAM;

VERSION

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

SEE ALSO

       syslog(3), logger(8)

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