Can you Pre-Define Order Of News Shown With News Slideshow?

[SBlueman]

I have the News Slideshow (https://vborg.vbsupport.ru/showthread.php?t=139529) modification on my site and was wondering if there was a way to organize the news stories so you can define which news stories show up first? Right now they just display in the order they were posted.

[Marco van Herwaarden]

If you have questions/problems with a modification, then please post in the thread (or support forum/board) about that modification. Best chance to receive a reply from either the author or another member using the same modification.

[SBlueman]

I would if it wasn't in the Modification Graveyard.

[Marco van Herwaarden]

The author removed it from vBulletin.org. I guess that means you will need to get support from whatever site he is releasing his work on now.

[SBlueman]

He stopped supporting it a long time ago, it became a member-supported mod. Anyway, I found the solution in case anyone wants it.

You'll need to install this modification: vb_Cement (https://vborg.vbsupport.ru/showthread.php?t=148940&highlight=vb_cement)

Then if you have the joombla slideshow, open the "mod_fpslideshow.php" file. 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!