Profile Enhancements - Cel Display Usergroups on Member Profile or in Postbit

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]

Originally Posted by Elixar

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".