This peace of code in remoting lib returns only active MySQL databases. If database marked as inactive API call returns zero: PHP: /** * Get all databases by user * @author Julio Montoya <[email protected]> BeezNest 2010 */ public function sites_database_get_all_by_user($session_id, $client_id) { global $app; if(!$this->checkPerm($session_id, 'sites_database_get')) { throw new SoapFault('permission_denied', 'You do not have the permissions to access this function.'); return false; } $client_id = $app->functions->intval($client_id); $sql = "SELECT d.database_id, d.database_name, d.database_user_id, d.database_ro_user_id, du.database_user, du.database_password FROM web_database d LEFT JOIN web_database_user du ON (du.database_user_id = d.database_user_id) INNER JOIN sys_user s on(d.sys_groupid = s.default_group) WHERE client_id = ?"; $all = $app->db->queryAllRecords($sql, $client_id); return $all; } I don't see WHERE clause which could indicate search by status... Am I missing something?
Use the sites_database_get function instead. You can pass as primary_id an array with the values you like to search for. I explained that in your other thread in February here: https://forum.howtoforge.com/threads/sys_-values-in-db.91838/