NPQ0aEck

1package me.ase.CommandCheckerBlocker.Listeners;
2
3import java.sql.*;
4import org.bukkit.event.EventHandler;
5import org.bukkit.event.Listener;
6import org.bukkit.event.player.AsyncPlayerChatEvent;
7
8import me.ase.CommandCheckerBlocker.DBConnect.databaseConnection;
9import me.ase.CommandCheckerBlocker.Utils.ColorChat;
10
11public class MuteListener implements Listener {
12	public void DatabaseConnect() throws SQLException, ClassNotFoundException {
13		try {
14			String sql = "CREATE TABLE IF NOT EXISTS CCB_Mutes (" + "USERNAME varchar(255)," + "UUID varchar(255),"
15					+ "ISMUTED varchar(255)" + ");";
16			databaseConnection.setData(sql);
17		} catch (Exception e) {
18			e.printStackTrace();
19		}
20	}
21
22	@EventHandler
23	public void onPlayerMute(AsyncPlayerChatEvent event) {
24
25		try {
26			String sql = "SELECT * FROM CCB_Mutes";
27			ResultSet rs = databaseConnection.getData(sql);
28			System.out.println("THE FIRST ONE WKRS I THINMOL");
29			while (rs.next()) {
30				String UUID = rs.getString("UUID");
31				String ISMUTED = rs.getString("ISMUTED");
32				if (UUID == event.getPlayer().getUniqueId().toString()) {
33					if (ISMUTED == "yes") {
34						event.setCancelled(true);
35						event.getPlayer().sendMessage(ColorChat.chat("[C&cCB&r] &cYou cannot speak as you are muted!"));
36					}
37
38				}
39			}
40		} catch (Exception e) {
41			e.printStackTrace();
42		}
43	}
44
45}