[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.

[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...
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:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

It appears two times, replace both with:

Block Disabled:      (Update License Status)
Suspended or Unlicensed Members Cannot View Code.

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.