aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorJames Atkinson <thefinn@users.sourceforge.net>2001-05-11 23:16:31 +0000
committerJames Atkinson <thefinn@users.sourceforge.net>2001-05-11 23:16:31 +0000
commitd3adc86325503a66c7fe0bf95ca1877855ebc7bb (patch)
tree58583159c35e372cb70e3a395708e9d54d4fb5d2
parentcaaf04c1971c49985c13a19c0711b6b74e3f17e6 (diff)
downloadforums-d3adc86325503a66c7fe0bf95ca1877855ebc7bb.tar
forums-d3adc86325503a66c7fe0bf95ca1877855ebc7bb.tar.gz
forums-d3adc86325503a66c7fe0bf95ca1877855ebc7bb.tar.bz2
forums-d3adc86325503a66c7fe0bf95ca1877855ebc7bb.tar.xz
forums-d3adc86325503a66c7fe0bf95ca1877855ebc7bb.zip
Memberlist working. Pagination seems to have problems. Might be generate_pagination code...
git-svn-id: file:///svn/phpbb/trunk@272 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat
-rw-r--r--phpBB/includes/page_header.php1
-rwxr-xr-xphpBB/language/lang_english.php2
-rw-r--r--phpBB/memberlist.php157
-rw-r--r--phpBB/templates/Default/memberlist_body.tpl32
-rw-r--r--phpBB/templates/PSO/images/post.gifbin1331 -> 1329 bytes
-rw-r--r--phpBB/templates/PSO/images/reply-locked.gifbin2061 -> 2054 bytes
-rw-r--r--phpBB/templates/PSO/images/reply.gifbin1304 -> 1303 bytes
7 files changed, 192 insertions, 0 deletions
diff --git a/phpBB/includes/page_header.php b/phpBB/includes/page_header.php
index 2325acd047..5d82661b09 100644
--- a/phpBB/includes/page_header.php
+++ b/phpBB/includes/page_header.php
@@ -160,6 +160,7 @@ $template->assign_vars(array(
"U_FAQ" => append_sid("faq.".$phpEx),
"U_VIEWONLINE" => append_sid("viewonline.$phpEx"),
"U_LOGIN_LOGOUT" => append_sid($u_login_logout),
+ "U_MEMBERSLIST" => append_sid("memberlist.".$phpEx),
"S_TIMEZONE" => $s_timezone,
"S_LOGIN_ACTION" => append_sid("login.$phpEx"),
diff --git a/phpBB/language/lang_english.php b/phpBB/language/lang_english.php
index 78ab7eb5e3..61c4751bca 100755
--- a/phpBB/language/lang_english.php
+++ b/phpBB/language/lang_english.php
@@ -149,6 +149,8 @@ $l_date_format_explanation = "Only change this if you know what you are doing!";
$l_password_if_changed = "You only need to supply a password if you want to change it.";
$l_password_confirm_if_changed = "You only need to confirm your password if you changed it above.";
+$l_top10 = "Top 10 Posters";
+$l_alpha = "Sorta Alphabetical";
// Viewforum
$l_viewforum = "View Forum";
diff --git a/phpBB/memberlist.php b/phpBB/memberlist.php
new file mode 100644
index 0000000000..af81b25995
--- /dev/null
+++ b/phpBB/memberlist.php
@@ -0,0 +1,157 @@
+<?php
+/***************************************************************************
+ * common.php
+ * -------------------
+ * begin : Friday, May 11, 2001
+ * copyright : (C) 2001 The phpBB Group
+ * email : support@phpbb.com
+ *
+ * $Id$
+ *
+ ***************************************************************************/
+
+
+/***************************************************************************
+ *
+ * This program is free software; you can redistribute it and/or modify
+ * it under the terms of the GNU General Public License as published by
+ * the Free Software Foundation; either version 2 of the License, or
+ * (at your option) any later version.
+ ***************************************************************************/
+include('extension.inc');
+include('common.'.$phpEx);
+
+$pagetype = "memberlist";
+$page_title = $l_memberslist;
+
+//
+// Start session management
+//
+$userdata = session_pagestart($user_ip, PAGE_VIEWMEMBERS, $session_length);
+init_userprefs($userdata);
+//
+// End session management
+//
+
+include('includes/page_header.'.$phpEx);
+
+if(!$start)
+{
+ $start = 0;
+}
+switch($mode)
+{
+ case 'top10':
+ $sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website
+ FROM ".USERS_TABLE." WHERE user_id != ".ANONYMOUS." AND user_level != ".DELETED." ORDER BY user_posts ASC LIMIT 10";
+
+ break;
+ case 'alpha':
+ $sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website
+ FROM ".USERS_TABLE." WHERE user_id != ".ANONYMOUS." AND user_level != ".DELETED." ORDER BY username ASC LIMIT $start, ".$board_config['topics_per_page'];
+ break;
+ default:
+ $sql = "SELECT username, user_id, user_viewemail, user_posts, user_regdate, user_from, user_website
+ FROM ".USERS_TABLE." WHERE user_id != ".ANONYMOUS." AND user_level != ".DELETED." ORDER BY user_id ASC LIMIT $start, ".$board_config['topics_per_page'];
+ break;
+}
+
+if(!$result = $db->sql_query($sql))
+{
+ if(DEBUG)
+ {
+ $error = $db->sql_error();
+ error_die(SQL_QUERY, "Error getting memberlist.<br>Reason: ".$error['message']."<br>Query: $sql.", __LINE__, __FILE__);
+ }
+ else
+ {
+ error_die(SQL_QUERY);
+ }
+}
+if(($selected_members = $db->sql_numrows($result)) > 0)
+{
+ $template->set_filenames(array("body" => "memberlist_body.tpl"));
+ $template->assign_vars(array("U_VIEW_TOP10" => append_sid("memberlist.$phpEx?mode=top10"),
+ "U_SORTALPHA" => append_sid("memberlist.$phpEx?mode=alpha"),
+ "L_VIEW_TOP10" => $l_top10,
+ "L_SORTALPHA" => $l_alpha,
+ "L_EMAIL" => $l_email,
+ "L_WEBSITE" => $l_website,
+ "L_FROM" => $l_from));
+
+ $members = $db->sql_fetchrowset($result);
+
+ for($x = $start; $x < $selected_members; $x++)
+ {
+ $username = stripslashes($members[$x]['username']);
+ $user_id = $members[$x]['user_id'];
+ $posts = $members[$x]['user_posts'];
+ $from = stripslashes($members[$x]['user_from']);
+ $joined = create_date($board_config['default_dateformat'], $members[$x]['user_regdate'], $board_config['default_timezone']);
+ if($members[$x]['user_viewemail'] != 0)
+ {
+ $email = str_replace("@", " at ", $members[$x]['user_email']);
+ $email = "<a href=\"mailto:$email\">$email</a>";
+ }
+ else
+ {
+ $email = "&nbsp;";
+ }
+
+ if($members[$x]['user_website'])
+ {
+ $url_img = $images['www'];
+ $url = "<a href=\"".stripslashes($members[$x]['user_website'])."\"><img src=\"".$url_img."\" /></a>";
+ }
+ else
+ {
+ $url = "&nbsp;";
+ }
+
+ if(!($x % 2))
+ {
+ $row_color = "#".$theme['td_color1'];
+ }
+ else
+ {
+ $row_color = "#".$theme['td_color2'];
+ }
+ $template->assign_block_vars("memberrow", array(
+ "ROW_COLOR" => $row_color,
+ "U_VIEWPROFILE" => append_sid("profile.$phpEx?mode=viewprofile&".POST_USERS_URL."=".$user_id),
+ "USERNAME" => $username,
+ "FROM" => $from,
+ "JOINED" => $joined,
+ "POSTS" => $posts,
+ "EMAIL" => $email,
+ "WEBSITE" => $url));
+ }
+
+ if($mode != "top10")
+ {
+ $sql = "SELECT count(*) AS total FROM ".USERS_TABLE." WHERE user_id != ".ANONYMOUS." AND user_level != ".DELETED;
+ if(!$count_result = $db->sql_query($sql))
+ {
+ if(DEBUG)
+ {
+ $error = $db->sql_error();
+ error_die(SQL_QUERY, "Error getting total users<br>Reason: ".$error['message']."<br>Query: $sql", __LINE__, __FILE__);
+ }
+ else
+ {
+ error_die(SQL_QUERY);
+ }
+ }
+ else
+ {
+ $total = $db->sql_fetchrowset($count_result);
+ $total_members = $total[0]['total'];
+ $pagination = generate_pagination("memberlist.$phpEx?mode=$mode", $total_members, $board_config['posts_per_page'], $start, TRUE);
+ }
+ $template->assign_vars(array("PAGINATION" => $pagination));
+ }
+ $template->pparse("body");
+}
+
+include('includes/page_tail.'.$phpEx);
+?> \ No newline at end of file
diff --git a/phpBB/templates/Default/memberlist_body.tpl b/phpBB/templates/Default/memberlist_body.tpl
new file mode 100644
index 0000000000..1a3199d972
--- /dev/null
+++ b/phpBB/templates/Default/memberlist_body.tpl
@@ -0,0 +1,32 @@
+<tr>
+ <td bgcolor="#000000" align="center"><table width="100%" cellpadding="0" cellspacing="1" border="0">
+ <td>
+ <table width="100%" cellpadding="3" cellspacing="1" border="0">
+ <tr class="tableheader">
+ <td colspan="6" align="right"><a href="{U_VIEW_TOP10}">{L_VIEW_TOP10}</a> | <a href="{U_SORTALPHA}">{L_SORTALPHA}</a></td>
+ </tr>
+ <tr class="tableheader">
+ <td align="center">{L_USERNAME}</td>
+ <td align="center">{L_FROM}</td>
+ <td align="center">{L_JOINED}</td>
+ <td align="center">{L_POSTS}</td>
+ <td align="center">{L_EMAIL}</td>
+ <td align="center">{L_WEBSITE}</td>
+ </tr>
+ <!-- BEGIN memberrow -->
+ <tr bgcolor="{memberrow.ROW_COLOR}" class="tablebody">
+ <td align="center"><a href="{memberrow.U_VIEWPROFILE}">{memberrow.USERNAME}</a></td>
+ <td align="center" valign="middle">{memberrow.FROM}</td>
+ <td align="center" valign="middle">{memberrow.JOINED}</td>
+ <td align="center" valign="middle">{memberrow.POSTS}</td>
+ <td align="center" valign="middle">{memberrow.EMAIL}</td>
+ <td align="center">{WEBSITE}</a></td>
+ </tr>
+ <!-- END memberrow -->
+ <tr class="catheader">
+ <td colspan="6">{PAGINATION}</td>
+ </tr>
+ </table></td>
+ </tr>
+ </table></td>
+</tr> \ No newline at end of file
diff --git a/phpBB/templates/PSO/images/post.gif b/phpBB/templates/PSO/images/post.gif
index f1b8e3ef3e..baf67af19d 100644
--- a/phpBB/templates/PSO/images/post.gif
+++ b/phpBB/templates/PSO/images/post.gif
Binary files differ
diff --git a/phpBB/templates/PSO/images/reply-locked.gif b/phpBB/templates/PSO/images/reply-locked.gif
index 90173f19d3..f9a35d22f8 100644
--- a/phpBB/templates/PSO/images/reply-locked.gif
+++ b/phpBB/templates/PSO/images/reply-locked.gif
Binary files differ
diff --git a/phpBB/templates/PSO/images/reply.gif b/phpBB/templates/PSO/images/reply.gif
index 9276298a6b..51fbb487e3 100644
--- a/phpBB/templates/PSO/images/reply.gif
+++ b/phpBB/templates/PSO/images/reply.gif
Binary files differ
generated by cgit v1.2.1 (git 2.21.0) at 2025-03-14 18:30:13 +0000