Sponsored Content
Top Forums Web Development Notes with Ravinder on Badging System Development Part II Post 303028189 by Neo on Tuesday 1st of January 2019 12:42:18 PM
Old 01-01-2019
Hey Ravinder,

Your fancy query is broken... even I I put xxxxx as the field in the query, I get the same wrong answer:

Code:
mysql> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), FROM_UNIXTIME('xxxxx')))/(3600*24) AS 'join_time' FROM user WHERE userid =1;
+-----------+
| join_time |
+-----------+
|   34.9583 |
+-----------+
1 row in set, 2 warnings (0.00 sec)

Code:
mysql> SELECT TIME_TO_SEC(TIMEDIFF(NOW(), FROM_UNIXTIME('WHAT_THE_F')))/(3600*24) AS 'join_time' FROM user WHERE userid =1;
+-----------+
| join_time |
+-----------+
|   34.9583 |
+-----------+
1 row in set, 2 warnings (0.00 sec)

This is why I write SQL queries that a 12 year old can understand. LOL

Yours looks really clever, but is broken.

I kindly suggest you rewrite your query to perform the logic outside of the SQL query; but it is up to you. I will wait for your next attempt.

Thanks and good try!

PS: You might earn your Dev Ops Team Badge sooner than I thought .. Haha
 

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
cvm-mysql(8)						      System Manager's Manual						      cvm-mysql(8)

NAME
cvm-mysql - MySQL module SYNOPSIS
cvm-mysql CREDENTIALS
Pass phrase DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3). CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the MySQL default). CVM_MYSQL_DEFAULT_GROUP If set, the module will read connection default options from the named group in the defaults file as above CVM_MYSQL_HOST The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed. CVM_MYSQL_USER The MySQL login ID to connect as. If not set, the invoking user is assumed. CVM_MYSQL_PASS The password for the above user. CVM_MYSQL_DB The database name, must be set. CVM_MYSQL_PORT The port number for the TCP/IP connection (only used if the server is not local). CVM_MYSQL_POSTQ (optional) The SQL query to execute after the credentials have been validated, see cvm-sql(7). CVM_MYSQL_PWCMP (optional) The password comparison module to use. CVM_MYSQL_SOCKET The path to the socket that should be used for connections to a local server. CVM_MYSQL_QUERY (optional) The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7). SEE ALSO
cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test- client(8) http://untroubled.org/pwcmp/pwcmp.html http://untroubled.org/cvm/cvm.html cvm-mysql(8)
All times are GMT -4. The time now is 09:30 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy