/admin/users/index.php "hack"

[ilicz]

Hi...
We have web with several tens of user accounts, divided into several different groups. I needed to easily see, which group each user belongs to, so I "hacked" /admin/users/index.php to show it in the dropdown menu.

Changed file (WB 2.6.5) is attached to this post...

Main change is in db $query - it was extended to ask also for group_name in groups table.
The second - minor - change was reformatting of output sended to dropdown menu. User info in dropdown menu now displays like
"username (group) - display_name"

Code:

// Get existing value from database
$database = new database();
$query = "SELECT user_id, username, display_name, ".TABLE_PREFIX."groups.name AS group_name FROM ".TABLE_PREFIX."users, ".TABLE_PREFIX."groups WHERE (user_id != '1') AND (".TABLE_PREFIX."users.group_id = ".TABLE_PREFIX."groups.group_id) ORDER BY username";
$results = $database->query($query);
if($database->is_error()) {
$admin->print_error($database->get_error(), 'index.php');

...

while($user = $results->fetchRow()) {
$template->set_var('VALUE', $user['user_id']);
$template->set_var('NAME', $user['username'].' ('.$user['group_name'].') - '.$user['display_name']);
$template->parse('list', 'list_block', true);
}