[fixed] member list

[cihangir]

each user is shown 4 times at this url (http://beta.jelsoft.com/memberlist.php?sessionhash=19a0608ae524489c9bd4277 30bc4177f&action=getall&what=&perpage=30&orderby=username&ausername=&ahomepage=&aicq=&aaim=&ayahoo=&joindateafter=&joindatebefore=&lastpostafter=&lastpostbefore=&postslower=&postsupper=&direction=&pagenumber=46) (found it at the referrer list of my site statics)

[Wayne Luke]

Originally posted by cihangir
each user is shown 4 times at this url (http://beta.jelsoft.com/memberlist.php?sessionhash=19a0608ae524489c9bd4277 30bc4177f&action=getall&what=&perpage=30&orderby=username&ausername=&ahomepage=&aicq=&aaim=&ayahoo=&joindateafter=&joindatebefore=&lastpostafter=&lastpostbefore=&postslower=&postsupper=&direction=&pagenumber=46) (found it at the referrer list of my site statics)

Looks like a join isn't created properly. Might try to force it using a Select Distinct or a join on userid

[Freddie Bingham]

Yes the SQL statement is at fault as you can see .. It wasn't apparent until I went and added more custom profile fields .. I am going to fix it in a bit..

[Freddie Bingham]

fixed and you can now also actually use the advanced search now (no longer returns every user no matter what you put in)