Hi,

To solve issues by mysql rand() function, do the following.


Open video.php

find:
Code:
$sql = "SELECT * FROM `videos` WHERE
               `video_type`='public' AND
               `video_active`='1' AND
               `video_approve`='1'
                $channel_sql
                ORDER BY rand()
                LIMIT $start_from, $config[num_watch_videos]";
replace with:
Code:
$rand_start = rand($start_from, $view['total'] - $config['num_watch_videos']);
        $sql = "SELECT * FROM `videos` WHERE
               `video_type`='public' AND
               `video_active`='1' AND
               `video_approve`='1'
                $channel_sql
                LIMIT $rand_start, $config[num_watch_videos]";
If you can't do it, open a support ticket at

BuyScripts Helpdesk

with your vshare admin and FTP login details.

Thanks

Buyscripts Team