echo "</form>";
CloseTable();
break;
case 'category':
echo "<h3>" . _AM_CATEGORY . "</h3>\n";
echo "<hr /><br />";
if (isset($_GET['catid'])) {
edit_category(intval($_GET['catid']));
} else {
show_categories();
}
break;
case 'catimp':
echo "<h3>" . _AM_CATEGORY . "</h3>\n";
echo "<hr /><br />";
import_category();
break;
case 'summary':
echo "<h3>" . _AM_SUMMARY . "</h3>\n";
echo "<hr /><br />";
$now = time();
$result = $xoopsDB->query('SELECT count(eid) FROM ' . EGTBL . ' LEFT JOIN ' . EXTBL . " ON eid=eidref");
list($count) = $xoopsDB->fetchRow($result);
$max = $xoopsModuleConfig['max_list'];
$start = isset($_GET['start']) ? intval($_GET['start']) : 0;
$nav = new XoopsPageNav($count, $max, $start, "start", 'op=summary');
$show = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/event.php';
$receipt = XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/receipt.php';
$result = $xoopsDB->query('SELECT e.eid,if(x.exid,x.exid,0) exid, IF(exdate,exdate,edate) exdate,title,uid,status,persons,IF(x.reserved,x.reserved,o.reserved) reserved FROM ' . EGTBL . ' e LEFT JOIN ' . OPTBL . ' o ON e.eid=o.eid LEFT JOIN ' . EXTBL . " x ON e.eid=eidref ORDER BY exdate DESC,e.eid DESC", $max, $start);
if ($count > $max) {
echo $nav->renderNav();
case 4:
if ($_POST['submit'] == "Clear existing data and import") {
if (!CCategoryManager::ClearAllCategories()) {
break;
}
echo "Cleared all categories.<br/>";
$import_type = "override";
} else {
if ($_POST['submit'] == "Merge with existing data") {
$import_type = "merge";
} else {
header('Location: xls_importer.php');
}
}
$filename = $_POST['filename'];
import_category($filename);
$extra_data = array();
$extra_data[0] = $filename;
// name of uploaded file
$extra_data[1] = $import_type;
// type of importing
go_to_step(5, $extra_data);
break;
case 5:
$filename = $_POST['filename'];
$import_type = $_POST['import_type'];
$added_row_count = isset($_POST['added_row_count']) ? $_POST['added_row_count'] : 0;
$last_time = isset($_POST['last_time']) ? $_POST['last_time'] : 0;
$duplicated_time_count = isset($_POST['duplicated_time_count']) ? $_POST['duplicated_time_count'] : 0;
if (isset($filename) && isset($import_type)) {
if ($import_type == "override" && $added_row_count == 0) {
