Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > vBulletin 3.7 > vBulletin 3.7 Add-ons

Reply
 
Thread Tools
Usergroups Usernames in Forumdisplay Highlighting Details »»
Usergroups Usernames in Forumdisplay Highlighting
Version: 2.0, by Hasann Hasann is offline
Developer Last Online: Jun 2021 Show Printable Version Email this Page

Category: Mini Mods - Version: 3.7.x Rating:
Released: 02-27-2008 Last Update: 12-16-2008 Installs: 169
Uses Plugins
Code Changes Additional Files Translations  
No support by the author.

Username HTML Markup in FORUMHOME + FORUMDISPLAY + SUBFORUMS by Hasann

This Product brought to you by
www.vbulletin-turkey.com

Description:

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


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

Tested on:
  • vBulletin 3.7.x
  • vBulletin 3.8.x

Demo: www.vbulletin-turkey.com/forum

Supporters / CoAuthors

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #42  
Old 11-24-2008, 12:59 AM
crackers crackers is offline
 
Join Date: Oct 2008
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Very bad optimization, this mod generates big load! This mod should go to trash...
Reply With Quote
  #43  
Old 11-24-2008, 09:41 AM
nakedzero nakedzero is offline
 
Join Date: Nov 2008
Posts: 9
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nice hack. Btw, may i have the theme of your forum?
Reply With Quote
  #44  
Old 11-24-2008, 02:43 PM
2L8 2L8 is offline
 
Join Date: Nov 2008
Posts: 41
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

it works fine for 3.7.4 thx
Reply With Quote
  #45  
Old 11-24-2008, 10:34 PM
Hasann's Avatar
Hasann Hasann is offline
 
Join Date: Aug 2005
Location: Germany
Posts: 897
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by crackers View Post
Very bad optimization, this mod generates big load! This mod should go to trash...
who are you?

if not working please uninstall it
Reply With Quote
  #46  
Old 12-03-2008, 12:54 PM
NikosN NikosN is offline
 
Join Date: May 2008
Posts: 37
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Thank you!
Reply With Quote
  #47  
Old 12-03-2008, 12:55 PM
crackers crackers is offline
 
Join Date: Oct 2008
Posts: 18
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

People should know that installing this mod can cause high load and lay off from shared hosting... You ignored my pm so how can I have enough respect for you...
Reply With Quote
  #48  
Old 12-23-2008, 11:14 AM
arauf arauf is offline
 
Join Date: Aug 2005
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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



Hassann
Reply With Quote
  #49  
Old 12-23-2008, 11:17 AM
arauf arauf is offline
 
Join Date: Aug 2005
Posts: 45
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

when i click on my forums Database errors shows up :s
i have removed all files and uninstalled the ( product-username_html_markup.xml )

but No Gain same error

can you please tell whats wrong

something's wrong with ( functions_forumlist.php )
Reply With Quote
  #50  
Old 12-23-2008, 06:22 PM
digicom's Avatar
digicom digicom is offline
 
Join Date: Apr 2006
Location: England Uk
Posts: 223
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Working on 3.7.4 with no problems,apprciated:up:
Reply With Quote
  #51  
Old 12-23-2008, 07:17 PM
Hasann's Avatar
Hasann Hasann is offline
 
Join Date: Aug 2005
Location: Germany
Posts: 897
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by arauf View Post
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



Hassann
did you installed this hack ?
https://vborg.vbsupport.ru/showthread.php?t=199568
Reply With Quote
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:04 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.03631 seconds
  • Memory Usage 2,308KB
  • Queries Executed 28 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (2)bbcode_php
  • (2)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete