Cel Display Usergroups on Member Profile or in Postbit

[cellarius]

What does it do?
This addon lets you display a list of all usergroups in a member profile side block and/or in postbit. Visibility of the information can be limited by usergroup, so you can show it only to your admins and moderators.

How does it work?
Without additional queries on postbit and just one small query on the member profile page, i.e. practically without overhead. The necessary information is being pulled from the cache wherever possible.

How to install?
- Upload the contents of the UPLOAD folder to your forum root.
- Install the addon xml file.
- Check the settings AdminCP->Settings->Options.

Something special?
- For the member profile, you can choose where in the sidebar the usergroups are to be displayed.
- The ouput is templated (postbit_cel_ugdisplay and memberinfo and memberinfo_block_cel_ugdisplay), so you can adapt it to your liking (within limits)
- Each usergroup is wrapped in <span>-Tags with a unique css-class, so you can style it using the additional.css (cel_ugdisplay_ug6, where the bold number is the usergroup id)

[cellarius]

Fixed a minor bug and reuploaded package. Please redownload and reupload cel/ugdisplay/code.php, no need to reinstall the .xml-file.

[Elixar]

I just updated the file, and I just got a DB error.

[cellarius]

I just updated the file, and I just got a DB error.
Please always post the full error text, and best do so inside code tags.

[Elixar]

I just replaced it with the old file since at first I thought the whole board broke, it's just the profile. Let me see.

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT membergroupids FROM user;

MySQL Error : Table 'forumsfo_vb1.user' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 18th 2014 @ 06:49:07 PM
Error Date : Tuesday, March 18th 2014 @ 06:49:07 PM
Script : http://*/member.php?1-Elixir
Referrer : http://*/forum.php
IP Address : 96.225.133.161
Username : Elixir
Classname : vB_Database
MySQL Version : 5.5.36-cll

[cellarius]

Please redownload and upload the file once again.

[Elixar]

Alright I did that, still giving me the error. Sorry about all this. :(

[cellarius]

Exactly the same error?

[Elixar]

Yes. :)

[cellarius]

Maybe something went wrong with down/upload. Could you redo the procedure, and if the error persists, post it again? I'm really at a loss there - after all your user table needs to exist and your table prefix indeed is "forumsfo_vb1".

[Elixar]

Database error in vBulletin 4.2.2:

Invalid SQL:
SELECT membergroupids FROM user;

MySQL Error : Table 'forumsfo_vb1.user' doesn't exist
Error Number : 1146
Request Date : Tuesday, March 18th 2014 @ 07:37:21 PM
Error Date : Tuesday, March 18th 2014 @ 07:37:21 PM
Script : http://`/member.php?1-Elixir
Referrer : http://`/forum.php
IP Address : 96.225.133.161
Username : Elixir
Classname : vB_Database
MySQL Version : 5.5.36-cll

[cellarius]

OK. I think I caught the nasty little bugger. Sorry for all the bother, but could you do the procedure one last time (hopefully)?

[Elixar]

There we go, works. :)

[cellarius]

Great!

[Elixar]

I took the groups off the postbit, and now I'm getting white screens on the threads.

[cellarius]

And another try ;)

[Elixar]

I am no longer getting the white screen, but it won't disappear from the post bit.

[cellarius]

Hm, I really think I need to get some sleep...

Wanne give it a last try for today?

[Elixar]

It just transported me to Greece. :D

Haha in all seriousness, everything works. :)

[cellarius]

It just transported me to Greece. :D

Haha in all seriousness, everything works. :)
I'd like Greece, though :D

[ozzy47]

It just transported me to Greece. :D

Haha in all seriousness, everything works. :)

Now that wade me laugh. :)

[Elixar]

Is it possible to limit who can view the usergroup list on profiles and such? I'm mainly looking to only allow Staff access to view them.

[Elixar]

Bump. :)

[ozzy47]

Ummm, is that not what the setting, Enter a comma seperated list of userids. Default: Administrators (6), Supermoderators (5), Moderators (7) is for?

[Elixar]

What I mean is I don't want all usergroups to see which usergroups a member is in. Only certain Staff usergroups.

[ozzy47]

Right, so if you enter 5,6,7 in that setting, only Administrators, Supermoderators and Moderators should be able to see the display of usergroups a member is in.

[Elixar]

Um....I'm dumb .

I read that wrong the whole time. So sorry to ozzy and cellarius. :(

I thought that meant for them to be displayed on the profile.

[ozzy47]

LOL, it's cool. Yeah that setting is for allowing of groups viewing of the info, not which groups it shows up on. :)

[Elixar]

Ooooo okay, I promise I didn't drink last night. :D

Okay only a little shot glass. :D

[ozzy47]

Well to be fair, the setting is not very descriptive, it don't even have a title, or tell you what setting numbers in there does. Only way I knew was to look at the code and see what the setting actually did. :)

It happens to all coders at some point, when you push out a mod quickly, the phrase may have been created, but cel forgot to tag it for his mod, and it is actually tagged for vBulletin.

[Elixar]

Okay I just noticed this. In order for certain user groups to display on the profile, you have to give them the ability to see groups on profiles too for some reason.

[Elixar]

Any way to fix this?

[Elixar]

Any idea?