New Vid On The Block

This forum is for help with this web site. Please read the FAQ and then search this forum before asking questions here; most likely the question you are about to ask has already been answered.

New Vid On The Block

Postby LightningCountX » Sun Jul 06, 2003 11:01 am

How do you get your video on New Vid On The Block?
User avatar
LightningCountX
 
Joined: 20 May 2003
Location: Bayside, NY Interests: Your Mom ^_^

g

Postby Nemoxs » Sun Jul 06, 2003 2:33 pm

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.
User avatar
Nemoxs
 
Joined: 08 Mar 2003

Re: New Vid On The Block

Postby derobert » Mon Jul 07, 2003 9:11 am

LightningCountX wrote: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.
Key 55EA59FE; fingerprint = E501 CEE3 E030 2D48 D449 274C FB3F 88C2 55EA 59FE
A mighty order of ages is born anew.              http://twitter.com/derobert
User avatar
derobert
Phantom of the .Org
 
Joined: 24 Oct 2001
Location: AOD Command Fortress


Return to Site Help & Feedback

Who is online

Users browsing this forum: No registered users and 0 guests