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:

[Subah]

Cool , Thanks

[Lionel]

The vbcement link is not working

[SBlueman]

And fixed, thank you for catching that.

[ChurchMedia]

Excellent! I'm going to install ASAP.

[yahoooh]

can u make module like it for vbadvanced cmps ?

[SBlueman]

The Frontpage Slideshow mod IS the mod that would add the module for vbadvanced. It is not free though.

This modification is just an enhancement to the Slideshow modification for people who use/own it.

[Lionel]

You could also look at this one with more options and no queries

[SBlueman]

Will this modification work with your vBslideshow?

[Lionel]

It's just a matter of changing the ORDER BY. In fact, I am going to add that option in admincp where you will define the order by