Order of posts alphabetically
 

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!

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

Like this?

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

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

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. Page 2 puts them in reverse order.

If you click here, 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

Oh wonderful! :dead:

:classic:

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

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

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

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).
It then arranges the threads alphabetically.

Dave.

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

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.

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

Please? :classic:

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

one } is on an invalid place.

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.

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

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...hp?forumid=164

Look at my Hack: http://www.vbulletin.org/hacks/index...ack&hackid=136

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.

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