MyBB Community Forums

Full Version: need help
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Are there suppose to be an extra Admin added to the account? When I checked the number of Admin under my forum I see 3 but when I actually check to see who the extra Admin, there were none, only two.

Also how do you add an image to users?
An example would be this member rank.

http://community.mybboard.net/images/gro...upport.png
Run these queries in phpMyAdmin:

SELECT COUNT(*) AS Admins FROM `mybb_users` WHERE `usergroup` = '4';
SELECT COUNT(*) AS AdditionalAdmins FROM `mybb_users` WHERE `additionalgroups` LIKE '4';

What are the results??
Your SQL query has been executed successfully
SELECT COUNT( * ) AS Admins
FROM mybb_users
WHERE usergroup = '4';

Admins
2



Your SQL query has been executed successfully
SELECT COUNT( * ) AS AdditionalAdmins
FROM mybb_users
WHERE additionalgroups LIKE '4';

AdditionalAdmins
1
Someone has admin as an additional usergroup then. Run this one:

SELECT `uid`, `username` FROM `mybb_users` WHERE `additionalgroups` LIKE '%4%';

This will give you the username and UID of this user, you can then edit their settings.
Its fixed, Thanks Matt

Also how do you add an image to users?
An example would be this member rank.
http://community.mybboard.net/images/gro...upport.png

I want to have it like yours under username since I got one for each user group
Upload them to the ./images/groupimages/english/ folder, and then give the path to the image in the setting for the usergroup image in the settings for each group.
Thanks for your help today. Happy Holidays.
No problem, happy holidays to you too Smile