Verzeichnisstruktur phpBB-1.0.0
- Veröffentlicht
- 15.12.2000
So funktioniert es
|
|
Auf das letzte Element klicken. Dies geht jeweils ein Schritt zurück |
Auf das Icon klicken, dies öffnet das Verzeichnis. Nochmal klicken schließt das Verzeichnis. |
|
|
(Beispiel Datei-Icons)
|
Auf das Icon klicken um den Quellcode anzuzeigen |
bb_memberlist.php
001 <?php
002 /***************************************************************************
003 bb_memberlist.php - description
004 -------------------
005 begin : Sat June 17 2000
006 copyright : (C) 2000 by James Atkinson
007 email : james@totalgeek.org
008
009 $Id: bb_memberlist.php,v 1.18 2000/11/23 08:00:59 thefinn Exp $
010
011 ***************************************************************************/
012
013 /***************************************************************************
014 *
015 * This program is free software; you can redistribute it and/or modify
016 * it under the terms of the GNU General Public License as published by
017 * the Free Software Foundation; either version 2 of the License, or
018 * (at your option) any later version.
019 *
020 ***************************************************************************/
021
022 /*
023 * This Page Created By: Yokhannan
024 * Email: support@4cm.com
025 * Created On: Saturday, July 22, 2000
026 *
027 * Edited: Thursday, October 19, 2000
028 * Added a better ICQ method.
029 * Changed all the Font Settings to use Variables
030 * Made some minor PHP-HTML changes
031 *
032 * Oct 27, 2000
033 * Added pagination
034 * - James
035 */
036 include('extention.inc');
037 include('functions.'.$phpEx);
038 include('config.'.$phpEx);
039 require('auth.'.$phpEx);
040 $pagetitle = "Members List";
041 $pagetype = "other";
042 include("page_header.$phpEx");
043
044 /**
045 * July 25, 2000 - Nathan.
046 * Sorting by # of posts would be cool.. but I can't find a way to do it
047 * without requiring 1 or 2 additional SQL queries per user. Yuck.
048 */
049
050 switch ($sortby) {
051 case '':
052 $sortby = "user_id ASC";
053 break;
054 case 'user':
055 $sortby = "username ASC";
056 break;
057 case 'from':
058 $sortby = "user_from ASC";
059 break;
060 case 'posts':
061 $sortby = "user_posts DESC";
062 break;
063 }
064
065 if(!$start) $start = 0;
066
067 $sql = "SELECT * FROM users WHERE user_id != -1 AND user_level != -1 ORDER BY $sortby LIMIT $start, $topics_per_page";
068 if(!$result = mysql_query($sql, $db))
069 die("An Error Occured<HR>Could not contact the database. Please check and make sure you have supplied the correct user name and password for the database<BR>$sql");
070
071 ?>
072 <TABLE BORDER="0" CELLPADDING="1" CELLSPACING="0" ALIGN="CENTER" VALIGN="TOP" WIDTH="<?php echo $tablewidth?>">
073 <tr>
074 <td align=right>
075 <?php
076 $sql = "SELECT count(*) AS total FROM users WHERE user_level != -1";
077 if(!$r = mysql_query($sql, $db))
078 die("Error could not contact the database!</TABLE></TABLE>");
079 list($all_topics) = mysql_fetch_array($r);
080 $count = 1;
081 $next = $start + $topics_per_page;
082 if($all_topics > $topics_per_page) {
083 echo "<font size=-1>\n<a href=\"bb_memberlist.$phpEx?start=$next&sortby=$sortby\">Next Page</a> | ";
084 for($x = 0; $x < $all_topics; $x++) {
085 if(!($x % $topics_per_page)) {
086 if($x == $start)
087 echo "$count\n";
088 else
089 echo "<a href=\"bb_memberlist.$phpEx?&start=$x&sortby=$sortby\">$count</a>\n";
090 $count++;
091 if(!($count % 10)) echo "<BR>";
092 }
093 }
094 }
095 $next = 0;
096
097 ?>
098 <table width="100%" border="0" cellspacing="2" cellpadding="0" bordercolor="#000000" bgcolor="#000000">
099 <tr nowrap>
100 <td>
101
102 <?PHP
103
104 $row = mysql_fetch_array($result);
105
106 if (!$row) {
107 echo "<P><font face=Verdana Size=1>We Presently Have No Members To Report!";
108 } else {
109 ?>
110 <table width="100%"" border="0" cellspacing="1" cellpadding="0">
111 <TR>
112 <td bgcolor="<?php echo $color2?>" width="25%" height="25" nowrap><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <B><a href="<?php echo $PHP_SELF?>?sortby=user&start=<?php echo $start?>">User Name</a></B></TD>
113 <td bgcolor="<?php echo $color2?>" width="30%" height="25"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <B><a href="<?php echo $PHP_SELF?>?sortby=from&start=<?php echo $start?>">From</a></B></TD>
114 <td bgcolor="<?php echo $color2?>" width="8%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><B>Date Joined</B></TD>
115 <td bgcolor="<?php echo $color2?>" width="8%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><b><a href="<?php echo $PHP_SELF?>?sortby=posts&start=<?php echo $start?>">Posts</a></b></td>
116 <td bgcolor="<?php echo $color2?>" width="8%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><B>Email</B></TD>
117 <td bgcolor="<?php echo $color2?>" width="6%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><B>URL</B></TD>
118 <td bgcolor="<?php echo $color2?>" width="6%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><B>ICQ</B></TD>
119 <td bgcolor="<?php echo $color2?>" width="6%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><B>AIM</B></TD>
120 <td bgcolor="<?php echo $color2?>" width="5%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><B>YIM</B></TD>
121 <td bgcolor="<?php echo $color2?>" width="6%" height="25" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"><B>MSNM</B></TD>
122 </TR>
123 <?
124
125 do {
126 if ($row[user_viewemail]) {
127 $email = "<a href=\"mailto:$row[user_email]\"><img src=\"$email_image\" width=\"33\" height=\"17\" border=\"0\" alt=\"Email $row[username]\"></a>";
128 } else {
129 $email = " ";
130 }
131 if ($row[user_website]) {
132 $www = "<a href=\"$row[user_website]\"><img src=\"$www_image\" width=\"34\" height=\"17\" border=\"0\" alt=\"Visit $row[username]'s Web Site\"></a>";
133 } else {
134 $www = " ";
135 }
136 if ($row[user_icq]) {
137 $icq = "<a href=\"http://wwp.icq.com/scripts/search.dll?to=$row[user_icq]\"><img src=\"$icq_add_image\" width=\"32\" height=\"17\" border=\"0\" alt=\"Add $row[username]\"></a>";
138 } else {
139 $icq = " ";
140 }
141 if ($row[user_aim]) {
142 $aim = "<a href=\"aim:goim?screenname=$row[user_aim]&message=Hi+$row[user_aim].+Are+you+there?\"><img src=\"$images_aim\" width=\"30\" height=\"17\" border=\"0\" alt=\"AIM $row[user_aim]\"></a></TD>";
143 } else {
144 $aim = " ";
145 }
146 if ($row[user_yim]) {
147 $yim = "<a href=\"http://edit.yahoo.com/config/send_webmesg?.target=$row[user_yim]&.src=pg\"><img src=\"$images_yim\" width=\"16\" height=\"16\" border=\"0\" alt=\"YIM $row[user_yim]\"></a>";
148 } else {
149 $yim = " ";
150 }
151 if ($row[user_msnm]) {
152 $msnm = "<a href=\"$url_phpbb/bb_profile.$phpEx?mode=view&user=$row[user_id]\"><img src=\"$images_msnm\" width=\"16\" height=\"16\" border=\"0\" alt=\"MSNM $row[user_msnm]\"></a>";
153 } else {
154 $msnm = " ";
155 }
156 if ($row[user_regdate])
157 $regdate = $row[user_regdate];
158 else
159 $regdate = " ";
160 ?>
161 <TR>
162 <td bgcolor="<?php echo $color2?>" width="25%" height="30" nowrap><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <a href="<?php echo $url_phpbb?>/bb_profile.<?php echo $phpEx?>?mode=view&user=<?php echo $row[user_id]?>"><?php echo $row[username]?></a></TD>
163 <td bgcolor="<?php echo $color1?>" width="30%" height="30"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $row[user_from]?></TD>
164 <td bgcolor="<?php echo $color2?>" width="8%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $regdate?> </td>
165 <td bgcolor="<?php echo $color1?>" width="8%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $row[user_posts]?> </td>
166 <td bgcolor="<?php echo $color2?>" width="8%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $email?> </TD>
167 <td bgcolor="<?php echo $color1?>" width="6%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $www?> </TD>
168 <td bgcolor="<?php echo $color2?>" width="6%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $icq?> </TD>
169 <td bgcolor="<?php echo $color1?>" width="6%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $aim?> </TD>
170 <td bgcolor="<?php echo $color2?>" width="5%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $yim?> </TD>
171 <td bgcolor="<?php echo $color1?>" width="6%" height="30" nowrap align="center"><FONT FACE="<?php echo $FontFace?>" SIZE="<? echo $FontSize2?>" COLOR="<?php echo $textcolor?>"> <?php echo $msnm?> </TD>
172 </TR>
173 <?
174 } while ($row = mysql_fetch_array($result));
175 echo "</table> \n";
176 }
177 $count = 1;
178 $next = $start + $topics_per_page;
179 if($all_topics > $topics_per_page) {
180 echo "<font size=-1>\n<a href=\"bb_memberlist.$phpEx?start=$next&sortby=$sortby\">Next Page</a> | ";
181 for($x = 0; $x < $all_topics; $x++) {
182 if(!($x % $topics_per_page)) {
183 if($x == $start)
184 echo "$count\n";
185 else
186 echo "<a href=\"bb_memberlist.$phpEx?&start=$x&sortby=$sortby\">$count</a>\n";
187 $count++;
188 if(!($count % 10)) echo "<BR>";
189 }
190 }
191 }
192 echo "<BR>\n";
193 ?>
194 </td>
195 </tr>
196 </table>
197 </td>
198 </tr>
199 </table>
200
201
202 <?php
203 include('page_tail.'.$phpEx);
204 ?>
205