Add a truly random video to any page...

[grynmoors]

I found that this works and you don't have to enter the database/user name information (you will still have to enter the domain name tho)

<?php
			   include("include/config.php");
			   
        $sql = mysql_query("SELECT VID FROM video WHERE type = 'public' AND approve = '1' AND active= '1'") or die (mysql_error());
        while($row = mysql_fetch_array($sql)){
            $row_array[] = $row['VID'];
        }

        $random_row = $row_array[rand(0, count($row_array) - 1)];

        $sql2 = mysql_query("SELECT flvdoname FROM video WHERE VID = '$random_row'") or die (mysql_error());

        $row = mysql_fetch_object($sql2);

        $flv = $row->flvdoname;

        ?>

        <?

        echo "<div style=\"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; padding-bottom: 2px; PADDING-TOP: 10px\">\n";

        echo "<script type=\"text/javascript\" src=\"http://YOURDOMAIN.COM/player/swfobject.js\"></script>\n";

        echo "<p id=\"vshare_player\"><a href=\"http://www.macromedia.com/go/getflashplayer\">Get Flash</a> to see this player.</p>\n";

        echo "<script type=\"text/javascript\" src=\"http://YOURDOMAIN.COM/player/swfobject.js\"></script>\n";
        echo "<script type=\"text/javascript\">\n";
        echo "var so = new SWFObject(\"http://YOURDOMAIN.COM/player/player.swf\",\"vshare_player\",\"300\",\"275\",\"8\");\n";
        echo "so.addParam(\"allowfullscreen\",\"true\");\n";
        echo "so.addVariable(\"file\",\"http://YOURDOMAIN.COM/flvideo/", urlencode($flv), "\");\n";
        echo "so.addVariable(\"image\",\"http://YOURDOMAIN.COM/thumb/", urlencode($random_row), ".jpg\");\n";
        echo "so.addVariable(\"logo\",\"http://YOURDOMAIN.COM/templates/images/watermark.gif\");\n";
        echo "so.addVariable(\"link\",\"http://YOURDOMAIN.COM\");\n";
        echo "so.addVariable(\"linktarget\",\"_blank\");\n";
        echo "so.addVariable(\"width\",\"300\");\n";
        echo "so.addVariable(\"height\",\"275\");\n";
        echo "so.addVariable(\"bufferlength\", \"5\");\n";
        echo "so.addVariable(\"overstretch\", \"true\");\n";
        echo "so.addVariable(\"autostart\", \"false\");\n";
        echo "so.write('vshare_player');\n";
        echo "</script>";

        echo "</div>";

        ?>

I'm working on finding a way so that we don't have to add in the domain information...like somehow putting {$baseurl} in there instead if that's possible. I currently have it working at my test site: http://vshare-mods.com

[eyeonprize]

<?php
               include("include/config.php");
               
        $sql = mysql_query("SELECT VID FROM video WHERE type = 'public' AND approve = '1' AND active= '1'") or die (mysql_error());
        while($row = mysql_fetch_array($sql)){
            $row_array[] = $row['VID'];
        }

        $random_row = $row_array[rand(0, count($row_array) - 1)];

        $sql2 = mysql_query("SELECT flvdoname FROM video WHERE VID = '$random_row'") or die (mysql_error());

        $row = mysql_fetch_object($sql2);

        $flv = $row->flvdoname;

        ?>

        <?

        echo "<div style=\"PADDING-RIGHT: 10px; PADDING-LEFT: 10px; padding-bottom: 2px; PADDING-TOP: 10px\">\n";

        echo "<script type=\"text/javascript\" src=\"http://YOURDOMAIN.COM/player/swfobject.js\"></script>\n";

        echo "<p id=\"vshare_player\"><a href=\"http://www.macromedia.com/go/getflashplayer\">Get Flash</a> to see this player.</p>\n";

        echo "<script type=\"text/javascript\" src=\"http://YOURDOMAIN.COM/player/swfobject.js\"></script>\n";
        echo "<script type=\"text/javascript\">\n";
        echo "var so = new SWFObject(\"http://YOURDOMAIN.COM/player/player.swf\",\"vshare_player\",\"300\",\"275\",\"8\");\n";
        echo "so.addParam(\"allowfullscreen\",\"true\");\n";
        echo "so.addVariable(\"file\",\"http://YOURDOMAIN.COM/flvideo/", urlencode($flv), "\");\n";
        echo "so.addVariable(\"image\",\"http://YOURDOMAIN.COM/thumb/", urlencode($random_row), ".jpg\");\n";
        echo "so.addVariable(\"logo\",\"http://YOURDOMAIN.COM/templates/images/watermark.gif\");\n";
        echo "so.addVariable(\"link\",\"http://YOURDOMAIN.COM\");\n";
        echo "so.addVariable(\"linktarget\",\"_blank\");\n";
        echo "so.addVariable(\"width\",\"300\");\n";
        echo "so.addVariable(\"height\",\"275\");\n";
        echo "so.addVariable(\"bufferlength\", \"5\");\n";
        echo "so.addVariable(\"overstretch\", \"true\");\n";
        echo "so.addVariable(\"autostart\", \"false\");\n";
        echo "so.write('vshare_player');\n";
        echo "</script>";

        echo "</div>";

        ?>

Then can you at least tell me which file this code is added to?

Tks