Results 1 to 3 of 3

Thread: Featured from TODAY

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Join Date
    Sep 2009
    Posts
    25

    Thumbs up Featured from TODAY

    Hi,

    How can I rotate randomly the TODAY FEATURED videos ?

    I haven't FEATURED VIDEOS, but in home show 5 videos as FEATURED.

    Allways the same videos...

    look VB-MUNDO VIDEOS - Videos Tecnicos

    How can I set to randomly showing videos ??

    Regards

  2. #2

    Default

    Hi,

    Its need custom code modification.

    Open a support ticket with your site admin and FTP login details.

    Thanks,

  3. #3
    Join Date
    Sep 2009
    Posts
    25

    Default

    Thanks but I have the solution !!!

    You must edit the INDEX.PHP

    Find

    if (mysql_num_rows($result) < 1)
    {
    $sql = "SELECT * FROM `videos` WHERE
    `video_type`='public' AND
    `video_active`='1' AND
    `video_approve`='1'
    $sql_adult_filter
    LIMIT 4";
    $result = mysql_query($sql) or mysql_die($sql);
    }

    and replace for

    if (mysql_num_rows($result) < 1)
    {
    $sql = "SELECT * FROM `videos` WHERE
    `video_type`='public' AND
    `video_active`='1' AND
    `video_approve`='1'
    $sql_adult_filter
    ORDER BY RAND() LIMIT 4";
    $result = mysql_query($sql) or mysql_die($sql);
    }

    this ORDER BY RAND() make a Random results showed.. It's fine !!

    Now my content change on every refresh or visit...

    Regards !!

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •