stlmpp/biomercs-api

Angular x NestJS ❤️

Atualmente estudando Dart, Flutter e Sveltekit

Contato

biomercs-api's Issues

Add end-point to return rejected and pending scores

related issue: stLmpp/biomercs#5

Do not expose the entity model, create a ViewModel

• Platform (e627076)
• Game (54d38a1)
• Mini game (2091146)
• Mode (62c0341)
• Stage (044ecad)
• Character (0cadac2)
• Region (43cdaf3)
• Game mini game (db755a1)
• Platform game mini game (89596a2)
• Platform game mini game mode (545a584)
• Platform game mini game mode stage (8e7bf6c)
• Platform game mini game mode character costume (7e486ad)
• Character costume (ff2ed4a)
• Score approval motive (20b4226)
• Refactor all to use the new MapProfile injectable, because it will throw an error if the map profile doesn't exists, prior to this, the error would be thrown in runtime, which is not good (08ce8b0, 044ecad, 68e765a, 0b012d3, 75be871, 8481af6, 9cfcb67, 417580b, e307390, 90800fb, 7b8a89c, 484fc26, 33960e4, 30c2b20, and probably more)

Score world record timing problem

in ScoreService.approvalAdmin it's possible to check for world record before the approval is done.

// These two actions needs to finish before we check for world record
const promises: Promise<ScoreApproval | UpdateResult | void>[] = [
  this.scoreApprovalService.addAdmin({ ...dto, idUser: user.id, action, actionDate: approvalDate, idScore }),
  this.scoreRepository.update(idScore, {
    status: action === ScoreApprovalActionEnum.Approve ? ScoreStatusEnum.Approved : ScoreStatusEnum.RejectedByAdmin,
    approvalDate,
  }),
];
if (action === ScoreApprovalActionEnum.Approve) {
  promises.push(
    this.scoreWorldRecordService.checkForWorldRecord({
      idPlatformGameMiniGameModeStage: score.idPlatformGameMiniGameModeStage,
      fromDate: addSeconds(approvalDate, -5),
      idPlatformGameMiniGameModeCharacterCostumes: orderBy(
        score.scorePlayers.map(scorePlayer => scorePlayer.idPlatformGameMiniGameModeCharacterCostume)
      ),
    })
  );
}
await Promise.all(promises);

Organize scripts into a folder

Create a folder called scripts and organize the scripts
Create a utils.ts file to have some utils functions

Add end-point to create player (admin)

Front-end issue: stLmpp/biomercs#9

Forum - notifications

• new entity TopicPlayerSettings (idTopic, idPlayer, notifications) 1169ed9
• send notifications according to this table

Create end-points on the forum

Create websockets to update the scores in real time

• Leaderboards
• World records
• Score approval
• Score change requests

Add new column "dateAchieved" to Score

Forum - create history of posts

Cancel score

Add option to cancel score in the change request

• New status "Cancelled" in the ScoreStatus
• New end-point to cancel the score

Front-end: stLmpp/biomercs#71

Add info about controller and mk to score player

Front-end: stLmpp/biomercs#50

• new entity Controller, columns: id, name
• new column idController in the ScorePLayer entity
• new properties idController and controllerName in the ScorePlayerViewModel
• new column idController in the Player entity, this will be the default in the ScorePlayerViewModel, if the player does not set it and submiting a score

Migrate to MikroORM

It seems much more features than typeorm

https://mikro-orm.io/

Fix search players not retuning itself when admin

Search players end-point should return the player requesting when the player is an admin

Refactor environment variables

Update socket.io to v4

nestjs/nest#5676

Feature: ban user

• Add bannedDate column to User
• Banned user approvals goes straight to admin

Notifications

• Table to hold the notifications
• Socket to send new notifications

Forum - avatar

Remove world record history end-points

Configure AWS SES to receive e-mails

E-mail queue

Create a queue for the e-mail

• new table EmailQueue
• the action of sending will be handled by rxjs (auditTime)

Clear todo itens

• Better error message on MapperService.map when there's no MapProfile
• Remove PlatformGameMiniGameModeStageService.findRandom
• Remove PlayerService.findRandom
• Remove ScorePlayerService.addManyRandom
• Remove ScoreController.insertRandom
• Remove ScoreController.insertManyRandom
• Remove ScoreService.insert
• Better error handling for SQL errors in HandleErrorFilter.catch (maybe create a issue for this only alone)

Register with steam does not work if an user already exists in the database

If you try to register with steam and the personaname of the steam profile already exists in the player or user tables, the api throws an error

Create structure to begin the forum

Tables:

• Category (name)
• SubCategory (name, description, idCategory)
• Moderator (idPlayer)
• SubCategoryModerator (idModerator, idSubCategory)
• Topic (name, idSubCategory, idScore, views, pinned, lockedDate)
• TopicTransfer (idTopic, idSubCategoryFrom, idSubCategoryTo)
• Post (post, idTopic, idPlayer, deletedDate)
• TopicPlayerLastRead (idPlayer, idTopic, readDate)
• New column (type) in the Rule entity to separate rules from the Forum and the Site

Add table ScoreStatus based on ScoreStatusEnum

Create end-point to change password

E-mail service refactor

Refactor e-mail service to not use AWS SES (since the refused my production access :D)

Update score gateway to send count approvals

Add count approvals to the payload of the socket

Send e-mail when the score is approved

Paginate response from player/search

Related issue: stLmpp/biomercs#10

Forum - transfer topic

Figure out how to create [email protected]

Figure out how to redirect from http to https on aws

Score world record - Seems to be not working

If you submit a lower score, it will consider it as wr

Forum - add validation to update and delete posts/topics

Block user after 3 tries to login with wrong password

Remove player approval of scores

The scores will go directly to the admin, even if there are more than 1 player

front-end: stLmpp/biomercs#65

Make sure only admins can submit scores for other players

Improvements MapService

• Add a way to map multiple properties at once, eg.

mapperService.create(Score, ScoreViewModel)
  .for(
    dest => [dest.idScoreStatus, dest.scoreStatusDescription],
    from => [from.scoreStatus.id, from.scoreStatus.description]
  );

This will be useful to need repeat code when multiple properties needs a slightly complex logic
https://github.com/stLmpp/biomercs-v2-api/blob/32d285a04a6f3fa3d1ad85a0027d0aaa47145aa7/src/score/score.module.ts#L182-L188
https://github.com/stLmpp/biomercs-v2-api/blob/32d285a04a6f3fa3d1ad85a0027d0aaa47145aa7/src/score/score.module.ts#L189-L195

In the example above, we're doing 2 lookups in the from.scoreWorldRecords array, and could be only one

Persist errors to the database

Create a new table to persist errors in the database

Add end-point to get the parameters filtered in the score/approval end-points

Create new end-point to search the parameters (Platform, game, etc) in the score approvals

Related issue: stLmpp/biomercs#11

Add Rate limit to some routes

• Login
• Register
• Steam register

Login will not have a rate limit, instead it will block the user when tried to login with wrong password more than 3 times. See #20