Skip to content

Database documentation (v1.X)

Erik Bianco Vera edited this page Dec 30, 2021 · 3 revisions

db.reto

This file includes basic user information related to points and the servers an user is on.

  • username (String) The Discord given ID of an user.

  • points (Int) The amount of Karma an user holds.

  • servers (Array of Strings) An array of Discord server IDs both an user and Reto are on.

srv.reto

This file includes server-specific information. Most of it serves little purpose, and are remnants of cut features.

  • serverid (Int) The Discord given ID of a server.

  • heart (String) The name of the Heart emoji. Goes unused - all entries are set to "plus".

  • crush (String) The name of the Crush emoji. Goes unused - all entries are set to "minus".

  • star (String) The name of the Star emoji. Goes unused - all entries are set to "10".

  • global (Boolean) Determines whether the server is Global - that being, if the posts that belong to it can be included in Global Post Leaderboards.

activity.reto

This file includes the activities (Playing... statuses) that Reto flips through every 30 seconds. Each activity is stored as an individual element on the database.

  • activity (String) An activity to flip through.

customprefix.reto

This file includes the custom prefixes each server has.

[WIP]

best.reto

This file includes the name, ID and other info about the Best Of channel.

  • serverid (String) The Discord given ID of a server.

  • channelid (String) The Discord given ID of the channel that acts as the Best Of channel for the given server.

  • notification (String) The type of notification that's sent when a person reacts to a message. (message/reaction/disabled)

  • name (String) The name of the Best Of channel.

  • plusMessage (String) The message sent when a person reacts to a message with a :plus:, while the Notification is set to Message.

  • minusMessage (String) The message sent when a person reacts to a message with a :minus:, while the Notification is set to Message.

  • 10Message (String) The message sent when a person reacts to a message with a ⭐, while the Notification is set to Message.

comments.reto

This file includes any comment that has been reacted to at least once.

  • msgid (String) The Discord given message ID.

  • username (String) The Discord given ID of the user who's sent the comment.

  • points (Int) The amount of Karma said comment holds.

  • servers (String) The Discord given ID of the server the comment was sent on.

  • content (String) The text of the comment.

  • embed (String) A link to the first embedded URL on the comment. (EG. an image, a file, etc)

  • richembed (Array) An array that includes the elements of an embed. (EG. an embed sent by a bot, the contents of a link, etc.)

  • voters (Array of Ints) An array of Discord IDs for the people who voted on the comment. Used to prevent multiple voting.

  • stars (String) The amount of Stars given to the comment.

  • nsfw (Boolean) Determines if the comment was sent on a NSFW channel.

  • timestamp (String) A timestamp of the comment's publication date.

Clone this wiki locally