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:
// oldest first or newest first
if ($postorder==0) {
$postorder="";
} else {
$postorder="DESC";
}
into this:
// 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 :p )

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

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

[Xenon]

Looks good so...

[Littlebit]

Originally posted by g-force2k2
instead of making the option in the newthread / newreply just make the option in the member.php where the user profile stuff is ;)

Hi g-force :)
I edited the post above to add your query instead...I'm not sure what you mean about making the option in newthread/newreply...is that what I did in member.php above? I thought it was the profile stuff. :ermm:

[Littlebit]

Hi Xenon :classic: ,
Originally posted by Xenon
Looks good so...
Does this mean you think it may work? nothing major I need to alter?

[Austone]

some quick suggestions...

1) in member.php don't mess with the $options... make a new variable... such as

$thepostorder=iif($thepostorder=="yes",1,0);

2)further down find the query that starts.. $DB_site->query("UPDATE user

and add... postorder='$thepostorder', anywhere will work.. I added it right after ....
emailonpm='$emailonpm',pmpopup='$pmpopup'

3)make sure that you change the template to reflect the variable name i.e. $thepostorder

<tr>
<td bgcolor="{firstaltcolor}"><normalfont>
<b>Show posts in decending order?</b>
</normalfont></td>
<td bgcolor="{firstaltcolor}"><normalfont>
<input type="radio" name="thepostorder" value="yes" $postorderchecked> yes
<input type="radio" name="thepostorder" value="no" $postordernotchecked> no
</normalfont></td>
</tr>

This worked for me.

THEN I had to go in and make a bunch of changes to teh post numbers hack... but you won't need that unless you use that hack.

Hope that helps,
Kyle

P.S. I can rewrite all this if you have probs... but it looks like you were almost there anyway!

[Littlebit]

Kyle,
Thank you for the wonderful input :)
I wouldn't say I'm almost there as far as doing it myself, however. :bandit:
Xenon got the ball rolling with this stuff:
if ($bbuserinfo[postorder]==0) { ... and g-force fixed my lame guess at a query! All I did was guess at the template changes to add...and what you just told me has given me the courage to write it all out and install it.
And I don't mind writing it out and pming it to anyone who wants to post it in the beta forum.
I really think some people may find it useful other then us.
What you said about the numbering posts hack. I was wondering how this would effect that hack earlier here (https://vborg.vbsupport.ru/showthread.php?postid=316657#post316657) . Oh duh! I just saw your reply in that thread. Thanks again :)