File: index.php

package info (click to toggle)
opendb 0.81p18-2
links: PTS
area: main
in suites: etch, etch-m68k
size: 4,716 kB
ctags: 6,787
sloc: php: 50,213; sql: 3,098; sh: 272; makefile: 54; xml: 48
file content (1923 lines) | stat: -rw-r--r-- 80,825 bytes
<?php
/*
 	OpenDb - Open Media Lending Database
	Copyright (C) 2001,2002 by Jason Pell

	This program is free software; you can redistribute it and/or
	modify it under the terms of the GNU General Public License
	as published by the Free Software Foundation; either version 2
	of the License, or (at your option) any later version.

	This program is distributed in the hope that it will be useful,
	but WITHOUT ANY WARRANTY; without even the implied warranty of
	MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
	GNU General Public License for more details.

	You should have received a copy of the GNU General Public License
	along with this program; if not, write to the Free Software
	Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA  02111-1307, USA.
*/
include_once("./functions/datetime.php");
include_once("./functions/item_type.php");
include_once("./functions/item_type_group.php");
include_once("./functions/import.php");
include_once("./admin/s_item_type/functions.php");
include_once("./admin/s_attribute_type/functions.php");

function display_edit_site_plugin($record_r, $HTTP_VARS=NULL)
{
	if(is_array($record_r))
		echo get_input_field('site_type', NULL, 'Site Type', 'readonly', 'Y', $record_r['site_type']);
	else
		echo get_input_field('site_type', NULL, 'Site Type', 'text(10,10)', 'Y', $record_r['site_type']);

	echo get_input_field('classname', NULL, 'Class Name', 'text(50,50)', 'Y', $record_r['classname']);

	echo get_input_field('title', NULL, 'Title', 'text(25,50)', 'Y', $record_r['title']);

	$field = get_input_field('image', NULL, 'Image', 'url(25,*,"gif,jpg,png",N)', 'N', $record_r['image'], FALSE, NULL, 'if(this.value.length>0){document.images[\'s_site_plugin_image\'].src=\'./site/images/\'+this.value;}else{document.images[\'s_site_plugin_image\'].src=\'./admin/s_site_plugin/spacer.gif\';}');

	if(strlen($record_r['image'])>0)
		$image_src = "./site/images/".$record_r['image'];

	if($image_src!==FALSE && strlen($image_src)>0 && file_exists($image_src))
		$field .= " <img align=absmiddle valign=absmiddle src=\"".$image_src."\" name=\"s_site_plugin_image\">";
	else
		$field .= " <img align=absmiddle valign=absmiddle src=\"./admin/s_site_plugin/spacer.gif\" name=\"s_site_plugin_image\">";
	echo format_field('Image', NULL, $field);

	echo get_input_field('description', NULL, 'Description', 'text(50,255)', 'Y', $record_r['description']);
	echo get_input_field('external_url', NULL, 'External URL', 'text(50,255)', 'Y', $record_r['external_url']);
	echo get_input_field('more_info_url', NULL, 'More Info URL', 'text(50,255)', 'N', $record_r['more_info_url']);
	echo get_input_field('items_per_page', NULL, 'Items Per Page', 'number(3)', 'N', $record_r['items_per_page']);
}

function display_site_plugin_conf_row($record_r, $row)
{
	if(is_not_empty_array($record_r))
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"Y\">");
		echo("<td class=\"data\">".get_input_field("name[$row]", NULL, "Name", "readonly", "Y", $record_r['name'], FALSE)."</td>");
		echo("<td class=\"data\">".get_input_field("keyid[$row]", NULL, "Key ID", "readonly", "Y", $record_r['keyid'], FALSE)."</td>");
	}
	else
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"N\">");
		echo("<td class=\"data\">".get_input_field("name[$row]", NULL, "Name", "text(20,50)", "Y", $record_r['name'], FALSE)."</td>");
		echo("<td class=\"data\">".get_input_field("keyid[$row]", NULL, "Key ID", "text(10,50)", "Y", $record_r['keyid'], FALSE)."</td>");
	}

	echo("<td class=\"data\">".get_input_field("description[$row]", NULL, "Description", "text(20,255)", 'N', $record_r['description'], FALSE)."</td>");
	echo("<td class=\"data\">".get_input_field("value[$row]", NULL, "Value", "text(20,255)", "Y", $record_r['value'], FALSE)."</td>");

	echo("\n<td class=\"data\">");
	if(is_not_empty_array($record_r))
	{
		echo("<input type=button onclick=\"".
			"document.forms['navigate'].name.value=this.form['name[$row]'].value; ".
			"document.forms['navigate'].keyid.value=this.form['keyid[$row]'].value; ".
			"document.forms['navigate'].op.value='delete_site_plugin_conf'; ".
			"document.forms['navigate'].submit();\" value=\"Delete\">");
	}
	else
	{
		echo("&nbsp;");
	}
	echo("\n</td>");
}

function display_site_plugin_link_row($record_r, $row)
{
	if(is_not_empty_array($record_r))
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"Y\">");
		echo("<input type=hidden name=\"sequence_number[$row]\" value=\"".$record_r['sequence_number']."\">");
	}
	else
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"N\">");
	}

	echo("<td class=\"data\">".get_input_field("order_no[$row]", NULL, "Order No", "number(3)", "Y", $record_r['order_no'], FALSE)."</td>");

	$item_type_groups[] = '*';
	$results = fetch_item_type_group_rs('Y');
	if($results)
	{
		while($item_type_group_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$item_type_groups[] = $item_type_group_r['s_item_type_group'];
		}
		mysql_free_result($results);
	}

	echo ("\n<td class=\"data\" align=center>".format_field(NULL, NULL, custom_select("s_item_type_group[$row]", $item_type_groups, "%value%", 1, is_array($record_r)?$record_r['s_item_type_group']:'*', 'value', NULL, NULL, "if(this.options[this.options.selectedIndex].value != '*'){this.form['s_item_type[$row]'].options[0].selected=true;}"), FALSE)."</td>");

	$item_types[] = '*';
	$results = fetch_item_type_rs();
	if($results)
	{
		while($item_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$item_types[] = $item_type_r['s_item_type'];
		}
		mysql_free_result($results);
	}
	echo ("\n<td class=\"data\" align=center>".format_field(NULL, NULL, custom_select("s_item_type[$row]", $item_types, "%value%", 1, is_array($record_r)?$record_r['s_item_type']:NULL, 'value', NULL, NULL, "if(this.options[this.options.selectedIndex].value != '*'){this.form['s_item_type_group[$row]'].options[0].selected=true;}"), FALSE)."</td>");

	echo("<td class=\"data\">".get_input_field("description[$row]", NULL, "Description", "text(20,255)", 'N', $record_r['description'], FALSE)."</td>");
	echo("<td class=\"data\">".get_input_field("url[$row]", NULL, "URL", "text(20,255)", 'N', $record_r['url'], FALSE)."</td>");
	echo("<td class=\"data\">".get_input_field("title_url[$row]", NULL, "Title URL", "text(20,255)", 'N', $record_r['title_url'], FALSE)."</td>");

	echo("\n<td class=\"data\">");
	if(is_not_empty_array($record_r))
	{
		echo("<input type=button onclick=\"".
			"document.forms['navigate'].sequence_number.value=this.form['sequence_number[$row]'].value; ".
			"document.forms['navigate'].op.value='delete_site_plugin_link'; ".
			"document.forms['navigate'].submit();\" value=\"Delete\">");
	}
	else
	{
		echo("&nbsp;");
	}
	echo("\n</td>");
}

function display_site_plugin_input_field_row($record_r, $row)
{
	if(is_not_empty_array($record_r))
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"Y\">");
		echo("<td class=\"data\">".get_input_field("order_no[$row]", NULL, "Order No", "number(3)", "Y", $record_r['order_no'], FALSE)."</td>");
		echo("<td class=\"data\">".get_input_field("field[$row]", NULL, "Field Name", "readonly", "Y", $record_r['field'], FALSE)."</td>");
	}
	else
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"N\">");
		echo("<td class=\"data\">".get_input_field("order_no[$row]", NULL, "Order No", "number(3)", "Y", NULL, FALSE)."</td>");
		echo("<td class=\"data\">".get_input_field("field[$row]", NULL, "Field Name", "text(10,20)", "Y", NULL, FALSE)."</td>");
	}

	echo("<td class=\"data\">".get_input_field("description[$row]", NULL, "Description", "text(20,255)", 'N', $record_r['description'], FALSE)."</td>");
	echo("<td class=\"data\">".get_input_field("prompt[$row]", NULL, "URL", "text(10,30)", 'N', $record_r['prompt'], FALSE)."</td>");
	echo ("\n<td class=\"data\">".format_field(NULL, NULL, custom_select("field_type[$row]", get_legal_input_field_types(), "%value%", 1, $record_r['field_type']), FALSE)."</td>");
	echo("<td class=\"data\">".get_input_field("refresh_mask[$row]", NULL, "Refresh Mask", "text(20,255)", 'N', $record_r['refresh_mask'], FALSE)."</td>");
	echo("<td class=\"data\">".get_input_field("default_value[$row]", NULL, "Default Value", "text(7,50)", 'N', $record_r['default_value'], FALSE)."</td>");

	echo("\n<td class=\"data\">");
	if(is_not_empty_array($record_r))
	{
		echo("<input type=button onclick=\"".
			"document.forms['navigate'].field.value=this.form['field[$row]'].value; ".
			"document.forms['navigate'].op.value='delete_site_plugin_input_field'; ".
			"document.forms['navigate'].submit();\" value=\"Delete\">");
	}
	else
	{
		echo("&nbsp;");
	}
	echo("\n</td>");
}

function display_site_plugin_s_attribute_type_map_row($record_r, $row)
{
	if(is_not_empty_array($record_r))
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"Y\">");
		echo("<input type=hidden name=\"sequence_number[$row]\" value=\"".$record_r['sequence_number']."\">");
		echo("<td class=\"data\">".get_input_field("variable[$row]", NULL, "Variable", "readonly", "Y", $record_r['variable'], FALSE)."</td>");
	}
	else
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"N\">");
		echo("<td class=\"data\">".get_input_field("variable[$row]", NULL, "Variable", "text(10,20)", "Y", NULL, FALSE)."</td>");
	}

	$item_type_groups[] = '*';
	$results = fetch_item_type_group_rs('Y');
	if($results)
	{
		while($item_type_group_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$item_type_groups[] = $item_type_group_r['s_item_type_group'];
		}
		mysql_free_result($results);
	}

	// this is to avoid confusion if system data is defined for non-existent s_item_type_groups
	if(!in_array($record_r['s_item_type_group'], $item_type_groups))
		$item_type_groups[] = $record_r['s_item_type_group'];

	echo ("\n<td class=\"data\" align=center>".format_field(NULL, NULL, custom_select("s_item_type_group[$row]", $item_type_groups, "%value%", 1, $record_r['s_item_type_group'], 'value', NULL, NULL, "if(this.options[this.options.selectedIndex].value != '*'){this.form['s_item_type[$row]'].options[0].selected=true;}"), FALSE)."</td>");

	$item_types[] = '*';
	$results = fetch_item_type_rs();
	if($results)
	{
		while($item_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$item_types[] = $item_type_r['s_item_type'];
		}
		mysql_free_result($results);
	}

	// this is to avoid confusion if system data is defined for non-existent s_item_types
	if(!in_array($record_r['s_item_type'], $item_types))
		$item_types[] = $record_r['s_item_type'];

	echo ("\n<td class=\"data\" align=center>".format_field(NULL, NULL, custom_select("s_item_type[$row]", $item_types, "%value%", 1, $record_r['s_item_type'], 'value', NULL, NULL, "if(this.options[this.options.selectedIndex].value != '*'){this.form['s_item_type_group[$row]'].options[0].selected=true;}"), FALSE)."</td>");

	$attribute_types[] = '';
	$results = fetch_item_type_s_attribute_type_rs();
	if($results)
	{
		while($attribute_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$attribute_types[] = $attribute_type_r['s_attribute_type'];
		}
		mysql_free_result($results);
	}

	// this is to avoid confusion if system data is defined for non-existent s_attribute_types
	if(!in_array($record_r['s_attribute_type'], $attribute_types))
		$attribute_types[] = $record_r['s_attribute_type'];

	echo ("\n<td class=\"data\">".format_field(NULL, NULL, custom_select("s_attribute_type[$row]", $attribute_types, "%value%", 1, $record_r['s_attribute_type']), FALSE)."</td>");

	echo("\n<td class=\"data\">");
	if(is_not_empty_array($record_r))
	{
		echo("<input type=button onclick=\"".
			"document.forms['navigate'].sequence_number.value=this.form['sequence_number[$row]'].value;".
			"document.forms['navigate'].op.value='delete_site_plugin_s_attribute_type_map'; ".
			"document.forms['navigate'].submit();\" value=\"Delete\">");
	}
	else
	{
		echo("&nbsp;");
	}
	echo("\n</td>");
}

function get_lookup_attribute_type_array()
{
	$buffer = "";

	// Give us the whole s_attribute_type_lookup table, whoo baby...
	$arrayOfLookupValues = "";
	$arrayOfLookupValuesCount=0;

	$attresults = fetch_attribute_type_lookup_rs();
	while($attribute_type_r = mysql_fetch_array($attresults))
	{
		$arrayOfLookupValues .= "\narrayOfLookupValues[$arrayOfLookupValuesCount] = new LookupAttribute(\"".$attribute_type_r['s_attribute_type']."\",\"".$attribute_type_r['value']."\",\"".$attribute_type_r['value']." - ".$attribute_type_r['display']."\");";
		$arrayOfLookupValuesCount++;
	}

	$buffer .= "\n\narrayOfLookupValues = new Array($arrayOfLookupValuesCount);";
	$buffer .= $arrayOfLookupValues;

	// Now wrap and return
	return "\n<script language=\"JavaScript\">\n<!-- // hide from stupid browsers\n".
				$buffer.
				"\n// -->\n</script>\n";
}


function display_site_plugin_s_attribute_type_lookup_map_row($record_r, $row)
{
	if(is_not_empty_array($record_r))
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"Y\">");
		echo("<input type=hidden name=\"sequence_number[$row]\" value=\"".$record_r['sequence_number']."\">");
		echo("<td class=\"data\">".get_input_field("s_attribute_type[$row]", NULL, "Attribute Type", "readonly", "Y", $record_r['s_attribute_type'], FALSE)."</td>");
		echo("<td class=\"data\">".get_input_field("value[$row]", NULL, "Site Value", "readonly", "Y", $record_r['value'], FALSE)."</td>");

		$results = fetch_attribute_type_lookup_rs($record_r['s_attribute_type']);
		echo ("\n<td class=\"data\">".format_field(NULL, NULL, custom_select("lookup_attribute_val[$row]", $results, "%value% - %display%", 1, $record_r['lookup_attribute_val']), FALSE)."</td>");
	}
	else
	{
		echo("<input type=hidden name=\"exists_ind[$row]\" value=\"N\">");
		$attribute_types[] = '';
		$results = fetch_lookup_s_attribute_type_rs();
		if($results)
		{
			while($attribute_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
			{
				$attribute_types[] = $attribute_type_r['s_attribute_type'];
			}
			mysql_free_result($results);
		}
		echo ("\n<td class=\"data\">".format_field(NULL, NULL, custom_select("s_attribute_type[$row]", $attribute_types, "%value%", 1, NULL, 'value', NULL, NULL, "populateList(this.options[this.options.selectedIndex].value, this.form['lookup_attribute_val[$row]'], arrayOfLookupValues, false, null, false);"), FALSE)."</td>");
		echo("<td class=\"data\">".get_input_field("value[$row]", NULL, "Site Value", "text(20,255)", "Y", NULL, FALSE)."</td>");
		echo ("\n<td class=\"data\">".format_field(NULL, NULL, custom_select("lookup_attribute_val[$row]", array(array('value'=>'', 'display'=>'')), "%value% - %display%", 1, NULL), FALSE)."</td>");
	}

	echo("\n<td class=\"data\">");
	if(is_not_empty_array($record_r))
	{
		echo("<input type=button onclick=\"".
			"document.forms['navigate']['sequence_number'].value=this.form['sequence_number[$row]'].value;".
			"document.forms['navigate'].op.value='delete_site_plugin_s_attribute_type_lookup_map'; ".
			"document.forms['navigate'].submit();\" value=\"Delete\">");
	}
	else
	{
		echo("&nbsp;");
	}
	echo("\n</td>");
}

/**
	@param $edit_op - indicates the operation that spawned this table, will be used
	by the refresh operation.
*/
function display_edit_table($edit_op, $update_op, $headers, $display_functioname, $context_http_vars, $results)
{
	global $PHP_SELF;
	global $ADMIN_TYPE;
	global $HTTP_VARS;

	echo "<table cellspacing=2 border=0>";
	echo "\n<form name=\"editform\" action=\"$PHP_SELF\" method=\"post\">";
	echo "\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">";
	echo "\n<input type=\"hidden\" name=\"op\" value=\"$edit_op\">";
	echo get_url_fields($context_http_vars, NULL, array('op', 'type'));

	$column_count = 0;
	echo  "\n<tr>";
	for($i=0; $i<count($headers); $i++)
	{
		echo  "\n<td class=\"navbar\">".$headers[$i]."</td>";
		$column_count++;
	}
	echo  "\n</tr>";

	$row = 0;
	if($results)
	{
		while($result_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			echo  "\n<tr>";
			$display_functioname($result_r, $row);
			echo  "\n</tr>";
			$row++;
		}
		mysql_free_result($results);
	}

	if(is_numeric($HTTP_VARS['blank_rows']))
		$blank_rows = (int)$HTTP_VARS['blank_rows'];
	else
		$blank_rows = 5;

	for($i=$row; $i<$row+$blank_rows; $i++)
	{
		echo "\n<tr>";
		$display_functioname(array(), $i);
		echo "\n</tr>";
	}

	echo "<tr>";
	echo "<td colspan=1 align=center>".
		get_input_field("blank_rows", NULL, NULL, "value_select(\"1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20\",1)", "N", ifempty($HTTP_VARS['blank_rows'], "5"), FALSE, NULL, "this.form.submit();")
		."</td>";

	echo "<td colspan=".($column_count-1)." align=center>";
	echo "<input type=button value=\"Refresh\" onclick=\"document.forms['navigate'].blank_rows.value='$blank_rows'; document.forms['navigate']['op'].value='$edit_op'; document.forms['navigate'].submit();\">";
	echo "&nbsp;<input type=button value=\"Update\" onclick=\"this.form['op'].value='$update_op'; this.form.submit();\">";
	echo "</td></tr>";

	echo "</form>";
	echo "</table>";

	return $buffer;
}

function generate_site_plugin_sql($site_type_r)
{
	global $CONFIG_VARS;
	
	$CRLF = get_user_browser_crlf();

	$buffer ="#########################################################".
			$CRLF."# OpenDb ".$CONFIG_VARS['site.version']." ".$site_type_r['title']." (".$site_type_r['site_type'].") Site Plugin".
			$CRLF."#########################################################";

	$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin.".$CRLF."#".$CRLF;

	$buffer .= $CRLF."INSERT INTO s_site_plugin ( site_type, classname, order_no, title, image, description, external_url, items_per_page, more_info_url )".
				"VALUES ( ".
				"'".$site_type_r['site_type']."', ".
				"'".$site_type_r['classname']."', ".
				"".$site_type_r['order_no'].", ".
				"'".addslashes($site_type_r['title'])."', ".
				"'".addslashes($site_type_r['image'])."', ".
				"'".addslashes($site_type_r['description'])."', ".
				"'".addslashes($site_type_r['external_url'])."', ".
				"".$site_type_r['items_per_page'].", ".
				"'".addslashes($site_type_r['more_info_url'])."' );";

	$results = fetch_site_plugin_conf_rs($site_type_r['site_type']);
	if($results)
	{
		$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin Configuration".$CRLF."#.".$CRLF;

		while($site_plugin_conf_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$buffer .= $CRLF."INSERT INTO s_site_plugin_conf ( site_type, name, keyid, description, value ) ".
						"VALUES ( ".
						"'".$site_plugin_conf_r['site_type']."', ".
						"'".addslashes($site_plugin_conf_r['name'])."', ".
						"'".addslashes($site_plugin_conf_r['keyid'])."', ".
						"'".addslashes($site_plugin_conf_r['description'])."', ".
						"'".addslashes($site_plugin_conf_r['value'])."' );";
		}
		mysql_fetch_array($results);
	}

	$results = fetch_site_plugin_input_field_rs($site_type_r['site_type']);
	if($results)
	{
		$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin Input Fields".$CRLF."#".$CRLF;

		while($site_plugin_input_field_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$buffer .= $CRLF."INSERT INTO s_site_plugin_input_field ( site_type, field, order_no, description, prompt, field_type, default_value, refresh_mask ) ".
						"VALUES ( ".
						"'".$site_plugin_input_field_r['site_type']."', ".
						"'".$site_plugin_input_field_r['field']."', ".
						"".$site_plugin_input_field_r['order_no'].", ".
						"'".addslashes($site_plugin_input_field_r['description'])."', ".
						"'".addslashes($site_plugin_input_field_r['prompt'])."', ".
						"'".$site_plugin_input_field_r['field_type']."', ".
						"'".addslashes($site_plugin_input_field_r['default_value'])."', ".
						"'".addslashes($site_plugin_input_field_r['refresh_mask'])."' );";
		}
		mysql_fetch_array($results);
	}

	$results = fetch_site_plugin_link_rs($site_type_r['site_type']);
	if($results)
	{
		$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin Links".$CRLF."#".$CRLF;

		while($fetch_site_plugin_link_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$buffer .= $CRLF."INSERT INTO s_site_plugin_link ( site_type, s_item_type_group, s_item_type, order_no, description, url, title_url ) ".
						"VALUES ( ".
						"'".$fetch_site_plugin_link_r['site_type']."', ".
						"'".$fetch_site_plugin_link_r['s_item_type_group']."', ".
						"'".$fetch_site_plugin_link_r['s_item_type']."', ".
						"".$fetch_site_plugin_link_r['order_no'].", ".
						"'".addslashes($fetch_site_plugin_link_r['description'])."', ".
						"'".addslashes($fetch_site_plugin_link_r['url'])."', ".
						"'".addslashes($fetch_site_plugin_link_r['title_url'])."' );";
		}
		mysql_fetch_array($results);
	}

	$results = fetch_site_plugin_s_attribute_type_map_rs($site_type_r['site_type']);
	if($results)
	{
		$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin System Attribute Type Map".$CRLF."#".$CRLF;

		while($site_plugin_s_attribute_type_map_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$buffer .= $CRLF."INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) ".
						"VALUES ( ".
						"'".$site_plugin_s_attribute_type_map_r['site_type']."', ".
						"'".$site_plugin_s_attribute_type_map_r['s_item_type_group']."', ".
						"'".$site_plugin_s_attribute_type_map_r['s_item_type']."', ".
						"'".addslashes($site_plugin_s_attribute_type_map_r['variable'])."', ".
						"'".$site_plugin_s_attribute_type_map_r['s_attribute_type']."' );";
		}
		mysql_fetch_array($results);
	}

	$results = fetch_site_plugin_s_attribute_type_lookup_map_rs($site_type_r['site_type']);
	if($results)
	{
		$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin System Attribute Type Lookup Map".$CRLF."#".$CRLF;

		while($site_plugin_s_attribute_type_lookup_map_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$buffer .= $CRLF."INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) ".
						"VALUES ( ".
						"'".$site_plugin_s_attribute_type_lookup_map_r['site_type']."', ".
						"'".$site_plugin_s_attribute_type_lookup_map_r['s_attribute_type']."', ".
						"'".addslashes($site_plugin_s_attribute_type_lookup_map_r['value'])."', ".
						"'".addslashes($site_plugin_s_attribute_type_lookup_map_r['lookup_attribute_val'])."' ); ";
		}
		mysql_fetch_array($results);
	}

	$results = fetch_site_attribute_type_rs($site_type_r['site_type']);
	if($results)
	{
		$buffer .= $CRLF.$CRLF."####################################################################################################".
					$CRLF."# Item Type / Attribute Type relationships".
					$CRLF."####################################################################################################";

		$attr_inserts = "";

		$list_of_attribute_types = NULL;
		while($site_attribute_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
		{
			$list_of_attribute_types[] = $site_attribute_type_r['s_attribute_type'];

			$attr_inserts .= $CRLF."INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, display_type, s_field_type, site_type ) ".
							"VALUES ( ".
							"'".$site_attribute_type_r['s_attribute_type']."', ".
							"'".addslashes($site_attribute_type_r['description'])."', ".
							"'".addslashes($site_attribute_type_r['prompt'])."', ".
							"'".addslashes($site_attribute_type_r['input_type'])."', ".
							"'".addslashes($site_attribute_type_r['display_type'])."', ".
							"'".$site_attribute_type_r['s_field_type']."', ".
							"'".$site_attribute_type_r['site_type']."' );";

		}
		mysql_fetch_array($results);

		//if(is_array($list_of_attribute_types))
		//{
		//	$sql_in_clause = format_sql_in_clause($list_of_attribute_types);
			//$buffer .= $CRLF.$CRLF."# cleanup after previous install.";
			//$buffer .= $CRLF."DELETE FROM s_attribute_type WHERE s_attribute_type IN (".$sql_in_clause.")";
			//$buffer .= $CRLF."DELETE FROM s_attribute_type WHERE s_attribute_type IN (".$sql_in_clause.")";
		//}

		$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin Attribute Type(s)".$CRLF."#".$CRLF;

		$buffer .= $attr_inserts;

		$results = fetch_site_item_attribute_type_rs($site_type_r['site_type']);
		if($results)
		{
			$buffer .= $CRLF.$CRLF."#".$CRLF."# Site Plugin Item Attribute Type Relationship(s)".$CRLF."#".$CRLF;
			while($site_item_attribute_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
			{
				$buffer .= $CRLF."INSERT INTO s_item_attribute_type ( s_item_type, s_attribute_type, order_no, prompt, compulsory_ind ) ".
							"VALUES ( ".
							"'".$site_item_attribute_type_r['s_item_type']."', ".
							"'".$site_item_attribute_type_r['s_attribute_type']."', ".
							" ".$site_item_attribute_type_r['order_no'].", ".
							"'".addslashes($site_item_attribute_type_r['prompt'])."', ".
							"'".ifempty($site_item_attribute_type_r['compulsory_ind'], 'N')."' );";
			}
			mysql_fetch_array($results);
		}
	}

	$buffer .= $CRLF;

	return $buffer;
}

session_start();
if (is_opendb_valid_session())
{
	if (is_user_admin($HTTP_SESSION_VARS['user_id'], $HTTP_SESSION_VARS['user_type']))
	{
		// default.
		if(strlen($HTTP_VARS['op'])==0)
			$HTTP_VARS['op'] = 'list_site_plugins';

		if($HTTP_VARS['op'] == 'insert_site_plugin')
		{
			if(!is_exists_site_plugin($HTTP_VARS['site_type'], FALSE))
			{
				// first of all we need to derive the order_no
				$max_order_no = fetch_max_site_plugin_order_no();
				if($max_order_no!==FALSE && is_numeric($max_order_no))
					$order_no = $max_order_no + 1;
				else
					$order_no = 1; // first plugin

				if(insert_s_site_plugin($HTTP_VARS['site_type'], $HTTP_VARS['classname'], $order_no, $HTTP_VARS['title'], $HTTP_VARS['image'], $HTTP_VARS['description'], $HTTP_VARS['external_url'], $HTTP_VARS['items_per_page'], $HTTP_VARS['more_info_url']))
				{
					// return to edit form, so rest of site plugin information can be populated.
					$HTTP_VARS['op'] = 'list_site_plugins';
				}
				else
				{
					$errors[] = array('error'=>'Site Plugin not inserted','detail'=>mysql_error());
					$HTTP_VARS['op'] = 'new_site_plugin';
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin exists','detail'=>mysql_error());
				$HTTP_VARS['op'] = 'new_site_plugin';
			}
		}
		else if($HTTP_VARS['op'] == 'update_site_plugin')
		{
			if(is_exists_site_plugin($HTTP_VARS['site_type'], FALSE))
			{
				if(!update_s_site_plugin($HTTP_VARS['site_type'], $HTTP_VARS['classname'], FALSE, $HTTP_VARS['title'], $HTTP_VARS['image'], $HTTP_VARS['description'], $HTTP_VARS['external_url'], $HTTP_VARS['items_per_page'], $HTTP_VARS['more_info_url']))
				{
					$errors[] = array('error'=>'Site Plugin not updated','detail'=>mysql_error());
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found.', 'detail'=>'');
			}

			// at the end return to list site plugins
			$HTTP_VARS['op'] = 'list_site_plugins';
		}
		else if($HTTP_VARS['op'] == 'update_site_plugins')
		{
			if(is_not_empty_array($HTTP_VARS['order_no']))
			{
				for($i=0; $i<count($HTTP_VARS['order_no']); $i++)
				{
					if(strlen($HTTP_VARS['order_no'][$i])>0)
					{
						if(!update_s_site_plugin($HTTP_VARS['site_type'][$i], FALSE, $HTTP_VARS['order_no'][$i], FALSE, FALSE, FALSE, FALSE, FALSE, FALSE))
							$errors[] = array('error'=>'Site Plugin Link not updated','detail'=>mysql_error());
					}//else ignore
				}
			}

			// return to edit mode
			$HTTP_VARS['op'] = 'list_site_plugins';
		}
		else if($HTTP_VARS['op'] == 'delete_site_plugin')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				if($HTTP_VARS['confirmed'] == 'false')
				{
					// return to edit form
					$HTTP_VARS['op'] = 'list_site_plugins';
				}
				else
				{
					if($HTTP_VARS['confirmed'] != 'true')
					{
						// Get the theme specific source of the image.
						echo "<h3>Delete Site Plugin</h3>";

						$op_confirm_prompt .= "Are you sure you want to delete Site Plugin \"".$site_plugin_r['site_type']." - ".$site_plugin_r['title']."\"?";
						echo get_op_confirm_form(
								$PHP_SELF,
								$op_confirm_prompt,
								$HTTP_VARS);
					}
					else // $HTTP_VARS['confirmed'] == 'true'
					{
						// perform the delete process.
						delete_s_site_plugin_s_attribute_type_lookup_map($HTTP_VARS['site_type']);
						delete_s_site_plugin_s_attribute_type_map($HTTP_VARS['site_type']);
						delete_s_site_plugin_input_field($HTTP_VARS['site_type']);
						delete_s_site_plugin_link($HTTP_VARS['site_type']);
						delete_s_site_plugin_conf($HTTP_VARS['site_type']);
						delete_s_site_plugin($HTTP_VARS['site_type']);

						// return to edit form
						$HTTP_VARS['op'] = 'list_site_plugins';
					}
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}

		else if($HTTP_VARS['op'] == 'update_site_plugin_item_types')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				$results = fetch_site_attribute_type_rs($HTTP_VARS['site_type']);
				if($results)
				{
					$site_attribute_type_r = array();
					while($site_plugin_attribute_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
					{
						$site_attribute_type_r[] = $site_plugin_attribute_type_r['s_attribute_type'];
					}
					mysql_free_result($results);
				}

				if(is_not_empty_array($site_attribute_type_r))
				{
					if(is_not_empty_array($HTTP_VARS['s_item_type']))
					{
						reset($HTTP_VARS['s_item_type']);
						while(list($v_s_item_type, $value) = each($HTTP_VARS['s_item_type']))
						{
							if(is_exists_item_type($v_s_item_type))
							{
								// now we need to transfer in
								if($value == 'exclude')
								{
									$site_item_attribute_type_rs = array();
									// so this is the list of attributes currently attached to the s_item_type
									$results2 = fetch_site_item_attribute_type_rs($HTTP_VARS['site_type'], $v_s_item_type);
									if($results2)
									{
										while($attribute_type_r = mysql_fetch_array($results2, MYSQL_ASSOC))
										{
											$site_item_attribute_type_rs[] = $attribute_type_r;
										}
										mysql_free_result($results2);
									}

									$delete = TRUE;
									reset($site_item_attribute_type_rs);
									while(list(,$site_item_attribute_type_r) = each($site_item_attribute_type_rs))
									{
										if(!is_s_item_attribute_type_deletable($v_s_item_type, $site_item_attribute_type_r['s_attribute_type'], $site_item_attribute_type_r['order_no']))
										{
											$errors[] = array('error'=>'Dependent Item Attribute records exist','detail'=>'s_item_type='.$v_s_item_type.', s_attribute_type='.$site_item_attribute_type_r['s_attribute_type'].', order_no='.$site_item_attribute_type_r['order_no']);
											$delete = FALSE;
										}
									}

									if($delete)
									{
										reset($site_item_attribute_type_rs);
										while(list(,$site_item_attribute_type_r) = each($site_item_attribute_type_rs))
										{
											if(!delete_s_item_attribute_type($v_s_item_type, $site_item_attribute_type_r['s_attribute_type'], $site_item_attribute_type_r['order_no']))
												$errors[] = array('error'=>'System Item Attribute Type (s_item_type='.$v_s_item_type.', s_attribute_type='.$site_item_attribute_type_r['s_attribute_type'].', order_no='.$site_item_attribute_type_r['order_no'].') not deleted','detail'=>mysql_error());
										}
									}
								}
								else if($value == 'include')
								{
									for($i=0; $i<count($site_attribute_type_r); $i++)
									{
										if(!is_exists_item_attribute_type($v_s_item_type, $site_attribute_type_r[$i], 0))
										{
											if(!insert_s_item_attribute_type($v_s_item_type, $site_attribute_type_r[$i], 0, NULL, 'N'))
												$errors[] = array('error'=>'System Item Attribute Type (s_item_type='.$v_s_item_type.', s_attribute_type='.$site_item_attribute_type_r['s_attribute_type'].', order_no='.$site_attribute_type_r['order_no'].') not inserted','detail'=>mysql_error());
										}
									}
								}
							}
						}
					}//if(is_not_empty_array($HTTP_VARS['s_item_type']))

					// return to edit mode
					$HTTP_VARS['op'] = 'edit_site_plugin_item_types';

				}//if(is_not_empty_array($site_attribute_type_r))
				else
				{
					$errors[] = array('error'=>'Site Plugin attribute type\'s not found');
					$HTTP_VARS['op'] = 'list_site_plugins';
				}
			}//if(is_not_empty_array($site_plugin_r))
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'update_site_plugin_links')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				if(is_not_empty_array($HTTP_VARS['exists_ind']))
				{
					for($i=0; $i<count($HTTP_VARS['exists_ind']); $i++)
					{
						if(strlen($HTTP_VARS['s_item_type_group'][$i])>0 && strlen($HTTP_VARS['s_item_type'][$i])>0 && is_numeric($HTTP_VARS['order_no'][$i]) && strlen($HTTP_VARS['description'][$i])>0 && (strlen($HTTP_VARS['url'][$i])>0 || strlen($HTTP_VARS['title_url'][$i])>0))
						{
							if($HTTP_VARS['exists_ind'][$i] == 'N')
							{
								if(!insert_s_site_plugin_link($HTTP_VARS['site_type'], $HTTP_VARS['s_item_type_group'][$i], $HTTP_VARS['s_item_type'][$i], $HTTP_VARS['order_no'][$i], $HTTP_VARS['description'][$i], $HTTP_VARS['url'][$i], $HTTP_VARS['title_url'][$i]))
									$errors[] = array('error'=>'Site Plugin Link not inserted','detail'=>mysql_error());
							}
							else if(is_numeric($HTTP_VARS['sequence_number'][$i]))
							{
								if(!update_s_site_plugin_link($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number'][$i], $HTTP_VARS['s_item_type_group'][$i], $HTTP_VARS['s_item_type'][$i], $HTTP_VARS['order_no'][$i], $HTTP_VARS['description'][$i], $HTTP_VARS['url'][$i], $HTTP_VARS['title_url'][$i]))
									$errors[] = array('error'=>'Site Plugin Link not updated','detail'=>mysql_error());
							}
						}//else ignore
					}
				}

				// return to edit mode
				$HTTP_VARS['op'] = 'edit_site_plugin_links';
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'update_site_plugin_confs')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				if(is_not_empty_array($HTTP_VARS['exists_ind']))
				{
					for($i=0; $i<count($HTTP_VARS['exists_ind']); $i++)
					{
						if(strlen($HTTP_VARS['name'][$i])>0 && strlen($HTTP_VARS['keyid'][$i])>0 && strlen($HTTP_VARS['value'][$i])>0)
						{
							if($HTTP_VARS['exists_ind'][$i] == 'N')
							{
								if(!insert_s_site_plugin_conf($HTTP_VARS['site_type'], $HTTP_VARS['name'][$i], $HTTP_VARS['keyid'][$i], $HTTP_VARS['value'][$i], $HTTP_VARS['description'][$i]))
									$errors[] = array('error'=>'Site Plugin Configuration not inserted','detail'=>mysql_error());
							}
							else
							{
								if(!update_s_site_plugin_conf($HTTP_VARS['site_type'], $HTTP_VARS['name'][$i], $HTTP_VARS['keyid'][$i], $HTTP_VARS['value'][$i], $HTTP_VARS['description'][$i]))
									$errors[] = array('error'=>'Site Plugin Configuration not updated','detail'=>mysql_error());
							}
						}//else ignore
					}
				}

				// return to edit mode
				$HTTP_VARS['op'] = 'edit_site_plugin_confs';
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'update_site_plugin_input_fields')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				if(is_not_empty_array($HTTP_VARS['exists_ind']))
				{
					for($i=0; $i<count($HTTP_VARS['exists_ind']); $i++)
					{
						if(strlen($HTTP_VARS['field'][$i])>0 && strlen($HTTP_VARS['order_no'][$i])>0)
						{
							if($HTTP_VARS['exists_ind'][$i] == 'N')
							{
								if(!insert_s_site_plugin_input_field($HTTP_VARS['site_type'], $HTTP_VARS['field'][$i], $HTTP_VARS['order_no'][$i], $HTTP_VARS['description'][$i], $HTTP_VARS['prompt'][$i], $HTTP_VARS['field_type'][$i], $HTTP_VARS['default_value'][$i], $HTTP_VARS['refresh_mask'][$i]))
									$errors[] = array('error'=>'Site Plugin Input Field not inserted','detail'=>mysql_error());
							}
							else
							{
								if(!update_s_site_plugin_input_field($HTTP_VARS['site_type'], $HTTP_VARS['field'][$i], $HTTP_VARS['order_no'][$i], $HTTP_VARS['description'][$i], $HTTP_VARS['prompt'][$i], $HTTP_VARS['field_type'][$i], $HTTP_VARS['default_value'][$i], $HTTP_VARS['refresh_mask'][$i]))
									$errors[] = array('error'=>'Site Plugin Input Field not updated','detail'=>mysql_error());
							}
						}//else ignore
					}
				}

				// return to edit mode
				$HTTP_VARS['op'] = 'edit_site_plugin_input_fields';
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'update_site_plugin_s_attribute_type_maps')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				if(is_not_empty_array($HTTP_VARS['exists_ind']))
				{
					for($i=0; $i<count($HTTP_VARS['exists_ind']); $i++)
					{
						if(strlen($HTTP_VARS['variable'][$i])>0 && strlen($HTTP_VARS['s_item_type_group'][$i])>0 && strlen($HTTP_VARS['s_item_type'][$i])>0 && strlen($HTTP_VARS['s_attribute_type'][$i])>0)
						{
							if($HTTP_VARS['exists_ind'][$i] == 'N')
							{
								if(!insert_s_site_plugin_s_attribute_type_map($HTTP_VARS['site_type'], $HTTP_VARS['variable'][$i], $HTTP_VARS['s_item_type_group'][$i], $HTTP_VARS['s_item_type'][$i], $HTTP_VARS['s_attribute_type'][$i]))
									$errors[] = array('error'=>'Site Plugin Attribute Type Map not inserted','detail'=>mysql_error());
							}
							else if(is_numeric($HTTP_VARS['sequence_number'][$i]))
							{
								if(!update_s_site_plugin_s_attribute_type_map($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number'][$i], $HTTP_VARS['s_item_type_group'][$i], $HTTP_VARS['s_item_type'][$i], $HTTP_VARS['s_attribute_type'][$i]))
									$errors[] = array('error'=>'Site Plugin Attribute Type Map not updated','detail'=>mysql_error());
							}
						}//else ignore
					}
				}

				// return to edit mode
				$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_maps';
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'update_site_plugin_s_attribute_type_lookup_maps')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				if(is_not_empty_array($HTTP_VARS['s_attribute_type']))
				{
					for($i=0; $i<count($HTTP_VARS['s_attribute_type']); $i++)
					{
						if(strlen($HTTP_VARS['s_attribute_type'][$i])>0 && strlen($HTTP_VARS['value'][$i])>0 && strlen($HTTP_VARS['lookup_attribute_val'][$i])>0)
						{
							if($HTTP_VARS['exists_ind'][$i] == 'N')
							{
								if(!insert_s_site_plugin_s_attribute_type_lookup_map($HTTP_VARS['site_type'], $HTTP_VARS['s_attribute_type'][$i], $HTTP_VARS['value'][$i], $HTTP_VARS['lookup_attribute_val'][$i]))
									$errors[] = array('error'=>'Site Plugin Lookup Attribute Type Map not inserted','detail'=>mysql_error());
							}
							else if(is_numeric($HTTP_VARS['sequence_number'][$i]))
							{
								if(!update_s_site_plugin_s_attribute_type_lookup_map($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number'][$i], $HTTP_VARS['lookup_attribute_val'][$i]))
									$errors[] = array('error'=>'Site Plugin Lookup Attribute Type Map not updated','detail'=>mysql_error());
							}
						}//else ignore
					}
				}

				// return to edit mode
				$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_lookup_maps';
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'delete_site_plugin_link')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				$site_plugin_link_r = fetch_site_plugin_link_r($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number']);
				if(is_not_empty_array($site_plugin_link_r))
				{
					if($HTTP_VARS['confirmed'] == 'false')
					{
						// return to edit mode
						$HTTP_VARS['op'] = 'edit_site_plugin_links';
					}
					else
					{
						if($HTTP_VARS['confirmed'] != 'true')
						{
							echo("\n<h3>Delete ".$site_plugin_r['title']." Site Plugin Link</h3>");

							$op_confirm_prompt .= "Are you sure you want to delete ".$site_plugin_r['title']." Site Plugin Link (".$site_plugin_link_r['description'].")?";
							echo get_op_confirm_form(
									$PHP_SELF,
									$op_confirm_prompt,
									$HTTP_VARS);
						}
						else // $HTTP_VARS['confirmed'] == 'true'
						{
							delete_s_site_plugin_link($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number']);

							// return to edit mode
							$HTTP_VARS['op'] = 'edit_site_plugin_links';
						}
					}
				}
				else
				{
					$errors[] = array('error'=>'Site Plugin Link not found');
					$HTTP_VARS['op'] = 'edit_site_plugin_links';
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'delete_site_plugin_conf')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				$site_plugin_conf_r = fetch_site_plugin_conf_r($HTTP_VARS['site_type'], $HTTP_VARS['name'], $HTTP_VARS['keyid']);
				if(is_not_empty_array($site_plugin_conf_r))
				{
					if($HTTP_VARS['confirmed'] == 'false')
					{
						// return to edit mode
						$HTTP_VARS['op'] = 'edit_site_plugin_confs';
					}
					else
					{
						if($HTTP_VARS['confirmed'] != 'true')
						{
							echo("\n<h3>Delete ".$site_plugin_r['title']." Site Plugin Configuration</h3>");

							$op_confirm_prompt .= "Are you sure you want to delete ".$site_plugin_r['title']." Site Plugin Configuration (name=".$site_plugin_conf_r['name'].", keyid=".$site_plugin_conf_r['keyid'].", value=".$site_plugin_conf_r['value'].")?";
							echo get_op_confirm_form(
									$PHP_SELF,
									$op_confirm_prompt,
									$HTTP_VARS);
						}
						else // $HTTP_VARS['confirmed'] == 'true'
						{
							delete_s_site_plugin_conf($HTTP_VARS['site_type'], $HTTP_VARS['name'], $HTTP_VARS['keyid']);

							// return to edit mode
							$HTTP_VARS['op'] = 'edit_site_plugin_confs';
						}
					}
				}
				else
				{
					$errors[] = array('error'=>'Site Plugin Configuration not found');
					$HTTP_VARS['op'] = 'edit_site_plugin_confs';
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'delete_site_plugin_input_field')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				$site_plugin_input_field_r = fetch_site_plugin_input_field_r($HTTP_VARS['site_type'], $HTTP_VARS['field']);
				if(is_not_empty_array($site_plugin_input_field_r))
				{
					if($HTTP_VARS['confirmed'] == 'false')
					{
						// return to edit mode
						$HTTP_VARS['op'] = 'edit_site_plugin_input_fields';
					}
					else
					{
						if($HTTP_VARS['confirmed'] != 'true')
						{
							echo("\n<h3>Delete ".$site_plugin_r['title']." Site Plugin Input Field</h3>");

							$op_confirm_prompt .= "Are you sure you want to delete ".$site_plugin_r['title']." Site Plugin Input Field (field=".$site_plugin_input_field_r['field'].", prompt=".$site_plugin_input_field_r['prompt'].", description=".$site_plugin_input_field_r['description'].")?";
							echo get_op_confirm_form(
									$PHP_SELF,
									$op_confirm_prompt,
									$HTTP_VARS);
						}
						else // $HTTP_VARS['confirmed'] == 'true'
						{
							delete_s_site_plugin_input_field($HTTP_VARS['site_type'], $HTTP_VARS['field']);

							// return to edit mode
							$HTTP_VARS['op'] = 'edit_site_plugin_input_fields';
						}
					}
				}
				else
				{
					$errors[] = array('error'=>'Site Plugin Input Field not found');
					$HTTP_VARS['op'] = 'edit_site_plugin_input_fields';
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'delete_site_plugin_s_attribute_type_map')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				$site_plugin_s_attribute_type_map_r = fetch_site_plugin_s_attribute_type_map_r($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number']);
				if(is_not_empty_array($site_plugin_s_attribute_type_map_r))
				{
					if($HTTP_VARS['confirmed'] == 'false')
					{
						// return to edit mode
						$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_maps';
					}
					else
					{
						if($HTTP_VARS['confirmed'] != 'true')
						{
							echo("\n<h3>Delete ".$site_plugin_r['title']." Site Plugin Attribute Type Map</h3>");

							$op_confirm_prompt .= "Are you sure you want to delete ".$site_plugin_r['title']." Site Plugin Attribute Type Map (variable=".$site_plugin_s_attribute_type_map_r['variable'].", s_item_type_group=".$site_plugin_s_attribute_type_map_r['s_item_type_group'].", s_item_type=".$site_plugin_s_attribute_type_map_r['s_item_type'].", s_attribute_type=".$site_plugin_s_attribute_type_map_r['s_attribute_type'].")?";
							echo get_op_confirm_form(
									$PHP_SELF,
									$op_confirm_prompt,
									$HTTP_VARS);
						}
						else // $HTTP_VARS['confirmed'] == 'true'
						{
							delete_s_site_plugin_s_attribute_type_map($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number']);

							// return to edit mode
							$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_maps';
						}
					}
				}
				else
				{
					$errors[] = array('error'=>'Site Plugin Attribute Type Map not found');
					$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_maps';
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'delete_site_plugin_s_attribute_type_lookup_map')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				$site_plugin_s_attribute_type_lookup_map_r = fetch_site_plugin_s_attribute_type_lookup_map_r($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number']);
				if(is_not_empty_array($site_plugin_s_attribute_type_lookup_map_r))
				{
					if($HTTP_VARS['confirmed'] == 'false')
					{
						// return to edit mode
						$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_lookup_maps';
					}
					else
					{
						if($HTTP_VARS['confirmed'] != 'true')
						{
							echo("\n<h3>Delete ".$site_plugin_r['title']." Site Plugin Lookup Attribute Type Map</h3>");

							$op_confirm_prompt .= "Are you sure you want to delete ".$site_plugin_r['title']." Site Plugin Lookup Attribute Type Map (s_attribute_type=".$site_plugin_s_attribute_type_lookup_map_r['s_attribute_type'].", value=".$site_plugin_s_attribute_type_lookup_map_r['value'].", lookup_attribute_val=".$site_plugin_s_attribute_type_lookup_map_r['lookup_attribute_val'].")?";
							echo get_op_confirm_form(
									$PHP_SELF,
									$op_confirm_prompt,
									$HTTP_VARS);
						}
						else // $HTTP_VARS['confirmed'] == 'true'
						{
							delete_s_site_plugin_s_attribute_type_lookup_map($HTTP_VARS['site_type'], $HTTP_VARS['sequence_number']);

							// return to edit mode
							$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_lookup_maps';
						}
					}
				}
				else
				{
					$errors[] = array('error'=>'Site Plugin Lookup Attribute Type Map not found');
					$HTTP_VARS['op'] = 'edit_site_plugin_s_attribute_type_lookup_maps';
				}
			}
			else
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}

		if($HTTP_VARS['op'] == 'edit_site_plugin_item_types')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				$results = fetch_site_attribute_type_rs($HTTP_VARS['site_type']);
				if($results)
				{
					$site_attribute_type_r = array();
					while($site_plugin_attribute_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
					{
						$site_attribute_type_r[] = $site_plugin_attribute_type_r['s_attribute_type'];
					}
					mysql_free_result($results);
				}

				if(is_not_empty_array($site_attribute_type_r))
				{
					echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");
					echo("\n<h3>Edit ".$site_plugin_r['title']." Site Plugin System Item Types</h3>");

					if(is_not_empty_array($errors))
						echo format_error_block($errors);

					echo('<script src="./admin/s_site_plugin/select.js" language="JavaScript" type="text/javascript"></script>');

					echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
						"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
						"\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">".
						"\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">".
						"\n</form>");

					echo("<table>");
					echo("\n<form name=\"s_status_type\" action=\"$PHP_SELF\" method=\"post\">");
					echo("\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">");
					echo("\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">");
					echo("\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">");

					$exists_item_type_rs = array();
					$not_exists_item_type_rs = array();

					$results = fetch_item_type_rs();
					if($results)
					{
						while($item_type_r = mysql_fetch_array($results, MYSQL_ASSOC))
						{
							$exists = FALSE;
							for($i=0; $i<count($site_attribute_type_r); $i++)
							{
								if(is_exists_item_attribute_type($item_type_r['s_item_type'], $site_attribute_type_r[$i]))
								{
									$exists = TRUE;
								}
							}

							if($exists)
								$exists_item_type_rs[] = $item_type_r;
							else
								$not_exists_item_type_rs[] = $item_type_r;
						}
						mysql_free_result($results);
					}

					echo("<tr><td class=navbar>Exclude</td><td>&nbsp;</td><td class=navbar>Include</td></tr>");
					echo("<tr><td><select name=\"from_item_types\" size=15 MULTIPLE>");
					echo("<option value=\"\" onClick=\"this.selected=false;\">-----------------------------------------\n");
					for($i=0; $i<count($not_exists_item_type_rs); $i++)
					{
						echo("<option value=\"".$not_exists_item_type_rs[$i]['s_item_type']."\">".$not_exists_item_type_rs[$i]['s_item_type']." - ".$not_exists_item_type_rs[$i]['description']."\n");
					}
					echo("</select></td>");

					echo("<td>");
					echo("<input type=button value=\"&nbsp;>&nbsp;\" onClick=\"moveOptions(this.form, 's_item_type', this.form['from_item_types'], this.form['to_item_types']);\"><br>".
						"<input type=button value=\">>\" onClick=\"moveAllOptions(this.form, 's_item_type', this.form['from_item_types'], this.form['to_item_types']);\"><br><br>");

					echo("<input type=button value=\"&nbsp;<&nbsp;\" onClick=\"moveOptions(this.form, 's_item_type', this.form['to_item_types'], this.form['from_item_types']);\"><br>".
						"<input type=button value=\"<<\" onClick=\"moveAllOptions(this.form, 's_item_type', this.form['to_item_types'], this.form['from_item_types']);\">");

					echo("</td>");

					echo("<td><select name=\"to_item_types\" size=15 MULTIPLE>");
                    echo("<option value=\"\" onClick=\"this.selected=false;\">-----------------------------------------\n");
					for($i=0; $i<count($exists_item_type_rs); $i++)
					{
						echo("<option value=\"".$exists_item_type_rs[$i]['s_item_type']."\">".$exists_item_type_rs[$i]['s_item_type']." - ".$exists_item_type_rs[$i]['description']."\n");
					}
					echo("</select></td>");

					for($i=0; $i<count($not_exists_item_type_rs); $i++)
					{
						echo("\n<input type=hidden name=\"s_item_type[".$not_exists_item_type_rs[$i]['s_item_type']."]\" value=\"exclude\">");
					}

					for($i=0; $i<count($exists_item_type_rs); $i++)
					{
						echo("\n<input type=hidden name=\"s_item_type[".$exists_item_type_rs[$i]['s_item_type']."]\" value=\"include\">");
					}

					echo("\n<tr><td colspan=\"3\" align=center>");
					echo("<input type=button value=\"Refresh\" onclick=\"document.forms['navigate'].op.value='".$HTTP_VARS['op']."'; document.forms['navigate'].submit();\">");
					echo("\n<input type=button value=\"Update\" onclick=\"this.form.op.value='update_site_plugin_item_types'; this.form.submit();\">");
					echo("\n</td></tr>");

					echo("</form>");
					echo("</table>");
				}//if(is_not_empty_array($attribute_type_r))
				else
				{
					$errors[] = array('error'=>'Site Plugin attribute type\'s not found');
					$HTTP_VARS['op'] = 'list_site_plugins';
				}
			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'edit_site_plugin_links')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");
				echo("\n<h3>Edit ".$site_plugin_r['title']." Site Plugin Links</h3>");

				if(is_not_empty_array($errors))
					echo format_error_block($errors);

				echo get_validation_javascript();

				echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
					"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
					"\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">".
					"\n<input type=\"hidden\" name=\"blank_rows\" value=\"".$HTTP_VARS['blank_rows']."\">".
					"\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">".
					"\n<input type=\"hidden\" name=\"sequence_number\" value=\"\">".
					"\n</form>");

				echo(display_edit_table(
						$HTTP_VARS['op'],
						'update_site_plugin_links',
						array('Order', 'Item Type<br>Group', 'Item Type', 'Description', 'URL', 'Title URL', ''),
						'display_site_plugin_link_row',
						array('site_type'=>$HTTP_VARS['site_type']),
						fetch_site_plugin_link_rs($HTTP_VARS['site_type'])));
			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'edit_site_plugin_confs')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");
				echo("\n<h3>Edit ".$site_plugin_r['title']." Site Plugin Configuration</h3>");

				if(is_not_empty_array($errors))
					echo format_error_block($errors);

				echo get_validation_javascript();

				echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
					"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
					"\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">".
					"\n<input type=\"hidden\" name=\"blank_rows\" value=\"".$HTTP_VARS['blank_rows']."\">".
					"\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">".
					"\n<input type=\"hidden\" name=\"name\" value=\"\">".
					"\n<input type=\"hidden\" name=\"keyid\" value=\"\">".
					"\n</form>");

				echo(display_edit_table(
						$HTTP_VARS['op'],
						'update_site_plugin_confs',
						array('Name', 'Key ID', 'Description', 'Value', ''),
						'display_site_plugin_conf_row',
						array('site_type'=>$HTTP_VARS['site_type']),
						fetch_site_plugin_conf_rs($HTTP_VARS['site_type'])));
			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'edit_site_plugin_input_fields')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");
				echo("\n<h3>Edit ".$site_plugin_r['title']." Site Plugin Input Fields</h3>");

				if(is_not_empty_array($errors))
					echo format_error_block($errors);

				echo get_validation_javascript();

				echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
					"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
					"\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">".
					"\n<input type=\"hidden\" name=\"blank_rows\" value=\"".$HTTP_VARS['blank_rows']."\">".
					"\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">".
					"\n<input type=\"hidden\" name=\"field\" value=\"\">".
					"\n</form>");

				echo(display_edit_table(
						$HTTP_VARS['op'],
						'update_site_plugin_input_fields',
						array('Order No', 'Field Name', 'Description', 'Prompt', 'Field Type', 'Refresh Mask', 'Default Value', ''),
						'display_site_plugin_input_field_row',
						array('site_type'=>$HTTP_VARS['site_type']),
						fetch_site_plugin_input_field_rs($HTTP_VARS['site_type'])));
			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'edit_site_plugin_s_attribute_type_maps')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");
				echo("\n<h3>Edit ".$site_plugin_r['title']." Site Plugin Attribute Type Map</h3>");

				if(is_not_empty_array($errors))
					echo format_error_block($errors);

				echo get_validation_javascript();

				echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
					"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
					"\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">".
					"\n<input type=\"hidden\" name=\"blank_rows\" value=\"".$HTTP_VARS['blank_rows']."\">".
					"\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">".
					"\n<input type=\"hidden\" name=\"sequence_number\" value=\"\">".
					"\n</form>");

				echo(display_edit_table(
						$HTTP_VARS['op'],
						'update_site_plugin_s_attribute_type_maps',
						array('Variable', 'Item Type<br>Group', 'Item Type', 'Attribute Type', ''),
						'display_site_plugin_s_attribute_type_map_row',
						array('site_type'=>$HTTP_VARS['site_type']),
						fetch_site_plugin_s_attribute_type_map_rs($HTTP_VARS['site_type'])));
			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'edit_site_plugin_s_attribute_type_lookup_maps')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");
				echo("\n<h3>Edit ".$site_plugin_r['title']." Site Plugin Lookup Attribute Type Map</h3>");

				if(is_not_empty_array($errors))
					echo format_error_block($errors);

				echo get_validation_javascript();
				echo '<script src="./include/search.js" language="JavaScript" type="text/javascript"></script>';
				echo get_lookup_attribute_type_array();

				echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
					"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
					"\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">".
					"\n<input type=\"hidden\" name=\"blank_rows\" value=\"".$HTTP_VARS['blank_rows']."\">".
					"\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">".
					"\n<input type=\"hidden\" name=\"sequence_number\" value=\"\">".
					"\n</form>");

				echo(display_edit_table(
						$HTTP_VARS['op'],
						'update_site_plugin_s_attribute_type_lookup_maps',
						array('Attribute Type', 'Site Value', 'Lookup Attribute Value', ''),
						'display_site_plugin_s_attribute_type_lookup_map_row',
						array('site_type'=>$HTTP_VARS['site_type']),
						fetch_site_plugin_s_attribute_type_lookup_map_rs($HTTP_VARS['site_type'])));

			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'edit_site_plugin')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");

				echo("\n<h3>Edit Site Plugin</h3>");

				if(is_not_empty_array($errors))
					echo format_error_block($errors);

				echo get_validation_javascript();

				echo("\n<table cellspacing=2 border=0>");
				echo("\n<form name=\"s_site_plugin\" action=\"$PHP_SELF\" method=\"post\">");
				echo("\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">");
				echo("\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">");

				display_edit_site_plugin($site_plugin_r, $HTTP_VARS);

				if($CONFIG_VARS['widgets.show_prompt_compulsory_ind']!==FALSE)
				{
					echo("\n<tr><td align=left nowrap>".
						format_help_block(array(array('img'=>'compulsory.gif', 'text'=>$LANG_VARS['compulsory_field']))).
						"</td><td>&nbsp;</td></tr>");
				}

				echo("\n<tr><td colspan=\"2\" align=center>");
				if($CONFIG_VARS['widgets.enable_javascript_validation']!==FALSE)
					echo("\n<input type=button value=\"Update\" onclick=\"if(!checkForm(this.form)){return false;}else{this.form.op.value='update_site_plugin'; this.form.submit();}\">");
				else
					echo("\n<input type=button value=\"Update\" onclick=\"this.form.op.value='update_site_plugin'; this.form.submit();\">");
				echo("\n</td></tr>");

				echo("\n</form>");
				echo("\n</table>");
			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}
		else if($HTTP_VARS['op'] == 'new_site_plugin')
		{
			echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");

			echo("\n<h3>New Site Plugin</h3>");

			if(is_not_empty_array($errors))
				echo format_error_block($errors);

			echo get_validation_javascript();

			echo("\n<table cellspacing=2 border=0>");
			echo("\n<form name=\"s_site_plugin\" action=\"$PHP_SELF\" method=\"post\">");
			echo("\n<input type=\"hidden\" name=\"op\" value=\"insert_site_plugin\">");
			echo("\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">");

			display_edit_site_plugin(NULL, $HTTP_VARS);

			if($CONFIG_VARS['widgets.show_prompt_compulsory_ind']!==FALSE)
			{
				echo("\n<tr><td align=left nowrap>".
					format_help_block(array(array('img'=>'compulsory.gif', 'text'=>$LANG_VARS['compulsory_field']))).
					"</td><td>&nbsp;</td></tr>");
			}

			echo("\n<tr><td colspan=\"2\" align=center>");
			if($CONFIG_VARS['widgets.enable_javascript_validation']!==FALSE)
				echo("\n<input type=button value=\"Insert\" onclick=\"if(!checkForm(this.form)){return false;}else{this.form.submit();}\">");
			else
				echo("\n<input type=button value=\"Insert\" onclick=\"this.form.submit();\">");
			echo("\n</td></tr>");

			echo("\n</form>");
			echo("\n</table>");
		}
		else if($HTTP_VARS['op'] == 'sql_site_plugin')
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				header("Cache-control: no-store");
				header("Pragma: no-store");
				header("Expires: 0");
				header("Content-disposition: attachment; filename=".$HTTP_VARS['site_type'].".sql");
				header("Content-type: application/octet-stream");

				echo generate_site_plugin_sql($site_plugin_r);
			}
			else
			{
				echo format_error_block(array('error'=>'Site Plugin not found'));
			}
		}
		else if($HTTP_VARS['op'] == 'maintain_site_plugin_install') // special function to allow upload of file into database,etc
		{
			$site_plugin_r = fetch_site_plugin_r($HTTP_VARS['site_type']);
			if(is_not_empty_array($site_plugin_r))
			{
				if(file_exists("./patch/site/".$HTTP_VARS['site_type'].".install.class.php"))
				{
					$classname = "Install_".$HTTP_VARS['site_type'];

					include_once("./patch/site/".$HTTP_VARS['site_type'].".install.class.php");
					$installPlugin =& new $classname();

					// this is currently the only type we support.
					if($installPlugin->getInstallType() == 'Install_Table')
					{
						if(check_opendb_table($installPlugin->getInstallTable(), FALSE))
						{
							// get rid of any directory information.
							if(strlen($HTTP_VARS['import_file'])>0)
							{
								$HTTP_VARS['import_file'] = basename($HTTP_VARS['import_file']);

								if(file_exists('./patch/site/upload/'.$HTTP_VARS['import_file']))
								{
									$extension = get_file_ext($HTTP_VARS['import_file']);
									$importPlugin =& get_extension_import_plugin($extension);
									if($importPlugin !== NULL)
									{
										$fh = @fopen('./patch/site/upload/'.$HTTP_VARS['import_file'], 'rb');
										if($fh!==FALSE)
										{
											@set_time_limit(600);

											echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");

											echo("\n<h3>".$site_plugin_r['title']." Install Maintenance - Updating ".strtoupper($installPlugin->getInstallTable())." table</h3>");

											echo("<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&site_type=".$HTTP_VARS['site_type']."&op=maintain_site_plugin_install\">Back to CSV File List</a>]</div>");
											echo("<br>");
											echo("\n<div class=\"colortext\">Importing ".$HTTP_VARS['import_file']."...</div>");

											if(preg_match("/([0-9]*)[\s]*-[\s]*([0-9]*)/", $HTTP_VARS['range'], $matches))
											{
												$installPlugin->setRowRange($matches[1], $matches[2]);
											}

											$fileHandler =& new WrapperFileHandler($fh);

											$header_row = $importPlugin->read_header($fileHandler, $error);

											// pass first row in
											$installPlugin->_handleRow($header_row);

											while( !$installPlugin->isEndRowFound() && !$fileHandler->isEof() && ($read_row_r = $importPlugin->read_row($fileHandler, $error)) !== FALSE )
											{
												//to keep proxy server happy.
												if(($installPlugin->getRowCount() % 100)===0)
													echo("\n");
												else
													echo(" ");

												flush();

												$installPlugin->_handleRow($read_row_r);
											}
											fclose($fh);

											echo("<br><table>");
											echo("<tr><td class=\"prompt\">Rows Processed:</td><td class=\"data\">".$installPlugin->getProcessedCount()."</td></tr>");
											echo("<tr><td class=\"prompt\">Rows Inserted:</td><td class=\"data\">".$installPlugin->getInsertCount()."</td></tr>");
											echo("<tr><td class=\"prompt\">Rows Updated:</td><td class=\"data\">".$installPlugin->getUpdateCount()."</td></tr>");
											echo("<tr><td class=\"prompt\">Rows Deleted:</td><td class=\"data\">".$installPlugin->getDeleteCount()."</td></tr>");
											echo("</table>");

											$errors_r = $installPlugin->getErrors();
											if(is_not_empty_array($errors_r))
											{
												echo("\n<br><br><div class=\"error\">Error Details</div><br>");
												echo("<table>");
												reset($errors_r);
												echo("<tr><td class=\"navbar\">Row No.</td><td class=\"navbar\">Error</td><td class=\"navbar\">Details</td></tr>");
												$toggle=TRUE;
												while(list(,$error_r) = each($errors_r))
												{
													$color = ($toggle?"top":"top2");
													$toggle = !$toggle;

													echo("<tr><td class=\"$color\">".$error_r['rowcount']."</td><td class=\"$color\">".$error_r['error']."</td><td class=\"$color\">".$error_r['details']."</td></tr>");
												}
												echo("</table>");

												flush();
											}
										}
										else
										{
											$errors[] = array('error'=>'Could not access upload file', 'detail'=>$error);
											$HTTP_VARS['op'] = 'list_site_plugins';
										}
									}
									else
									{
										$errors[] = array('error'=>'Upload file extension not supported.');
										$HTTP_VARS['op'] = 'list_site_plugins';
									}
								}
								else
								{
									$errors[] = array('error'=>'Upload file not found.');
									$HTTP_VARS['op'] = 'list_site_plugins';
								}
							}//if(strlen($HTTP_VARS['import_file'])>0)
							else
							{
								echo("\n<div class=\"footer\">[<a href=\"$PHP_SELF?type=$ADMIN_TYPE&op=list_site_plugins\">Back to Site Plugin List</a>]</div>");
								echo("\n<h3>".$site_plugin_r['title']." Install Maintenance - Update ".strtoupper($installPlugin->getInstallTable())." table</h3>");

								echo(get_validation_javascript());

								$recordCount = $installPlugin->getRecordCount();
								if(is_numeric($recordCount))
								{
									echo("\n<div class=\"colortext\">Table Record Count: ".$recordCount."</div>");
								}

								$lastUpdated = $installPlugin->getLastUpdated();
								if($lastUpdated!==FALSE)
								{
									$lastUpdatedString = get_localised_timestamp(
										$CONFIG_VARS['system_admin_tools.datetime_mask'],
										$lastUpdated);
								}
								if(strlen($lastUpdated)>0)
								{
									echo("\n<div class=\"colortext\">Table last updated: ".$lastUpdatedString."</div>");
								}

								echo("\n<h4>Listing <code>./patch/site/upload/</code> directory</h4>");
								echo("\n<table border=0 width=50%>");
								echo("\n<tr>"
									."<td class=\"navbar\">CSV File</td>"
									."<td class=\"navbar\">Row Range</td>"
									."<td class=\"navbar\">Action</td>"
									."\n</tr>");

								$file_list_r = get_file_list('./patch/site/upload/', 'csv');
								if(is_not_empty_array($file_list_r))
								{
									$toggle = TRUE;
									reset($file_list_r);
									while(list(,$file) = each($file_list_r))
									{
										$color = ($toggle?"top":"top2");
										$toggle = !$toggle;
										echo("\n<tr><form action=\"$PHP_SELF\" method=\"get\">");
										echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
											"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
											"\n<input type=\"hidden\" name=\"site_type\" value=\"".$HTTP_VARS['site_type']."\">".
											"\n<input type=\"hidden\" name=\"op\" value=\"".$HTTP_VARS['op']."\">".
											"\n<input type=\"hidden\" name=\"import_file\" value=\"".$file."\">");

										echo("\n<td class=\"$color\" align=center width=50%>".$file."</td>");
										echo("\n<td class=\"$color\"><input class=\"$color\" type=\"text\" name=\"range\" value=\"0-\" onChange=\"this.value=legalCharFilter(this.value, '0123456789-');\"></td>");
										echo("<td class=\"$color\" align=center><input type=submit value=\"Import\"></td>");
										echo("\n</form></tr>");
									}
								}
								else
								{
									echo("<tr><td align=center colspan=3 class=\"error\">No files found</td></tr>");
								}
								echo("</table>");

								echo("<br><div class=footer>* Upload CSV files directly (using FTP or equivalent) to the <code>./patch/site/upload/</code> directory.</div>");
							}
						}
						else
						{
							$errors[] = array('error'=>'Plugin table '.strtoupper($installPlugin->getInstallTable()).' does not exist.');
							$HTTP_VARS['op'] = 'list_site_plugins';
						}
					}
					else
					{
						$errors[] = array('error'=>'Operation not supported');
						$HTTP_VARS['op'] = 'list_site_plugins';
					}
				}
				else
				{
					$errors[] = array('error'=>'Site Plugin installation maintenance class not found');
					$HTTP_VARS['op'] = 'list_site_plugins';
				}
			}
			else//if(is_not_empty_array($site_plugin_r))
			{
				$errors[] = array('error'=>'Site Plugin not found');
				$HTTP_VARS['op'] = 'list_site_plugins';
			}
		}

		if($HTTP_VARS['op'] == 'list_site_plugins')
		{
			if(is_not_empty_array($errors))
				echo format_error_block($errors);

			echo("\n<form name=\"navigate\" action=\"$PHP_SELF\" method=\"get\">".
				"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
				"\n<input type=\"hidden\" name=\"op\" value=\"\">".
				"\n<input type=\"hidden\" name=\"site_type\" value=\"\">".
				"\n</form>");

			echo("<table border=0>");
				echo("<tr>"
					."<td class=\"navbar\">Order</td>"
					."<td class=\"navbar\">Site</td>"
					."<td class=\"navbar\">Title</td>"
					."<td class=\"navbar\" colspan=3>&nbsp;</td>"
					."</tr>");

			$results = fetch_site_plugin_rs();
			if($results)
			{
				echo("\n<form name=\"sqlform\" action=\"$PHP_SELF\" method=\"get\">".
					"\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">".
					"\n<input type=\"hidden\" name=\"op\" value=\"\">".
					"\n<input type=\"hidden\" name=\"inc_theme\" value=\"N\">".
					"\n<input type=\"hidden\" name=\"site_type\" value=\"\">".
					"\n</form>");

				echo("\n<form name=\"s_site_plugin\" action=\"$PHP_SELF\" method=\"get\">");
				echo("\n<input type=\"hidden\" name=\"type\" value=\"".$ADMIN_TYPE."\">");
				echo("\n<input type=\"hidden\" name=\"op\" value=\"new_site_plugin\">");
				echo("\n<input type=\"hidden\" name=\"site_type\" value=\"\">");

				$row = 0;
				while($site_plugin_r = mysql_fetch_array($results, MYSQL_ASSOC))
				{
					$href = "<a href=\"admin.php?type=$ADMIN_TYPE&op=edit&site_type=".$site_plugin_r['site_type']."\">";

					echo("<tr>");
					echo("\n<td class=\"data\" align=center>".get_input_field("order_no[$row]", NULL, NULL, "number(3)", "N", $site_plugin_r['order_no'], FALSE)."</td>");
					echo("<td class=\"data\" align=center>".$site_plugin_r['site_type']."<input type=hidden name=\"site_type[$row]\" value=\"".$site_plugin_r['site_type']."\"></td>");
					echo("<td class=\"data\">".$site_plugin_r['title']."</td>");

					echo("<td class=\"data\" valign=top>");
					echo("<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='edit_site_plugin'; document.forms['navigate'].submit();\" value=\"Edit\">");
					echo("&nbsp;<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='delete_site_plugin'; document.forms['navigate'].submit();\" value=\"Delete\">");

					if(file_exists("./patch/site/".$site_plugin_r['site_type'].".install.class.php"))
					{
						echo("&nbsp;<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='maintain_site_plugin_install'; document.forms['navigate'].submit();\" value=\"Install Maintenance\">");
					}
					echo("</td>");

					echo("<td class=\"data\">");
					echo("<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='edit_site_plugin_item_types'; document.forms['navigate'].submit();\" value=\"Item Types\">");
					echo("&nbsp;<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='edit_site_plugin_links'; document.forms['navigate'].submit();\" value=\"Links\">");
					echo("&nbsp;<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='edit_site_plugin_confs'; document.forms['navigate'].submit();\" value=\"Configuration\">");
					echo("&nbsp;<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='edit_site_plugin_input_fields'; document.forms['navigate'].submit();\" value=\"Input Fields\">");
					echo("&nbsp;<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='edit_site_plugin_s_attribute_type_maps'; document.forms['navigate'].submit();\" value=\"Attribute Map\">");
					echo("&nbsp;<input type=button onclick=\"document.forms['navigate'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['navigate'].op.value='edit_site_plugin_s_attribute_type_lookup_maps'; document.forms['navigate'].submit();\" value=\"Lookup Attribute Map\">");
					echo("</td>");

					echo("<td class=\"data\" valign=top>");
					echo("<input type=button onclick=\"document.forms['sqlform'].site_type.value='".$site_plugin_r['site_type']."'; document.forms['sqlform'].op.value='sql_site_plugin'; document.forms['sqlform'].submit();\" value=\"SQL\">");
					echo("</td>");
					echo("</tr>");

					$row++;
				}
				mysql_free_result($results);

				echo("<tr>".
				"<td colspan=6 align=center>".
				"<input type=button value=\"Refresh\" onclick=\"document.forms['navigate'].op.value='".$HTTP_VARS['op']."'; document.forms['navigate'].submit();\">".
				"&nbsp;<input type=button value=\"Update\" onclick=\"this.form.op.value='update_site_plugins'; this.form.submit();\">".
				"&nbsp;<input type=button value=\"New Site Plugin\" onclick=\"document.forms['navigate'].op.value='new_site_plugin'; document.forms['navigate'].submit();\">".
				"</td>".
				"</tr>");
				echo("</form>");
			}//if($results)
			else
			{
				echo("<tr><td colspan=6 align=center><div class=error>No Site Plugins Installed</div></td></tr>");

				echo("<tr><td colspan=6 align=center>".
				"<input type=button value=\"Refresh\" onclick=\"document.forms['navigate'].op.value='".$HTTP_VARS['op']."'; document.forms['navigate'].submit();\">".
				"&nbsp;<input type=button value=\"New Site Plugin\" onclick=\"document.forms['navigate'].op.value='new_site_plugin'; document.forms['navigate'].submit();\">".
				"</td></tr>");
			}
			echo("</table>");

			$filelist = get_file_list('./patch/site/', 'sql');
			$sitelist = NULL;
			if(is_not_empty_array($filelist))
			{
				for($i=0; $i<count($filelist); $i++)
				{
					$sitelist[] = parse_file($filelist[$i]);
				}

				if(is_not_empty_array($sitelist))
				{
					echo("<br><br><div class=colortext>The following Site Plugin SQL definitions are available to be installed / reinstalled.</div>");
					echo get_popup_javascript();
					echo("<table border=0 width=50%>");
					echo("<tr>"
					."<td class=\"navbar\">Site Plugin*</td>"
					."<td class=\"navbar\">SQL File</td>"
					."<td class=\"navbar\">&nbsp;</td>"
					."<td class=\"navbar\">&nbsp;</td>"
					."</tr>");

					for($i=0; $i<count($sitelist); $i++)
					{
						if(!is_exists_site_plugin($sitelist[$i]['name'], FALSE))
							$install_text = "Install";
						else
							$install_text = "Reinstall";

						echo("<tr>".
							"<td align=center>".$sitelist[$i]['name']."</td>".
							"<td align=center>".$sitelist[$i]['name'].".".$sitelist[$i]['extension']."</td>".
							"<td><a href=\"javascript:popup('patch.php?from=site&type=optional&title=Site+Plugins&op=result&preview=true&standalone=Y&sqlfile=".$sitelist[$i]['name'].".".$sitelist[$i]['extension']."', 800, 600)\">Preview</a></td>".
							"<td><a href=\"javascript:popup('patch.php?from=site&type=optional&title=Site+Plugins&op=result&standalone=Y&sqlfile=".$sitelist[$i]['name'].".".$sitelist[$i]['extension']."', 800, 600)\">".$install_text."</a></td>".
							"</tr>");
					}
					echo("</table>");

					echo("<div class=footer>* Site Plugin name is a guess, based on the name of the SQL file itself, this may not be accurate.</div>");
				}
			}
		}
	}
	else
	{
		echo _theme_error($LANG_VARS['not_authorized_to_page']);
	}
}//(is_opendb_valid_session())
?>