Method getUserFileInfo

public static function getUserFileInfo($file, $userId)
{
    $db = Factory::getDBO();
    $allFile['size'] = 0;
    $allFile['count'] = 0;
    $query = 'SELECT SUM(a.filesize) AS sumfiles, COUNT(a.id) AS countfiles' . ' FROM #__phocadownload AS a' . ' WHERE a.owner_id = ' . (int) $userId;
    $db->setQuery($query, 0, 1);
    $fileData = $db->loadObject();
    if (isset($fileData->sumfiles) && (int) $fileData->sumfiles > 0) {
        $allFile['size'] = (int) $allFile['size'] + (int) $fileData->sumfiles;
    }
    if (isset($file['size'])) {
        $allFile['size'] = (int) $allFile['size'] + (int) $file['size'];
        $allFile['count'] = (int) $fileData->countfiles + 1;
    }
    return $allFile;
}