Custom User Status by Usergroup [Final]

I could not find a way to add an additional user status field based on usergroup other than setting a override, which got rid of the normal usertitle based on post count and I didn't want that. This is my solution.

This hack adds an additional field to the usergroup table and allows you to display that custom group status field in addition to the normal usertitle that is defined either custom for the user or normally by number of posts without overriding the usertitle variable.

The end result gives you something like this (depending on how you edit your postbit template) for the output:

Jen
Tyro Hacker
[Custom Group Status Here]
[Users Avatar]
[Users other details]

The custom group status is set within the cp from the user group modify function for each group you want to add this additional status field to.

Questions, Problems, etc.. ask here as I am unable to provide support via email. This hack has been tested on vB 2.2.6.

[Elly]

Thanks Jen ^_^

[Allstar DC]

any updates yet?

[Jen]

My apologies, I've been very busy the past week or so and haven't had time to look into these two issues.

I will work on them over the weekend and have a fix on the image issue and verify if there are conflicts with the other hack.

[Jen]

I tested the hack for using an image as the group custom status and had no problems using the standard HTML IMG tag to reference the image to be used.

PHP Code:

<IMG SRC="http://www.yourhost.com/yourimage.gif"> 


The standard HTML tag did work without problem. If it is not working for you please post some more information on exactly what behavior you are getting as well as what code you are using to display your image etc.

[Allstar DC]

i got the image working now, but for some reason i now get an error when tying to add or modify a usergroup.

i received the following error when trying to add a new usergroup"

mysql error: Column count doesn't match value count at row 1

mysql error number: 1136

[Jen]

Found the conflict with the Stars hack.

The database changes for Stars in admin/usergroup.php also occur with this hack and it's likely something was left out or changed improperly which is causing the conflict. I'll post an update to the sql for users who have Stars shortly.

[Elly]

Thank you very much Jen ^_^

[Allstar DC]

sorry for not replying, but i was on a short vacation

my errors are fixed, it had nothing to do with this hack, my database just got screwed up a lil.

about the stars, i have them installed too, but don't have anyprobs with it

[JeffyJoe]

Originally posted by Jen
Found the conflict with the Stars hack.

The database changes for Stars in admin/usergroup.php also occur with this hack and it's likely something was left out or changed improperly which is causing the conflict. I'll post an update to the sql for users who have Stars shortly.

Jen, Have you updated the sql yet?
I had stars on mine and cannot get mine to work... I think the stars is the problem...

[JeffyJoe]

What does this mean?

Database error in vBulletin 2.2.8:

Invalid SQL:
SELECT
post.*,usergroup.groupcustomstatus,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attach ment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
FROM post
LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
LEFT JOIN usergroup ON usergroup.usergroupid=user.usergroupid
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,2163,2198,2199,2202,2205,2396)
ORDER BY dateline

mysql error: Unknown column 'usergroup.groupcustomstatus' in 'field list'

mysql error number: 1054

Date: Monday 18th of November 2002 03:32:34 PM
Script: http://www.mysite.com/chat/chat/show...=&threadid=392
Referer: http://www.mysite.com/chat/forumdisp...p?s=&forumid=5

Specifically what does "mysql error: Unknown column 'usergroup.groupcustomstatus' in 'field list' " mean

(I have been screwing with this for a few weeks now and can't figure it out... considering hiring someone to fix this