public void updateTravellerCount(int id) {
// how many travellers are in the TARDIS?
Statement statement = null;
ResultSet rsCount = null;
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
String queryCount = "SELECT COUNT (*) AS count FROM travellers WHERE tardis_id = " + id;
rsCount = statement.executeQuery(queryCount);
if (rsCount.next()) {
int count = rsCount.getInt("count");
plugin.trackTravellers.put(id, count);
}
rsCount.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " /TARDIS travel to location Error: " + e);
} finally {
try {
rsCount.close();
} catch (Exception e) {
}
try {
statement.close();
} catch (Exception e) {
}
}
}
public void setBlockCheck(World w, int x, int y, int z, int m, byte d, int id) {
// List of blocks that a door cannot be placed on
List<Integer> ids =
Arrays.asList(
0, 6, 8, 9, 10, 11, 18, 20, 26, 27, 28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 44, 46,
50, 51, 53, 54, 55, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 75, 76,
77, 78, 79, 81, 83, 85, 89, 92, 93, 94, 96, 101, 102, 104, 105, 106, 107, 108, 109, 111,
113, 114, 115, 116, 117, 118, 119, 120, 122, 128, 130, 131, 132, 134, 135, 136);
Block b = w.getBlockAt(x, y, z);
Integer bId = Integer.valueOf(b.getTypeId());
byte bData = b.getData();
Statement statement = null;
if (ids.contains(bId)) {
b.setTypeIdAndData(m, d, true);
// remember replaced block location, TypeId and Data so we can restore it later
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
String replaced = w.getName() + ":" + x + ":" + y + ":" + z + ":" + bId + ":" + bData;
String queryReplaced =
"UPDATE tardis SET replaced = '" + replaced + "' WHERE tardis_id = " + id;
statement.executeUpdate(queryReplaced);
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + "Set Replaced Block Error: " + e);
} finally {
try {
statement.close();
} catch (Exception e) {
}
}
}
}
public boolean checkChunk(String w, int x, int z, TARDISConstants.SCHEMATIC schm) {
boolean chunkchk = false;
int cw, cl;
Statement statement = null;
ResultSet rs = null;
switch (schm) {
case BIGGER:
cw = roundUp(plugin.biggerdimensions[1], 16);
cl = roundUp(plugin.biggerdimensions[2], 16);
break;
case DELUXE:
cw = roundUp(plugin.deluxedimensions[1], 16);
cl = roundUp(plugin.deluxedimensions[2], 16);
break;
default:
cw = roundUp(plugin.budgetdimensions[1], 16);
cl = roundUp(plugin.budgetdimensions[2], 16);
break;
}
// check all the chunks that will be used by the schematic
for (int cx = 0; cx < cw; cx++) {
for (int cz = 0; cz < cl; cz++) {
String queryCheck =
"SELECT * FROM chunks WHERE world = '"
+ w
+ "' AND x ="
+ (x + cx)
+ " AND z = "
+ (z + cl)
+ " LIMIT 1";
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
rs = statement.executeQuery(queryCheck);
if (rs.next()) {
chunkchk = true;
}
rs.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Get All Chunks Error: " + e);
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
statement.close();
} catch (Exception e) {
}
}
}
}
return chunkchk;
}
public void setBlockAndRemember(
World w, int x, int y, int z, int m, byte d, int id, boolean rebuild) {
Block b = w.getBlockAt(x, y, z);
// save the block location so that we can protect it from damage and restore it (if it wasn't
// air)!
int bid = b.getTypeId();
String l = b.getLocation().toString();
Statement statement = null;
String queryAddBlock;
if (rebuild == false) {
if (bid != 0) {
byte data = b.getData();
queryAddBlock =
"INSERT INTO blocks (tardis_id, location, block, data) VALUES ("
+ id
+ ",'"
+ l
+ "', "
+ bid
+ ", "
+ data
+ ")";
} else {
queryAddBlock = "INSERT INTO blocks (tardis_id, location) VALUES (" + id + ",'" + l + "')";
}
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
statement.executeUpdate(queryAddBlock);
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Could not save block location to DB!");
} finally {
try {
statement.close();
} catch (Exception e) {
}
}
}
b.setTypeIdAndData(m, d, true);
}
public int[] getStartLocation(int id, TARDISConstants.COMPASS dir) {
int cx, cz;
Statement statement = null;
ResultSet rs = null;
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
String queryChunk = "SELECT chunk FROM tardis WHERE tardis_id = " + id + " LIMIT 1";
rs = statement.executeQuery(queryChunk);
String chunkstr = rs.getString("chunk");
String[] split = chunkstr.split(":");
World w = plugin.getServer().getWorld(split[0]);
cx = parseNum(split[1]);
cz = parseNum(split[2]);
Chunk chunk = w.getChunkAt(cx, cz);
startLoc[0] = chunk.getBlock(0, 15, 0).getX();
startLoc[1] = startLoc[0];
startLoc[2] = chunk.getBlock(0, 15, 0).getZ();
startLoc[3] = startLoc[2];
startLoc[4] = 1;
startLoc[5] = 1;
rs.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Get Chunk Error: " + e);
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
statement.close();
} catch (Exception e) {
}
}
return startLoc;
}
public class TARDISUtils {
private final TARDIS plugin;
TARDISDatabase service = TARDISDatabase.getInstance();
public TARDISUtils(TARDIS plugin) {
this.plugin = plugin;
}
public void setBlock(World w, int x, int y, int z, int m, byte d) {
Block b = w.getBlockAt(x, y, z);
b.setTypeIdAndData(m, d, true);
}
public void setBlockAndRemember(
World w, int x, int y, int z, int m, byte d, int id, boolean rebuild) {
Block b = w.getBlockAt(x, y, z);
// save the block location so that we can protect it from damage and restore it (if it wasn't
// air)!
int bid = b.getTypeId();
String l = b.getLocation().toString();
Statement statement = null;
String queryAddBlock;
if (rebuild == false) {
if (bid != 0) {
byte data = b.getData();
queryAddBlock =
"INSERT INTO blocks (tardis_id, location, block, data) VALUES ("
+ id
+ ",'"
+ l
+ "', "
+ bid
+ ", "
+ data
+ ")";
} else {
queryAddBlock = "INSERT INTO blocks (tardis_id, location) VALUES (" + id + ",'" + l + "')";
}
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
statement.executeUpdate(queryAddBlock);
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Could not save block location to DB!");
} finally {
try {
statement.close();
} catch (Exception e) {
}
}
}
b.setTypeIdAndData(m, d, true);
}
public void setBlockCheck(World w, int x, int y, int z, int m, byte d, int id) {
// List of blocks that a door cannot be placed on
List<Integer> ids =
Arrays.asList(
0, 6, 8, 9, 10, 11, 18, 20, 26, 27, 28, 29, 30, 31, 32, 33, 34, 37, 38, 39, 40, 44, 46,
50, 51, 53, 54, 55, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 75, 76,
77, 78, 79, 81, 83, 85, 89, 92, 93, 94, 96, 101, 102, 104, 105, 106, 107, 108, 109, 111,
113, 114, 115, 116, 117, 118, 119, 120, 122, 128, 130, 131, 132, 134, 135, 136);
Block b = w.getBlockAt(x, y, z);
Integer bId = Integer.valueOf(b.getTypeId());
byte bData = b.getData();
Statement statement = null;
if (ids.contains(bId)) {
b.setTypeIdAndData(m, d, true);
// remember replaced block location, TypeId and Data so we can restore it later
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
String replaced = w.getName() + ":" + x + ":" + y + ":" + z + ":" + bId + ":" + bData;
String queryReplaced =
"UPDATE tardis SET replaced = '" + replaced + "' WHERE tardis_id = " + id;
statement.executeUpdate(queryReplaced);
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + "Set Replaced Block Error: " + e);
} finally {
try {
statement.close();
} catch (Exception e) {
}
}
}
}
private static int[] startLoc = new int[6];
public int[] getStartLocation(int id, TARDISConstants.COMPASS dir) {
int cx, cz;
Statement statement = null;
ResultSet rs = null;
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
String queryChunk = "SELECT chunk FROM tardis WHERE tardis_id = " + id + " LIMIT 1";
rs = statement.executeQuery(queryChunk);
String chunkstr = rs.getString("chunk");
String[] split = chunkstr.split(":");
World w = plugin.getServer().getWorld(split[0]);
cx = parseNum(split[1]);
cz = parseNum(split[2]);
Chunk chunk = w.getChunkAt(cx, cz);
startLoc[0] = chunk.getBlock(0, 15, 0).getX();
startLoc[1] = startLoc[0];
startLoc[2] = chunk.getBlock(0, 15, 0).getZ();
startLoc[3] = startLoc[2];
startLoc[4] = 1;
startLoc[5] = 1;
rs.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Get Chunk Error: " + e);
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
statement.close();
} catch (Exception e) {
}
}
return startLoc;
}
public boolean checkChunk(String w, int x, int z, TARDISConstants.SCHEMATIC schm) {
boolean chunkchk = false;
int cw, cl;
Statement statement = null;
ResultSet rs = null;
switch (schm) {
case BIGGER:
cw = roundUp(plugin.biggerdimensions[1], 16);
cl = roundUp(plugin.biggerdimensions[2], 16);
break;
case DELUXE:
cw = roundUp(plugin.deluxedimensions[1], 16);
cl = roundUp(plugin.deluxedimensions[2], 16);
break;
default:
cw = roundUp(plugin.budgetdimensions[1], 16);
cl = roundUp(plugin.budgetdimensions[2], 16);
break;
}
// check all the chunks that will be used by the schematic
for (int cx = 0; cx < cw; cx++) {
for (int cz = 0; cz < cl; cz++) {
String queryCheck =
"SELECT * FROM chunks WHERE world = '"
+ w
+ "' AND x ="
+ (x + cx)
+ " AND z = "
+ (z + cl)
+ " LIMIT 1";
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
rs = statement.executeQuery(queryCheck);
if (rs.next()) {
chunkchk = true;
}
rs.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Get All Chunks Error: " + e);
} finally {
try {
rs.close();
} catch (Exception e) {
}
try {
statement.close();
} catch (Exception e) {
}
}
}
}
return chunkchk;
}
public static int roundUp(int num, int divisor) {
return (num + divisor - 1) / divisor;
}
public int parseNum(String i) {
int num = 0;
try {
num = Integer.parseInt(i);
} catch (NumberFormatException n) {
plugin.console.sendMessage("Could not convert to number");
}
return num;
}
public void updateTravellerCount(int id) {
// how many travellers are in the TARDIS?
Statement statement = null;
ResultSet rsCount = null;
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
String queryCount = "SELECT COUNT (*) AS count FROM travellers WHERE tardis_id = " + id;
rsCount = statement.executeQuery(queryCount);
if (rsCount.next()) {
int count = rsCount.getInt("count");
plugin.trackTravellers.put(id, count);
}
rsCount.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " /TARDIS travel to location Error: " + e);
} finally {
try {
rsCount.close();
} catch (Exception e) {
}
try {
statement.close();
} catch (Exception e) {
}
}
}
}
@Override
public boolean onCommand(CommandSender sender, Command cmd, String label, String[] args) {
// If the player typed /tardis then do the following...
// check there is the right number of arguments
if (cmd.getName().equalsIgnoreCase("tardis")) {
Player player = null;
if (sender instanceof Player) {
player = (Player) sender;
}
if (args.length == 0) {
sender.sendMessage(TARDISConstants.COMMANDS.split("\n"));
return true;
}
// the command list - first argument MUST appear here!
if (!firstArgs.contains(args[0].toLowerCase())) {
sender.sendMessage(
plugin.pluginName
+ " That command wasn't recognised type "
+ ChatColor.GREEN
+ "/tardis help"
+ ChatColor.RESET
+ " to see the commands");
return false;
}
if (args[0].equalsIgnoreCase("version")) {
FileConfiguration pluginYml =
YamlConfiguration.loadConfiguration(
plugin.pm.getPlugin("TARDIS").getResource("plugin.yml"));
String version = pluginYml.getString("version");
String cb = Bukkit.getVersion();
sender.sendMessage(
plugin.pluginName
+ " You are running TARDIS version: "
+ ChatColor.AQUA
+ version
+ ChatColor.RESET
+ " with CraftBukkit "
+ cb);
return true;
}
if (player == null) {
sender.sendMessage(
plugin.pluginName + ChatColor.RED + " This command can only be run by a player");
return false;
} else {
if (args[0].equalsIgnoreCase("chameleon")) {
if (!plugin.getConfig().getBoolean("chameleon")) {
sender.sendMessage(
plugin.pluginName
+ " This server does not allow the use of the chameleon circuit!");
return false;
}
if (player.hasPermission("tardis.timetravel")) {
if (args.length < 2
|| (!args[1].equalsIgnoreCase("on") && !args[1].equalsIgnoreCase("off"))) {
sender.sendMessage(plugin.pluginName + " Too few command arguments!");
return false;
}
// get the players TARDIS id
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "*");
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
int id = rs.getInt("tardis_id");
String chamStr = rs.getString("chameleon");
if (chamStr.equals("")) {
sender.sendMessage(plugin.pluginName + " Could not find the Chameleon Circuit!");
return false;
} else {
int x, y, z;
String[] chamData = chamStr.split(":");
World w = plugin.getServer().getWorld(chamData[0]);
TARDISConstants.COMPASS d =
TARDISConstants.COMPASS.valueOf(rs.getString("direction"));
x = plugin.utils.parseNum(chamData[1]);
y = plugin.utils.parseNum(chamData[2]);
z = plugin.utils.parseNum(chamData[3]);
Block chamBlock = w.getBlockAt(x, y, z);
Sign cs = (Sign) chamBlock.getState();
if (args[1].equalsIgnoreCase("on")) {
String queryChameleon =
"UPDATE tardis SET chamele_on = 1 WHERE tardis_id = " + id;
statement.executeUpdate(queryChameleon);
sender.sendMessage(plugin.pluginName + " The Chameleon Circuit was turned ON!");
cs.setLine(3, ChatColor.GREEN + "ON");
}
if (args[1].equalsIgnoreCase("off")) {
String queryChameleon =
"UPDATE tardis SET chamele_on = 0 WHERE tardis_id = " + id;
statement.executeUpdate(queryChameleon);
sender.sendMessage(plugin.pluginName + " The Chameleon Circuit was turned OFF.");
cs.setLine(3, ChatColor.RED + "OFF");
}
cs.update();
}
rs.close();
statement.close();
return true;
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Chameleon Circuit Save Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("occupy")) {
if (player.hasPermission("tardis.timetravel")) {
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "tardis_id");
if (!rs.next()) {
sender.sendMessage(
plugin.pluginName
+ " You must be the Timelord of the TARDIS to use this command!");
return false;
}
int id = rs.getInt("tardis_id");
rs.close();
String queryOccupied =
"SELECT * FROM travellers WHERE tardis_id = "
+ id
+ " AND player = '"
+ player.getName()
+ "'";
ResultSet rsOccupied = statement.executeQuery(queryOccupied);
String queryOcc;
String occupied;
if (rsOccupied.next()) {
queryOcc =
"DELETE FROM travellers WHERE tardis_id = "
+ id
+ " AND player = '"
+ player.getName()
+ "'";
occupied = ChatColor.RED + "UNOCCUPIED";
} else {
queryOcc =
"INSERT INTO travellers (tardis_id,player) VALUES ("
+ id
+ ",'"
+ player.getName()
+ "')";
occupied = ChatColor.GREEN + "OCCUPIED";
}
statement.executeUpdate(queryOcc);
sender.sendMessage(plugin.pluginName + " TARDIS occupation was set to: " + occupied);
return true;
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Couldn't get TARDIS: " + e);
}
}
}
if (args[0].equalsIgnoreCase("comehere")) {
if (player.hasPermission("tardis.timetravel")) {
final Location eyeLocation = player.getTargetBlock(transparent, 50).getLocation();
if (!plugin.getConfig().getBoolean("include_default_world")
&& plugin.getConfig().getBoolean("default_world")
&& eyeLocation
.getWorld()
.getName()
.equals(plugin.getConfig().getString("default_world_name"))) {
sender.sendMessage(
plugin.pluginName
+ " The server admin will not allow you to bring the TARDIS to this world!");
return true;
}
Statement statement = null;
ResultSet rs = null;
try {
Connection connection = service.getConnection();
statement = connection.createStatement();
rs = service.getTardis(player.getName(), "*");
if (!rs.next()) {
sender.sendMessage(
plugin.pluginName
+ " You must be the Timelord of the TARDIS to use this command!");
return false;
}
final TARDISConstants.COMPASS d =
TARDISConstants.COMPASS.valueOf(rs.getString("direction"));
TARDISTimetravel tt = new TARDISTimetravel(plugin);
int[] start_loc = tt.getStartLocation(eyeLocation, d);
int count =
tt.safeLocation(
start_loc[0] - 3,
eyeLocation.getBlockY() + 1,
start_loc[2],
start_loc[1],
start_loc[3],
eyeLocation.getWorld(),
d);
if (count > 0) {
sender.sendMessage(
plugin.pluginName
+ " That location would grief existing blocks! Try somewhere else!");
return true;
}
if (plugin.worldGuardOnServer
&& plugin.getConfig().getBoolean("respect_worldguard")) {
if (plugin.wgchk.cantBuild(player, eyeLocation)) {
sender.sendMessage(
plugin.pluginName + "That location is protected by WorldGuard!");
return false;
}
}
if (player.hasPermission("tardis.exile")) {
String areaPerm = plugin.ta.getExileArea(player);
if (plugin.ta.areaCheckInExile(areaPerm, eyeLocation)) {
sender.sendMessage(
plugin.pluginName
+ "You exile status does not allow you to bring the TARDIS to this location!");
return false;
}
}
if (plugin.ta.areaCheckLocPlayer(player, eyeLocation)) {
sender.sendMessage(
plugin.pluginName
+ "You do not have permission ["
+ plugin.trackPerm.get(player.getName())
+ "] to bring the TARDIS to this location!");
plugin.trackPerm.remove(player.getName());
return false;
}
Material m = player.getTargetBlock(transparent, 50).getType();
if (m != Material.SNOW) {
int yplusone = eyeLocation.getBlockY();
eyeLocation.setY(yplusone + 1);
}
// set save location
final Player p = player;
final int id = rs.getInt("tardis_id");
String badsave = rs.getString("save");
boolean chamtmp;
if (!plugin.getConfig().getBoolean("chameleon")) {
chamtmp = false;
} else {
chamtmp = rs.getBoolean("chamele_on");
}
final boolean cham = chamtmp;
String[] saveData = badsave.split(":");
World w = plugin.getServer().getWorld(saveData[0]);
int x, y, z;
x = plugin.utils.parseNum(saveData[1]);
y = plugin.utils.parseNum(saveData[2]);
z = plugin.utils.parseNum(saveData[3]);
final Location oldSave = w.getBlockAt(x, y, z).getLocation();
String comehere =
eyeLocation.getWorld().getName()
+ ":"
+ eyeLocation.getBlockX()
+ ":"
+ eyeLocation.getBlockY()
+ ":"
+ eyeLocation.getBlockZ();
String querySave =
"UPDATE tardis SET save = '"
+ comehere
+ "', current = '"
+ comehere
+ "' WHERE tardis_id = "
+ id;
statement.executeUpdate(querySave);
// how many travellers are in the TARDIS?
plugin.utils.updateTravellerCount(id);
sender.sendMessage(plugin.pluginName + " The TARDIS is coming...");
long delay = 100L;
if (plugin.getServer().getPluginManager().getPlugin("Spout") != null
&& SpoutManager.getPlayer(player).isSpoutCraftEnabled()) {
SpoutManager.getSoundManager()
.playCustomSoundEffect(
plugin,
SpoutManager.getPlayer(player),
"https://dl.dropbox.com/u/53758864/tardis_land.mp3",
false,
eyeLocation,
9,
75);
delay = 400L;
}
Bukkit.getServer()
.getScheduler()
.scheduleSyncDelayedTask(
plugin,
new Runnable() {
@Override
public void run() {
plugin.destroyer.destroySign(oldSave, d);
plugin.destroyer.destroyTorch(oldSave);
plugin.destroyer.destroyBlueBox(oldSave, d, id, false);
plugin.builder.buildOuterTARDIS(id, eyeLocation, d, cham, p, false);
}
},
delay);
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + "Couldn't get TARDIS: " + e);
} finally {
try {
if (rs != null) {
rs.close();
}
if (statement != null) {
statement.close();
}
} catch (Exception e) {
}
}
return true;
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("home")) {
if (player.hasPermission("tardis.timetravel")) {
Location eyeLocation = player.getTargetBlock(transparent, 50).getLocation();
if (!plugin.getConfig().getBoolean("include_default_world")
&& plugin.getConfig().getBoolean("default_world")
&& eyeLocation
.getWorld()
.getName()
.equals(plugin.getConfig().getString("default_world_name"))) {
sender.sendMessage(
plugin.pluginName
+ " The server admin will not allow you to set the TARDIS home in this world!");
return true;
}
if (plugin.worldGuardOnServer && plugin.getConfig().getBoolean("respect_worldguard")) {
if (plugin.wgchk.cantBuild(player, eyeLocation)) {
sender.sendMessage(plugin.pluginName + "That location is protected by WorldGuard!");
return false;
}
}
if (plugin.ta.areaCheckLocPlayer(player, eyeLocation)) {
sender.sendMessage(
plugin.pluginName
+ "You do not have permission ["
+ plugin.trackPerm.get(player.getName())
+ "] to set the TARDIS home to this location!");
plugin.trackPerm.remove(player.getName());
return false;
}
Material m = player.getTargetBlock(transparent, 50).getType();
if (m != Material.SNOW) {
int yplusone = eyeLocation.getBlockY();
eyeLocation.setY(yplusone + 1);
}
// set save location
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "*");
if (!rs.next()) {
sender.sendMessage(
plugin.pluginName
+ " You must be the Timelord of the TARDIS to use this command!");
return false;
}
int id = rs.getInt("tardis_id");
rs.close();
String sethome =
eyeLocation.getWorld().getName()
+ ":"
+ eyeLocation.getBlockX()
+ ":"
+ eyeLocation.getBlockY()
+ ":"
+ eyeLocation.getBlockZ();
String querySave =
"UPDATE tardis SET home = '" + sethome + "' WHERE tardis_id = " + id;
statement.executeUpdate(querySave);
statement.close();
sender.sendMessage(plugin.pluginName + " The new TARDIS home was set!");
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + "Couldn't get TARDIS: " + e);
}
return true;
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("update")) {
if (player.hasPermission("tardis.update")) {
String[] validBlockNames = {
"door",
"button",
"save-repeater",
"x-repeater",
"z-repeater",
"y-repeater",
"chameleon",
"save-sign"
};
if (args.length < 2) {
sender.sendMessage(plugin.pluginName + " Too few command arguments!");
return false;
}
if (!Arrays.asList(validBlockNames).contains(args[1].toLowerCase(Locale.ENGLISH))) {
player.sendMessage(
plugin.pluginName
+ " That is not a valid TARDIS block name! Try one of : door|button|save-repeater|x-repeater|z-repeater|y-repeater|chameleon|save-sign");
return false;
}
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
String queryInTARDIS =
"SELECT tardis.owner, travellers.player FROM tardis, travellers WHERE travellers.player = '"
+ player.getName()
+ "' AND travellers.tardis_id = tardis.tardis_id AND travellers.player = tardis.owner";
ResultSet rs = statement.executeQuery(queryInTARDIS);
if (rs == null || !rs.next()) {
sender.sendMessage(
plugin.pluginName
+ " Either you are not a Timelord, or you are not inside your TARDIS. You need to be both to run this command!");
return false;
}
rs.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Update TARDIS Blocks Error: " + e);
}
plugin.trackPlayers.put(player.getName(), args[1].toLowerCase());
player.sendMessage(
plugin.pluginName
+ " Click the TARDIS "
+ args[1].toLowerCase()
+ " to update its position.");
return true;
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("rebuild") || args[0].equalsIgnoreCase("hide")) {
if (player.hasPermission("tardis.rebuild")) {
String save = "";
World w;
int x, y, z, id = -1;
TARDISConstants.COMPASS d = TARDISConstants.COMPASS.EAST;
boolean cham = false;
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "*");
if (!rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
save = rs.getString("save");
id = rs.getInt("tardis_id");
if (!plugin.getConfig().getBoolean("chameleon")) {
cham = false;
} else {
cham = rs.getBoolean("chamele_on");
}
d = TARDISConstants.COMPASS.valueOf(rs.getString("direction"));
rs.close();
statement.close();
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Select TARDIS By Owner Error: " + e);
}
String[] save_data = save.split(":");
w = plugin.getServer().getWorld(save_data[0]);
x = plugin.utils.parseNum(save_data[1]);
y = plugin.utils.parseNum(save_data[2]);
z = plugin.utils.parseNum(save_data[3]);
Location l = new Location(w, x, y, z);
if (args[0].equalsIgnoreCase("rebuild")) {
plugin.builder.buildOuterTARDIS(id, l, d, cham, player, true);
sender.sendMessage(plugin.pluginName + " The TARDIS Police Box was rebuilt!");
return true;
}
if (args[0].equalsIgnoreCase("hide")) {
// remove torch
plugin.destroyer.destroyTorch(l);
// remove sign
plugin.destroyer.destroySign(l, d);
// remove blue box
plugin.destroyer.destroyBlueBox(l, d, id, true);
sender.sendMessage(
plugin.pluginName
+ " The TARDIS Police Box was hidden! Use "
+ ChatColor.GREEN
+ "/tardis rebuild"
+ ChatColor.RESET
+ " to show it again.");
return true;
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("list")) {
if (player.hasPermission("tardis.list")) {
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "owner");
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
if (args.length < 2
|| (!args[1].equalsIgnoreCase("saves")
&& !args[1].equalsIgnoreCase("companions")
&& !args[1].equalsIgnoreCase("areas"))) {
sender.sendMessage(
plugin.pluginName
+ " You need to specify which TARDIS list you want to view! [saves|companions|areas]");
return false;
}
TARDISConstants.list(player, args[1]);
rs.close();
statement.close();
return true;
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " List Companions Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("find")) {
if (player.hasPermission("tardis.find")) {
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "save");
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
String loc = rs.getString("save");
String[] findData = loc.split(":");
sender.sendMessage(
plugin.pluginName
+ " TARDIS was left at "
+ findData[0]
+ " at x: "
+ findData[1]
+ " y: "
+ findData[2]
+ " z: "
+ findData[3]);
rs.close();
statement.close();
return true;
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Find TARDIS Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("add")) {
if (player.hasPermission("tardis.add")) {
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
String queryList =
"SELECT tardis_id, companions FROM tardis WHERE owner = '"
+ player.getName()
+ "'";
ResultSet rs = statement.executeQuery(queryList);
String comps;
int id;
if (!rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
} else {
id = rs.getInt("tardis_id");
comps = rs.getString("companions");
}
if (args.length < 2) {
sender.sendMessage(plugin.pluginName + " Too few command arguments!");
return false;
}
if (!args[1].matches("[A-Za-z0-9_]{2,16}")) {
sender.sendMessage(
plugin.pluginName + "That doesn't appear to be a valid username");
return false;
} else {
String queryCompanions;
if (!rs.wasNull() && !comps.equals("")) {
// add to the list
String newList = comps + ":" + args[1].toLowerCase();
queryCompanions =
"UPDATE tardis SET companions = '" + newList + "' WHERE tardis_id = " + id;
} else {
// make a list
queryCompanions =
"UPDATE tardis SET companions = '"
+ args[1].toLowerCase()
+ "' WHERE tardis_id = "
+ id;
}
statement.executeUpdate(queryCompanions);
player.sendMessage(
plugin.pluginName
+ " You added "
+ ChatColor.GREEN
+ args[1]
+ ChatColor.RESET
+ " as a TARDIS companion.");
rs.close();
statement.close();
return true;
}
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Companion Save Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("remove")) {
if (player.hasPermission("tardis.add")) {
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
String queryList =
"SELECT tardis_id, companions FROM tardis WHERE owner = '"
+ player.getName()
+ "'";
ResultSet rs = statement.executeQuery(queryList);
String comps;
int id;
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
} else {
id = rs.getInt("tardis_id");
comps = rs.getString("companions");
if (rs.wasNull() || comps.equals("")) {
sender.sendMessage(
plugin.pluginName + " You have not added any TARDIS companions yet!");
return true;
}
rs.close();
}
if (args.length < 2) {
sender.sendMessage(plugin.pluginName + " Too few command arguments!");
return false;
}
if (!args[1].matches("[A-Za-z0-9_]{2,16}")) {
sender.sendMessage(
plugin.pluginName + "That doesn't appear to be a valid username");
return false;
} else {
String[] split = comps.split(":");
StringBuilder buf = new StringBuilder();
String newList = "";
if (split.length > 1) {
// recompile string without the specified player
for (String c : split) {
if (!c.equals(args[1].toLowerCase())) {
// add to new string
buf.append(c).append(":");
}
}
// remove trailing colon
newList = buf.toString();
newList = newList.substring(0, newList.length() - 1);
} else {
newList = "";
}
String queryCompanions =
"UPDATE tardis SET companions = '" + newList + "' WHERE tardis_id = " + id;
statement.executeUpdate(queryCompanions);
player.sendMessage(
plugin.pluginName
+ " You removed "
+ ChatColor.GREEN
+ args[1]
+ ChatColor.RESET
+ " as a TARDIS companion.");
statement.close();
return true;
}
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Companion Save Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("save")) {
if (player.hasPermission("tardis.save")) {
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "*");
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
if (args.length < 2) {
sender.sendMessage(plugin.pluginName + " Too few command arguments!");
return false;
}
if (!args[1].matches("[A-Za-z0-9_]{2,16}")) {
sender.sendMessage(
plugin.pluginName
+ "That doesn't appear to be a valid save name (it may be too long or contains spaces).");
return false;
} else {
String cur = rs.getString("current");
String sav = rs.getString("save");
int id = rs.getInt("tardis_id");
String[] curDest;
// get current destination
String queryTraveller =
"SELECT * FROM travellers WHERE player = '" + player.getName() + "'";
ResultSet rsTraveller = statement.executeQuery(queryTraveller);
if (rsTraveller != null && rsTraveller.next()) {
// inside TARDIS
curDest = cur.split(":");
} else {
// outside TARDIS
curDest = sav.split(":");
}
PreparedStatement psSave =
connection.prepareStatement(
"INSERT INTO destinations (tardis_id,dest_name, world, x, y, z) VALUES (?,?,?,?,?,?)");
psSave.setInt(1, id);
psSave.setString(2, args[1]);
psSave.setString(3, curDest[0]);
psSave.setInt(4, plugin.utils.parseNum(curDest[1]));
psSave.setInt(5, plugin.utils.parseNum(curDest[2]));
psSave.setInt(6, plugin.utils.parseNum(curDest[3]));
psSave.executeUpdate();
rs.close();
rsTraveller.close();
statement.close();
psSave.close();
sender.sendMessage(
plugin.pluginName + " The location '" + args[1] + "' was saved successfully.");
return true;
}
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Location Save Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("removesave")) {
if (player.hasPermission("tardis.save")) {
if (args.length < 2) {
sender.sendMessage(plugin.pluginName + " Too few command arguments!");
return false;
}
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "tardis_id");
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
int id = rs.getInt("tardis_id");
String queryDest =
"SELECT dest_id FROM destinations WHERE dest_name = '"
+ args[1]
+ "' AND tardis_id = "
+ id;
ResultSet rsDest = statement.executeQuery(queryDest);
if (rsDest == null || !rsDest.next()) {
sender.sendMessage(
plugin.pluginName + " Could not find a saved destination with that name!");
return false;
}
int destID = rsDest.getInt("dest_id");
String queryDelete = "DELETE FROM destinations WHERE dest_id = " + destID;
statement.executeUpdate(queryDelete);
sender.sendMessage(
plugin.pluginName + " The destination " + args[1] + " was deleted!");
return true;
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Destination Save Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("setdest")) {
if (player.hasPermission("tardis.save")) {
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "*");
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
if (args.length < 2) {
sender.sendMessage(plugin.pluginName + " Too few command arguments!");
return false;
}
if (!args[1].matches("[A-Za-z0-9_]{2,16}")) {
sender.sendMessage(
plugin.pluginName
+ "The destination name must be between 2 and 16 characters and have no spaces!");
return false;
} else {
int id = rs.getInt("tardis_id");
// get location player is looking at
Block b = player.getTargetBlock(transparent, 50);
Location l = b.getLocation();
if (!plugin.getConfig().getBoolean("include_default_world")
&& plugin.getConfig().getBoolean("default_world")
&& l.getWorld()
.getName()
.equals(plugin.getConfig().getString("default_world_name"))) {
sender.sendMessage(
plugin.pluginName
+ " The server admin will not allow you to set the TARDIS destination to this world!");
return true;
}
if (plugin.worldGuardOnServer
&& plugin.getConfig().getBoolean("respect_worldguard")) {
if (plugin.wgchk.cantBuild(player, l)) {
sender.sendMessage(
plugin.pluginName + "That location is protected by WorldGuard!");
return false;
}
}
if (player.hasPermission("tardis.exile")) {
String areaPerm = plugin.ta.getExileArea(player);
if (plugin.ta.areaCheckInExile(areaPerm, l)) {
sender.sendMessage(
plugin.pluginName
+ "You exile status does not allow you to save the TARDIS to this location!");
return false;
}
}
if (plugin.ta.areaCheckLocPlayer(player, l)) {
sender.sendMessage(
plugin.pluginName
+ "You do not have permission ["
+ plugin.trackPerm.get(player.getName())
+ "] to set the TARDIS destination to this location!");
plugin.trackPerm.remove(player.getName());
return false;
}
String dw = l.getWorld().getName();
int dx = l.getBlockX();
int dy = l.getBlockY() + 1;
int dz = l.getBlockZ();
PreparedStatement psSetDest =
connection.prepareStatement(
"INSERT INTO destinations (tardis_id, dest_name, world, x, y, z) VALUES (?,?,?,?,?,?)");
psSetDest.setInt(1, id);
psSetDest.setString(2, args[1]);
psSetDest.setString(3, dw);
psSetDest.setInt(4, dx);
psSetDest.setInt(5, dy);
psSetDest.setInt(6, dz);
psSetDest.executeUpdate();
rs.close();
statement.close();
psSetDest.close();
sender.sendMessage(
plugin.pluginName
+ " The destination '"
+ args[1]
+ "' was saved successfully.");
return true;
}
} catch (SQLException e) {
plugin.console.sendMessage(plugin.pluginName + " Destination Save Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("direction")) {
if (player.hasPermission("tardis.timetravel")) {
if (args.length < 2
|| (!args[1].equalsIgnoreCase("north")
&& !args[1].equalsIgnoreCase("west")
&& !args[1].equalsIgnoreCase("south")
&& !args[1].equalsIgnoreCase("east"))) {
sender.sendMessage(
plugin.pluginName
+ " You need to specify the compass direction e.g. north, west, south or east!");
return false;
}
try {
Connection connection = service.getConnection();
Statement statement = connection.createStatement();
ResultSet rs = service.getTardis(player.getName(), "*");
if (rs == null || !rs.next()) {
sender.sendMessage(plugin.pluginName + " " + TARDISConstants.NO_TARDIS);
return false;
}
String save = rs.getString("save");
String[] save_data = save.split(":");
int id = rs.getInt("tardis_id");
boolean cham;
if (!plugin.getConfig().getBoolean("chameleon")) {
cham = false;
} else {
cham = rs.getBoolean("chamele_on");
}
String dir = args[1].toUpperCase();
TARDISConstants.COMPASS old_d =
TARDISConstants.COMPASS.valueOf(rs.getString("direction"));
String queryDirectionUpdate =
"UPDATE tardis SET direction = '" + dir + "' WHERE tardis_id = " + id;
statement.executeUpdate(queryDirectionUpdate);
String queryDoorDirectionUpdate =
"UPDATE doors SET door_direction = '"
+ dir
+ "' WHERE door_type = 0 AND tardis_id = "
+ id;
statement.executeUpdate(queryDoorDirectionUpdate);
World w = plugin.getServer().getWorld(save_data[0]);
int x = plugin.utils.parseNum(save_data[1]);
int y = plugin.utils.parseNum(save_data[2]);
int z = plugin.utils.parseNum(save_data[3]);
Location l = new Location(w, x, y, z);
TARDISConstants.COMPASS d = TARDISConstants.COMPASS.valueOf(dir);
plugin.destroyer.destroySign(l, old_d);
plugin.builder.buildOuterTARDIS(id, l, d, cham, player, true);
rs.close();
statement.close();
return true;
} catch (SQLException e) {
plugin.console.sendMessage(
plugin.pluginName + " Quotes Preferences Save Error: " + e);
}
} else {
sender.sendMessage(plugin.pluginName + TARDISConstants.NO_PERMS_MESSAGE);
return false;
}
}
if (args[0].equalsIgnoreCase("namekey")) {
Material m = Material.getMaterial(plugin.getConfig().getString("key"));
ItemStack is = player.getItemInHand();
if (!is.getType().equals(m)) {
sender.sendMessage(plugin.pluginName + "You can only rename the TARDIS key!");
return false;
}
int count = args.length;
if (count < 2) {
return false;
}
StringBuilder buf = new StringBuilder(args[1]);
for (int i = 2; i < count; i++) {
buf.append(" ").append(args[i]);
}
String tmp = buf.toString();
if (is != null) {
TARDISItemRenamer ir = new TARDISItemRenamer(is);
ir.setName(tmp, false);
}
sender.sendMessage(plugin.pluginName + "TARDIS key renamed to '" + tmp + "'");
return true;
}
if (args[0].equalsIgnoreCase("help")) {
if (args.length == 1) {
sender.sendMessage(TARDISConstants.COMMANDS.split("\n"));
return true;
}
if (args.length == 2) {
switch (TARDISConstants.fromString(args[1])) {
case CREATE:
sender.sendMessage(TARDISConstants.COMMAND_CREATE.split("\n"));
break;
case DELETE:
sender.sendMessage(TARDISConstants.COMMAND_DELETE.split("\n"));
break;
case TIMETRAVEL:
sender.sendMessage(TARDISConstants.COMMAND_TIMETRAVEL.split("\n"));
break;
case LIST:
sender.sendMessage(TARDISConstants.COMMAND_LIST.split("\n"));
break;
case FIND:
sender.sendMessage(TARDISConstants.COMMAND_FIND.split("\n"));
break;
case SAVE:
sender.sendMessage(TARDISConstants.COMMAND_SAVE.split("\n"));
break;
case REMOVESAVE:
sender.sendMessage(TARDISConstants.COMMAND_REMOVESAVE.split("\n"));
break;
case ADD:
sender.sendMessage(TARDISConstants.COMMAND_ADD.split("\n"));
break;
case TRAVEL:
sender.sendMessage(TARDISConstants.COMMAND_TRAVEL.split("\n"));
break;
case UPDATE:
sender.sendMessage(TARDISConstants.COMMAND_UPDATE.split("\n"));
break;
case REBUILD:
sender.sendMessage(TARDISConstants.COMMAND_REBUILD.split("\n"));
break;
case CHAMELEON:
sender.sendMessage(TARDISConstants.COMMAND_CHAMELEON.split("\n"));
break;
case SFX:
sender.sendMessage(TARDISConstants.COMMAND_SFX.split("\n"));
break;
case PLATFORM:
sender.sendMessage(TARDISConstants.COMMAND_PLATFORM.split("\n"));
break;
case SETDEST:
sender.sendMessage(TARDISConstants.COMMAND_SETDEST.split("\n"));
break;
case HOME:
sender.sendMessage(TARDISConstants.COMMAND_HOME.split("\n"));
break;
case HIDE:
sender.sendMessage(TARDISConstants.COMMAND_HIDE.split("\n"));
break;
case VERSION:
sender.sendMessage(TARDISConstants.COMMAND_HIDE.split("\n"));
break;
case ADMIN:
sender.sendMessage(TARDISConstants.COMMAND_ADMIN.split("\n"));
break;
case AREA:
sender.sendMessage(TARDISConstants.COMMAND_AREA.split("\n"));
break;
default:
sender.sendMessage(TARDISConstants.COMMANDS.split("\n"));
}
}
return true;
}
}
}
// If the above has happened the function will break and return true. if this hasn't happened
// then value of false will be returned.
return false;
}
