<?php // Redirect to Main PBO web pages
	  // Send to main PBO index file
	  // DEVELOPER ------------ DATE --------------------- MODIFICATION NOTES
	  //--------------------------------------------------------------------
	  // Eliot Lee              09/15/04                   Initial Coding
	  // Eliot Lee              09/20/04                   Check for Alt URL, go there if exists
	  // Eliot Lee              11/01/04                   Changed pgsql connection to persistent - pg_pconnet
	  // Eliot Lee              01/12/05                   Added error checking codes if page does not exist in database
	  // Eliot Lee              02/16/05                   Added additional error checking, cannot connect to database server, dies
	  // Eliot Lee              07/06/05                   Removed constant vars, conflict with main website constant vars of SCRIPT_TITLE and VERSION
	  // Eliot Lee              04/07/06     			   Added page_active in WHERE clause to make sure that only active pages load
	  //--------------------------------------------------------------------
	  if (file_exists('../global_settings.php')) {
	  	  require_once('../global_settings.php');
		  if (is_numeric($_REQUEST['pageid'])) {
		  		$pageid = $_REQUEST['pageid'];
		  		$db_link = pg_pconnect($pg_connect_string) or die('Cannot connect to database server.');
					$query = "SELECT * FROM webcommon_view WHERE (pageid =" . $pageid . ") AND (page_active = 1)";
					$result = pg_exec($db_link, $query);
					if (!$result) {
						 header("Location: " . $main_url . "?pageid=" . $pageid);
					}
					else {
						$numrows = pg_numrows($result);
						$row     = 0;
						if ($numrows > 0) {
							  for ($row = 0; $row < pg_numrows($result); $row++) {
							  		$page_url    = pg_result($result, $row, 'page_alt_url');
									if ($page_url <> "") {
									  	header("Location:  $page_url");
									}
									else {
							  		  	header("Location: " . $main_url . "?pageid=" . $pageid);
									}
						  	}
						}
						else {
							 header("Location: " . $main_url);
						}
					}
				pg_close($db_link);
	  	  }
		  else {
		        header("Location: " . $main_url);
		  }
	  }
	  else {
	  	   header("Location: " . $main_url);
	  }
?>