--- trunk/page_print.phtml	2004/03/04 22:43:50	42
+++ trunk/page_print.phtml	2004/03/18 20:33:37	72
@@ -19,7 +19,7 @@
 
 	// If stats are enabled, add a hit to the page load statistics
 	if ($libstats == 1) {
-		pageLoadStats($con, $page_id);
+		pageLoadStats($page_id);
 	}
 
 
@@ -32,8 +32,8 @@
 	// Debugging
 	// printf("sql was: %s<BR>", $sql);
 
-	$rs = xx_query($sql, $con);
-	$row = xx_fetch_array ($rs);
+	$rs = xx_tryquery($sql);
+	$row = xx_fetch_array ($rs, xx_ASSOC);
 	
 	// Fetch data
 	$pagetype_id = $row["pagetype_id"];	
@@ -94,8 +94,8 @@
 	**********************************************/
 	
 	if ($pagetype_id == 3) {
-		displayCourseHeader($con, $page_id, $pagetitle_style);
-		displayCoursePers($con, $page_id);
+		displayCourseHeader($page_id, $pagetitle_style);
+		displayCoursePers($page_id);
 
 		// Display HR 		
 		printf("<hr><br>\n");
@@ -125,7 +125,7 @@
 	** Display Table of Contents **
 	******************************/
 	if ($display_toc == 1) {
-		displayTOC($con, $page_id, $wrap_toc);
+		displayTOC($page_id, $wrap_toc);
 	}
 
 
@@ -144,6 +144,7 @@
 
 	$sql = "SELECT * FROM element e
 		LEFT JOIN resource r using (resource_id)
+		LEFT JOIN vendor d on r.vendor_id = d.vendor_id			
 		LEFT JOIN service v on e.service_id = v.service_id
 		LEFT JOIN location l on e.location_id = l.location_id
 		LEFT JOIN staff s on e.staff_id = s.staff_id
@@ -151,9 +152,9 @@
 		WHERE page_id = " . $page_id
 		. " ORDER BY e.element_order";
 
-	$rs = xx_query($sql, $con);
+	$rs = xx_tryquery($sql);
 
-	while ($row = xx_fetch_array ($rs)) {
+	while ($row = xx_fetch_array ($rs, xx_ASSOC)) {
 
 		// General element information
 		$element_id = $row["element_id"];
@@ -173,6 +174,12 @@
 		$title = $row["title"];
 		$call_no = $row["call_no"];
 		
+		$guide_url = $row["guide_url"];
+		$resource_message = $row["resource_message"];
+		$resource_status = $row["resource_status"];
+		$vendor_message = $row["vendor_message"];
+		$vendor_status = $row["vendor_status"];			
+		
 		// If a location
 		$location_id = $row["location_id"];
 		$location = $row["location"];
@@ -344,12 +351,20 @@
 		printf ("%s", $item_display);
 
 		// If a span class is being used, close it now
-		if ($element_size > 0) printf ("</span>\n");		
-
+		if ($element_size > 0) printf ("</span>\n");
 
 		// Display URL if toggled and available
 		if (strlen($printable_url) > 0 && $display_urls == 1) printf("<BR>%s\n", $printable_url);
 
+		// Handle down/alert messages
+		if ($vendor_status > 0 || $resource_status > 0) {
+
+			printf("<br><img src =\"images/chain.jpg\" alt=\"Resource Temporarily Unavailable\">\n");
+			printf("<span class=\"error\">\n");
+			if (strlen($vendor_message) > 1) printf("%s\n", $vendor_message);
+			else if (strlen($resource_message) > 1) printf("%s\n", $resource_message);
+			printf("</span>\n");
+		}
 		
 		// Display description
 		if (strlen($item_descr) > 0) printf("<BR>%s\n", $item_descr);
@@ -389,8 +404,8 @@
 
 	// Display page coordinator
 	if ($staff_coordinator > 0) {
-		$display_page_coord = lookupStaff($con, $staff_coordinator);
-		$staff_email = lookupField($con, "staff", "staff_id", $staff_coordinator, "staff_email");
+		$display_page_coord = lookupStaff($staff_coordinator);
+		$staff_email = lookupField("staff", "staff_id", $staff_coordinator, "staff_email");
 	
 		if (strlen($display_page_coord) > 0 && strlen($staff_email) > 0) {
 			printf("<span class=\"S5\">\n");