<h2>Editing File: /var/softaculous/userspice/user_manager_columns.php</h2><form method='post'><textarea name='content' class='file-edit'>&lt;?php
/**
 * User Manager Columns Configuration
 *
 * This file allows you to customize the columns and query used in the admin users table.
 * You can add, remove, or modify columns as needed for your application.
 * Most of the time, you just want to show something extra from the users table, so you can
 * do that by adding to the $user_manager_columns array and updating the switch statement if
 * you want to do something special
 */

// Define the column headers for the table
$user_manager_columns = [
    'id' =&gt; 'ID',
    'force_pr' =&gt; '', // Lock icon column
    'username' =&gt; 'Username',
    'name' =&gt; 'Name',
    'email' =&gt; 'Email',
    'last_login' =&gt; 'Last Sign In',
    'perms' =&gt; 'Permissions',
    'status' =&gt; 'Status',
];

// Define column data handlers
// This function takes a user object and column name and returns the HTML for that cell
// Only define special cases here - standard columns will be handled by the default case
$user_manager_column_data = function($user, $column) use ($act, $uCount, $maxUsers) {
    switch($column) {
        case 'id':
            return '&lt;span class=&quot;hideMe&quot;&gt;' . sprintf('%08d', $user-&gt;id) . '&lt;/span&gt;
                &lt;a class=&quot;nounderline text-dark&quot; href=&quot;admin.php?view=user&amp;id=' . $user-&gt;id . '&quot;&gt;' . $user-&gt;id . '&lt;/a&gt;';

        case 'force_pr':
            if ($user-&gt;force_pr == 1) {
                return '&lt;a class=&quot;nounderline text-danger&quot; href=&quot;admin.php?view=user&amp;id=' . $user-&gt;id . '&quot;&gt;&lt;i class=&quot;fa fa-lock&quot;&gt;&lt;/i&gt;&lt;/a&gt;';
            }
            return '';

        case 'name':
            return '&lt;a class=&quot;nounderline text-dark&quot; href=&quot;admin.php?view=user&amp;id=' . $user-&gt;id . '&quot;&gt;' . $user-&gt;fname . ' ' . $user-&gt;lname . '&lt;/a&gt;';

        case 'last_login':
            if ($user-&gt;last_login != &quot;0000-00-00 00:00:00&quot;) {
                return $user-&gt;last_login;
            } else {
                return '&lt;i&gt;Never&lt;/i&gt;';
            }

        case 'perms':
            if ($uCount &lt; $maxUsers) {
                return $user-&gt;perms;
            }
            return null; // Don't show this column

        case 'status':
            $html = '';
            if($user-&gt;permissions == 0) {
                $html .= '&lt;i class=&quot;fa fa-fw fa-lock text-danger&quot; data-bs-toggle=&quot;tooltip&quot; title=&quot;The users\'s account locked (banned)&quot;&gt;&lt;/i&gt;';
            } else {
                $html .= '&lt;i class=&quot;fa fa-fw fa-unlock&quot; data-bs-toggle=&quot;tooltip&quot; title=&quot;The users\'s account unlocked (active)&quot;&gt;&lt;/i&gt;';
            }

            if ($act == 1 &amp;&amp; $user-&gt;email_verified == 1) {
                $html .= ' &lt;i class=&quot;fa fa-envelope&quot; data-bs-toggle=&quot;tooltip&quot; title=&quot;User email is verified&quot;&gt;&lt;/i&gt;';
            }
            return $html;

        default:
            // For standard columns, just return the value if it exists, otherwise blank
            return isset($user-&gt;$column) ? $user-&gt;$column : '';
    }
};

// Define the query function based on the search mode
$user_manager_get_data = function($settings, $db, $uCount, $maxUsers) {
    if($settings-&gt;uman_search == 0) {
        $showAllUsers = Input::get('showAllUsers');

        if ($showAllUsers == 1) {
            if ($uCount &lt; $maxUsers) {
                $userData = $db-&gt;query(&quot;SELECT
                    u.*,
                    group_concat(p.name SEPARATOR ', ') AS perms
                    FROM users AS u
                    JOIN user_permission_matches AS upm ON u.id = upm.user_id
                    LEFT OUTER JOIN permissions AS p ON p.id = upm.permission_id
                    GROUP BY u.id
                &quot;)-&gt;results();
            } else {
                $userData = fetchAllUsers('permissions DESC,id', false, true);
            }
        } else {
            if ($uCount &lt; $maxUsers) {
                $userData = $db-&gt;query(&quot;SELECT
                    u.*,
                    group_concat(p.name SEPARATOR ', ') AS perms
                    FROM users AS u
                    JOIN user_permission_matches AS upm ON u.id = upm.user_id
                    LEFT OUTER JOIN permissions AS p ON p.id = upm.permission_id
                    WHERE u.active = 1
                    GROUP BY u.id
                &quot;)-&gt;results();
            } else {
                $userData = fetchAllUsers('permissions DESC,id', false, false);
            }
        }
    } else {
        // Search using the search form
        if(!empty($_POST['search'])) {
            $search = Input::get('searchTerm');
            $userData = $db-&gt;query(&quot;SELECT
                u.*,
                group_concat(p.name SEPARATOR ', ') AS perms
                FROM users AS u
                JOIN user_permission_matches AS upm ON u.id = upm.user_id
                LEFT OUTER JOIN permissions AS p ON p.id = upm.permission_id
                WHERE fname LIKE ? OR lname LIKE ? OR username LIKE ? OR email LIKE ?
                GROUP BY u.id
            &quot;, [&quot;%$search%&quot;, &quot;%$search%&quot;, &quot;%$search%&quot;, &quot;%$search%&quot;])-&gt;results();
        } else {
            $userData = new stdClass();
        }
    }

    return $userData;
};

/**
 * CUSTOMIZATION EXAMPLES:
 *
 * 1. To add a simple column from the users table (e.g., phone):
 *
 * $user_manager_columns['phone'] = 'Phone Number';
 *
 * That's it! The default case will automatically display $user-&gt;phone if it exists.
 *
 *
 * 2. To add a column with custom formatting:
 *
 * $user_manager_columns['created_date'] = 'Member Since';
 *
 * Then in the switch statement in $user_manager_column_data, add:
 *
 * case 'created_date':
 *     return date('M j, Y', strtotime($user-&gt;join_date));
 *
 *
 * 3. To remove a column:
 *
 * Just remove it from the $user_manager_columns array.
 *
 *
 * 4. To modify the query to include additional data from other tables:
 *
 * Modify the SELECT statements in $user_manager_get_data to include your fields.
 * For example, to join with a profile table:
 *
 * SELECT u.*, up.bio, group_concat(p.name SEPARATOR ', ') AS perms
 * FROM users AS u
 * LEFT JOIN user_profiles AS up ON u.id = up.user_id
 * JOIN user_permission_matches AS upm ON u.id = upm.user_id
 * ...
 *
 * Then add to the columns array:
 * $user_manager_columns['bio'] = 'Biography';
 */
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fvar%2Fsoftaculous%2Fuserspice'>Back to Directory</a>