query("SELECT userrole, username, wss_server, web_socket_port, server_path, profile_name, sip_username, sip_password, stun_server, audio_output_id, video_src_id, video_height, frame_rate, aspect_ratio, video_orientation, audio_src_id, auto_gain_control, echo_cancellation, noise_suppression, ring_output_id, video_conf_extension, video_conf_window_width, profile_picture, notifications, use_roundcube, rcdomain, rcbasicauthuser, rcbasicauthpass, rcuser, rcpassword, enabled FROM app_users WHERE BINARY username = '$username' AND enabled = 1"); $confdatafromdb = $querysel->fetch_assoc(); // Replace the SIP password, Roundcube password (if any) and Roundcube basic auth password (if any) with placeholders $psswdaddedkey = file_get_contents('restr/'.$username.'/pwdkey'); if ($confdatafromdb['sip_password'] != '' && $confdatafromdb['sip_password'] != null && $confdatafromdb['sip_password'] != 'undefined') { $confdatafromdb['sip_password'] = "%20%20%20%20%20%20%20"; } else { $confdatafromdb['sip_password'] = ''; } if ($confdatafromdb['rcbasicauthpass'] != '' && $confdatafromdb['rcbasicauthpass'] != null && $confdatafromdb['rcbasicauthpass'] != 'undefined') { $confdatafromdb['rcbasicauthpass'] = "%20%20%20%20%20%20%20"; } else { $confdatafromdb['rcbasicauthpass'] = ''; } if ($confdatafromdb['rcpassword'] != '' && $confdatafromdb['rcpassword'] != null && $confdatafromdb['rcpassword'] != 'undefined') { $confdatafromdb['rcpassword'] = "%20%20%20%20%20%20%20"; } else { $confdatafromdb['rcpassword'] = ''; } $datafromdb = $confdatafromdb; echo json_encode($datafromdb); } else { header("Location: roundpin-login.php"); } ?>