Added ability to export catalog to iTunes database

Fixed sql error when creating catalog

2 files changed, 56 insertions, 0 deletions

diff --git a/templates/show_export.inc.php b/templates/show_export.inc.php
new file mode 100644
index 00000000..eece02f2
--- /dev/null
+++ b/templates/show_export.inc.php
@@ -0,0 +1,55 @@
+<?php
+/*
+
+ Copyright (c) 2001 - 2007 Ampache.org
+ All rights reserved.
+
+ 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; version 2
+ of the License. 
+
+ 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.
+
+*/
+show_box_top(_('Export Catalog')); ?>
+<form name="duplicates" action="<?php echo Config::get('web_path'); ?>/admin/export.php?action=export" method="post" enctype="multipart/form-data" >
+<table cellspacing="0" cellpadding="3">
+<tr>
+	<td valign="top"><strong><?php echo _('Catalog'); ?>:</strong></td>
+	<td>
+		<select id="export_catalog" name="export_catalog" width="150" style="width: 150px">
+			<option value="">(all)</option>
+<?php
+		$catalog_ids = Catalog::get_catalogs(); 
+		foreach ($catalog_ids as $cat_id) {
+			$cat = new Catalog($cat_id);
+?>
+			<option value="<?php echo $cat->id; ?>" <?php if($_REQUEST['export_catalog']==$cat->id) echo "selected=\"selected\"" ?>><?php echo $cat->name; ?></option>
+<?php
+		}
+?>
+		</select>
+	</td>
+</tr>
+<tr>
+	<td valign="top"><strong><?php echo _('Format'); ?>:</strong></td>
+	<td>
+		<select id="export_format" name="export_format" width="150" style="width: 150px">
+			<option value="itunes" <?php if($_REQUEST['export_format']=='itunes') echo "selected=\"selected\"" ?>>iTunes</option>
+		</select>
+	</td>
+</tr>
+</table>
+<div class="formValidation">
+      <input type="submit" value="<?php echo _('Export'); ?>" />
+</div>
+</form>
+<?php show_box_bottom(); ?>
diff --git a/templates/sidebar_admin.inc.php b/templates/sidebar_admin.inc.php
index 45630bca..0f0411ab 100644
--- a/templates/sidebar_admin.inc.php
+++ b/templates/sidebar_admin.inc.php
@@ -25,6 +25,7 @@
       <li id="sb_admin_ot_ClearNowPlaying"><a href="<?php echo $web_path; ?>/admin/catalog.php?action=clear_now_playing"><?php echo _('Clear Now Playing'); ?></a></li>
       <li id="sb_admin_ot_ClearCatStats"><a href="<?php echo $web_path; ?>/admin/catalog.php?action=clear_stats"><?php echo _('Clear Stats'); ?></a></li>
       <li id="sb_admin_ot_ManageFlagged"><a href="<?php echo $web_path; ?>/admin/flag.php"><?php echo _('Manage Flagged'); ?></a></li>
+      <li id="sb_admin_ot_Export"><a href="<?php echo $web_path; ?>/admin/export.php"><?php echo _('Export'); ?></a></li>
       <?php if (Config::get('shoutbox')) { ?>
       <li id="sb_admin_ot_ManageShoutbox"><a href="<?php echo $web_path; ?>/shout.php?action=show_manage"><?php echo _('Manage Shoutbox'); ?></a></li>
       <?php } ?>