You are not logged in.

#1 2005-02-08 20:01:06

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Purge unanswered posts / quick reply

Hi,

If you click 'view unanswered posts' then you get around 26 pages of posts. With the exception of the obvious annoucement-type boards, those unanswered posts don't really serve any purpose. They are simply taking up space on the server, but more importantly they add potential noise to search results - which means it can be more difficult to find relevants posts to solve old problems, etc.

So, does anyone else think that a cull of unanswered posts which are say, older than 90 days?

Offline

#2 2005-02-08 22:25:03

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: Purge unanswered posts / quick reply

I use the "view new posts" link instead. then, after I sift through those, I go back to the main page, and click "mark all posts read".
rinse..repeat


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#3 2005-02-08 22:42:31

phrakture
Arch Overlord
From: behind you
Registered: 2003-10-29
Posts: 7,879
Website

Re: Purge unanswered posts / quick reply

cactus wrote:

I use the "view new posts" link instead. then, after I sift through those, I go back to the main page, and click "mark all posts read".
rinse..repeat

same here

Offline

#4 2005-02-09 11:50:11

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Purge unanswered posts / quick reply

But that's not my point.  What I was trying to propose was some sort of "garbage collection" within the forums.

For example, a random pick gives a post from Nov 2003:

Hello Everyone ..

We've set up a server .. it's pretty basic right now .. we have ssh and apache running basicly .. and they're fine .. but when we connect to the box it keeps dropping the connection. If we surf to the page it comes up one min then the next it doesn't then the next it's up again??

Any ideas??

... but obviously, there is no answer. So what is the point of archiving this post? It's old - so that problem is likely not to exist any more. But's let us say that someone has a problem with a dropped connection and searches for "connection dropping", this post would probably be returned but to what use for the searcher? It's just cluttering up the boards, no?

So I reckon that it should be possible to run a sql query on the DB that removes unanswered posts that are 'old', by whatever definition you'd like to give, say 6 months. It could help reduce the amount of storage being used, and it could ease the servers' workload a tad by not having to process such posts during searches.

Maybe I'm obsessive compulsive about keeping things tidy - but that's my only conern: making it easier for users to find relevant information within the forums.

Offline

#5 2005-02-09 12:16:06

cactus
Taco Eater
From: t͈̫̹ͨa͖͕͎̱͈ͨ͆ć̥̖̝o̫̫̼s͈̭̱̞͍̃!̰
Registered: 2004-05-25
Posts: 4,622
Website

Re: Purge unanswered posts / quick reply

maybe posts that are older than 6 mo, with no replies, and are not labeled as sticky or announcement.


"Be conservative in what you send; be liberal in what you accept." -- Postel's Law
"tacos" -- Cactus' Law
"t̥͍͎̪̪͗a̴̻̩͈͚ͨc̠o̩̙͈ͫͅs͙͎̙͊ ͔͇̫̜t͎̳̀a̜̞̗ͩc̗͍͚o̲̯̿s̖̣̤̙͌ ̖̜̈ț̰̫͓ạ̪͖̳c̲͎͕̰̯̃̈o͉ͅs̪ͪ ̜̻̖̜͕" -- -̖͚̫̙̓-̺̠͇ͤ̃ ̜̪̜ͯZ͔̗̭̞ͪA̝͈̙͖̩L͉̠̺͓G̙̞̦͖O̳̗͍

Offline

#6 2005-02-09 13:16:42

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Purge unanswered posts / quick reply

Seems fair to me.

The New and Requested packages may also need special consideration too, since may posts are often annouments of new pacakges in TURs, etc, and thus don't often warrant a reply.

Offline

#7 2005-02-09 16:17:44

Dusty
Schwag Merchant
From: Medicine Hat, Alberta, Canada
Registered: 2004-01-18
Posts: 5,986
Website

Re: Purge unanswered posts / quick reply

I think its a good idea, lets see what rasat says first though. He always has the neatest insights....

Offline

#8 2005-02-11 07:08:18

skoal
Member
From: Frequent Flyer Underworld
Registered: 2004-03-23
Posts: 612
Website

Re: Purge unanswered posts / quick reply

Personally, I don't think it's necessary.  Most of the major forums I hit have a feature to hanldle this.

Basically, posts before a certain date are just hidden, not deleted.  You have to explicitly extend your search parameters with a date form.  If phpBB supports it, I think that would be a lot easier for the Moderators than going back and deleting countless posts.

Just set a timestamp of about 2 months (or whatever) for currently visible threads.  You would have to select from an additional "date" (or archive) form in your search if you wanted to extend your results, or better yet, decrease them.

Offline

#9 2005-02-11 10:40:45

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

I have few times been tempted to click the unanswered purge buttom at admin panel but there are many singel posts as announcement, system info, and other useful configure information. The purge has to be done manually. Once I am back in Singapore (18th) I will take a closer look at this issue.


Markku

Offline

#10 2005-02-11 12:15:34

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Purge unanswered posts / quick reply

Ah I see. So I guess you are slightly limited to the functionality of phpbb. I've never maintained phpbb, so I have no idea what it is capible of from an admin perspective.

However, surely it uses a db backend, such as mysql, and so it would be very simple to bypass the phpbb interface and just interact with the DB itself. The SQL queries wouldn't be too difficult. Alternatively, it would be feasible to extend the phpbb to allow more fine-grained purges.

Offline

#11 2005-02-11 15:46:28

Dusty
Schwag Merchant
From: Medicine Hat, Alberta, Canada
Registered: 2004-01-18
Posts: 5,986
Website

Re: Purge unanswered posts / quick reply

Rasat is a forum admin, I don't think he has direct access to the MySQL db... that's not to say that he couldn't obtain it, of course.

Dusty

Offline

#12 2005-02-21 04:12:27

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

Through a hard lesson I learned that phpBB doesen't have the option to purge unanswered posts.
http://bbs.archlinux.org/viewtopic.php?t=10153


Markku

Offline

#13 2005-02-21 04:22:45

sarah31
Member
From: Middle of Canada
Registered: 2002-08-20
Posts: 2,975
Website

Re: Purge unanswered posts / quick reply

well they managed to purge alot of my posts on the Libranet forum.


AKA uknowme

I am not your friend

Offline

#14 2005-02-21 09:49:52

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Purge unanswered posts / quick reply

Maybe this functionality comes via a mod of somekind. There seem to be thousands of them.

Offline

#15 2005-02-21 12:41:52

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

I have searched in Internet for a module but so far didn't find. Maybe we could develop our own?


Markku

Offline

#16 2005-02-21 13:02:58

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Purge unanswered posts / quick reply

I'll look into it.

Offline

#17 2005-02-21 20:01:23

arooaroo
Member
From: London, UK
Registered: 2005-01-13
Posts: 1,268
Website

Re: Purge unanswered posts / quick reply

Ok, just spent the afternoon installing apache, php, mysql and phpbb, and then trying to learn how to mod phpbb.

I'm hoping to create a mod which will give a new page in the admin panel that'll give more fine grained control of the pruning process. Admittedly, it may take me a little while, as getting info about to mod phpbb has been surprisingly hard. Plus, it's been a long time since I did any php programming.

Hopefully I'll get something going soon. I'll be able to test on my own system of course.

Do you think this would be useful, Rasat?

Offline

#18 2005-02-22 04:58:45

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

arooaroo wrote:

Do you think this would be useful, Rasat?

Yes, I do. When number of posts increases (currently we have about 150 posts per day and increasing every month) some posts with difficult question or "too newbie" for some users liking will be easily unanswered. I would like our active forum users to find these posts.

Currently "view unanswered posts" cannot be used when showing 26 pages of posts. To clean manually, what I am trying to do, is too much work. After six months there will be again pages of posts.

The module needs three options: select forum, remove post with 0 reply, and   specify number of days. Same as the pruning function but for unanswered posts:
http://www.doreo.com/tutorials/phpbb/pruning-forums.php

Cactus also have an interest in developing this module and familar with php/mysql. I suugest we discuss this developmet on user-contribution.org. I will setup a forum for this project.
http://user-contributions.org/forums/userproject/

EDIT:
PhpBB modules for Arch Forum
To improve phpBB forum management, post your ideas here.
http://user-contributions.org/forums/us … m.php?f=18


Markku

Offline

#19 2005-02-22 17:21:45

i3839
Member
Registered: 2004-02-04
Posts: 1,185

Re: Purge unanswered posts / quick reply

rasat wrote:

Currently "view unanswered posts" cannot be used when showing 26 pages of posts. To clean manually, what I am trying to do, is too much work. After six months there will be again pages of posts.

I don't understand why "view unanswered posts" cannot be used. It returns all unanswered posts, ordened by date. No pruning is needed because it's very easy to ignore too old posts. There may be other reasons to want to prune unanswered posts, but this doesn't seem to be one of them.

Offline

#20 2005-02-22 17:52:23

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

i3839 wrote:

I don't understand why "view unanswered posts" cannot be used.

In "view unanswered posts" all posts are important, not just the current. Currently who wants to browse 26 pages of posts (1,300). Myself two years ago took a look at the posts and that was enough though only few pages.
http://bbs.archlinux.org/search.php?sea … unanswered (23 pages.. cleaning is going on).

Another thing, many of the posts don't need a reply but has an important message e.g. in forum: "New and Requested Packages" and "User Contributions". We are thinking about adding a forum selection box for those interested to search unanswered posts in a particular forum.
The point is, number of posts are increasing daily and its easier to browse when using the options:

- View posts since last visit
- View your posts
- View unanswered posts

We can also add more options.


Markku

Offline

#21 2005-02-23 02:49:52

sarah31
Member
From: Middle of Canada
Registered: 2002-08-20
Posts: 2,975
Website

Re: Purge unanswered posts / quick reply

In your flurry of activity in trying to mod the forum could you please consider some of the other requested mod that DO exist ... such as quick reply. Just look through this forum and you will see a few of the requests have ben made a couple of times.


AKA uknowme

I am not your friend

Offline

#22 2005-02-23 06:01:05

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

sarah31 wrote:

... such as quick reply.

I will check at it.
http://user-contributions.org/forums/us … c.php?t=87


Markku

Offline

#23 2005-02-23 06:06:43

sarah31
Member
From: Middle of Canada
Registered: 2002-08-20
Posts: 2,975
Website

Re: Purge unanswered posts / quick reply

Markku,

I there is an existing mod for quick reply and I think quick search. They and other can be found through the phpBB site.


AKA uknowme

I am not your friend

Offline

#24 2005-02-23 07:09:40

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

I am aware and not planning to develop from scratch. I am starting with this:
http://www.phpbbhacks.com/viewhack.php?id=540


Markku

Offline

#25 2005-02-23 10:51:25

rasat
Forum Fellow
From: Finland, working in Romania
Registered: 2002-12-27
Posts: 2,293
Website

Re: Purge unanswered posts / quick reply

You can test here using quick reply (no need to register, give any user name):
http://user-contributions.org/forums/us … c.php?t=87


Markku

Offline

Board footer

Powered by FluxBB