Order of posts alphabetically

[Cyn]

In forumdisplay.php I have the following code placed to alphabetize the thread titles in one forum.

switch ($sortfield) {
case 'title':
case 'lastpost':
case 'replycount':
case 'views':
case 'postusername':
case 'voteavg':
break;

default:

if($foruminfo[forumid]==163) $sortfield='title';
else $sortfield='lastpost';
}

This is placing the threads in reversed alphabetical order Z - A. How can I change it to place them A-Z? Thanks!

[Xenon]

add $sqlsortoder='ASC'; to your if cond ;)

[Cyn]

Like this?

default:
if($foruminfo[forumid]==163) $sortfield='title'; $sqlsortorder='ASC';
else $sortfield='lastpost';

Edited to add: It worked!! :classic: Thanks!!

[Cyn]

I spoke too soon.

I placed the same code as another "if" to include another forum, like this:

default:
if($foruminfo[forumid]==163) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==164) $sortfield='title' AND $sqlsortorder='ASC';
else $sortfield='lastpost';
}


Problem is it only works for page 1 (http://www.mothering.com/discussions/forumdisplay.php?s=&forumid=164). Page 2 (http://www.mothering.com/discussions/forumdisplay.php?s=&forumid=164&daysprune=30&sortorder=&sortfield=title&perpage=30&pagenumber=2) puts them in reverse order.

[Chris M]

If you click here (http://www.mothering.com/discussions/forumdisplay.php?s=&forumid=164&daysprune=30&sortorder=&sortfield=title&perpage=30&pagenumber=1), you will see that it reverses the order when you go back to page one by clicking on the page1 link...

It has something to do with the "pagenumber":)

Satan

[Cyn]

Oh wonderful! :dead:

:classic:

[Cyn]

I tried this:

default:
if($foruminfo[forumid]==163) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==163 AND pagenumber=2) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==164) $sortfield='title' AND $sqlsortorder='ASC';

else $sortfield='lastpost';
}

And got this:

Parse error: parse error, unexpected '=' in /usr/www/users/mother1/discussions/forumdisplay.php on line 376

[Cyn]

And tried this:

default:
if($foruminfo[forumid]==163) $sortfield='title' AND $sqlsortorder='ASC';
if($foruminfo[forumid]==163 AND $foruminfo[pagenumber]==2) $sortfield='title' AND $sqlsortorder='ASC';


Didn't get a parse error but no desired result either. :(

[Xenon]

your synatx is incorrect, you have to do it like this:

if($foruminfo[forumid]==163)
{
$sortfield='title';
$sqlsortorder='ASC';
}

[Davey]

Isn't this feature already available?
You click on "Thread" at the top of the forum (Click here to arrange all of General Hacking Discussion's threads alphabetically (https://vborg.vbsupport.ru/forumdisplay.php?s=&forumid=10&daysprune=30&pagenumber=1&perpage=25&sortorder=asc&sortfield=title)).
It then arranges the threads alphabetically.

Dave.

[Xenon]

yes, but i think he meant to be automatically :)

[Cyn]

Thanks Xenon but how will that fix the reversed alphabetization on thread page 2? That's my problem right now. My current syntax is working to alphabetize a-z on page 1 but page 2 is z-a.

[Cyn]

I tried your syntax and I still have the same problem page 1 is a-z but page 2 is z-a. I've discovered something else that is problem as well.

I want the posts to be listed in a-z order of thread title regardless of last post date. I don't want the post date to influence the placement of the thread. I want all threads that start with A to be listed with all the A's and so on. Presently there are A's on page 1 and on page 2 due to the date of the last post.

So two things: a-z order on all pages and placement of threads in their a-z order regardless of post date or last post date.

I appreciate your help. Really I do. :)

PS. I'm a she. ;)

[Cyn]

Please? :classic:

[Rebo Firemead]

I tried this and several other variants and have not been able to get it to work. :(

vB version: 2.3.0
PHP version: 4.3.1
MYSQL ver.: 4.0.13


switch ($sortfield) {
case 'title':
case 'lastpost':
case 'replycount':
case 'views':
case 'postusername':
case 'voteavg':
break;

default:
if($foruminfo[forumid]==49)
{$sortfield='title';
$sqlsortorder='ASC';

else $sortfield='lastpost';
}}

[Xenon]

one } is on an invalid place.

[Rebo Firemead]

Well, I've tried editing this snippet of code 7 ways from Sunday, all to no avail. I'll work on it in my test forums and catalog the changes and errors.

[cindyd]

Did this hack ever get worked out? I was also interested in applying this to 1 of my forums. Thanks

[Cyn]

We're using it but the second and all following pages don't alphabetize in continuing order. They flip the alphabetization. For example, page one gives a list like this:

a
b
c
d
e
f
g
h
i
j


Page two reads like this, repeating those same threads:

j
i
h
g
f


And page three:

d
c
b
a


You can see it in action here: http://www.mothering.com/discussions/forumdisplay.php?forumid=164

[Hoffi]

Look at my Hack: http://www.vbulletin.org/hacks/index.php?s=&action=showhack&hackid=136

[cindyd]

Cyn: I see if you select "ascending" order on the bottom of page 2, then it rights itself on that page as well as page 3.

I would like the hack to do this automatically, I can see from your forum why you would want this too.

[Cyn]

Yes, that is what I suggest to our members to correct the inverted order. If you find a solution please do let me know.
:)