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
DACS_LIST_JURISDICTI(8) 				     DACS Web Services Manual					   DACS_LIST_JURISDICTI(8)

NAME
dacs_list_jurisdictions - display information about DACS jurisdictions SYNOPSIS
dacs_list_jurisdictions [dacsoptions[1]] DESCRIPTION
This web service is part of the DACS suite. The dacs_list_jurisdictions web service displays information, relative to the jurisdiction that receives the request, about its federation and other jurisdictions in that federation. Included are the federation's public encryption key and its unique instance identifier. The FORMAT argument (see dacs.services(8)[2]) determines the type of output, with the default being HTML, using the style sheet dacs_list_jurisdictions.css[3]. The various flavours of XML, a PHP format (see below), JSON, and plain text (TEXT) are supported. One application of dacs_list_jurisdictions is to assist middleware to generate a menu of jurisdictions for user authentication. If FORMAT is PHP, a list of each jurisdiction that provides an authentication service is emitted (as text/plain, one jurisdiction per line. Each line has the format: jurisdiction[]=jname&host[]=url&jname The string jname is the DACS jurisdiction name and url is the complete URL prefix for DACS web services at the jurisdiction. For example, invoking this URL: https://example.com/infocards/cgi-bin/dacs/dacs_list_jurisdictions?FORMAT=PHP might return the following response: jurisdiction[]=INFOCARDS&host[]=https://example.com/infocards/cgi-bin/dacs&INFOCARDS jurisdiction[]=DEMO&host[]=https://example.com/demo/cgi-bin/dacs&DEMO jurisdiction[]=TEST&host[]=https://test.example.com/cgi-bin/dacs&TEST The html/examples/login.php[4] template demonstrates this feature. If XML output is selected, a document conforming to dacs_list_jurisdictions.dtd[5] is returned. When returned as an XML attribute, a public encryption key is a base-64 encoding of the PEM formatted key. Note This program is also available as a DACS utility, dacslist(1)[6]. Because dacs_admin(8)[7] provides the same functionality and more, dacs_list_jurisdictions may be removed in a future release. Web Service Arguments In addition to the standard CGI arguments[8], dacs_list_jurisdictions understands the following CGI arguments: JURISDICTION Limit the output to the specified jurisdiction name. As a special case, if the argument does not specify a jurisdiction name, only federation-scoped information will be returned. PUB_KEY_ONLY If this argument is "yes" (case insensitive) only the federation's or a jurisdiction's public key (if known) will be returned. If JURISDICTION is given and is not the empty string, that jurisdiction name is selected; if JURISDICTION is given and is the empty string, the federation is selected; and if the argument is absent, the current jurisdiction is selected. This argument currently requires FORMAT to be TEXT. A PEM [RFC 1421[9], RFC 1422[10], RFC 1423[11], RFC 1424[12]] formatted key is returned. Note In the current implementation, a jurisdiction's public key can only be provided by one of the jurisdictions configured on the same host. FILES
dacs_list_jurisdictions.css[3] DIAGNOSTICS
The program exits 0 if everything was fine, 1 if an error occurred. SEE ALSO
dacs(1)[13], dacskey(1)[14], dacslist(1)[6], dacs.groups(5)[15] AUTHOR
Distributed Systems Software (www.dss.ca[16]) COPYING
Copyright2003-2012 Distributed Systems Software. See the LICENSE[17] file that accompanies the distribution for licensing information. NOTES
1. dacsoptions http://dacs.dss.ca/man/dacs.1.html#dacsoptions 2. dacs.services(8) http://dacs.dss.ca/man/dacs.services.8.html#FORMAT 3. dacs_list_jurisdictions.css http://dacs.dss.ca/man//css/dacs_list_jurisdictions.css 4. html/examples/login.php http://dacs.dss.ca/man/../examples/login.php 5. dacs_list_jurisdictions.dtd http://dacs.dss.ca/man/../dtd-xsd/dacs_list_jurisdictions.dtd 6. dacslist(1) http://dacs.dss.ca/man/dacslist.1.html 7. dacs_admin(8) http://dacs.dss.ca/man/dacs_admin.8.html 8. standard CGI arguments http://dacs.dss.ca/man/dacs.services.8.html#standard_cgi_args 9. RFC 1421 http://www.rfc-editor.org/rfc/rfc1421.txt 10. RFC 1422 http://www.rfc-editor.org/rfc/rfc1422.txt 11. RFC 1423 http://www.rfc-editor.org/rfc/rfc1423.txt 12. RFC 1424 http://www.rfc-editor.org/rfc/rfc1424.txt 13. dacs(1) http://dacs.dss.ca/man/dacs.1.html 14. dacskey(1) http://dacs.dss.ca/man/dacskey.1.html 15. dacs.groups(5) http://dacs.dss.ca/man/dacs.groups.5.html 16. www.dss.ca http://www.dss.ca 17. LICENSE http://dacs.dss.ca/man/../misc/LICENSE DACS 1.4.27b 10/22/2012 DACS_LIST_JURISDICTI(8)
All times are GMT -4. The time now is 07:58 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy