Fixes

This discussion is related to the User List addon.

To fix the random member and Limit number of users:
Change line 32+:
$this->Users = $SQL
->Select($Select)
->From($From)
->Join('UserRole r','u.UserID = r.UserID')
->Where($Where)
->Get();
To:
$this->Users = $SQL
->Select($Select)
->From($From)
->Join('UserRole r','u.UserID = r.UserID')
->Where($Where)
->OrderBy($Order)
->Limit($Limit)
->Get();

Andrew

Aolee

hi andrew, how come only one user is being displayed in the member box? pls see www.pinoyau.info

i tried to print_r the returned row values but only admin is really being fetched? but if i enable the photo, all three members are shown?

Aolee

ok i got the the answer, it's on the setting, i have to tick " Show users that don't have a photo" sorry for my ignorance.