diff options
| author | raylu <raylu@cmu.edu> | 2011-04-07 00:27:27 -0400 |
|---|---|---|
| committer | raylu <raylu@cmu.edu> | 2011-04-07 00:27:27 -0400 |
| commit | f8c9eb5220afaf2f9a62f9a176a45913240f4081 (patch) | |
| tree | 99775178acfcef6e86e39184be0ac96083042f1b /pages/memberlist.php | |
| download | pathery-f8c9eb5220afaf2f9a62f9a176a45913240f4081.tar.xz | |
Initial import from Dropbox
Diffstat (limited to 'pages/memberlist.php')
| -rw-r--r-- | pages/memberlist.php | 91 |
1 files changed, 91 insertions, 0 deletions
diff --git a/pages/memberlist.php b/pages/memberlist.php new file mode 100644 index 0000000..e9f2059 --- /dev/null +++ b/pages/memberlist.php @@ -0,0 +1,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());
+ }
+}
+
+
+
+
+?>
\ No newline at end of file |