Newer
Older
tuve_tv_web / docroot / people.php
@reddawg reddawg on 14 May 2008 3 KB Sync
<?
  /* 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=>"people.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 (username LIKE '%$data[skey]%' OR firstname LIKE '%$data[skey]%' OR lastname LIKE '%$data[skey]%')";

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

  
  if (!$data['start'])
    $data['start'] = 0;


  if ($data['start'] - 20 >= 0) 
    $data['tpl']->assign("PREV","/people.php?data[skey]=$data[skey]&data[sage]=$data[sage]&data[eage]=$data[eage]&data[start]=" . ($data['start'] - 20));
  else
    $data['tpl']->assign("PREV","/people.php?data[skey]=$data[skey]&data[sage]=$data[sage]&data[eage]=$data[eage]&data[start]=" . 0);

  $data[tpl]->define(array("row"=>"people-row.html"));

  $end = $data['start'] + 20;

  $data['tpl']->assign("END",$end);

  $query = "SELECT SQL_CALC_FOUND_ROWS uid,username,main_image,profile_image,caption,city,state_prov FROM users WHERE active = 1 AND (byear <= $syear AND byear >= $eyear) $gender $skey ORDER BY laston DESC LIMIT $data[start],$end ";

  $res = mysql_query($query);

  $rows = mysql_num_rows($res);

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

  if ($data['start'] + 20 < $trows) {
    $data['tpl']->assign("NEXT","/people.php?data[skey]=$data[skey]&data[sage]=$data[sage]&data[eage]=$data[eage]&data[start]=" . $end);
    }
  else {
    $data['tpl']->assign("NEXT","/people.php?data[skey]=$data[skey]&data[sage]=$data[sage]&data[eage]=$data[eage]&data[start]=$data[start]");
    }
  $data['tpl']->assign("START",$data['start'] + 1);


 $data['tpl']->assign("TOTAL",$trows);

  for ($i = 0;$i < $rows;$i++) {
    $uid = mysql_result($res,$i,'uid');

    /* Set Profile Image */
    $mid = mysql_result($res,$i,'profile_image');
    if ($mid == 0)
      $thumb = mysql_result($res,$i,'main_image');
    else
      $thumb = $avatars[$mid];
    $data['tpl']->assign("PROFILE_IMAGE",$thumb);

    $data['tpl']->assign("USER",mysql_result($res,$i,'username'));
    $data['tpl']->assign("CAPTION",mysql_result($res,$i,'caption'));
    $data['tpl']->assign("CITY",mysql_result($res,$i,'city'));
    $data['tpl']->assign("STATE",mysql_result($res,$i,'state_prov'));

    if (mysql_numrows(mysql_query("SELECT userid FROM active WHERE uid = $uid")) == 1)
      $data['tpl']->assign("ONLINE","Currently Online");
    else
      $data['tpl']->assign("ONLINE","Currently Offline");



    $data['tpl']->parse("RESULTS",".row");
    }


  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");
?>