In our quest to make lookups easier and faster for customers we sometimes take the time to collate open government data sources that are in horrible Excel/CSV/MDB/Text files with differing columns into a single standardised MySQL database table. GP Practices was one such mess of OpenGov Data. The GPPractices-2020-06-02.sql file contains the following numbers of GP Practice details: England...
Its something that is always annoying, having to try to do address look-ups, there are loads of third-party services that offer this, but they all charge per lookup or block of look-ups. We packaged up our complete UK Address list (All of England, Scotland, Wales and Northern Ireland) into a wonderful MySQL Script that runs to create a single Addresses table containing all of the 30,689,521...
Commands Plugin Commands !deletebotmessage Deletes Bot Messages !warning1 — !warning2 — !warning3 — Levels Plugin Commands !levels Get a link to the leaderboard !rank (optional user) Get the rank of anyone in the server Moderator Plugin Commands !ban [member] (optional reason) Bans a member from the server !tempban [member] [duration] (optional reason) Temporarly bans a member...