Go Back   Pligg CMS Forum > Pligg Help > General Help

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 09-02-2006, 11:44 AM
New Pligger
 
Join Date: Aug 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Main Page

I'm trying to change the order in which the stories are selected from the database. Right now it appears as if they're in order by date added.

Which file/line is this query on?
Reply With Quote
  #2 (permalink)  
Old 09-02-2006, 03:34 PM
Casual Pligger
 
Join Date: Jun 2006
Location: Dover, NH
Posts: 62
Thanks: 3
Thanked 42 Times in 16 Posts
I haven't tested this, but if I were to make the change you're looking for, here's where I'd start. In "index.php" look for the following chunck of code:
Code:
if($search) {
	$from_where .= $search;
	$order_by = '';
} else {
	$order_by = " ORDER BY link_published_date DESC ";
}
Change "link_published_date" to the value you want to use to sort the stories on your main page. Hope this helps. :)
Reply With Quote
Reply

Thread Tools
Display Modes
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 Off
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Variables Yankidank Wiki Articles 1 08-13-2008 03:59 AM
Page Numbers in main page.... vgreets General Help 0 01-10-2008 09:27 PM
Show Page Thumbnails on main page seer General Help 2 11-20-2007 04:20 AM
Show Video and images Thumbnails on main page massi999 General Help 1 11-19-2007 12:40 PM


Search Engine Friendly URLs by vBSEO 3.2.0