<?php  
$full_path = $_SERVER['REQUEST_URI'];
$script = $_SERVER['SCRIPT_NAME'];
$fixed_path = ereg_replace("^$script","",$full_path);// remove script name from path
$path_arr = explode("/", $fixed_path);

$external_intro = "There is a wealth of valuable resources on the net - it's all a matter of being able to find them. This is a categorized collection of web design resources I've found useful. Ten random entries appear below.";

function fix_spaces($string,$mode)
  {
  $fix_char = "_";
  switch($mode)
	{
	case "removespaces": return str_replace(" ", $fix_char, $string);
	case "addspaces": return str_replace($fix_char, " ", $string);
	case "nbsp": return str_replace(" ", "&nbsp;", $string);
	}
  }
 
/*
FOR CATEGORIES
/externals/categoryname
*/
 
$category = $path_arr[1];

$title = "WebFu Externals";
$tagline = "External Links";
include "begin.php";

require "connect.php";
if (isset($category))
	{
	echo "\n<div id=\"main\" class=\"ext_cat\">\n";
	$fixed_category = fix_spaces($category, "addspaces");
	echo "<div id=\"side\">";
	echo "<div id=\"side_h\"></div>";
	echo "<h4>$fixed_category Externals</h4>";
	echo "</div> <!-- end body leftcol -->\n";
	
	//List all externals in this category
	$result = mysql_query("select external_name, external_url, external_comment from externals where external_category = '$fixed_category' order by external_name") or die(mysql_error());
	echo "<div id=\"body_main\">";
	echo "<dl>\n";
	while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
		{
		echo "<dt><a href=\"{$row['external_url']}\">{$row['external_name']}</a></dt>";
		echo "<dd>{$row['external_comment']}</dd>";
		}
	echo "</dl>\n";
	echo "</div> <!-- end body main -->\n";
	}
else
	{
	echo "\n<div id=\"main\" class=\"ext_list\">\n";
	//Main externals page
	//List external categories
	$result = mysql_query("select distinct external_category from externals order by external_category") or die(mysql_error());
	echo "<div id=\"side\">";
	echo "<div id=\"side_h\"></div>";
	echo "<h4>Categories</h4>\n";
	echo "<ul>\n";
	while($categ = mysql_fetch_array($result,MYSQL_NUM)) 
		{
		$fixed_category = fix_spaces($categ[0], "removespaces");
		$nbsp_category = fix_spaces($categ[0], "nbsp");
		echo "<li><a href=\"$script/$fixed_category\">$nbsp_category</a></li>\n";
		}
	echo "</ul>\n";
	echo "</div> <!-- end body rightcol -->\n";
	
	//Get ten random externals
	$sql = "select external_name, external_url, external_comment from externals order by rand() limit 10";
	$result = mysql_query($sql) or die(mysql_error());
	
	echo "<div id=\"body_main\">\n";
	echo "<p class=\"intro\">$external_intro</p>\n";
	echo "<dl>\n";
	while($row = mysql_fetch_array($result,MYSQL_ASSOC)) 
		{
		echo "<dt><a href=\"{$row['external_url']}\">{$row['external_name']}</a></dt>\n";
		echo "<dd>{$row['external_comment']}</dd>\n";
		}
	echo "</dl>\n";
	echo "</div> <!-- end body main -->\n";
	}

echo "\n</div> <!-- end main -->\n";
include "end.php"; 
?>