예제 #1
0
 public static OfflinePlayer getChamp(GodType type) {
   OfflinePlayer p = null;
   ResultSet r = null;
   try {
     r =
         (new SQLQuery(
                 (new String(
                     "select champ from £.gods where idGod="
                         + String.valueOf(Utility.getDBNumberFromGodType(type)))),
                 ConfigManager.getMySQLConfig())
             .excecuteQuery());
   } catch (MySQLSyntaxErrorException e1) {
     e1.printStackTrace();
   }
   try {
     while (r.next()) {
       String s = r.getString(1);
       if (s != null) {
         p = Bukkit.getPlayer(r.getString(1));
       }
     }
   } catch (SQLException e) {
     return null;
   }
   return p;
 }
예제 #2
0
 public static void createDatabase(String string) {
   ConfigManager.reloadConfig();
   MySQLConfig msqlc2 = ConfigManager.getMySQLConfig();
   (new SQLQuery("CREATE DATABASE IF NOT EXISTS £;", msqlc2)).excecuteUpdate();
   (new SQLQuery(
           "CREATE TABLE IF NOT EXISTS £.`locations` (`id` int(11) NOT NULL AUTO_INCREMENT, `world` varchar(45) NOT NULL, `chunkx` int(11) NOT NULL, `chunkz` int(11) NOT NULL, `x` int(11) NOT NULL,  `y` int(11) NOT NULL, `z` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1",
           msqlc2))
       .excecuteUpdate();
   (new SQLQuery(
           "CREATE TABLE IF NOT EXISTS £.`gods` (`idGod` int(11) NOT NULL AUTO_INCREMENT, `champ` varchar(45) DEFAULT NULL, `Descrizione` varchar(45) DEFAULT NULL, `lastActivated` date DEFAULT NULL, PRIMARY KEY (`idGod`)) ENGINE=InnoDB DEFAULT CHARSET=latin1",
           msqlc2))
       .excecuteUpdate();
   (new SQLQuery(
           "CREATE TABLE IF NOT EXISTS £.`followers` (`id` int(11) NOT NULL AUTO_INCREMENT,`follower` varchar(45) NOT NULL,`reputation` int(11) NOT NULL, `points` int(11) NOT NULL,`god` int(11) NOT NULL,`lastpray` date DEFAULT NULL, `lastheal` date DEFAULT NULL, `priest` binary NOT NULL DEFAULT FALSE,PRIMARY KEY (`id`),KEY `FollowerGod_idx` (`god`),CONSTRAINT `FollowerGod` FOREIGN KEY (`god`) REFERENCES £.`gods` (`idGod`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1",
           msqlc2))
       .excecuteUpdate();
   (new SQLQuery(
           "CREATE TABLE IF NOT EXISTS £.`altar`(`id` int(11) NOT NULL AUTO_INCREMENT, `god` int(11) NOT NULL,`type` varchar(20) NOT NULL, `location` int(11) NOT NULL, `owner` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `FK_god_idx` (`god`), KEY `FK_location_altar_idx` (`location`), KEY `FK_priest_idx`(`priest`), CONSTRAINT `FK_god` FOREIGN KEY (`god`) REFERENCES £.`gods` (`idGod`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_location_altar` FOREIGN KEY (`location`) REFERENCES £.`locations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_priest` FOREIGN KEY (`owner`) REFERENCES £.`followers` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1;",
           msqlc2))
       .excecuteUpdate();
   (new SQLQuery(
           "CREATE TABLE IF NOT EXISTS £.`nonnatural` (`id` int(11) NOT NULL AUTO_INCREMENT, `location` int(11) NOT NULL,`dayPlaced` date NOT NULL, PRIMARY KEY (`id`),KEY `FK_loc_idx` (`location`),CONSTRAINT `FK_loc` FOREIGN KEY (`location`) REFERENCES £.`locations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1",
           msqlc2))
       .excecuteUpdate();
   (new SQLQuery(
           "CREATE TABLE IF NOT EXISTS £.`thrones` (`god` int(11) NOT NULL,`hasThrone` tinyint(1) NOT NULL, `location` int(11) DEFAULT NULL,PRIMARY KEY (`god`), KEY `fkgod_idx` (`god`), KEY `fklocation_idx` (`location`), CONSTRAINT `fkgod` FOREIGN KEY (`god`) REFERENCES £.`gods` (`idGod`) ON DELETE NO ACTION ON UPDATE NO ACTION,  CONSTRAINT `fklocation` FOREIGN KEY (`location`) REFERENCES £.`locations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1",
           msqlc2))
       .excecuteUpdate();
   msqlc = msqlc2;
   for (int i = 1; i < 5; i++) {
     (new SQLQuery("insert into £.gods(descrizione) values ('desc')", msqlc)).excecuteUpdate();
     (new SQLQuery("insert into £.thrones(god,hasthrone) values (" + i + ",0)", msqlc))
         .excecuteUpdate();
   }
 }
예제 #3
0
public class DatabaseManager {
  private static MySQLConfig msqlc = ConfigManager.getMySQLConfig();

  public static OfflinePlayer getChamp(GodType type) {
    OfflinePlayer p = null;
    ResultSet r = null;
    try {
      r =
          (new SQLQuery(
                  (new String(
                      "select champ from £.gods where idGod="
                          + String.valueOf(Utility.getDBNumberFromGodType(type)))),
                  ConfigManager.getMySQLConfig())
              .excecuteQuery());
    } catch (MySQLSyntaxErrorException e1) {
      e1.printStackTrace();
    }
    try {
      while (r.next()) {
        String s = r.getString(1);
        if (s != null) {
          p = Bukkit.getPlayer(r.getString(1));
        }
      }
    } catch (SQLException e) {
      return null;
    }
    return p;
  }

  public static void testDB() throws DatabaseException {
    try {
      ResultSet r = new SQLQuery("select * from £.thrones;", msqlc).excecuteQuery();
      r = new SQLQuery("select * from £.thrones;", msqlc).excecuteQuery();
      int cnt = 0;
      while (r.next()) {
        cnt++;
      }
      if (cnt < 4) {
        throw new DatabaseException("Exception", DatabaseExceptionType.NOT_COMPLETE);
      }
      r = new SQLQuery("select * from £.thrones;", msqlc).excecuteQuery();
      r = new SQLQuery("select * from £.thrones;", msqlc).excecuteQuery();
      r = new SQLQuery("select * from £.thrones;", msqlc).excecuteQuery();
      r = new SQLQuery("select * from £.thrones;", msqlc).excecuteQuery();
    } catch (MySQLSyntaxErrorException e) {
      throw new DatabaseException("Exception", DatabaseExceptionType.NOT_FOUND);
    } catch (SQLException e) {
      throw new DatabaseException("Exception", DatabaseExceptionType.CONNECTION);
    }
  }

  public static FollowerData getFollower(OfflinePlayer p) {
    try {
      String sq =
          "select reputation,god,lastpray,lastheal,points from £.followers where follower like '"
              + p.getName()
              + "';";
      ResultSet r = (new SQLQuery(new String(sq), msqlc)).excecuteQuery();
      boolean empty = true;
      while (r.next()) {
        empty = false;
        break;
      }
      if (!empty) {
        r.first();
        GregorianCalendar c = new GregorianCalendar();
        Date c2 = r.getDate(3), d2 = r.getDate(4);
        if (c2 == null) c = null;
        else c.setTimeInMillis(c2.getTime());
        GregorianCalendar d = new GregorianCalendar();
        if (d2 == null) d = null;
        else d.setTimeInMillis(d2.getTime());
        return new FollowerData(
            r.getInt(1),
            r.getInt(5),
            GodManager.getGod(Utility.getGodTypeFromDBNumber(r.getInt(2))),
            c,
            d,
            true);
      }
    } catch (SQLException ex) {
      if (p.isOnline())
        p.getPlayer()
            .sendMessage(Utility.formattedMessage(Utility.getMessage("msg.followers.loadfail")));
    }
    return null;
  }

  public static void setChamp(God g, OfflinePlayer p) {
    String s =
        new String(
            "update £.gods set champ="
                + ((p == null) ? "NULL" : "'" + p.getName() + "'")
                + " where idGod="
                + (new Integer(Utility.getDBNumberFromGodType(g.getGodType()))));
    Bukkit.getServer().broadcastMessage(s);
    (new SQLQuery(s, msqlc)).excecuteUpdate();
  }

  public static void saveFollower(
      Player p,
      int rep,
      int points,
      God g,
      GregorianCalendar lastPrayed,
      GregorianCalendar lastHealed) {
    String sr = new String("select id from £.followers where follower like '" + p.getName() + "';");
    ResultSet r = null;
    try {
      r = (new SQLQuery(sr, msqlc)).excecuteQuery();
    } catch (MySQLSyntaxErrorException e) {
      e.printStackTrace();
    }
    boolean empty = true;
    try {
      String s;
      while (r.next()) {
        empty = false;
      }
      if (empty) {
        DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        s =
            new String(
                    "insert into £.followers(follower,reputation,points,god,lastpray,lastheal) values('"
                        + p.getName())
                + "',"
                + rep
                + ","
                + points
                + ","
                + Utility.getDBNumberFromGodType(g.getGodType())
                + ",'"
                + df.format(lastPrayed.getTime())
                + "','"
                + df.format(lastHealed.getTime()).toString()
                + "');";
      } else if (rep == -1) {
        s = new String("delete from £.followers where id=" + r.getInt(1) + ";");
      } else {
        r.first();
        DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
        s =
            new String(
                "update £.followers set lastpray='"
                    + df.format(lastPrayed.getTime())
                    + "', points="
                    + points
                    + ", reputation="
                    + rep
                    + ", god="
                    + Utility.getDBNumberFromGodType(g.getGodType())
                    + ", lastheal='"
                    + df.format(lastHealed.getTime())
                    + "' where id="
                    + r.getInt(1)
                    + ";");
      }
      new SQLQuery(s, msqlc).excecuteUpdate();
    } catch (SQLException e2) {
      e2.printStackTrace();
    }
  }

  public static void loadAltars() {
    ResultSet r = null;
    try {
      r =
          (new SQLQuery(
                  new String(
                      "select a.god,a.type,l.x,l.y,l.z,l.world,a.id,a.owner from £.altar a, £.locations l where a.location=l.id;"),
                  msqlc))
              .excecuteQuery();
    } catch (MySQLSyntaxErrorException e1) {
      e1.printStackTrace();
    }
    try {
      if (r != null) {
        while (r.next()) {
          AltarManager.loadAltar(
              GodManager.getGod(Utility.getGodTypeFromDBNumber(r.getInt(1))),
              AltarType.valueOf(r.getString(2)),
              new Location(
                  Bukkit.getServer().getWorld(r.getString(6)),
                  r.getInt(3),
                  r.getInt(4),
                  r.getInt(5)),
              r.getInt(7),
              Bukkit.getPlayer(r.getString(8)));
        }
      }
    } catch (SQLException e) {
      return;
    }
  }

  public static void loadBlocks(Chunk chunk) {
    ResultSet r = null;
    try {
      r =
          (new SQLQuery(
                  "select l.world,l.x,l.y,l.z,b.dayPlaced,b.id from £.locations l, £.nonnatural b where l.id=b.location and l.chunkx="
                      + chunk.getX()
                      + " and l.chunkz="
                      + chunk.getZ()
                      + ";",
                  msqlc))
              .excecuteQuery();
    } catch (MySQLSyntaxErrorException e1) {
      e1.printStackTrace();
    }
    try {
      while (r.next()) {
        GregorianCalendar g = new GregorianCalendar();
        g.setTime(r.getDate(5));
        BlockManager.loadBlock(
            (new Location(Bukkit.getWorld(r.getString(1)), r.getInt(2), r.getInt(3), r.getInt(4)))
                .getBlock(),
            g,
            r.getInt(6));
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }

  public static void loadThrones() {
    for (GodType t : GodType.values()) {
      if (GodManager.isActive(t)) {
        String str =
            "select l.x,l.y,l.z,g.hasThrone,l.world from £.thrones g,£.locations l where g.location=l.id and god="
                + Utility.getDBNumberFromGodType(t)
                + ";";
        ResultSet r = null;
        try {
          r = (new SQLQuery(str, msqlc)).excecuteQuery();
        } catch (MySQLSyntaxErrorException e1) {
          e1.printStackTrace();
        }
        try {
          while (r.next()) {
            if (r.getBoolean(4)) {
              Location l =
                  new Location(
                      Bukkit.getServer().getWorld(r.getString(5)),
                      r.getInt(1),
                      r.getInt(2),
                      r.getInt(3));
              GodManager.getGod(t).setThrone((Sign) l.getBlock().getState());
              AltarManager.loadAltar(GodManager.getGod(t), AltarType.THRONE, l, 1, null);
              Sign s = (Sign) l.getBlock().getState();
              if (!s.getLine(1).equalsIgnoreCase(GodManager.getGod(t).getGodName()))
                s.setLine(1, GodManager.getGod(t).getGodName().toUpperCase());
            }
          }
        } catch (IndexOutOfBoundsException e) {
          e.printStackTrace();
        } catch (SQLException e) {
          e.printStackTrace();
        }
      }
    }
  }

  public static void loadChamps() {
    for (int i = 1; i <= GodManager.getActiveGods(); i++) {
      GodType t = Utility.getGodTypeFromDBNumber(i);
      ResultSet r = null;
      try {
        r =
            (new SQLQuery(
                    new String("select lastActivated,champ from £.gods where idGod=" + i + ";"),
                    msqlc))
                .excecuteQuery();
      } catch (MySQLSyntaxErrorException e1) {
        e1.printStackTrace();
      }
      try {
        while (r.next()) {
          GregorianCalendar c = null;
          Date d = r.getDate(1);
          if (d != null) {
            c = new GregorianCalendar();
            c.setTime(r.getDate(1));
          }
          God g = GodManager.getGod(t);
          if (g != null) {
            g.setLastActivated(c);
            String s = r.getString(2);
            if (s != null) {
              OfflinePlayer p = Bukkit.getOfflinePlayer(r.getString(2));
              g.setChamp(p);
            }
          }
        }
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }

  public static void saveThrones() {
    for (int i = 1; i < 5; i++) {
      God g = GodManager.getGod(Utility.getGodTypeFromDBNumber(i));
      if (g != null) {
        if (g.hasThrone()) {
          if (AltarManager.getAltar(g.getThrone()).getDBId() == 0) {
            Location l = g.getThrone().getLocation();
            String s =
                "insert into £.locations(world,chunkx,chunkz,x,y,z) values('"
                    + l.getWorld().getName()
                    + "',"
                    + l.getChunk().getX()
                    + ","
                    + l.getChunk().getZ()
                    + ","
                    + l.getBlockX()
                    + ","
                    + l.getBlockY()
                    + ","
                    + l.getBlockZ()
                    + ")";
            (new SQLQuery(s, msqlc)).excecuteUpdate();
            ResultSet r = null;
            try {
              r = (new SQLQuery("select max(id) from £.locations", msqlc)).excecuteQuery();
            } catch (MySQLSyntaxErrorException e1) {
              e1.printStackTrace();
            }
            try {
              r.first();
              s =
                  "update £.thrones set hasThrone=true, location="
                      + r.getInt(1)
                      + " where god="
                      + i;
              (new SQLQuery(s, msqlc)).excecuteUpdate();
            } catch (SQLException e) {
              e.printStackTrace();
            }
          }
        } else {
          Bukkit.getConsoleSender().sendMessage("2");

          String s = "select location from £.thrones where god=" + i + ";";
          ResultSet r = null;
          try {
            r = (new SQLQuery(s, msqlc)).excecuteQuery();
          } catch (MySQLSyntaxErrorException e1) {
            e1.printStackTrace();
          }
          s = "update £.thrones set hasThrone=false, location=NULL where god=" + i + ";";
          (new SQLQuery(s, msqlc)).excecuteUpdate();
          try {
            while (r.next()) {
              s = "delete from £.locations where id=" + r.getInt(1) + ";";
              (new SQLQuery(s, msqlc)).excecuteUpdate();
            }
          } catch (SQLException e) {
            e.printStackTrace();
          }
        }
        GregorianCalendar gc = g.getLastActivated();
        if (gc != null) {
          DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
          String s =
              "update £.gods set lastActivated='"
                  + df.format(gc.getTime())
                  + "' where idGod="
                  + i
                  + ";";
          (new SQLQuery(s, msqlc)).excecuteUpdate();
        }
      }
    }
  }

  public static void saveAltars() {
    Set<Entry<Location, Altar>> sal = AltarManager.getAltars();
    for (Entry<Location, Altar> al : sal) {
      try {
        Altar a = al.getValue();
        if (a.marked()) {
          ResultSet r =
              new SQLQuery("select location from £.altar where id=" + a.getDBId() + ";", msqlc)
                  .excecuteQuery();
          while (r.next()) {
            new SQLQuery("delete from £.altar where id=" + a.getDBId() + ";", msqlc)
                .excecuteUpdate();
            new SQLQuery("delete from £.locations where id=" + r.getInt(1) + ";", msqlc)
                .excecuteUpdate();
          }
        } else {
          int idDB = a.getDBId();
          if (idDB == -1) {
            Location l = a.getLocation();
            new SQLQuery(
                    "insert into £.locations(world,chunkx,chunkz,x,y,z) values('"
                        + l.getWorld().getName()
                        + "',"
                        + l.getChunk().getX()
                        + ","
                        + l.getChunk().getZ()
                        + ","
                        + l.getBlockX()
                        + ","
                        + l.getBlockY()
                        + ","
                        + l.getBlockZ()
                        + ");",
                    msqlc)
                .excecuteUpdate();
            ResultSet r = new SQLQuery("select max(id) from £.locations", msqlc).excecuteQuery();
            while (r.next()) {
              new SQLQuery(
                      "insert into £.altar(god,type,location) values("
                          + Utility.getDBNumberFromGodType(a.getGod().getGodType())
                          + ",'"
                          + a.getType()
                          + "',"
                          + r.getInt(1)
                          + ")",
                      msqlc)
                  .excecuteUpdate();
            }
          }
        }
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
  }

  public static void saveBlocks(Chunk c) {
    Set<Entry<Location, PlacedBlock>> i = BlockManager.getPlacedBlocksIterator();
    for (Entry<Location, PlacedBlock> lpb : i) {
      PlacedBlock b = lpb.getValue();
      if (!b.getBlock().getChunk().equals(c)) return;
      if (b.isInDB()) {
        if (Utility.daysFromToday(b.getDayPlaced()) > 6) b.mark();
        if (b.isMarked()) {
          ResultSet r = null;
          try {
            r =
                (new SQLQuery(
                        "select location from £.nonnatural where id=" + b.getIdDB() + ";", msqlc))
                    .excecuteQuery();
          } catch (MySQLSyntaxErrorException e1) {
            e1.printStackTrace();
          }
          try {
            while (r.next()) {
              (new SQLQuery("delete from £.locations where id=" + r.getInt(1) + ";", msqlc))
                  .excecuteUpdate();
              (new SQLQuery("delete from £.nonnatural where id=" + b.getIdDB() + ";", msqlc))
                  .excecuteUpdate();
            }
          } catch (SQLException e) {
            e.printStackTrace();
          }
        }
      } else {
        Location l = b.getBlock().getLocation();
        String s =
            "insert into £.locations(world,chunkx,chunkz,x,y,z) values('"
                + l.getWorld().getName().toString()
                + "',"
                + c.getX()
                + ","
                + c.getZ()
                + ","
                + l.getBlockX()
                + ","
                + l.getBlockY()
                + ","
                + l.getBlockZ()
                + ");";
        (new SQLQuery(s, msqlc)).excecuteUpdate();
        ResultSet r = null;
        try {
          r = (new SQLQuery("select max(id) from £.locations;", msqlc)).excecuteQuery();
        } catch (MySQLSyntaxErrorException e1) {
          e1.printStackTrace();
        }
        try {
          DateFormat df = new SimpleDateFormat("yyyy-MM-dd");
          while (r.next()) {
            (new SQLQuery(
                    "insert into £.nonnatural(location,dayPlaced) values("
                        + r.getInt(1)
                        + ",'"
                        + df.format(b.getDayPlaced().getTime())
                        + "');",
                    msqlc))
                .excecuteUpdate();
          }
        } catch (SQLException e) {
          e.printStackTrace();
        }
      }
    }
  }

  public static void createDatabase(String string) {
    ConfigManager.reloadConfig();
    MySQLConfig msqlc2 = ConfigManager.getMySQLConfig();
    (new SQLQuery("CREATE DATABASE IF NOT EXISTS £;", msqlc2)).excecuteUpdate();
    (new SQLQuery(
            "CREATE TABLE IF NOT EXISTS £.`locations` (`id` int(11) NOT NULL AUTO_INCREMENT, `world` varchar(45) NOT NULL, `chunkx` int(11) NOT NULL, `chunkz` int(11) NOT NULL, `x` int(11) NOT NULL,  `y` int(11) NOT NULL, `z` int(11) NOT NULL, PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=latin1",
            msqlc2))
        .excecuteUpdate();
    (new SQLQuery(
            "CREATE TABLE IF NOT EXISTS £.`gods` (`idGod` int(11) NOT NULL AUTO_INCREMENT, `champ` varchar(45) DEFAULT NULL, `Descrizione` varchar(45) DEFAULT NULL, `lastActivated` date DEFAULT NULL, PRIMARY KEY (`idGod`)) ENGINE=InnoDB DEFAULT CHARSET=latin1",
            msqlc2))
        .excecuteUpdate();
    (new SQLQuery(
            "CREATE TABLE IF NOT EXISTS £.`followers` (`id` int(11) NOT NULL AUTO_INCREMENT,`follower` varchar(45) NOT NULL,`reputation` int(11) NOT NULL, `points` int(11) NOT NULL,`god` int(11) NOT NULL,`lastpray` date DEFAULT NULL, `lastheal` date DEFAULT NULL, `priest` binary NOT NULL DEFAULT FALSE,PRIMARY KEY (`id`),KEY `FollowerGod_idx` (`god`),CONSTRAINT `FollowerGod` FOREIGN KEY (`god`) REFERENCES £.`gods` (`idGod`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1",
            msqlc2))
        .excecuteUpdate();
    (new SQLQuery(
            "CREATE TABLE IF NOT EXISTS £.`altar`(`id` int(11) NOT NULL AUTO_INCREMENT, `god` int(11) NOT NULL,`type` varchar(20) NOT NULL, `location` int(11) NOT NULL, `owner` int(11) NOT NULL, PRIMARY KEY (`id`), KEY `FK_god_idx` (`god`), KEY `FK_location_altar_idx` (`location`), KEY `FK_priest_idx`(`priest`), CONSTRAINT `FK_god` FOREIGN KEY (`god`) REFERENCES £.`gods` (`idGod`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `FK_location_altar` FOREIGN KEY (`location`) REFERENCES £.`locations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `FK_priest` FOREIGN KEY (`owner`) REFERENCES £.`followers` (`id`) ON DELETE NO ACTION ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1;",
            msqlc2))
        .excecuteUpdate();
    (new SQLQuery(
            "CREATE TABLE IF NOT EXISTS £.`nonnatural` (`id` int(11) NOT NULL AUTO_INCREMENT, `location` int(11) NOT NULL,`dayPlaced` date NOT NULL, PRIMARY KEY (`id`),KEY `FK_loc_idx` (`location`),CONSTRAINT `FK_loc` FOREIGN KEY (`location`) REFERENCES £.`locations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1",
            msqlc2))
        .excecuteUpdate();
    (new SQLQuery(
            "CREATE TABLE IF NOT EXISTS £.`thrones` (`god` int(11) NOT NULL,`hasThrone` tinyint(1) NOT NULL, `location` int(11) DEFAULT NULL,PRIMARY KEY (`god`), KEY `fkgod_idx` (`god`), KEY `fklocation_idx` (`location`), CONSTRAINT `fkgod` FOREIGN KEY (`god`) REFERENCES £.`gods` (`idGod`) ON DELETE NO ACTION ON UPDATE NO ACTION,  CONSTRAINT `fklocation` FOREIGN KEY (`location`) REFERENCES £.`locations` (`id`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE=InnoDB DEFAULT CHARSET=latin1",
            msqlc2))
        .excecuteUpdate();
    msqlc = msqlc2;
    for (int i = 1; i < 5; i++) {
      (new SQLQuery("insert into £.gods(descrizione) values ('desc')", msqlc)).excecuteUpdate();
      (new SQLQuery("insert into £.thrones(god,hasthrone) values (" + i + ",0)", msqlc))
          .excecuteUpdate();
    }
  }

  public static ArrayList<Entry<String, Integer>> getTopFollowers(God g) {
    ArrayList<Entry<String, Integer>> list = new ArrayList<>();
    ResultSet r = null;
    try {
      r =
          (new SQLQuery(
                  "select follower,reputation from £.followers f where god="
                      + Utility.getDBNumberFromGodType(g.getGodType())
                      + " order by f.reputation limit 10;",
                  msqlc))
              .excecuteQuery();
    } catch (MySQLSyntaxErrorException e1) {
      e1.printStackTrace();
    }
    try {
      while (r.next()) {
        list.add(
            new AbstractMap.SimpleEntry<String, Integer>(r.getString(1), new Integer(r.getInt(2))));
      }
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return list;
  }

  public static void updateReputationLevel(OfflinePlayer player, int rep) {
    (new SQLQuery(
            "update table £.followers set reputation=reputation+"
                + rep
                + " where £.follower like "
                + player.getName(),
            msqlc))
        .excecuteUpdate();
  }

  public static void connectToDB() throws DatabaseException {
    try {
      msqlc.getConnection();
    } catch (SQLException e) {
      throw new DatabaseException("", DatabaseExceptionType.CONNECTION);
    }
  }

  public static void setPriest(OfflinePlayer player, boolean b) {
    (new SQLQuery(
            "update table £.followers set priest="
                + ((Boolean) b).toString()
                + " where follower like"
                + player.getName(),
            msqlc))
        .excecuteUpdate();
  }

  public static OfflinePlayer getNewChampCandidate(GodType g) {
    try {
      ResultSet r =
          (new SQLQuery(
                  "select follower from £.followers where reputation>999 and god="
                      + Utility.getDBNumberFromGodType(g)
                      + " order by reputation,points,follower limit 1",
                  msqlc))
              .excecuteQuery();
      while (r.next()) {
        return Bukkit.getOfflinePlayer(r.getString(1));
      }
      return null;
    } catch (MySQLSyntaxErrorException e) {
      e.printStackTrace();
    } catch (SQLException e) {
      e.printStackTrace();
    }
    return null;
  }

  public static void removeFollower(String name) {
    try {
      ResultSet r =
          (new SQLQuery("select id from £.followers where follower like '" + name + "';", msqlc))
              .excecuteQuery();
      r.next();
      new SQLQuery("delete from £.followers where id=" + r.getInt(1) + ";", msqlc).excecuteUpdate();
    } catch (SQLException e) {
      e.printStackTrace();
    }
  }
}