This was a rather small mod I made for how my ticket system is needed to work. I just figured I'd share it.
Effect: Allows you to choose any staff member as a department manager regardless of the department they are in. This means that if you need one person to be the manager of multiple departments, you can do so.
in include/staff/dept.inc.php
Change:
<? if($info) { //update
$users= db_query('SELECT staff_id,CONCAT_WS(" ",firstname,lastname) as name FROM '.STAFF_TABLE.' WHERE dept_id='.db_input($info));
?>
To:
<? if($info) { //update
$users= db_query('SELECT staff_id,CONCAT_WS(" ",firstname,lastname) as name FROM '.STAFF_TABLE);
?>
In the future I'll look at ammending this post with a second mod on allowing multipl managers for a dept. Since that doesn't effect me atm, it'll have some wait time