spacebarchat/server-ts.git/src/api, branch dev/admin-apiSpacebar Server, written with love in TypeScript and C#
http://cgit.rory.gay/spacebarchat/server-ts.git/atom?h=dev%2Fadmin-api2025-10-05T19:34:40ZLocal changes2025-10-05T19:34:40ZEmma [it/its]@Rory&root@rory.gay2025-04-08T16:55:55Zurn:sha1:abb1b570a4343d5e4fde34f55c1a2bf403f62981Fix import2025-10-04T19:55:23ZRory&root@rory.gay2025-10-04T19:55:23Zurn:sha1:a4e40102116c2e4a2a42172a494822c7d594f750Templates, maybe?2025-10-04T19:52:18ZRory&root@rory.gay2025-10-04T19:52:18Zurn:sha1:95b08ac51ccb6fbc300ef7445ad367c21b332eafAdd sticker limit2025-10-04T19:25:39ZRory&root@rory.gay2025-10-04T19:25:39Zurn:sha1:021a38767959a996231a3b6fa03c0261fea7bf4aUnkown -> unkown (typo fix)2025-10-04T17:09:26ZRory&root@rory.gay2025-10-03T18:53:24Zurn:sha1:625df4e31412f7e105aa462e86dfc104872cd532Clean up array extensions2025-10-04T17:09:26ZRory&root@rory.gay2025-10-03T18:50:48Zurn:sha1:a25393e80683dbb1d2b9e305af624aa3752050d6Add dotnet-ish Random class2025-10-04T17:09:25ZRory&root@rory.gay2025-10-03T18:29:32Zurn:sha1:7d2fd7b4f8d5ab7e27bfbea6a4498edbbaf7df9cDrop dependency on missing-native-js-functions2025-10-04T17:09:25ZRory&root@rory.gay2025-10-03T18:28:25Zurn:sha1:b681ae7522029433c3df8caa6a08017012932c97Move reporting menu to todo2025-10-04T17:09:25ZRory&root@rory.gay2025-10-03T17:18:39Zurn:sha1:88e043fad8ef89deee5567d56d9491721506d18aFix ignored request schemas2025-10-04T17:09:25ZRory&root@rory.gay2025-10-02T17:29:49Zurn:sha1:efba3f245dc9694187ee5143410ce1fb18cd7302fix: getting invites for a channel2025-10-02T16:55:47ZCyberL1cyber.hf18@gmail.com2025-10-02T13:39:18Zurn:sha1:9ef9744332ccc4de597ec98e75f0109ab4cc893cLog schema name on error2025-10-01T18:37:42ZRory&root@rory.gay2025-10-01T18:37:42Zurn:sha1:c6d763a905b163ea5c9244fbd483a3aaa233444bSafety hub work2025-10-01T18:17:14ZRory&root@rory.gay2025-10-01T18:17:14Zurn:sha1:c232d5c82ea2bd0bc4e2f86a053e77cf01a9092fImplement fetching mutual friends2025-09-30T17:24:10ZRory&root@rory.gay2025-09-30T17:24:10Zurn:sha1:6a3155adba66dda664d75ae4dbef2adcfcc4145dPass mergeParams: true to new router calls due to express behavior change2025-09-30T05:14:10ZRory&root@rory.gay2025-09-30T05:14:10Zurn:sha1:d647f882b179bdaba8311717563d83fddc52a3ddClean up unused imports2025-09-30T03:13:29ZRory&root@rory.gay2025-09-30T03:13:29Zurn:sha1:b87d28c2c94371fabf620b713b136baed9dec185Silence, dotenv, we dont want your ads2025-09-29T20:18:38ZRory&root@rory.gay2025-09-29T20:11:08Zurn:sha1:0e495bc31d475bfb56ddac5db226a0302bd4a1e2Drop @sentry/node (Sentry support) - untested and unused2025-09-29T20:08:03ZRory&root@rory.gay2025-09-29T19:28:06Zurn:sha1:0c3d8a792f9f17f2f28ad449cd8bc5c2a381c8d5No error when message not found2025-09-29T16:38:06ZRory&root@rory.gay2025-09-29T01:13:05Zurn:sha1:54b8351e7cb3efa9ebf3c045bc3731c99e59b3f7Also filter expired invites when returning invite list2025-09-29T16:38:06ZRory&root@rory.gay2025-09-29T00:40:09Zurn:sha1:46ad97d409ce00a2197db2ff79ba57725fc4f1aaDelete expired invites2025-09-29T16:38:06ZRory&root@rory.gay2025-09-29T00:38:35Zurn:sha1:ba612ab2ba50250bb62a3c9ee13e686e62d3cbeeAdd fetching guild profiles2025-09-29T16:38:06ZRory&root@rory.gay2025-09-29T00:19:20Zurn:sha1:2620a5551803734c6f498dfd00b6539e60e52bcfMaybe this tie2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T22:02:28Zurn:sha1:697b599eb51fcdb3f542c0323b891bed0d6e3d65Include attachments2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T21:57:29Zurn:sha1:61c3b537ad1a51d6d73fb045bcd7f82419dbaea2Polyfill referenced message2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T21:52:36Zurn:sha1:364a98f71abc7af99115f6778d427d67759acc31More relations2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T21:47:32Zurn:sha1:b6cfb32d5af5c7de1d61e6885ae9ea13c4c5fc5cAdd author and mentions relation to fetching messages2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T21:44:00Zurn:sha1:2f1b131b0f70bc923955261c57986e47d10627b2Actually set the referenced_message relation on new messages2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T21:36:26Zurn:sha1:871880996bb1ce98e2018c1a124da0bd4af81baeInclude referenced_message relation on GET /channel/.../messages2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T21:27:18Zurn:sha1:ba5117c00329d9d288df4329821ed989aa10e038Null coalescing for file id2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T18:36:07Zurn:sha1:f8e4e8864f48dff5852af45e32c78adbdf9b07caUse default ID on file upload requests2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T18:32:34Zurn:sha1:d59bd1050be9337ac6391ac7126f3abf6bbd7175Make cloud uploads work2025-09-29T16:38:06ZRory&root@rory.gay2025-09-28T18:09:38Zurn:sha1:f20dff80eff002d39a662eedb538a486ec6be76bLogging of empty messages2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T22:03:03Zurn:sha1:d007acc64e464deafda2d86a89c5a6ff469823e5meow???2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T21:58:21Zurn:sha1:c3fa8d3b1f6b4783a35ed840bf0ecadb838b8758Log validation errors2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T21:45:27Zurn:sha1:d166c9a69a156e4cb13b9d4807d8c21a6c4176d2Try to handle new attachment style in message handler2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T21:36:55Zurn:sha1:3bba7882fa153915a2b25c1bed267693f65fbb1aUpdate message schema to handle cloud attachments2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T21:25:08Zurn:sha1:db765d8ff0423ec9eea9b624973895569ddff558Implment deleting cloud attachments2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T20:48:14Zurn:sha1:19ca94fc329dd3dcf80e0345167491ffb2644a9aFix upload filename2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T19:12:27Zurn:sha1:2a10b3528fd369e2e9c5aa2385ba2a39c06e1585Add first half of cloud attachment uploads2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T19:05:35Zurn:sha1:1e6ed06da142e4aa558cf1ada38204d4adf55c92Fix schema for preload messages2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T17:06:48Zurn:sha1:3720068b83a868dbf98f2566a53c5832d42654e4Implement greeting2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T17:05:39Zurn:sha1:b6065145eed7c204bf2c04b1e01aab346f72ed8eImplement fetching DM messages by user ID2025-09-29T16:38:06ZRory&root@rory.gay2025-09-23T15:17:42Zurn:sha1:0db40d7a0a104085e6c6aa88deea12bcb80c7791Implement message preloading2025-09-29T16:38:06ZRory&root@rory.gay2025-09-22T13:43:13Zurn:sha1:f78a9412b888a1e9429620bff1f50d922d4d7bb2Permissions: less magic numbers2025-09-29T16:38:06ZRory&root@rory.gay2025-09-11T11:03:54Zurn:sha1:a8f8af92d37d82d2ae3897ba4c0c8da008e9d256Add endpoint implementations2025-09-29T16:38:06ZRory&root@rory.gay2025-07-14T16:34:32Zurn:sha1:387722d017fe51335020f40852e8f2c708064bf6Screw off, telemetry2025-09-29T16:38:06ZRory&root@rory.gay2025-07-13T22:31:00Zurn:sha1:8b946ac41dd617201552b248e5cb8dd3f92b52e6Colorful roles2025-09-29T16:38:06ZRory&root@rory.gay2025-07-12T18:12:37Zurn:sha1:528662446c3377032190c117f5a3fe2fa8f3b88eDo settings versioning2025-09-29T16:38:06ZRory&root@rory.gay2025-07-11T13:47:29Zurn:sha1:18e752a457eb178f35c37dd5e0d8b8e7a53e4cbeOops, actually send the events to a user...2025-09-29T16:38:06ZRory&root@rory.gay2025-07-11T12:03:06Zurn:sha1:b212cbbea1259e47d4cf9db107cacdb4e35e4e1cEmit USER_SETTINGS_PROTO_UPDATE2025-09-29T16:38:06ZRory&root@rory.gay2025-07-11T11:59:53Zurn:sha1:5466de1c02447333f4cdfe09235b7bd08e548729Merge in json representation of settings protos2025-09-29T16:38:06ZRory&root@rory.gay2025-07-11T11:38:28Zurn:sha1:b62fc8aca85454ce68d2e8923da9e17181dd4cc6Release -> ClientRelease2025-09-29T16:38:06ZRory&root@rory.gay2025-07-11T11:20:29Zurn:sha1:93ef08320e9e4b1ddd727944194ecb625b73288fSetting protos support2025-09-29T16:38:06ZRory&root@rory.gay2025-07-11T10:55:38Zurn:sha1:5e3080d72fe5a388c53698c732b855b98ca92d6eUpdate copyright date in pin endpoints2025-09-29T16:38:06ZRory&root@rory.gay2025-07-09T14:49:56Zurn:sha1:09147ae51c76a8806260c9a8512a602a4fdc3aeefix: don't set order for counting queries2025-09-29T16:32:21ZCyberL1cyber.hf18@gmail.com2025-09-29T08:20:15Zurn:sha1:3e93ad8a879454cfa56b5c9791c345af4f58cea6fix: set DESC order2025-09-29T16:32:21ZCyberL1cyber.hf18@gmail.com2025-09-29T08:17:42Zurn:sha1:6bf4109465311dc04b2aa50f38dbd79e83e820d9refactor: don't use query builder2025-09-29T16:32:21ZCyberL1cyber.hf18@gmail.com2025-09-29T05:44:25Zurn:sha1:8e18a642fe6673a7d8adc24ed17cb0d6e3aa64cerefactor: don't use query builder2025-09-29T16:32:21ZCyberL1cyber.hf18@gmail.com2025-09-29T05:40:26Zurn:sha1:29c4a6695c1061200b79da5871e617eda2de47e4refactor: add `pinned` getter to `Message` entity2025-09-29T16:32:21ZCyberL1cyber.hf18@gmail.com2025-07-15T06:08:39Zurn:sha1:5c332ae763c1a5fdd1c0edcc7b379d59edc9dfbfrefactor: use `pinned_at` to check if message is pinnned2025-09-29T16:32:21ZCyberL1cyber.hf18@gmail.com2025-07-13T08:56:30Zurn:sha1:dc3a85f078e3c4242d22612e51c3729b11624c69fix: getting message pinss2025-09-29T16:32:21ZCyberL1cyber.hf18@gmail.com2025-07-13T05:30:17Zurn:sha1:b8b461f0dba77eb0714fa8af3d33c92e376fdc0ffix stupid bug2025-09-28T22:08:23ZMathMan05mathmanrm@gmail.com2025-09-19T20:19:52Zurn:sha1:b461da9b8f70a22769f89d5aab8e0550934f20e4prevent re-verifying email2025-09-05T22:35:50ZPuyodead1puyodead@proton.me2025-09-05T22:35:50Zurn:sha1:6ff8eec72269658d58642194e6d15c5b3c6be713fixes and minor changes for email stuff2025-09-05T22:03:59ZPuyodead1puyodead@proton.me2025-09-05T22:03:59Zurn:sha1:b8b9b038cfc11f10ec6070679dca22b066d3a2c9fix an issue with NO_AUTHENTICATE routes2025-09-05T21:47:42ZPuyodead1puyodead@proton.me2025-09-05T21:47:42Zurn:sha1:5fafb6d156c539f6a99c0f4f8ce1f9c2820efe53More cleanup2025-07-27T13:49:37ZRory&root@rory.gay2025-07-27T13:42:54Zurn:sha1:9d314cd995d68f0e4d05219e750959d344f674f8WIP logo/terminal stuff2025-07-27T13:49:37ZEmma [it/its]@Rory&root@rory.gay2024-10-27T22:30:14Zurn:sha1:bd81cde9770e3d7c93b7b42f866b355c8b8bcbefImplement CRUD for automod2025-07-27T13:49:37ZEmma [it/its]@Rory&root@rory.gay2024-10-15T09:10:58Zurn:sha1:3f7d26118dd75f83390ecfed0c0d6397cf542093add types to the ban api response objects2025-07-21T21:05:14Zdank074torresefrain10@gmail.com2025-07-21T21:05:14Zurn:sha1:7261766459b266bb303e60af8e99ebf5d520e54bupdate guild bans api2025-07-21T05:46:14Zdank074torresefrain10@gmail.com2025-07-21T05:46:14Zurn:sha1:3c0efd17bcb2ef45c9990278fa0323db46b72aa6Merge pull request #1305 from ZaneH/feat/handle-github-webhook2025-07-12T16:56:00ZPuyodead1puyodead@proton.me2025-07-12T16:56:00Zurn:sha1:9347a3ec6f1f4373149a8e9d6bc6b3a6d481dbc8
Implement GitHub-compatible webhookModern pins endpoints2025-07-08T20:45:57ZRory&root@rory.gay2025-07-08T20:45:57Zurn:sha1:d58414c9c5a79992a33692f6b412357a2ba7b60dAdd emoji source endpoint2025-07-07T19:59:25ZRory&root@rory.gay2025-07-07T19:59:25Zurn:sha1:cb0443821ef8da4b44ee2f4fb677854896287705Add endpoint to get account standing2025-07-07T18:40:38ZRory&root@rory.gay2025-07-07T18:40:38Zurn:sha1:5205ccecd5d245d5d0c67c28339cf3e84c7a5fdePrettier2025-07-06T16:03:17ZRory&root@rory.gay2025-07-06T09:08:51Zurn:sha1:b590482bfbed461c47e785e1bf59d16e211c6982Fix forgotten function signature changes2025-07-06T16:03:17ZRory&root@rory.gay2025-07-06T09:02:18Zurn:sha1:9e4a769d6937bf7a4002f118309537f9c820c3f6Make IP/user-agent validation in CDN work2025-07-06T16:03:17ZRory&root@rory.gay2025-07-04T07:10:42Zurn:sha1:2e196573ea1e257fc9266d6c63289c51fbaa4e12sign attachment on sending message2025-07-06T16:03:17ZEmma [it/its]@Rory&root@rory.gay2025-07-03T07:29:25Zurn:sha1:0fcdbd28317d470a86f82b77e708a343eae473f7Sign media per user2025-07-06T16:03:17ZEmma [it/its]@Rory&root@rory.gay2025-07-03T07:25:04Zurn:sha1:387cef269a28791ee0a721b4df7084aaf4445f39Add options to erquire IP or User Agent to access CDN2025-07-06T16:03:17ZEmma [it/its]@Rory&root@rory.gay2025-07-02T14:40:25Zurn:sha1:0e0da6d722f656c9d994e51543edc08940e06740Fix typeorm queries no longer allowing empty where clauses2025-07-06T07:18:22ZEmma [it/its]@Rory&root@rory.gay2025-07-02T15:36:46Zurn:sha1:3e549dae28fc89d93a657be6498fb2900d079fadUpdate some dependencies, fix nix2025-07-02T13:54:23ZEmma [it/its]@Rory&root@rory.gay2025-07-02T13:54:23Zurn:sha1:fca7953a514f278f1ac4547602a2f328e8b5831dFix the fix2025-07-01T23:21:24ZMathMan0573901602+MathMan05@users.noreply.github.com2024-08-26T04:13:14Zurn:sha1:6ab26cb3ffb9c40a203fa5f1f829b151b1847400
this should actually be what's intendedCheck for old password when setting new2025-07-01T23:21:24ZMathMan0573901602+MathMan05@users.noreply.github.com2024-08-26T03:56:55Zurn:sha1:76857bdcfb0057e3b512f2e91833b596d828e46a
Checks for passwordProxy avatar URL + adjust event logic2025-06-29T16:17:24ZZane Heltonzane99@me.com2025-06-29T16:17:24Zurn:sha1:ed85ba3dc245fcd17e8d1dadbad4bc5f57276936
I've proxied the URLs with `getProxyUrl` specifying the size as 80x80.
I've also adjusted the event logic so that unstarring doesn't trigger an
alert and I've disabled the 'watch' event because Discord doesn't use
it either.
Make tsc happy when using strings as Date in embed2025-06-29T15:34:57ZZane Heltonzane99@me.com2025-06-29T15:34:57Zurn:sha1:590331518ce6f742773de4d90edaf5cd8dca8dc9
Validation on embeds has interesting behavior. Embeds have a `timestamp`
property that is of type `Date`. However when providing a Date,
`WebhookExecuteSchema` silently ends the operation.
The resolution was to use strings and to annotate them with `//
@ts-expect-error`. This was not my first choice, but it was the best
option I saw.
The other option is to allow `Embeds` to pass strings as a timestamp but
I'd want a second opinion before making that change.
Refactor `/github` endpoint into it's own file2025-06-29T14:46:16ZZane Heltonzane99@me.com2025-06-29T14:21:29Zurn:sha1:9143c1d408f65157a10d7b76794d74bb9d1c9657Capitalize `ref_type` when using in embed2025-06-29T07:56:01ZZane Heltonzane99@me.com2025-06-29T07:56:01Zurn:sha1:82642d0e97d23787417a337786f450330f570da6
The GitHub API provides `ref_type` as lowercase. For consistency, this
adds a utility function and makes use of it when formatting the `create`
event from GitHub.
tag => Tag
branch => Branch
Implement webhook handler for GitHub2025-06-29T07:18:43ZZane Heltonzane99@me.com2025-06-29T07:18:43Zurn:sha1:77dd48174206b0116dce011bff98d526b711eedc
I've created a middleware that runs when `/github` is appended to the
webhook URL. The middleware parses the GitHub webhook and turns it into
usable embeds.
Fix the creation of guilds from templates2025-06-29T03:27:14ZZane Heltonzane99@me.com2025-06-29T02:09:56Zurn:sha1:33fde3bc4a338dccd8707a7712763535862aa037
The biggest hold-up was missing fields (`premium_tier`,
`welcome_screen`, etc.) but it looks like someone has provided a
helpful function called `createGuild(...)` to provide sensible default
values.
This commit fixes the errors related to creating a guild from a
template. I've also refactored the code to include roles and channels in
the template.
To make sure that the @everyone role is cloned correctly, when
creating the guild from a template, we check if the role's ID
matches the template's `source_guild_id`. If it does, we set the
@everyone role to the new guild's ID.
Set `premium_tier` to 0 when creating guild from template2025-06-29T03:27:14ZZane Heltonzane99@me.com2025-06-28T22:10:38Zurn:sha1:eec2a8ba8584e1b3121e9b2fda05dc98c77ddf25
I think we'll need to discuss the proper way to provide default values
here. `premium_tier` for example should never be provided from the
template so it's fine going after the spread operator.
This commit still doesn't allow guilds to be created from template
because the next error is that `welcome_screen` doesn't exist. Our
options:
1. Provide default values in the ORM
2. Provide default values in the guild creation process
3. Throw an error if the template is missing values
Resolves: #1283 but creates a new issue
Await guild creation to fix a race condition2025-06-29T03:27:14ZZane Heltonzane99@me.com2025-06-28T22:02:54Zurn:sha1:ff692c19b77a7dcae07dcb71f33c4753db106f5d
`Promise.all(...)` runs these simultaneously, yet role depends on the
guild to be created first. This can lead to a race condition. I've
awaited role creation too because the call to `Member.addToGuild(...)`
relies on the role to be created.
Fix PATCH Template route implementation2025-06-29T03:25:22ZZane Heltonzane99@me.com2025-06-29T02:56:15Zurn:sha1:4772731a17c309c3e5af5173f9c928e65c4728cc
The previous PATCH implementation was creating a new template rather
than editing the existing template. This resulted in all requests
failing because it was missing more than one required field.
Resolves: #1281
Add OP to message.mentions when replied to2025-06-28T23:14:58ZZane Heltonzane99@me.com2025-06-28T23:01:49Zurn:sha1:4f7591965125d7c3289b81ff8bba6ba91512af3f
The `message.message_reference` stores:
1. `message_id`
2. `channel_id`
3. `guild_id`
We use the `message_id` and `channel_id` to `.findOne(...)` Message, and
find the author. If the author is the same as OP, we skip (so replying
to yourself doesn't add you to the mentions array) otherwise, it adds
the author_id to the mentions array.
Resolves: #1247
Preserve reactions when a message is edited2025-06-28T22:44:47ZZane Heltonzane99@me.com2025-06-28T13:57:34Zurn:sha1:e8d3f655a399a8ac5870e0d2612e2e23d87ae6b3
Resolves #1241
Properly filter existing embed links2025-06-28T22:39:42ZZane Heltonzane99@me.com2025-06-28T14:55:56Zurn:sha1:81d431363113d9a21ec252b016ff41210833e97c
In a previous PR, I was checking if the `.url` property existed, the
correct fix is to remove any embed that isn't a rich embed
type (non-link).
See also: #1296
Start fresh when updating embeds for links2025-06-28T08:30:52ZZane Heltonzane99@me.com2025-06-28T07:17:09Zurn:sha1:184433b0781dbbf40c150d598336545ae5fa5720
In a previous commit I was attempting to be clever by only
replacing/removing embeds if necessary. This not only made the logic
more confusing but introduced a bug that would allow for orphaned
embeds when updating the search params of a URL.
This commit will remove all embeds that have a `.url` property and start
fresh. This simplifies the code and eliminates the aforementioned bug.
Fix various issues with embeds on message updates2025-06-28T08:30:52ZZane Heltonzane99@me.com2025-06-28T05:38:46Zurn:sha1:f9cfb46e73b2e51d0c48fe509594bc3338ed65ac
The `postHandleMessage` function is parsing links and adding them to the
EmbedCache table if necessary. In the previous implementation, message
updates would push to the embeds unconditionally.
This commit parses links from the message and:
1. Normalizes the URLs
- Useful for deduplicating similar URLs
2. Remove embeds with matching normalized URLs
- Leaves all embeds except for ones with a `.url` property matching
the updated message
- This allows embeds to be re-ordered if the URL is moved
3. If no normalized URLs are found, remove all embeds
4. Take the deduplicated + normalized URLs and add an embed to the message and
insert into the EmbedCache table (if necessary)
This enables:
1. Embeds to be re-ordered by re-ordering links
2. Embeds to be removed by removing links
and fixes:
1. Duplicate embeds being attached to a message when edited
Add validation to date_of_birth registration field2025-06-28T07:08:00ZZane Heltonzane99@me.com2025-06-28T02:23:10Zurn:sha1:c0f9c22e67f33e9b12eca33432c4a2a849e0c20e
Resolves: #1020