Sort Members By State

[ranger2kxlt]

I think this would be a great hack and definately useful for boards with chapters and stuff where people get together on a regular basis.

Anyways heres what i need. I will be changing the location field on the profile into a text box and a drop down box. The drop down box will contain the states and canadian provinces... whatever... and the text box will be for the city.

It will still display the same way as it always has and everything, just i was wanting to be able to sort members by state and i think this is the only way i can get it done. Anyways... after this i am lost on what to do to get it to sort this way. I know how to do the query to make it sort, but i cant make it support more than one page?? How can i do that?

PHP Code:

$DB_site->query("SELECT blah, blah, blah, state, blah FROM user ORDER BY state ASC"); 


Can someone write a hack to have this done?

[ranger2kxlt]

anyone interested? I know there has to be more people that would be interested in this type of thing... speak up!

[ranger2kxlt]

I can't believe that no one would be interested in this hack? Can someone at least point me in the right direction so i know what i will have to do???

[bharvey42]

I would be interested in it as well.

[ranger2kxlt]

Ok im turning this request into a beg! Please someone help with this!!

[Chris M]

I'm not entirely sure what the memberlist.php file uses as a variable to call the information to be displayed, but modify that query, and then create a new column in the memberlist template, called "State", then a new column in the memberlistbit template, and enter the variable name followed by [state]

i.e. $memberinfo[state]

As I said, I am not sure what the variable is

Satan

[PixelFx]

what if your not in a state? say your in a provence or an international user .. maybe adding system to group by country would be better...

[ranger2kxlt]

It may be for some... but my site pertains to the united states and canada as the cars are not offered anywhere else and that is why i asked for it this way.

[ranger2kxlt]

Satan thanks a bunch for the help... at least its something to start with. I will be working on this tomorrow but im highly doubting much progress with come of it... but we will see

[ranger2kxlt]

Update on this... suprisingly Im almost complete! Hope some people will be interested in this... its not the smallest hack ever.

I first had to hardcode in the location field instead of having it as a custom profile field in the admin cp... then i had to make it edittable in the profile and add a new collumn to the member list and edit the profile and postbit. I have everything working bug free except the sort which i havent attempted yet. Shouldnt be a problem though and I will get to it tomorrow.