<?
require_once('admin/tmpl.php');
require_once('admin/dbconnect.php');


$show = $_GET['show'];

if (!$show) {
	$show = "list";
}


///////////////////////
//	Show List	   //
//	 of Names	   //
///////////////////////

if ($show == "list" || 
	$show == "listunusual" || 
    $show == "listman" ||
    $show == "listwoman" ||
    $show == "listplaces" ||
    $show == "listhebrew" ||
    $show == "listgreek" || 
    $show == "listoldtestament" || 
    $show == "listnewtestament"
    ) {
	$tab = $_GET['tab'];
	if (!$tab) { $tab = "A"; }

	if ( $show == "listman" ||
    $show == "listwoman" ||
    $show == "listplaces" ||
    $show == "listhebrew" ||
    $show == "listgreek" || 
    $show == "listoldtestament" || 
    $show == "listnewtestament" ) 
    {
    
    	$filtering=TRUE;
    
    	switch($show) {
        
        case 'listman':
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_man = '1' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_man = '1' ORDER BY names_name",$db);

		}
        break;
            
        case 'listwoman':
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_woman = '1' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_woman = '1' ORDER BY names_name",$db);

		}
        break;
        
        case 'listplaces':
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_places = '1' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_places = '1' ORDER BY names_name",$db);

		}
        break;
        
        case 'listhebrew':
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_hebrew = '1' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_hebrew = '1' ORDER BY names_name",$db);

		}
        break;
        
        case 'listgreek':
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_greek = '1' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_greek = '1' ORDER BY names_name",$db);

		}
        break;
        
        case 'listoldtestament':
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_oldtestament = '1' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_oldtestament = '1' ORDER BY names_name",$db);

		}
        break;     
        
        case 'listnewtestament':
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_newtestament = '1' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_newtestament = '1' ORDER BY names_name",$db);

		}
        break;   
        
        default:
        break;
        }
    }
    else
    {
	if ($show == "listunusual") {
		$unusualtype = "1";
	} else {
		$unusualtype = "0";
	}
		if ( $tab == "ALL") {
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_unusual = '$unusualtype' ORDER BY names_name",$db);

		} else {
			$reg = strtoupper($tab) . strtolower($tab);
			$result_o = mysql_query("SELECT * FROM bnames_names WHERE names_name REGEXP '^[$reg]' AND names_unusual = '$unusualtype' ORDER BY names_name",$db);

		}
    }


	if (mysql_num_rows($result_o)) {
		require_once($se_location . 'functions/getnames.php');
	}


	if (!$index) {
		if ($tab == "ALL") {
			$nomsg = "No Entries in the Database at the moment.";
		} else {
			$nomsg = "No Entries in the Database for <B>'" . strtoupper($tab) . "'</B> at the moment.";
		}		
	}
}


///////////////////////
//  Show Individual  //
//       Names	     //
///////////////////////

if ($show == "name") {

	$nameID = $_GET['id'];
	if (!$nameID) {
		header("Location: " . $_SERVER['PHP_SELF']);
		exit;
	}

	if ( is_numeric($nameID) ) {
		$result = mysql_query("SELECT * FROM bnames_names WHERE names_id = '$nameID' LIMIT 1",$db);
	} else {
		$result = mysql_query("SELECT * FROM bnames_names WHERE names_name = '$nameID' LIMIT 1",$db);

		if (!mysql_affected_rows()) {
			$result_d = mysql_query("SELECT * FROM bnames_derives WHERE derives_name = '$nameID' LIMIT 1",$db);

			while( $list = mysql_fetch_array($result_d) ) {
				$result_dID = $list["derives_name_id"];
				
				$table["id"] = $list["derives_id"];
				$table["name"] = ucfirst($list["derives_name"]);
		        $table["gender"] = $list["derives_gender"];
                if($list["derives_meaning"]!='') $table["meaning"] = str_replace("<br>", "<br />", trim($list["derives_meaning"]));
                if($list["derives_history"]!='')  $table["history"] = str_replace("<br>", "<br />", trim($list["derives_history"]));

				$result = mysql_query("SELECT * FROM bnames_names WHERE names_id = '$result_dID' LIMIT 1",$db);
			}
			
			$is_derive = "1";
		} else {
      $is_derive = "0";
    }
	}
  
	if (!mysql_affected_rows()) {
		header("Location: " . $_SERVER['PHP_SELF']);
		exit;
	}

	while( $list = mysql_fetch_array($result) ) {

    if ( $is_derive == "0" ) {
       $table["id"] = $list["names_id"];
		   $table["name"] = ucfirst($list["names_name"]);
		   $table["gender"] = $list["names_gender"];
		} else {
       $table["original"]["id"] = $list["names_id"];
		   $table["original"]["name"] = ucfirst($list["names_name"]);
		   $table["original"]["gender"] = $list["names_gender"];
		}

		$list["names_meaning"] = trim($list["names_meaning"]);
		$list["names_history"] = trim($list["names_history"]);
		if(!isset($table["meaning"])) $table["meaning"] = str_replace("<br>", "<br />", $list["names_meaning"]);
		if(!isset($table["history"])) $table["history"] = str_replace("<br>", "<br />", $list["names_history"]);
		
    if ( $is_derive == "1" ) {
      $result_d = mysql_query("SELECT * FROM bnames_derives WHERE derives_name_id = '" .$list["names_id"] . "' AND derives_id != '" .$table["id"]. "' ORDER BY derives_name",$db);
    } else {
      $result_d = mysql_query("SELECT * FROM bnames_derives WHERE derives_name_id = '" .$list["names_id"] . "' ORDER BY derives_name",$db);
    }

		$i = 0;
		while( $list = mysql_fetch_array($result_d) ) {
			$table["derives"][$i]["derives_name"] = ucfirst($list["derives_name"]);
			$table["derives"][$i]["derives_id"] = $list["derives_id"];
			$table["derives"][$i]["derives_gender"] = $list["derives_gender"];
			$i++;
		}

		if($table["derives"]){
			sort($table["derives"]);
			reset($table["derives"]);
		}

	}

}

///////////////////////
//	 List A-Z      //
//	Name Links	   //
///////////////////////

function fn_names_menu () {
	global $show, $tab;
 
	$data = '';

	for ($i = A; $i!="AA" ; $i++) {
		if( strtoupper($tab) == $i ) {
			$data .= "<u>$i</u>\n";
		} else {
			$data .= "<a href=\"" . $_SERVER['PHP_SELF'] . "?show=$show&amp;tab=$i&amp;page=1\">$i</a>\n";
		}
	}

	if( strtoupper($tab) == "ALL" ) {
		$data .= "<u>ALL</u>";
	} else {
		$data .= "<a href=\"" . $_SERVER['PHP_SELF'] . "?show=$show&amp;tab=ALL&amp;page=1\">ALL</a>";
	}

	return $data;
}


///////////////////////
//	Define Box	   //
//	  Headers	   //
///////////////////////

if ($show == "list" || 
	$show == "listunusual" || 
    $show == "listman" ||
    $show == "listwoman" ||
    $show == "listplaces" ||
    $show == "listhebrew" ||
    $show == "listgreek" || 
    $show == "listoldtestament" || 
    $show == "listnewtestament"
    ) {

	if ($show == "listunusual") {
		$mainbox_title = "Browse Unusual Baby Names A-Z";
	} else {
		$mainbox_title = "Browse Baby Names A-Z";
	}

} elseif ($show == "name") {
		$mainbox_title = "Name Meaning and Biblical Context of " .$table["name"];
		$html_title = $table["name"];
		$html_metakey = $table["name"];
		$html_metadescription="Meaning of baby name ".$table["name"].", Definition of ".$table["name"].", What does baby name ".$table["name"]." mean? Origin of ".$table["name"].". Pronunciation of ".$table["name"].". Who was ".$table["name"]." in the bible?";

}


///////////////////////
//	HTML Stuffs	   //
//	    Here	   //
///////////////////////


include('admin/tmpl_header.php');
include('admin/tmpl_extraboxes.php');

echo $mainbox_start;


	if ($show == "list" || 
	$show == "listunusual" || 
    $show == "listman" ||
    $show == "listwoman" ||
    $show == "listplaces" ||
    $show == "listhebrew" ||
    $show == "listgreek" || 
    $show == "listoldtestament" || 
    $show == "listnewtestament"
    ) {

		echo "<div class=\"name_table\">\n\n".
			"	<div class=\"name_menu\">\n".
			"	" .fn_names_menu(). "\n".
			"	</div>\n\n";

			require('_names_list.php');

		echo "</div>";

	} elseif ($show == "name") {
		require('_names_show.php');
	}


echo $mainbox_end;


	mysql_close($db);

include('admin/tmpl_footer.php');
?>