<?
session_start();
include('admin/db.php');
$result = mysql_query("SELECT content.*, (SELECT content_views.views FROM content_views WHERE content_views.content = content.record_num) as views FROM content WHERE enabled = 1 AND approved = 2 AND photos = 0 AND embed = '' ORDER BY encoded_date DESC") or die(mysql_error());
while($row = mysql_fetch_array($result)) {
	$title = $row[title]; 
	$bad = array('?','!',' ','&','*','$','#','@');
	$good = array('','','-','','','','',''); 
	$url = "$basehttp/videos/".strtolower(str_replace($bad,$good,$row[title]))."-".$row[record_num].".html"; 
	$dirname = str_replace('.flv','',$row[orig_filename]);
	$subdir = $row[filename][0].'/'.$row[filename][1].'/'.$row[filename][2].'/'.$row[filename][3].'/'.$row[filename][4].'/'; 
	$dirname = $subdir.$dirname; 
	$thumb = $thumb_url.'/'.$dirname.'/'.$row[orig_filename].'-'.$row[main_thumb].'.jpg';
	echo "$url|$thumb|$title\n"; 
}
?>