vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Add-On Releases - Username Prefix with Html MarkUp (Clan Tags) 4.x.x (https://vborg.vbsupport.ru/showthread.php?t=290374)

SpikedRocker 11-10-2012 03:20 PM

Quote:

Originally Posted by Elite_360_ (Post 2379827)
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
Code:

<span style='color: (COLOR YOU WANT HERE);'>(YOUR TAG HERE)
2nd column
Code:

(OR YOU TAG HERE)</span>

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

leejohn02 11-11-2012 10:33 AM

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

Elite_360_ 11-11-2012 03:04 PM

Quote:

Originally Posted by leejohn02 (Post 2380224)
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 11-11-2012 05:47 PM

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_ 11-11-2012 06:21 PM

Quote:

Originally Posted by leejohn02 (Post 2380321)
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 11-11-2012 08:06 PM

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_ 11-11-2012 08:40 PM

Quote:

Originally Posted by leejohn02 (Post 2380358)
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_ 11-15-2012 12:33 PM

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 11-28-2013 11:26 AM

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_ 11-28-2013 01:27 PM

Quote:

Originally Posted by leejohn02 (Post 2464325)

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


All times are GMT. The time now is 03:19 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01137 seconds
  • Memory Usage 1,753KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete