Version 3.2.0

Updating from a previous version? You'll need to change some things!

• The awards table will need to be altered. The column labelled "awardType" needs to be changed to "awardCategory". If you're also using this to show on a website, you'll need to change it there too.
• We've also moved the quote and request a quote system to the database. However, we don't transfer these over. You'll need to do this manually due to the values required to save a quote have changed.

Changes

2a3a762 Version Change in AssemblyInfo.cs
5b6f561 Changed around the introduction message
5219bfb Fixed an SQL Query where UpdateChannel would update the guilds table
0f5d556 Added command editbotchannels to allow the Bot Owner to modify all bot channels with a single command
fd3673f Removed command addreaction
27c352a Added Methods.cs to store useful methods for the application
fabf8a9 Added a new Windows Form to configure the application
ce979fb Database validation is required again when Validate DB Settings button is clicked
266a938 Added IsBot check into AwardEXPToUser to prevent bots from gaining EXP
1c0e540 Changed the quote system to store quotes into the database
8c0b857 Fixed an issue with editquote command
3b2a607 Removed the Voting Links handlers
f6fc1b3 Using Objects in FunModule
d177bc5 Add command to create the admin_log table in the database
a275742 Added admin logging to log important commands that are issued to the database
d0a9e4c Changed the console message for when database commands are executed
82dd1fa Package changes
b524a8b Fixed an typo where StringConfiguration messages appear as GuildConfiguration
4063e75 Removed MogiiCraft commands
66badbb Cleaned up AdminLog
3b01f63 Cleaned up Quote & RequestQuote
51f58ba Changed Activity Type based commands to a simpler system to combat confusion
1e4cdab Changed AwardId from ulong to int
1e4cdab Added patreonSupporter into the SQL for the users table
d601de0 Removed commented code
af0d9e8 Updated stats command to use the count member instead of a loop
9de082e Updated startup notification and changed the embed style and information
d9b4e51 Changed the way the Configurator variables are printed to console
d9b4e51 Added the date and time to the information printed to the console
8837c49 Added notes to DiscordBot.cs
f87a87b Added publish path to csproj
bc5767c Added LoadAll to Award to load all the awards from the database on startup
3015cce Changed awards command to use the loaded awards from startup
eda5420 Modified listquotes and listrequestquotes to list quotes from the loaded lists
fa31c2d Changed buyquote to requestquote
a03ab6a Created AwardNotFoundException.cs and UserNotFoundException.cs
f45e35d Changed awardType to awardCategory in DatabaseActivity.cs when creating the awards table
fd3b777 Changed GetUser() to throw UserNotFoundException when the bot is unable to get the user
8761725 Fixed an issue where stats wouldn't return a result if the bot couldn't getUser()
bc19ffc Fixed an issue on startup where the bot wouldn't post a startup message if it couldn't getUser()
ddc075d Remove Console outputs from leaderboard command in LeaderboardModule.cs
68e0ec5 Added AwardingEXPReactionEnabled and AwardingEXPReactPostEnabled to control if reactions award EXP
89251d1 Added toggleexpreactawarding and toggleexpreactpostawarding to editconfig
e5db29a Added awardCategory to categorise awards
e5db29a Added GetAward() to Award.cs
e5db29a Added ReloadAll() to Award.cs
e5db29a Added AddAward() to Award.cs
e5db29a Added DeleteAward() to Award.cs
967c46c Added giveaward command to give users awards
967c46c Added listawards command to list all the awards in the database
967c46c Added deleteaward command to remove an award from a user
967c46c Changed AwardModule base class from ModuleBase to InteractiveBase
5afd889 Changed the format of the Award List
be448e4 Removed PrintExceptionToLog method
f1baaa5 Moved MessageReceived, Log and Ready events to their own handler classes
072187a Added awardinfo command to display information about an award
afb2059 Code Cleanup
487d6d9 Code Cleanup
189c800 Removed...

Version 3.1.0.0

Changes

9c74d30 Added SQL Command to add the table 'guilds' to the database
8dd50e7 Added SQL Command to add the table 'channels' to the database
0d3e4f8 Added SQL Command to add the table 'bans' to the database
341ee1b Added an additional field into the channels table to identify the guild
e680d82 Added channelType to the channels table in the database
81e86b7 Added SQL Command to add channels to the database when the ready event is executed
81e86b7 Added a check to gather information from the database to see if the channel is awardingEXP
baaed3c Fixed typo in a comment
8a54a59 Added ChannelUpdated Event to allow updates to the database if a channel has been updated
52e172c Added SQL Command to add channels to the database when the bot joins a new guild
f79f663 Added SQL Command to add channels that are newly created that the bot can see
a9aeb0e Added Update SQL Command to update the channels table when the user toggles if the channel awards EXP
5070933 Changed the AwardEXP in the MessageReceived Event to use the Channel Object
68ccc23 Created the Channel Object to load information from the database
eb345c4 Commented out Common/Channel for removal
763786f Removed commented out code in UserExtensions
ac7df6d Changed Ready Event to call methods to issue changes to tables in the database
ac7df6d Added ReadyAddGuildsToDatabase to add guilds to the database when the ready event is called
ac7df6d Added ReadyAddChannelsToDatabase to add channels to the database when the ready event is called
ac7df6d Added ReadyAddUsersToDatabase to add users to the database when the ready event is called
ac7df6d Added ReadyAddBansToDatabase to add bans to the database when the ready event is called
3300496 Added additional Guild Events
04db261 Changed dateJoined in Guilds Table from date to datetime
70718e7 Added InsertChannelToDB to issue an MySQL Command to the database inserting the guild channel passed
70718e7 Cleaned up ChannelHandler
88864c5 Added InsertGuildToDB to issue an MySQL Command to the database inserting the guild passed
88864c5 Added additional guild event methods
0895878 Cleaned up DiscordBot by moving methods to their handlers and calling methods from there such as InsertGuildToDB and InsertChannelToDB
c881e63 Changed database engine for tables
5a6868f Changed params in AwardModule to read from the awards table the correct values
c776f38 Added Events to handle Guild Bans
a8d8a1a Added MySQL Commands to add and remove users from the bans table in the database when they have been banned/unbanned from a guild
463051d Added MySQL Commands to update the guilds table when a guild has been updated or the Bot has been removed
83d0cb6 Added methods to GuildHandler to handle the database commands to add, update and remove guilds from the database
e8625b4 Added methods to ChannelHandler to handle the database commands to add, update and remove channels from the database
7c2dc4d Renamed variable in Channel Object from cId to channelID
60510fe Renamed a database field in the guilds table from enableNsfwCommands to nsfwCommandsEnabled
0cb67d7 Added Guild Object to handle the data read from the database
ef902e7 Updated gPrefix in DiscordBot to load from the Guild Object
b33f8cf Added DefaultUndefinedChannelID to Configuration to set the Channel ID in Guild Object if the channel is null
596182e Added SendMessageToGuild to GuildHandler to provide information for setting up the bot in new guilds
b87264f Updated files to load from Guild Object instead of Common/GuildConfiguration
e08cb84 Commented out GuildConfiguration to be removed
1c3be16 Added Objects/Channel and Objects/Guild to the Project
a52a076 Cleaned up User Object
736a8a0 Added PROFILE_URL_ID_TAGGED to Configuration to make the profile URL configurable
87e7914 Added a link to the users online profile to their about message
87e7914 Added required EXP to level up to the about message
1a03d57 Cleaned up CreateDatabaseIfNotExists in DatabaseActivity to issue one command instead of two
336efaa Added guildsInDatabase in Ready Event to remove guilds from the database if the bot was removed from the guild whilst it was offline
8129ee4 Changed RemoveGuildFromDB from private to public
e520a51 Changed Version to 3.1.0.0
99b2f95 Removed Latest Version Check on Rea...

Version 3.0.0.0

Changes

8e8f610 Added the user class to create user objects.
6f5b60a Update User.cs
2eff348 Updated User.cs
31d6974 Added PokemonGoFriendCode
b4d1791 Added method call to check if the database exists
6f84d72 Added method to check for the database - currently checks the configuration file to see if the database details exist
e4a7c19 Moved database check below configuration check to ensure that the configuration file is created before using it
fd08f56 Updated AwardModule to use DatabaseActivity instead
29d71da Added Execute Command methods along with create commands to create the database and tables
e563590 Made changes to add parameters to MySqlCommand instead of directly inserting them
052a9ee Added DataReader to read information from the database about a user
9631680 Fixed casting issue
d6ec930 Removed byte casting and changed to GetByte method
e9928bc Removed parameter passing for CREATE DATABASE due to errors
ba2ccb9 Added startup check to ensure all users have been added to the database
e4f45fa Changed nullable bool to bool in User Object
18ff83c Changed ExecuteNonQueryCommand method return the amount of rows affected
404e92d Changed #UserExtensions from Common/User to Objects/User
557ab8b Changed User Object to read and write to the database
d42e1b6 Updated profile module to get and update data on the database
2c706ef Changed variables to prevent them from being nullable
aebc52e Added DiscordBot.Objects to use the User object instead of the User in /Common
0b5cf22 Updated OwnerModule to get and update data on the database
8e0d768 Added UserUpdated Event to log changes such as a username update for the website
5e1abc5 Updated FunModule to read from the database
072a35e Updated LeaderboardModule to read from the database
cc1a374 Updated InfoModule to read from the database
c83ccb2 Updated TeamMemberModule to read from the database
30e4bf8 Updated ForceModule to get and update data on the database
33a5a73 Updated UserHandler to add a new user to the database and update users if they update their username or avatar
8fe7830 Changed the charset to allow emojis to be added to the database
373b816 Changed null checks to string.isnullorempty checks instead
73ebed6 Commented out Common/User.cs - file to be removed
b540e9d Version change and adding of ValueTuple Package
01679f6 Changed if null checks to string null checks
e744c11 Added command to change Pokemon Go Friend Code, and it now appears on the about message
e488ced Changed minecraftusername to just minecraft in ForceModule
fa87d42 Added PokemonGoFriendCode to ForceModule
d69e52e Added GetPokemonGoFriendCode to UserExtensions
d9c15e2 Changed null check to string null check in DiscordBot to fix messages as commands issue
44dcc7f Added AwardingEXPMentionUser to the Configuration to enable or disable mentions in the 'User Levelled Up' embed
8512950 Added AwardingEXPMentionUser to UpdateConfiguration
d43740b Added a check to see if the user gets mentioned when they have leveled up
bce0ba1 Added a command to toggle AwardingEXPMentionUser
c88fdb0 Cleaned up the debugging code
2c62cb6 Fixed a database connection leak issue
b8eab58 Fixed an issue where the MySqlDataReader would close before the datawas saved

Pull Requests Merged

db02c0f Merge pull request #2 from MythicalCuddles/Database Integration and User Update
7e29e1f Merge pull request #3 from MythicalCuddles/Changing EXP Message to have a toggle-able mention

Version 2.12.3.0

Fixed an issue with Awards in the past not showing up.

Version 2.12.2.0

Merge remote-tracking branch 'origin/master'

Version 2.12.1.0

Version 2.12.1.0