Order all stories of a user (profil view) by category

Register an Account
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old 02-06-2008, 12:23 PM
Constant Pligger
 
Join Date: Apr 2007
Posts: 1,042
What has to be done to order all stories of a user by category (and date)?

Since demo isnīt running anymore I canīt tell you the english name of the triggering profile tab but it must be the one connected with PLIGG_Visual_User_Profile_Total_Links.
Reply With Quote
  #2 (permalink)  
Old 02-06-2008, 12:30 PM
Banned
Pligg Version: 9.8.
Pligg Template: Custom
 
Join Date: Feb 2007
Location: Canada
Posts: 796
So you mean in addition to what is already there, i.e., published, upcoming, submitted you want another tab to show a list of categories and the number of stories they have submitted to that category?

Geoserv.
Reply With Quote
  #3 (permalink)  
Old 02-06-2008, 12:42 PM
redwine's Avatar
Pligg Donor
Pligg Version: 9.8
Pligg Template: custom templat
 
Join Date: Jul 2007
Location: Canada
Posts: 216
Quote:
Originally Posted by tbones View Post
What has to be done to order all stories of a user by category (and date)?

Since demo isnīt running anymore I canīt tell you the english name of the triggering profile tab but it must be the one connected with PLIGG_Visual_User_Profile_Total_Links.
The PLIGG_Visual_User_Profile_Total_Links is the label for the total links under "My Profile Stats" in the user's profile.

If I understood correctly, you want when clicking on the tabs "Submitted", "Published", "Upcoming" that the stories be listed by category and date. In this case, the functions that displays the data for the mentioned tabs are in /user.php.

function do_history () is for the "Submitted"
The data is ordered by link date in descending order
function do_published () is for the "Published"
The data is ordered by link published date in descending order
function do_shaken () is for the "Upcoming"
The data is ordered by link date in descending order

This is where you have to alter the queries to get the ordering you want.
Reply With Quote
  #4 (permalink)  
Old 02-06-2008, 03:48 PM
Constant Pligger
 
Join Date: Apr 2007
Posts: 1,042
Sorry for the confusion!

This is exactly what I was looking for:
Quote:
Originally Posted by redwine View Post
function do_history () is for the "Submitted"
The data is ordered by link date in descending order
function do_published () is for the "Published"
The data is ordered by link published date in descending order
function do_shaken () is for the "Upcoming"
The data is ordered by link date in descending order
Iīve modified all statments to ORDER BY link_category, ..., the voted and commented function to ORDER BY link_author, link_category, ....

Thank you both!
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Control of meta description - categories Divisive Cotton Questions and Comments 71 03-29-2011 10:03 PM
Pligg 1.0 RC4 Category Order Is Not Working argh2xxx Questions and Comments 4 04-08-2009 11:05 AM
Pligg Categories Yankidank Wiki Articles 1 12-17-2008 11:10 AM
Pligg beta 9.5 [updated] kbeeveer46 Current Version 0 04-29-2007 10:58 PM
Show Top Stories by Category in Sidebar - A How To TrailofDead Questions and Comments 0 04-23-2007 10:30 PM


Pligg Modules and Pligg Templates from Pligg Pro Find support on the Pligg CMS Forum - 24 hours a day! Make a donation to support Pligg CMS development