Random Video on index.php ... is that possible?

[FanAddict]

Is it possible to have a 'random' or even the 'latest' video on the main page?

Something that would change either randomly or everytime you add new content?

Would be nice to have :D

[kip]

well, you can take the same code for random on the home page and where it says LIMIT 6, change that to 1. Of course, you can remove the count, and tables, but thats if you know what your doing =].

Also, if you want the latest, you can copy the code, and change ORDER by RAND() to ORDER by gId

I think gId is the variable for the game id. If not, you would need to change this, not looking at the code right now, (on vacation =] ) Let me know if you have any problems/questions.

[FanAddict]

Hmm nah that's not what I meant.

Like - have the FULL VIDEO like on one of the video pages.... on the main page....?

[FanAddict]

well this sucks... no one knows how to do that?

Would really make the page look ALOT nicer....

[Cookie]

I have just posted a MOD for the index page which will show one random video clip.
Check out the post here (http://www.fastfreemedia.com/forums/showthread.php?t=165)