Razviar / mtgap

Support tool for MTG Arena online game
https://mtgarena.pro/
219 stars 50 forks source link

Exported collection (.csv) has incomplete card names #311

Closed Senryoku closed 2 years ago

Senryoku commented 2 years ago

Detailed context (ISSUES WILL NOT BE INVESIGATED WITHOUT IT!):

Your Desktop:

Describe the bug Exported collections from the website in the MTGGoldfish CSV format features some incomplete card names, limiting the interaction with other tools. In looks like it's filtering some SQL keywords. Examples I've encountered:

I think the problem was introduced recently as I didn't notice it the last time I exported my collection (around the 24th of April I think?), and it definitely already contained "Selective Snare" for example.

To Reproduce Steps to reproduce the behavior:

  1. Go to the collection manager (or use mine as an example: https://mtgarena.pro/collection/?Senryoku)
  2. Click on 'Export Collection'
  3. Select MTGGoldfish CSV format
  4. Inspect card names in the generated file (or lookup the attached example)
Razviar commented 2 years ago

We performed db upgrade to MySQL 8.0.28, so those issues are quite possible. We will look into it

Razviar commented 2 years ago

Fixed.