Sort Article Alphabetically SMF1.0.7

[bloc]

ah, yes. I forgot...that code was from 0.9.5, while you have 0.8.6.

Just switch "ORDER BY date DESC" to "ORDER BY subject ASC" and it should work fine. The second "tpsort" should be the same.

[Nifelhein]

Thanks a lot Bloc, I knew this could be done somehow without hours looking for where and how.

[Nifelhein]

It worked like a charm, now I will leave you guys to your hard and great work. Since I just found this amazing forum, should this be taken to tips and tricks?

[Assistance]

it should be merged with my topic

[Nifelhein]

Well, has it helped you too? My site has this done and working.

[Assistance]

nope
gave up on 1.0.7 cause no one was making mods for it
so I went up to 1.1 RC2 and re did my entire site
so I lost everything that I had for the new features
( I think it was worth it )

[Nifelhein]

I jsut noticed, after quite a while, that this change lead to a change in the way news items are shown in the frontpage, they also get sorted alphabetically, but in reverse (from Z to A), a very unwelcome side effect of the change that resulted in me going back to the original code.

We will be installing SMF 1.0.8 and Tp 0.9.5 in the weekend and hopefully we will have things perfect with that alone.

Just thought you woudl like to know. Cheers!

[bloc]

Thats because the sorting routine sort the other way too..and it does sort both topics and articles. So although articles is fetched correctly, the topics are not - because it use a SSI function, which is already "made".

[Nifelhein]

Thanks for the reply Bloc, is that changed on v0.9.5 or in the thoughts for v1.0? If not, I would suggest giving us options to sort articles and still have the enws items sorted the way they should be, I think it could be useful to more people that way, but if it involves too much work i can udnedrstand it not being done at all.

I do want to congratulate you on your work though, it is very very good.

[bloc]

Thank you.

I will look into this. I can see it as viable option, along with for example showing news, then articles or vice-versa. Also a mode where articles, news and recent uploads come mixed or after one another.