User Option Post Listing Order

[Littlebit]

I'm searching to see if there is already a hack created that provides the members with being able to choose for themselves in user options which order they prefer the posts to be listed. I prefer latest post first, but a few of my members would like the first post at the beginning. I ran a few searches but maybe I'm not using the right keywords? Or maybe there isn't a hack for this yet? If not would this be relatively easy to implement?

[Xenon]

i don't know if such a hack exists, but it wouldn't be hard to implement it

you have to add one field to usertable
edit member.php and one user-cp template to allow a user to change the value
and one really small change to showthread.php

lets say you add the field postorder to your usertable, you have to change this in showthread.php:

PHP Code:

// oldest first or newest first
if ($postorder==0) {
  $postorder="";
} else {
  $postorder="DESC";
} 


into this:

PHP Code:

// oldest first or newest first
if ($bbuserinfo[postorder]==0) {
  $postorder="";
} else {
  $postorder="DESC";
} 


[Littlebit]

Those file changes are more then some of the hacks here have. You should post your new hack so I can give you credit as one of your users :banana:
(I'm not sure why I just inserted that banana...I just saw it and it made me laugh...)
Anyway, thanks for responding and for the code.

[Xenon]

np

hmm, i think you're right, i should post more releases, but most of all i'm too laze to write a good installfile

also testing takes so much time, so i give more hints

[Littlebit]

Xenon,
did you ever list this as a hack? I've searched, but don't see anything in releases.

[Xenon]

no i didn't

[Brad]

If i get around to it i may release it myself.

[Littlebit]

I would love to make this official and fine tune it with instructions, but I don't have the experience to do it efficiently.
Is anyone willing to make this a hack worthy of being released?

[Littlebit]

Okay here is my trial go at it (no laughing )

RUN THIS QUERY:

ALTER TABLE user ADD postorder smallint(6) unsigned NOT NULL

OPEN SHOWTHREAD.PHP AND FIND AROUND LINE 111:

// oldest first or newest first
if ($postorder==0) {
$postorder="";
} else {
$postorder="DESC";
}

AND CHANGE TO THIS:

// oldest first or newest first
if ($bbuserinfo[postorder]==0) {
$postorder="";
} else {
$postorder="DESC";
}

OPEN MEMBER.PHP AND FIND AROUND LINE 637:


if ($bbuserinfo[showsignatures]) {
$showsignatureschecked="checked";
$showsignaturesnotchecked="";
} else {
$showsignatureschecked="";
$showsignaturesnotchecked="checked";
}

ADD BEFORE IT:

if ($bbuserinfo[postorder]) {
$postorderchecked="checked";
$postordernotchecked="";
} else {
$postorderchecked="";
$postordernotchecked="checked";
}

FIND AROUND LINE 841:

$options=iif($showsignatures=="yes",1,0);

ADD BEFORE IT:

$options=iif($postorder=="yes",1,0);

UPLOAD SHOWTHREAD.PHP AND MEMBER.PHP

OPEN TEMPLATE MODIFY OPTIONS AND FIND:

<tr>
<td bgcolor="#1C5780"><normalfont><b>Show user's signatures in their posts?</b></normalfont></td>
<td bgcolor="#1C5780"><normalfont>
<input type="radio" name="showsignatures" value="yes" $showsignatureschecked> yes
<input type="radio" name="showsignatures" value="no" $showsignaturesnotchecked> no
</normalfont></td>
</tr>

ADD BEFORE IT:

<tr>
<td bgcolor="#1C5780"><normalfont><b>Show posts in decending order?</b></normalfont></td>
<td bgcolor="#1C5780"><normalfont>
<input type="radio" name="postorder" value="yes" $postorderchecked> yes
<input type="radio" name="postorder" value="no" $postordernotchecked> no
</normalfont></td>
</tr>

What do I need to work on to get it working correctly?

[g-force2k2]

Littlebit a suggestion if i may... just use Xenon's edit and then run the query...

PHP Code:

ALTER TABLE user ADD postorder smallint(6) unsigned NOT NULL 


and then instead of making the option in the newthread / newreply just make the option in the member.php where the user profile stuff is

but thats just what i would do don't know how Xenon would or anyone else... regards...

g-force2k2