random video fuction made me crazy

[vshare2]

Hi,

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


Open video.php

find:

$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:

$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

[clonevideos]

i did not find the code that you have mentioned in your earlier message.
you wrote:

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

could you please check. i have just created a support ticket for you with my login details.