]> git.mxchange.org Git - friendica.git/blobdiff - src/Model/User.php
Fix uddate issues and improve speed when displaying contact posts
[friendica.git] / src / Model / User.php
index 43e2c067fce2a4cd2669ab9062c203a1b349f03f..a1d3bc65f851faf8d0a8e2a1da878a46095dd05c 100644 (file)
@@ -37,11 +37,10 @@ use Friendica\Database\DBA;
 use Friendica\DI;
 use Friendica\Module;
 use Friendica\Network\HTTPClient\Client\HttpClientAccept;
-use Friendica\Network\HTTPException\InternalServerErrorException;
-use Friendica\Security\TwoFactor\Model\AppSpecificPassword;
 use Friendica\Network\HTTPException;
 use Friendica\Object\Image;
 use Friendica\Protocol\Delivery;
+use Friendica\Security\TwoFactor\Model\AppSpecificPassword;
 use Friendica\Util\Crypto;
 use Friendica\Util\DateTimeFormat;
 use Friendica\Util\Images;
@@ -128,7 +127,6 @@ class User
 
                        case 'community':
                                return User::ACCOUNT_TYPE_COMMUNITY;
-
                }
                return null;
        }
@@ -280,8 +278,7 @@ class User
                // List of possible actor names
                $possible_accounts = ['friendica', 'actor', 'system', 'internal'];
                foreach ($possible_accounts as $name) {
-                       if (!DBA::exists('user', ['nickname' => $name, 'account_removed' => false, 'account_expired' => false]) &&
-                               !DBA::exists('userd', ['username' => $name])) {
+                       if (!DBA::exists('user', ['nickname' => $name]) && !DBA::exists('userd', ['username' => $name])) {
                                DI::config()->set('system', 'actor_name', $name);
                                return $name;
                        }
@@ -326,7 +323,7 @@ class User
        public static function getByGuid(string $guid, array $fields = [], bool $active = true)
        {
                if ($active) {
-                       $cond = ['guid' => $guid, 'account_expired' => false, 'account_removed' => false];
+                       $cond = ['guid' => $guid, 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false];
                } else {
                        $cond = ['guid' => $guid];
                }
@@ -345,6 +342,35 @@ class User
                return DBA::selectFirst('user', $fields, ['nickname' => $nickname]);
        }
 
+       /**
+        * Set static settings for community user accounts
+        *
+        * @param integer $uid
+        * @return void
+        */
+       public static function setCommunityUserSettings(int $uid)
+       {
+               $user = self::getById($uid, ['account-type', 'page-flags']);
+               if ($user['account-type'] != User::ACCOUNT_TYPE_COMMUNITY) {
+                       return;
+               }
+
+               DI::pConfig()->set($uid, 'system', 'unlisted', true);
+
+               $fields = [
+                       'allow_cid'  => '',
+                       'allow_gid'  => $user['page-flags'] == User::PAGE_FLAGS_PRVGROUP ? '<' . Circle::FOLLOWERS . '>' : '',
+                       'deny_cid'   => '',
+                       'deny_gid'   => '',
+                       'blockwall'  => true,
+                       'blocktags'  => true,
+               ];
+
+               User::update($fields, $uid);
+
+               Profile::update(['hide-friends' => true], $uid);
+       }
+
        /**
         * Returns the user id of a given profile URL
         *
@@ -398,7 +424,7 @@ class User
         * @return array user
         * @throws Exception
         */
-       public static function getFirstAdmin(array $fields = []) : array
+       public static function getFirstAdmin(array $fields = []): array
        {
                if (!empty(DI::config()->get('config', 'admin_nickname'))) {
                        return self::getByNickname(DI::config()->get('config', 'admin_nickname'), $fields);
@@ -533,23 +559,88 @@ class User
                return $default_circle;
        }
 
-/**
- * Fetch the language code from the given user. If the code is invalid, return the system language
- *
- * @param integer $uid   User-Id
- * @param boolean $short If true, return the short form g.g. "en", otherwise the long form e.g. "en-gb"
- * @return string
- */
-       public static function getLanguageCode(int $uid, bool $short): string
+       /**
+        * Fetch the language code from the given user. If the code is invalid, return the system language
+        *
+        * @param integer $uid User-Id
+        * @return string
+        */
+       public static function getLanguageCode(int $uid): string
        {
-               $owner = self::getOwnerDataById($uid);
-               $languages = DI::l10n()->getAvailableLanguages($short);
-               if (in_array($owner['language'], array_keys($languages))) {
-                       $language = $owner['language'];
-               } else {
-                       $language = DI::config()->get('system', 'language');
+               $owner    = self::getOwnerDataById($uid);
+               $language = DI::l10n()->toISO6391($owner['language']);
+               if (in_array($language, array_keys(DI::l10n()->getLanguageCodes()))) {
+                       return $language;
+               }
+               return DI::l10n()->toISO6391(DI::config()->get('system', 'language'));
+       }
+
+       /**
+        * Fetch the wanted languages for a given user
+        *
+        * @param integer $uid
+        * @return array
+        */
+       public static function getWantedLanguages(int $uid): array
+       {
+               return DI::pConfig()->get($uid, 'channel', 'languages', [User::getLanguageCode($uid)]) ?? [];
+       }
+
+       /**
+        * Get a list of all languages that are used by the users
+        *
+        * @return array
+        */
+       public static function getLanguages(): array
+       {
+               $cachekey  = 'user:getLanguages';
+               $languages = DI::cache()->get($cachekey);
+               if (!is_null($languages)) {
+                       return $languages;
+               }
+
+               $supported = array_keys(DI::l10n()->getLanguageCodes());
+               $languages = [];
+               $uids      = [];
+
+               $condition = ["`verified` AND NOT `blocked` AND NOT `account_removed` AND NOT `account_expired` AND `uid` > ?", 0];
+
+               $abandon_days = intval(DI::config()->get('system', 'account_abandon_days'));
+               if (!empty($abandon_days)) {
+                       $condition = DBA::mergeConditions($condition, ["`last-activity` > ?", DateTimeFormat::utc('now - ' . $abandon_days . ' days')]);
                }
-               return $language;
+
+               $users = DBA::select('user', ['uid', 'language'], $condition);
+               while ($user = DBA::fetch($users)) {
+                       $uids[] = $user['uid'];
+                       $code = DI::l10n()->toISO6391($user['language']);
+                       if (!in_array($code, $supported)) {
+                               continue;
+                       }
+                       $languages[$code] = $code;
+               }
+               DBA::close($users);
+
+               $channels = DBA::select('pconfig', ['uid', 'v'], ["`cat` = ? AND `k` = ? AND `v` != ?", 'channel', 'languages', '']);
+               while ($channel = DBA::fetch($channels)) {
+                       if (!in_array($channel['uid'], $uids)) {
+                               continue;
+                       }
+                       $values = unserialize($channel['v']);
+                       if (!empty($values) && is_array($values)) {
+                               foreach ($values as $language) {
+                                       $language = DI::l10n()->toISO6391($language);
+                                       $languages[$language] = $language;
+                               }
+                       }
+               }
+               DBA::close($channels);
+
+               ksort($languages);
+               $languages = array_keys($languages);
+               DI::cache()->set($cachekey, $languages);
+
+               return $languages;
        }
 
        /**
@@ -703,7 +794,7 @@ class User
                                $fields = ['uid', 'nickname', 'password', 'legacy_password'];
                                $condition = [
                                        "(`email` = ? OR `username` = ? OR `nickname` = ?)
-                                       AND NOT `blocked` AND NOT `account_expired` AND NOT `account_removed` AND `verified`",
+                                       AND `verified` AND NOT `blocked` AND NOT `account_removed` AND NOT `account_expired`",
                                        $user_info, $user_info, $user_info
                                ];
                                $user = DBA::selectFirst('user', $fields, $condition);
@@ -739,7 +830,7 @@ class User
                if ($user['last-activity'] != $current_day) {
                        User::update(['last-activity' => $current_day], $uid);
                        // Set the last activity for all identities of the user
-                       DBA::update('user', ['last-activity' => $current_day], ['parent-uid' => $uid, 'account_removed' => false]);
+                       DBA::update('user', ['last-activity' => $current_day], ['parent-uid' => $uid, 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false]);
                }
        }
 
@@ -965,7 +1056,7 @@ class User
        public static function getAvatarUrl(array $user, string $size = ''): string
        {
                if (empty($user['nickname'])) {
-                       DI::logger()->warning('Missing user nickname key', ['trace' => System::callstack(20)]);
+                       DI::logger()->warning('Missing user nickname key');
                }
 
                $url = DI::baseUrl() . '/photo/';
@@ -1007,7 +1098,7 @@ class User
        public static function getBannerUrl(array $user): string
        {
                if (empty($user['nickname'])) {
-                       DI::logger()->warning('Missing user nickname key', ['trace' => System::callstack(20)]);
+                       DI::logger()->warning('Missing user nickname key');
                }
 
                $url = DI::baseUrl() . '/photo/banner/';
@@ -1134,7 +1225,7 @@ class User
                        throw new Exception(DI::l10n()->tt('Username should be at most %s character.', 'Username should be at most %s characters.', $username_max_length));
                }
 
-               // So now we are just looking for a space in the full name.
+               // So now we are just looking for a space in the display name.
                $loose_reg = DI::config()->get('system', 'no_regfullname');
                if (!$loose_reg) {
                        $username = mb_convert_case($username, MB_CASE_TITLE, 'UTF-8');
@@ -1454,7 +1545,7 @@ class User
                Photo::delete(['uid' => $register['uid']]);
 
                return DBA::delete('user', ['uid' => $register['uid']]) &&
-                      Register::deleteByHash($register['hash']);
+                       Register::deleteByHash($register['hash']);
        }
 
        /**
@@ -1504,10 +1595,9 @@ class User
                You may also wish to add some basic information to your default profile
                (on the "Profiles" page) so that other people can easily find you.
 
-               We recommend setting your full name, adding a profile photo,
-               adding some profile "keywords" (very useful in making new friends) - and
-               perhaps what country you live in; if you do not wish to be more specific
-               than that.
+               We recommend adding a profile photo, adding some profile "keywords" 
+               (very useful in making new friends) - and perhaps what country you live in; 
+               if you do not wish to be more specific than that.
 
                We fully respect your right to privacy, and none of these items are necessary.
                If you are new and do not know anybody here, they may help
@@ -1608,10 +1698,9 @@ class User
                        You may also wish to add some basic information to your default profile
                        ' . "\x28" . 'on the "Profiles" page' . "\x29" . ' so that other people can easily find you.
 
-                       We recommend setting your full name, adding a profile photo,
-                       adding some profile "keywords" ' . "\x28" . 'very useful in making new friends' . "\x29" . ' - and
-                       perhaps what country you live in; if you do not wish to be more specific
-                       than that.
+                       We recommend adding a profile photo, adding some profile "keywords" ' . "\x28" . 'very useful
+                       in making new friends' . "\x29" . ' - and perhaps what country you live in; if you do not wish
+                       to be more specific than that.
 
                        We fully respect your right to privacy, and none of these items are necessary.
                        If you are new and do not know anybody here, they may help
@@ -1640,16 +1729,24 @@ class User
         * @param int $uid user to remove
         * @return bool
         * @throws HTTPException\InternalServerErrorException
+        * @throws HTTPException\NotFoundException
         */
        public static function remove(int $uid): bool
        {
                if (empty($uid)) {
-                       return false;
+                       throw new \InvalidArgumentException('uid needs to be greater than 0');
                }
 
                Logger::notice('Removing user', ['user' => $uid]);
 
-               $user = DBA::selectFirst('user', [], ['uid' => $uid]);
+               $user = self::getById($uid);
+               if (!$user) {
+                       throw new HTTPException\NotFoundException('User not found with uid: ' . $uid);
+               }
+
+               if (DBA::exists('user', ['parent-uid' => $uid])) {
+                       throw new \RuntimeException(DI::l10n()->t("User with delegates can't be removed, please remove delegate users first"));
+               }
 
                Hook::callAll('remove_user', $user);
 
@@ -1704,7 +1801,7 @@ class User
 
                $identities = [];
 
-               $user = DBA::selectFirst('user', ['uid', 'nickname', 'username', 'parent-uid'], ['uid' => $uid]);
+               $user = DBA::selectFirst('user', ['uid', 'nickname', 'username', 'parent-uid'], ['uid' => $uid, 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false]);
                if (!DBA::isResult($user)) {
                        return $identities;
                }
@@ -1721,7 +1818,7 @@ class User
                        $r = DBA::select(
                                'user',
                                ['uid', 'username', 'nickname'],
-                               ['parent-uid' => $user['uid'], 'account_removed' => false]
+                               ['parent-uid' => $user['uid'], 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false]
                        );
                        if (DBA::isResult($r)) {
                                $identities = array_merge($identities, DBA::toArray($r));
@@ -1731,7 +1828,7 @@ class User
                        $r = DBA::select(
                                'user',
                                ['uid', 'username', 'nickname'],
-                               ['uid' => $user['parent-uid'], 'account_removed' => false]
+                               ['uid' => $user['parent-uid'], 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false]
                        );
                        if (DBA::isResult($r)) {
                                $identities = DBA::toArray($r);
@@ -1741,7 +1838,7 @@ class User
                        $r = DBA::select(
                                'user',
                                ['uid', 'username', 'nickname'],
-                               ['parent-uid' => $user['parent-uid'], 'account_removed' => false]
+                               ['parent-uid' => $user['parent-uid'], 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false]
                        );
                        if (DBA::isResult($r)) {
                                $identities = array_merge($identities, DBA::toArray($r));
@@ -1752,7 +1849,7 @@ class User
                        "SELECT `user`.`uid`, `user`.`username`, `user`.`nickname`
                        FROM `manage`
                        INNER JOIN `user` ON `manage`.`mid` = `user`.`uid`
-                       WHERE `user`.`account_removed` = 0 AND `manage`.`uid` = ?",
+                       WHERE NOT `user`.`account_removed` AND `manage`.`uid` = ?",
                        $user['uid']
                );
                if (DBA::isResult($r)) {
@@ -1774,7 +1871,7 @@ class User
                        return false;
                }
 
-               $user = DBA::selectFirst('user', ['parent-uid'], ['uid' => $uid, 'account_removed' => false]);
+               $user = DBA::selectFirst('user', ['parent-uid'], ['uid' => $uid, 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false]);
                if (!DBA::isResult($user)) {
                        return false;
                }
@@ -1783,7 +1880,7 @@ class User
                        return true;
                }
 
-               if (DBA::exists('user', ['parent-uid' => $uid, 'account_removed' => false])) {
+               if (DBA::exists('user', ['parent-uid' => $uid, 'verified' => true, 'blocked' => false, 'account_removed' => false, 'account_expired' => false])) {
                        return true;
                }