Topic cement

Post by **Extensions Robot** » Tue Nov 18, 2008 8:38 am

Modification name: Topic cement
Author: Elglobo
Modification description: This MOD allows the members authorized (permission local/global 'm_set_priority') to give a priority on certain topics.
By default priority is zero; all topics with a priority of zero are sorted as they always have been: first by type, then by date of last post.
This mod inserts a new sort: first by type, then by priority (descending), and then by date of last post.
Modification version: 1.0.1
Tested on phpBB version: 3.0.5

Download file: Topic_cement_v1.0.1.zip
File size: 59.06 KiB

Modification overview page: View

The phpBB Team is not responsible nor required to provide support for this modification. By installing this MOD, you acknowledge that the phpBB Support Team or phpBB Extension Customisations Team may not be able to provide support.

-->Modification support<--

Post by **Paul** » Tue Nov 18, 2008 8:38 am

Modification validated/released

Notes:

Elglobo · Post by **Elglobo** » Tue Nov 18, 2008 8:38 am

There is a Bug in v1.0.0 with the last page in a forum where priorities was used.
Open viewforum.php and search:

Code: Select all

    ORDER BY t.topic_type " . ((!$store_reverse) ? 'DESC' : 'ASC') . ', t.topic_priority DESC, ' . $sql_sort_order;

Replace by:

Code: Select all

	ORDER BY t.topic_type " . ((!$store_reverse) ? 'DESC' : 'ASC') . ', t.topic_priority ' . ((!$store_reverse) ? 'DESC' : 'ASC') . ', ' . $sql_sort_order;

manic2 · Post by **manic2** » Tue Nov 18, 2008 5:03 pm

This is a brilliant mod

.

This has been requested several times & will be of great benefit to those that want to give their topics a specific order within a forum, e.g:-

Date order for upcoming or past events,
Chapter order for 'on screen books',
Section number order for legislation,
...... and many more uses.

I have been using it for a few weeks now since downloading it from phpBBhacks.com. I have a glitch which it is not obvious why it is occurring.

I have tried ordering a forum for past events that have occurred over the past year, by setting priorities based on dates, e.g:-

108 for an event on 8 January,
319 for an event on 19 March,
1124 for an event on 24 November.

A problem that I found is that once I got onto the third page of ordered events / threads (i.e. over 100) then I started to lose sight of some in viewforum.

There doesn't seem to be any obvious reason for this & I can still see them in the mod control panel.

Any ideas?

manic2 · Post by **manic2** » Tue Nov 18, 2008 7:59 pm

I've just replicated my problem by creating a new forum & set the forum so it shows 5 topics per page.

I then created 20 topics, numbers 1 to 20.

I have given topics 6 to 20 priorities of 6 to 20 & left topics 1 to 5 with priorities of 0.

Viewforum shows the following: -

Page 1 topics 20 to 16 (correct)
Page 2 topics 15 to 11 (correct)
Page 3 topics 10 to 6 (correct)
Page 4 topics 16 to 20 (incorrect)

Topics 1 to 5 can’t be see at all in viewforum!

Lisbon · Post by **Lisbon** » Wed Nov 19, 2008 5:15 pm

Scrennshot please

ChriZathens · Post by **ChriZathens** » Wed Nov 19, 2008 6:07 pm

Congratulations, Elglobo...
A lot of people (including me..) had missed this mod since the migration to phpbb3...

Elglobo · Post by **Elglobo** » Thu Nov 20, 2008 12:54 pm

Hi all,

First, I am going to check the issue reported by manic2, and after I posted in the second message several screenshots.

Have a good day

Dugi · Post by **Dugi** » Thu Nov 27, 2008 7:37 pm

i dont understand this

ChriZathens · Post by **ChriZathens** » Thu Nov 27, 2008 10:20 pm

dugi wrote:i dont understand this

You mean that you can't understand what this mod does?

IPB_Refugee · Post by **IPB_Refugee** » Fri Nov 28, 2008 8:24 am

Elglobo wrote:First, I am going to check the issue reported by manic2

Any news on this? I have a similar issue on my board.

Regards
Wolfgang

Dugi · Post by **Dugi** » Fri Nov 28, 2008 12:36 pm

ChriZathens wrote:
dugi wrote:i dont understand this
You mean that you can't understand what this mod does?

yeah i don't understand what the mod does

IPB_Refugee · Post by **IPB_Refugee** » Fri Nov 28, 2008 12:59 pm

Hi,

with this MOD you can set the order of topics on viewforum page manually. The topics are displayed depending on their priority, not by their post time. (Only topics with standard priority appear in the order of last post's date.)

Here are some screenshots: http://www.phpbbhacks.com/demos/8537.gif

Regards
Wolfgang

8black · Post by **8black** » Fri Nov 28, 2008 10:21 pm

This mod is what i was looking for weeks!

...but... i'm not sure i'm able to install...

In the first part of the instructions, after "SQL", there are two lines:

Code: Select all

ALTER TABLE phpbb_topics ADD topic_priority SMALLINT DEFAULT '0' NOT NULL;
ALTER TABLE phpbb_topics ADD INDEX (topic_priority);

...err... what should i do with them?

IPB_Refugee · Post by **IPB_Refugee** » Sat Nov 29, 2008 6:31 am

Hi,

these are SQL orders: [Tutorial] How to use phpMyAdmin

Also worth a read: [Tutorial] How to install a MODX modification

Regards
Wolfgang

advertisements