<?
  /* Main include info */
  ini_set('include_path',"/usr/web/sites/tuve.tv/include/");
  include("site.inc");

  /* Assign the page title */
  $data[tpl]->assign("PAGE_TITLE","");

  /* Main defines */
  $data[tpl]->define(array(index=>"index/index.html"));
  $data[tpl]->define(array(body=>"videos.html"));

  //DoSession();

  if ($data['gender'] == 1) {
    $data['tpl']->assign("RMALE","CHECKED");
    $data['tpl']->assign("RFEMALE","");
    $data['tpl']->assign("RBOTH","");
    $gender = "AND gender = 1";
    }
  else if ($data['gender'] == 2) {
    $data['tpl']->assign("RMALE","");
    $data['tpl']->assign("RFEMALE","CHECKED");
    $data['tpl']->assign("RBOTH","");
    $gender = "AND gender = 2";
    }
  else {
    $data['tpl']->assign("RFEMALE","");
    $data['tpl']->assign("RMALE","");
    $data['tpl']->assign("RBOTH","CHECKED");
    $gender = "";
    }

  if (!$data['eage'])
    if ($data['skey'])
      $data['eage'] = 69;
    else
      $data['eage'] = 35;

  if (!$data['sage'])
    $data['sage'] = 18;

  $syear = 2007 - $data['sage'];
  $eyear = 2007 - $data['eage'];

  if ($data['skey'] != "")
    $skey = "AND (artist LIKE '%$data[skey]%' OR title LIKE '%$data[skey]%')";
  else
    $skey = "";

  $data['tpl']->assign("SKEY",$data['skey']);

  $query = "SELECT SQL_CALC_FOUND_ROWS vid,artist,title,thumb,count,length,username FROM videos v INNER JOIN users u ON v.oid = u.uid WHERE mType = 1 $skey AND rating <= 3 AND status = 0 ORDER BY added DESC LIMIT 0,20";

  $res = mysql_query($query);

  $rows = mysql_num_rows($res);

  $trows = mysql_result(mysql_query("SELECT FOUND_ROWS()"),0,'FOUND_ROWS()');

 $data['tpl']->assign("TOTAL",$trows);
  
    if ($rows > 40) {
      $rows = 40;
      $m = 1;
      }
    else
      $m = 0;

  $data['tpl']->assign("START","1");
  $data['tpl']->assign("END",$rows);

  for ($i = 0;$i < $rows;$i++) {
    $vid = mysql_result($res,$i,'vid');
    $artist = mysql_result($res,$i,'artist');
    $title = mysql_result($res,$i,'title');
    $thumb    = mysql_result($res,$i,'thumb');
    $views    = mysql_result($res,$i,'count');
    $ptime    = date("H:i:s",mysql_result($res,$i,'length'));
    $username = mysql_result($res,$i,'username');
    $results .= "<TR><TD ALIGN=\"CENTER\"><A HREF=\"/watch/$vid\"><IMG SRC=\"$thumb\" WIDTH=\"100\"></TD><TD>Artist: $artist<BR>Ttitle: $title<BR>$ptime <A HREF=\"/$username\">$username</A><BR>Views: $views</A></TD></TR>";
    }

  $data['tpl']->assign("RESULTS",$results);

  for ($i = 18;$i <= 69;$i++) {
    if ($data['sage'] == $i)
      $sage .= "<OPTION VALUE=\"$i\" SELECTED>$i</OPTION>";
    else
      $sage .= "<OPTION VALUE=\"$i\">$i</OPTION>";
    }
  $data['tpl']->assign("SAGE",$sage);

  for ($i = 18;$i <= 69;$i++) {
    if ($data['eage'] == $i)
      $eage .= "<OPTION VALUE=\"$i\" SELECTED>$i</OPTION>";
    else
      $eage .= "<OPTION VALUE=\"$i\">$i</OPTION>";
    }
  $data['tpl']->assign("EAGE",$eage);



  /* Parse and print */
  $data[tpl]->parse(BODY, array("body"));
  $data[tpl]->parse(INDEX, array("index"));
  $data[tpl]->FastPrint("INDEX");
?>