3) $video_id = substr($video_id,0,3); $ip = $_SERVER['REMOTE_ADDR']; $os = $_SERVER['HTTP_USER_AGENT']; require_once('atv.inc'); connect(); $result = mysql_query("SELECT vid_id FROM video_details"); $num = mysql_num_rows($result); $num = $num - 1; ?> body {background-color: #272727}'; $query = "SELECT folder_name, flash_name, script_name, vid_title, vid_description, vid_cat, last_ip, hits, file_name, oldaspect FROM video_details WHERE vid_id = $video_id"; $result = mysql_query($query); $row = mysql_fetch_row($result); $directory = $row[0]; $flash = $row[1]; $script = $row[2]; $title = $row[3]; $description = $row[4]; $cat = $row[5]; $lastip = $row[6]; $hits = $row[7]; $filename = $row[8]; $oldaspect = $row[9]; if ($ip!==$lastip) { $hits++; $query = "UPDATE video_details SET last_ip = '".$ip."', hits = '".$hits."' WHERE vid_id = $video_id"; $result = mysql_query($query); $query = "INSERT into video_log (vid_id, ip) VALUES ('".$video_id."', '".$ip."')"; $result = mysql_query($query); } $w='100%'; $h='75%'; if ($oldaspect==1){$w="100%";$h="56%";} $len = strlen($filename) - 4; $filename = substr($filename, 0, $len); echo ' '.$title.'

'.$title.'

'.$description.'

'; ?>