Profile Enhancements - Customizable Roster

Customizable Roster

Introduction:

This Mod is ideal for a Guild/Clan roster, but it is also a great replacement for the memberlist. Customize it any way you like: add or remove columns with just a few easy edits. The installer includes permission control that allows you to set which groups appear on the roster and which ones can view it. The most popular option is the ability to control advanced sorting; check it out!

Click Here For A Preview

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). When upgrading from version, make a copy of all your templates, then revert the templates back to their default, and then uninstall the older version. Also, make sure you delete the bitfield_showroster.xml file in the /includes/xml directory; this will cause database errors if not deleted.

Step 1: Download the showroster_vX.X.X.zip file and unzip it.

Step 2: Upload the files to their correct directories.

Upload the showroster.php to the /forum/ directory.
Delete the bitfield_showroster.xml in the /forum/includes/xml/ directory (if there).

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

Import the product-showroster_v4.x.x.xml file.

Step 4: 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 5: Admincp > Settings > Options > ShowRoster Settings

Update the settings for your roster: usergroups allowed to view the roster, usergroups that are displayed on the roster, the title and field# for each of your columns on the roster, and any of the many other settings.

Step 6: Admincp > Styles & Templates > Expand > ShowRoster Templates > SHOWROSTER, showroster_header, and showroster_userbits

You only need to adjust these if you have custom adjustments to make. Otherwise, there is no longer a need to change these.

NOTE: See installation and upgrading instructions in the included corresponding txt files.

Version Updates: See 2nd post.
FAQ: See 3rd post.
Screenshots: See 4th post.

PLEASE CLICK INSTALLED.
Support will be given to those that do.

[CoZmicShReddeR]

Ok I loaded it back... Having issues with the beta 4.03 version with usergroups...

I have uninstall it to update groups!

[Front Range 4x4]

Originally Posted by Sarcoth

@ Front Range - NP. I'm curious about those IF statements. I do have some in there now because there are new options that you need to set in the ShowRoster Settings which turn the Joined Date/Last Activity on. Although, they are on by default.

I have them turned on but it didn't help, once I removed the IF statements they popped right up.

[CoZmicShReddeR]

Also sorting can that be a drop down menu that might help the spacing out and would look nicer...

[Sarcoth]

Originally Posted by Front Range 4x4

I have them turned on but it didn't help, once I removed the IF statements they popped right up.

Did you download the new .php file as well? I just noticed the new xml file had more views than the php so I'm thinking that some of you were installing the new xml and not using the new php file. The post with the xml said the php file was 2 posts up.

Originally Posted by CoZmicShReddeR

Also sorting can that be a drop down menu that might help the spacing out and would look nicer...

I'm not sure what you mean.

[CoZmicShReddeR]

It was suggested to me to create a drop down menu for people to chose how they want to see the listing/sort instead of the table where you can click on the info to change the order you have a drop down menu with the listing of like where it says status at the top and there is a row of all the info about the roster users...

[Sarcoth]

Originally Posted by CoZmicShReddeR

It was suggested to me to create a drop down menu for people to chose how they want to see the listing/sort instead of the table where you can click on the info to change the order you have a drop down menu with the listing of like where it says status at the top and there is a row of all the info about the roster users...

Interesting. You gave me an idea. I'll see what I can do.

[Sarcoth]

All sorting should be working in this beta version. See attachment if you want to try it out. I haven't seen any errors. Please keep in mind, ALL options for this version are set in the ShowRoster Settings. There is no need to edit any usergroups. The bitfield file in the includes/xml folder can be deleted to avoid confusion.

Before I release the next full version:

1) I still want to get the avatar problem fixed, but I am having problems duplicating the problem. I need to know some options that you have on your forums before I can figure out what to do on mine. If you have a problem with the avatars working and you have a duplicate of your forums set up as a test site, let me know. I'd like to use that as a test bed so I can work out that problem. In the meantime, I'll keep looking into it.

2) I'm going to try and put together a different type of sorting area like Cozmic suggested. That is what I am working on now.

EDIT: #2 has been completed. I guess I'll release 4.0.3 as soon as I can figure out how to do the avatars. The zip file has been updated.

Check out my roster to view some of the changes: http://sacredhaven.org/forumsh/showroster.php
The Adventure/Crafting Level columns are set to a single table format. You can do that with any column. You can also adjust the direction they are sorted.

EDIT again: I found a small problem with the sorting again. I thought I had it all worked out, but apparently I missed something. The default sort works perfectly, but once you do another sort, the users with blanks for the column you are sorting will not appear on the list. That's fine, but it is supposed to be an option to do that. I'll figure it out tonight.

[CoZmicShReddeR]

I uninstalled the previous version and installed the one you just posted with the new showroster.php

I am having issues with the usergroups with this latest one it doesn't show and it makes a field in usergroups with a button but no info and when I click the button and click ok I get a database error...

Database error in vBulletin 4.0.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Registered Users',
	`description` = '',
	`usertitle` = '',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`downloads2permissions` = '127',
	`downloads2extrapermissions` = '0',
	`excludecatlist` = '',
	`downloadsmaxuploadtotal` = '-1',
	`downloadsmaxdailydl` = '-1',
	`downloadsmaxdailyfiles` = '-1',
	`downloaddelaygrp` = '60',
	`micromembers` = '31',
	`psiwd_options` = '0',
	`forumpermissions` = '12317183',
	`attachlimit` = '0',
	`showrosteraddpermissions` = '1',
	`trmpermissions` = '0',
	`dbtech_vbactivitypermissions` = '2',
	`vbblog_general_permissions` = '519166',
	`vbblog_customblocks` = '5',
	`vbblog_custompages` = '5',
	`vbblog_entry_permissions` = '8191',
	`vbblog_comment_permissions` = '974',
	`dbtech_vbshoutpermissions` = '2108',
	`genericpermissions` = '1579685575',
	`pmquota` = '50',
	`pmpermissions` = '3',
	`pmsendmax` = '5',
	`pmthrottlequantity` = '0',
	`calendarpermissions` = '63',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions2` = '1',
	`genericoptions` = '62',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '65535',
	`avatarmaxwidth` = '100',
	`avatarmaxheight` = '100',
	`avatarmaxsize` = '30000',
	`signaturepermissions` = '237567',
	`sigpicmaxwidth` = '500',
	`sigpicmaxheight` = '100',
	`sigpicmaxsize` = '10000',
	`sigmaxrawchars` = '1000',
	`sigmaxchars` = '500',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '4',
	`albumpermissions` = '255',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '63',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '251767',
	`maximumsocialgroups` = '5',
	`groupiconmaxsize` = '65535'
WHERE usergroupid=2;

MySQL Error   : Unknown column 'showrosteraddpermissions' in 'field list'
Error Number  : 1054
Request Date  : Monday, March 22nd 2010 @ 05:40:13 PM
Error Date    : Monday, March 22nd 2010 @ 05:40:13 PM
Script        : http://www.cozworld.com/admincp/usergroup.php?do=update
Referrer      : http://www.cozworld.com/admincp/usergroup.php?do=edit&usergroupid=2
IP Address    : 99.158.234.165
Username      : CoZmicShReddeR
Classname     : vB_Database
MySQL Version : 5.1.41

Also the Roster tab only shows when I go to the http://www.cozworld.com/showroster.php

[Sarcoth]

Did you delete the bitfield_showroster.xml in the includes/xml folder? Also, you have to put usergroups id's you want on the roster in the ShowRoster Setting options now.

[CoZmicShReddeR]

Ok deleting bitfield_showroster.xml fixed the showing empty field in usergroup issue!

But the Nav button not showing globally still exists... I tried disabling the tab mod didn't show even after trying 1-9 for position to show tab...