Welcome to Geeklog, Anonymous Thursday, April 24 2025 @ 04:44 am EDT

Geeklog Forums

Date time member last logged on

Post New Reply

Author:

Mood:

Code

Font Color Font Size Close Tags

Forum BBCode Help

BBCode	Effect
[b]bolded text[/b]	bolded text
[i]italicized text[/i]	italicized text
[u]underlined text[/u]	underlined text
[s]strikethrough text[/s]	strikethrough text
[img]http://www.site.com/forum/images/forum.png[/img] OR [img h=65 w=50]http://www.site.com/forum/images/forum.png[/img]
[url=https://www.geeklog.net]Geeklog[/url]	Geeklog
[quote]quoted text[/quote]	To quote: quoted text
[size=15]Your Text[/size] "12" is usually standard on message boards. Usually measured in pixels (px).	Your Text
[color=red]Red Text[/color] OR [color=#FF0000]Red Text[/color] Can use many different color names or hex codes.	Red Text
[list] []List item 1 []List item 2 [/list] OR [list=1] []List item 1 []List item 2 [/list]	List item 1 List item 2 List item 1 List item 2
[code]monospaced text[/code]	monospaced text
[code=XYX]formatted code[/code] Where XYZ can be any of the following: c css html4strict java javascript jquery perl php plain python SQL and many more...	formatted code
To enter a backslash (\) in your post, use \\\\	\

Subject

[QUOTE][u]Quote by: lgriffin[/u][p]Ok I that in the single member form ok, but what I trying to get to is to do a list of members and last time logged on.  So I guess the questions is how to change that stange varchar unix timestamp to something that makes sense to people?
[code]$color = "#C0C0C0"; // this set the background color of the switched row.

//get and prep array of user info
$membersprep = DB_query( "SELECT * FROM gl_users, gl_userinfo where gl_users.uid = gl_userinfo.uid ORDER BY username" );
//$members = DB_fetchArray($membersprep);

//figure out haw many users we really have here
$limit = DB_count('gl_userinfo') - 2;
$count = 1;

// tell folks how popular we really are
$putout .= "There are currently " . $limit . " members of the site!n";

//Load up the first of the display
$putout .= "<table>";

//create our header row
$putout .= "<TR bgcolor="#FFFFFF">n";
$putout .= "<TD><B><H3>Name</H3></B></TD>n";
$putout .= "<TD><B><H3>Join Date</H3></B></TD>n";
$putout .= "<TD><B><H3>Last Login Date</H3></B></TD>n";
$putout .= "</TR>n";

//start spewing out information and switching the bkgrnd color
$switch = false;
while($count <= $limit){
$membersout = DB_fetcharray($membersprep);
switch ( $switch ) {
case true:
$switch = false; // alternating color
$putout .= "<TR bgcolor="" . $color . "">n";
break;
default:
$switch = true; // default, no back color
$putout .= "<TR bgcolor"FFFFFF">n";
} // switch
$putout .= "<TD><a href="http://www.lomguild.com/admin/user.php?mode=edit&uid=";
$putout .= $membersout['uid'] . "">" . $membersout['username'] . "</a></TD>n";
$putout .= "<TD>" . $membersout['regdate'] . "</TD>n";
$putout .= "<TD>" . $membersout['lastlogin'] . "</TD>n";
$putout .= "</TR>n";
$count++;
} // while

//close out the table
$putout .= "</TABLE>";
return $putout;;

[/code]

Thanks Larry[/p][/QUOTE]

Options:

HTML Mode

Geeklog Forums

Search

Resources

About

Getting started

Support

Development

Topics

User Functions

What's New

Articles last 4 weeks

Comments last 4 weeks

Pages last 4 weeks

Links last 4 weeks

Downloads last 4 weeks