New Vid On The Block

[LightningCountX]

How do you get your video on New Vid On The Block?

[Nemoxs]

I think that it's a random pick system, i belive it changes every few hours depending on whom ever got their video in first that hour... I think.

[derobert]

How do you get your video on New Vid On The Block?

<ul><li>It must be locally downloadable<li>It needs to have premiered in the past<li>It needs to be the most recent, sorted by premier date, then by entry date<li>It can't be hidden (not sure what that flag means...)</ul>

That is,

Code: Select all

select vid_id, title from videos where local = 'TRUE' and local_hidden = 'FALSE' and date_premiered < now() order by date_premiered desc, date_entered desc limit $limit

Hope that helps. $limit depends on if you've donated or not.