Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Define Order Of News Shown With Frontpage Slideshow Details »
Define Order Of News Shown With Frontpage Slideshow
Mod Version: 1.00, by SBlueman (Member) SBlueman is offline
Developer Last Online: Dec 2013 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 3.6.8 Rating: (1 vote - 5.00 average) Installs: 15
Released: 02 Dec 2007 Last Update: Never Downloads: 4
Not Supported Template Edits Translations  

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:

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Integration with vBulletin News Slideshow Lionel Modification Graveyard 399 06 Nov 2007 04:28

Comments
  #2  
Old 02 Dec 2007, 09:40
Subah's Avatar
Subah Subah is offline
 
Join Date: Feb 2006
Cool , Thanks
Reply With Quote
  #3  
Old 02 Dec 2007, 15:06
Lionel Lionel is offline
 
Join Date: Dec 2001
Real name: Lionel
The vbcement link is not working

Last edited by Lionel; 02 Dec 2007 at 15:30.
Reply With Quote
  #4  
Old 02 Dec 2007, 15:17
SBlueman SBlueman is offline
 
Join Date: Jan 2006
And fixed, thank you for catching that.
Reply With Quote
  #5  
Old 02 Dec 2007, 18:56
ChurchMedia's Avatar
ChurchMedia ChurchMedia is offline
 
Join Date: Dec 2002
Real name: Tim Eason
Excellent! I'm going to install ASAP.
Reply With Quote
  #6  
Old 02 Dec 2007, 21:41
yahoooh yahoooh is offline
 
Join Date: Oct 2002
can u make module like it for vbadvanced cmps ?
Reply With Quote
  #7  
Old 02 Dec 2007, 21:52
SBlueman SBlueman is offline
 
Join Date: Jan 2006
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.
Reply With Quote
  #8  
Old 02 Dec 2007, 22:01
Lionel Lionel is offline
 
Join Date: Dec 2001
Real name: Lionel
You could also look at this one with more options and no queries
Reply With Quote
  #9  
Old 02 Dec 2007, 22:15
SBlueman SBlueman is offline
 
Join Date: Jan 2006
Will this modification work with your vBslideshow?
Reply With Quote
  #10  
Old 02 Dec 2007, 22:28
Lionel Lionel is offline
 
Join Date: Dec 2001
Real name: 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
Reply With Quote
  #11  
Old 04 Dec 2007, 14:53
Qwest Qwest is offline
 
Join Date: Jun 2004
Holy thread jackers batman..........
Reply With Quote
  #12  
Old 05 Dec 2007, 01:20
aycan555 aycan555 is offline
 
Join Date: Dec 2005
Real name: www.ultrapaylasim.com
thanx for this great hack mate....

Note: if someones interested to buy the joomla's frontpage slideshow script, i want to sell mine because i am not using it any more, it is normally 22 euros, i would sell it for 10 euro by paypal. Please pm me if you are interested...
__________________
Reply With Quote
  #13  
Old 05 Dec 2007, 12:02
PoetJA-1975's Avatar
PoetJA-1975 PoetJA-1975 is offline
 
Join Date: Sep 2006
Real name: Jacquii Cooke
Very nice modification - It looks AWESOME on GridironFans!
Question - do you need to download the Frontpage Slideshow for vBulletin specifically or does it make any difference?

Thanx for the sharing.

Jacquii.

ps - PMing AYCAN555
Reply With Quote
  #14  
Old 05 Dec 2007, 16:59
SBlueman SBlueman is offline
 
Join Date: Jan 2006
As far as I know you'd need the vbulletin version for this to work with the way I have this lined out. I couldn't tell you of another way to do this.
Reply With Quote
  #15  
Old 05 Dec 2007, 23:45
PoetJA-1975's Avatar
PoetJA-1975 PoetJA-1975 is offline
 
Join Date: Sep 2006
Real name: Jacquii Cooke
OK - Thanx - I would love to install - but it's a bit expensive for the moment...
Still awaiting answer to my PM - At anyrate - thanx so much for sharing.
It really looks AWESOME on your Forum

Jacquii.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

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


New To Site? Need Help?

All times are GMT. The time now is 20:22.

Layout Options | Width: Wide Color: