예제 #1
0
  /**
   * 储存聊天
   *
   * @param pc
   * @param target
   * @param text
   * @param type
   */
  public void storeChat(
      final L1PcInstance pc, final L1PcInstance target, final String text, final int type) {
    if (!this.isLoggingTarget(type)) {
      return;
    }

    // type
    // 0:一般频道
    // 1:Whisper(密语频道)
    // 2:大喊频道
    // 3:广播频道
    // 4:血盟频道
    // 11:组队频道
    // 13:联盟频道
    // 14:聊天队伍频道
    Connection con = null;
    PreparedStatement pstm = null;
    try {

      con = L1DatabaseFactory.getInstance().getConnection();
      if (target != null) {
        pstm =
            con.prepareStatement(
                "INSERT INTO log_chat (account_name, char_id, name, clan_id, clan_name, locx, locy, mapid, type, target_account_name, target_id, target_name, target_clan_id, target_clan_name, target_locx, target_locy, target_mapid, content, datetime) VALUE (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE())");
        pstm.setString(1, pc.getAccountName());
        pstm.setInt(2, pc.getId());
        pstm.setString(3, pc.isGm() ? "******" : pc.getName());
        pstm.setInt(4, pc.getClanid());
        pstm.setString(5, pc.getClanname());
        pstm.setInt(6, pc.getX());
        pstm.setInt(7, pc.getY());
        pstm.setInt(8, pc.getMapId());
        pstm.setInt(9, type);
        pstm.setString(10, target.getAccountName());
        pstm.setInt(11, target.getId());
        pstm.setString(12, target.getName());
        pstm.setInt(13, target.getClanid());
        pstm.setString(14, target.getClanname());
        pstm.setInt(15, target.getX());
        pstm.setInt(16, target.getY());
        pstm.setInt(17, target.getMapId());
        pstm.setString(18, text);
      } else {
        pstm =
            con.prepareStatement(
                "INSERT INTO log_chat (account_name, char_id, name, clan_id, clan_name, locx, locy, mapid, type, content, datetime) VALUE (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, SYSDATE())");
        pstm.setString(1, pc.getAccountName());
        pstm.setInt(2, pc.getId());
        pstm.setString(3, pc.isGm() ? "******" : pc.getName());
        pstm.setInt(4, pc.getClanid());
        pstm.setString(5, pc.getClanname());
        pstm.setInt(6, pc.getX());
        pstm.setInt(7, pc.getY());
        pstm.setInt(8, pc.getMapId());
        pstm.setInt(9, type);
        pstm.setString(10, text);
      }
      pstm.execute();

    } catch (final SQLException e) {
      _log.log(Level.SEVERE, e.getLocalizedMessage(), e);
    } finally {
      SQLUtil.close(pstm);
      SQLUtil.close(con);
    }
  }
예제 #2
0
  /**
   * 道具执行
   *
   * @param data 参数
   * @param pc 对象
   * @param item 道具
   */
  @Override
  public void execute(final int[] data, final L1PcInstance pc, final L1ItemInstance item) {

    final int itemId = item.getItemId();
    boolean isTeleport = false;
    final int x = pc.getX();
    final int y = pc.getY();
    final short map = pc.getMapId();

    switch (itemId) {
      case 40289: // 傲慢之塔传送符(11F),傲慢之塔传送符(51F)
      case 40293:
        // 傲慢之塔1层上方魔法阵
        if ((x >= 32816) && (x <= 32821) && (y >= 32778) && (y <= 32783) && (map == 101)) {
          isTeleport = true;
        }
        break;

      case 40290: // 傲慢之塔传送符(21F),傲慢之塔传送符(61F)
      case 40294:
        // 傲慢之塔1层右方魔法阵
        if ((x >= 32815) && (x <= 32820) && (y >= 32815) && (y <= 32820) && (map == 101)) {
          isTeleport = true;
        }
        break;

      case 40291: // 傲慢之塔传送符(31F),傲慢之塔传送符(71F)
      case 40295:
        // 傲慢之塔1层左方魔法阵
        if ((x >= 32779) && (x <= 32784) && (y >= 32778) && (y <= 32783) && (map == 101)) {
          isTeleport = true;
        }
        break;

      case 40292: // 傲慢之塔传送符(41F),傲慢之塔传送符(81F)
      case 40296:
        // 傲慢之塔1层下方魔法阵
        if ((x >= 32779) && (x <= 32784) && (y >= 32815) && (y <= 32820) && (map == 101)) {
          isTeleport = true;
        }
        break;

      case 40297: // 傲慢之塔传送符(91F)
        // 傲慢之塔90层右方魔法阵
        if ((x >= 32706) && (x <= 32710) && (y >= 32909) && (y <= 32913) && (map == 190)) {
          isTeleport = true;
        }
        break;
    }

    if (isTeleport) {
      L1Teleport.teleport(
          pc,
          item.getItem().get_locx(),
          item.getItem().get_locy(),
          item.getItem().get_mapid(),
          5,
          true);
    } else {
      pc.sendPackets(new S_ServerMessage(79)); // \f1没有任何事情发生。
    }
  }