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

brlapi_writearguments_t

brlapi_writeArguments_t(3)					      BrlAPI						brlapi_writeArguments_t(3)

NAME

       brlapi_writeArguments_t -

SYNOPSIS

       #include <brlapi.h>

   Data Fields
       int displayNumber
       unsigned int regionBegin
       unsigned int regionSize
       char * text
       int textSize
       unsigned char * andMask
       unsigned char * orMask
       int cursor
       char * charset

Detailed Description
       Structure containing arguments to be given to brlapi_write()

Field Documentation
   unsigned char* brlapi_writeArguments_t::andMask
       And attributes; applied first

   char* brlapi_writeArguments_t::charset
       Text charset. NULL means it is assumed to be 8bits, and the same as the server's. '' means current locale's charset. If no locale was
       selected, defaults to NULL's meaning.

   int brlapi_writeArguments_t::cursor
       BRLAPI_CURSOR_LEAVE == don't touch, BRLAPI_CURSOR_OFF == turn off, 1 = 1st char of display, ...

   int brlapi_writeArguments_t::displayNumber
       Display number BRLAPI_DISPLAY_DEFAULT == unspecified

   unsigned char* brlapi_writeArguments_t::orMask
       Or attributes; applied after ANDing

   unsigned int brlapi_writeArguments_t::regionBegin
       Region of display to update, 1st character of display is 1

   unsigned int brlapi_writeArguments_t::regionSize
       Number of characters held in text, andMask and orMask.

   char* brlapi_writeArguments_t::text
       Text to display, must hold as many characters as the region fields expresses.

   int brlapi_writeArguments_t::textSize
       Size of text in bytes. If -1, strlen() is used for computing it.

Author
       Generated automatically by Doxygen for BrlAPI from the source code.

Version 1.0							  Fri Jun 7 2013					brlapi_writeArguments_t(3)
All times are GMT -4. The time now is 02:52 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy