Sponsored Content
Top Forums Web Development Color a Badge Based on the Weeks the Member is Active in the Latest Sequence Post 303028557 by Neo on Thursday 10th of January 2019 11:35:27 AM
Old 01-10-2019
Update: After testing, reset all members who have not been active in the past week, as follows:

Code:
UPDATE user SET lastweekactive = (lastactivity/(60*60*24*7)), weeksinsequence =  0  WHERE lastactivity < (UNIX_TIMESTAMP() - 3600*24*8);

 

5 More Discussions You Might Find Interesting

1. Solaris

Link based Active Active IPMP

Hi, I need to configure 4 ip address (same subnet and mask) in one ipmp group (two interfaces) in an active active formation (link based). Can some one provide the steps or a tutorial link. Thanks (2 Replies)
Discussion started by: Mack1982
2 Replies

2. Shell Programming and Scripting

Color line based on first field

Hello, I have a bash script that outputs the following text to a file and then prints that file to the screen: |64 |30 |0 |8 |23:59:14 |38 |57 |2 |14 |00:09:05 |29 |50 |4 |20 |23:58:04 |20 |48 |7 |23 |00:05:44 |18 ... (2 Replies)
Discussion started by: fnj00
2 Replies

3. Shell Programming and Scripting

Help with awk color codes based on condition

HI i have two files say test and test1 Test.txt Code: Lun01 2TB 1.99TB 99.6% Lun02 2TB 1.99TB 99.5% Lun03 2TB 1.99TB 99.5% Lun04 2TB 1.55TB 89.6% Code: Test1.txt Lun01 2TB 1.99TB 89.5% Lun02 2TB 1.99TB 99.5% Lun03 2TB 1.99TB 99.5% Requirement is to compare... (6 Replies)
Discussion started by: venkitesh
6 Replies

4. UNIX for Beginners Questions & Answers

Best way to increment weeks based on fiscal start year

Hi Folks - I'm looking for the best way to to increment fiscal weeks - allow me to explain. At my one client, 10/01/17 was the beginning if year fiscal year 2018. Each week, I need to manage a unique set of variable that are updated in my application - they are called substitution variables.... (31 Replies)
Discussion started by: SIMMS7400
31 Replies

5. What is on Your Mind?

Update to Posts - Member Info Icon and Badge

Hey, Upgrade (step 1) the posts, by putting a "user info" icon in the top right and making it so it toggles the user info. The user info icon has a badge which shows the number of posts. I will have to dig around in the code more to get the total posts thanks and other badges working; but... (22 Replies)
Discussion started by: Neo
22 Replies
SDL::Color(3)						User Contributed Perl Documentation					     SDL::Color(3)

NAME
SDL::Color - a SDL perl extension SYNOPSIS
$color = new SDL::Color ( -r => 0xde, -g => 0xad, -b =>c0 ); $color = new SDL::Color -surface => $app, -pixel => $app->pixel($x,$y); $color = new SDL::Color -color => SDL::NewColor(0xff,0xaa,0xdd); DESCRIPTION
"SDL::Color" is a wrapper for display format independent color representations, with the same interface as SDL::Color. new ( -color => ) "SDL::Color::new" with a "-color" option will construct a new object referencing the passed SDL_Color*. new (-r => , -g => , -b => ) "SDL::Color::new" with "-r,-g,-b" options will construct both a SDL_Color structure, and the associated object with the specified vales. new (-pixel =>, -surface =>) "SDL::Color::new" with "-pixel,-surface" options will generate a SDL_Color* with the r,g,b values associated with the integer value passed by "-pixel" for the given "-surface"'s format. r ( [ red ] ), g( [ green ] ), b( [ blue ] ) "SDL::Color::r, SDL::Color::g, SDL::Color::b" are accessor methods for the red, green, and blue components respectively. The color value can be set by passing a byte value (0-255) to each function. pixel ( surface ) "SDL::Color::pixel" takes a "SDL::Surface" object and r,g,b values, and returns the integer representation of the closest color for the given surface. AUTHOR
David J. Goehrig SEE ALSO
perl SDL::Surface perl v5.12.1 2010-07-05 SDL::Color(3)
All times are GMT -4. The time now is 09:10 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy