Username HTML Markup in Forumdisplay

[Hasann]

Username HTML Markup in FORUMDISPLAY + SUBFORUMS by Hasann

This Product brought to you by
www.vbulletin-turkey.com (http://www.vbulletin-turkey.com/)

Description:

This mini Add-On will showing the Usergroups Username HTML Markup in
FORUMDISPLAY
SUBFORUMS

Installation:

Import the product-username_html_markup.xml product file via admincp -> product manager -> import/export products

Tested on:


vBulletin 3.7.x
vBulletin 3.8.x


Demo: www.vbulletin-turkey.com/forum (http://www.vbulletin-turkey.com/forum)

[Hasann]

reserved


if you using the old Usergroups Usernames in Forumdisplay Highlighting (https://vborg.vbsupport.ru/showthread.php?t=171623) modification
please uninstall it and install the new one

[KURTZ]

interesting Hasann, but isn't possible to do this without any file edit?

[Magnumutz]

Definitely installed :D

[rizelim]

thanks hasann.

[kaptanblack]

Thanks hasann

[princeedward]

...as always...one of the best also comes from you bro.hasann...thanks for the release and sharing it with us...
Rated Exellent...& Nominate...
;):up:

[Hasann]

interesting Hasann, but isn't possible to do this without any file edit?

nothing is impossible but coming soon with vBulletin v4.0.0 :)

[digicom]

Installed Apprciated :up:

[DarkGizmo]

Hasann can you update This Mod (https://vborg.vbsupport.ru/showthread.php?t=184426&highlight=Individual+HTML+user+markup) to include a Border option around the usernames and release it for both 3.7 and 3.8?

It would be much appreciated, thanks! :D

[eTiKeT?]

Hım Very Nice Thanks :)

installed

[DarkGizmo]

Does this work on 3.7? :)

[Hasann]

Hasann can you update This Mod (https://vborg.vbsupport.ru/showthread.php?t=184426&highlight=Individual+HTML+user+markup) to include a Border option around the usernames and release it for both 3.7 and 3.8?
It would be much appreciated, thanks! :D
No, I can't
I have no permission to update it
Does this work on 3.7? :)
yes it will work

[DarkGizmo]

Can you re-code your current one to include individual HTML markups then? or make something similar to Opserty's please?

[samet54]

Thanks hasann

[Hornstar]

very sexy ^^ ill have to give this a whirl when i upgrade.

[dannykilla]

Awesome!!!!

Thanks Hasann

[NAZIA]

nice Idea...
Tagged,,

[codershark]

works it also in searchresult ?

[haothiencz]

Hi Hassan, just want to ask you one question, if you really coded this mod by yourself ? :)

[sakli_duslerr]

Thanks Hasann

[macc]

Thanks
read about this code (before in some vb. version) that this code produce many database queries or server overloads?

regards

macc

[forumsonsuz]

Thanks hasann

[rob01]

un-installed :( this adds 20 queries to my forums


any idea?

[dvbusuario]

works it also in searchresult ?

me too!

Thank you

Install!!!

[R-D]

No, it doesn't work on the search results page.

Also, you might wanna look at the queries it adds to forumhome. 30 additional queries on my board, taking forumhome's total to 46.

On the plus side, it only added one query to forumdisplay.

[safakuygur]

excellent hassan :)

thanks Installed.

[alhamzeei]

Thanks hasann

[RvG2]

how many queries it adds up?

[R-D]

It adds one query for each category, forum, subforum and even for forums hidden from the index. If you don't have permission to see a forum (eg. a staff forum), that doesn't add a query.

My forumhome now uses 46 queries in total for staff members, 39 queries for regular members.

[Magnumutz]

It adds one query for each category, forum, subforum and even for forums hidden from the index. If you don't have permission to see a forum (eg. a staff forum), that doesn't add a query.

My forumhome now uses 46 queries in total for staff members, 39 queries for regular members.
Is that true Hasann?

[arauf]

Hasann i have installed your previous HTML Markup ..

i uninstalled that before installing this one but i am getting this Database Error :o

Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, hasannuser.displaygroupid AS hasanndisplaygid, hasannuser.usergroupid AS hasannusergid, huseyinuser.displaygroupid AS huseyindisplaygid, huseyinuser.usergroupid AS huseyinusergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS hasannuser ON (thread.lastposter = hasannuser.username)
LEFT JOIN user AS huseyinuser ON (thread.postuserid = huseyinuser.userid)
WHERE thread.threadid IN (0,6853,6583,4837,1441,3393,2797,1219,1459,1112,15 10,1111,1107,856,913,931,948)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Error Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Script : http://xxx/voiceforums/forumdisplay.php?f=9
Referrer : http://xxx/voiceforums/index.php
IP Address : 77.31.9.228
Username : Kareem
Classname : vB_Database
MySQL Version : 5.0.51a-community

Help :o !

[the.code]

i installed ur hack once and it created 70 additional query's to my forum index wich made my index to slow ill suggest the coder to update it reducing these query load

[Hasann]

Is that true Hasann?
yes it's true
Hasann i have installed your previous HTML Markup ..

i uninstalled that before installing this one but i am getting this Database Error :o

Database error in vBulletin 3.8.0 Beta 2:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, postusername, postuserid, thread.iconid AS threadiconid,
thread.dateline, notes, thread.visible, sticky, votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastpostid, replycount, IF(views<=replycount, replycount+1, views) AS views,
thread.prefixid, thread.taglist, hiddencount, deletedcount
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason

, threadredirect.expires
, hasannuser.displaygroupid AS hasanndisplaygid, hasannuser.usergroupid AS hasannusergid, huseyinuser.displaygroupid AS huseyindisplaygid, huseyinuser.usergroupid AS huseyinusergid
FROM thread AS thread
LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)

LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS hasannuser ON (thread.lastposter = hasannuser.username)
LEFT JOIN user AS huseyinuser ON (thread.postuserid = huseyinuser.userid)
WHERE thread.threadid IN (0,6853,6583,4837,1441,3393,2797,1219,1459,1112,15 10,1111,1107,856,913,931,948)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Column 'votenum' in field list is ambiguous
Error Number : 1052
Request Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Error Date : Tuesday, December 23rd 2008 @ 06:12:43 PM
Script : http://xxx/voiceforums/forumdisplay.php?f=9
Referrer : http://xxx/voiceforums/index.php
IP Address : 77.31.9.228
Username : Kareem
Classname : vB_Database
MySQL Version : 5.0.51a-community

Help :o !
did you installed this hack ?
https://vborg.vbsupport.ru/showthread.php?t=199568

i installed ur hack once and it created 70 additional query's to my forum index wich made my index to slow ill suggest the coder to update it reducing these query load

I take a look and I'll upgrade it

[arauf]

yes hassann i have installed ( [AJAX/vBOptimise] vB Profile Ratings 1.0.0 )

but u know i have uploaded Fresh ( functions_forumlist.php ) in includes folder now forum is back to normal but no HTML Markups in forumdisplay ....

but i want HMTL Markup :o

[KHALIK]

i installed ur hack once and it created 70 additional query's to my forum index wich made my index to slow ill suggest the coder to update it reducing these query load

Any change of reducing the additional query.
I want to install this mod, but really do not want to have lots of query running on my home page.

[itsIAN]

I installed the rate profile hack as well, and when I install this one, it causes a database error. I've disabled this mod for the time being.

[steve1966]

just had to uninstall becuase my vbadvanced shown errors

[vip-q.com]

Thanks hasann
Installed and in search page it doesn't work !!

I hope to fix :)

[Magnumutz]

So... any news on trying to optimize the queries?

[Noonster]

Works great - thanks!

[SweetHome]

Thanks hasann

[MẪ$T?Я]

its cool

i will try it

thanks ,

[dannykilla]

would it be possible to get this to work on the Forum Statistics near the footer on the forum homepage ?

Thanks
Danny

[dannykilla]

will there be any update to make this compatible with vbAdvanced ?

[hscorp]

thanks man

but you forgot some places like

inbox

[Magnumutz]

"Supported" became unsupported?

[SuperTaz]

Can you update this mod to also include vBadvanced?

[SwollenCranium]

Supported ?

Seems like NOT.

[mk craig 42]

thank you!

[Charlie98902]

Fix the Inbox of PM's and the search for new posts and this would be a great mod indeed.

[DarkGizmo]

Can you update this mod to also include vBadvanced?

^^ I would like this too, this was actually the reason I uninstalled this neat mod, it broke my vBAdvanced installation.

[SuperTaz]

You updated the product. What about the uploaded files? Where are they?

[dai-kun]

read the instructions

[Magnumutz]

And what's changed?

[Ceege]

Great, so now it only does forumdisplay and subforums.

I'd rather have the version that uses file edits so I can have the colored names everywhere.

[Hasann]

Great, so now it only does forumdisplay and subforums. What a worthless mod this is now.

I'd rather have the version that uses file edits so I can have the colored names everywhere.

it's your decision if you find this mod worthless than you don't need use it

[ForYou]

What about ForumHome , ?!!

[DraculaVN]

FORUMHOME not active ... Please help...

[LGKeiz]

FORUMHOME doesnt work.

[SuperTaz]

Go back to the old way. I did and it still works.

[thefifthlord]

nvm i miss read...

Nice job.

[Ceege]

it's your decision if you find this mod worthless than you don't need use it

Sorry, I edited out that one part...was in a grumpy mood (sick).

Would it be possible to also include forumhome? That'what I loved about this mod, and it makes it easy to distinguish when an admin/mod posts, because the name changes color.

Or would it be possible to get the old mod uploaded for us legacy people :)

[cleverone]

Forum home please.... would be a nice addition!

[hscorp]

forumhome please too :)

[Redzzand]

+10000 on forumhome!! please!?!

[Redzzand]

no support + no forumhome/forumdisplay markup = UNINSTALL

[Hasann]

Forum home please.... would be a nice addition!

forumhome please too :)

+10000 on forumhome!! please!?!

no support + no forumhome/forumdisplay markup = UNINSTALL

I won't add this feature on forumhome sorry if you dont like it you can UNINSTALL IT

[qbn720]

<font face="Tahoma">Nice little modification, it takes care of that tiny little bit of flavor we need. I can see why you chose to leave out ForumHome. Probably for the better, that's just a bit too much of a hassle, either way, I like it and I have installed. Keep up the great work, I like most of your mods!</font>

[itsheinz]

how about in the forum home?

[1uxkz]

if you run a large forum like i do ... i wouldn't install it... it adds way to many mysql queries to the server, almost 100 queries on every page load at least on my site and i usually only have 30 running.

[starplatinum]

if you run a large forum like i do ... i wouldn't install it... it adds way to many mysql queries to the server, almost 100 queries on every page load at least on my site and i usually only have 30 running.
upgrade your server instead :D

[Feanor_87]

Great work, thanks!!

Is there anyway for it to just show up in the Thread creator bit and not Last post by bit?

[Aclikyano]

need for forumhome!!!!!!!!!!!!

[ReadOrDie]

I won't add this feature on forumhome sorry if you dont like it you can UNINSTALL IT

Why not? At least add the option...

[tuRiver]

ForumHome and Search? is that posible?

[mk craig 42]

This worked for me before, but i uninstalled it accidentally, then re-imported the XML file to Plug in manager and it don't seem to work anymore. Any ideas?

[sebaldus]

I added the vBSEO forum in my forums and then came the big pictures like this in all posts https://vborg.vbsupport.ru/external/2009/05/35.jpg

There were unfortunately no other solution to get these out, than to uninstalled this addons. So if others get the same problem as this is the cause of these horrific images on all the posts.

If someone knows how to install this addons together with vBSEO, please tell me how..

All the Best from Sebaldus...

[Mysterious Ride]

Hmmmm...I need some help. It doesn't work on my forum unless I'm missing something. I imported it. What else should I do?

[DiLSuZ]

great plugin, thanks hasann

[Trek]

Doesn't seem to work on my forums either, I checked the default style as well and it's not working there either.

I imported it, but can't find any settings for it, etc... so I assume it should just start working? Using 3.8 BTW.

[Trek]

Nevermind, I was looking in forumhome for this to appear and it only works per forum_display. I see in a couple pages back the author won't be supporting forum home and says to uninstall... Anyway, the mod isn't broken, just doesn't do what many of us seemed to of expected.

[P?ŋĭsЋ?я]

Thanks Hasann..

[xpinx2pin]

i dunt know its a html markup bugs or seo bugs.
but when i installed it on my forum, some of user profile link is become invalid link. would u check the script please.

thanks

[bumwrap]

I would like to see it in new posts & todays post. Thanks.

[markblair]

Another great Hasann product. :) Installed

[Charlie98902]

I would like to see it in new posts & todays post. Thanks.

Won't happen this is why I uninstalled it as the author said he wouldn't add it. I'd think it would be simple and at least an option for those that want it and there is a lot of users wanting this feature.

[360themes]

plz make it effect on Forum home lastpost :)

[DanielGara]

I was searching in the web for put "username HTML mark" in forumhome (last post) and i found this:

1) Edit file functions_forumlist.php (file that is in folder "includes")

- Find:

$lastpostinfo = (empty($lastpostarray[$forumid]) ? array() : $vbulletin->forumcache["$lastpostarray[$forumid]"]);

- After Add:

if($lastpostinfo[lastposter])
{
$temp=$vbulletin->db->query_first("
SELECT userid, username, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "user
WHERE username = '".addslashes(htmlspecialchars_uni($lastpostinfo[lastposter]))."'");
if ($temp[userid])
{
$lastpostinfo[lastposter]= fetch_musername($temp);
}
}

:)

In my forum www.mundomedellin.com vbulletin 3.8.3 this worked perfectly

[NLP-er]

I was searching in the web for put "username HTML mark" in forumhome (last post) and i found this:

1) Edit file functions_forumlist.php (file that is in folder "includes")

- Find:

$lastpostinfo = (empty($lastpostarray[$forumid]) ? array() : $vbulletin->forumcache["$lastpostarray[$forumid]"]);

- After Add:

if($lastpostinfo[lastposter])
{
$temp=$vbulletin->db->query_first("
SELECT userid, username, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid
FROM " . TABLE_PREFIX . "user
WHERE username = '".addslashes(htmlspecialchars_uni($lastpostinfo[lastposter]))."'");
if ($temp[userid])
{
$lastpostinfo[lastposter]= fetch_musername($temp);
}
}

:)

In my forum www.mundomedellin.com vbulletin 3.8.3 this worked perfectly

Here you have plugin for "username HTML mark" in forumhome (last post) :
https://vborg.vbsupport.ru/showthread.php?p=1850299

Simple and easy - just import product :) no template modicications :) It colors only last post, so use booth plugins :)

[Strike-Force.ne]

I'm running both right now with 3.8.3 and haven't seen any issues with doing so. Works exactly like I want it to.

[macc]

Nice - thanks

one problem with vba CMPS - in news module shows image code instead avatar picture - disabled avatar in options - works fine

some solutions ?

regards

macc

[Strike-Force.ne]

Found an issue with this and vBSEO. Due to the html markup it's causing incorrect urls of the members. Here's an example of how it rendered one users profile link:

http://www.invertog.net/members/-font-color-blue-b-hightower-b-font-.html

While I like this plugin, I like vBSEO more.

UNINSTALLED

[Dr.LoVe]

Mark as installed ;)

but i have question if i can ask

can you put the colour also in the FORUMHOME to be more beatiful ??

however thank you :D

[Stryker412]

Installed a while ago, and all the sudden it is not working. I tried uninstalling and reinstalling, still nothing.

[Winterworks]

edit: nvm.

[Winterworks]

Oh, it works!

But what about the forum index? Can we have it for that too?

[rajubd]

i installed it but no changes anyone please help ...

[Dcoy]

thanks for this

[christon26]

i dunt know its a html markup bugs or seo bugs.
but when i installed it on my forum, some of user profile link is become invalid link. would u check the script please.

thanks

Found an issue with this and vBSEO. Due to the html markup it's causing incorrect urls of the members. Here's an example of how it rendered one users profile link:

http://www.invertog.net/members/-font-color-blue-b-hightower-b-font-.htmlWhile I like this plugin, I like vBSEO more.

UNINSTALLED

I am having the exact same issue as the above posters....and this is only happening with the username markup links, not the normal ones without username markup...and chance of a fix? I also have VBSEO installed...and I have the username markup for the forum home page also and it doesn't change the link like this....

Live example: http://www.havendesignz.com/forum/general-chatter/

Click on colored names...get the error message, click on normal black text names...reach profile just fine

Anyone?

[Bansheebob]

installed twice, does not work?

[HaqForum]

its not working on funky fresh skin ,.... can anyone confirm

[NetRover]

Excellent, helped me out with the advanced thread bit mod from someone else where username html markup had gone.

This mod works a treat. thank you.

[muratcan25]

Thanks Installed

[ZEHH]

Essa função é muito bom!

[And 1]

installed ;)

[Normandi2]

Installed

Thank's Hasann

[final kaoss]

Nice one, installed!

[Hasanudin]

thx for u Hassan :)

[choccyclaire]

Uninstalled now I have vbseo. Please fix? :)

[kabir]

Im Installed but not show color

[soulz2003]

grrr, does anyone know how to add html markup color in vbadvanced (recent threads), seems like nobody has a solution.

[Target Practice]

This appears to have stopped working since I installed vB 3.8.5... anyone else come across this?

[Target Practice]

Uninstalled as no longer working.

[whisky198x]

Fix AVATAR : Mod New vBadvanced CMPS
Hellp

[AftahFX]

Fix AVATAR : Mod New vBadvanced CMPS
Hellp


this will make it work - if you use hassan's mod an cmps:
for all styles find edit template adv_portal_newsbits:

change:

<img align="$stylevar[left]" style="padding:6px" alt="<phrase 1="$news[postusername]">$vbphrase[xs_avatar]</phrase>" border="0" src="$news[avatarpath]" />


to:

<img align="$stylevar[left]" style="padding:6px" alt="" border="0" src="$news[avatarpath]" />


:D

[Eduardo Leon]

well ..

installed but you have for : Forumhome ???

[Spadow]

Great addon, but is there anyway to get this working for the main page and in ''new posts''? Thanks in advance.

[JGreig]

This works for me apart from the forum index, what do I need to do to make it work there? Works every including the thread listing.

[Scyther]

Cool Mod..
Marked installed.

[majsm]

This works for me apart from the forum index, what do I need to do to make it work there? Works every including the thread listing.

For some reason it has stopped working in the FORUMHOME display for me as well anyone have a solution?

[Divvy]

Please update this mod to 4.x version :)

EDIT:
Ops... found It! hehe
https://vborg.vbsupport.ru/showthread.php?t=229146

But still have same bug...

[s.sami]

TR: Merhaba hasann peki bunu istediğimiz kullanıcı grupları için açıp yada kapıyabiliyormuz
mesela ben sadece adminlerin kırmızı gözükmesini istiyorum bunu nası sağlayabilirim?

ENG: Hi Hasann, could we apply this plug in for just admin user group, for example i wanna make red the only admins...

[hpidriver]

Any way to limit this to certain usergroups? Is there somewhere in the mod to add an inclusion/exclusion line? thanks

[Noser]

hi hasan great mod i used it a time ago but now i want to use it again on vb 3.8.7 but it doesnt work anywhere even in the standart style

greetings
noser

[Frosti]

For some reason it has stopped working in the FORUMHOME display for me as well anyone have a solution?


Same here... works once in the forums but not on index page

[Frosti]

Nevermind, I was looking in forumhome for this to appear and it only works per forum_display. I see in a couple pages back the author won't be supporting forum home and says to uninstall... Anyway, the mod isn't broken, just doesn't do what many of us seemed to of expected.

OH, OK, sorry, missed that. OH WELL

[Asmod]

Installation:

1. step: upload the hooks_username_html_markup.xml file to your forumroot/includes/xml folder


2. step: find in forumroot/includes/functions_forumlist.php file this code
PHP Code:
$lastpostinfo = (empty($lastpostarray[$forumid]) ? array() : $vbulletin->forumcache["$lastpostarray[$forumid]"]);


than add below this code
PHP Code:
($hook = vBulletinHook::fetch_hook('forumbit_lastpostby')) ? eval($hook) : false;


Save and reupload.

3. step:

And at least import the product-username_html_markup.xml product file via admincp -> product manager -> import/export products

files link http://www.vbteam.info/attachments/vb-3-8-x-addons-and-template-modifications/9225d1229540370-username-html-markup-in-everywhere-username_html_markup.zip


hope i wont get banned but this is also found on google, since it used to work on FORUMHOME also without tweaking and stuff...

[itilm]

Hay this not working on Forum Display on 3.8.7 version !!1

[Andr? Noberto]

not working..can you fix it?

[AllenBAN]

it's not working for me ??

[AllenBAN]

how do you make it work i imported it and it's not showing any settings or legend bar or anything ???