vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - Username HTML Markup 4.2.x (https://vborg.vbsupport.ru/showthread.php?t=229146)

DUI_ 12-23-2009 04:47 PM

Error on 4.0, had to disable

Dr.osamA 12-23-2009 08:18 PM

Quote:

Error on 4.0, had to disable
plzzzz wher is the upgrade ??

Waiting
________
KOHLS GIFT CARD

arauf 12-23-2009 11:03 PM

Update required Hasan !

Trek 12-24-2009 12:56 AM

If you are getting results that look like this:

Code:

by
Admin is offline now.">Admin

Then you need to edit each usergroup you have and replace any double quotes(") with single quotes (') in the HTML colors you've setup. I had this same problem a while back and this fixed it fine and I'm running 4.0 gold.

Alecsmith 12-24-2009 08:44 AM

Working On VB 4 Gold :)

Cadellin 12-24-2009 01:22 PM

Quote:

Originally Posted by Trek (Post 1936933)
If you are getting results that look like this:

Code:

by
Admin is offline now.">Admin

Then you need to edit each usergroup you have and replace any double quotes(") with single quotes (') in the HTML colors you've setup. I had this same problem a while back and this fixed it fine and I'm running 4.0 gold.

Thanks just what I needed :)

Perhaps this should be added to the toppost?

ASPnix 12-24-2009 02:33 PM

Awesome,

Working :) thanks!

almty1 12-24-2009 10:51 PM

Thank you! Installed

Socloves 12-26-2009 02:56 AM

Quote:

Originally Posted by sebaldus (Post 1936197)
I got this error when I use the script:

by
Admin is offline now.">Admin

This are all colour names.
All posts.
Regards from Sebaldus.

Help me :(

Universal 12-26-2009 05:18 AM

Quote:

Originally Posted by Socloves (Post 1938387)
Help me :(

Change the custom code in Usergroup Manager (Username HTML Markup) in your admincp to:

Add in the first box:
Code:

<span style='font-weight: bold; font-style: italic; color: red;'>
(You can also use #ff0000 instead of red if you want a particular color. Just change or remove what you do not need.

Add in the second box:
Code:

</span>

Vackrick 12-26-2009 09:02 AM

i dun think this work for Gold....

Universal 12-26-2009 09:13 AM

Quote:

Originally Posted by Vackrick (Post 1938487)
i dun think this work for Gold....

Works for me on 4.0.0

Pumpo 12-26-2009 11:46 AM

Quote:

Originally Posted by Vackrick (Post 1938487)
i dun think this work for Gold....

working on 4.0.0 patch 1

Trek 12-26-2009 06:49 PM

Quote:

Originally Posted by Socloves (Post 1938387)
Help me :(

As mentioned several times in this thread already, use a single quote ' instead of a double quote " in your color definitions.

Dr.osamA 12-26-2009 07:36 PM

plzz hasann

i need help in the mod


Quote:

MySQL Error : Not unique table/alias: 'user'
Error Number : 1066
Request Date : Monday, December 26st 2009 @ 07:01:06 PM
Error Date : Monday, December 26st 2009 @ 07:01:06 PM
Script : http://www.xxxxx.com/testforum/forum...-Announcements
Referrer : http://www.xxxxx.com/testforum/forum.php
IP Address : xx.xxx.xxx.xx
Username : User
Classname : vB_Database
MySQL Version : 5.1.39-community
i have VB 4.0.0 LP1
________
FRIDAY NIGHT LIGHTS FORUMS

valendono 12-27-2009 07:50 PM

got problem as well with 4.0 gold..

PHP Code:

 MySQL Error   Not unique table/alias'user' 


Dr.osamA 12-27-2009 07:54 PM

Quote:

Originally Posted by Trek (Post 1929218)
Another report for DB errors on RC2, here's the error incase you need it:

Code:

Invalid SQL:

                SELECT forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend
                    , forumread.readtime AS forumread
                FROM dhv_forum AS forum
                LEFT JOIN dhv_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 1)
                LEFT JOIN dhv_user AS user ON (user.userid = forum.lastposterid)
                LEFT JOIN dhv_userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
                LEFT JOIN dhv_user AS user ON (forum.lastposterid = user.userid) LEFT JOIN dhv_usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

MySQL Error  : Not unique table/alias: 'user'
Error Number  : 1066
Request Date  : Saturday, December 12th 2009 @ 03:40:07 AM
Error Date    : Saturday, December 12th 2009 @ 03:40:07 AM


Quote:

Originally Posted by Dr.osamA (Post 1938875)
plzz hasann

i need help in the mod




i have VB 4.0.0 LP1

conflict with tis mod

Dy-Display Thread Start Time v1.0

:(
________
Lamborghini Bravo

Socloves 12-28-2009 12:55 PM

Quote:

Originally Posted by Universal (Post 1938436)
Change the custom code in Usergroup Manager (Username HTML Markup) in your admincp to:

Add in the first box:
Code:

<span style='font-weight: bold; font-style: italic; color: red;'>
(You can also use #ff0000 instead of red if you want a particular color. Just change or remove what you do not need.

Add in the second box:
Code:

</span>

thanks !

Installed, work vbb 4.0 :D

carleboy 12-30-2009 05:57 PM

i cant get this to work i get the same as below. i have checked the span is correct but mod just caused DB error.

Quote:

Originally Posted by valendono (Post 1939700)
got problem as well with 4.0 gold..

PHP Code:

 MySQL Error   Not unique table/alias'user' 



Switch3130 12-30-2009 06:49 PM

Is this mod ever going to be like previous ones where certain usergroups were able to pick their own color, font, etc?

gil 12-30-2009 07:37 PM

Thanks

softvnzla 01-02-2010 03:13 PM

help
MySQL Error : Not unique table/alias: 'user'

:(

evildon 01-03-2010 05:27 AM

Getting database error when installed this mod.

Help needed..

arauf 01-03-2010 06:16 AM

like i see some sayin working fine with vb 4 gold some sayin error, seems like some other installed plugin is makin error or its not compatible with some other plugins.

i have alot other plugins installed, if i install this product its giving me Database error

LuckyNeo 01-03-2010 06:42 AM

Good work! really! Thank you very much! You smart and gifted pal! I known so many mods and huck's wich you made!

t2cervens 01-06-2010 04:53 PM

Quote:

Originally Posted by softvnzla (Post 1945023)
help
MySQL Error : Not unique table/alias: 'user'

:(


same here...

Magnumutz 01-09-2010 12:25 PM

I too am getting this error:
Quote:

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend

FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN user AS user ON (forum.lastposterid = user.userid) LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

MySQL Error : Not unique table/alias: 'user'
Error Number : 1066
Request Date : Saturday, January 9th 2010 @ 04:23:24 PM
Error Date : Saturday, January 9th 2010 @ 04:23:25 PM
Script : http://127.0.0.1/forum/forum.php
Referrer : http://127.0.0.1/forum/admincp/index.php?do=head
IP Address : 127.0.0.1
Username : Magnumutz
Classname : vB_Database
MySQL Version : 5.1.37
The modification says that it's supported, but i see no support given in the last couple of weeks.
Is it really supported or not?

Juggernaut 01-09-2010 05:01 PM

Thank you, works great with Gold Publishing Suite :D

heugabel 01-10-2010 07:27 PM

1 Attachment(s)
this works without sql error.

the query has 2 same joins.

Quote:

SELECT forum.forumid, forum.lastpost, CONCAT(usergroup.opentag, forum.lastposter, usergroup.closetag) AS lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend

FROM forum AS forum

LEFT JOIN user AS user ON (user.userid = forum.lastposterid)

LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)
LEFT JOIN user AS user ON (forum.lastposterid = user.userid) LEFT JOIN usergroup AS usergroup ON (user.usergroupid = usergroup.usergroupid);

i-israeli.co.il 01-14-2010 12:48 PM

what with update? thanks man

KURTZ 01-14-2010 01:01 PM

1 Attachment(s)
too many errors with this hack ... i've tried to install all the versions but i've always an error ... with the latest release i've the same mysql error than the others ... with the heugabel .xml i've got this ...

Yasuno 01-14-2010 03:01 PM

Can someone update this? =[

aaronrand 01-15-2010 01:43 AM

https://vborg.vbsupport.ru/external/2010/01/34.png

not sure where i went wrong?
Code:

box1<font color="red"> ADR  box2</font>
EDIT nevermind, i got it. single quote...maybe that should be mentioned in the notes or download...

Droptop 01-15-2010 01:58 AM

^ Where exactly do you need to change this code?

Trek 01-15-2010 02:32 AM

Quote:

Originally Posted by Droptop (Post 1956163)
^ Where exactly do you need to change this code?

Edit each usergroup that is having the problem. It's the field called Username HTML Markup.

Droptop 01-15-2010 05:44 AM

Quote:

Originally Posted by Trek (Post 1956169)
Edit each usergroup that is having the problem. It's the field called Username HTML Markup.

Thanks Trek :cool:

KURTZ 01-15-2010 05:49 AM

Quote:

Originally Posted by Trek (Post 1956169)
Edit each usergroup that is having the problem. It's the field called Username HTML Markup.

in the UG manager?

Droptop 01-15-2010 05:54 AM

Quote:

Originally Posted by KURTZ (Post 1956244)
in the UG manager?

Yup, but it doe not fix the problem with heugabel's version of this mod.

Switch3130 01-16-2010 05:02 AM

However the HTML tags are messed up:

https://vborg.vbsupport.ru/

Edit: I guess it's not just the rep messages, I get the same thing when I mouse over anyone's username:

https://vborg.vbsupport.ru/

argothiusz 01-16-2010 09:50 PM

Does this work with 4.0.1?


All times are GMT. The time now is 04:51 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.01982 seconds
  • Memory Usage 1,838KB
  • 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
  • (8)bbcode_code_printable
  • (2)bbcode_php_printable
  • (19)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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