Using Agriya Player with vShare

[ccr1969]

still no go on the thumb click does the someurl need to be repointed ??

ORDER BY RAND()";if you want your thumbs to be random

$sql = "SELECT * FROM video WHERE
      type='public' AND
      active=1 AND
      approve=1 AND
      (keyword like '%$rtags[0]%' $chnl)
      ORDER BY VID ASC";

[bplex]

I didn't even notice that there was a URL in the link. Good catch. However, now that requires me to remodify the code that I put up. I am going to edit that post to have the correct playlist_xml.php. This file will place the URL to the video in it and is multi-server compatible.

As for your second question (regarding the ORDER BY RAND();), I would NOT recommend that you do that. The way that function works is it determines the number of rows within the table and then generates that many random numbers (so, if there are 1000 rows, 1000 random numbers are generated). It will then choose the lowest of those random numbers. The problem with this is the process of diminishing returns. As the number of videos on your site grows, you will be requiring your server to work harder and harder for EACH video that you display. The end result of that will a mySQL crash (crash as the result of the following: number of videos [let's use 1000] x number of random numbers [would be 1000] x number of simultaneous visitors [let's use a small number and say 200]).

Note: In my example above, that's 200,000,000 (2 Hundred Million) numbers generated for 200 people. That's a lot of work.

[ccr1969]

now with the some url replaced with

echo "<VIDEO Name=\"$video_info[title]($duration_hms)\"   Rating=\"$video_info[rate]\" Comments=\"$video_info[com_num]\" Views=\"$video_info[viewnumber]\"  Thumbnails=\"$thumb\" url=\"$flv_url\" target=\"_self\"/>";

when the thumb is clicked it ask's to download file or open it??

[bplex]

Dang it. My bad. The code is putting in the link to FLV. However, it appears as though the playlist in Agriya is not linking to the FLV back into the player. Rather, it's loading the site. Hang on a bit. I'll change the code and repost it.

[bplex]

Ok, give it a try now. I just changed the code again.

[ccr1969]

when the thumbs clicked does a replay of the video just watched not whats on the thumb

[bplex]

Hmm... Seems as though some of the code is being reused. Didn't notice that before. Just changed the PHP again for playlist_xml.php. Try it now.

[ccr1969]

that got her going very nice seems to do what it was meant to thank you

[ccr1969]

your work is appreciated maybe you can put the 2 together and get it sticked

[bplex]

You're welcome