Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.dibdibcraft.dBans;
- import org.bukkit.Bukkit;
- import org.bukkit.command.Command;
- import org.bukkit.command.CommandSender;
- import org.bukkit.entity.Player;
- import org.bukkit.event.EventException;
- import org.bukkit.event.EventHandler;
- import org.bukkit.event.Listener;
- import org.bukkit.event.player.PlayerLoginEvent;
- import org.bukkit.plugin.PluginManager;
- import org.bukkit.plugin.java.JavaPlugin;
- import com.dibdibcraft.dBans.SQL;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- public class Main extends JavaPlugin implements Listener {
- public SQL sql = new SQL();
- JavaPlugin plugin;
- //PERMISSION DEFINITIONS
- String permPrefix = "dBans."; //This will be used later....
- public String colorize(String msg) {
- String coloredMsg = "";
- for (int i = 0; i < msg.length(); i++) {
- if (msg.charAt(i) == '&') {
- coloredMsg += 'ยง';
- }
- else{
- coloredMsg += msg.charAt(i);
- }
- }
- return coloredMsg;
- }
- @Override
- public void onEnable(){
- System.out.println("[dBans] dBans Enabled");
- PluginManager pManager = getServer().getPluginManager();
- pManager.registerEvents(this, this);
- try {
- sql.connect(); //Opens the SQL connection.
- }
- catch (SQLException e) {
- e.printStackTrace();
- }
- }
- @Override
- public void onDisable(){
- System.out.println("[dBans] dBans Disabled");
- try {
- sql.close(null);
- }
- catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- public boolean onCommand(CommandSender s, Command cmd, String label, String[] args){
- if (cmd.getName().equalsIgnoreCase("dBans")){
- if (args.length == 0){ //If the command is just /dbans or /dbans help, return the help menu.
- s.sendMessage(colorize("&f&ldBans Help Menu"
- + "\n&&f/ban - "
- + "\n &f&oDescription: Permanently Bans a Player from the Selected Platform(s)"
- + "\n &f&oUsage: /ban <playerName> <platform> <reason>"));
- }
- }
- return false;
- }
- @EventHandler
- public void playerLogin(PlayerLoginEvent event) throws SQLException, EventException{
- Player player = event.getPlayer();
- Bukkit.broadcastMessage("UUID from Client: " + player.getUniqueId());
- ResultSet pData = sql.checkPlayer(plugin, player.getUniqueId().toString());
- while (pData.next()) { Bukkit.broadcastMessage("UUID: " + pData.getString("mcUUID")); }
- }
- }
- //Again, the SQL class would normally be in a different file but it has been included here for simplicity.
- package com.dibdibcraft.dBans;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.PreparedStatement;
- import java.sql.SQLException;
- import org.bukkit.plugin.java.JavaPlugin;
- import org.bukkit.scheduler.BukkitRunnable;
- import java.sql.ResultSet;
- public class SQL {
- private String host = "dibdibguy.com";
- private String username = "dibdibgu_mc";
- private String db = "dibdibgu_ddc";
- private int port = 3306;
- private String password = "password";
- private Connection con;
- private JavaPlugin plugin;
- public void connect() throws SQLException{
- this.con = DriverManager.getConnection("jdbc:mysql://" + host + ":" + port + "/" + db,
- username, password);
- }
- @SuppressWarnings("unused")
- public ResultSet checkPlayer(JavaPlugin plugin, String uuid) throws SQLException{
- ResultSet data = (ResultSet) new BukkitRunnable(){
- public ResultSet run(JavaPlugin plugin, String uuid) throws SQLException{
- if(!con.isValid(2)) { connect(); }
- String query = "SELECT * FROM `u_u_bans` WHERE `mcUUID`=? LIMIT 1";
- PreparedStatement stat = con.prepareStatement(query);
- stat.setString(1, uuid);
- return stat.executeQuery();
- }
- @Override
- public void run() {
- // TODO Auto-generated method stub
- }
- }.runTaskAsynchronously(this.plugin);
- return data;
- }
- public void close(JavaPlugin plugin) throws SQLException{
- this.con.close();
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement