Videos Being Watched Right Now...

[Meghwar]

Hi all
I buy the script and got the 2nd one free, but I you look the image below, top image from the site i bought my Script from it shows the time on the roller on the bottom image its my site it doesn't show the time, any help to show that time.

Image http://vcoders.org/roller.jpg

Thank you in advance

Thanks for letting me know about the issue. Change your roller.php file to this.

<?php 



include("include/config.php");



$VID=$_REQUEST[VID];



$query = "SELECT * FROM video WHERE type = 'public' AND active='1' AND approve='1' ORDER BY viewtime desc LIMIT 12"; 

$db=mysql_connect ($db_host,$db_user,$db_pass) or die ('I cannot connect to the database because: ' . mysql_error());

mysql_select_db ($db_name); 

$num_rows = mysql_num_rows(mysql_query("select * from video")); 

$result = mysql_query($query) or die ('Query Error: ' . mysql_error()); 



header("Content-Type: text/xml"); 

header("Expires: 0"); 

print "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\n"; 

print "<ut_response status=\"ok\">\n";

 

print "<video_list>\n";



while ($results = mysql_fetch_array($result)) 

{ 

	$viewnumber = $results['viewnumber']; 

	$title = $results['title']; 

	$duration = $results['duration']; 

	$viewkey = $results['vkey'];

	$VID = $results['VID'];



//Seconds to Mins - Mod

$seconds = $results['duration'];

$time = str_pad(intval(($seconds / 60) % 60),2,"0",STR_PAD_LEFT).":"

. str_pad(intval($seconds % 60),2,"0",STR_PAD_LEFT) ;

//Seconds to Mins - Mod





print "<video>\n";



print "<viewers>";

print "$viewnumber";

print "</viewers>\n";



print "<title>";

print "$title";

print "</title>\n";



print "<run_time>";

print "$time";

print "</run_time>\n";



print "<url>";

print $config['BASE_URL'];

print "/";

print "view";

print "/";

print "$VID";

print "/";

print "$title";

print "/";

print "</url>\n";



print "<thumbnail_url>";

print $config['BASE_URL'];

print "/thumb/1_";

print "$VID";

print ".jpg";

print "</thumbnail_url>\n";



print "</video>\n";



} 

mysql_close(); 



print "</video_list>\n";



print "</ut_response>"; 



?>

Thanks, Jereme

Thank you It works Like a Sharm :)

am still waiting your PM ! about what we talk before