Page MenuHomedesp's stash
Files F373930

BotBan.java
No OneTemporary
Actions

BotBan.java
View Options

package me.despawningbone.discordbot.command.admin;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Arrays;
import org.apache.commons.lang3.exception.ExceptionUtils;
import me.despawningbone.discordbot.DiscordBot;
import me.despawningbone.discordbot.command.Command;
import me.despawningbone.discordbot.command.CommandResult;
import me.despawningbone.discordbot.command.CommandResult.CommandResultType;
import net.dv8tion.jda.api.entities.Member;
import net.dv8tion.jda.api.entities.Message;
import net.dv8tion.jda.api.entities.TextChannel;
import net.dv8tion.jda.api.entities.User;
public class BotBan extends Command {
public BotBan() {
this.alias = Arrays.asList("bban");
this.desc = "Ban a user from the bot";
this.usage = "<userID>";
this.examples = Arrays.asList(DiscordBot.OwnerID);
this.botUserLevel = BotUserLevel.BOT_MOD.ordinal();
}
@Override
public CommandResult execute(TextChannel channel, User author, Message msg, String[] args) {
if (args.length < 1) {
return new CommandResult(CommandResultType.INVALIDARGS, "Please enter a user ID.");
} else {
//boolean alrBanned = false;
String SID = args[0];
Member b;
try {
b = channel.getGuild().getMemberById(SID);
} catch (NumberFormatException e) {
return new CommandResult(CommandResultType.INVALIDARGS, "Invalid user ID.");
}
if (b != null) {
if (DiscordBot.ModID.contains(SID) || SID.equals(DiscordBot.BotID)) {
return new CommandResult(CommandResultType.FAILURE, "That user cannot be banned.");
} else {
try (Connection con = DiscordBot.db.getConnection(); Statement s = con.createStatement()) {
String reports = "";
ResultSet uRs = s.executeQuery("SELECT reports FROM users WHERE id = " + SID + ";");
if(uRs.next()) {
reports = uRs.getString(1);
if(reports.split("\n").length >= 5) {
return new CommandResult(CommandResultType.FAILURE, "The user is already banned from the bot.");
}
}
PreparedStatement set = con.prepareStatement("INSERT INTO users(id, reports) VALUES (?, \"0\n0\n0\n0\n0\n\") ON CONFLICT(id) DO UPDATE SET reports = \"0\n0\n0\n0\n0\n\"");
set.setString(1, SID);
if(set.executeUpdate() != 0) {
channel.sendMessage("You have successfully banned <@!" + SID + "> from the bot.").queue();
return new CommandResult(CommandResultType.SUCCESS);
} else {
throw new IllegalArgumentException("This should never happen");
}
} catch (SQLException e) {
return new CommandResult(CommandResultType.ERROR, ExceptionUtils.getStackTrace(e));
}
/*for (int i = 0; i < DiscordBot.BannedID.size(); i++) {
if (DiscordBot.BannedID.get(i).equals(SID)) {
alrBanned = true;
break;
}
}
if (!alrBanned) {
boolean inList = false;
for (int i = 0; i < DiscordBot.playerreportlist.size(); i++) {
if (DiscordBot.playerreportlist.get(i).equals(SID)) {
inList = true;
DiscordBot.playerreportlist.set(i, SID + " " + "5");
break;
}
}
if (!inList) {
DiscordBot.playerreportlist.add(SID + " " + "5");
}
DiscordBot.BannedID.add(SID);
Path fp = Paths.get(System.getProperty("user.dir"), "PlayerReports.txt");
try {
List<String> fileContent = new ArrayList<>(
Files.readAllLines(fp, StandardCharsets.UTF_8));
for (int f = 0; f < fileContent.size(); f++) {
if (fileContent.get(f).startsWith(SID)) {
fileContent.set(f, SID + " " + "5");
inList = true;
break;
}
}
if (!inList) {
fileContent.add(SID + " " + "5");
}
Files.write(fp, fileContent, StandardCharsets.UTF_8);
} catch (IOException e) {
e.printStackTrace();
}
channel.sendMessage("You have successfully banned <@!" + SID + "> from the bot.").queue();
return new CommandResult(CommandResultType.SUCCESS);
} else {
return new CommandResult(CommandResultType.FAILURE, "The user is already banned from the bot.");
}*/
}
} else {
return new CommandResult(CommandResultType.FAILURE, "This user ID is invalid.");
}
}
}
}

File Metadata

Mime Type
text/x-java
Expires
Fri, Aug 1, 12:25 PM (14 h, 43 m)
Storage Engine
local-disk
Storage Format
Raw Data
Storage Handle
21/00/f85d43619118f1f92b97cf5ef670

Event Timeline

Back to Main Site