Add-On Releases - Username Prefix with Html MarkUp (Clan Tags) 4.x.x

This mod is now combine with this mod e360 - Username Html MarkUp 4.2.x

Can a Moderator or Admin put this in graveyard

[SpikedRocker]

Originally Posted by Elite_360_

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_]

Originally Posted by leejohn02

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_]

Originally Posted by 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

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_]

Originally Posted by 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

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/forumdi...-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_]

Originally Posted by leejohn02

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/forumdi...-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