vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Template Modifications (https://vborg.vbsupport.ru/forumdisplay.php?f=192)
-   -   Profile Enhancements - Customizable Roster (Member List) (https://vborg.vbsupport.ru/showthread.php?t=141311)

ssslippy 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 03-28-2007 01:07 PM

Quote:

Originally Posted by ssslippy (Post 1214259)
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 03-28-2007 05:18 PM

Removed this post to prevent confusion.

Enjoy!!!

Brian31fl 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 03-28-2007 11:15 PM

Quote:

Originally Posted by Sarcoth (Post 1204306)
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 03-29-2007 12:02 AM

Quote:

Originally Posted by Sarcoth (Post 1214595)
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 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 03-29-2007 12:07 AM

Quote:

Originally Posted by grecostimpy (Post 1214906)
Awesome!

Still white screens on large usergroups though. :(

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

grecostimpy 03-29-2007 02:21 AM

Quote:

Originally Posted by Sarcoth (Post 1214911)
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 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.


All times are GMT. The time now is 04:57 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01251 seconds
  • Memory Usage 1,755KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete