Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- }/*else if(args[0].equals("stats")) {
- if(p.hasPermission("stats.jumblehill")) {
- String nameselect = "SELECT * FROM " + table + " WHERE shopname = '" + cleantext +"';";
- String itemselect = "SELECT * FROM " + itemtable + " WHERE itemname = '" + args[1] +"';";
- String itemremove = "DELETE FROM " + itemtable + " WHERE itemname = '" + args[1] +"';";
- try {
- Statement statement = c.createStatement();
- ResultSet res = statement.executeQuery(nameselect);
- Statement statement2 = c.createStatement();
- ResultSet res2 = statement2.executeQuery(itemselect);
- if(res.next()) {
- if(res.getString("owner").equals(p.getName())) {
- if(res2.next()) {
- if(res2.getString("itemname").equals(args[1]) ) {
- Statement statement3 = c.createStatement();
- statement3.executeUpdate(itemremove);
- p.sendMessage(intro + ChatColor.GREEN + "Item Sucessfully Removed!");
- }
- } else {
- p.sendMessage(intro + ChatColor.RED + "This Item Isn't In That Shop!");
- }
- } else {
- p.sendMessage(intro + ChatColor.RED + "Sorry, You Don't Own This Shop!");
- }
- } else {
- p.sendMessage(intro + ChatColor.RED + "Error! No Shop With That Name Exists!");
- }
- } catch (SQLException e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- }
- }*/
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement