Champion Tickets Bot v1.7.9.4

Update 1.7.6

Scroll to the bottom of update to see Migration Guide
!!! Before updating to this version backup your json.sqlite file !!!

• Added option to choose between SQLite, MySQL & MongoDB for database
• From now all data will be saved in corresponding tables
• MongoDB will use cache for faster response
• Updated to use new Discord Username Format
• Fixed ChannelInfo Command
• Reworked Startup Database Checks
• Fixed quote command returning wrong price
• Added Ticket Category Embed Title/Thumbnail/Image to dashboard
• Changed a bit of Crypto Command Code
• Suggestion Modal is now requires min. 3 characters instead of 6

This update brings some breaking changes that requires you to migrate your database to the new format. Thanks to the 'database-actions' addon, this is done by just starting bot with it.
Visit this page to see more information on how to migrate database:

Click here to visit Migration Guide

!!! Before updating to this version backup your json.sqlite file !!!​

Update 1.7.5.1

• Added button to transcripts which then opens list of Ticket Question Answers
• Changed Logo on Dashboard Sidebar to the New one
• Thread with Ticket Question Answers from now prevents sending messages in it
• Renamed 'autoResponse' to 'auto_response'
• Renamed 'autoAnnounce' to 'auto_announce'
• Added Cooldown for Auto Response Messages in channel
• 'question_answer_format' now also supports <name> placeholder​

Update 1.7.5

• From now answers of ticket questions are sent in a thread which is created in ticket channel (+ is no longer sent in embed but rather as normal message with markdown)
• Added per-ticket-category Embed Images and Thumbnail
• Ticket Category Panels can now be sent with image and thumbnail
• categories.yml placeholders for subcategories are changed so '<category>' now represents Parent Category while '<subcategory>' is subcategory
• categories.yml category field 'title' is moved to 'embed' section in category
• Added '<portfolio>' placeholder for quote embed
• Added that when using /getproduct slash command it first sends message 'Your file is uploading''
• From now AttachFiles permission is automatically given to ticket members (some servers doesn't have perms set properly so it wasn't giving by default)
• Fixed 'button_color' on dashboard
• Fixed 'ask_review' on dashboard
• Fixed dashboard not having 'image' and 'thumbnail' fields in categories
• Fixed withdraw throwing error
• Fixed reask and claim commands being shown on help menu even tho they're disabled
• Fixed some errors in ticketClose event
• Fixed setprofile command modal all fields being required
• Transcripts should regenerate if they're too big from now
• Fixed dashboard throwing error if there are no categories
• Changed title of transcript page to just say 'Ticket Transcript'
• Fixed getinvoice command
• Fixed default categories.yml having the wrong default 'description' in subcategories
• Reordered some fields by default in config.yml​

Update 1.7.4

• Added option to choose color of buttons on panel (when you have multiple or one that automatically opens in category)
• Added option to move tickets to 'archived' tickets channel category after they get closed
• In the most of places, <author>, <user> and other placeholders which represent some Member/User will no longer be mention in embed but rather in format Username#Discriminator
• Fixed error when opening ticket saying that you already have max. number of tickets but still creating channel
• ChangeCategory command from now also edit roles
• Fixed issue where configuration file would be blank/with just few lines/whole but with some broken lines at top, after you save something on dashboard
• Added <reviewId> placeholder to Review Embeds
• New placeholders <authorId>/<userId>.. are added to some embeds.yml sections
• Added option to move Client >< Freelancer Commission Messages (of 'Message Client' button) to Thread below commission message
• 'dm_message' config field is now 'dm_author' - can be sent when ticket is closed ('ticketCloseDm' in embeds.yml)
• Fixed some colors in Help Command
• Disabled 'inactivity_check' by default
• Temporary increased max. number of characters per Ticket Question Answer to 410 until split Embeds is added in some of the next updates
• Fixed GetReview when using slash command
• When you request money through withdraw it will be subtracted from your balance, if it gets denied money will be returned
• Fixed ticketCreate Collector
• Fixed createdTimestamp error for Ticket AutoClose
• Fixed bypass roles not being set properly through dashboard save​

Update 1.7.3
Make sure to read the text at the end!

• Added Dashboard HomePage Charts for Ticket Open/Close per Day
• Added Dashboard HomePage Charts for Members Join/Leave per Day
• Added option to customise & send Tickets Panel from Dashboard on 'Ticketing' Page (Send, Preview, Edit)
• Added option to toggle which Stat Boxes to show on Dashboard HomePage
• Ticket Categories editing has been moved to 'Ticketing' Page
• From now you can edit Ticket SubCategories + Ticket SubCategory Parent from Dashboard
• From now you can leave 'emoji' field in category empty and it won't give errors
• From now Panel Embed can be sent with multiple buttons for different categories
• From now you can specify which Ticket Categories to send in SelectMenu
• From now you can select to only specific Ticket Categories ask for Review (ask_review)
• Renamed 'ask' field from Ticket Categories to 'ask_questions'
• Added Config Bot to Change Bot's Status (Online, Idle, Invisible, Dnd - how this wasn't a feature? Thanks to the guy who suggested)
• Renamed 'instant_panel' field to 'panel_type' and it's value can be either 'SELECT_MENU' or 'BUTTONS'
• Added Config field 'panel_buttons_line' to specify how much Buttons per row can be in Panel Embed (Max 5)
• Added Footer to Ticket Transcripts
• Added Thumbnail Image to Ticket Transcripts
• Added 'Image' Image to Ticket Transcripts
• Changed Color of Dashboard Navbar and Color of some other elements that used the same (it's darker now)
• Added guildMemberAdd event
• Fixed Tooltip on 'Add Question', 'Remove Question' & 'Delete Category' Buttons on Dashboard
• 'mention_support_type' config field can now be edited from Dashboard
• Fixed Taxes not working with decimals
• Fixed Taxes when submitted from Modal
• Some more small tweaks

For this update it's required to replace all files (except configs) with new ones. I've made a Docs Page to make it easier for you to update configs with new fields - Click Here.
Make sure to backup all your files before you start update & have in mind that Dashboard Charts haven't been tested in real-time (whole 7 days) so issues may happen.
And for the end, thanks to everybody who made suggestions and gave feedback, it means a lot! I would like to hear about your feedback on this new update as well ​

Update 1.7.2

• Ticket Categories are now in separate file (categories.yml)
• Category with type 'SUBCATEGORY_PARENT' can be sent as Separate Panel
• Panel to automatically open Ticket in SubCategory can be sent from now
• Fixed Ticket Channel not created because of Ticket ID being forbidden number
• Invalid Scope Error will no longer be sent if there's no ID of Server in guild field
• Fixed some problem with close button​

Update 1.7.1.1

• Fixed Dashboard giving 403 Error Page
• Changed way Support Roles are mentioned in Tickets
• Added config option to select which field to use to mention Support Roles in Ticket
• Fixed isSelectMenu deprecated​

Update 1.7.1

• Fixed Dashboard Settings Page
• Fixed Invoice Command Errors
• When Role is Invalid, it will be logged in errors.txt file with ID
• Fixed Save Profile on Dashboard
• Added Inactive Tickets Check to Delete Them
• Updated discord.js version to 14.7.1​