Exemple #1
0
    $q = str_replace('{WHERE}', $where, str_replace('{SELECT}', $s, $q2));
} elseif ($such == 'aeit') {
    $where = "`c`.`time` >= " . $x . " AND `c`.`erstid` = " . $uid;
    $gAnz = @db_result(db_query(str_replace('{WHERE}', $where, str_replace('{SELECT}', ' COUNT(DISTINCT `a`.`id`)', $q))), 0);
    $q = str_replace('{WHERE}', $where, str_replace('{SELECT}', $s, $q));
}
$MPL = db_make_sites($page, "", $limit, 'index.php?forum-' . $such . ($such == 'aeit' ? '-' . $uid : ''), "", $gAnz);
$tpl = new tpl('forum/search');
$q = db_query($q . " LIMIT " . $anfang . "," . $limit);
$class = '';
$tpl->set_out('gAnz', $gAnz, 0);
while ($r = db_fetch_assoc($q)) {
    $class = $class == 'Cmite' ? 'Cnorm' : 'Cmite';
    $r['class'] = $class;
    $r['ctime'] = db_result(db_query("SELECT MAX(`time`) FROM `prefix_posts` WHERE `tid` = " . $r['id']), 0, 0);
    $r['ord'] = forum_get_ordner($r['ctime'], $r['id'], $r['fid']);
    $r['link'] = 'forum-showposts-' . $r['id'];
    if ($menu->get(1) == 'aeit') {
        $r['author'] = '';
    } elseif ($such == 'aubt') {
        $r['author'] = ' ' . $lang['from'] . ' ' . $r['author'];
    } else {
        $r['author'] = ' ' . $lang['newpost'] . ' ' . $lang['from'] . ' ' . $r['author'];
        $r['postsbefore'] = db_count_query('SELECT COUNT(`id`) FROM `prefix_posts` WHERE `tid` = ' . $r['id'] . ' AND `id` < ' . $r['firstnew']);
        $r['page'] = ceil(($r['postsbefore'] + 1) / $allgAr['Fpanz']);
        $r['link'] .= '-p' . $r['page'] . '#' . $r['firstnew'];
    }
    $tpl->set_ar_out($r, 1);
}
$tpl->set_out('MPL', $MPL, 2);
if ($such == 'aeit') {
Exemple #2
0
 */
defined('main') or die('no direct access');
$title = $allgAr['title'] . ' :: Forum :: ' . aktForumCats($aktForumRow['kat'], 'title');
$hmenu = $extented_forum_menu . '<a class="smalfont" href="index.php?forum">Forum</a><b> &raquo; </b>' . aktForumCats($aktForumRow['kat']) . $extented_forum_menu_sufix;
$design = new design($title, $hmenu, 1);
$design->header();
$tpl = new tpl('forum/show_cat');
$tpl->out(0);
$cid = escape($menu->get(2), 'integer');
$q = "SELECT\r\n  `a`.`id`, `a`.`cid`, `a`.`name`, `a`.`besch`,\r\n  `a`.`topics`, `a`.`posts`, `b`.`name` as `topic`,\r\n  `c`.`id` as `pid`, `c`.`tid`, `b`.`rep`, `c`.`erst`, `c`.`time`,\r\n  `a`.`cid`, `k`.`name` as `cname`\r\nFROM `prefix_forums` `a`\r\n  LEFT JOIN `prefix_forumcats` `k` ON `k`.`id` = `a`.`cid`\r\n  LEFT JOIN `prefix_posts` `c` ON `a`.`last_post_id` = `c`.`id`\r\n  LEFT JOIN `prefix_topics` `b` ON `c`.`tid` = `b`.`id`\r\n\r\n  LEFT JOIN `prefix_groupusers` `vg` ON `vg`.`uid` = " . $_SESSION['authid'] . " AND `vg`.`gid` = `a`.`view`\r\n  LEFT JOIN `prefix_groupusers` `rg` ON `rg`.`uid` = " . $_SESSION['authid'] . " AND `rg`.`gid` = `a`.`reply`\r\n  LEFT JOIN `prefix_groupusers` `sg` ON `sg`.`uid` = " . $_SESSION['authid'] . " AND `sg`.`gid` = `a`.`start`\r\n\r\nWHERE ((" . $_SESSION['authright'] . " <= `a`.`view` AND `a`.`view` < 1)\r\n   OR (" . $_SESSION['authright'] . " <= `a`.`reply` AND `a`.`reply` < 1)\r\n   OR (" . $_SESSION['authright'] . " <= `a`.`start` AND `a`.`start` < 1)\r\n\t OR `vg`.`fid` IS NOT NULL\r\n\t OR `rg`.`fid` IS NOT NULL\r\n\t OR `sg`.`fid` IS NOT NULL\r\n\t OR -9 >= " . $_SESSION['authright'] . ")\r\n  AND `k`.`id`     = " . $cid . "\r\nORDER BY `k`.`pos`, `a`.`pos`";
$erg1 = db_query($q);
$xcid = 0;
while ($r = db_fetch_assoc($erg1)) {
    $r['topicl'] = $r['topic'];
    $r['topic'] = html_enc_substr($r['topic'], 0, 23);
    $r['ORD'] = forum_get_ordner($r['time'], $r['id']);
    $r['mods'] = getmods($r['id']);
    $r['datum'] = post_date($r['time']);
    $r['page'] = ceil(($r['rep'] + 1) / $allgAr['Fpanz']);
    $tpl->set_ar($r);
    if ($r['cid'] != $xcid) {
        $tpl->out(1);
        // Unterkategorien
        $sql = db_query("SELECT DISTINCT `a`.`name` as `cname`, `a`.`id` as `cid` FROM `prefix_forumcats` `a` LEFT JOIN `prefix_forums` `b` ON `a`.`id` = `b`.`cid` WHERE `a`.`cid` = {$r['cid']} AND `a`.`id` = `b`.`cid` ORDER BY `a`.`pos`, `a`.`name`");
        while ($ucat = db_fetch_assoc($sql)) {
            $tpl->set_ar_out($ucat, 2);
        }
        // Unterkategorien - Ende
        $xcid = $r['cid'];
    }
    $tpl->out(3);
if ($forum_rights['start'] == TRUE) {
    $tpl->set('NEWTOPIC', '<b>[ <a href="index.php?forum-newtopic-' . $fid . '">' . $lang['newtopic'] . '</a> ]</b>');
} else {
    $tpl->set('NEWTOPIC', '');
}
$tpl->set('MPL', $MPL);
$tpl->set_out('FID', $fid, 0);
$q = "SELECT a.id, a.name, a.rep, a.erst, a.hit, a.art, a.stat, b.time, b.erst as last, b.id as pid\r\n\tFROM prefix_topics a\r\n\tLEFT JOIN prefix_posts b ON a.last_post_id = b.id\r\n\tWHERE a.fid = {$fid}\r\n\tORDER BY a.art DESC, b.time DESC\r\n\tLIMIT " . $anfang . "," . $limit;
$erg = db_query($q);
if (db_num_rows($erg) > 0) {
    while ($row = db_fetch_assoc($erg)) {
        if ($row['stat'] == 0) {
            $row['ORD'] = 'cord';
        } else {
            #$row['ORD'] = get_ordner($row['time']);
            $row['ORD'] = forum_get_ordner($row['time'], $row['id'], $fid);
        }
        $row['date'] = date('d.m.y - H:i', $row['time']);
        $row['page'] = ceil(($row['rep'] + 1) / $allgAr['Fpanz']);
        $row['VORT'] = $row['art'] == 1 ? 'Fest: ' : '';
        $tpl->set_ar_out($row, 1);
    }
} else {
    echo '<tr><td colspan="6" class="Cnorm"><b>keine Eintr&auml;ge vorhanden</b></td></tr>';
}
$tpl->out(2);
if ($forum_rights['mods'] == TRUE) {
    $tpl->set('id', $fid);
    $tpl->out(3);
}
$design->footer();
Exemple #4
0
/**
 * Checkt, ob ein Post neu ist
 *
 * @param  $ftime Die letzte Updatezeit des Topics
 * @param  $id Die Id des Topics
 * @param  $postid die Id des Posts
 */
function post_is_new($ftime, $topicId, $forumId)
{
    // wir rufen ganz frech forum_get_ordner auf und überprüfen den rückgabewert
    $result = forum_get_ordner($ftime, $topicId, $forumId) == 'nord' ? true : false;
    return $result;
}