Username Prefix with Html MarkUp (Clan Tags) 4.x.x

[Elite_360_]

This mod is now combine with this mod e360 - Username Html MarkUp 4.2.x (https://vborg.vbsupport.ru/showthread.php?t=290368)

Can a Moderator or Admin put this in graveyard

[Elite_360_]

Version Information:

v1.0 - Nov 08. 2012.
-First version

v1.0.4 - Nov 15 2012
-Change XML ID from e360_clantag to e360_prefix
-Change Name of Mod from Clan Tags with Username Html MarkUp to e360 - Username Prefix with Html MarkUp
-New: Display The User Display Usergroup color if they are in multiple Usergroups Works on newest member too as of 1.0.4
-New: Newest Member Markup without adding a new Query as of 1.0.4
-New: Optimize The Code
-Fix bug when someone reply to a post it changes the postusername to the lastposter markup color on thread display
-Fix ToolTip Bug on the Started by on threadbit
Next Release Plans:

v1.1.0
-Custom Fonts Selection will be compatible with e360-@font-face-@keyframes (https://vborg.vbsupport.ru/showthread.php?t=292744)
Release Date ?

[SpikedRocker]

Interesting, could you possibly make this usergroup specific? Tagged.

[Elite_360_]

Interesting, could you possibly make this usergroup specific? Tagged.
what do you mean? it for the ever user to have there own tag it can be what ever they want, and it uses the usergroup html markup so the color will match the usename. on my site my user name is Elite_360_, with this mod i can have my clan tag on my name like this [BoE] Elite_360_.

[Mr_Running]

Interesting, could you possibly make this usergroup specific? Tagged.

I believe this means Usergroup Manager permissions.
I would like to see permissions too. :)

Enable For Specified Usergroups
Select usergroups. It would be good if the Primary and secondary groups worked too.

[Elite_360_]

I believe this means Usergroup Manager permissions.
I would like to see permissions too. :)

Enable For Specified Usergroups
Select usergroups. It would be good if the Primary and secondary groups worked too.
yeah i read it wrong been up all night coding yeah i can make it do that only some usergroups can see or use or both? i will have a update in like an hour or so.

Its going to be later today if you guys want it for select usergroups that can only use and see the mod. I have to change the code and alter the user table for it to work. No more custom fields so a user cant enter info into it, or it show on register page then a new user can put info into it. They will only be able to edit on the edit profile page if they in one of the usergroups with permissions. Well i can make it so they still see the markup just not the clan tags. Admin can edit it on the user info in the admin cp

[v123shine]

can u provide screen shot, please!

[SpikedRocker]

Or that each usergroup has its own unique clan tag. The website I run has like 3 or 4 different tags that could be used in this fashion, but they are slightly different from each other.

Sorry for not explaining it better myself, was up pretty late last night.

[Elite_360_]

Or that each usergroup has its own unique clan tag. The website I run has like 3 or 4 different tags that could be used in this fashion, but they are slightly different from each other.

Sorry for not explaining it better myself, was up pretty late last night.
that fine i was up late too.
well this is for user to have a Clan tag in front on there name and they choose what there clan tag is it only take the usergroup html markup and colors the clan tag to what usergroup they are in you can make usergroup tags by edit the usergroup html markup go to admin cp > Usergroups > Usergropu Manager > select the usergroup you want > Username HTML Markup put this in the first column<span style='color: (COLOR YOU WANT HERE);'>(YOUR TAG HERE) 2nd column(OR YOU TAG HERE)</span>

[Elite_360_]

I believe this means Usergroup Manager permissions.
I would like to see permissions too. :)

Enable For Specified Usergroups
Select usergroups. It would be good if the Primary and secondary groups worked too.

im working on it now i can make so only specified usergroups can use it but everyone going to see it i tried so specified usergroups can see and use but the usergroups that can see only see it in some place so im going to take that out its going to be a new mod called Username Prefix html markup

[SpikedRocker]

that fine i was up late too.
well this is for user to have a Clan tag in front on there name and they choose what there clan tag is it only take the usergroup html markup and colors the clan tag to what usergroup they are in you can make usergroup tags by edit the usergroup html markup go to admin cp > Usergroups > Usergropu Manager > select the usergroup you want > Username HTML Markup put this in the first column<span style='color: (COLOR YOU WANT HERE);'>(YOUR TAG HERE) 2nd column(OR YOU TAG HERE)</span>

Ah ok, i'm following you now...thanks!

[leejohn02]

it gave me a database error i cant access the anything on the site now HELPPPPP

[Elite_360_]

it gave me a database error i cant access the anything on the site now HELPPPPP

did you up load the e360mods folder to your forum root first, and what vb version do you have? whats the database error? put this in you vbulletin /includes/config.php file define("DISABLE_HOOKS",1); right above this
// ****** DATABASE TYPE ****** then uninstall

[leejohn02]

i put the file in, installed the xml, it was only when i activated the plugin, it completely crashed my site, and every page even the admin panel showed a database error, i couldnt even uninstall it because everything was showing errors, but thanks for the help i done a roll back instead

[Elite_360_]

i put the file in, installed the xml, it was only when i activated the plugin, it completely crashed my site, and every page even the admin panel showed a database error, i couldnt even uninstall it because everything was showing errors, but thanks for the help i done a roll back instead

what vb version do you have? whats the database error? did you do step number 3? i tested it from 4.0.2 to 4.2.0 i did not get any errors. would like to know the error so i could fix it.

[leejohn02]

i didnt actually get an error exactly, im running version 4.2.0, it just made the database corrupt, so i couldnt access the site or the panel to take it off

[Elite_360_]

i didnt actually get an error exactly, im running version 4.2.0, it just made the database corrupt, so i couldnt access the site or the panel to take it off
i running it on 4.2.0pl3 i dont have a problem with the mod

[Elite_360_]

Updated to 1.0.4 - Nov 15 2012

-Change XML ID from e360_clantag to e360_prefix
-Change Name of Mod from Clan Tags with Username Html MarkUp to e360 - Username Prefix with Html MarkUp
-New: Display The User Display Usergroup color if they are in multiple Usergroups Works on newest member too as of 1.0.4
-New: Newest Member Markup without adding a new Query as of 1.0.4
-New: Optimize The Code
-Fix bug when someone reply to a post it changes the postusername to the lastposter markup color on thread display
-Fix ToolTip Bug on the Started by on threadbit

[leejohn02]

This is the error i get

Database error in vBulletin 4.2.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.firstpostid, post.pagetext AS thumb,
thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible

, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires
, thread.bop_global , disgroup.opentag AS disopen, disgroup.closetag AS disclose, prigroup.opentag AS priopen, prigroup.closetag AS priclose,
disuser.displaygroupid AS display, priuser.displaygroupid AS display, user.displaygroupid, thread.postusername AS e360postusername,
disfield.fieldfield28, prifield.fieldfield28
FROM thread AS thread
LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)

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 threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 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 disuser ON ( disuser.userid = thread.postuserid ) LEFT JOIN userfield AS disfield ON ( disfield.userid = disuser.userid ) LEFT JOIN usergroup AS disgroup ON ( disgroup.usergroupid = disuser.displaygroupid ) LEFT JOIN user AS priuser ON ( priuser.userid = thread.postuserid ) LEFT JOIN userfield AS prifield ON ( prifield.userid = priuser.userid ) LEFT JOIN usergroup AS prigroup ON ( prigroup.usergroupid = priuser.usergroupid )
WHERE thread.threadid IN (0,6014,6008,6001,5875,5867,5591,5371,5324,4857,45 09,4464,3890,2996,3492,3446,3454,3448,3443,3432,33 97)
ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error : Unknown column 'disfield.fieldfield28' in 'field list'
Error Number : 1054
Request Date : Thursday, November 28th 2013 @ 10:15:23 AM
Error Date : Thursday, November 28th 2013 @ 10:15:23 AM
Script : http://www.pureglitching.com/forumdisplay.php?40-Announcements
Referrer : http://www.pureglitching.com/forum.php
IP Address : 82.12.176.199
Username : Glitch_Guru
Classname : vB_Database
MySQL Version : 5.5.32-cll

[Elite_360_]

MySQL Error : Unknown column 'disfield.fieldfield28' in 'field list'
Error Number : 1054
Request Date : Thursday, November 28th 2013 @ 10:15:23 AM
Error Date : Thursday, November 28th 2013 @ 10:15:23 AM
Script : http://www.pureglitching.com/forumdisplay.php?40-Announcements
Referrer : http://www.pureglitching.com/forum.php
IP Address : 82.12.176.199
Username : Glitch_Guru
Classname : vB_Database
MySQL Version : 5.5.32-cll

For "Field ID" just add the number in AdminCP > Settings > Options > e360 - Usernames Prefix Options > Field ID.

it looks like you add "field28" to that option just add "28" to the option

[leejohn02]

thanks finally got it working, only one quick question, is there anyway to add it to VSA chatbox because it isnt showing in there, it works great everywhere else

[Elite_360_]

thanks finally got it working, only one quick question, is there anyway to add it to VSA chatbox because it isnt showing in there, it works great everywhere else

You would have to edit the code in that mod and i would not know where to start since i don't use that mod.

[Elite_360_]

Can a Moderator or Admin put this in graveyard