vB News Ticker

[davidw]

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 <!-- main --> Add above $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.php?p=1407098&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.php?p=1046633&postcount=28

1.0.1 Fixed a width issue as seen here:
https://vborg.vbsupport.ru/showpost.php?p=1045653&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

[mholtum]

w00t #1

-Installed

[Snake]

Second one to install this. Thanks! :D

[PitPunks]

#1 complainer :P

Do you have any non christian news ticker? :P

[davidw]

You can pull the news from any forums on your website you want to. The forums you put in the forumid can be anti-Christian if that is how you feel.

I don't have a test website so I do all my testing on a live website - my own. :) (Otherwise my links would reflect a test website for the demo and for the screenshots) - hope that helps.

[Oddjob]

This work on 3.6?

[rmxs]

thanks :) installed

[TNAImpact]

Great stuff.

How can I edit it so that I can put for example, "Latest Threads:" before the ticker? Oh and add - between each thread title to make it a little cleaner.

I'll use it once or if the above is do able. :) Cheers!

[davidw]

on the Latest Threads, all you have to do is go to your templates in the admincp, find the vbnews_ticker template and add Latest threads: before $ticker_titles like this
<div align="center" style="padding:7px"><marquee width="{$vboptions[tickwidth]}"% height="{$vboptions[tickheight]}" behavior=scroll scrollamount="{$vboptions[tickspeed]}" onmouseover='this.stop()' onmouseout='this.start()'>Latest threads: $ticker_titles</marquee></div>or if you want the Latest threads: bolded, add the strong tag <strong>Latest Threads: </strong> such as this:
<div align="center" style="padding:7px"><marquee width="{$vboptions[tickwidth]}"% height="{$vboptions[tickheight]}" behavior=scroll scrollamount="{$vboptions[tickspeed]}" onmouseover='this.stop()' onmouseout='this.start()'><strong>Latest Threads: </strong>$ticker_titles</marquee></div>

for the second part, in the edit the plugin in the plugin manager, find vB News Ticker under forumhome_complete.
Look for &nbsp; &nbsp; and put a - (hyphen) in between the two &nbsp; symbols.

[davidw]

@oddjob - I've not tried it, but I don't see why it shouldn't work on 3.6 (I've not installed 3.6 as of yet). However, once I get a development board up and running, I'll let everyone know (unless someone has 3.6 and it works fine for them).

[C_P]

Have it on 3.6 at www.cpfools.com/forum and works perfect. Thank you for the great addition!

[Buraq]

hey there, cool mod (installed)

Is there a way to make the stream continuous? For some reason on my forum it goes through the forums listed, waits till the last of the text clears, then starts again.

Also, there's a little browser-compliance issue:
marquee width="{$vboptions[tickwidth]}"%
makes the width of the marquee 100 pixels (if it's set to 100) in IE. Easy fix:
marquee width="{$vboptions[tickwidth]}%"

move the "%" inside the the quote, gives you the proper width in IE and firefox.

[TNAImpact]

on the Latest Threads, all you have to do is go to your templates in the admincp, find the vbnews_ticker template and add Latest threads: before $ticker_titles like this
<div align="center" style="padding:7px"><marquee width="{$vboptions[tickwidth]}"% height="{$vboptions[tickheight]}" behavior=scroll scrollamount="{$vboptions[tickspeed]}" onmouseover='this.stop()' onmouseout='this.start()'>Latest threads: $ticker_titles</marquee></div>or if you want the Latest threads: bolded, add the strong tag <strong>Latest Threads: </strong> such as this:
<div align="center" style="padding:7px"><marquee width="{$vboptions[tickwidth]}"% height="{$vboptions[tickheight]}" behavior=scroll scrollamount="{$vboptions[tickspeed]}" onmouseover='this.stop()' onmouseout='this.start()'><strong>Latest Threads: </strong>$ticker_titles</marquee></div>

for the second part, in the edit the plugin in the plugin manager, find vB News Ticker under forumhome_complete.
Look for &nbsp; &nbsp; and put a - (hyphen) in between the two &nbsp; symbols.


Perfect. :) Quality mod.

Installed.

[Foxsake]

Installed this and works fine - nice i must say;)

However i dont understand the forum id bit :confused: how do you know the number? and how to you get it to pull the data and display it?

the only way i can see to adjust the ticker is manually changing the text in the template - is this how it works?
Sorry im a bit new still to all this

[Foxsake]

ah ha - sorry forget the last message i've sussed it - Brilliant :)

[davidw]

@Burgaq - I'm looking into making it stream continuously - I've wondered that myself. Thanks for the tip on the ". My original code didn't work when I used the " that way, but didn't think to test it after changing the code to $vboptions.

@Foxsake - 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).

[davidw]

ah ha - sorry forget the last message i've sussed it - Brilliant :)Good job :)

[rmxs]

Sugestion: color chenge
seperators (add one option if user add for exaple - or / or \ seperate the topics if not add somethis appeard without seperators)
make addon that if user wont pass from the screen all the attachments in X forum with x size.. :) (with this you can make new hack) LOL

[davidw]

Color change as in background color or border color?

Also - the separators, currently you can manually edit the xml, such as this:
in the edit the plugin in the plugin manager, find vB News Ticker under forumhome_complete.
Look for &nbsp; &nbsp; and put a - (hyphen) in between the two &nbsp; symbols. or in your case a / or \ - however, I can look at adding this to the options so that a user can control this from the admincp rather than having to edit it manually :). I'm not sure I follow the last part in regards to the attachments.

[davidw]

Ok, here's an updated XML file with the admincp control to change your spacing between news items.

[rmxs]

LOL you are very fast i know this thing with edit byt others user maube not :)
i have already change the &nbsp; &nbsp;

now about the color i mean the letter...no boarder on option in admin control panel that user can set 2 different collors EXAPLE 1-3-5-7 topics BLUE 2-4-6-8 topics RED :)

[davidw]

Honestly, I am not sure if the even/odd color is probable. The information is gathered in a single query and then run through a while loop. The while loop is then run each time for each instance of what is pulled out of the query. This is done sequencially.

If it is possible, I would like to know (and how) (and I could then make changes to do so).

[davidw]

I'm working on an update right now that will give users the option to choose a border, a border size, a border color, a background color, in addition to the change made earlier (admincp control on spacing). It won't be ready until tomorrow though as I've written it but haven't had time to test it.

[Harley-Heaven]

Hi Chris,

had a look at the mod/hack, looks great. Can you give a newbie a little piece of advice please??

Where do I find the forum numbers from if I am using a Hack/Mod called "About Today" where I can select a number of news sources i.e. CNN, BBC, Yahoo etc.

Thanks for your assistance.

[davidw]

I'm not familiar with that hack. However, if that information is going into a forum, then you have no problems. Here is a snippit of something I posted yesterday but it should help you out, especially if About Today does insert into a forum. 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).

[davidw]

@rmxs - now that I think about it - I think it CAN be done - I just have to figure out how.

[Eagle Creek]

My homepage is slow after installing this?

Could that be caused by the ticker? (I have set 7 items) or just something else?

EDIT:
In FireFox it looks great. But when using IE I puts extra whitelines between it.

Look:
http://www.nucia.nl/forum/

[davidw]

TBH, I'm not sure why it is slow (in testing most of the time 7-8 out of 10 times it worked fine) but I think it could have something to do with the subquery. However, I don't know for sure. However, I am caching templates, so that should speed things up on the ticker.

EDIT: in the control panel, go to vbulletin options => vB News Ticker => Ticker Height => change the number from 50 to 10. That should fix it.

[Eagle Creek]

Homepage takes 8(!) seconds to load :(.
Both IE and FireFox.

When I disable the ticker it's running fine. I really like the feature but when it's slowing down my HP so much I can't have it installed.

(the height is ok now in IE)

I'm running:
PHP 4.4.2
MySQL Version 4.1.19-standard-log

[davidw]

It's probably the subquery then. I'll see what I can do to try to speed this up.

I've updated the zip file to include the latest changes.

[Eagle Creek]

I have the idea my whole forum is slowing down? Also posting a reply takes ages now.

I will de?nstall and re?nstall :).

[Eagle Creek]

Noo :(.

Take a look: http://www.nucia.nl/forum/ . Takes a long time to load.

[davidw]

The only page that should be affected is the forumhome. I see 6 seconds on regular pages and 8 seconds on the forumhome. Try disabling the plugin. I want to see what I reach your page with it disabled.

[Eagle Creek]

It's now disabled, please try again.


Enabled:
Page generated in 5.46892 seconds with 22 queries [Server Loads: 0.44 0.35 : 0.35]

Disabled:
Page generated in 0.14331 seconds with 22 queries [Server Loads: 0.42 0.36 : 0.35]

[davidw]

I see 5 seconds on the forumhome now and 1 1/2 seconds on regular pages.

[Eagle Creek]

You see the difference?

My forumhome is quicker (about <1 second) but there is a difference.

[davidw]

I'll see what I can do about making this quicker. Quicker is better.

[Eagle Creek]

Thankyou :).

I'll keep track on this thread.

[davidw]

I got mine up to 1.699seconds (in firefox) - try this - I removed a bunch of stuff that needn't be used (things I had from a query that I'm using for a hack I'm going to release later this week).

Try this one out - if this works, I'll update the hack today - which it possibly could. I disabled my vbshout and installed this and shaved 70% off my delay.

[Buraq]

Yeah I'm experiencing slower loading times as well. Normally my forum home takes fractions of a second to load, with this hack it sometimes takes upwards of 10 (sometimes 12) seconds.

I'll hold off on trying the new xml file till you release the final version, since I made some modifications to the way it displays and don't wanna have to do them again and again.

[davidw]

ok, try this then in the plugin, find this:

$gettickers = $db->query_read("
SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle
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
");
and replace with this
$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
");

and then find this
$ticker['title'] = preg_replace('/\<[a-zA-Z0-9 \&lt;\<\,\&gt;\>\.\?\/\:\;\~\"\`\!\@\#\$\%\^\&\*\(\)\_\-\+\=]*\>/', '', $ticker['title']);
$ticker['title'] = fetch_trimmed_title(fetch_censored_text(unhtmlspec ialchars($ticker['title'])), $titlelim);
$ticker['date'] = vbdate($vbulletin->options['dateformat'], $ticker['dateline']);
$ticker['time'] = vbdate($vbulletin->options['timeformat'], $ticker['dateline']);
$ticker['replycount'] = vb_number_format($ticker['replycount']);
$ticker['views'] = vb_number_format($ticker['views']); and replace with this:
$ticker['title'] = preg_replace('/\<[a-zA-Z0-9 \&lt;\<\,\&gt;\>\.\?\/\:\;\~\"\`\!\@\#\$\%\^\&\*\(\)\_\-\+\=]*\>/', '', $ticker['title']);
$ticker['title'] = fetch_trimmed_title(fetch_censored_text(unhtmlspec ialchars($ticker['title'])), $titlelim);
$ticker_titles .= '<a href="showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank">'. $ticker['title'] .'</a> '. $ticksep.'';

[VaaKo]

Thank you for taking my rewuest into consideration.
However, I'm getting this error when I installed it.

Database error in vBulletin 3.5.4:

Invalid SQL:

SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle
FROM forum f
INNER JOIN thread t ON t.forumid = f.forumid AND t.visible = 1 AND 10 > ( SELECT count(10) FROM thread WHERE forumid = f.forumid AND visible = 1 AND dateline > t.dateline )
LEFT OUTER JOIN post AS post ON post.postid = t.firstpostid WHERE t.forumid IN (0,0,0,0,0,0,0,0,0)
ORDER BY field(f.forumid,0,0,0,0,0,0,0,0,0), t.dateline desc;

MySQL Error : You have an error in your SQL syntax near 'SELECT count(10) FROM thread WHERE forumid = f.forumid AND visible = 1 AND datel' at line 4
Error Number : 1064
Date : Tuesday, August 8th 2006 @ 12:07:32 AM
Script : http://www.onelebanon.com/forum/index.php
Referrer : http://www.onelebanon.com/forum/index.php
IP Address : 82.198.0.27
Username : Golani
Classname : vb_database

:(

[davidw]

What do you have for your first forumid? it looks like 0. You need something for your forumid. Also, you may want to edit your code to remove your IP address and username.

Also, what version of SQL are using? This will only run on 4.1 or higher.

[bhxtyrant]

Hey christianb,i was wondering does this version only work with 3.5.5 or will it work ok with 3.5.4 as well?I tried installing it but i cant seem to get it working with 3.5.4 is there a version of this mod for 5.4?

[davidw]

Yes, it does work with 3.5.4 (that's what I'm running). What kind of problem are you seeing?

[bhxtyrant]

I think it may be due to me trying to use it in the header template rather then ForumHome as my ticker area is in the header,When i add the approriate mod and import the xml i set the forum id to "2" and set height width ect but nothing shows in the area at all.

[Eagle Creek]

I got mine up to 1.699seconds (in firefox) - try this - I removed a bunch of stuff that needn't be used (things I had from a query that I'm using for a hack I'm going to release later this week).

Try this one out - if this works, I'll update the hack today - which it possibly could. I disabled my vbshout and installed this and shaved 70% off my delay.

Still slow as * :(.

ok, try this then in the plugin, find this:

$gettickers = $db->query_read("
SELECT t.threadid, t.title, t.lastpost, t.forumid, t.open, t.replycount, t.postusername, t.postuserid, t.lastposter, t.dateline, t.views, t.visible, t.firstpostid, f.title AS forumtitle
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
");
and replace with this
$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
");

and then find this
$ticker['title'] = preg_replace('/\<[a-zA-Z0-9 \&lt;\<\,\&gt;\>\.\?\/\:\;\~\"\`\!\@\#\$\%\^\&\*\(\)\_\-\+\=]*\>/', '', $ticker['title']);
$ticker['title'] = fetch_trimmed_title(fetch_censored_text(unhtmlspec ialchars($ticker['title'])), $titlelim);
$ticker['date'] = vbdate($vbulletin->options['dateformat'], $ticker['dateline']);
$ticker['time'] = vbdate($vbulletin->options['timeformat'], $ticker['dateline']);
$ticker['replycount'] = vb_number_format($ticker['replycount']);
$ticker['views'] = vb_number_format($ticker['views']); and replace with this:
$ticker['title'] = preg_replace('/\<[a-zA-Z0-9 \&lt;\<\,\&gt;\>\.\?\/\:\;\~\"\`\!\@\#\$\%\^\&\*\(\)\_\-\+\=]*\>/', '', $ticker['title']);
$ticker['title'] = fetch_trimmed_title(fetch_censored_text(unhtmlspec ialchars($ticker['title'])), $titlelim);
$ticker_titles .= '<a href="showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank">'. $ticker['title'] .'</a> '. $ticksep.'';


Do I have to try these things also?

[Eagle Creek]

EDIT:

Made the changes but not any differences..

[davidw]

@bhxtyrant - it won't work, as far as I know, in the header. It will only work in the forumhome template.

@Eagle Creek - Those are the same changes in the product I posted earlier for you. Those changes are to be made in the plugin. If you go to your Plugin System => Plugin Manager => find vB News Ticker under forumhome_complete and click on [Edit] on the right side - it will give you the option to edit the plugin.

[Eagle Creek]

I think there is something really wrong with your code.

It just take up to 20 seconds?

[bhxtyrant]

thanks christian,Is there any hope of getting this to work with the header template?I found another hack here called "Latest Threads IN Marquee" which does work in the header but it doesnt have nearly as many features as yours does such as the ability to pull news from only a single forum id.

[davidw]

@Eagle Creek, just out of curiousity, how long does it take to start the forums here: http://www.christianboards.org/forum.php

@bhyxtyrant, I can see what I can do but I'm not sure. It might possibly work but changing the plugin (in the plugin manager) from forumhome_complete to global_start and then trying the $vbnews_ticker where you want it - try that. I've not tested it, so I'm not sure if that will work or not.

[Eagle Creek]

@Eagle Creek, just out of curiousity, how long does it take to start the forums here: http://www.christianboards.org/forum.php

@bhyxtyrant, I can see what I can do but I'm not sure. It might possibly work but changing the plugin (in the plugin manager) from forumhome_complete to global_start and then trying the $vbnews_ticker where you want it - try that. I've not tested it, so I'm not sure if that will work or not.
FORUMHOME:
First time load, it kept loading and loading and after 400 (!) seconds I stopped it.
Second try: 3.156 seconds.
After a refresh of the page: 6.453

FORUMDISPLAY:
1.954 seconds

[davidw]

My average load time (for me) is about 1.7 seconds. I have done a refresh and connected as quick as 1.117. I think distance may play a part in it though.

[Eagle Creek]

I guess so.. Cause when you say my forumhome takes 6 seconds, I say you are slow :p.

But anyway: The script is slowing down my index.

Any change you will re-write the script? (I saw you already added some functions).

[davidw]

I will look at optimizing the script to make it go faster. I don't like hangups on code and will work on this moreso this week. I have 2-3 ideas I am working on. I have also thought possibly that the location (forumhome_complete) may be part of the issue there.

[davidw]

Ok, I believe I've figured out the problem :)

This works for the forumids you are not using.
(I will update the readme later today for this.)
Go to your plugin (admincp => Plugin System => Plugin Manager)
Find vB News Ticker under forumhome_complete, click [Edit]

Find (near the top)

$tickarray = array(
$vbulletin->options['fid1'],
$vbulletin->options['fid2'],
$vbulletin->options['fid3'],
$vbulletin->options['fid4'],
$vbulletin->options['fid5'],
$vbulletin->options['fid6'],
$vbulletin->options['fid7'],
$vbulletin->options['fid8'],
$vbulletin->options['fid9']
);

### EXAMPLE ###
If you are only pulling news from 2 forumids, comment out fid3 - fid9 (like below) and remove the comma after the fid2 (as shown)
Remove the comma from fid2 if you are commenting out fid3

$tickarray = array(
$vbulletin->options['fid1'],
$vbulletin->options['fid2'] // remove the comma here
//$vbulletin->options['fid3'],
//$vbulletin->options['fid4'],
//$vbulletin->options['fid5'],
//$vbulletin->options['fid6'],
//$vbulletin->options['fid7'],
//$vbulletin->options['fid8'],
//$vbulletin->options['fid9']
);

Why should this work? I thought about this - this morning. There is an array of 9 variables being passed through 1 query and a subquery REGARDLESS of whether or not it is being used. Commenting out the ones not being used - it will not be passed through the query, nor will it be passed through the subquery. I did a test on my website to try it out. My forumhome load went from 1.787s to 0.897 when I commented out those above.

For now, this is a manual fix, until I can figure out how to fix this so that it doesn't have to be edited through the plugin.

[Eagle Creek]

I'm using

$tickarray = array(
$vbulletin->options['fid1']
//$vbulletin->options['fid2'],
//$vbulletin->options['fid3'],
//$vbulletin->options['fid4'],
//$vbulletin->options['fid5'],
//$vbulletin->options['fid6'],
//$vbulletin->options['fid7'],
//$vbulletin->options['fid8'],
//$vbulletin->options['fid9']
);
now because I only use one forum to pull the news out.

Whieeeeeeeeeee! It's working!
I can still see there is a delay in loading, but it isn't big (<1 seconds).

EDIT: :( no...
When I open the page, it takes about 1.5 second. After a refresh also.
When I go to a forumdisplay, and at the top I click at the hompage link it takes about 6 seconds :(.

EDIT2: Even when I'm direct opening the homepage, is slow again. Strange.

[Eagle Creek]

Ok People,

with the help from Christian (another modification) it's working fine now!
It's slowing down a little bit, but that's normal because there's more to load. You almost don't know you have the hack installed :).

Thx again David ;).

[davidw]

now about the color i mean the letter...no boarder on option in admin control panel that user can set 2 different collors EXAPLE 1-3-5-7 topics BLUE 2-4-6-8 topics RED :)Ok, I believe I have got this figured out :)
You need to edit the plugin to make this work.

Find:
while($ticker = $db->fetch_array($gettickers)) Add above:
$color1 = "#0000FF"; //blue
$color2 = "#FF0000"; //red
$color = 1;
Find:
$ticker_titles .= '<a href="showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank">'. $ticker['title'] .'</a> '. $ticksep.''; Replace with:
$tick_color = ($color % 2) ? $color1 : $color2;
$ticker_titles .= '<a href="showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank"><font color="'. $tick_color .'">'. $ticker['title'] .'</font></a> '. $ticksep .'';
$color++;

The screenshot is what it does:

[Eagle Creek]

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

What's 'wrong'?

[davidw]

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.

[Eagle Creek]

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

But I have more forums. I will support this hack till the end! :D.

[Buraq]

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.

[davidw]

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.

[Buraq]

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.

[davidw]

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.

[Eagle Creek]

You fixed it? (cause I don't see your reply anymore)

[davidw]

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.

[davidw]

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:
$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:
LEFT OUTER JOIN " . TABLE_PREFIX . "post AS post ON post.postid = t.firstpostid

which changes it to this:
$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.

[Battle_Ring]

will this work with 3.6

[davidw]

Yes :)

[doggy1]

This appears to be a great hack and thank you for offering it. However, I had to remove it because it caused delays with members trying to post on the forum and every now and then an error message that the page could not be displayed would appear. Anyone else having this and is there a way to fix it? Thanks.

[davidw]

Which version did you use? Did you try the legacy version? Just curious.

[doggy1]

Which version did you use? Did you try the legacy version? Just curious.
I did not try the legacy version, but maybe if I learn to read I would have seen that you have addressed this already with this version. LOL!

I will this version and see what happens. Thanks for the reply!

:)

[doggy1]

for the second part, in the edit the plugin in the plugin manager, find vB News Ticker under forumhome_complete.
Look for &nbsp; &nbsp; and put a - (hyphen) in between the two &nbsp; symbols.
Product appears to now work! Thank you. Now.....

I am trying to find out how to get into forumhome_complete to add this hyphen. I am able to get to the edit section of the plugin manager but don't know how to get where I need to go for the edit.

Thanks!

[davidw]

Actually, you don't have to do that now - its in the adminCP :)
Just put something like &nbsp; - &nbsp; in the ticker separator.
Don't forget to click install :)

[doggy1]

Actually, you don't have to do that now - its in the adminCP :)
Just put something like &nbsp; - &nbsp; in the ticker separator.
Don't forget to click install :)
Worked perfectly and one click for this product! :)

I have to see if there is a way to change the colors and if you can put the feature on other pages, not just on forumhome. If so it will even be more awesome!

:D

[davidw]

The new version I changed it from forumhome_complete to global_start and I was able to use it in the header and on other pages. Just play around with that.

What did you have in mind on the colors?

[doggy1]

The new version I changed it from forumhome_complete to global_start and I was able to use it in the header and on other pages. Just play around with that.

What did you have in mind on the colors?
I will try to add it to the other pages.

As for the colors, it will probably be easier just to show you the hack on the forum. We do have several styles but it blends in too much with the surroundings. I'm still trying to decide on colors but take a look if you get the chance. Plus, other members here can see how well your hack is working! :)

Click here (http://www.corvettevalley.com/vb3index.php)

[davidw]

Looks good :)

[Retell]

David with this hack installed members can not submit anything or view profiles can you look into it for me please?

www.nzxt.com/forum

[VaaKo]

Is there a way to make the newely added thread in the forumID I choose to be displayed at first in the scrolling marquee?

Thanks.

/me clicks install

[davidw]

It goes in order from top to bottom. forumid 1 is the first one that shows. Btw, don't forget to click install :D

[laskos]

is there anyway i can just view say the last 20 posts from all the threads ?

[davidw]

Yes, change the field 'Number News Items Displayed' from 3 to 20 and that will display the last 20 posts from all the forumIDs. Is that what you meant?

[laskos]

Yes, change the field 'Number News Items Displayed' from 3 to 20 and that will display the last 20 posts from all the forumIDs. Is that what you meant?

yes but if you look at my site http://www.recycle.co.uk i will have about 50 - 70 forums so i would like to have a from all instead of my putting the ids in

[davidw]

Ahh, so you just want the last 20 from all your forums together? I can work on something as soon as I get a chance to for that - like a special character that will do all forums.

[laskos]

that would be great. the sooner the better ;) ;)

this is where i will be running it http://www.recycle.co.uk/index.php?page=items_offered

thanks for reply

[davidw]

Ok, make sure you have a copy of the original one you installed just in case this doesn't work. I don't have a way to test it because my site is down and my sql is down as well. However, theoretically, it should work.

[laskos]

no if you look at http://www.recycle.co.uk/index.php?page=items_offered the ticker has stopped now

[laskos]

ive put the original one back on for now

[davidw]

try changing this:
if (fid1=="777") {to this:
if ($fid1=="777") {

[PuddingMonkey]

Is it possible to get this addon to function on vBAdvanced pages? I've tried just adding the string into the vBa template but no go. Thanks in advance for the support.

[davidw]

I had it working in my header (which showed up on vbadvanced pages). I'll have to look into it when my site gets back up to test that.

[PuddingMonkey]

Okay, thanks for the quick reply. I actually see that laskos has it running on his, I'm going to play around with it some more and see what I can't do.

[laskos]

try changing this:
if (fid1=="777") {to this:
if ($fid1=="777") {

where do i change that

[laskos]

Okay, thanks for the quick reply. I actually see that laskos has it running on his, I'm going to play around with it some more and see what I can't do.

ive added it on VBA pages ok

[PuddingMonkey]

Odd, when I add that string into vBa pages it doesn't work. Possibly something to do betwen 3.5x and 3.6 (I doubt it but I can't think of anything else).

[laskos]

im using 3.5.4

[davidw]

Version shouldn't have anything to do with it. I suspect it is something else such as needing a different hook location.

[davidw]

Ok, here's what I have read... you need to add the plugin titles to Portal Output Global Variables in your CMPS options. I am not sure how to navigate there as I don't have access to this atm.

Edit reading another thread, the way is: Admin CP => vBa CMPS => Default Settings => Portal Output Global Variables

[PuddingMonkey]

Ok, here's what I have read... you need to add the plugin titles to Portal Output Global Variables in your CMPS options. I am not sure how to navigate there as I don't have access to this atm.

Edit reading another thread, the way is: Admin CP => vBa CMPS => Default Settings => Portal Output Global Variables

Thanks, that got it working perfectly. I just added ticker_titles and vbnews_ticker into there and its working like a charm.

[davidw]

Sounds good! After I get back from going out of town today, I'll add it to the instructions. I'm working on an update (kind of hard when you don't have anything to test it on, LOL!) that will give more control over the tickers. I may release it for 3.6 when I get finished, but a fix or two will make it compatible for 3.5.

[laskos]

hi

have you worked on this as i would like more control over what and where i display recents posts if possible

thanks for this, much appreciated

[davidw]

I am working on an updated ticker - I just have to wait until I have access to do some testing as my site is down atm. What did you have in mind?

[mpage]

I've made a similar thing, doesnt require any particular mysql version, and grabs
rss feed from any source you want to display as a ticker

see this post (java rss feed ticker), might be what your looking for: https://vborg.vbsupport.ru/showthread.php?p=1122198#post1122198

[MajorFm.com]

is there a vb6 version? and does each story have its own link to the thread?

[davidw]

no, but this should work with 3.6 - it links to the thread that the thread's title comes from.

[rmxs]

hello i use vb 3.6.4 and if activate the mod my server load 16+
without this 0.01-0.10

someone have any idea?

[davidw]

Which PHP/SQL are you using?
Let me look at the query and see what I can do to speed it up and drop the server load.

[rmxs]

PHP 4.4.4 sql 4.1.10 in debian sarge stable!

[davidw]

Let me look at this tomorrow. I was off work today - everything is at work.

Edit: btw, which ticker did you use? Have you tried the legacy version?

[rmxs]

both of them

[davidw]

How many forums will you be using on this? I'm going to see about creating something custom.

[rmxs]

6-7 forums i have also try with 2-3 byt same results!

i thing there is some tables open or something like that!
It not possible after 1 min after enable the mod server load 16+

[davidw]

Ok, try this...

[rajab1988]

any one tested this on 3.6.4

[davidw]

Working right here: http://www.christianboards.org/forum.php :)

[fishhub]

Thanks, that got it working perfectly. I just added ticker_titles and vbnews_ticker into there and its working like a charm.

I have done that, and its working. But everytime I click onto the news, it shows an error. How do I configure it?

[davidw]

What error are you seeing? You configure it by the admincp (Step 3).

[Fungsten]

What error are you seeing? You configure it by the admincp (Step 3).

I fixed it. One question, how do you change color of the ticker?

[davidw]

Here is one way you can do it: https://vborg.vbsupport.ru/showpost.php?p=1047607&postcount=60

[Fungsten]

Here is one way you can do it: https://vborg.vbsupport.ru/showpost.php?p=1047607&postcount=60

Thanks I'll try it.

[fishhub]

Ok, here's what I have read... you need to add the plugin titles to Portal Output Global Variables in your CMPS options. I am not sure how to navigate there as I don't have access to this atm.

Edit reading another thread, the way is: Admin CP => vBa CMPS => Default Settings => Portal Output Global Variables


i hv done this for vba cmps , n added ticker_titles and vbnews_ticker into there. It seems that its working partially. When I click onto the news link, it shows error.only vbacmps does not link it back to the forum threads. Any suggestions to fix it. TIA.:o

[davidw]

What error are you getting? Don't forget to click install for support.

[fishhub]

What error are you getting? Don't forget to click install for support.

clicks installed. Pmed you the information. TIA.:o

[davidw]

PM'd you back, btw, to add on you should be able to also use the full path up to that point such as $ticker_titles .= '<a href="http://www.yoursite.com/forum/showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank">'. $ticker['title'] .'</a> '. $ticksep.'';
Anyone else having issues with the target link because of forum location, please take a note in the product there are 9 areas that start with <a href="showthread.php... (such as the code above) but altering that to your forum should fix the link.

[fishhub]

PM'd you back, btw, to add on you should be able to also use the full path up to that point such as $ticker_titles .= '<a href="http://www.yoursite.com/forum/showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank">'. $ticker['title'] .'</a> '. $ticksep.'';
Anyone else having issues with the target link because of forum location, please take a note in the product there are 9 areas that start with <a href="showthread.php... (such as the code above) but altering that to your forum should fix the link.


thanks alot for your great assistance. appreciate lots. works like a charm.

:up::)

[fishhub]

this is mod compatible with php5? TIA.:o

[davidw]

Yes it is - I initially created it while I used version 5 :)

[baklash]

hey i installed it and its in the system but where do i add the news? lol i cant not find it lmaoo

[davidw]

You make all changes (add forumids for example) in the admincp options
Admincp => vBulletin Options => vBulletin Options => vB News Ticker

Don't forget to click install :)

[SBlueman]

The ticker seems to be working on my forum home:
http://gridironfans.com/forums/index.php

But not on my vbadvanced index page:
http://gridironfans.com/

What can be done to fix this?

[SBlueman]

Nevermind, I found this post and it answered my question:

https://vborg.vbsupport.ru/showpost.php?p=1070544&postcount=103
Ok, here's what I have read... you need to add the plugin titles to Portal Output Global Variables in your CMPS options. I am not sure how to navigate there as I don't have access to this atm.

Edit reading another thread, the way is: Admin CP => vBa CMPS => Default Settings => Portal Output Global Variables
Thanks, that got it working perfectly. I just added ticker_titles and vbnews_ticker into there and its working like a charm.

[Alfa1]

I would really like some effects, like http://eurosport.yahoo.com/ or http://news.bbc.co.uk/
Would you consider to add this?

[SBlueman]

I like how the Yahoo link you put up allows you to scroll back and forth. I was using the RSS News Ticker from CoffeeCup before having to uninstall it because of a security flaw (hattip to Alfa1 for the heads up) but it allowed you to scroll back and forth. It's the only feature missing that I am missing from the CoffeeCup code.

[davidw]

I've actually considered working on adding something like the second link. The first link would be something I'd have to look into as I've not seen that one as of yet. Let me see what I can do when I get some time.

[Alfa1]

How do you change the background colour?
I want to decrease the height of my ticker. The height of my ticker does not change when changing the setting in vb options. I have already set it to 1, but that does not help. Any ideas?
I do have the ticker in VBA CMPS.
This is my template:
<table align="center" border="0" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" class="tborder" width="100%">
<thead>
<tr>
<td class="tcat" colspan="$mods[colspan]">

<span class="smallfont"><strong>$vba_style[portal_blockbullet] <if condition="$mods['link']"><a href="$mods[link]">$mods[title]</a><else />$mods[title]</if></strong></span></td>
</tr>
</thead>

<tr>
<td
style="height: 0px; width: 100%; text-align: center; vertical-align: top;">
$vbnews_ticker
</td>
</tr>
</tbody>
</table><br />

[davidw]

To change the background color you should be able to just edit the $vbnews_ticker template and add something like this in this div tag:
<div align="center" style="padding:7px">
right before the "> add
z-index: -1; background-color:#FF0000; layer-background-color:#FF0000; - change the colors as necessary.
Also, remove the padding:7px to adjust the height (or change the number to a lower number).

[Alfa1]

Thanks!

[SBlueman]

The ticker doesn't seem to work on some pages on my site:

http://gridironfans.com/forums/vbplaza.php?
http://gridironfans.com/forums/photoplog/index.php
http://gridironfans.com/forums/arcade.php

[davidw]

I can look into the arcade (although it's not my modification), but I'm not sure what to suggest for vbplaza and photoplog as I don't use those (although photoplog I will use for my next site).

[Mark.B]

I can look into the arcade (although it's not my modification), but I'm not sure what to suggest for vbplaza and photoplog as I don't use those (although photoplog I will use for my next site).
As I don't use this mod myself, I can't vouch for the below, but try this:

ibproarcade: edit the file arcade/functions/functions.php
Find:

global $header,

Add after:

$vbnews_ticker,

Note there's a space at the start of that line.

Photoplog: the same variable needs to be added into admincp > Photoplog > modify settings > global variables. Add "vbnews_ticker" to the list on a new line. Note....no "$" at the start!!

vBPlaza I dunno as I have not used it, but it will be something similar to one of the above.

This sorts it out for most modifications. Hopefully it will for this.

[davidw]

Thanks for the add Mark :) I'll post a link to this in the instructions.

[Mark.B]

Ok cool...though I haven't tested it on this particular mod, so it might be worth getting someone to confirm it works. Can't see why it wouldn't though.

I know it works for may other mods, like Paul M's new rep points, new posts since last visit, and several others.

[fatal1980]

Just installed its working nice.. how do I change the text size?

[SBlueman]

I edited the html portion of the plugin.

[SBlueman]

As I don't use this mod myself, I can't vouch for the below, but try this:

ibproarcade: edit the file arcade/functions/functions.php
Find:

global $header,

Add after:

$vbnews_ticker,

Note there's a space at the start of that line.

Photoplog: the same variable needs to be added into admincp > Photoplog > modify settings > global variables. Add "vbnews_ticker" to the list on a new line. Note....no "$" at the start!!

vBPlaza I dunno as I have not used it, but it will be something similar to one of the above.

This sorts it out for most modifications. Hopefully it will for this.

It worked for all but the vbPlaza. I can't find any way to edit this for that mod.

[rnmcd]

SBlueman, aren't you using this ticker mod on gridironfans.com?

[SBlueman]

Yes I am. I was using something else before but it had a security issue.

[rnmcd]

Sorry, I didn't notice it. I was looking for the ticker to be at the bottom. Nice site.

[SBlueman]

Ah, thanks! :):up:

[Alfa1]

I am using this ticker outside of my forums folder. So when I click on a link, it takes me to a blank screen, because it misses 'forums/' in the url.

How do I correct that?

[davidw]

In the plugin, find each instance of $ticker_titles .= '<a href="showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank">'. $ticker['title'] .'</a> '. $ticksep.''; and change the href="showthread... part to a full url.
Example: $ticker_titles .= '<a href="http://www.yoursite.com/showthread.php?t='. $ticker['threadid'] .'" title="'. $ticker['title'] .'" target="blank">'. $ticker['title'] .'</a> '. $ticksep.'';

[Alfa1]

Muchas gracias!

[Mark.B]

It worked for all but the vbPlaza. I can't find any way to edit this for that mod.
Apologies, I haven't used vBPlaza, so I don't know.

Does it have any settings for adding variables?

Or failing that, a config file where variables can be added to a string?

The mod isn't available for download, or else I'd take a look and see what I can find. :(

There is usually SOME place a variable can be put to make it work though.

[SBlueman]

No it doesn't have a field to enter in anything in the AdminCP. I can PM you the file I think it is (I wouldn't want to post it out in the open since it's a paid mod).

[N FUL FX]

hi! I just installed this, and it works great except for an empty line (line break) before the marquee. How do I get rid of that?.

[davidw]

Check at the end of your navbar template and you might find a <br /> there

[N FUL FX]

Nah couldn't find anything. It was fine before. It's not a big deal, I just don't know where that would suddenly come from. Thanks for the tip though! :)

[oaddah]

thanks my frind

installed

[rnmcd]

What is the latest version of vB that you have found this hack to work in?

[darkskies1]

I was wondering, is there anyway to get this to pull from the categories instead of just the forums? Is there any chance you will be adding it for more then 9 forums?

It's an awesome, well loved mod within my members. Thanks!

[davidw]

What is the latest version of vB that you have found this hack to work in?
I have a 3.7.x version here: https://vborg.vbsupport.ru/showthread.php?t=167061

I was wondering, is there anyway to get this to pull from the categories instead of just the forums? Is there any chance you will be adding it for more then 9 forums?

It's an awesome, well loved mod within my members. Thanks!I'm not sure if categories would work, but you could try the respective id in there and test that. How many were you interested in? Any changes I make will probably be to the latest version.

[leitel]

It looks like the ticker is not updating to reflect the newest x entries. I disabled and then re-enabled the product with no change. It is working but with the original entries from each forum although there are newer entries posted into these forums.
Ideas? Suggestions?
Thank you :)

[davidw]

If I remember this correctly, this is based on thread creation date, so in order to get it to display by last response the query would have to be altered.

[leitel]

I will explore that but I expected the default behavior for it to show the latest 'news'.

[leitel]

From what I see, here is the query performed on each forum:
...
ORDER BY dateline DESC
LIMIT " . $alllim . "

So basically, the query takes the latest x posts and adds them to the list to be displayed in the newsticker.

The queries look good however what appears in the ticker does represent the latest posts.

[davidw]

This version no longer supported. Only 3.7.x and higher is supported.

[SBlueman]

I know this version isn't supported....but does anyone know how to remove the underline under the links created with this modification?

[shakirulqadree]

i want this mod on 3.8x plz if there is some thing for me

[MagicThemeParks]

This works: https://vborg.vbsupport.ru/showthread.php?t=207432