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.

[Brandon Sheley]

great work again!

[WhiskeyOSS]

this is a awesome addition, and very simple to setup.. thank you

[smgxtreme]

Awesome, the members at our site have been asking about something like the old one. Thank You!

[smgxtreme]

Well, installed exactly how instructions say and I see the page but it wont pull from db.
I do have db prefix, you think thats the problem?
I added subdomain where vb5 is installed: www.domain.com/vb5 ofcourse I used my domain name.

Also images don't show up unless I add subfolder before images in the memberlist.php
Like: src=/vb5/images/memberlist/contact.png

I did add the stuff to .htaccess also.

For the ones that got it working, is your forum install to domain.com or subfolder like domain.com/vb5 ?

[wdwms]

Originally Posted by smgxtreme

Well, installed exactly how instructions say and I see the page but it wont pull from db.
I do have db prefix, you think thats the problem?
I added subdomain where vb5 is installed: www.domain.com/vb5 ofcourse I used my domain name.

Also images don't show up unless I add subfolder before images in the memberlist.php
Like: src=/vb5/images/memberlist/contact.png

I did add the stuff to .htaccess also.

For the ones that got it working, is your forum install to domain.com or subfolder like domain.com/vb5 ?

Try v.12 that i just uploaded. Make sure your URl w/the subdirectory is set properly in the settings, you have to put the full URL to where you have it installed. I also added a setting for your db prefix.

[smgxtreme]

Yeah still not working. I also moved my whole vb5 install to root domain hoping it will fix it.

So basically I did edit all the database settings and i know they are correct.
And path is correct, prefix didn't fix.

Only thing I can think of is maybe my version of php, apache or mysql?
php is 5.3 , apache is 2.2....

Hmm, I even added to .htaccess

This is vb5 version 5.0.0

You can see what I see here: www.xtremevisiongaming.com/memberlist I also included screenshot.

Also I noticed in the memberlist.php it shows $vb_host="'127.0.0.1"; I see an extra ' after the first set of quotes.

Thanks for your help though.

[wdwms]

Originally Posted by smgxtreme

Yeah still not working. I also moved my whole vb5 install to root domain hoping it will fix it.

So basically I did edit all the database settings and i know they are correct.
And path is correct, prefix didn't fix.

Only thing I can think of is maybe my version of php, apache or mysql?
php is 5.3 , apache is 2.2....

Hmm, I even added to .htaccess

This is vb5 version 5.0.0

You can see what I see here: www.xtremevisiongaming.com/memberlist I also included screenshot.

Also I noticed in the memberlist.php it shows $vb_host="'127.0.0.1"; I see an extra ' after the first set of quotes.

Thanks for your help though.

Comment out the line that has the include for vbheader.php and vbfooter.php and error_reporting. Then load the file and post the error message.

[smgxtreme]

Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in /home/vision/public_html/memberlist.php on line 96

Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in /home/vision/public_html/memberlist.php on line 97

mysql_numrows() expects parameter 1 to be resource, boolean given in /home/vision/public_html/memberlist.php on line 207

[wdwms]

Originally Posted by smgxtreme

Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in /home/vision/public_html/memberlist.php on line 96

Warning: mysql_numrows() expects parameter 1 to be resource, boolean given in /home/vision/public_html/memberlist.php on line 97

mysql_numrows() expects parameter 1 to be resource, boolean given in /home/vision/public_html/memberlist.php on line 207

Your Mysql settings are incorrect, please email me directly at todd@aero-pro.net so i can get you setup.