fix(api): don't send @everyone in route response ...

The response of `PATCH /guilds/{guild.id}/members/{user.id}` should not include "@everyone" role

fix(api): prevent @everyone role duplication ...

If user already has @everyone role, then don't push it to the array

fix(api): always add @everyone in user's roles ...

When you add or delete an user's role, you MUST always add "@everyone" role to the roles map

refactor(gateway): delete hardcoded guild boosts ...

Since you can set `premium_subscription_count` and `premium_tier` by editing the database (and it works fine), this should not be hardcoded.

Fix bans list (#674) ...

* Fix bans list

- Bans list should load properly now

* Updated

Removed await
Removed unnecessary foreach

* Update ban.ts

await

Revert "Type change" ...

This reverts commit de8b83f.

Type change ...

Changed type for column "content" to "longtext"

(you might want to get a back up from your database before updating)

Check username

[Fix] Changing bio and accent color

Fixed npm run tsnode throwing error about ES modules for node-fetch. Probably was api package.json still included node-fetch 3, but bundle still had v2

Tsnode support (#580) ...

* ts-node support. debugging is slightly wonky as vscode will not allow breakpoints in modules that aren't bundle, yet.

* apparently ts-node compilerOptions.path wasn't needed? on windows I could've sworn it was.

* Cleaned up tsconfig.json a bit ( moved tsnode config to own file ).
Fixed breakpoints for all modules under tsnode

* Removed Microsoft Corp advert
* Remove one more Microsoft Corp. ad

Signed-off-by: Erkin Alp Güney <erkinalp9035@gmail.com>

* Added `tsnode` npm script

* Added `typescript-cached-transpile` package to help improve performance

Co-authored-by: Erkin Alp Güney <erkinalp9035@gmail.com>

document which field is which

Initial work on public read receipts ...

Progress on #416

Add nan to dependencies ...

sqlite requires it, setup not going through without it, and manual install isn't working. does work when adding to dependencies tho.

Merge pull request #656 from fosscord/dependabot/npm_and_yarn/bundle/url-parse-1.5.10 ...

Bump url-parse from 1.5.7 to 1.5.10 in /bundle

Bump url-parse from 1.5.7 to 1.5.10 in /bundle ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.7 to 1.5.10.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.7...1.5.10)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #655 from fosscord/dependabot/npm_and_yarn/util/url-parse-1.5.10 ...

Bump url-parse from 1.5.7 to 1.5.10 in /util

Merge pull request #654 from fosscord/dependabot/npm_and_yarn/gateway/url-parse-1.5.10 ...

Bump url-parse from 1.5.7 to 1.5.10 in /gateway

Bump url-parse from 1.5.7 to 1.5.10 in /util ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.7 to 1.5.10.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.7...1.5.10)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

Bump url-parse from 1.5.7 to 1.5.10 in /gateway ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.7 to 1.5.10.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.7...1.5.10)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #653 from fosscord/dependabot/npm_and_yarn/api/url-parse-1.5.10 ...

Bump url-parse from 1.5.7 to 1.5.10 in /api

Bump url-parse from 1.5.7 to 1.5.10 in /api ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.7 to 1.5.10.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.7...1.5.10)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

Merge pull request #621 from fosscord/origin/dev/erkinalp/self-bans ...

Allow self-banning

[Fix] Profile & banner uploading ...

Related to this issue https://github.com/fosscord/fosscord-server/pull/639#issuecomment-1046140968

Bump url-parse from 1.5.3 to 1.5.7 in /bundle ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.3 to 1.5.7.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.3...1.5.7)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

Bump url-parse from 1.5.3 to 1.5.7 in /gateway ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.3 to 1.5.7.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.3...1.5.7)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

Bump url-parse from 1.5.3 to 1.5.7 in /util ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.3 to 1.5.7.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.3...1.5.7)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

Bump url-parse from 1.5.3 to 1.5.7 in /api ...

Bumps [url-parse](https://github.com/unshiftio/url-parse) from 1.5.3 to 1.5.7.
- [Release notes](https://github.com/unshiftio/url-parse/releases)
- [Commits](https://github.com/unshiftio/url-parse/compare/1.5.3...1.5.7)

---
updated-dependencies:
- dependency-name: url-parse
  dependency-type: indirect
...

Signed-off-by: dependabot[bot] <support@github.com>

changed user.premium_since to also load from the database.

Forgot the openapi.json change.