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) {