$res = $xoopsDB->query("SELECT catid, cname FROM " . TCAT . " WHERE catid IN (" . get_exists_ids(TLOG, 'pcat') . ")"); $categ = array(); if ($res && $xoopsDB->getRowsNum($res)) { if (isset($_SESSION['logtick']['cats']) && empty($catid)) { $catid = $_SESSION['logtick']['cats']; } $cats = split(',', $catid); while ($cat = $xoopsDB->fetchArray($res)) { $cat['cname'] = htmlspecialchars($cat['cname']); $cat['checked'] = in_array($cat['catid'], $cats); $categ[] = $cat; } } // input form $xoopsTpl->assign('mycategories', lt_get_categories()); $xoopsTpl->assign('timespans', lt_split_options($xoopsModuleConfig['timespans'])); $xoopsTpl->assign('users', $users); $xoopsTpl->assign('categories', $categ); $xoopsTpl->assign('interval', $xoopsModuleConfig['interval']); $modurl = XOOPS_URL . '/modules/' . basename(dirname(__FILE__)); $xoopsTpl->assign('logresult', show_list($uid, $catid)); $xoopsTpl->assign("xoops_js", $xoopsTpl->get_template_vars('xoops_js') . "\n//--></script><script type='text/javascript' src='{$modurl}/logtick.js'><!--"); $xoopsTpl->assign('now', $now); include XOOPS_ROOT_PATH . '/footer.php'; function get_exists_ids($table, $idname) { global $xoopsDB; $res = $xoopsDB->query("SELECT {$idname} FROM {$table} GROUP BY {$idname}"); $ids = array(); while (list($u) = $xoopsDB->fetchRow($res)) { $ids[] = $u;
if (isset($_POST['delete'])) { $logid = intval($_POST['logid']); $res = $xoopsDB->query("DELETE FROM " . TLOG . " WHERE logid={$logid}"); redirect_header('index.php', 1, _MD_LOGTICK_DELETED); exit; } } include XOOPS_ROOT_PATH . '/header.php'; $xoopsOption['template_main'] = 'logtick_editlog.html'; set_logtick_breadcrumbs(array(_MD_LOGTICK_EDITLOG => 'index.php')); $res = $xoopsDB->query("SELECT * FROM " . TLOG . " WHERE logid={$logid}"); $data = $xoopsDB->fetchArray($res); $ptime = new pastTime(); $data['comment'] = htmlspecialchars($data['comment']); $data['lspan'] = htmlspecialchars($data['lspan']); $spans = lt_split_options($xoopsModuleConfig['timespans']); $span = $data['lspan']; foreach (array_keys($spans) as $v) { if (span2sec($v) == $span) { $data['span'] = $v; break; } } if (!isset($data['span'])) { $spans[$lspan] = $ptime->getSpan($lspan); $data['span'] = $span; } $data['ldate'] = formatTimestamp($data['ltime']); $data['mdate'] = formatTimestamp($data['mtime']); $xoopsTpl->assign('log', $data); $xoopsTpl->assign('categories', lt_get_categories());