Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Advanced Forum Properties part 2 Details »
Advanced Forum Properties part 2
Mod Version: 1.00, by Hoffi (Member) Hoffi is offline
Developer Last Online: Mar 2016 I like it Show Printable Version Email this Page

This modification is in the archives.
vB Version: 2.2.x Rating: (0 vote - 0 average) Installs: 17
Released: 28 Jan 2002 Last Update: Never Downloads: 5
Not Supported Is in Beta Stage  

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:

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
Color Picker for Admin CP Style Properties bira vBulletin 2.x Full Releases 40 22 Mar 2003 19:45

Comments
  #2  
Old 29 Jan 2002, 03:40
MarkB's Avatar
MarkB MarkB is offline
 
Join Date: Oct 2001
This looks like a great hack! I'll test it over the next couple of days
Reply With Quote
  #3  
Old 29 Jan 2002, 05:52
nuno's Avatar
nuno nuno is offline
 
Join Date: Oct 2001
hmm
i cant understand 2nd screenshot
what is it for? :stoned:
__________________
Powered by: vBulletin
Reply With Quote
  #4  
Old 29 Jan 2002, 06:06
Hoffi's Avatar
Hoffi Hoffi is offline
 
Join Date: Nov 2001
Real name: Christian
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.
Reply With Quote
  #5  
Old 29 Jan 2002, 06:16
Mark Hensler's Avatar
Mark Hensler Mark Hensler is offline
 
Join Date: Oct 2001
haha... that's WinXP using the Windows Classic theme. What's wrong? Don'tcha like a 'squishy' GUI?
Reply With Quote
  #6  
Old 29 Jan 2002, 22:02
DarkReaper DarkReaper is offline
 
Join Date: Oct 2001
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
Reply With Quote
  #7  
Old 29 Jan 2002, 22:35
Hoffi's Avatar
Hoffi Hoffi is offline
 
Join Date: Nov 2001
Real name: Christian
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.
Reply With Quote
  #8  
Old 30 Jan 2002, 10:06
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Real name: Maurice
Great hack, thanks.
Reply With Quote
  #9  
Old 30 Jan 2002, 20:26
DarkReaper DarkReaper is offline
 
Join Date: Oct 2001
Um...in editsortrows, shouldn't it select all the properties of a thread, not a forum?
Reply With Quote
  #10  
Old 30 Jan 2002, 20:42
Hoffi's Avatar
Hoffi Hoffi is offline
 
Join Date: Nov 2001
Real name: Christian
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.
Reply With Quote
  #11  
Old 31 Jan 2002, 20:44
DarkReaper DarkReaper is offline
 
Join Date: Oct 2001
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?
Reply With Quote
  #12  
Old 31 Jan 2002, 21:41
Hoffi's Avatar
Hoffi Hoffi is offline
 
Join Date: Nov 2001
Real name: Christian
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.
Reply With Quote
  #13  
Old 01 Feb 2002, 04:54
DarkReaper DarkReaper is offline
 
Join Date: Oct 2001
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
Reply With Quote
  #14  
Old 01 Feb 2002, 05:56
Hoffi's Avatar
Hoffi Hoffi is offline
 
Join Date: Nov 2001
Real name: Christian
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!

Last edited by Hoffi; 01 Feb 2002 at 05:59.
Reply With Quote
  #15  
Old 08 Feb 2002, 21:18
LangTuDaTinh LangTuDaTinh is offline
 
Join Date: Dec 2001
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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 10:32.

Layout Options | Width: Wide Color: