Search options

ok, :-)

After studying this section of code for awhile i have figured out how you made them link to the form topic. :-)

I understand to add the fields in the string:

$result = $db->query('SELECT t.id, t.subject,  FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON t.forum_id=f.id WHERE t.moved_to IS NULL AND '.$forum_sql.'f.admmod_only=0 ORDER BY '.$order_by.' DESC LIMIT '.$show)

I would add this as such:

$result = $db->query('SELECT t.id, t.subject, <b>((Somthing)))</b> FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON t.forum_id=f.id WHERE t.moved_to IS NULL AND '.$forum_sql.'f.admmod_only=0 ORDER BY '.$order_by.' DESC LIMIT '.$show)

From the looks of this, it looks like that there had been a joining of tables.

ok the only real problem I have is the echo thing.

In the script I do not see any echo for the ' t.id, t.subject ' ?

Im very sorry for all the questions guys, I am tring to learn PHP so i want have to ask so many :-)

Could someone please use this script and put an example in it how to add a different field? Then i can build on that information .

// Fetch $show topics
        $result = $db->query('SELECT t.id, t.subject,  FROM '.$db->prefix.'topics AS t INNER JOIN '.$db->prefix.'forums AS f ON t.forum_id=f.id WHERE t.moved_to IS NULL AND '.$forum_sql.'f.admmod_only=0 ORDER BY '.$order_by.' DESC LIMIT '.$show) or error('Unable to fetch topic list', __FILE__, __LINE__, $db->error());

        while ($cur_topic = $db->fetch_assoc($result))
        {
            if ($pun_config['o_censoring'] == '1')
                $cur_topic['subject'] = censor_words($cur_topic['subject']);

            if (pun_strlen($cur_topic['subject']) > $max_subject_length)
                $subject_truncated = trim(substr($cur_topic['subject'], 0, ($max_subject_length-5))).' ...';
            else
                $subject_truncated = $cur_topic['subject'];

            echo '<b>·</b> <a href="'.$pun_config['o_base_url'].'/viewtopic.php?id='.$cur_topic['id'].'&action=new" title="'.pun_htmlspecialchars($cur_topic['subject']).'">'.pun_htmlspecialchars($subject_truncated).'</a><br>'."\n";
        }
    }

    exit;

Thanks so much
Daryl

Hi rscheats,

In order to intall the forum you will need to have some knowledge of php, and mysql.

The first thing i would do is ask your web hosting company if they had mysql even running on your account.

If you do, then what I would suggest is to read about php and mysql on some webpages or by a book on the topic, that should get you going.

I would recomend PHP and MYSQL for dynamic websites. I used this book. I didnt know anyting about either topic, and after reading only half the book, I am able to ready some PHP and was able to create my tabe in mysql that punbb needs to run.

You can always try and find a forum script  that uses a file to write to instead of a database.

Hope this Helps.
Daryl