Making a Discord ticket bot w/ MySQL support. (Need some feedback.)

[Travis.]

The Discord ticket bot I am making depends on a MySQL database, and stores any information that it needs to store in the database. I am looking for suggestions as this bot will be sold here on MC-Market sooner or later.

Basically every message that is visible to your end user is able to be customized. All customizations are stored in an options.ini file. I have may ideas planned out already, but I have only just started and I am looking for feedback before I really start making this project and releasing it. I don't want this bot to be your regular ticket bot you can easily download from GitHub or a bot like Tickety. I want this to be something new and user-friendly.

Here are some of my plans:
- All tickets are archived in MySQL, so all ticket messages could be uploaded to a safe text uploader privately. (say Hastebin or Pastebin.)
- Check a ticket's status to see if it is opened or closed using a command.
- More coming soon...

If you suggest something that I like and that would be a great addition, I will credit you on this thread and when I actually release the bot. All suggestions will be reviewed and evaluated.

 

[markd]

wait so your saying all ticket messages are stored in a MySQL database?

 

[Travis.]

wait so your saying all ticket messages are stored in a MySQL database?

Yes, but instead I might change that so after a ticket closes, it will upload to Pastebin or something. Which would be toggleable in the options.ini file.[DOUBLEPOST=1553626879][/DOUBLEPOST]Let me rephrase that. All messages would be stored in the database. After the ticket is closed, all messages will be sent off to Pastebin and then wiped from the database. In the database under the ticket ID, would be the Pastebin link to view the ticket archive.

 

[Travis.]

Either one is a viable option. It's all personal preference anyway.

I am more familiar with normal MySQL.

 

[LillianA]

Or just once the ticket closes grab all of the messages and store them in plaintext and upload that file (if under 8MB) to a channel that you can specify, no need for a database if all it serves is to upload messages to pastebin

and store the file in a ./data/archives/ folder or something like that

 

[Travis.]

Or just once the ticket closes grab all of the messages and store them in plaintext and upload that file (if under 8MB) to a channel that you can specify, no need for a database if all it serves is to upload messages to pastebin

and store the file in a ./data/archives/ folder or something like that

True, and if the file is over 8mb it could upload to file dropper or something. I think I will do that instead then. Then if the options.ini file, the bot owner could specify if they want to upload the chat to a file uploader or not.

 

[Travis.]

How much could I even get for this, or should I just make it open source?

 

[Kuchy]

MySQL would be good if you planned on making a web panel alongside it. Otherwise, not really the best option for something you are wanting. Still good but a simple file with the data is better.

How much could I even get for this, or should I just make it open source?

People underprice discord bots at most times. If you went along with a panel, I'd say you could get it for $250-$300, being exclusive of course. For the other method, probably $85-$100.

If it's non exclusive, I'd probably sell it as a resource for $14.99 with panel. $11.99 without.

 

[Travis.]

MySQL would be good if you planned on making a web panel alongside it. Otherwise, not really the best option for something you are wanting. Still good but a simple file with the data is better.


People underprice discord bots at most times. If you went along with a panel, I'd say you could get it for $250-$300, being exclusive of course. For the other method, probably $85-$100.

If it's non exclusive, I'd probably sell it as a resource for $14.99 with panel. $11.99 without.

I will probably sell it for like $5. I think I would get more customers and also more attention to the product.

 

[Kuchy]

I will probably sell it for like $5. I think I would get more customers and also more attention to the product.

Completely up to you. Personally, I'd charge more if it included the web panel system. For web development, I try to charge based on difficulty and how long it would take so I can price based on per hour all together. Works well for me but everyone has their own preference.


I like your bot idea. Very nice and unique idea for saving chat logs (at least to me). Hope everything goes well.

Good luck!

 

[Travis.]

Completely up to you. Personally, I'd charge more if it included the web panel system. For web development, I try to charge based on difficulty and how long it would take so I can price based on per hour all together. Works well for me but everyone has their own preference.


I like your bot idea. Very nice and unique idea for saving chat logs (at least to me). Hope everything goes well.

Good luck!

I would make a panel if I knew anything about web development.

 

[Izuku]

agree wit u