Random Database Record (Button)

[LukasGr.]

Hi guys, 

I created a Video Database on our site where everyone is allowed to submit a youtube video. Thus, a lot of database records (a database record is only a youtube video) are stored after a while. So far so good. 

We want to allow our guests to brows through the whole database and get entertained by the videos provided.
(1.) Now comes the part where I need your help: Is there a way to create a button letting users jump to a random database record (video)? I thought about a php way with counting the items stored in the database and select a random number out of the count as the ID. But this won't work cause of every ID is unique and after deleting a post the video won't appear anymore but the ID is still assigned. (I hope you know what I mean)

So, is there a way with IPS varibles to select 1 active random database record??

(2.) Furthermore, can we add a random standard sorting of the database records (those settings can be found in the database settings in the ACP)?

[LukasGr.]

Hm, I wonder if no one else is interested in this? Or is it such a stupid question that no one response I can't find helpful input from the documentation though.

[bradl]

Waiting for random list view. I use it on 3.x to keep an advertising-oriented database listing "fair" in terms of presentation and the primacy effect. 

[LukasGr.]

Sorry but I have to bump this up since it is still very important for our feature we would like to release for weeks now.