Discord.js Bot with mySQL integration

Overview



Orange Discord Bot

A multi-Guild usable Discord bot built with discord.js

AboutFeaturesInstallationSetting UpLicenseCreditsCommands

The orange [ˈɔrɪndʒ] is a round, sweet fruit with a thick orange skin and an orange core, which is divided into many parts.

Or·ange [the]: A fruit

About

Orange is an open source, customizable Discord bot that is constantly growing. The Bot comes packaged with a variety of commands. The Bot's codebase also serves as a base framework so everyone can easily create a Discord Bot of all kinds and needs. You can invite Orange to your Discord server using this link! Also, you can join my Server Funf for questions, suggestions, assistance and much more.

If you like this repository, feel free to leave a star to help promote Orange!
You can find a detailed information sheet with all commands here.

Features

21 commands across 3 different categories!

  • fun commands like reddit, reddit [custom subreddit]
  • moderation commands like clear, clearchannel, prefix and userinfo
  • music commands like play, lyrics, 24/7, autoplay, skip and much more

Installation

You can add Orange to your server with this link! Alternatively, you can clone this repository and host the bot yourself.

git clone https://github.com/jonaskroedel/orangedb

After cloning, run these commands

npm install
npm install discord.js
npm install dotenv --save
npm install --save mysql2
npm install [email protected]
npm install lyrics-finder

to get all the dependencies and packages. You need Node.js and MySQL installed. I highly recommend to install nodemon as it makes testing much easier.

Setting Up

You have to create a .env file in your root directory to run the bot (you can use the example file provided as a base). Your file should look something like this:

BOT_TOKEN=YOURTOKEN
DB_HOST=YOUR_HOST_ADRESS //eg. localhost
DB_USER=YOUR_DB_USER //eg. root
DB_PASS=YOUR_DB_PASSWORD //eg. root
DB_NAME=orangedb  //if you dont know, then do not change that!
HOST=YOU_LAVALINK_HOST
PASSWORD=YOUR_LAVALINK_PASSWORD
PORT=YOUR_LAVALINK_PORT
PREFIX=o! //default prefix for orange

Visit the Discord developer portal to create an app and use the client token you are given for the token option. ownerId is your own Discord snowflake.

After that, you have enable Privileged Intents on your Discord developer portal. You can find these intents under the "Bot" section, and there are two ticks you have to switch on. For more information on Gateway Intents, check out this link.

To-Do

OrangeDB is a continous state of development. New features/updates can come at any time. Some pending ideas are:

  • Music
  • Ticket-System
  • Automod
  • Autoroles
  • Stream alerts

License

Released under the GNU GPL v3 license.

Credits

  • Jonas Krödel - initial work, artwork, idea, implementation and project management - github
  • Julian Hoffmann - minor helping - github
  • Angelo Failoni - helping hand and database-design - github
© Jonas Krödel 2022
You might also like...

A CRUD implementation using sequelize, mySQL, NODEJS, Express, JWT and other technologies.

A CRUD implementation using sequelize, mySQL, NODEJS, Express, JWT and other technologies.

A ideia do projeto é simular o funcionamento do backend de um blog através da implementação de uma aplicação em Node.js usando o pacote sequelize para

May 11, 2022

Application template for NestJS + Docker + Prisma + MySQL

nestjs-docker-prisma-mysql Application template for NestJS + Docker + Prisma + MySQL Setup # install $ yarn # Setup env file for database $ cp .env.e

Oct 15, 2022

A clean-looking, secure, MySQL/MariaDB remote connection terminal made in NodeJS

A clean-looking, secure, MySQL/MariaDB remote connection terminal made in NodeJS

NodeJS MySQL/MariaDB Terminal NodeJS MySQL/MariaDB Terminal is a remote terminal for MySQL/MariaDB databases, which works in the same way as the offic

Jun 24, 2022

Public project to perform migrations on mysql database.

node-mysql-migrate Public project to perform migrations on mysql database. How to run First step, install the dependency for your project. To make it,

Aug 16, 2022

Simple REST API using Express with TypeScript, PostgreSQL, and MySQL to practice the Clean Architecture by Uncle Bob.

Clean-Architecture Simple REST API using Express with TypeScript, PostgreSQL, and MySQL to practice the Clean Architecture by Uncle Bob. About This RE

Oct 16, 2022

MySQL meets Jupyter notebooks. Grasp provides a new way to learn and write SQL, by providing a coding-notebook style with runnable blocks, markdown documentation, and shareable notebooks. ✨

MySQL meets Jupyter notebooks. Grasp provides a new way to learn and write SQL, by providing a coding-notebook style with runnable blocks, markdown documentation, and shareable notebooks. ✨

A New Way to Write & Learn SQL Report Bug · Request Feature Table of Contents About The Project Built With Getting Started Prerequisites Installation

Sep 1, 2022

Blog application api in Node.js express.js sequelize ORM and MYSQL Database

Node Express Mysql Sequelise Blog System Api Node api with express mysql sequelise Usage To get started with this api follow the steps below $ git clo

Nov 9, 2022

Nestjs, Sequelize, Mysql Boilerplate

Nestjs - Sequelize - Mysql Boilerplate Description NestJS framework TypeScript starter repository or boilerplate with jwt user authentication. Feature

Aug 27, 2022

Fastest JavaScript client for MySQL, with Deno FFI.

Fastest JavaScript client for MySQL, with Deno FFI.

mysql-native The fastest [1] JavaScript MySQL client. import { Connection } from "https://deno.land/x/mysql_native/mod.ts"; const conn = new Connectio

Sep 27, 2022
A discord bot to track "owo", usually used to help with OwO bot. Made with Discord.js v13 includes Slash commands, Leaderboards, Auto Resets etc.

Discord-OwO-tracker A discord bot to track "owo", usually used to help with OwO bot Requirements Discord.js v13 (npm install discord.js@latest) applic

Astrex 4 Nov 24, 2022
fardin 8 Oct 18, 2022
Use real-time computing technology and web technology to build a big data Kanban l to solve the problem. Among them, practical technologies include MySQL, Kafka, Flink, Redis, Flask and Echarts

实时计算(English Version) 运用实时计算技术、Web 技术构建一个大数据看板来解决问题。其中实用技术包括Mysql、Kafka、Flink、Redis、Flask和Echarts 目录 1.问题需求 2.方案分析 3.安装环境 4.环境启动命令和运行代码的方法 5.代码目录结构说明

Serendipity 2 Jan 8, 2022
practice site to utilize node.js, Express, and mySQL

fishing_site practice site to utilize node.js, Express, and mySQL Run Locally create local instance of MySQL database. Run DB/fishing_Schema.sql to cr

Ryan Graue 1 Jan 22, 2022
A dockerized express mysql starter using typescript which iclude user management

A dockerized express mysql starter using typescript which iclude user management

Nimatullah Razmjo 2 Jan 26, 2022
A Restaurant (Table) Reservation API built with Node, TypeScript, Express, TypeORM, a MySQL DB, all running on Docker containers

Restaurant (Table) Reservation API A simple API for reserving tables at a restaurant. The API is based on the REST architectural style and uses Node.j

null 14 Oct 5, 2022
A Restaurant (Table) Reservation API built with Node, TypeScript, Express, TypeORM, a MySQL DB, all running on Docker containers

Restaurant (Table) Reservation API A simple API for reserving tables at a restaurant. The API is based on the REST architectural style and uses Node.j

null 14 Oct 5, 2022
Node.js Express + MySQL vulnerable boilerplate project

Node.js Express + MySQL vulnerable boilerplate project

null 13 Sep 16, 2022
A Deno ORM for MySQL, SQLite, PostgreSQL, MongoDB, GitHub and serverless service like Deta, InspireCloud, CloudBase, LeanCloud

A Deno ORM for MySQL, SQLite, PostgreSQL, MongoDB, GitHub and serverless service like Deta, InspireCloud, CloudBase, LeanCloud.

ʀᴀʏ 5 Dec 15, 2022