Atozee Extension

We needed to have alphabetical pagination for a project we are working on. The SQL query method would have worked, however I am pulling several custom fields, I am pulling categories, and I will be using this on five other sites. Using a SQL query would have been a nightmare because each new site on MSM has different columns for custom fields. Seeing that this wasn’t working on 1.6.8 and its unfortunate method of adding a new column to a core table, I cracked open the extension to see if I could fix it. After removing the code that adds the new column and adjusting the SQL query modification to LEFT(LOWER(title), 1), I wasn’t seeing any results. It seems that the code depends on the custom build_sql_query hook which is a modification that Custom Fields in EE Tags uses. After applying this custom hook, my modified version began working. You can download it here or by the attached file. Thanks! Sam Oltz for Spearia

Hi Sam,

Thanks for updating this! Unfortunately, I was unable to get this working in 1.6.8, so wonder if I’m doing something wrong? Here’s my code:

{exp:weblog:entries weblog="resources" rdf="off" status="open|hidden" dynamic="off" title_alpha="c"}

{title}


{/exp:weblog:entries}

I thought that would give me a list of entries that began with C, but I just see all entries regardless.

Appreciate any tips on this if you can think of any.

Thanks.

Hello Stephen,

Did you apply the custom hook first? Sam’s version of the extension has some instructions for applying the hook near the top of his php file. I haven’t tried Sam’s extension yet but I took a quick look at it. In my 1.6.8 version of modules/weblog/mod.weblog.php, the hook location is more like line 2727 than the 2361 he notes.

From what I understand, the hook was part of Mark Huot’s formerly popular “Custom Fields” extension (2006-2007). Much of that extension’s functionality was subsumed when EE subsequently added the search=”” parameter to the weblog:entries tag.

If you get Sam’s version of Atozee working, please let me know. I may have a use for it sooner than I expected.

Thanks.

Hi fjldude 😊

Thanks for this, and argh, that’s where I was going wrong. I didn’t realise I needed to add the custom hooks.

To be honest, in that case, it’s probably not the extension for me as I hate having to add in ‘hacks’ to the core files.

When I couldn’t get this extension working, I went via the PHP route and this worked great: http://ellislab.com/forums/viewthread/81278/#426257

Thanks.