Advanced Forum Properties part 2

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:

[MarkB]

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

[nuno]

hmm
i cant understand 2nd screenshot
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.