1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
|
<?PHP
htmlHeader();
?>
<body>
<?php
topbar($Links);
include_once ('./includes/db.inc.php');
//$sql = "SELECT `ID`, `Display`, `Date_Joined`, `Date_Login` FROM `USERS`";
$sql = "SELECT `ID`, `displayName`, `dateJoined`, `dateLogin` FROM `users`";
$result = mysql_query($sql);
echo "
<br />
<table>
<tr>
<td>ID</td><td>Display name:</td><td>Joined On:</td><td>Last Logon</td>
</tr>
";
while (list($CUID, $CUsername, $Joined, $LastLogon) = mysql_fetch_row($result)) {
//$Joined = Date("d/m/y - g:ia", $Joined);
//$Joined = relative_date($Joined);
if ($LastLogon == 0) {
$LastLogon = "Never";
} else {
//$LastLogon = Date("d/m/y - g:ia", $LastLogon);
//$LastLogon = date('M j, Y', $LastLogon);
//$LastLogon = relative_date($LastLogon);
}
//$LastLogon = Date("l, M jS. g:iA", $LastLogon);
Echo "<tr>
<td>$CUID</td>
<td><a href='javascript:;'>$CUsername</a></td>
<td>$Joined</td>
<td>$LastLogon</td>
</tr>";
}
Echo "
</table>
<br />
<br />
</td>
</tr>
</table>
";
//Thank you:
//http://snippets.dzone.com/posts/show/196
function relative_date($time) {
$today = strtotime(date('M j, Y'));
$reldays = ($time - $today)/86400;
if ($reldays >= 0 && $reldays < 1) {
return 'Today';
} else if ($reldays >= 1 && $reldays < 2) {
return 'Tomorrow';
} else if ($reldays >= -1 && $reldays < 0) {
return 'Yesterday';
}
if (abs($reldays) < 7) {
if ($reldays > 0) {
$reldays = floor($reldays);
return 'in ' . $reldays . ' day' . ($reldays != 1 ? 's' : '');
} else {
$reldays = abs(floor($reldays));
return $reldays . ' day' . ($reldays != 1 ? 's' : '') . ' ago';
}
}
if (abs($reldays) < 182) {
return date('l, F j',$time ? $time : time());
} else {
return date('l, F j, Y',$time ? $time : time());
}
}
?>
|