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 Ready Event
5bf696c
Updated Color on UserJoined Event from Red to Green
fb8a0b6
Changed condition check for rows updated on User Joined
Pull Requests Merged
7456019
Merge pull request #4 from MythicalCuddles/More Database Changes