#
$num = (int) $db->executeGetOne('SELECT COUNT(*) FROM `users` WHERE `id`=' . $user_id);
if ($num < 1) {
$user_id = 0;
}
if ($user_id < 1) {
# something bad happened, nobody (not even a nobody user) is logged
# in at that phone. assign the default nobody user of the phone:
$user_id = @gs_prov_assign_default_nobody($db, $mac, null);
if ($user_id < 1) {
_settings_err('Failed to assign nobody account to phone ' . $mac);
}
}
# get host for user
#
$host = @gs_prov_get_host_for_user_id($db, $user_id);
if (!$host) {
_settings_err('Failed to find host.');
}
$pbx = $host;
# $host might be changed if SBC configured
# who is logged in at that phone?
#
$user = @gs_prov_get_user_info($db, $user_id);
if (!is_array($user)) {
_settings_err('DB error.');
}
# store the current firmware version in the database:
#
@$db->execute('UPDATE `phones` SET ' . '`firmware_cur`=\'' . $db->escape($fw_vers_nrml) . '\' ' . 'WHERE `mac_addr`=\'' . $db->escape($mac) . '\'');
# firmware update
#
$user = @gs_prov_get_user_info($db, $user['id']);
if (!is_array($users[$i])) {
_settings_err('DB error.');
}
$user['id'] = $users[$i]['id'];
$users[$i]['name'] = $user['name'];
$users[$i]['mailbox'] = $user['mailbox'];
$users[$i]['secret'] = $user['secret'];
$users[$i]['nobody_index'] = $user['nobody_index'];
$users[$i]['user'] = $user['user'];
$users[$i]['firstname'] = $user['firstname'];
$users[$i]['lastname'] = $user['lastname'];
# get host for user
#
$users[$i]['host'] = @gs_prov_get_host_for_user_id($db, $user['id']);
if (!$users[$i]['host']) {
_settings_err('Failed to find host.');
}
$pbx = $users[$i]['host'];
# $host might be changed if SBC configured
# store the current firmware version in the database:
#
@$db->execute('UPDATE `phones` SET ' . '`firmware_cur`=\'' . $db->escape($fw_vers_nrml) . '\' ' . 'WHERE `mac_addr`=\'' . $db->escape($mac_addr) . '\'');
# store the user's current IP address in the database:
#
@$db->execute('UPDATE `users` SET ' . '`current_ip`=\'' . $db->escape($requester['phone_ip']) . '\' ' . 'WHERE `id`=\'' . (int) $user['id'] . '\'');
# get SIP proxy to be set as the phone's outbound proxy
#
$sip_proxy_and_sbc = gs_prov_get_wan_outbound_proxy($db, $requester['phone_ip'], $user['id']);
if ($sip_proxy_and_sbc['sip_server_from_wan'] != '') {
