Portal Software - Define Order Of News Shown With Frontpage Slideshow

I have been using this on my site for a while now and I love how I can sort the order in which the news is displayed. I felt it would be a cool thing to share with everyone, so here goes:

First, you'll need to have Joomblaworks "FrontPage Slideshow" installed on your site. (this is NOT a free modification, and is needed to make this work)

Then you'll need to install this modification: vb_Cement

Now, open the "mod_fpslideshow.php" file for the Frontpage Slideshow. Search for "sticky" (only one instance in the entire file) and replace with "threadweight".

Old line of code:

$getnews = $db->query_read("SELECT threadid from ".TABLE_PREFIX."thread WHERE attach !='0' AND forumid in($forumid) ORDER by sticky DESC, threadid DESC LIMIT $limit");

New line of code:

$getnews = $db->query_read("SELECT threadid from ".TABLE_PREFIX."thread WHERE attach !='0' AND forumid in($forumid) ORDER by threadweight DESC, threadid DESC LIMIT $limit");

Now use the vb_Cement modification to arrange your sticky news items in the forum you are pulling the news from. Enjoy!

DEMO:
http://gridironfans.com/

Screenshot:

[joeycano]

I'm willing to collaborate. Let me know.

[SledgeHead]

Anyway to make them show up randomly. I have it where it is like a banner ad displaying the "Hot Topics" and it would be nice if it would appear in a random order. Here's an example of how I have it set up. OrlandoUnited.com/Forums

[yunie_]

please help me.. i dont wanna spend 22euros for nothing.. I cant get the slideshow to work properly on vbadvanced. anyone help? the faq at joomlaworks only teach u how to put it in vb and not vbadvanced.

HELP (yes im desperate)

[ivanmcp]

Originally Posted by yunie_

please help me.. i dont wanna spend 22euros for nothing.. I cant get the slideshow to work properly on vbadvanced. anyone help? the faq at joomlaworks only teach u how to put it in vb and not vbadvanced.

HELP (yes im desperate)

I made this work in vBadvanced, do you still need to know how its done?

[joeycano]

I purchased and installed FrontPage SlideShow pursuant to the vBulletin instructions. Installation went fine. However, I soon en encountered a small attachment issue when some registered users tried to add an attachment using the paper clip on the WYSIWYG tool bar. Some users were able to post attachments but others received the following message: "Invalid Thread specified. If you followed a valid link, please notify the administrator" I did confirm that the users had appropriate attachment posting permission.

To fix the problem, I contacted vBulletin for assistance. They advised that I uninstall all attachments and revert all temples. I have a tech perform vBulletin's recommendation except for FrontPage SlideShow as I thought it could not be the issue. However, the same issue continued until FrontPage SlideShow was uninstalled. Since everything has reinstalled without an issues.

I wanted to know if there is a fix for this??? I have properly set FrontPage SlideShow to post attachments from one forum (id11).

I am using Version 1.6 (vBulletin Version) on vBulletin 3.7.1

[jkcerda]

cool