|
Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews. |
Advertisement | |
|
|
Learn how to remove ads |
|
Thread Tools | Display Modes |
#1
|
||||
|
||||
How do I show top X by ratings (top.php)
Hi Samuel,
What would I need to do to get a "TOP list" sorted by rating (overall or otherwise)? (i.e. what would the MySQL query look like to modify module top.php?) these are the fields in the db (some are serialized) "ratings_data", "avg_rating_data" , "overall_rating" & "avg_rating" : but I don't understand their data storage functions.....which are in use & what data do they hold? Thank you, John |
#2
|
||||
|
||||
Hey there, the problem is that you would need to sort by partial serialized values which isnt really that easy.
Bear with me, next version is coming along and will make this much more plausible and easier. |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Is it possible to show the header image in top x module ? | stckhlm | Geek Article and Review System | 0 | 12-27-2009 11:04 AM |
how to make Top 5 Articles block show up on frontpage (vbA CMPS) | beowulf68 | Geek Article and Review System | 1 | 02-23-2008 10:29 AM |
Featured/Latest/Top Active/Top Read Tutorials showing wrong thing | Azhria Lilu | Geek Article and Review System | 5 | 05-22-2006 08:28 PM |
Top x queries on GARS user and admin ratings? | mlrst | Geek Article and Review System | 6 | 02-16-2006 08:10 PM |
Modified top.php | SALvation | Geek Article and Review System | 4 | 10-12-2005 03:30 PM |