876

(9 replies, posted in PunBB 1.3 discussion)

If you use more than one table in FROM or JOINS, you should add a prefix manually to the tables, and add this parameter to the query builder:

'PARAMS' => array('NO_PREFIX' => true),
VincentBroccoli wrote:

- And the line

<a href="'. FORUM_ROOT .'viewtopic.php?id='.$cur_post['id'].'" title="View Replies" >'.$cur_post['num_replies'].' Comments</a>

links to the post id not to the topic id. How can I fix that?

Modify 'SELECT' key in array:

    'SELECT'    =>    'p.id, p.message, t.subject, t.poster, t.num_replies, t.posted, p.poster_id, t.num_replies, t.id AS tid',

And link will look like this:

<a href="'. FORUM_ROOT .'viewtopic.php?id='.$cur_post['tid'].'" title="View Replies" >'.$cur_post['num_replies'].' Comments</a>

Code

'ORDER BY'    => 't.posted DESC',
'LIMIT'            => '0,10' 

work fine for me to limit the numbers of topics.

Go to <FORUM_ROOT>/inlcude/search_functions.php go to line 643 and replace this code

'ORDER BY'    => 't.last_post DESC'

with this

'ORDER BY'  => 't.last_post DESC',
'LIMIT'     => '50'

Right now we have only one article in wiki, related with DB query.
John_S, this query will return the first post of every forum topic with forum_id = 10:

 $query = array(
    'SELECT'    =>    'p.id, p.message, t.subject, t.poster, t.num_replies, t.posted, p.poster_id, t.num_replies',
    'FROM'        =>    'posts AS p',
    'JOINS'        => array(
        array(
            'LEFT JOIN'    =>    'topics AS t',
            'ON'        =>    'p.topic_id = t.id'
        )
    ),
    'WHERE'        => 'p.id = t.first_post_id AND t.forum_id = 10',
    'ORDER BY'    => 't.posted DESC'
);    
MattF wrote:

Plus, it isn't necessary to load all of the quickquote/multiquote information for guests. The page size is being bloated unnecessarily for no reason whatsoever.

Agree with you. It will be implemented in the next version of pun_quote.
What method do you suggest to determine whether client's JavaScript is enabled at server?

881

(1 replies, posted in PunBB 1.3 troubleshooting)

sdpunbb wrote:

How do I ban all the IPs of the spam user names?

If you want to ban several ips, enter the ip-addresses separated by space in the Ban creation form. Other fields of the form can be left empty.

sdpunbb wrote:

Also, will banning the ips cause the posts to be deleted? Or do I have to delete the posts manually?

Banning a user does not affect that user's posts, you have to delete those posts manually.

882

(19 replies, posted in PunBB 1.3 extensions)

I hope, pun_karma will be adapted for the last PunBB version. But I can't say anything about the time of its release. Nevertheless, what features would you like to be added in the new version of the extension?

PunBB 1.3 allows to split selected posts into new posts (Use "Moderate topic" link to do that). The feature that would allow to you move posts can be implemented as an extension. Add an extension request, please.

884

(3 replies, posted in PunBB 1.3 troubleshooting)

Have you any other rewrite rules at your site, besides the forum rules?

Could you add an extension request, please?

In most cases, headers are sent in "header.php". Replace it or add an if-statement, if your want to send special headers only for some pages.

887

(19 replies, posted in News)

Cereal wrote:

will you guys allow otehr people into the dev team? none informer people?

Yes, of course. We are interested in involving new developers in the project.

888

(19 replies, posted in News)

Unfortunately, Anatoly has left our company. He has contributed greatly in the development of PunBB.
I will be managing the PunBB project henceforth. You can send me PM or e-mail.
We will continue developing PunBB as usual. Our goal remains the same: to make the fastest and lightweight forum. Our priorities are support and improvement of the current version of PunBB 1.3, by developing official extensions.
Our nearest plan is to release PunBB 1.3.3, this version will contain all bug fixes since PunBB 1.3.2 has been released.

889

(2 replies, posted in PunBB 1.3 troubleshooting)

As MattF wrote, you can edit the width of the field via the stylesheet or go to the line 344 of <FORUM_ROOT>/extensions/pun_tags/manifest.xml and change value of the attribute "size".

890

(2 replies, posted in PunBB 1.3 extensions)

PunBB 1.3 has an extension system. It helps to add functionalily to a forum easily with usage of hooks. This article should help you. To add a new link to a profile you can use "pf_change_details_modify_main_menu" hook.

BED wrote:

I can make confusion making these modifications to database (table users)?

What changes do you want to make in the DB?

What extension have you got installed?

892

(41 replies, posted in PunBB 1.3 extensions)

Thank you for the explanations, this check will be implemented in the next version of the extension.

893

(1 replies, posted in PunBB 1.3 troubleshooting)

SiCo wrote:

I want my style to be the only one, I know I could delete Oxygen then mine would be the only one, is this the only way?

'If there is only one style in the style directory, the section with styles will not show up in profile.

SiCo wrote:

Otherwise I make a plugin to disable the choice for users, and to automatically set each user to use the selected style by admin. - I believe this should be included in the future because not everyone likes to provide style selection.

I think it is easy to remove unnessary styles and update users table with an SQL-query, which will set the correct style.

It could be a nice extension. I think it should be a link "tell a friend" for a topic and forum.

895

(5 replies, posted in PunBB 1.3 extensions)

AdsBB wrote:

Could this be added to the hook navigator?

Yes, it could, I think

896

(1 replies, posted in PunBB 1.3 extensions)

You can post bug here, I think

897

(5 replies, posted in PunBB 1.3 extensions)

We are planning to develop 2 extensions for developers: Hook Navigator and Extension Editor. They will contain the feature implemented by you. You can add some other features to the wiki page.

898

(4 replies, posted in PunBB 1.3 troubleshooting)

It seems that css-styles don't load for your site. Have you tried to clear the cache of your browser?

899

(17 replies, posted in PunBB 1.3 troubleshooting)

SiCo wrote:

To fix this do I suggest it as a feature / bug or just make my own extension to do it?

I don't think that it is a bug, but if you want you can create an extension to validate this information. I think, real members of forum are interested in stating the real and correct contact information about themselves in their profiles. Fake users will enter something useless in these fields, and you will notice this.

SiCo wrote:

Looking at even more of these settings there are tons that aren't remotely checked. For example you can set the users time zone to 999.

Yes, this defect persists. We will fix it.

900

(9 replies, posted in PunBB 1.3 troubleshooting)

Have you tried enabling the debug mode?