UBB.Developers Forums UBB.threads 6 V6 Modifications Archived Mods [6.x] User List Sort By Location 1.1

Mod Name / Version - User List Location 1.1
ver 1.1 fixes some errors in my directions
Description - Adds the Location and Ability to sort by location to the User List
Working Under - 6.1 (code should be the same for 6.0.x)
Any pre-requisites - none
Author(s) - JoshPet
Credits - msula
Files Altered - showmembers.php, showmembers.tmpl
Database Altered - no
New Files - none
Notes - Haven't tested this... simply modified my profile status bar stuff to the userlist. Should work fine. Let me know. <img src="/threads/php/images/icons/smile.gif" alt="" />
Created on - September 8, 2002

As always.... back up your files and database before installing any hacks. <img src="/threads/php/images/icons/wink.gif" alt="" />

Again, I haven't tested this..... let us know how it works for you. <img src="/threads/php/images/icons/smile.gif" alt="" />

didn't work for me?

Msula was going to try it.

I'll have to set it up on a test site and verify.

I had never used or tested this.

Finally had the need to install this on a site, and found a few typos in my directions.

I've updated the first post to version 1.1 which fixes my errors in the instructions....
And I guess it's no longer "untested". Works for me!

Josh, what site has this working, I would like to check it out, sounds like what I was looking for.

Small note, there is a missing </td> tag in the instructions for the template, it should look like this:

code:

Change it to this:

<td align="left" width="15%" nowrap="nowrap">
<a href="{$config['phpurl']}/showmembers.php?Cat=$Cat&sb=$sortstatus&page=$page">
{$ubbt_lang['USER_STATUS']} $StatusS
</a>
[:"red"]</td>[/] 
<td align="left" width="15%" nowrap="nowrap">
<a href="{$config['phpurl']}/showmembers.php?Cat=$Cat&sb=$sortlocation&page=$page">
Location $LocationS
</a>

---

Also, further down in the script there is a colspan that needs to changed.

Otherwise it seems to work fine.

Thanks!

Good eye.

I've corrected the instructions attached to the first post.

Josh, I used this mod for 6.4 now and it works!! well... 95%

And I hope that someone here is able to help me sloving the missing 5%

What's not working is the SORTING. When I click on 'location' in my User List, it sorts something, but I can't figure out what.

Can I send my showmembers.php to someone to check it out ?

Thanks!

Pasqual

Ok, I figured out that when clicking on 'Location' it does sort!! Only problem is that it shows the blanks first in stead of 'a'

I have no idea how I can correct this... anyone ?

I don't know this script that well but try to put in a ltrim() and why your at it a rtrim()

Thanks for the suggestion scroungr, but I've got zero-point-one knowledge of php/sql

Applying the hack above was a piece of cake, but now I have no idea where I should put the ltrim() and rtrim().
Can I send you my file ?

As I said not to sure of this mod.. hopes Josh speaks soon but I would try a ltrim here

find list ($Username,$Reged,$ICQ,$Home,$Posts,$Status,$Location) = $dbh -> fetch_array($sth);
place under it

$Username = ltrim(rtrim($Username));

and see what the outcome is

I'm not sure of a way around that - the sorting is being done in the MySQL query with an ORDER BY statement. This mod just adds an additional field to the existing user list functionality. The other user list fields all behave the same way... if you click on home page or ICQ number, all the ones without answers come first.