Add-On Releases - Member List for VB5

This is an add-on that does NOT plug into VB5's API. This is a stand-alone file that utilizes the VB5 header and footer system to wrap my implementation of the member list with the look/feel of your VB site. You may need to edit colors and such; that is up to you to change. But it is compatible with the out of the box VB5 style.

This is running at this URL:
www.diecastmodelaircraft.com/memberlist.php

We have a more customized version running here:
www.diecastmodelaircraft.com/memberlist

Instructions:
1. Upload all files in the upload directory to the root of your VB5 install
2. Edit memberlist.php as follows
Your Site URL
Maximum Number of users per page
Display for Logged Out Users
3. These settings are obtained from your vb install config file, you should not have to modify these
Mysql Host
Database User
Database Password
Database Name
Database Prefix (if any)
4. Load http://www.yoursite.com/memberlist.php

Optional:
Add the following lines to .htaccess

RewriteEngine on
RewriteRule ^(memberlist)$ /memberlist.php [QSA,L]
RewriteRule ^(memberlist)/$ /memberlist.php [QSA,L]

Now you can access your memberlist by going to the url:
Load http://www.yoursite.com/memberlist

Questions? Comments?
Email: todd@aero-pro.net

Donations are gladly accepted for this work:
paypal@aero-pro.net

If you install it, let us know so we can see how it works on other sites.

Revision Info:
.10 - First Release
.11 - Created Zip file w/different paths.
.12 - Adjusted paths for images to be relative; modified link to use profile; added ability to work with databases with prefix.
.13 - Better db prefix handling; removed un-needed DB variable.
.14 - Added ability to display list only for logged in users; misc bug fixes, added link to this thread for support. Expanded readme.txt.
.15 - Fixed bug for show member list for users who aren't logged in. System now uses core/includes/config.php for mysql settings.

[CheeseMan316]

Hope you don't mine me making a quick change, and I'm not trying to take any credit here, but I found an interim solution until you release the v.14 "official" page. We are releasing the site to our members tonight so I wanted to get something.

I added:

//show only registered users 
//I know membergroupids could be wrong, but all of the users who aren't in the primary
//group id 2 (registered) that I want to appear start with 2 so it works
$custom_group_mask = " (usergroupid = 2 or membergroupids like '2,%') and ";
//validate the user session cookie against the session db to ensure a valid user id is returned
//and it is for the current IP address.
$session_check = "exists (select 1 from ".$vb_prefix."session where userid != 0 and host='".$_SERVER['REMOTE_ADDR']."' and sessionhash = '".$_COOKIE["bbsessionhash"]."') and ";

Then I modified the queries to be as follows:

$query ="Select * from ".$vb_prefix."user where ".$custom_group_mask.$session_check." username like $like order by username";
$query ="Select * from ".$vb_prefix."user where ".$custom_group_mask.$session_check." username like $like order by username LIMIT $from, $max_results";

[wdwms]

Originally Posted by CheeseMan316

Hope you don't mine me making a quick change, and I'm not trying to take any credit here, but I found an interim solution until you release the v.14 "official" page. We are releasing the site to our members tonight so I wanted to get something.

I just released .14 with your wish granted..

The code actually takes the bbsessionhash cookie and looks up if the user is logged in via the session table.

Let me know if this is what you are after.

[CheeseMan316]

Thank you!

[doctorsexy]

Hi ... a little problem all im getting is ...You must be logged in to access the member list... and i am..ive done something wrong ..any suggestions . thanks

[wdwms]

Originally Posted by doctorsexy

Hi ... a little problem all im getting is ...You must be logged in to access the member list... and i am..ive done something wrong ..any suggestions . thanks

In memberlist.php, what do you have:
$showto_loggedout

set too in the config?

[doctorsexy]

$showto_loggedout = 1;

[wdwms]

You can get by this by changing

PHP Code:

if ($loggedin && $showto_loggedout) 


to

PHP Code:

$loggedin=1
if ($loggedin) 


But please email me directly, i'd like to find out why your are seeing this.

[doctorsexy]

Hi..with that all im getting is a white page... the joys of vb5

[wdwms]

You don't have your mysql settings configured correctly. Remove the line error_reporting(0); run the script again and email me the errors: todd@aero-pro.net

[doctorsexy]

hi ..done that and no errors just says ...You must be logged in to access the member list.