Location: PHPKode > projects > Open Media Collectors Database > export.php
<?php
/* 	
	Open Media Collectors Database
	Copyright (C) 2001,2006 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.
*/

// This must be first - includes config.php
require_once("./include/begin.inc.php");

include_once("./functions/database.php");
include_once("./functions/auth.php");
include_once("./functions/logging.php");
include_once("./functions/item_type.php");
include_once("./functions/item.php");
include_once("./functions/item_attribute.php");
include_once("./functions/user.php");
include_once("./functions/widgets.php");
include_once("./functions/utils.php");
include_once("./functions/export.php");
include_once("./functions/TitleMask.class.php");

/*
* Export Type 
*/
function export_type_items(&$exportPlugin, $page_title, $s_item_type, $item_id, $instance_no, $owner_id)
{
	if(is_numeric($item_id) && is_numeric($instance_no))
	{
		send_header($exportPlugin, $page_title);
		
		$item_r = fetch_item_instance_r($item_id, $instance_no);
		if($item_r['owner_id'] == get_opendb_session_var('user_id') || is_user_granted_permission(PERM_VIEW_ITEM_DISPLAY))
		{
			send_data(get_export_type_item($exportPlugin, $item_id, $instance_no, $item_r['s_item_type'], $item_r['title'], $owner_id));
		}
		
		send_footer($exportPlugin);
		return TRUE;
	}
	else
	{
		$itemresults = fetch_export_item_rs($s_item_type, $owner_id);
		if($itemresults)
		{
			send_header($exportPlugin, $page_title);
			while($item_r = db_fetch_assoc($itemresults))
			{
				send_data(get_export_type_item($exportPlugin, $item_r['item_id'], NULL, $item_r['s_item_type'], $item_r['title'], $owner_id));
			}
			db_free_result($itemresults);
			
			send_footer($exportPlugin);
			return TRUE;
		}
	}
	
	//else
	return FALSE;
}

/*
*/
function get_export_type_item(&$exportPlugin, $item_id, $instance_no, $s_item_type, $title, $owner_id)
{
	$buffer = '';
	
	$buffer .= $exportPlugin->start_item($item_id, $s_item_type, $title);
	
	// export item (non instance level) attributes.
	$buffer .= export_type_item_attributes($exportPlugin, $item_id, NULL, $s_item_type);
	
	if(is_numeric($instance_no))
	{
		$item_instance_r = fetch_item_instance_r($item_id, $instance_no);
		if(is_not_empty_array($item_instance_r))
		{
			$buffer .= $exportPlugin->start_item_instance($item_instance_r['instance_no'], $item_instance_r['owner_id'], $item_instance_r['borrow_duration'], $item_instance_r['s_status_type'], $item_instance_r['status_comment']);
			$buffer .= export_type_item_attributes($exportPlugin, $item_id, $item_instance_r['instance_no'], $s_item_type);
			$buffer .= $exportPlugin->end_item_instance();
		}
	}
	else
	{
		$iiresults = fetch_item_instance_rs($item_id, $owner_id);
		if($iiresults)
		{
			while($item_instance_r = db_fetch_assoc($iiresults))
			{
				$buffer .= $exportPlugin->start_item_instance($item_instance_r['instance_no'], $item_instance_r['owner_id'], $item_instance_r['borrow_duration'], $item_instance_r['s_status_type'], $item_instance_r['status_comment']);
				$buffer .= export_type_item_attributes($exportPlugin, $item_id, $item_instance_r['instance_no'], $s_item_type);
				$buffer .= $exportPlugin->end_item_instance();
			}
			db_free_result($iiresults);
		}
	}
	
	$buffer .= $exportPlugin->end_item();
	return $buffer;
}

function export_type_item_attributes($exportPlugin, $item_id, $instance_no, $s_item_type)
{
    $buffer = '';
    
	$attresults = fetch_item_attribute_type_rs($s_item_type, is_numeric($instance_no)?'instance_attribute_ind':'item_attribute_ind', FALSE);
	if($attresults)
	{
		while($item_attribute_type_r = db_fetch_assoc($attresults))
		{
			// Only attribute specific s_field_type's should be exported as XML.
			if(strlen($item_attribute_type_r['s_field_type'])==0 || (
						$item_attribute_type_r['s_field_type'] != 'TITLE' &&
						$item_attribute_type_r['s_field_type'] != 'DURATION' &&
						$item_attribute_type_r['s_field_type'] != 'STATUSTYPE' &&
						$item_attribute_type_r['s_field_type'] != 'STATUSCMNT' &&
						$item_attribute_type_r['s_field_type'] != 'ITEM_ID') )
			{
				$item_attribute_val_r = fetch_attribute_val_r($item_id, $instance_no, $item_attribute_type_r['s_attribute_type'], $item_attribute_type_r['order_no']);
				if(is_not_empty_array($item_attribute_val_r))
				{
				    for($i=0; $i<count($item_attribute_val_r); $i++)
					{
						$buffer .= $exportPlugin->item_attribute($item_attribute_type_r['s_attribute_type'], $item_attribute_type_r['order_no'], $item_attribute_val_r[$i]);
					}
				}
			}
		}
		db_free_result($attresults);
	}
	
	return $buffer;
}

/**
* Row Export
*/
function export_row_items(&$exportPlugin, $page_title, $include_header, $export_columns, $s_item_type, $owner_id)
{
	$iiresults = fetch_export_item_instance_rs($s_item_type, $owner_id);
	if($iiresults)
	{
		send_header($exportPlugin, $page_title);

		if($include_header == 'Y')
		{
			if(method_exists($exportPlugin, 'prompt_header'))
			{
				$row = get_header_row('prompt', $export_columns, $s_item_type);
				if(is_not_empty_array($row))
				{
					send_data($exportPlugin->prompt_header($row));
				}
			}
			else if(method_exists($exportPlugin, 'data_header'))
			{
				$row = get_header_row('data', $export_columns, $s_item_type);
				if(is_not_empty_array($row))
				{
					send_data($exportPlugin->data_header());
				}
			}
		}
		
		$item_instance_r2 = NULL;
		while($item_instance_r = db_fetch_assoc($iiresults))
		{
			$row = get_item_row(
						$export_columns,
						strlen($s_item_type)==0,
						$item_instance_r['item_id'], 
						$item_instance_r['instance_no'],
						$item_instance_r['owner_id'],
						$item_instance_r['s_item_type'],
						$item_instance_r['title'],
						$item_instance_r['borrow_duration'],
						$item_instance_r['s_status_type'],
						$item_instance_r['status_comment']);

			if(is_not_empty_array($row))
			{
				send_data($exportPlugin->item_row($row));
			}
						
			$item_instance_r2 = $item_instance_r;
		}
		
		db_free_result($iiresults);
		
		if(method_exists($exportPlugin, 'close'))
		{
			send_data($exportPlugin->close());
		}
		
		send_footer($exportPlugin);
		return TRUE;
	}
	else
	{
		return FALSE;
	}
}

function get_item_row($export_columns, $is_all_item_types, $item_id, $instance_no, $owner_id, $s_item_type, $title, $borrow_duration, $s_status_type, $status_comment)
{
	if(!is_array($export_columns) || $export_columns['item_id'] == 'Y')
	{
		$row[] = $item_id;
	}
	
	if(!is_array($export_columns) || $export_columns['instance_no'] == 'Y')
	{
		$row[] = $instance_no;
	}
	
	if(!is_array($export_columns) || $export_columns['owner_id'] == 'Y')
	{
		$row[] = $owner_id;
	}
	
	if(!is_array($export_columns) || $export_columns['s_item_type'] == 'Y')
	{
		$row[] = $s_item_type;
	}
	
	if($is_all_item_types !== TRUE)
	{
		$results = fetch_item_attribute_type_rs($s_item_type);
		if($results)
		{
			while($item_attribute_type_r = db_fetch_assoc($results))
			{
				$fieldname = get_field_name($item_attribute_type_r['s_attribute_type'], $item_attribute_type_r['order_no']);
				if(!is_array($export_columns) || $export_columns[$fieldname] == 'Y')
				{
					if($item_attribute_type_r['s_field_type'] != 'ITEM_ID')
					{
						if($item_attribute_type_r['s_field_type'] == 'TITLE')
						{
							$row[] = $title;
						}
						else if($item_attribute_type_r['s_field_type'] == 'DURATION')
						{
							$row[] = $borrow_duration;
						}
						else if($item_attribute_type_r['s_field_type'] == 'STATUSTYPE')
						{
							$row[] = $s_status_type;
						}
						else if($item_attribute_type_r['s_field_type'] == 'STATUSCMNT')
						{
							$row[] = $status_comment;
						}
						else 
						{
							$item_attribute_val_r = fetch_attribute_val_r($item_id, $instance_no, $item_attribute_type_r['s_attribute_type'], $item_attribute_type_r['order_no']);
							if(is_not_empty_array($item_attribute_val_r))
							{
								// the plugins will have to handle a array, and format it appropriately.
								$row[] = $item_attribute_val_r;
							}
							else
							{
								$row[] = ''; // nothing.
							}
						}
					}
				}
			}
			db_free_result($results);
		}
	}
	else
	{
		if(!is_array($export_columns) || $export_columns['title'] == 'Y')
		{
			$row[] = $title;
		}
	}
	
	return $row;
}

function get_header_row($header_type, $export_columns, $s_item_type)
{
	if(!is_array($export_columns) || $export_columns['item_id'] == 'Y')
	{
		if($header_type == 'data')
			$headings[] = 'item_id';
		else
			$headings[] = get_opendb_lang_var('item_id');
	}
	
	if(!is_array($export_columns) || $export_columns['instance_no'] == 'Y')
	{
		if($header_type == 'data')
			$headings[] = 'instance_no';
		else
			$headings[] = get_opendb_lang_var('instance_no');
	}
	
	if(!is_array($export_columns) || $export_columns['owner_id'] == 'Y')
	{
		if($header_type == 'data')
			$headings[] = 'owner_id';
		else
			$headings[] = get_opendb_lang_var('owner_id');
	}
	
	if(!is_array($export_columns) || $export_columns['s_item_type'] == 'Y')
	{
		if($header_type == 'data')
			$headings[] = 's_item_type';
		else
			$headings[] = get_opendb_lang_var('s_item_type');
	}
	
	if(strlen($s_item_type)>0)
	{
		// Get the item_attribute headings.
		$results = fetch_item_attribute_type_rs($s_item_type);
		if($results)
		{
			while($item_attribute_type_r = db_fetch_assoc($results))
			{
				// Only legal s_field_type's - ignore ITEM_ID!!!
				if(strlen($item_attribute_type_r['s_field_type'])==0 || 
							$item_attribute_type_r['s_field_type'] == 'CATEGORY' || 
							$item_attribute_type_r['s_field_type'] == 'TITLE' || 
							$item_attribute_type_r['s_field_type'] == 'DURATION' ||
							$item_attribute_type_r['s_field_type'] == 'STATUSTYPE' ||
							$item_attribute_type_r['s_field_type'] == 'STATUSCMNT' ||
							$item_attribute_type_r['s_field_type'] == 'IMAGE')
				{
					$fieldname = get_field_name($item_attribute_type_r['s_attribute_type'], $item_attribute_type_r['order_no']);
					if(!is_array($export_columns) || $export_columns[$fieldname] == 'Y')
					{
						if($header_type == 'data')
						{
							$headings[] = $fieldname;
						}
						else //if($header_type == 'prompt')
						{
							$headings[] = $item_attribute_type_r['prompt'];
						}
					}
				}
			}
			db_free_result($results);
		}
	}
	else
	{
		if(!is_array($export_columns) || $export_columns['title'] == 'Y')
		{
			if($header_type == 'data')
				$headings[] = 'title';
			else
				$headings[] = get_opendb_lang_var('title');
		}
	}
	return $headings;
}

function send_data($buffer)
{
	if(strlen($buffer))
	{
		echo($buffer);
			
		// do explicit flush
		flush();
	}
}

function send_header(&$exportPlugin, $page_title)
{
	// hard code for now
	$filename_prefix = 'export';

	if(method_exists($exportPlugin, 'get_file_extension'))
	{
		$filename = $filename_prefix.'.'.$exportPlugin->get_file_extension();
	}
	else
	{
		$filename = $filename_prefix.'.txt';
	}
		
	if(method_exists($exportPlugin, 'get_file_content_type'))
	{
		$content_type = $exportPlugin->get_file_content_type();
	}
	else
	{
		$content_type = 'text/plain';
	}
	
	if(method_exists($exportPlugin, 'http_header'))
	{
		$exportPlugin->http_header($filename, $content_type);
	}
	else
	{
		header("Cache-control: no-store");
		header("Pragma: no-store");
		header("Expires: 0");
		header("Content-disposition: attachment; filename=$filename");
		header("Content-type: $content_type");
	}
	
	if(method_exists($exportPlugin, 'file_header'))
	{
		send_data($exportPlugin->file_header($page_title));
	}
}

function send_footer(&$exportPlugin)
{
	if(method_exists($exportPlugin, 'file_footer'))
	{
		send_data($exportPlugin->file_footer());
	}
}

function get_row_export_column_form(&$exportPlugin, $HTTP_VARS)
{
	global $PHP_SELF;
	
	$buffer .= "\n<form method=\"POST\" action=\"$PHP_SELF\">";
	$buffer .= "\n<input type=\"hidden\" name=\"op\" value=\"export\">";
	$buffer .= "\n<input type=\"hidden\" name=\"owner_id\" value=\"".$HTTP_VARS['owner_id']."\">";
	$buffer .= "\n<input type=\"hidden\" name=\"s_item_type\" value=\"".$HTTP_VARS['s_item_type']."\">";
	$buffer .= "\n<input type=\"hidden\" name=\"plugin\" value=\"".$HTTP_VARS['plugin']."\">";
	
	$buffer .= "\n<ul class=\"checkboxGridOptionsVertical\">";
	
	$buffer .= "\n<li><input type=\"checkbox\" class=\"checkbox\" name=\"export_columns[item_id]\" value=\"Y\">".get_opendb_lang_var('item_id')."</li>";
	$buffer .= "\n<li><input type=\"checkbox\" class=\"checkbox\" name=\"export_columns[instance_no]\" value=\"Y\">".get_opendb_lang_var('instance_no')."</li>";
	$buffer .= "\n<li><input type=\"checkbox\" class=\"checkbox\" name=\"export_columns[owner_id]\" value=\"Y\">".get_opendb_lang_var('owner_id')."</li>";
	$buffer .= "\n<li><input type=\"checkbox\" class=\"checkbox\" name=\"export_columns[item_id]\" value=\"Y\"".(strlen($HTTP_VARS['owner_id'])==0?' CHECKED':'').">".get_opendb_lang_var('item_id')."</li>";
	$buffer .= "\n<li><input type=\"checkbox\" class=\"checkbox\" name=\"export_columns[s_item_type]\" value=\"Y\">".get_opendb_lang_var('s_item_type')."</li>";
	
	if(strlen($HTTP_VARS['s_item_type'])>0)
	{
		$results = fetch_item_attribute_type_rs($HTTP_VARS['s_item_type']);
		if($results)
		{
			while($item_attribute_type_r = db_fetch_assoc($results))
			{
				// Only legal s_field_type's - ignore ITEM_ID!!!
				if(strlen($item_attribute_type_r['s_field_type'])==0 || 
							$item_attribute_type_r['s_field_type'] == 'CATEGORY' || 
							$item_attribute_type_r['s_field_type'] == 'TITLE' || 
							$item_attribute_type_r['s_field_type'] == 'DURATION' ||
							$item_attribute_type_r['s_field_type'] == 'STATUSTYPE' ||
							$item_attribute_type_r['s_field_type'] == 'STATUSCMNT' ||
							$item_attribute_type_r['s_field_type'] == 'IMAGE')
				{
					$buffer .= '<li><input type="checkbox" class="checkbox" name="export_columns['.get_field_name($item_attribute_type_r['s_attribute_type'], $item_attribute_type_r['order_no']).']" value="Y"';
								
					
					// work out what columns to have checked by default.
					if( $item_attribute_type_r['s_field_type'] == 'TITLE' || 
								$item_attribute_type_r['s_field_type'] == 'IMAGE' || 
								(strlen($item_attribute_type_r['s_field_type'])==0 && 
									strcasecmp(ifempty($item_attribute_type_r['display_type'],$item_attribute_type_r['input_type']), "hidden")!==0) )
					{
						$buffer .= ' CHECKED';
					}
					
					$buffer .= '>'.$item_attribute_type_r['prompt']."</li>";
				}
			}
			db_free_result($results);
		}
	}
	else
	{
		$buffer .= "\n<li><input type=\"checkbox\" class=\"checkbox\" name=\"export_columns[title]\" value=\"Y\">".get_opendb_lang_var('title')."</li>";
	}
	
	if(method_exists($exportPlugin, 'prompt_header') || method_exists($exportPlugin, 'data_header'))
	{		
		$buffer .= "\n<li id=\"include-header\"><input type=\"checkbox\" class=\"checkbox\" name=\"include_header\" value=\"Y\" CHECKED>".get_opendb_lang_var('include_header')."</li>";
	}
	
	$buffer .= "</ul>";
	
	$buffer .= "\n<ul class=\"actionButtons\">";
	$buffer .= "\n<li><input type=\"button\" class=\"button\" value=\"".get_opendb_lang_var('check_all')."\" onClick=\"setCheckboxes(this.form, 'export_columns', true);\"></li>".
	"\n<li><input type=\"button\" class=\"button\" value=\"".get_opendb_lang_var('uncheck_all')."\" onClick=\"setCheckboxes(this.form, 'export_columns', false);\"></li>".
	"\n<li><input type=\"reset\" class=\"reset\" value=\"".get_opendb_lang_var('reset')."\"></li>".
	"\n<li class=\"submitButton\"><input type=\"submit\" class=\"submit\" value=\"".get_opendb_lang_var('export_items')."\"></li>".
	"</ul>";
							
	$buffer .= '</form>';
	
	return $buffer;
}

if(is_site_enabled())
{
	if(is_opendb_valid_session())
	{
		if(is_user_granted_permission(PERM_ADMIN_EXPORT) || is_user_granted_permission(PERM_USER_EXPORT))  
		{
			if(!is_numeric($HTTP_VARS['item_id']) && !is_user_granted_permission(PERM_ADMIN_EXPORT))
			{
				$HTTP_VARS['owner_id'] = get_opendb_session_var('user_id');
			}
			
			if($HTTP_VARS['op'] == 'export')
			{
				$exportPlugin =& get_export_plugin($HTTP_VARS['plugin']);
				if($exportPlugin !== NULL)
				{
					if(strlen($HTTP_VARS['s_item_type'])==0 || is_valid_item_type_structure($HTTP_VARS['s_item_type']))
					{
						if($exportPlugin->get_plugin_type() == 'row')
						{
							// Work out page title.
							if(strlen($HTTP_VARS['owner_id'])>0)
								$page_title = get_opendb_lang_var('type_export_for_name_item_type', array('description'=>$exportPlugin->get_display_name(), 'fullname'=>fetch_user_name($HTTP_VARS['owner_id']),'user_id'=>$HTTP_VARS['owner_id'], 's_item_type'=>$HTTP_VARS['s_item_type']));
							else if(strlen($HTTP_VARS['s_item_type'])>0)
								$page_title = get_opendb_lang_var('type_export_for_item_type', array('description'=>$exportPlugin->get_display_name(), 's_item_type'=>$HTTP_VARS['s_item_type']));
							else
								$page_title = get_opendb_lang_var('type_export', array('description'=>$exportPlugin->get_display_name()));
							
							if(is_not_empty_array($HTTP_VARS['export_columns']))
							{
								@set_time_limit(600);
								if(!export_row_items($exportPlugin, $page_title, $HTTP_VARS['include_header'], $HTTP_VARS['export_columns'], $HTTP_VARS['s_item_type'], $HTTP_VARS['owner_id']))
								{
									echo _theme_header($page_title);
									echo("<h2>".$page_title."</h2>");
									echo format_error_block(array('error'=>get_opendb_lang_var('no_records_found'),'detail'=>''));
									echo _theme_footer();
								}
							}
							else
							{
								echo _theme_header($page_title);
								echo("<h2>".$page_title."</h2>");
								
								echo("<h3>".get_opendb_lang_var('choose_export_fields')."</h3>");
									
								echo(get_row_export_column_form($exportPlugin, $HTTP_VARS));
									
								echo _theme_footer();
							}
						}
						else if($exportPlugin->get_plugin_type() == 'item')
						{
						    $titleMaskCfg = new TitleMask('item_display');
						    
							// Work out page title.
							if(strlen($HTTP_VARS['owner_id'])>0 || is_numeric($HTTP_VARS['item_id']))
							{
								if(strlen($HTTP_VARS['owner_id'])>0 && strlen($HTTP_VARS['s_item_type'])>0)
									$page_title = get_opendb_lang_var('type_export_for_name_item_type', array('description'=>$exportPlugin->get_display_name(), 'fullname'=>fetch_user_name($HTTP_VARS['owner_id']),'user_id'=>$HTTP_VARS['owner_id'], 's_item_type'=>$HTTP_VARS['s_item_type']));
								else if(strlen($HTTP_VARS['s_item_type'])>0)
									$page_title = get_opendb_lang_var('type_export_for_item_type', array('description'=>$exportPlugin->get_display_name(), 's_item_type'=>$HTTP_VARS['s_item_type']));
								else if(is_numeric($HTTP_VARS['item_id']) && is_numeric($HTTP_VARS['instance_no']))
								{
									$item_r = fetch_item_instance_r($HTTP_VARS['item_id'], $HTTP_VARS['instance_no']);
									$page_title = get_opendb_lang_var('type_export_for_item_instance', array('description'=>$exportPlugin->get_display_name(), 'item_id'=>$HTTP_VARS['item_id'],'instance_no'=>$HTTP_VARS['instance_no'],'title'=>$titleMaskCfg->expand_item_title($item_r)));
								}
								else if(is_numeric($HTTP_VARS['item_id']))
								{
									// Not really a child item, but we are not interested in the instance, so use this.  It still
									// returns the right data anyway.
									$item_r = fetch_child_item_r($HTTP_VARS['item_id']);
									$page_title = get_opendb_lang_var('type_export_for_item', array('description'=>$exportPlugin->get_display_name(), 'item_id'=>$HTTP_VARS['item_id'],'title'=>$titleMaskCfg->expand_item_title($item_r)));
								}
								else
								{
									$page_title = get_opendb_lang_var('type_export_for_name', array('description'=>$exportPlugin->get_display_name(), 'fullname'=>fetch_user_name($HTTP_VARS['owner_id']), 'user_id'=>$HTTP_VARS['owner_id']));
								}
							}//if(strlen($HTTP_VARS['owner_id'])>0 || is_numeric($HTTP_VARS['item_id']))
							else
							{
								$page_title = get_opendb_lang_var('type_export', array('description'=>$exportPlugin->get_display_name()));
							}
							
							@set_time_limit(600);
							if(!export_type_items($exportPlugin, $page_title, $HTTP_VARS['s_item_type'], $HTTP_VARS['item_id'], $HTTP_VARS['instance_no'], $HTTP_VARS['owner_id']))
							{
								echo _theme_header($page_title);
								echo("<h2>".$page_title."</h2>");
								echo format_error_block(array('error'=>get_opendb_lang_var('no_records_found'),'detail'=>''));
								echo _theme_footer();
							}
						}//get_plugin_type() not supported.
						else
						{
							echo _theme_header(get_opendb_lang_var('undefined_error'));
							echo("<p class=\"error\">".get_opendb_lang_var('undefined_error')."</p>");
							echo _theme_footer();
						}
					}//if(strlen($HTTP_VARS['s_item_type'])==0 || is_valid_item_type_structure($HTTP_VARS['s_item_type']))
					else
					{
						$page_title = get_opendb_lang_var('type_export', array('description'=>$exportPlugin->get_display_name()));
						echo _theme_header($page_title);
						echo("<h2>".$page_title."</h2>");
						echo(format_error_block(array('error'=>get_opendb_lang_var('invalid_item_type_structure', 's_item_type', $HTTP_VARS['s_item_type']),'detail'=>'')));
						echo _theme_footer();
					}
				}//if($importPlugin !== NULL)
				else
				{
					echo _theme_header(get_opendb_lang_var('undefined_error'));
					echo("<p class=\"error\">".get_opendb_lang_var('undefined_error')."</p>");
					echo _theme_footer();
				}
			}
			else
			{
				// A custom title.
				if(is_user_granted_permission(PERM_ADMIN_EXPORT) && strlen($HTTP_VARS['owner_id'])==0)
					$page_title = get_opendb_lang_var('export_items');
				else if($HTTP_VARS['owner_id'] == get_opendb_session_var('user_id') || strlen($HTTP_VARS['owner_id'])==0)
					$page_title = get_opendb_lang_var('export_my_items');
					
				echo _theme_header($page_title);
				echo("<h2>".$page_title."</h2>");
				
				echo("<form method=\"GET\" action=\"$PHP_SELF\">");
				echo("\n<input type=\"hidden\" name=\"op\" value=\"export\">");
				
				echo("<table>");
				
				if(is_user_granted_permission(PERM_ADMIN_EXPORT))
				{
					echo format_field(
							get_opendb_lang_var('owner'), 
							"\n<select name=\"owner_id\">".
								"\n<option value=\"\">-------------- ".get_opendb_lang_var('all')." --------------".
								custom_select(
									'owner_id', 
									fetch_user_rs(PERM_USER_EXPORT), 
									'%fullname% (%user_id%)',
									'NA',
									ifempty($HTTP_VARS['owner_id'], get_opendb_session_var('user_id')),
									'user_id'
								).
								"\n</select>"
							);
				}
				else
				{
					echo("<input type=\"hidden\" name=\"owner_id\" value=\"".$HTTP_VARS['owner_id']."\">");
				}
				
				echo format_field(
						get_opendb_lang_var('item_type'), 
						"<select name=\"s_item_type\">".
							"\n<option value=\"\">-------------- ".get_opendb_lang_var('all')." --------------".
							custom_select(
									's_item_type', 
									fetch_item_type_rs(),
									'%s_item_type% - %description%',
									'NA',
									$HTTP_VARS['s_item_type'],
									's_item_type').
						"\n</select>"
					);
					
				$field = "\n<select name=\"plugin\">\n";
				$plugin_list_r = get_export_plugin_list_r();
				if(is_array($plugin_list_r))
				{
					while(list(,$plugin_r) = @each($plugin_list_r))
					{
						$field .= '<option value="'.$plugin_r['name'].'">'.$plugin_r['description']."\n";
					}
				}
				$field .= "</select>";
				
				echo format_field(get_opendb_lang_var('type'), $field);
				
				echo("</table>");
					
				echo("<input type=\"submit\" class=\"submit\" value=\"".get_opendb_lang_var('submit')."\">");
				
				echo("</form>");
				
				echo _theme_footer();
			}
		}
		else//no guests or borrowers allowed!
		{
			echo _theme_header(get_opendb_lang_var('not_authorized_to_page'));
			echo("<p class=\"error\">".get_opendb_lang_var('not_authorized_to_page')."</p>");
			echo _theme_footer();
		}	
	}
	else
	{
		// invalid login, so login instead.
		redirect_login($PHP_SELF, $HTTP_VARS);
	}
}//if(is_site_enabled())
else
{
	echo _theme_header(get_opendb_lang_var('site_is_disabled'), FALSE);
	echo("<p class=\"error\">".get_opendb_lang_var('site_is_disabled')."</p>");
	echo _theme_footer();
}

// Cleanup after begin.inc.php
require_once("./include/end.inc.php");
?>
Return current item: Open Media Collectors Database