Advanced Forum Properties part 2

[Hoffi]

some time ago, i asked if it's possible to enter an extra sorting option for each forum.
a small but Ppowerful hint came up from FireFly, and i build a Hack around it.

I hope it works and you like it.

What it does: it adds new Fileds to every Forum-Properties and you can select, if the Board-defaults were shown when the forum is opend, or you you can say which Row schould be sorted. Ascending or Descending is also selectable.
To build it as much as flexible, I add an Admin-Page, where you can Select some of all Listed Colums existing in the forum-Table. Even new added through Hack. So have only These Colums in your Drop-Down Box.

Part 1 of this Hack is the DaysPruneOverride Hack.
Later i will release all of them in one Big hack.

I hope you like it.
-----
Update:
The SQL ALTER-Command was wrong. Fixed.
-----
Update:
I must be blind and used the wrong table. Fixed.

Demo:
http://www.hoffi.org/demo.gif

[MarkB]

This looks like a great hack! I'll test it over the next couple of days :D

[nuno]

hmm
i cant understand 2nd screenshot :confused:
what is it for? :stoned:

[Hoffi]

I'll try to explain.

The 2nd Screenshot is what you get, if you click on "Sort Preselection" in the Menu.
Here I list all fields of the Forum-Table and you can specify which Colums should appear in the Drop-Down Box you can see in Screenshot 1.
I did this, because i won't set only a few fix Colums to sort. So you can select your own. Even if you added fields through a Hack, you can select this fields to see it in the sort-Drop-Down Box.

I hope this helps you to understand the 2nd screenshot.

[Mark Hensler]

haha... that's WinXP using the Windows Classic theme. What's wrong? Don'tcha like a 'squishy' GUI? ;)

[DarkReaper]

ALTER TABLE forum ADD sortdefault VARCHAR (4) DEFAULT 'DESC' not null, sortrow VARCHAR (255), sortoverride SMALLINT DEFAULT '0' not null

MySQL said:

You have an error in your SQL syntax near 'sortrow VARCHAR (255), sortoverride SMALLINT DEFAULT '0' not null' at line 1

[Hoffi]

Ups. mySQL don't like it, to add three rows on a time. Just change it to these three ALTER-SQL-Commands:

ALTER TABLE forum ADD sortdefault VARCHAR (4) DEFAULT 'DESC' not null

ALTER TABLE forum ADD sortrow VARCHAR (255)

ALTER TABLE forum ADD sortoverride SMALLINT DEFAULT '0' not null

then it works.

txt-File Updated.

[Lesane]

Great hack, thanks. :up:

[DarkReaper]

Um...in editsortrows, shouldn't it select all the properties of a thread, not a forum?

[Hoffi]

Originally posted by DarkReaper
Um...in editsortrows, shouldn't it select all the properties of a thread, not a forum?

Why? I want to sort the Forum. So i see no need, to get any properties of the thread.

[DarkReaper]

Wait...doesn't this allow you to change the default sort settings of the threads within a forum? So when they go to the forum it defaults to sorting ASC/DESC ordered by title, posts, views, or whatever you choose?

[Hoffi]

Yes. It sorts the Threads in the specified Forum. But i don't use any thread-properties. The Threads inside the Forum were sorted like my choose in the CP. eg. Title, ASC.
With my Part 1 of the Hack, to override the User-Settings how old threads should be shown, this is perfect or an archive. Thats why i develop this Hacks.
When all is done, i will release on big Hack named Advanced Forum properties.

[DarkReaper]

I don't understand how you would be ordering threads a certain way by using properties that apply to the forum. It doesn't make sense...threads should be ordered by their own properties - replies, views, titles, starter, last poster, etc...not by the forum's properties. Just one example(because I'm too tired to list them all) - you wouldn't sort threads by the 'allowposting' option :)

[Hoffi]

D'oh!
Now I understand you. I must be blind... :D
Thanks DarkReaper!
It works, because the filed-names in both tables were nearly the same... I Updated the hack. The Changes were small, but now it is better.

Update:
First go to the New Menu. Sort Preselection.
Disable all Columns. (You not disable rows, if you are shure, the they are in both tables the same! e.g. title)

Opel admin/forum.php:

Search for:
$sortinfos=$DB_site->query("describe forum");

It appears two times, replace both with:
$sortinfos=$DB_site->query("describe thread");

Now you can reset you Sort Preselection! You will see, that the List is smaller. ;)

That's all!

[LangTuDaTinh]

I did install as you said and but it seems that ascending doesn't work. it always display in descending order. (note i changed to ASC in my forum properties) pls tell me what should i need to fix.

[Hoffi]

If you installed all Correctly, it must work. So please take a look, if you changed all correctly, and upload your files again.

I think you forgot some Code in forumdisplay.php

[eg_92901]

I had the same problem, I restored the original forumdisplay.php and reapplied the code just for that page and it works now.

Thanks for the great hack, its just what I needed! :D

[ladyfyre]

Two questions:

1. Will this work with 2.2.6?

2. Can you add the option to allow a sort by the date the thread was started?

[Hoffi]

I haven't tested it with 2.2.6
You can chooser yourself which Table-Fields are Displayed in the Drop-Down Box. I am just not shure if this Date is in one of the Fileds, if yes you can do It by Yourself. Otherwise i must take a look to the DB-Structure.

[Pontemonti]

I got it to work with 2.26.
I had one problem, though - I had to modify forumdisplay.php

Find:
switch ($sortfield) {

Now, the fields you want to be able to sort on should be added below that line...For example, I wanted to sort on threadid (making the forum display the threads in the order which they were posted), so I added the following line:
case 'threadid':


I also made a template modification to allow everyone to sort on threadid...I modified this template:
forumdisplay_threadslist

Find:
<option value="title" $sort[title]>thread title</option>

Add below:
<option value="threadid" $sort[threadid]>thread post time</option>


Okay, that should be it. A small improvement...hope it helps someone :nervous:

[X-Fan]

Originally posted by Hoffi
If you installed all Correctly, it must work. So please take a look, if you changed all correctly, and upload your files again.

I think you forgot some Code in forumdisplay.php

I'm having a similar problem on v2.2.8 - it's only sorting by descending, not ascending even though I've got the sort order set to ascending. And I've triple-checked the code, and it's all been added/changed correctly.

Help!

[kevinnguyen]

02-08-02 at 11:18 PM LangTuDaTinh said this in Post #15 (https://vborg.vbsupport.ru/showthread.php?postid=219127#post219127)
I did install as you said and but it seems that ascending doesn't work. it always display in descending order. (note i changed to ASC in my forum properties) pls tell me what should i need to fix.
i got the same prob on 2.3.0 *sigh*
i was looking for this hack

[kevinnguyen]

nevermind
fixed the problem

[X-Fan]

How'd you fix it?

[kevinnguyen]

somehow the code doesnt accept the capital letters (ASC, DESC) so i replaced them w/ (asc, desc)

in admin/forum.php
Find:
makecustomchoosercode ("Default sort order","sortdefault","ASC,DESC");
Change it to:
makecustomchoosercode ("Default sort order","sortdefault","asc,desc");
Find:
makecustomchoosercode ("Default sort order","sortdefault","ASC,DESC",$forum[sortdefault]);
Replace w/:
makecustomchoosercode ("Default sort order","sortdefault","asc,desc",$forum[sortdefault]);
It should work fine now

[X-Fan]

You mean admin/forum.php ;)

[kevinnguyen]

yeah, sorry :D

[noonespecial]

yeah, sorry :D
this is NEEDED for vb3

[Hoffi]

this is NEEDED for vb3
Indeed. I will be build it next time.