Ejemplo n.º 1
0
$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;
Ejemplo n.º 2
0
    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());