[Solved] user list plugin : random users not working

Chanux

im using user list plugin. random user not working. always displaying same users. how can i fix

jspautsch

Looks like he forgot to include the OrderBy. Open up class.userlistmodule.php and find the following statement...

$this->Users = $SQL
        ->Select($Select)
        ->From($From)
        ->Join('UserRole r','u.UserID = r.UserID')
        ->Where($Where)
        ->Get();

...then add a line to make it look like this:

$this->Users = $SQL
        ->Select($Select)
        ->From($From)
        ->Join('UserRole r','u.UserID = r.UserID')
        ->Where($Where)
        ->OrderBy($Order)
        ->Get();

See if that works!

jspautsch

Looks like he forgot to include the OrderBy. Open up class.userlistmodule.php and find the following statement...

$this->Users = $SQL
        ->Select($Select)
        ->From($From)
        ->Join('UserRole r','u.UserID = r.UserID')
        ->Where($Where)
        ->Get();

...then add a line to make it look like this:

$this->Users = $SQL
        ->Select($Select)
        ->From($From)
        ->Join('UserRole r','u.UserID = r.UserID')
        ->Where($Where)
        ->OrderBy($Order)
        ->Get();

See if that works!

Chanux

@jspautsch wow its working. thank you so much