Search options (Page 44 of 49)

define('FORUM_DEBUG', 1);

 if ($cur_set['sticky'] == '1')
{
    $item_subject_status['sticky'] = $lang_forum['Sticky'];
    $item_status['sticky'] = 'sticky';
 }
    
if ($cur_set['closed'] != '0')
{
    $item_subject_status['closed'] = $lang_forum['Closed'];
    $item_status['closed'] = 'closed';
}

<?php
    $topics_count = 20;
    $query_active_topics= array(
        'SELECT'    => 't.id AS tid, t.poster, t.subject, t.posted AS has_posted, t.last_post, t.last_post_id, t.num_replies, t.num_views, t.closed, t.sticky, t.forum_id',
        'FROM'        => 'topics AS t',
        'JOINS'        => array(
            array(
                'INNER JOIN'    => 'forums AS f',
                'ON'            => 'f.id=t.forum_id'
            ),
            array(
                'LEFT JOIN'     => 'forum_perms AS fp',
                'ON'            => '(fp.forum_id=f.id AND fp.group_id='.$forum_user['g_id'].')'
            )
        ),
        'ORDER BY'    => 't.last_post',
        'LIMIT' => $topics_count
    );
    $result_active = $forum_db->query_build($query_active_topics) or error(__FILE__, __LINE__);
    
    if ($forum_db->num_rows($result_active) == 0)
    {

    ?>
        <div class="main-content main-message">
            <p>There is no message.</p>
        </div>
    <?php
        
    } 
    else
    {
        require_once FORUM_ROOT.'lang/'.$forum_user['language'].'/forum.php';

    ?>    
        <div class="main-subhead">
                <p class="item-summary">
                    <span>
                        <strong class="subject-title"><?php echo $lang_index['Topics']; ?></strong>
                        <strong class="info-replies"><?php echo $lang_forum['Replies']; ?></strong>
                        <strong class="info-views"><?php echo $lang_forum['Views']; ?></strong>
                    </span>
                </p>                                                
            </div>
        <div class="main-content main-forum">                    
        <?php

            $item_num = 1;
            while ($cur_set = $forum_db->fetch_assoc($result_active))
            {
               // Start from scratch
                $item_subject = $item_body = $item_status = $item_nav = $item_title = array();
                $item_indicator = ''; 
                
                if (!$forum_user['is_guest'] && $forum_config['o_show_dot'] == '1' && $cur_set['has_posted'] > 0)
                {
                    $item_title['posted'] = '<span class="posted-mark">'.$lang_forum['You posted indicator'].'</span>';
                    $item_status['posted'] = 'posted';
                }

                $item_title['link'] = '<a href="'.forum_link($forum_url['post'], $cur_set['last_post_id']).'">'.forum_htmlencode($cur_set['subject']).'</a>';

                if (!empty($item_nav))
                    $item_title['nav'] = '<span class="item-nav">'.sprintf($lang_forum['Topic navigation'], implode('&#160;&#160;', $item_nav)).'</span>';

                $item_body['subject']['title'] = '<h3 class="hn"><span class="item-num">'.forum_number_format(++$item_num).'</span> '.implode(' ', $item_title).'</h3>';
                if ($cur_set['sticky'] == '1')
                {
                    $item_subject_status['sticky'] = $lang_forum['Sticky'];
                    $item_status['sticky'] = 'sticky';
                }
    
                if ($cur_set['closed'] != '0')
                {
                    $item_subject_status['closed'] = $lang_forum['Closed'];
                    $item_status['closed'] = 'closed';
                }
    
                if (!empty($item_subject_status))
                    $item_subject['status'] = '<span class="item-status">'.sprintf($lang_forum['Item status'], implode(' ', $item_subject_status)).'</span>';
    
                $item_subject['starter'] = '<span class="item-starter">'.sprintf($lang_forum['Topic starter'], '<cite>'.forum_htmlencode($cur_set['poster']).'</cite>').'</span>';
    
                $item_body['subject']['desc'] = implode(' ', $item_subject);
                if (empty($item_status))
                    $item_status['normal'] = 'normal';

                $item_style = (($item_num % 2 != 0) ? ' odd' : ' even').(($item_num == 1) ? ' main-first-item' : '').((!empty($item_status)) ? ' '.implode(' ', $item_status) : '');

                $item_body['info']['replies'] = '<li class="info-replies"><strong>'.forum_number_format($cur_set['num_replies']).'</strong> <span class="label">'.(($cur_set['num_replies'] == 1) ? $lang_forum['Reply'] : $lang_forum['Replies']).'</span></li>';
                $item_body['info']['views'] = '<li class="info-replies"><strong>'.forum_number_format($cur_set['num_views']).'</strong> <span class="label">'.(($cur_set['num_views'] == 1) ? $lang_forum['View'] : $lang_forum['Views']).'</span></li>';

                ?>
                    <div class="main-item<?php echo $item_style ?>">
                        <span class="icon <?php echo implode(' ', $item_status) ?>"><!-- --></span>
                        <div class="item-subject">
                            <?php echo implode("\n\t\t\t\t", $item_body['subject'])."\n" ?>
                        </div>
                        <ul class="item-info">
                            <?php echo implode("\n\t\t\t\t", $item_body['info'])."\n" ?>
                        </ul>
                  </div>
        <?php

           }

        ?>
        </div>
    <?php
    
    }

?>

$db = mysql_connect("server", "user", "password")or die("error message!");
mysql_select_db("dbname",$db)or die("error message 2!");

echo 'Logged in as: <b>'.pun_htmlspecialchars($pun_user['username']).'</b>';

$db->end_transaction();
$db->close();