Single post topic forum

MattF · 2007-05-19 15:14

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Topic: Single post topic forum

Firstly, apologies if I've put this in the wrong forum. Couldn't quite decide where it should go.

What areas would one need to concentrate on to create a forum where it is possible for any user to create a topic/thread, but once created, that topic/thread can only be edited by the user who created it, and they are only able to edit the original post, not add further posts to the topic/thread? It will in essence be a single post topic that can only be updated/edited by it's creator.

Simple idea for this one is something akin to an incorporated write-up/wiki section using the forums abilities, rather than utilising an external programme. Have been looking at wiki's and such over the last several weeks, and they all have problems or lack required elements, or are simply devilishly hard to use. The forum itself is a familiar interface for the users, however, and has all the pre-requisites, so I've decided to go down the route of modifying the forum itself rather than trying to tie in an external programme to achieve the required purpose.

Cheers,

Matt

hcgtv · 2007-05-19 15:31

hcgtv
Senior Member
Offline

From: Charlotte, NC
Registered: 2004-06-25
Posts: 1,991

Re: Single post topic forum

Hi Matt,

DokuWiki is very easy to install and is in the same spirit of Pun, very light.

It also has backend authenticattion for Wiki users against the Forum database:
http://wiki.splitbrain.org/wiki:auth:punbb?s=punbb

I use Doku cause there are times when it's better to use a hammer than the handle of a screwdriver.

PHPCrossRef . TXP Make . TXP Themes . TXP Tags . TXP Planet . We Love TXP

Smartys · 2007-05-19 15:31

Smartys
Former PunBB Developer
Offline

Registered: 2004-04-30
Posts: 7,844

Re: Single post topic forum

Unless I'm wrong, that's easily possible
Create a forum, edit its permissions in admin_forums.php. Make sure that people can only post topics, not replies. Then make sure people can edit their own posts. Tada!

MattF · 2007-05-19 16:28

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

hcgtv wrote:

Hi Matt,
DokuWiki is very easy to install and is in the same spirit of Pun, very light.
It also has backend authenticattion for Wiki users against the Forum database:
http://wiki.splitbrain.org/wiki:auth:punbb?s=punbb
I use Doku cause there are times when it's better to use a hammer than the handle of a screwdriver.

That was the one which looked most promising, but had various problems. Firstly, the PunBB authentication is for mysql only, and secondly, I couldn't get to grips with it's use within the first hour. I work on the motto that if I cannot figure it out within the hour, the less technical ones have no chance. Ease of use is the primary concern, and the forum usage is now second nature to them.

MattF · 2007-05-19 16:30

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

Smartys wrote:

Unless I'm wrong, that's easily possible
Create a forum, edit its permissions in admin_forums.php. Make sure that people can only post topics, not replies. Then make sure people can edit their own posts. Tada!

Ooh, if that's the case, I'll be well chuffed. I'm gonna' have a diddle now. Thanks ever so much for that pointer.

MattF · 2007-05-19 17:39

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

Right. Almost there. That works a treat. Only two deviations I need are that I want to differ the delete and edit settings from the global ones for forums that are post topic only, so that delete is disabled but edits are allowed indefinitely. So, would I need to adjust viewforum.php and viewtopic.php for this? Would it suffice to, if post_replies = 0, to set the following two within the script as below to allow the above?

g_delete_posts = 0
g_edit_subjects_interval = 0

Thanks again,

Matt

Edit: Just been delving, and it appears that it's viewtopic.php and edit.php tht will need some slight alteration?

MattF · 2007-05-19 19:10

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

Sorted that little quibble. Like a muppet, I didn't twig that the edit time only refers to the subject, so that one is an irrelevant point. The delete bit can be sorted by changing, in viewtopic.php around line 320:

$post_actions[] = '<li class="postdelete"><a href="delete.php?id='.$cur_post['id'].'">'.$lang_topic['Delete'].'</a>';

To:

if ($cur_topic['post_replies'] == '') {
        $post_actions[] = '<li class="postdelete"><a href="delete.php?id='.$cur_post['id'].'">'.$lang_topic['Delete'].'</a>';
}

Deletion will then be disabled for single topic forums. Cheers for the advice and help.

Matt

Smartys · 2007-05-19 19:25

Smartys
Former PunBB Developer
Offline

Registered: 2004-04-30
Posts: 7,844

Re: Single post topic forum

Well, it won't be disabled, the link is just hidden. You would need to make a similar edit in delete.php

MattF · 2007-05-19 21:06

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

Smartys wrote:

Well, it won't be disabled, the link is just hidden. You would need to make a similar edit in delete.php

Is that $cur_topic['post_replies'] variable/element already available in delete.php, or will it need to be introduced?

Smartys · 2007-05-19 21:40

Smartys
Former PunBB Developer
Offline

Registered: 2004-04-30
Posts: 7,844

Re: Single post topic forum

You need to edit the initial query for $cur_post to grab the post_replies column

MattF · 2007-05-19 22:40

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

Smartys wrote:

You need to edit the initial query for $cur_post to grab the post_replies column

Just been having a look at the delete.php db query, and it looks as if the post_replies is already in the lookup? This line:

$result = $db->query('SELECT f.id AS fid, f.forum_name, f.moderators, f.redirect_url, fp.post_replies, fp.post_topics, t.id AS tid, t.subject, t.posted, t.closed, p.poster, p.poster_id, p.message, p.hide_smilies FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.id='.$id) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());

Is that the right one, the fp.post_replies? If so, would I just use $cur_post['post_replies'] instead of the $cur_topic['post_replies'] var?

Thanks once again.

Matt

MattF · 2007-05-20 00:25

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

Sorted that last bit. The query is already there, so starting at line 58:

if (($pun_user['g_delete_posts'] == '0' ||
        ($pun_user['g_delete_topics'] == '0' && $is_topic_post) ||
        $cur_post['poster_id'] != $pun_user['id'] ||
        $cur_post['closed'] == '1') &&
        !$is_admmod)
        message($lang_common['No permission']);

That block above needs the following line adding: $cur_post['post_replies'] != '' ||

so that it looks like the following:

if (($pun_user['g_delete_posts'] == '0' ||
        ($pun_user['g_delete_topics'] == '0' && $is_topic_post) ||
        $cur_post['poster_id'] != $pun_user['id'] ||
        $cur_post['post_replies'] != '' ||
        $cur_post['closed'] == '1') &&
        !$is_admmod)
        message($lang_common['No permission']);

Thanks again for the advice.

Matt

Smartys · 2007-05-20 00:27

Smartys
Former PunBB Developer
Offline

Registered: 2004-04-30
Posts: 7,844

Re: Single post topic forum

MattF wrote:

Smartys wrote:
You need to edit the initial query for $cur_post to grab the post_replies column
Just been having a look at the delete.php db query, and it looks as if the post_replies is already in the lookup? This line:
$result = $db->query('SELECT f.id AS fid, f.forum_name, f.moderators, f.redirect_url, fp.post_replies, fp.post_topics, t.id AS tid, t.subject, t.posted, t.closed, p.poster, p.poster_id, p.message, p.hide_smilies FROM '.$db->prefix.'posts AS p INNER JOIN '.$db->prefix.'topics AS t ON t.id=p.topic_id INNER JOIN '.$db->prefix.'forums AS f ON f.id=t.forum_id LEFT JOIN '.$db->prefix.'forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id='.$pun_user['g_id'].') WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND p.id='.$id) or error('Unable to fetch post info', __FILE__, __LINE__, $db->error());
Is that the right one, the fp.post_replies? If so, would I just use $cur_post['post_replies'] instead of the $cur_topic['post_replies'] var?

Thanks once again.
Matt

You're right, I could have sworn that it wasn't in the query though

MattF · 2007-05-20 00:34

MattF
Senior Member
Offline

From: South Yorkshire, England
Registered: 2007-03-15
Posts: 1,956

Re: Single post topic forum

Smartys wrote:

You're right, I could have sworn that it wasn't in the query though

With the length of that query it's devilishly easy to miss. I needed a judicious dose of grep and reading it several times to find it. Thanks ever so much for all your help and advice, btw.

Matt

Single post topic forum

Posts: 14

1 Topic by MattF 2007-05-19 15:14 (edited by MattF 2007-05-19 15:15)

Topic: Single post topic forum

2 Reply by hcgtv 2007-05-19 15:31

Re: Single post topic forum

3 Reply by Smartys 2007-05-19 15:31

Re: Single post topic forum

4 Reply by MattF 2007-05-19 16:28 (edited by MattF 2007-05-19 16:31)

Re: Single post topic forum

5 Reply by MattF 2007-05-19 16:30

Re: Single post topic forum

6 Reply by MattF 2007-05-19 17:39 (edited by MattF 2007-05-19 18:00)

Re: Single post topic forum

7 Reply by MattF 2007-05-19 19:10 (edited by MattF 2007-05-19 19:11)

Re: Single post topic forum

8 Reply by Smartys 2007-05-19 19:25

Re: Single post topic forum

9 Reply by MattF 2007-05-19 21:06

Re: Single post topic forum

10 Reply by Smartys 2007-05-19 21:40

Re: Single post topic forum

11 Reply by MattF 2007-05-19 22:40

Re: Single post topic forum

12 Reply by MattF 2007-05-20 00:25

Re: Single post topic forum

13 Reply by Smartys 2007-05-20 00:27

Re: Single post topic forum

14 Reply by MattF 2007-05-20 00:34

Re: Single post topic forum

Posts: 14