Re: Need help with sql query...
Are you talking about your top 10 users who upload the most? LIke Joe Blow has uploaded 100 videos, Betty Boop has uploaded 90 videos...etc?
If so, my guess would be to look to the code in the submenu that says how many videos a person has (public and/or private). Or the user.tpl page where it says how many videos that person has uploaded
Code:
I have uploaded {$u_info.total_video} videos. {if $pack.video_limit gt "0"} out of {$pack.video_limit} videos{/if}
which gets that info from the "subscriber" section in the sql thingie and then total_video table.
sql thingie...don't you just love it when I speak technical?
If it's not fun, stop doing it!
Bookmarks