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)
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)
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)
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)