public static function handleDeletedUsers() { global $ilDB; $query = 'SELECT DISTINCT(vuid) FROM rep_robj_xvit_umap ' . 'LEFT JOIN usr_data ON iuid = usr_id ' . 'WHERE usr_id IS NULL ' . 'GROUP BY vuid '; $res = $ilDB->query($query); while ($row = $res->fetchRow(DB_FETCHMODE_OBJECT)) { try { $user_service = new ilViteroUserSoapConnector(); $user_service->deleteUser($row->vuid); } catch (ilViteroConnectorException $e) { } $umap = new ilViteroUserMapping(); $umap->deleteByViteroUserId($row->vuid); } }