Hall of Fame

[dtiberio]

in the Recent tab, sometimes if not often, sucky videos appear higher in the search results than good videos, because they all get loaded with 0 views and 0 likes.

good videos tend to come from the same accounts, and sucky videos tend to come from the same accounts, so I would like a way to give a boost to videos that come from better user accounts.

so you would need to count the views & likes for all videos for a user and put it in the user table, and then use this info to give them a boost when they all have 0 likes and 0 views.

I try to sort by views and likes as often as I can because it looks so much nicer.

I order all the popular videos for the day, then for the next day, etc. it looks much better and I am using it on my home page if the views > 0.

Code Select Expand

ORDER BY date(".DB_PREFIX."videos.date) DESC, ".DB_PREFIX."videos.views DESC, hour(".DB_PREFIX."videos.date) DESC

[PHPVibe A.]

Didn't really got you here...