$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()); $xoopsTpl->assign('timespans', $spans); include XOOPS_ROOT_PATH . '/footer.php';
function show_list($uid, $catid = "", $after = 0, $style = LT_STYLE_OWNER) { global $xoopsDB, $xoopsConfig, $xoopsModule, $xoopsModuleConfig, $xoopsUser; require_once XOOPS_ROOT_PATH . '/class/template.php'; require_once XOOPS_ROOT_PATH . '/class/pagenav.php'; $myts =& MyTextSanitizer::getInstance(); $tpl = new XoopsTpl(); $title = _MD_LOGTICK_TITLE; if (preg_match('/^\\d+(,\\d+)+$/', $uid)) { // show multiple user log $cond = "luid IN ({$uid})"; $disp = true; } elseif ($uid) { // show a user log $cond = "luid={$uid}"; $title = sprintf(_MD_LOGTICK_USER, xoops_getLinkedUnameFromId($uid)); $disp = false; } else { // show any user log $cond = '1'; $disp = true; } $now = time(); $timestamp = _MD_SHOW_TIMESTAMP . " " . formatTimestamp($now, "m") . "<!-- now: <{$now}> -->"; $tpl->assign(array('now' => $now, 'timestamp' => $timestamp, 'anonymous' => $xoopsConfig['anonymous'], 'showuser' => $disp, 'title' => $title)); if (preg_match('/^\\d+(,\\d+)+$/', $catid)) { // show multiple categories $cond .= " AND pcat IN ({$catid})"; } elseif ($catid) { // show a category $cond .= " AND pcat={$catid}"; } $users = $xoopsDB->prefix('users'); $res = $xoopsDB->query("SELECT count(*) FROM " . TLOG . " WHERE {$cond}"); list($count) = $xoopsDB->fetchRow($res); $start = isset($_GET['start']) ? intval($_GET['start']) : 0; $max = $xoopsModuleConfig['maxlist']; $args = array(); if ($uid) { $args[] = "uid={$uid}"; } if ($catid) { $args[] = "catid={$catid}"; } $nav = new XoopsPageNav($count, $max, $start, "start", join("&", $args)); $euid = is_object($xoopsUser) ? $xoopsUser->getVar('uid') : 0; $upnew = $xoopsModuleConfig['newentry']; if ($euid) { $cond = "({$cond}) OR (luid={$euid} AND ({$now}-ltime)<={$upnew})"; } $tpl->assign(array('pagenav' => $nav->renderNav(), 'count' => $count, 'maxpage' => intval(($count + $max - 1) / $max), 'current' => intval($start / $max) + 1)); $res = $xoopsDB->query("SELECT l.*, cname, uname, user_avatar FROM " . TLOG . " l LEFT JOIN " . TCAT . " ON pcat=catid LEFT JOIN {$users} ON luid=uid WHERE {$cond} ORDER BY mtime DESC", $max, $start); $logs = array(); if ($xoopsDB->getRowsNum($res)) { $ptime = new pastTime(); while ($data = $xoopsDB->fetchArray($res)) { if ($after) { // check newer if ($after > $data['ltime']) { return $timestamp; } $after = 0; } $data['span'] = $ptime->getSpan($data['lspan']); if ($now - $data['ltime'] < $upnew) { $data['class'] = ' new'; } $data['mdate'] = $ptime->getDate($data['mtime']); $data['comment'] = $myts->displayTarea($data['comment']); if ($style == LT_STYLE_OWNER && $data['luid'] == $euid) { $data['comment'] .= " [<a href='editlog.php?logid=" . $data['logid'] . "'>" . _EDIT . "</a>]"; } $data['cname'] = htmlspecialchars($data['cname']); $logs[] = $data; } } $tpl->assign('logs', $logs); return $tpl->fetch('db:logtick_result.html'); }