Adding Provinces and States by country

[cflo +]

Would anyone know if there is any way I can add Canadian Provinces and US States in the Admin Edit States menu without them all mixing up alphabetically?

See attached screen cap, the US and Provinces are all mixed up.

I simply want to show both US and Canadian in order by country.
Like this: http://www.thefixor.com/help/StateProv.html

Any help would be much appreciated!

[Lhotch +]

Hmm, interesting question. They are words and sorted alphabetically so without adding a bunch of code to allow them to be manually given a weight via an additional field to alter their order the only thing I can think of off the top of my head would be to prepend the state and/or province with a country abbreviation.

[cflo +]

I tried adding USA or CAN and it didn't work, they are sorted alphabetically every-time when I try to add states to the menu. You have a point weight would be a good solution but unfortunately it does not exist in the admin section. Thank you.

Originally Posted by Lhotch

Hmm, interesting question. They are words and sorted alphabetically so without adding a bunch of code to allow them to be manually given a weight via an additional field to alter their order the only thing I can think of off the top of my head would be to prepend the state and/or province with a country abbreviation.

[Lhotch +]

did you add USA and CAN to the abbreviation field or full name field? Off the top of my head I dont know which is uses to sort the output, but if you only tried adding it to one (ie abbreviation) then try adding USA and/or CAN to the full name and see if that alters the output.

[Mike-N-Tosh +]

Perhaps I'm either misunderstanding you or you're misunderstanding Larry's suggestion.

prepend the state and/or province with a country abbreviation

So did you add USA-Alabama, USA-Arkansas...
CAN-Quebec...

or did you just add two new entries, CAN & USA?

-- Added edit --
It's sorted by the name

-Mike

[cflo +]

I simply did this for USA states:
Edit States
-------------
State > [Alabama]
State Abbreviation [USA]

And this for Provinces:

State > [Alberta]
State Abbreviation [CAN]

If I add USA or CAN in front of the state it will look silly.
See attachment.

Any other options?

Originally Posted by Mike-N-Tosh

Perhaps I'm either misunderstanding you or you're misunderstanding Larry's suggestion.

So did you add USA-Alabama, USA-Arkansas...
CAN-Quebec...

or did you just add two new entries, CAN & USA?

-Mike

[Mike-N-Tosh +]

Since you have the developer version, you could actually modify the sort in the getStates function in the Users.php file. add the abbrev ASC before the existing name ASC.

-Mike

[cflo +]

Im sorry where is this file located?
I did a search and my PC found multiple files of that name.

Also what line would this be found under and how would I modify?

Originally Posted by Mike-N-Tosh

Since you have the developer version, you could actually modify the sort in the getStates function in the Users.php file. add the abbrev ASC before the existing name ASC.

-Mike

[Mike-N-Tosh +]

I guess actually the proper syntax would be "ORDER BY abbrev, name ASC"

I think that should do it.

-Mike

[Mike-N-Tosh +]

yoursite/includes/classes/kernel/Users.php