Exemple #1
0
 // This method loads fort flagpoles data from database
 private void loadFlagPoles() {
   Connection con = null;
   try {
     con = L2DatabaseFactory.getInstance().getConnection();
     PreparedStatement statement =
         con.prepareStatement(
             "SELECT * FROM fort_staticobjects WHERE fortId = ? AND objectType = ?");
     statement.setInt(1, getFortId());
     statement.setInt(2, 1);
     ResultSet rs = statement.executeQuery();
     while (rs.next()) {
       _flagPole =
           new L2ArtefactInstance(
               IdFactory.getInstance().getNextId(), NpcTable.getInstance().getTemplate(32027));
       _flagPole.setName(getName());
       _flagPole.spawnMe(rs.getInt("x"), rs.getInt("y"), rs.getInt("z"));
       _flagPole.setIsInvul(true);
       _flagPole.setFort(this);
     }
     rs.close();
     statement.close();
   } catch (Exception e) {
     _log.warn("Exception: loadFlagPoles(): " + e.getMessage());
     e.printStackTrace();
   } finally {
     try {
       con.close();
     } catch (Exception e) {
       _log.warn("" + e.getMessage());
       e.printStackTrace();
     }
   }
 }
Exemple #2
0
  /**
   * Show or hide flag inside flagpole<br>
   * <br>
   */
  public void setVisibleFlag(boolean val) {
    if (val) {
      if (_flag == null) {
        _flag =
            new L2NpcInstance(
                IdFactory.getInstance().getNextId(), NpcTable.getInstance().getTemplate(35062));
        _flag.spawnMe(_flagPole.getX(), _flagPole.getY(), _flagPole.getZ());
        _flag.setIsInvul(true);
      }

    } else if (_flag != null) {
      _flag.deleteMe();
      _flag = null;
    }
  }