The vB Geek

Go Back   The vB Geek > vB Geek Products > Geek Article and Review System

Geek Article and Review System GARS is the mega popular system for turning forums into articles, tutorials, or even reviews.

Advertisement
This is an HTML example. Isn't it just wonderful?!?!
  Learn how to remove ads

Reply
 
Thread Tools Display Modes
  #1  
Old 03-20-2006, 07:00 PM
fyjpm's Avatar
fyjpm fyjpm is offline
Junior Member
 
Join Date: Dec 2005
Posts: 12
Geek Article and Review System License Holder Geek Auto-Linker Pro License Holder 
Default 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
Reply With Quote
  #2  
Old 03-22-2006, 05:51 PM
The Geek's Avatar
The Geek The Geek is offline
Senior Member
 
Join Date: Aug 2005
Posts: 6,717
Geek Article and Review System License Holder GeekMart License Holder Geek Auto-Linker Pro License Holder Geek Advertising Banner License Holder Geek Gazette License Holder 
Default

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.
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 On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT. The time now is 11:28 PM.


Powered by vBulletin® Version 3.8.5
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.