Isolate Quotes in Database Field


#1

Could the quotes table be changed to have all the quote meta data in separate fields? It would make it easier to export a master list of the quotes (which I’m doing to upload the list for people to browse through the quotes). Right now, the format for the quotes field is:

[“username”,“quote”,timestamp,“game”]

…but putting each item in its own field would make it easier to work with them.


#2

Phantombot only supports key and value fields, it’s how the whole database is designed and we don’t have plans to change it for this version of phantombot.

It keeps things simple for those who make custom modules as well, since it’s an easy structure.


#3

Good to know, thanks!


#4

If youre exporting it to a browser, would can parse it as JSON in JavaScript and if will be an array. Makes it easier to manage than parsing it yourself.