The Arcive of Official vBulletin Modifications Site.

Customizable Roster (Member List) · **Released**: 03-05-2007

Customizable Roster (Member List)
[How to] get a working Guild/Clan Roster

Note: This modification is now discontinued - this means that while it will remain available for download and use, support will no longer be provided as the thread is no longer monitored. Please see the 3.7 release of this modification for future updates here.

Introduction:

This Mod started off as a [How to] template modification. I have since added in permission control and an installer. Those that install this Mod will need to make adjustments to two templates and one phrase depending on what you want displayed. I'll include instructions for each step as well as optional changes you can make at your decretion.

Click the following link for a Guild Roster preview: http://vanguard.sacredhaven.org/forums/showroster.php

You'll notice that I use the "Extra Profile Fields Page" by Wired1. It isn't needed for the Roster, but I think it makes the field updates look nicer for the users.

Installation:

Step 0: If you are upgrading from a previous version, save a copy of your old showroster.php and rename your showroster templates (I recommend giving them an underscore prefix; Example: _SHOWROSTER).

Step 1: Download the attached showrosterXXX.zip file.

Step 2: Upload the files to their correct directories.

Upload the showroster.php to the /forum/ directory.
Upload the bitfield_showroster.xml to the /forum/includes/xml/ directory.
Upload the spacer.gif to the /forum/images directory if you plan to use avatars.

Step 3: Admincp > Plugin & Products > Manage Products > Add/Import Product

Import the product-showroster.xml file.

Step 4: Admincp > Languages & Phrases > Phrase Manager > Phrase Type: ShowRoster > showroster_title --> Edit

Change this to whatever you want as the title of your roster.

Step 5: Admincp > User Profile Fields > Add New/Update User Profile Field

Add all the Profile Fields you plan to use and keep track of their number(s) (i.e. field6, field7, etc.).

Step 6: Admincp > Styles & Templates > Expand > ShowRoster Templates > showroster_header

This template contains the headers for each of your columns. Add/Edit/Remove columns to your preference. Be sure to update the colspan to the number of columns you have.

Step 7: Admincp > Styles & Templates > Expand > ShowRoster Templates > showroster_userbits

This template gets the data from each of the fields you want to have viewed on your roster. Add/Edit/Remove columns and/or the nowrap="nowrap" to your preference. Be sure to update each of the field#'s to match the fields from Step 5.

Step 8: Admincp > Usergroups > Usergroup Manager > Edit Usergroup

Set "Access - Should this usergroup have access to the Showroster page?" to Yes for whatever groups you want to have permissions to access the showroster page.

Set "Viewable - Should this usergroup be viewable on the Showroster page?" to Yes for the groups you want to have appear on the showroster page.

All instructions are included in the instructions.txt and optional.txt.

Enjoy!!!

Versions:

v1.1.3 - April 22, 2007

Added 'Who's Online' plugin to the installer (Thanks m002.p).
Made an update to the optional.txt file for changing the default sort.

v1.1.2 - April 20, 2007

Added sorting to the roster. This is optional and will work without adding the sorting features.

v1.1.1 - April 19, 2007

Small update. Just added total member count.

v1.1 - April 5, 2007 (Mod Revamp)

Revamped everything. There is now an installer to do most of the work for you.
The installer adds two new fields to your usergroup table. This allows you to set permissions for the showroster rather than using the showgroups permissions.
Removed a few options from the optional.txt file since they are now a part of the mod.

v1.03 - April 2, 2007

Added some code back to the showroster.php so join date, last activity, and usernames HTML markups could be used.
Changed $user[username] to $user[musername] in the showroster_userbits template. This will allow HTML markups to the usernames again.
Added instructions on how to change which usergroups appear on the Roster.
Added optional.txt to the zip for optional changes.

v1.01 - March 27, 2007

Changed a few variable names.
Changed template names.
Removed a lot of unneeded code from the showroster.php.
Added the ability to include user avatars.
Added a counter to keep track of how many users in each usergroup.

v1.01 - March 9, 2007

Removed a lot of unneeded code from the SHOWROSTER template.
Fixed a couple code problems.

v1.0 - March 6, 2007 (Initial Release)

ssslippy · #82 03-28-2007, 05:49 AM

Ive got the code here. Ill leave it up to u to make it so u can like make these changes inside the admin panel.

PHP Code:


			
$users = $db->query_read_slave("

SELECT user.*, usergroup.usergroupid, usergroup.title, user.options, usertextfield.*, userfield.*,  

IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid 

FROM " . TABLE_PREFIX . "usergroup AS usergroup 

LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.usergroupid = usergroup.usergroupid OR FIND_IN_SET(usergroup.usergroupid, user.membergroupids)) 

LEFT JOIN " . TABLE_PREFIX . "userfield AS userfield ON(userfield.userid = user.userid) 

LEFT JOIN " . TABLE_PREFIX . "usertextfield AS usertextfield ON(usertextfield.userid=user.userid) 

WHERE (usergroup.usergroupid = 161 or usergroup.usergroupid = 168 or usergroup.usergroupid = 145 or usergroup.usergroupid = 170 or usergroup.usergroupid = 164)

");

Ive got a working example here http://immortal-guild.net/forums/showrostervanguard.php, i still have to change my usergroup ids so i can sort them by that.

Sarcoth · #83 03-28-2007, 01:07 PM

Quote:

Originally Posted by ssslippy

Ive got the code here. Ill leave it up to u to make it so u can like make these changes inside the admin panel.

PHP Code:


			
WHERE (usergroup.usergroupid = 161 or usergroup.usergroupid = 168 or usergroup.usergroupid = 145 or usergroup.usergroupid = 170 or usergroup.usergroupid = 164)

Ahhhh, I didn't put () after the WHERE, which is why my tests were not working. Thanks Ssslippy. I'll get around to testing soon. My FTP appears to be down at the moment. Either that or my work realized I was doing a lot of FTP and blocked the port. Oh well.

Sarcoth · #84 03-28-2007, 05:18 PM

Removed this post to prevent confusion.

Enjoy!!!

Brian31fl · #85 03-28-2007, 10:53 PM

edit is now working can be seen here http://sacred-dragoons.com/forums/showroster.php
now to figure how to arrange the usergoup to show the right ones in order

Brian31fl · #86 03-28-2007, 11:15 PM

Quote:

Originally Posted by Sarcoth

Jeff, I found an answer for you while playing with some of the code.

This change will allow you to sort the groups by their groupid.

Open showroster.php

Find:

Code:

$t = strtoupper($user['title']);

Replace with:

Code:

$t = strtoupper($user['usergroupid']);

Then upload the updated showroster.php to your site.

FYI - Anyone that wants support, you need to click Install.

never mind i solved it with this small change that was posted a while ago seems to be working great good job buddy

grecostimpy · #87 03-29-2007, 12:02 AM

Quote:

Originally Posted by Sarcoth

You guys are going to love this...I hope.

I've only tested this in my test site so far, so use at your own risk. It is working for me though, so you shouldn't have any issues. I'll keep testing it for the rest of the day and wait for some brave souls to test it out. After that, I'll put the whole hack together in a nice install file for your enjoyment.

Here is what you need to do.

Step 1: Download the attached showrosterpermissions.zip file.

Step 2: Copy the new showroster.php to the /forum/ directory.

Step 3: Copy the bitfield_showroster.xml to the /forum/includes/xml/ directory.

Step 4: Admincp > Plugin & Products > Manage Products > Add/Import Product

Import the showroster.xml file.

Step 5: Admincp > Usergroups > Usergroup Manager > Edit Usergroup

Set "Access - Should this usergroup have access to the Showroster page?" to Yes for whatever groups you want to see the showroster page.

Set "Viewable - Should this usergroup be viewable on the Showroster page?" to Yes for the groups you want to show on the showroster page.

ZIP file is attached. I am anxiously awaiting your feedback.

Enjoy!!!

Awesome!

Still white screens on large usergroups though.

Sarcoth · #88 03-29-2007, 12:05 AM

Brian - Great to hear!

As soon as I get all the code together, I'll start up a new hack thread in the Mod forum. I'll keep supporting this one here for those that wish to only make design template changes. The new one will be using the install found in post #83 above. I have a lot more things I want to add to it before posting it though.

Sarcoth · #89 03-29-2007, 12:07 AM

Quote:

Originally Posted by grecostimpy

Awesome!

Still white screens on large usergroups though.

greco - Do you happen to have that problem with the actually showgroups page?

grecostimpy · #90 03-29-2007, 02:21 AM

Quote:

Originally Posted by Sarcoth

greco - Do you happen to have that problem with the actually showgroups page?

Yes, if I try to include a large usergroup, it white screens as well. I guess the roster page uses the same basic setup (hence the issue on both)?

grecostimpy · #91 03-29-2007, 02:29 AM

OK Sarcoth...this was not a problem with your hack. My php was not allotting enough memory to perform this task. Once I upp'ed it to 32M, it works fine now.

Thanks for all your help once again.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.09041 seconds Memory Usage 2,329KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (2)bbcode_php (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!