Posts by shedrock

shedrock · Programming

Please don't use smarty I hate to theme with that.

shedrock · Announcements

Well, it was that last line in fact but I was actually just busting your ba**s mate. I am just in one of my rare good moods. (:

shedrock · Announcements

Smartys, you're a really great guy, but your response to MattF is unwarranted and uncalled for. Just thought I would mention that.

shedrock · Announcements

No Connor, I am not out of line here. What I have stated is what a lot of the members are feeling towards the project at the moment. If I am out of line, then the majority of the community is as well. I am not here to blast you guys. I do know the dedication in the past, but sorry, I have not seen this in the last few months judging from the activity in the forum. You can't expect to lay low for so long and then boom! you all are back ready and committed, after the community's frustration is at its peak. It doesn't work that way.

You cannot expect people to jump when you say jump, and this is essentially what you all are doing. In other words, we'll release it whenever we want and you all have to deal with that. This is my assumption based on numerous posts in this forum, so forgive me if my opinion does not seem very supportive at the moment. This is a community, and the very meaning of the word has not been a reflection of what I've seen in recent months.

Look, I am 100% behind Flux and have been since its conception. All I am trying to say is that members are frustrated and the PR on the site does not reflect anything that makes you jump up and say "wow!, these guys are really committed". With all that being said, I still think you guys are great and I look forward to the next release.

Cheers!
Shedrock

shedrock · Announcements

I agree with all of Connor's ideas, but seriously guys. You've just got to give your community a time line. I don't think you can just keep leading people on and on in this manner. It appears to me that most of you aren't 100% committed to the project any more, except for Smartys who as far as I remembered retired a while back. So, is Smartys back 10%, 30%, 50% which is it? - I do hope he is back btw.

Anyway, I do respect the fact that this is all free and everyone has their personal lives to live, but really, you have to admit that it has gotten to a ridiculous point now. There seems to be no direction in my opinion even though you all speak of direction. I usually never get involved in these mattes but everyday I come on here and if there is nothing updated as far as updates to Flux, then there are people bickering about the future of Flux. Can't you all see that even though you may think that you are setting out a future for Flux, you're actually pushing your committed members away.

This of course is just my opinion, but I still believe you need a SET date on a release and adhere to it this time.

Shedrock

shedrock · General support (1.2)

Added it back to search.

shedrock · General support (1.2)

I did it like that intentionally. Why does it matter if the side bar is not visible. The Top navigation links are still visible...I am lost.

shedrock · General support (1.2)

La`me wrote:

why does it say fluxbb if its punbb? =/

I actually changed the links in there to reflect this site and as Gizzmo said, it is 98% alike.

shedrock · General support (1.2)

Tyler wrote:

Very very nice Shedrock. Looks extremely professional.

Thank you.

shedrock · General support (1.2)

It is punBB 1.2.20

shedrock · General support (1.2)

I had no other place to show my punBB site. Anyway, this is my new site and I am very proud to show off all of the modifications that was done with it. You will need to register to see all the features and so forth.

Here are some of the modification on it:

Last Topic on Index.
Last Topic in Viewforum.
New posts icons like VBulletin for sub forums with Mark Topics as Read when clicked.
Boxover (hover) JS.
Sub Forum layout (Single Line or List Style).
Topic Icons on Index before Topic Link.
Sub Forum View Option in Profile.
Hide/Show Left Blocks.
Accordion (mootools) Menu.
Forum/Sub Forum Category Icons.
Modified Attachment Mod displays icon when in viewforum view.
Subscribed icon visible in viewforum.
Sticky Icon visible in viewforum.
Forum Tools Menu.
Change Themes anywhere on the site.

...and a hold slew of other modifications. Far too many to mention.

Anyway, please give it a look over and give me your opinions.

http://raynedown.com

Cheers!
Shedrock

shedrock · General support (1.2)

Gizzmo wrote:

try this, set the href to # and use this onclick
onclick="insert_text('[url=http://fill in the blank]','Page Title[/url]'); return false"

Thanks Gizzmo,

This worked great.

Shedrock

shedrock · General support (1.2)

Can someone please tell me why this would not validate:

<a id="furl" class="tool_btn" title=<?php echo '"'.$lang_modern_bbcode['FURL title'].'"' ?> href="javascript:insert_text('[url=http://fill in the blank]','Page Title[/url]')"><?php echo $lang_modern_bbcode['FURL'] ?></a>

I get the following:

line 248 column 8 - Warning: <a> escaping malformed URI reference

This is what I have in my parser.php file:

    // Do the more complex BBCodes (also strip excessive whitespace and useless quotes)
    $a = array( '#\[url=("|\'|)(.*?)\\1\]\s*#i',
                '#\[url\]\s*#i',
                '#\s*\[/url\]#i',
                '#\[email=("|\'|)(.*?)\\1\]\s*#i',
                '#\[email\]\s*#i',
                '#\s*\[/email\]#i',
                '#\[img\]\s*(.*?)\s*\[/img\]#is',
                '#\[colou?r=("|\'|)(.*?)\\1\](.*?)\[/colou?r\]#is');

    $b = array(    '[url=$2]',
                '[url]',
                '[/url]',
                '[email=$2]',
                '[email]',
                '[/email]',
                '[img]$1[/img]',
                '[color=$2]$3[/color]');

Thanks
Shedrock

shedrock · General support (1.2)

Thanks, I added it.

btw: Is there a way to display just one image of the paperclip.gif and when I hover over it, it then lists all the attachments in that post. The reason I ask is if I have 5 attachments, then it breaks the layout.

Thanks
Shedrock

shedrock · General support (1.2)

I figured it out. I just added:

$attachment_extension=attach_get_extension($attachment_filename);

below:

                while( list( $attachment_id, $attachment_filename, $attachment_size, $attachment_downloads ) = $db->fetch_row( $result_attach ) )
                {

shedrock · General support (1.2)

Wow! This seems to be working great. Just one problem, it displays the unknown.png image which basically means it does not know what the archive extension is. It should display the ext. eg. zip, rar, image etc... If I can get that working it would be awesome!

I thank you so much for this. It really means a lot to me.

Shedrock

shedrock · General support (1.2)

Can someone please help me out here?

Shedrock

shedrock · General support (1.2)

Well, you basically said it all there. I am trying to to show whatever attachments are in the post. I am using a boxover script and it displays the attachment on mouseover. The problem there is that it only displays (1) file when it should display all of them. I will email you a working site so that you can see it in action.

Thanks for your help
Shedrock

shedrock · General support (1.2)

Here is my viewforum file: Maybe this may help.

<?php
/***********************************************************************

  Copyright (C) 2002-2005  Rickard Andersson (rickard@punbb.org)

  This file is part of PunBB.

  PunBB is free software; you can redistribute it and/or modify it
  under the terms of the GNU General Public License as published
  by the Free Software Foundation; either version 2 of the License,
  or (at your option) any later version.

  PunBB is distributed in the hope that it will be useful, but
  WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License for more details.

  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 59 Temple Place, Suite 330, Boston,
  MA  02111-1307  USA

************************************************************************/

define('PUN_ALT1',1); 
define('PUN_ROOT', './');
require PUN_ROOT.'include/common.php';
require PUN_ROOT.'include/parser.php';

if ($pun_user['g_read_board'] == '0')
    message($lang_common['No view']);

$id = isset($_GET['id']) ? intval($_GET['id']) : 0;
if ($id < 1)
    message($lang_common['Bad request']);

// Load the viewforum.php language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/forum.php';
require PUN_ROOT.'lang/'.$pun_user['language'].'/index.php';
// Load the viewtopic.php language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/topic.php';
// Load poll language file
require PUN_ROOT.'lang/'.$pun_user['language'].'/polls.php';
require PUN_ROOT.'include/attach/attach_incl.php'; //Attachment Mod row, loads variables, functions and lang file

// Fetch some info about the forum
$result = $db->query('SELECT f.forum_name, f.forum_note, f.head_note, f.show_note, pf.forum_name AS parent_forum, f.redirect_url, f.moderators, f.num_topics, f.sort_by, f.parent_forum_id, fp.post_topics, fp.post_polls FROM '.$db->prefix.'forums AS f LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') LEFT JOIN '.$db->prefix.'forums AS pf ON f.parent_forum_id=pf.id WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND f.id='.$id) or error('Unable to fetch forum info', __FILE__, __LINE__, $db->error());
if (!$db->num_rows($result))
    message($lang_common['Bad request']);

$cur_forum = $db->fetch_assoc($result);

// Is this a redirect forum? In that case, redirect!
if ($cur_forum['redirect_url'] != '')
{
        $item_status = 'iredirect';
        $icon_text = $lang_common['Redirect icon'];
        $icon_type = 'icon';
}

// Sort out who the moderators are and if we are currently a moderator (or an admin)
$mods_array = array();
if ($cur_forum['moderators'] != '')
    $mods_array = unserialize($cur_forum['moderators']);

$is_admmod = ($pun_user['g_id'] == PUN_ADMIN || ($pun_user['g_id'] == PUN_MOD && array_key_exists($pun_user['username'], $mods_array))) ? true : false;

// Can we or can we not post new topics?
if (($cur_forum['post_topics'] == '' && $pun_user['g_post_topics'] == '1') || $cur_forum['post_topics'] == '1' || $is_admmod)

////////////////////// Shedrock Added /////////////////////
if(file_exists('img/'.$pun_user['style'].'/forum_icons/newthread.gif')) {
$lang_forum['Post topic'] = '<img src="img/'.$pun_user['style'].'/forum_icons/newthread.gif" title="'.$lang_forum['Post topic'].'" alt="'.$lang_forum['Post topic'].'" />';

    $post_link = "\t\t".'<p class="postlink conr"><a href="post.php?fid='.$id.'">'.$lang_forum['Post topic'].'</a>'."\n";
}
else
{
    $post_link = "\t\t".'<p class="postlink conr"><a href="post.php?fid='.$id.'">'.$lang_forum['Post topic'].'</a>'."\n";
}
// Can we or can we not post new topics?
if (($cur_forum['post_topics'] == '' && $pun_user['g_post_topics'] == '1') || $cur_forum['post_topics'] == '1' || $is_admmod)

if (($cur_forum['post_polls'] == '' && $pun_user['g_post_polls'] == '1') || $cur_forum['post_polls'] == '1' || $is_admmod)

////////////////////// Shedrock Added /////////////////////
if(file_exists('img/'.$pun_user['style'].'/forum_icons/newpoll.gif')) {
$lang_polls['New poll'] = '<img src="img/'.$pun_user['style'].'/forum_icons/newpoll.gif" title="'.$lang_polls['New poll'].'" alt="'.$lang_polls['New poll'].'" />';

    $post_link .= "\t\t".'<a href="post.php?fid='.$id.'&amp;type=poll">'.$lang_polls['New poll'].'</a></p>'."\n";
}
else
{
    $post_link .= "\t\t".'<a href="post.php?fid='.$id.'&amp;type=poll">'.$lang_polls['New poll'].'</a></p>'."\n";
}

// Determine the topic offset (based on $_GET['p'])
$num_pages = ceil($cur_forum['num_topics'] / $pun_user['disp_topics']);

$p = (!isset($_GET['p']) || $_GET['p'] <= 1 || $_GET['p'] > $num_pages) ? 1 : $_GET['p'];
$start_from = $pun_user['disp_topics'] * ($p - 1);

// Generate paging links
$paging_links = $lang_common['Pages'].': '.paginate($num_pages, $p, 'viewforum.php?id='.$id);


$page_title = pun_htmlspecialchars($pun_config['o_board_title'].' / '.$cur_forum['forum_name']);
define('PUN_ALLOW_INDEX', 1);
require PUN_ROOT.'header.php';
$new_topics = get_all_new_topics();
$subforum_result = $db->query('SELECT f.forum_desc, f.forum_name, f.id, f.last_post, f.last_post_id, f.last_poster, f.moderators, f.num_posts, f.num_topics, f.redirect_url, p.poster_id AS last_poster_id FROM '.$db->prefix.'forums AS f LEFT JOIN '.$db->prefix.'posts AS p ON (p.id=f.last_post_id) WHERE parent_forum_id='.$id.' ORDER BY disp_position') or error('Unable to fetch sub forum info',__FILE__,__LINE__,$db->error());
if ($pun_user['subs_enable'] == 0)
{
if($db->num_rows($subforum_result))
{
?>
<div class="linkst">
    <div class="inbox">
        <ul><li class="vf_home_1"><span class="home"><a href="index.php"><?php echo $lang_common['Index'] ?></a></span>&nbsp;</li><li class="vf_home_2">&raquo;&nbsp;<?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?></li></ul>
        <div class="clearer"></div>
    </div>
</div>

<div id="vf1" class="blocktable misc">
    <h2 class="subs"><span>Sub forums</span></h2>
    <div class="box">
        <div class="inbox">
            <table cellspacing="0">
            <thead>
                <tr>
                    <th style="border-left: 0px;" class="tc0" scope="col">&nbsp;</th>
                    <th class="tc1" scope="col"><?php echo $lang_common['Forum'] ?>&nbsp;</th>
                    <th class="tc02" scope="col"><?php echo $lang_index['Topics'] ?>&nbsp;</th>
                    <th class="tc2" scope="col"><?php echo $lang_index['Topics'] ?>&nbsp;</th>
                    <th class="tc3" scope="col"><?php echo $lang_common['Posts'] ?>&nbsp;</th>
                    <th class="tcr" scope="col"><?php echo $lang_common['Last post'] ?>&nbsp;</th>
                </tr>
            </thead>
            <tbody>
<?php

while($cur_subforum = $db->fetch_assoc($subforum_result))
{
    $item_status = '';
    $icon_text = $lang_common['Normal icon'];
    $icon_type = 'icon';

    // Are there new posts?
    if (!$pun_user['is_guest'] && forum_is_new($cur_subforum['id'], $cur_subforum['last_post']))
    {
        $item_status = 'inew';
        $icon_text = $lang_common['New icon'];
        $icon_type = 'icon inew';
    }

    // Is this a redirect forum?
    if ($cur_forum['redirect_url'] != '')
    {
        $forum_field = '<h3><a href="'.pun_htmlspecialchars($cur_subforum['redirect_url']).'" title="'.$lang_index['Link to'].' '.pun_htmlspecialchars($cur_subforum['redirect_url']).'">'.pun_htmlspecialchars($cur_subforum['forum_name']).'</a></h3>';
        $num_topics = $num_posts = '&nbsp;';
        $item_status = 'iredirect';
        $icon_text = $lang_common['Redirect icon'];
        $icon_type = 'icon';
    }
    else
    {
        $forum_field = '<h3><a href="viewforum.php?id='.$cur_subforum['id'].'">'.pun_htmlspecialchars($cur_subforum['forum_name']).'</a></h3>';
        $num_topics = $cur_subforum['num_topics'];
        $num_posts = $cur_subforum['num_posts'];
    }

    if ($cur_subforum['forum_desc'] != '')
        $forum_field .= "\n\t\t\t\t\t\t\t\t".$cur_subforum['forum_desc'];


    // If there is a last_post/last_poster.
    if ($cur_subforum['last_post'] != '')
        //$last_post = '<a href="viewtopic.php?pid='.$cur_subforum['last_post_id'].'#p'.$cur_subforum['last_post_id'].'">'.format_time($cur_subforum['last_post']).'</a><br /> <span class="byuser">'.$lang_common['by'].' '.pun_htmlspecialchars($cur_subforum['last_poster']).'</span>';
    $last_post = '<span class="msgtitleicon"><a href="viewtopic.php?pid='.$cur_subforum['last_post_id'].'#p'.$cur_subforum['last_post_id'].'">'.format_time($cur_subforum['last_post']).'</a></span><br /> <span class="byuser">'.$lang_common['by'].' <a href="profile.php?id='.$cur_subforum['last_poster_id'].'">'.pun_htmlspecialchars($cur_subforum['last_poster']).'</a></span>';
    else
        $last_post = '&nbsp;';

    if ($cur_subforum['moderators'] != '')
    {
        $mods_array = unserialize($cur_subforum['moderators']);
        $moderators = array();

        while (list($mod_username, $mod_id) = @each($mods_array))
            $moderators[] = '<a href="profile.php?id='.$mod_id.'">'.pun_htmlspecialchars($mod_username).'</a>';

        $moderators = "\t\t\t\t\t\t\t\t".'<br /><span class="moderator">[<span class="mod_by">'.$lang_common['Moderated by'].':</span> '.implode(', ', $moderators).')</span>'."\n";
    }
?>
            <tr<?php if ($item_status != '') echo ' class="'.trim($item_status).'"'; ?>><td style="border-left: 0;" class="tc0"> <div class="<?php echo $icon_type ?>">&nbsp;</div></td>

                    <td onclick="window.location.href='viewforum.php?id=<?php echo $cur_subforum['id']; ?>'" class="tc1">
                                <?php echo $forum_field;
                                if ($cur_subforum['moderators'] != '') {
                                    echo "\n".$moderators;
                                }
                                ?>
              <td class="tc02"><?php echo $num_topics ?>&nbsp;</td>
                    <td class="tc2"><?php echo $num_topics ?>&nbsp;</td>
                    <td class="tc3"><?php echo $num_posts ?>&nbsp;</td>
                    <td class="tcr"><?php echo $last_post ?>&nbsp;</td>
                </tr>
<?php
    }
?>
            </tbody>
            </table>
        </div>
    </div>
</div>
<?php
    }
}
else

?>

<div class="linkst">
    <div class="inbox">
        <p class="pagelink conl"><?php echo $paging_links ?></p>
<?php

echo $post_link;
if($cur_forum['parent_forum'])
    echo "\t\t".'<ul><li class="vf_home_1"><span class="home"><a href="index.php">'.$lang_common['Index'].'</a></span></li><li class="vf_home_2">&raquo;&nbsp;<a href="viewforum.php?id='.$cur_forum['parent_forum_id'].'">'.pun_htmlspecialchars($cur_forum['parent_forum']).'</a>&nbsp;</li><li>&raquo;&nbsp;'.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';
else
    echo "\t\t".'<ul><li class="vf_home_1"><span class="home"><a href="index.php">'.$lang_common['Index'].'</a></span></li><li class="vf_home_2">&raquo;&nbsp;'.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';

?>        <div class="clearer"></div>
    </div>
</div>

<?php if ($cur_forum['show_note'] == 1){ ?>
<div class="blocktable no-border-viewforum">
    <h2 class="note_heading"><span><?php echo pun_htmlspecialchars($cur_forum['head_note']) ?></span></h2>
    <div class="box">
        <div class="inbox">
                                 <p style="padding-left: 8px;"> <?php echo  ($cur_forum['forum_note']) ?></p>
        </div>
    </div><br />
    <h2><span><?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?></span></h2>
<?php } else { ?>
<div id="vf" class="blocktable no-border-viewforum">
    <h2><span><?php echo pun_htmlspecialchars($cur_forum['forum_name']) ?></span></h2>
<?php } ?>
    <div class="box misc">
            <div class="inbox">    
        <table cellspacing="0">
        <thead>
            <tr>
        <th style="border-left: 0;" class="tc0" scope="col">&nbsp;</th>
        <th style="border-left: 0;" class="tc00" scope="col">&nbsp;</th>
        <th class="tc1" style="text-align: left;" scope="col"><?php echo $lang_common['Topic'] ?></th>
         <th style="cursor: pointer;" title="header=[Letter Legend:] cssheader=[box_subject] cssbody=[box_body_subject] body=[Subscribed - Attachment - Sticky] delay=[0] fade=[on]" class="tc2" scope="col" colspan="3">S&nbsp;&nbsp;&nbsp;&nbsp;A&nbsp;&nbsp;&nbsp;&nbsp;S</th>
        <th class="tc02" style="text-align: center;" scope="col"><?php echo $lang_common['Replies'] ?></th>

        <th class="tc3" scope="col"><?php echo $lang_forum['Views'] ?></th>
        <th class="tcr" scope="col"><?php echo $lang_common['Last post'] ?></th>
<?php
    if(!$pun_user['is_guest'] && $pun_config['o_show_dot'] == '1' )
{
    echo '<th class="tc01"><img src="img/'.$pun_user['style'].'/forum_icons/status.gif" title="'.$lang_forum['Posting status'].'" alt="" /></th>';
} 
else 
    if(!$pun_user['is_guest'] && $pun_config['o_show_dot'] == '0' )
{            if ($cur_topic['has_posted'] == $pun_user['id'])
    echo '<th class="tc01">x</th>';
}
?>
        </tr>
    </thead>
<tbody>
 
<?php

// Fetch list of topics to display on this page
if ($pun_user['is_guest'] || $pun_config['o_show_dot'] == '0')
{
    // Without "the dot"
    $sql = 'SELECT t.id, t.poster, t.subject, t.posted, t.last_post, p.message, p.hide_smilies, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, labels, question, icon_topic, p.poster_id AS last_poster_id, s.user_id AS is_subscribed FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'subscriptions AS s ON (t.id=s.topic_id AND s.user_id='.$pun_user['id'].') LEFT JOIN '.$db->prefix.'posts AS p ON (p.id=t.last_post_id) WHERE forum_id='.$id.' ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'];
}
else
{
    // With "the dot"
    switch ($db_type)
    {
        case 'mysql':
        case 'mysqli':
            $sql = 'SELECT p.poster_id AS has_posted, t.id, t.subject, p2.message, p2.hide_smilies, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.question, t.labels, t.icon_topic, p2.poster_id AS last_poster_id, s.user_id AS is_subscribed FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'subscriptions AS s ON (t.id=s.topic_id AND s.user_id='.$pun_user['id'].') LEFT JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id AND p.poster_id='.$pun_user['id'].' LEFT JOIN '.$db->prefix.'posts AS p2 ON (p2.id=t.last_post_id) WHERE t.forum_id='.$id.' GROUP BY t.id ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'];
            break;

        case 'sqlite':
            $sql = 'SELECT p.poster_id AS has_posted, t.id, t.subject, p2.message, p2.hide_smilies, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.question, t.labels, t.icon_topic FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id AND p.poster_id='.$pun_user['id'].' WHERE t.id IN(SELECT id FROM '.$db->prefix.'topics WHERE forum_id='.$id.' ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'].') GROUP BY t.id ORDER BY t.sticky DESC, t.last_post DESC';
            break;

        default:
            $sql = 'SELECT p.poster_id AS has_posted, t.id, t.subject, p2.message, p2.hide_smilies, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.question, t.labels, t.icon_topic FROM '.$db->prefix.'topics AS t LEFT JOIN '.$db->prefix.'posts AS p ON t.id=p.topic_id AND p.poster_id='.$pun_user['id'].' WHERE t.forum_id='.$id.' GROUP BY t.id, t.subject, t.poster, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, p.poster_id ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT '.$start_from.', '.$pun_user['disp_topics'];
            break;

    }
}

$result = $db->query($sql) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

// If there are topics in this forum.
if ($db->num_rows($result))
{
        $alt = true;
    while ($cur_topic = $db->fetch_assoc($result))
    {
        $alt = !$alt;
        $icon_text = $lang_common['Normal icon'];
        $item_status = '';
        $icon_type = 'icon';

        if ($cur_topic['moved_to'] == null)
            $last_post = '<span class="msgtitleicon"><a href="viewtopic.php?pid='.$cur_topic['last_post_id'].'#p'.$cur_topic['last_post_id'].'">'.format_time($cur_topic['last_post']).'</a></span><br /><span class="byuser">'.$lang_common['by'].'&nbsp;<a href="profile.php?id='.$cur_topic['last_poster_id'].'">'.pun_htmlspecialchars($cur_topic['last_poster']).'</a></span>';
        else
            $last_post = '&nbsp;';

        if ($pun_config['o_censoring'] == '1')
            $cur_topic['subject'] = censor_words($cur_topic['subject']);

// For truncated subject lines
        $subject = pun_htmlspecialchars($cur_topic['subject']);
//

// For truncated messages
        $cur_topic['message'] = pun_htmlspecialchars(parse_message($cur_topic['message'], $cur_topic['hide_smilies'], $cur_topic['allow_html']));
//



// Attachment Mod Block Start
    $attach_output = '';
    $attach_num = 0;
// Check if this post has any attachments
    $result_attach = $db->query('SELECT af.id, af.filename, af.size, af.downloads FROM '.$db->prefix.'attach_2_files AS af WHERE af.post_id='.$cur_topic['id']) or error('Unable to fetch if there were any attachments to the post', __FILE__, __LINE__, $db->error());
    $attach_num = $db->num_rows($result_attach);
    if($attach_num > 0)
{
    while(list($attachment_id, $attachment_filename, $attachment_size, $attachment_downloads)=$db->fetch_row($result_attach)){
    $attachment_extension=attach_get_extension($attachment_filename);
    $attach_output .= '<span title="header=[Filename: '.$attachment_filename.'] cssheader=[box_attach_header] cssbody=[box_body_attach] body=['.pun_htmlspecialchars(attach_icon($attachment_extension)).''.$attachment_filename.'<br />'.$lang_attach['Size:'].'&nbsp;'.number_format($attachment_size).'&nbsp;'.$lang_attach['bytes'].'<br />'.$lang_attach['Downloads:'].'&nbsp;<b>'.number_format($attachment_downloads).'</b>] delay=[0] fade=[on]"><img src="img/paperclip.gif" alt="" /></span>';
    }
}
// Attachment Mod Block End



// For subscription on subject lines
      if (!$pun_user['is_guest'] && $pun_config['o_subscriptions'] == '1')
{
      if ($cur_topic['is_subscribed'] != null) // 
        // I apologize for the variable naming here. It's a mix of subscription and action I guess :-)
        $subscraction = '<img src="img/'.$pun_user['style'].'/forum_icons/subscribed.gif" title="header=['.(strlen($subject) > 45 ? substr($subject, 0 , 55).'...' : $subject).'] cssheader=[box_subject] cssbody=[box_body_subject] body=[<b>'.$pun_user['username'].'</b>, '.$lang_topic['Is subscribed'].'] delay=[0] fade=[on]" alt="'.$lang_topic['Is subscribed'].'" />'."\n";
else
        $subscraction = '&nbsp;'."\n";
}
else
      $subscraction = '<div class="clearer"></div>'."\n";
//
        
        if ($cur_topic['moved_to'] != 0) {
            $item_status .= 'imoved';
            $icon_type = 'icon imoved';
            $subject = $lang_forum['Moved'].': <a title="header=['.pun_htmlspecialchars($cur_forum['forum_name']).'] cssheader=[box_subject] cssbody=[box_body_subject] body=['.(strlen($subject) > 75 ? substr($subject, 0 , 70).'...' : $subject).'] delay=[0] fade=[on]" href="viewtopic.php?id='.$cur_topic['moved_to'].'">'.(strlen($subject) > 45 ? substr($subject, 0 , 35).'...' : $subject).'</a>';
        }

else if ($cur_topic['question'] != '')
                     $subject = '<img style="vertical-align: middle; width: 14px; height: 14px;" src="img/'.$pun_user['style'].'/forum_icons/poll.gif" title="'.$lang_polls['Vote poll'].'" alt="'.$lang_polls['Vote poll'].'" /> <a title="header=['.pun_htmlspecialchars($cur_forum['forum_name']).'] cssheader=[box_subject] cssbody=[box_body_subject] body=['.(strlen($subject) > 75 ? substr($subject, 0 , 70).'' : $subject).'] delay=[0] fade=[on]" href="viewtopic.php?id='.$cur_topic['id'].'">'.(strlen($subject) > 45 ? substr($subject, 0 , 35).'...' : $subject).'</a><br /><span style="font-weight: normal;">Poll:&nbsp;</span><span class="poll_font">'.pun_htmlspecialchars($cur_topic['question']).'</span><br /><span class="poster_name">'.$lang_topic['Started by'].':</span>&nbsp;<span class="username"><a href="profile.php?id='.$cur_topic['last_poster_id'].'">'.pun_htmlspecialchars($cur_topic['poster']).'</a></span>';

else 

        if ($cur_topic['closed'] == '0')
        if ($pun_user['is_guest'])

            $subject = '<a title="header=['.pun_htmlspecialchars($cur_forum['forum_name']).'] cssheader=[box_subject] cssbody=[box_body_subject] body=['.(strlen($subject) > 75 ? substr($subject, 0 , 70).'' : $subject).'] delay=[0] fade=[on]" href="viewtopic.php?id='.$cur_topic['id'].'">'.(strlen($subject) > 45 ? substr($subject, 0 , 35).'...' : $subject).'</a><br /><span class="poster_name">'.$lang_topic['Started by'].':</span>&nbsp;<span class="username"><a href="profile.php?id='.$cur_topic['last_poster_id'].'">'.pun_htmlspecialchars($cur_topic['poster']).'</a></span>';
else
            $subject = '<a title="header=['.pun_htmlspecialchars($cur_forum['forum_name']).'] cssheader=[box_subject] cssbody=[box_body_subject] body=['.(strlen($subject) > 75 ? substr($subject, 0 , 70).'' : $subject).'] delay=[0] fade=[on]" href="viewtopic.php?id='.$cur_topic['id'].'">'.(strlen($subject) > 45 ? substr($subject, 0 , 35).'...' : $subject).'</a><span title="header=[<img style=\'vertical-align: middle;\' src=\'img/'.$pun_user['style'].'/forum_icons/info.gif\' />&nbsp;&nbsp;'.(strlen($subject) > 45 ? substr($subject, 0 , 55).'...' : $subject).'] cssheader=[box_header] cssbody=[box_body] body=['.(strlen($cur_topic['message']) > 500 ? substr($cur_topic['message'], 0 , 375).'<font style=\'color: red;\'>&nbsp;...cont\'d</font>' : $cur_topic['message']).'] delay=[0] fadespeed=[0.04] fade=[on]">&nbsp;<a href="viewtopic.php?pid='.$cur_topic['last_post_id'].'#p'.$cur_topic['last_post_id'].'"><img style="vertical-align: middle;" src="img/'.$pun_user['style'].'/forum_icons/preview.gif" alt="" /></a>&nbsp;</span><br /><span class="poster_name">'.$lang_topic['Started by'].':</span>&nbsp;<span class="username"><a href="profile.php?id='.$cur_topic['last_poster_id'].'">'.pun_htmlspecialchars($cur_topic['poster']).'</a></span>';
else 
        if ($pun_user['is_guest'])
        {
            $subject = '<a title="header=['.pun_htmlspecialchars($cur_forum['forum_name']).'] cssheader=[box_subject] cssbody=[box_body_subject] body=['.(strlen($subject) > 75 ? substr($subject, 0 , 70).'' : $subject).'] delay=[0] fade=[on]" href="viewtopic.php?id='.$cur_topic['id'].'">'.(strlen($subject) > 45 ? substr($subject, 0 , 35).'...' : $subject).'</a><br /><span class="poster_name">'.$lang_topic['Started by'].':</span>&nbsp;<span class="username"><a href="profile.php?id='.$cur_topic['last_poster_id'].'">'.pun_htmlspecialchars($cur_topic['poster']).'</a></span>';
            $icon_text = $lang_common['Closed icon'];
            $item_status = 'iclosed';
        }

else
        {
            $subject = '<a title="header=['.pun_htmlspecialchars($cur_forum['forum_name']).'] cssheader=[box_subject] cssbody=[box_body_subject] body=['.(strlen($subject) > 75 ? substr($subject, 0 , 70).'' : $subject).'] delay=[0] fade=[on]" href="viewtopic.php?id='.$cur_topic['id'].'">'.(strlen($subject) > 45 ? substr($subject, 0 , 35).'...' : $subject).'</a><span title="header=[<img style=\'vertical-align: middle;\' src=\'img/'.$pun_user['style'].'/forum_icons/info.gif\' />&nbsp;&nbsp;'.(strlen($subject) > 45 ? substr($subject, 0 , 55).'...' : $subject).'] cssheader=[box_header] cssbody=[box_body] body=['.(strlen($cur_topic['message']) > 500 ? substr($cur_topic['message'], 0 , 375).'<font style=\'color: red;\'>&nbsp;...cont\'d</font>' : $cur_topic['message']).'] delay=[0] fadespeed=[0.04] fade=[on]">&nbsp;<a href="viewtopic.php?pid='.$cur_topic['last_post_id'].'#p'.$cur_topic['last_post_id'].'"><img style="vertical-align: middle;" src="img/'.$pun_user['style'].'/forum_icons/preview.gif" alt="" /></a>&nbsp;</span><br /><span class="poster_name">'.$lang_topic['Started by'].':</span>&nbsp;<span class="username"><a href="profile.php?id='.$cur_topic['last_poster_id'].'">'.pun_htmlspecialchars($cur_topic['poster']).'</a></span>';
            $icon_text = $lang_common['Closed icon'];
            $item_status = 'iclosed';
        }

                        // gleek edit
                        if ($cur_topic['num_replies'] >= $pun_config['o_hot_count'])
                        {
                                $item_status .= ' ihot';
                                $icon_type = 'icon ihot';
                        }

                // MOD: MARK TOPICS AS READ - 1 LINE MODIFIED CODE FOLLOWS
        if (!$pun_user['is_guest'] && topic_is_new($cur_topic['id'], $id,  $cur_topic['last_post']) && $cur_topic['moved_to'] == null)
        {
            $icon_text .= ' '.$lang_common['New icon'];
            $item_status .= ' inew';
            $icon_type = 'icon inew';
                                // gleek edit
                                if ($cur_topic['num_replies'] >= $pun_config['o_hot_count'])
                                {
                                        $item_status .= ' nhot';
                                        $icon_type = 'icon nhot';
                                }
            $subject = '<strong>'.$subject.'</strong>';
            $subject_new_posts = '<span class="newtext"><a href="viewtopic.php?id='.$cur_topic['id'].'&amp;action=new" title="'.$lang_common['New posts info'].'">'.$lang_common['New posts'].'</a></span>';
        }
        else
            $subject_new_posts = null;

        if ($cur_topic['sticky'] == '1')
        {
            $subject = '<span class="stickytext">'.$lang_forum['Sticky'].': </span>'.$subject;
            $item_status .= ' isticky';
            $icon_text .= ' '.$lang_forum['Sticky'];
        }

        $num_pages_topic = ceil(($cur_topic['num_replies'] + 1) / $pun_user['disp_posts']);

        if ($num_pages_topic > 1)
            $subject_multipage = '<br /><div class="multipages"><span class="list_pages" title="'.$lang_forum['Multi Page'].'">'.paginate($num_pages_topic, -1, 'viewtopic.php?id='.$cur_topic['id']).'</span></div>';
        else
            $subject_multipage = null;

        // Should we show the "New posts" and/or the multipage links?
        if (!empty($subject_new_posts) || !empty($subject_multipage))
        {
            // - original line of code $subject .= '&nbsp; '.(!empty($subject_new_posts) ? $subject_new_posts : '');
            $subject .= ''.(!empty($subject_new_posts) ? $subject_new_posts : '');
            $subject .= !empty($subject_multipage) ? ' '.$subject_multipage : '';
        }

        $labels = (!empty($pun_config['o_topic_labels']))? $cur_topic['labels']: '';
        if ($alt)
    {
            $item_status .= ' alt';
    }
?>
            <tr<?php if ($item_status != '') echo ' class="'.trim($item_status).'"'; ?>><td style="border-left: 0;" class="tc0"><div class="<?php echo $icon_type ?>">&nbsp;</div></td>
            <td class="tc00">&nbsp;<?php if ($cur_topic['icon_topic'] != 0) 
    {
        $icon_topic = '<img style="vertical-align: middle;" src="./img/icons/'.$cur_topic['icon_topic'].'.gif" title="'.$lang_forum['Post icon'].'" alt="" />';
        echo $icon_topic;
    }
?>
</td>
<?php
      if ($cur_topic['moved_to'] != 0) 
    {
?><td onclick="window.location.href='viewtopic.php?id=<?php echo $cur_topic['moved_to']; ?>'" class="tc1"><?php echo $subject."\n" ?>
<?php
    }
else
    {
?><td onclick="window.location.href='viewtopic.php?id=<?php echo $cur_topic['id']; ?>'" class="tc1"><?php echo $subject."\n" ?>
<?php
    }
?>
                    <?php if (!empty($labels)) echo '<div class="topiclabels">'.$lang_common['Labels'].': ['.show_labels($labels).']</div>'; ?></td>
                    <td class="tc02">
<?php 
      if (!$pun_user['is_guest'] && $pun_config['o_subscriptions'] == '1')
{
      if ($cur_topic['is_subscribed'] != null) // 

    echo $subscraction; 
else
    echo "&nbsp;";
}


?>

</td>

<td class="tc03">
<?php 
    if ($pun_user['is_guest'])
{
    echo "&nbsp;";
}
else
    echo $attach_output ?>
</td>

<?php 
// For truncated subject lines
        $subject = pun_htmlspecialchars($cur_topic['subject']);
if ($cur_topic['sticky'] == '1')
{
    echo '<td class="tc04"><span title="header=['.(strlen($subject) > 75 ? substr($subject, 0 , 70).'' : $subject).'] cssheader=[box_subject] cssbody=[box_body_subject] body=[This thread has been maked as <b>Sticky</b>] delay=[0] fade=[on]">&nbsp;</span></td>';
    }
else
{
    echo '<td class="tc04">&nbsp;</td>';
}
?>

                    <td class="tc2"><?php echo ($cur_topic['moved_to'] == null) ? $cur_topic['num_replies'] : '&nbsp;' ?></td>
                    <td class="tc3"><?php echo ($cur_topic['moved_to'] == null) ? $cur_topic['num_views'] : '&nbsp;' ?></td>
                    <td class="tcr"><?php echo $last_post ?></td>
<?php
// For truncated subject lines
        $subject = pun_htmlspecialchars($cur_topic['subject']);
//
        // Should we display the dot or not? :)
if (!$pun_user['is_guest'] && $pun_config['o_show_dot'] == '1')
{
            if ($cur_topic['has_posted'] == $pun_user['id'])

                echo '<td class="tc01"><a href="search.php?action=show_user&amp;user_id='.$pun_user['id'].'"><img src="img/'.$pun_user['style'].'/forum_icons/dot.gif" title="header=['.(strlen($subject) > 25 ? substr($subject, 0 , 30).'...' : $subject).'] cssheader=[box_posted] cssbody=[box_body_posted] body=[<b>'.$pun_user['username'].'</b>,&nbsp;'.$lang_forum['Yes Post'].'] delay=[0] fade=[on]" alt="" /></a></td>'."\n";
            else if ($cur_topic['moved_to'] != 0)
            echo '<td>&nbsp;</td>';
else
                echo '<td class="tc01"><img src="img/'.$pun_user['style'].'/forum_icons/nodot.gif" title="header=['.(strlen($subject) > 25 ? substr($subject, 0 , 30).'...' : $subject).'] cssheader=[box_posted] cssbody=[box_body_posted_never] body=['.$lang_forum['No Post'].' <b>'.$pun_user['username'].'</b>] delay=[0] fade=[on]" alt="" /></td>';
}

?>
        </tr>
<?php

    }
}
else
{

?>
        <tr>
<?php
    if(!$pun_user['is_guest'] && $pun_config['o_show_dot'] == '1' )
{            
    if ($cur_topic['has_posted'] == $pun_user['id'])
?><td class="tcl" colspan="8"><?php echo $lang_forum['Empty forum'] ?></td>
<?php
    }
else
{
?><td class="tcl" colspan="7"><?php echo $lang_forum['Empty forum'] ?></td>
<?php
    }
?>
        </tr>
<?php
}
?>
            </tbody>
            </table>
        </div>
    </div>
</div>

<div class="linksb">
    <div class="inbox">
        <p class="pagelink conl"><?php echo $paging_links ?></p>
<?php
echo $post_link;
if($cur_forum['parent_forum'])
    echo "\t\t".'<ul><li class="vf_home_1"><span class="home"><a href="index.php">'.$lang_common['Index'].'</a></span></li><li class="vf_home_2">&raquo;&nbsp;<a href="viewforum.php?id='.$cur_forum['parent_forum_id'].'">'.pun_htmlspecialchars($cur_forum['parent_forum']).'</a>&nbsp;</li><li>&raquo;&nbsp;'.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';
else
    echo "\t\t".'<ul><li class="vf_home_1"><span class="home"><a href="index.php">'.$lang_common['Index'].'</a></span></li><li class="vf_home_2">&raquo;&nbsp;'.pun_htmlspecialchars($cur_forum['forum_name']).'</li></ul>';

?>        <div class="clearer"></div>
    </div>
</div>        
<?php

$forum_id = $id;
$footer_style = 'viewforum';
require PUN_ROOT.'footer.php';

shedrock · General support (1.2)

Well, it does work. the problem as I've stated in a previous post is that I can't get the db query line to work. All the rest of it works. I just can't get the code to work for the allowed part. What I've done is set the rules so that everyone can see the icon as well as the actual file in viewtopic, because it would make no sense seeing an icon in viewforum and no file attachment in viewtopic. As for overkill, well, if you saw it you would see exactly what I was referring to.

I know there must be a way for this to work, because all that is in viewtopic.php is more or less in viewforum.php. My viewforum is heavily modified, it is just that query driving me insane. Someone must be able to assist me with this.

Thanks for your help btw.

Shedrock

shedrock · General support (1.2)

The reason it is in viewforum is because when you are viewing it, I made a separate column that displays an attachment icon like VBulletin does.

shedrock · General support (1.2)

I am using a piece of code that normally resides in viewtopic.php but I am trying to get it to work in viewforum.php. - It works to a certain degree, but it appears to have a problem with the "allow" query of the code.

    // Attachment Mod Block Start
    $attach_allow_download = false;
    $attach_output = '';
    $attach_num = 0;
    // Check if this post has any attachments
    $result_attach = $db->query('SELECT af.id, af.filename, af.size, af.downloads FROM '.$db->prefix.'attach_2_files AS af WHERE af.post_id='.$cur_topic['id']) or error('Unable to fetch if there were any attachments to the post', __FILE__, __LINE__, $db->error());
    $attach_num = $db->num_rows($result_attach);
    if($attach_num > 0){
        if($pun_user['g_id']==PUN_ADMIN)$attach_allow_download=true;
        else{         //fetch the rules of the forum, and check so that the user is allowed to download.
            $result_attach_two = $db->query('SELECT ar.rules FROM '.$db->prefix.'attach_2_rules AS ar WHERE ar.group_id=\''.$pun_user['group_id'].'\' AND ar.forum_id='.$cur_topic['forum_id'].' LIMIT 1')or error('Unable to fetch rules for the attachments', __FILE__, __LINE__, $db->error());
            if($db->num_rows($result_attach_two)==1){
                list($attach_rules)=$db->fetch_row($result_attach_two);
                $attach_allow_download = attach_rules($attach_rules,ATTACH_DOWNLOAD);
            }
        }
        if($attach_allow_download){//check if the user is allowed to download it.
            while(list($attachment_id, $attachment_filename, $attachment_size, $attachment_downloads)=$db->fetch_row($result_attach)){
                $attachment_extension=attach_get_extension($attachment_filename);
                $attach_output .= '<span title="header=[Filename: '.$attachment_filename.'] cssheader=[box_attach_header] cssbody=[box_body_attach] body=['.pun_htmlspecialchars(attach_icon($attachment_extension)).''.$attachment_filename.'<br />'.$lang_attach['Size:'].'&nbsp;'.number_format($attachment_size).'&nbsp;'.$lang_attach['bytes'].'<br />'.$lang_attach['Downloads:'].'&nbsp;<b>'.number_format($attachment_downloads).'</b>] delay=[0] fade=[on]"><img src="img/paperclip.gif" alt="" /></span>';
            }
        }
    }
    // Attachment Mod Block End

but this query causes the error below:

            $result_attach_two = $db->query('SELECT ar.rules FROM '.$db->prefix.'attach_2_rules AS ar WHERE ar.group_id=\''.$pun_user['group_id'].'\' AND ar.forum_id='.$cur_topic['forum_id'].' LIMIT 1')or error('Unable to fetch rules for the attachments', __FILE__, __LINE__, $db->error());

File: c:\fluxbb\viewforum.php
Line: 351
FluxBB reported: Unable to fetch rules for the attachments
Database reported: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1 (Errno: 1064)

Thanks for any help.
Shedrock

shedrock · General support (1.2)

Anyone willing to help me with this?

shedrock · General support (1.2)

ok, I will try that..thank you FSX

shedrock · General support (1.2)

I do not know how to do that Smartys. Can you please tell me how?

Forums

#1 Re: Programming » Why FluxBB is so fast ? » 2009-01-18 23:25:06

#2 Re: Announcements » The future of FluxBB » 2009-01-18 03:18:13

#3 Re: Announcements » The future of FluxBB » 2009-01-18 00:32:39

#4 Re: Announcements » The future of FluxBB » 2009-01-14 13:20:53

#5 Re: Announcements » The future of FluxBB » 2009-01-14 11:58:16

#6 Re: General support (1.2) » Had to post my new site in here » 2008-11-12 23:49:05

#7 Re: General support (1.2) » Had to post my new site in here » 2008-11-12 23:31:14

#8 Re: General support (1.2) » Had to post my new site in here » 2008-11-12 01:29:25

#9 Re: General support (1.2) » Had to post my new site in here » 2008-11-12 01:10:10

#10 Re: General support (1.2) » Had to post my new site in here » 2008-11-12 01:09:30

#11 General support (1.2) » Had to post my new site in here » 2008-11-12 00:20:31

#12 Re: General support (1.2) » Can't validate the following bbcode » 2008-11-10 10:45:12

#13 General support (1.2) » Can't validate the following bbcode » 2008-11-10 01:19:22

#14 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-06 14:05:06

#15 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-06 01:34:57

#16 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-06 01:26:30

#17 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-04 23:16:59

#18 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-03 23:26:06

#19 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-03 20:38:30

#20 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-03 20:27:23

#21 Re: General support (1.2) » DB Query error with attachment mod » 2008-11-03 20:02:15

#22 General support (1.2) » DB Query error with attachment mod » 2008-11-02 19:06:08

#23 Re: General support (1.2) » Displaying a specific number of lines » 2008-11-02 17:47:31

#24 Re: General support (1.2) » Would like someone to optiomize this query » 2008-11-01 22:24:30

#25 Re: General support (1.2) » Would like someone to optiomize this query » 2008-11-01 21:31:57

Board footer