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 303028303 by Neo on Friday 4th of January 2019 12:04:37 AM
Old 01-04-2019
Note, I'm jumping on a plane in a few hours, so I don't have time to check this properly, but I'm thinking:

Code:
<?php
$day = 60 * 60 * 24;
$dayago = time() - $day;
$incrementseq = "UPDATE user SET lastdayactive = (UNIX_TIMESTAMP()/(60*60*24)), daysinsequence =  daysinsequence +1 WHERE userid =" . $uid;
$selectday = "SELECT lastdayactive AS lastactive FROM user WHERE userid =" . $uid;
$resetday = "UPDATE user SET lastdayactive = (UNIX_TIMESTAMP()/(60*60*24)), daysinsequence =  1 WHERE userid =" . $uid;

$day = $vbulletin->db->query_first($selectday);

if ($day['lastactive'] > $dayago && $day['lastactive'] <= $dayago * 2) {
    $status = $vbulletin->db->query_write($incrementseq);
} elseif ($day['lastactive'] > $dayago * 2) {
    $status = $vbulletin->db->query_write($resetday);
}

$getseq = "SELECT daysinsequence AS daysactive FROM user WHERE userid =" . $uid;
$days = $vbulletin->db->query_first($getseq);
if ($days['daysactive'] > 14) {
    $color['fahistory'] == 'black';
} elseif ($days['daysactive'] > 7) {
    $color['fahistory'] == 'indigo';
} elseif ($days['daysactive'] > 3) {
    $color['fahistory'] == 'blue';
} elseif ($days['daysactive'] > 1) {
    $color['fahistory'] == 'limegreen';
} else {
    $color['fahistory'] == 'lightgray';
}
$badgejs .= 'badge["fahistory"] = "' . $color['fahistory'] . '";';
$badgejs .= 'badge["fahistoryval"] = "' . number_format($days['daysactive']) . '";';

Please take a look and let me know what you think Ravinder!

Thanks

PS: I have not debugged that code above yet and realize that we need to add logic to not query the DB after we reset; because we already have the value (1) so no reason to do the extra query, etc.
This User Gave Thanks to Neo For This Post:
RavinderSingh13
 

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

timetrans

TIMETRANS(1p)						User Contributed Perl Documentation					     TIMETRANS(1p)

NAME

       timetrans - Converts time into time

SYNOPSIS

	 timetrans [units-options] [-count]

DESCRIPTION

       timetrans converts time from one type of unit to another.  If any of the units options are specified, then timetrans will convert those
       time units into the number of seconds to which they add up.  If given the count option, timetrans will convert that number of seconds into
       the appropriate number of weeks, days, hours, minutes, and seconds.  The converted result is printed out.  Units options cannot be
       specified in the same execution as the count option, and vice versa.

       timetrans is intended for use with DNSSEC-Tools, for calculating a zone's expiration time.

OPTIONS

   Units Options
       The converted value of each unit is totaled and a single result printed.

       -seconds seconds
	   Count of seconds to convert to seconds.

       -minutes minutes
	   Count of minutes to convert to seconds.

       -hours hours
	   Count of hours to convert to seconds.

       -days days
	   Count of days to convert to seconds.

       -weeks weeks
	   Count of weeks to convert to seconds.

   Count Option
       The specified seconds count is converted to the appropriate number of weeks, days, hours, minutes, and seconds.

       -count seconds
	   Count of seconds to convert to the appropriate set of units.

   Other Options
       timetrans has the following miscellaneous options.

       -Version
	   Displays the version information for timetrans and the DNSSEC-Tools package.

EXAMPLES

       Example 1:  Converting 5 days into seconds

	   $(42)> timetrans -days 5
	   432000

       Example 2:  Converting 2 weeks into seconds

	   $(43)> timetrans -w 2
	   1209600

       Example 3:  Converting 8 days and 8 hours into seconds

	   $(44)> timetrans -d 8 -hours 8
	   720000

       Example 4:  Converting 1 week, 1 day, and 8 hours into seconds

	   $(46)> timetrans -w 1 -days 1 -h 8
	   720000

       Example 5:  Converting 14 weeks, 4 days, 21 hours, 8 minutes, and 8 seconds into seconds

	   $(47)> timetrans -w 14 -d 4 -h 21 -m 8 -s 8
	   8888888

       Example 6:  Converting 720000 seconds into time units

	   $(48)> timetrans -c 720000
	   1 week, 1 day, 8 hours

       Example 7:  Converting 1814421 seconds into time units

	   $(49)> timetrans -c 1814421
	   3 weeks, 21 seconds

       Example 8:  Converting 8888888 seconds into time units

	   $(50)> timetrans -c 8888888
	   14 weeks, 4 days, 21 hours, 8 minutes, 8 seconds

COPYRIGHT

       Copyright 2004-2012 SPARTA, Inc.  All rights reserved.  See the COPYING file included with the DNSSEC-Tools package for details.

AUTHOR

       Wayne Morrison, tewok@tislabs.com

SEE ALSO

       zonesigner(8)

       Net::DNS::SEC::Tools::timetrans.pm(3)

perl v5.14.2							    2012-06-21							     TIMETRANS(1p)
All times are GMT -4. The time now is 03:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy