Package lineage2.gameserver.utils

Examples of lineage2.gameserver.utils.SqlBatch

123
124
125
126
127
128
129
130
131
132
133
134
135
136
    ThreadPoolManager.getInstance().schedule(new RunnableImpl()
    {
      @Override
      public void runImpl()
      {
        final NpcTemplate template = NpcHolder.getInstance().getTemplate(18602);
        if (template != null)
        {
          final NpcInstance a = template.getNewInstance();
          a.setCurrentHpMp(a.getMaxHp(), a.getMaxMp());
          a.spawnMe(actor.getLoc());
        }
      }
    }, 10000L);
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
      {
        player.sendPacket(Msg.YOU_CANNOT_TELEPORT_TO_A_VILLAGE_THAT_IS_IN_A_SIEGE);
        return;
      }
    }
    final Location pos = Location.findPointToStay(x, y, z, 50, 100, player.getGeoIndex());
    if (price > 0)
    {
      player.reduceAdena(price, true);
    }
    player.teleToLocation(pos);
View Full Code Here
137
138
139
140
141
142
143
144
      player.sendPacket(SystemMessage2.removeItems(item, count));
    }
    final int x = Integer.parseInt(param[0]);
    final int y = Integer.parseInt(param[1]);
    final int z = Integer.parseInt(param[2]);
    final Location pos = Location.findPointToStay(x, y, z, 20, 70, player.getGeoIndex());
    player.teleToLocation(pos);
  }
View Full Code Here
333
334
335
336
337
338
339
340
341
342
343
      return;
    }
    final String var = player.getVar("DCBackCoords");
    if ((var == null) || var.isEmpty())
    {
      player.teleToLocation(new Location(43768, -48232, -800), 0);
      return;
    }
    player.teleToLocation(Location.parseLoc(var), 0);
    player.unsetVar("DCBackCoords");
  }
View Full Code Here
48
49
50
51
52
53
54
55
56
57
    }
    for (Player player : World.getAroundPlayers(actor, 200, 200))
    {
      if (player != null)
      {
        player.teleToLocation(new Location(207559, 86429, -1000));
      }
    }
    return true;
  }
View Full Code Here
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
    try
    {
      con = DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      int order = 0;
      SqlBatch b = new SqlBatch("INSERT IGNORE INTO `character_effects_save` (`object_id`,`skill_id`,`skill_level`,`effect_count`,`effect_cur_time`,`duration`,`order`,`id`) VALUES");
      StringBuilder sb;
      for (Effect effect : effects)
      {
        if ((effect != null) && effect.isInUse() && !effect.getSkill().isToggle() && (effect.getEffectType() != EffectType.HealOverTime) && (effect.getEffectType() != EffectType.CombatPointHealOverTime) && (effect.getEffectType() != EffectType.Mentoring))
        {
          if (effect.isSaveable())
          {
            sb = new StringBuilder("(");
            sb.append(objectId).append(',');
            sb.append(effect.getSkill().getId()).append(',');
            sb.append(effect.getSkill().getLevel()).append(',');
            sb.append(effect.getCount()).append(',');
            sb.append(effect.getTime()).append(',');
            sb.append(effect.getPeriod()).append(',');
            sb.append(order).append(',');
            sb.append(id).append(')');
            b.write(sb.toString());
          }
          while (((effect = effect.getNext()) != null) && effect.isSaveable())
          {
            sb = new StringBuilder("(");
            sb.append(objectId).append(',');
            sb.append(effect.getSkill().getId()).append(',');
            sb.append(effect.getSkill().getLevel()).append(',');
            sb.append(effect.getCount()).append(',');
            sb.append(effect.getTime()).append(',');
            sb.append(effect.getPeriod()).append(',');
            sb.append(order).append(',');
            sb.append(id).append(')');
            b.write(sb.toString());
          }
          order++;
        }
      }
      if (!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch (final Exception e)
    {
      _log.error("Could not store active effects data!", e);
View Full Code Here
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
      statement.execute();
      if (player.getSharedGroupReuses().isEmpty())
      {
        return;
      }
      SqlBatch b = new SqlBatch(INSERT_SQL_QUERY);
      synchronized (player.getSharedGroupReuses())
      {
        for (IntObjectMap.Entry<TimeStamp> entry : player.getSharedGroupReuses())
        {
          int group = entry.getKey();
          TimeStamp timeStamp = entry.getValue();
          if (timeStamp.hasNotPassed())
          {
            StringBuilder sb = new StringBuilder("(");
            sb.append(player.getObjectId()).append(',');
            sb.append(group).append(',');
            sb.append(timeStamp.getId()).append(',');
            sb.append(timeStamp.getEndTime()).append(',');
            sb.append(timeStamp.getReuseBasic()).append(')');
            b.write(sb.toString());
          }
        }
      }
      if (!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch (final Exception e)
    {
      _log.error("CharacterGroupReuseDAO.insert(L2Player):", e);
View Full Code Here
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
    StringBuilder sb;
    try
    {
      con = DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      SqlBatch b = new SqlBatch("INSERT INTO `raidboss_points` (owner_id, boss_id, points) VALUES");
      for (Map.Entry<Integer, Map<Integer, Integer>> pointEntry : _points.entrySet())
      {
        Map<Integer, Integer> tmpPoint = pointEntry.getValue();
        if ((tmpPoint == null) || tmpPoint.isEmpty())
        {
          continue;
        }
        for (Map.Entry<Integer, Integer> pointListEntry : tmpPoint.entrySet())
        {
          if (KEY_RANK.equals(pointListEntry.getKey()) || KEY_TOTAL_POINTS.equals(pointListEntry.getKey()) || (pointListEntry.getValue() == null) || (pointListEntry.getValue() == 0))
          {
            continue;
          }
          sb = new StringBuilder("(");
          sb.append(pointEntry.getKey()).append(',');
          sb.append(pointListEntry.getKey()).append(',');
          sb.append(pointListEntry.getValue()).append(')');
          b.write(sb.toString());
        }
      }
      if (!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch (SQLException e)
    {
      _log.warn("RaidBossSpawnManager: Couldnt update raidboss_points table");
View Full Code Here
7146
7147
7148
7149
7150
7151
7152
7153
7154
7155
7156
7157
7158
7159
7160
7161
7162
7163
7164
7165
7166
7167
7168
7169
7170
7171
7172
7173
7174
7175
7176
7177
      statement.executeUpdate("DELETE FROM character_skills_save WHERE char_obj_id = " + getObjectId() + " AND class_index=" + getActiveClassId() + " AND `end_time` < " + System.currentTimeMillis());
      if (_skillReuses.isEmpty())
      {
        return;
      }
      SqlBatch b = new SqlBatch("REPLACE INTO `character_skills_save` (`char_obj_id`,`skill_id`,`skill_level`,`class_index`,`end_time`,`reuse_delay_org`) VALUES");
      synchronized (_skillReuses)
      {
        StringBuilder sb;
        for (TimeStamp timeStamp : _skillReuses.values())
        {
          if (timeStamp.hasNotPassed())
          {
            sb = new StringBuilder("(");
            sb.append(getObjectId()).append(',');
            sb.append(timeStamp.getId()).append(',');
            sb.append(timeStamp.getLevel()).append(',');
            sb.append(getActiveClassId()).append(',');
            sb.append(timeStamp.getEndTime()).append(',');
            sb.append(timeStamp.getReuseBasic()).append(')');
            b.write(sb.toString());
          }
        }
      }
      if (!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch (final Exception e)
    {
      _log.warn("Could not store disable skills data: " + e);
View Full Code Here
8677
8678
8679
8680
8681
8682
8683
8684
8685
8686
8687
8688
8689
8690
8691
8692
8693
8694
8695
8696
8697
8698
8699
8700
8701
      statement.executeUpdate("DELETE FROM character_blocklist WHERE obj_Id=" + getObjectId());
      if (_blockList.isEmpty())
      {
        return;
      }
      SqlBatch b = new SqlBatch("INSERT IGNORE INTO `character_blocklist` (`obj_Id`,`target_Id`) VALUES");
      synchronized (_blockList)
      {
        StringBuilder sb;
        for (Entry<Integer, String> e : _blockList.entrySet())
        {
          sb = new StringBuilder("(");
          sb.append(getObjectId()).append(',');
          sb.append(e.getKey()).append(')');
          b.write(sb.toString());
        }
      }
      if (!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch (Exception e)
    {
      _log.warn("Can't store player blocklist " + e);
View Full Code Here
TOP

Related Classes of lineage2.gameserver.utils.SqlBatch

  • ai.BaiumNpc
  • ai.ElcardiaAssistant
  • ai.ElcardiaAssistant$ThinkFollow
  • ai.GraveRobberSummoner
  • ai.GuardianAngel
  • ai.hellbound.DarionFaithfulServant
  • ai.hellbound.Kechi
  • ai.hellbound.MasterZelos
  • ai.hellbound.RankuScapegoat
  • ai.incubatorOfEvil.MonsterMage
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.