Changing the createdBy pull down to show the value of a first name and last name field from a member's account record

Hi Jerry

This will be a thread for advanced users only.  

What you are looking for is the "ajaxGetUsersAsPulldown()" function you found in common.php.  You'll see the SQL that is used to grab the list of users.  

$query = "SELECT u.num, u.username              FROM {$TABLE_PREFIX}accounts u              JOIN {$TABLE_PREFIX}_accesslist a ON u.num = a.userNum             WHERE a.accessLevel > 1 AND a.tableName IN ('all','$tableName')             ORDER BY username";

The first field in the SELECT is what gets used as the value stored in your database and should always be left as "a.num".

The section field listed is what is displayed in the drop down. You could do a CONCAT(a.firstname,a.lastname) or something like that. 

Keep in mind that we don't support changes to the library files like this so any further discussion on this can be continued through consulting@interactivetools.com. You'll also find that this change will be undone when you upgrade next.

Thanks!

$query = "SELECT u.num, u.username              FROM {$TABLE_PREFIX}accounts u              JOIN {$TABLE_PREFIX}_accesslist a ON u.num = a.userNum             WHERE a.accessLevel > 1 AND a.tableName IN ('all','$tableName')             ORDER BY username";