PHP pastTime Examples

Example #1

File: editlog.php Project: nbuy/xoops-modules-logtick

    redirect_header('index.php', 1, _MD_LOGTICK_STORED);
    exit;
} else {
    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']);

Example #2

File: functions.php Project: nbuy/xoops-modules-logtick

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');
}