<?php 
ini_set("display_errors","1");
ini_set("display_startup_errors","1");
set_magic_quotes_runtime(0);

include("include/dbcommon.php");
include("include/09GoldenSneaker5K_variables.php");


include('include/xtempl.php');
$xt = new Xtempl();

$filename="";	
$message="";
$key=array();
$next=array();
$prev=array();
$all=postvalue("all");
$pdf=postvalue("pdf");
$mypage=1;

$id=1;


//	Before Process event
if(function_exists("BeforeProcessView"))
	BeforeProcessView($conn);

$strWhereClause="";
if(!$all)
{
	$keys=array();
	$keys["AutoID"]=postvalue("editid1");

//	get current values and show edit controls

	$strWhereClause = KeyWhere($keys);


	$strSQL=gSQLWhere($strWhereClause);
}
else
{
	if ($_SESSION[$strTableName."_SelectedSQL"]!="" && @$_REQUEST["records"]=="") 
	{
		$strSQL = $_SESSION[$strTableName."_SelectedSQL"];
		$strWhereClause=@$_SESSION[$strTableName."_SelectedWhere"];
	}
	else
	{
		$strWhereClause=@$_SESSION[$strTableName."_where"];
		$strSQL=gSQLWhere($strWhereClause);
	}
	$strOrderBy=$_SESSION[$strTableName."_order"];
	if(!$strOrderBy)
		$strOrderBy=$gstrOrderBy;
	$strSQL.=" ".trim($strOrderBy);
//	order by
	$strOrderBy=$_SESSION[$strTableName."_order"];
	if(!$strOrderBy)
		$strOrderBy=$gstrOrderBy;
	$strSQL.=" ".trim($strOrderBy);
		$numrows=gSQLRowCount($strWhereClause,0);
}

$strSQLbak = $strSQL;
if(function_exists("BeforeQueryView"))
	BeforeQueryView($strSQL,$strWhereClause);
if($strSQLbak == $strSQL)
	$strSQL=gSQLWhere($strWhereClause);

if(!$all)
{
	LogInfo($strSQL);
	$rs=db_query($strSQL,$conn);
}
else
{
//	 Pagination:

	$nPageSize=0;
	if(@$_REQUEST["records"]=="page" && $numrows)
	{
		$mypage=(integer)@$_SESSION[$strTableName."_pagenumber"];
		$nPageSize=(integer)@$_SESSION[$strTableName."_pagesize"];
		if($numrows<=($mypage-1)*$nPageSize)
			$mypage=ceil($numrows/$nPageSize);
		if(!$nPageSize)
			$nPageSize=$gPageSize;
		if(!$mypage)
			$mypage=1;

		$strSQL.=" limit ".(($mypage-1)*$nPageSize).",".$nPageSize;
	}
	$rs=db_query($strSQL,$conn);
}

$data=db_fetch_array($rs);

$out="";
$first=true;

$templatefile="";

while($data)
{


	$xt->assign("show_key1", htmlspecialchars(GetData($data,"AutoID", "")));

$keylink="";
$keylink.="&key1=".htmlspecialchars(rawurlencode(@$data["AutoID"]));

////////////////////////////////////////////
//	FirstName - 
	$value="";
		$value = ProcessLargeText(GetData($data,"FirstName", ""),"","",MODE_VIEW);
	$xt->assign("FirstName_value",$value);
	$xt->assign("FirstName_fieldblock",true);
////////////////////////////////////////////
//	Split1Place - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Split1Place", ""),"","",MODE_VIEW);
	$xt->assign("Split1Place_value",$value);
	$xt->assign("Split1Place_fieldblock",true);
////////////////////////////////////////////
//	Split1 - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Split1", ""),"","",MODE_VIEW);
	$xt->assign("Split1_value",$value);
	$xt->assign("Split1_fieldblock",true);
////////////////////////////////////////////
//	Split2Place - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Split2Place", ""),"","",MODE_VIEW);
	$xt->assign("Split2Place_value",$value);
	$xt->assign("Split2Place_fieldblock",true);
////////////////////////////////////////////
//	Split2 - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Split2", ""),"","",MODE_VIEW);
	$xt->assign("Split2_value",$value);
	$xt->assign("Split2_fieldblock",true);
////////////////////////////////////////////
//	LastName - 
	$value="";
		$value = ProcessLargeText(GetData($data,"LastName", ""),"","",MODE_VIEW);
	$xt->assign("LastName_value",$value);
	$xt->assign("LastName_fieldblock",true);
////////////////////////////////////////////
//	OverallPlace - 
	$value="";
		$value = ProcessLargeText(GetData($data,"OverallPlace", ""),"","",MODE_VIEW);
	$xt->assign("OverallPlace_value",$value);
	$xt->assign("OverallPlace_fieldblock",true);
////////////////////////////////////////////
//	BibNum - 
	$value="";
		$value = ProcessLargeText(GetData($data,"BibNum", ""),"","",MODE_VIEW);
	$xt->assign("BibNum_value",$value);
	$xt->assign("BibNum_fieldblock",true);
////////////////////////////////////////////
//	Age - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Age", ""),"","",MODE_VIEW);
	$xt->assign("Age_value",$value);
	$xt->assign("Age_fieldblock",true);
////////////////////////////////////////////
//	Sex - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Sex", ""),"","",MODE_VIEW);
	$xt->assign("Sex_value",$value);
	$xt->assign("Sex_fieldblock",true);
////////////////////////////////////////////
//	City - 
	$value="";
		$value = ProcessLargeText(GetData($data,"City", ""),"","",MODE_VIEW);
	$xt->assign("City_value",$value);
	$xt->assign("City_fieldblock",true);
////////////////////////////////////////////
//	State - 
	$value="";
		$value = ProcessLargeText(GetData($data,"State", ""),"","",MODE_VIEW);
	$xt->assign("State_value",$value);
	$xt->assign("State_fieldblock",true);
////////////////////////////////////////////
//	Time - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Time", ""),"","",MODE_VIEW);
	$xt->assign("Time_value",$value);
	$xt->assign("Time_fieldblock",true);
////////////////////////////////////////////
//	Pace - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Pace", ""),"","",MODE_VIEW);
	$xt->assign("Pace_value",$value);
	$xt->assign("Pace_fieldblock",true);
////////////////////////////////////////////
//	Division - 
	$value="";
		$value = ProcessLargeText(GetData($data,"Division", ""),"","",MODE_VIEW);
	$xt->assign("Division_value",$value);
	$xt->assign("Division_fieldblock",true);
////////////////////////////////////////////
//	DivisionPlace - 
	$value="";
		$value = ProcessLargeText(GetData($data,"DivisionPlace", ""),"","",MODE_VIEW);
	$xt->assign("DivisionPlace_value",$value);
	$xt->assign("DivisionPlace_fieldblock",true);
////////////////////////////////////////////
//	DivisionTotal - 
	$value="";
		$value = ProcessLargeText(GetData($data,"DivisionTotal", ""),"","",MODE_VIEW);
	$xt->assign("DivisionTotal_value",$value);
	$xt->assign("DivisionTotal_fieldblock",true);
////////////////////////////////////////////
//	SexPlace - 
	$value="";
		$value = ProcessLargeText(GetData($data,"SexPlace", ""),"","",MODE_VIEW);
	$xt->assign("SexPlace_value",$value);
	$xt->assign("SexPlace_fieldblock",true);
////////////////////////////////////////////
//	SexTotal - 
	$value="";
		$value = ProcessLargeText(GetData($data,"SexTotal", ""),"","",MODE_VIEW);
	$xt->assign("SexTotal_value",$value);
	$xt->assign("SexTotal_fieldblock",true);

$body=array();
$body["begin"]="";

$xt->assignbyref("body",$body);
$xt->assign("style_block",true);
$xt->assign("stylefiles_block",true);

//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//Next Prev button
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////    
if(!@$_SESSION[$strTableName."_noNextPrev"])
{
	$where_next=$where_prev="";
	$order_next=$order_prev="";
	$arrFieldForSort=array();
	$arrHowFieldSort=array();
	$where=$_SESSION[$strTableName."_where"];
		if(GetFieldIndex("AutoID"))
			$key[]=GetFieldIndex("AutoID");
//if session mass sorting empty, then create it as a sheet
	if(@$_SESSION[$strTableName."_arrFieldForSort"] && @$_SESSION[$strTableName."_arrHowFieldSort"])
	{
		$arrFieldForSort=$_SESSION[$strTableName."_arrFieldForSort"];
		$arrHowFieldSort=$_SESSION[$strTableName."_arrHowFieldSort"];
		$lenArr=count($arrFieldForSort);
	}
	else
	{
		if(count($g_orderindexes))
		{
			for($i=0;$i<count($g_orderindexes);$i++)
			{
				$arrFieldForSort[]=$g_orderindexes[$i][0];
				$arrHowFieldSort[]=$g_orderindexes[$i][1];
			}
		}
		elseif($gstrOrderBy!='')
			$_SESSION[$strTableName."_noNextPrev"] = 1;
		if(count($key))
		{
			for($i=0;$i<count($key);$i++)
			{
				$idsearch=array_search($key[$i],$arrFieldForSort);
				if($idsearch===false)
				{
					$arrFieldForSort[]=$key[$i];
					$arrHowFieldSort[]="ASC";
				}
			}
		}
		$_SESSION[$strTableName."_arrFieldForSort"]=$arrFieldForSort;
		$_SESSION[$strTableName."_arrHowFieldSort"]=$arrHowFieldSort;
		$lenArr=count($arrFieldForSort);
	}
//if session order by empty, then create a line order		
	if(@$_SESSION[$strTableName."_order"]) 
		$order_next=$_SESSION[$strTableName."_order"];
	elseif($lenArr>0)
	{
		for($i=0;$i<$lenArr;$i++)
			$order_next .=(GetFieldByIndex($arrFieldForSort[$i]) ? ($order_next!="" ? ", " : " ORDER BY ").$arrFieldForSort[$i]." ".$arrHowFieldSort[$i] : "");
	}
//create a line where and order for the two queries
	if($lenArr>0 and count($key) and !$_SESSION[$strTableName."_noNextPrev"])
	{
		if($where)
			$where .=" and ";
		$scob="";
		$flag=0;
		for($i=0;$i<$lenArr;$i++)
		{
			$fieldName=GetFieldByIndex($arrFieldForSort[$i]);
			if($fieldName)
			{
				$order_prev .=($order_prev!="" ? ", " : " ORDER BY ").$arrFieldForSort[$i].($arrHowFieldSort[$i]=="ASC" ? " DESC" : " ASC");
				$dbg=GetFullFieldName($fieldName);
				if(!is_null($data[$fieldName]))
				{
					$mdv=make_db_value($fieldName,$data[$fieldName]);
					$ga=($arrHowFieldSort[$i]=="ASC" ? ">" : "<");
					$gd=($arrHowFieldSort[$i]=="ASC" ? "<" : ">");
					$gasc=$dbg.$ga.$mdv;
					$gdesc=$dbg.$gd.$mdv;
					$gravn=($i!=$lenArr-1 ? $dbg."=".$mdv : "");
					$ganull=($ga=="<" ? " or ".$dbg." IS NULL" : "");
					$gdnull=($gd=="<" ? " or ".$dbg." IS NULL" : "");
				}
				else{
						$gasc=($arrHowFieldSort[$i]=="ASC" ? $dbg." IS NOT NULL" : "");
						$gdesc=($arrHowFieldSort[$i]=="ASC" ? "" : $dbg." IS NOT NULL");
						$gravn=($i!=$lenArr-1 ? $dbg." IS NULL" : "");
						$ganull=$gdnull="";
					}
				$where_next .=($where_next!="" ? " and (" : " (").($gasc=="" && $gravn=="" ? " 1=0 " : ($gasc!="" ? $gasc.$ganull : "").($gasc!="" && $gravn!="" ? " or " : "").$gravn." ");
				$where_prev .=($where_prev!="" ? " and (" : " (").($gdesc=="" && $gravn=="" ? " 1=0 " : ($gdesc!="" ? $gdesc.$gdnull : "").($gdesc!="" && $gravn!="" ? " or " : "").$gravn." ");
				$scob .=")";
			}
			else $flag=1;
		}
		$where_next =$where_next.$scob;
		$where_prev =$where_prev.$scob;
		$where_next=whereAdd($where_next,SecuritySQL("Search"));
		$where_prev=whereAdd($where_prev,SecuritySQL("Search"));
		if($flag==1)
		{
			$order_next="";
			for($i=0;$i<$lenArr;$i++)
				$order_next .=(GetFieldByIndex($arrFieldForSort[$i]) ? ($order_next!="" ? ", " : " ORDER BY ").$arrFieldForSort[$i]." ".$arrHowFieldSort[$i] : "");
		}
		$sql_next=gSQLWhere($where.$where_next).$order_next;
		$sql_prev=gSQLWhere($where.$where_prev).$order_prev;
		if($where_next!="" and $order_next!="" and $where_prev!="" and $order_prev!="")
		{
					$sql_next.=" limit 1";
			$sql_prev.=" limit 1";
		
			$res_next=db_query($sql_next,$conn);		
			if($row_next=db_fetch_array($res_next))
			{
				$next[1]=$row_next["AutoID"];
			}
			
			$res_prev=db_query($sql_prev,$conn);	
			if($row_prev=db_fetch_array($res_prev))
			{
				$prev[1]=$row_prev["AutoID"];
			}
		}	
	}
}	
////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////	  
if(!$pdf && !$all)
{
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
    $nextlink=$prevlink="";
	if(count($next))
    {
		$xt->assign("next_button",true);
	 		$nextlink .="editid1=".htmlspecialchars(rawurlencode($next[1]));
		$xt->assign("nextbutton_attrs","onclick=\"window.location.href='09GoldenSneaker5K_view.php?".$nextlink."'\"");
	}
	else 
		$xt->assign("next_button",false);	
	if(count($prev))
	{
		$xt->assign("prev_button",true);
			$prevlink .="editid1=".htmlspecialchars(rawurlencode($prev[1]));
		$xt->assign("prevbutton_attrs","onclick=\"window.location.href='09GoldenSneaker5K_view.php?".$prevlink."'\"");
	}
    else 
		$xt->assign("prev_button",false);
//////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
	$xt->assign("back_button",true);
	$xt->assign("backbutton_attrs","onclick=\"window.location.href='09GoldenSneaker5K_list.php?a=return'\"");
}

$oldtemplatefile=$templatefile;
$templatefile = "09GoldenSneaker5K_view.htm";
if(!$all)
{
	if(function_exists("BeforeShowView"))
		BeforeShowView($xt,$templatefile,$data);
	if(!$pdf)
		$xt->display($templatefile);
	break;
}

}


?>