Can anyone help improve this so it works?
if (!defined("WHMCS")) die("This file cannot be accessed directly");
function add_admin_name_email($merge_fields) {
$table = "tbltickets";
$fields = "id,admin";
$where = array("id"=>$userid);
$result = select_query($table,$fields,$where);
$data = mysql_fetch_array($result);
$id = $data['id'];
$name = $data['admin'];
$messagename = 'Support Ticket Reply';
$relid = '9';
$merge_fields = array();
$merge_fields['admin_name'] = $name;
return $merge_fields;
}
add_hook("EmailPreSend",$relid,"add_admin_name_email");