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

Reply
 
Thread Tools
vB News Ticker Details »»
vB News Ticker
Version: 1.03, by davidw davidw is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Version: 3.5.5 Rating:
Released: 08-04-2006 Last Update: 07-25-2007 Installs: 52
Uses Plugins Template Edits
 
No support by the author.

What does this do? It allows you to take your news from your news forums (up to 9 news forums) and display them. You have a choice on how many you can pull from each forum, how fast you want the ticker to scroll, the length of the title of each news item, etc.

This works on 3.5.4, 3.5.5, and should work on pretty much any of the 3.5.x. I've not tested this for 3.6, but I have been told that it does work for 3.6.

Install/Upgrade Instructions

Step 1: Go to your admin Control Panel => Styles & Templates => Style Manager
Find your Master/Parent style or the style you wish to add this to and drop down the All Style Options menu dropdown and choose Edit Templates
Click Go if it does not redirect you
Open up your Forum Home Templates subdirectory and choose your FORUMHOME template

Find
PHP Code:
<!-- main --> 
Add above
PHP Code:
$vbnews_ticker 
Click Save & Reload

Step 2: Go to your admin Control Panel => Plugin System => Manage Products => [Add/Import Product];
Click Browse and find product-christianb_vbnews_ticker.xml
Remove contents of second line ./includes/xml/product.xml
Click the button next to Yes in Allow Overwrite
Click Import

Step 3: Go to your admin Control Panel => vBulletin Options => vBulletin Options => vB News Ticker => [Edit Settings]
Alter Settings as appropriate
*** IMPORTANT *** Make sure that if you do not enter an item in the forumIDs after the first one, the rest must be set to 0
- if it is not set to 0 or a forumid number, it will result in a database error.
Click Save

I've included the readme and the .xml Product/Plugin in the zip file.

If there are features you'd like to see for a future release, please let me know.

Frequently Asked Questions

What is the forumid?
The forumid is the id of the forum you have created. Each forum has its own unique number assigned to it. When you click on a forum link you can see a number that is assigned to it. This will show up in the URL of the page you are browsing. Another way of seeing the forumid is to go to your admin control panel => Forums & Moderators => Forum Manager => Click on [Expand All] and then move your mouse over (hover) any of the forums you've created. Your status bar (bottom of screen) should display your forumid (number at the end of the link/url).

How do I add the news ticker to the IBProArcade or Photoplog?
Thanks to Mark.B for his add - https://vborg.vbsupport.ru/showpost....&postcount=144

Changes

1.0.4 Added security

1.0.3 Changed the hook location from forumhome_complete to global_start giving admin ability to put the news ticker most places rather than in forum home.
Updated the query to remove a JOIN that may have been causing delays.

1.0.2
Added instructions to comment out unneccessary query pulls in the array to reduce wait times.
Optimized the query by removing non-essential SELECTs.
Added option for user to separate news items in admincp.
Fixed IE whitespace issue for ticker height as seen here:
https://vborg.vbsupport.ru/showpost....3&postcount=28

1.0.1 Fixed a width issue as seen here:
https://vborg.vbsupport.ru/showpost....3&postcount=12


Known Bugs/Issues:

From my testing on the new updates, when I (or a user on my site) clicks on any of the links that has the news ticker, it works fine, but when I or a user hits the refresh button, it can hang. I'm unsure why this is happening.

Temporary demo location:
http://www.christianboards.org/forum.php

Show Your Support

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

Comments
  #62  
Old 08-08-2006, 06:14 PM
Eagle Creek's Avatar
Eagle Creek Eagle Creek is offline
 
Join Date: Jan 2004
Location: Netherlands
Posts: 742
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That's cool .
All of my news items are underlined. At your screenshot they aren't.

What's 'wrong'?
Reply With Quote
  #63  
Old 08-08-2006, 07:03 PM
davidw's Avatar
davidw davidw is offline
 
Join Date: Jul 2005
Location: Arkansas
Posts: 2,815
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That happened to me one time because I was playing around with my FORUMHOME template and accidentally removed $spacer_open (right above where the $vbnews_ticker goes). Check there to see if it is located there. If not, you may want to put it in there.
Reply With Quote
  #64  
Old 08-08-2006, 09:43 PM
Eagle Creek's Avatar
Eagle Creek Eagle Creek is offline
 
Join Date: Jan 2004
Location: Netherlands
Posts: 742
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ahh.. My members don't like it.. .

But I have more forums. I will support this hack till the end! .
Reply With Quote
  #65  
Old 08-09-2006, 05:43 PM
Buraq's Avatar
Buraq Buraq is offline
 
Join Date: Nov 2004
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Version 1.0.2 makes my forumhome load even slower (yes I did the edits to the php).

I'm not sure how feasible this is, but why not just include the latest thread titles via RSS instead of queries into the db. I know we implemented something like this on our main website, where we get the latest threads from a specific forum in vBulletin. I have to ask my co-admin how he did it.

Until then, I'm gonna have to disable this plugin. 14+ seconds is just too much, and sometimes the page doesn't load at all until you refresh again.
Reply With Quote
  #66  
Old 08-09-2006, 07:39 PM
davidw's Avatar
davidw davidw is offline
 
Join Date: Jul 2005
Location: Arkansas
Posts: 2,815
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

How many forums were you pulling these from? Also what other plugins were you running with this (in forumhome_complete)? I found this mod doesn't play well with vbshout, for example.
Reply With Quote
  #67  
Old 08-09-2006, 08:06 PM
Buraq's Avatar
Buraq Buraq is offline
 
Join Date: Nov 2004
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by christianb
How many forums were you pulling these from? Also what other plugins were you running with this (in forumhome_complete)? I found this mod doesn't play well with vbshout, for example.
I'm pulling threads from 2 forums, and the only other plugin I'm using is a banner rotator plugin I wrote. The banner plugin does not perform any complicated db queries or anything of the sort. It mainly just pulls a couple of variables stored in $vbulletin->options[] via an adminCP back end.
Reply With Quote
  #68  
Old 08-09-2006, 08:20 PM
davidw's Avatar
davidw davidw is offline
 
Join Date: Jul 2005
Location: Arkansas
Posts: 2,815
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

It should be ok then - I don't know why the delay. I'd be interested in the RSS transfer as that might speed things up - but I'm not sure how to do that. Of course, I've always had trouble with using marquees. I will be looking into speeding up the query though.
Reply With Quote
  #69  
Old 08-11-2006, 03:34 PM
Eagle Creek's Avatar
Eagle Creek Eagle Creek is offline
 
Join Date: Jan 2004
Location: Netherlands
Posts: 742
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You fixed it? (cause I don't see your reply anymore)
Reply With Quote
  #70  
Old 08-11-2006, 03:46 PM
davidw's Avatar
davidw davidw is offline
 
Join Date: Jul 2005
Location: Arkansas
Posts: 2,815
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I thought I did. lol
I fixed one thing, but removing that line cause it to pull more forums that were not chosen lol. The only reason why it was in there was for a preview - but for some reason it broke something else.
Reply With Quote
  #71  
Old 08-11-2006, 03:58 PM
davidw's Avatar
davidw davidw is offline
 
Join Date: Jul 2005
Location: Arkansas
Posts: 2,815
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ok, silly me, accidentally removed the WHERE statement because I thoughtlessly left it on the same line as the one I needed removed.

anyways, here's the potential fix (again)...

@Buraq (and anyone else who may be having a slow response time) - try editing the plugin and changing the query...

Find this:
PHP Code:
            $gettickers $db->query_read("
                SELECT t.threadid, t.title, t.forumid, t.open, t.dateline, t.visible, t.firstpostid 
                FROM " 
TABLE_PREFIX "forum f 
                INNER JOIN " 
TABLE_PREFIX "thread t ON t.forumid = f.forumid AND t.visible = 1 AND " $desclim " > ( SELECT count(" $desclim ") FROM " TABLE_PREFIX "thread WHERE forumid = f.forumid AND visible = 1 AND dateline > t.dateline )
                LEFT OUTER JOIN " 
TABLE_PREFIX "post AS post ON post.postid = t.firstpostid WHERE t.forumid IN (" implode(','$tickarray) . ") 
                ORDER BY field(f.forumid," 
implode(','$tickarray) . "), t.dateline desc
            "
); 
remove this code:
PHP Code:
LEFT OUTER JOIN " . TABLE_PREFIX . "post AS post ON post.postid t.firstpostid 
which changes it to this:
PHP Code:
            $gettickers $db->query_read("
                SELECT t.threadid, t.title, t.forumid, t.open, t.dateline, t.visible, t.firstpostid 
                FROM " 
TABLE_PREFIX "forum f 
                INNER JOIN " 
TABLE_PREFIX "thread t ON t.forumid = f.forumid AND t.visible = 1 AND " $desclim " > ( SELECT count(" $desclim ") FROM " TABLE_PREFIX "thread WHERE forumid = f.forumid AND visible = 1 AND dateline > t.dateline )
                WHERE t.forumid IN (" 
implode(','$tickarray) . ")
                ORDER BY field(f.forumid," 
implode(','$tickarray) . "), t.dateline desc
            "
); 
That code served no purpose and may actually be causing the problem. It is only used for allowing a preview of the post/thread and it is something I forgot to take out.
This will be fixed in the next version.
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 10:43 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05001 seconds
  • Memory Usage 2,322KB
  • Queries Executed 25 (?)
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
  • (5)bbcode_php
  • (1)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
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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_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