Excidion / trackmania_nations_challenge_bot

Telegram chatbot to serve as a moderator to a weekly challenge in the video game TrackMania Nations.
1 stars 1 forks source link

Sometimes the current track is wrongly colored in plot #13

Open Excidion opened 3 years ago

Excidion commented 3 years ago

There are two steps in determining the color associated with a track:

Since the wrongly colored track follows the naming scheme in Step 2 and is still colored orange, Step 1 must be the problem source.

@fanyx please check the DB if a wrong or wrongly spelled author name is supplied.

fanyx commented 3 years ago
+------------------+---------+
| Name             | Author  |
+------------------+---------+
| C06-Speed        | Nadeo   |
| B02-Race         | Nadeo   |
| Very Short 7     | prchev  |
| A11-Race         | Nadeo   |
| B03-Race         | Nadeo   |
| C07-Race         | Nadeo   |
| Very Short 76    | prchev  |
| B10-Speed        | Nadeo   |
| Pull the Curtain | ..pat   |
| D12-Speed        | Nadeo   |
| S-03-short       | _ultima |
| A01-Race         | Nadeo   |
+------------------+---------+

DB table looks fine to me.

Excidion commented 3 years ago

Weird. But it seems like the data is somehow dirty. Are there maybe extra spaces around the name? Because if I just check if the Author name contains Nadeo, it works as expected. I could implement it to just check if it is contained, that would fix it but also potentially wrongly label any custom tracks whose author has Nadeo somwhere in the name.