Exemple #1
0
 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();
     }
   }
 }