Package l2p.database

Examples of l2p.database.FiltredStatement.executeUpdate()

5456
5457
5458
5459
5460
5461
5462
5463
5464
5465
5466
    FiltredStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      statement.executeUpdate("DELETE FROM character_skills_save WHERE char_obj_id = " + getObjectId() + " AND class_index=" + getActiveClassId() + " AND `end_time` < " + System.currentTimeMillis());
      if(skillReuseTimeStamps.isEmpty())
      {
        return;
      }
      SqlBatch b = new SqlBatch("REPLACE INTO `character_skills_save` (`char_obj_id`,`skill_id`,`class_index`,`end_time`,`reuse_delay_org`) VALUES");
View Full Code Here
5481
5482
5483
5484
5485
5486
5487
5488
5489
5490
5491
          }
        }
      }
      if(!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch(final Exception e)
    {
      _log.warning("Could not store disable skills data: " + e);
View Full Code Here
5502
5503
5504
5505
5506
5507
5508
5509
5510
5511
5512
    FiltredStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      statement.executeUpdate("DELETE FROM character_effects_save WHERE char_obj_id = " + getObjectId() + " AND class_index=" + getActiveClassId());
      if(_effectList == null || _effectList.isEmpty())
      {
        return;
      }
      int order = 0;
View Full Code Here
5562
5563
5564
5565
5566
5567
5568
5569
5570
5571
5572
          }
        }
      }
      if(!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch(final Exception e)
    {
      _log.warning("Could not store active effects data: " + e);
View Full Code Here
5679
5680
5681
5682
5683
5684
5685
5686
5687
5688
5689
          disableItem(skill, rDelayOrg, endTime - curTime);
        }
      }
      DatabaseUtils.closeStatement(statement);
      statement = con.createStatement();
      statement.executeUpdate("DELETE FROM character_skills_save WHERE char_obj_id = " + getObjectId() + " AND class_index=" + getActiveClassId() + " AND `end_time` < " + System.currentTimeMillis());
    }
    catch(Exception e)
    {
      _log.warning("Could not restore active skills data for " + getObjectId() + "/" + getActiveClassId());
      e.printStackTrace();
View Full Code Here
6922
6923
6924
6925
6926
6927
6928
6929
6930
6931
6932
    FiltredStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      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");
View Full Code Here
6941
6942
6943
6944
6945
6946
6947
6948
6949
6950
6951
          b.write(sb.toString());
        }
      }
      if(!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch(Exception e)
    {
      _log.warning("Can't store player blocklist " + e);
View Full Code Here
8119
8120
8121
8122
8123
8124
8125
8126
8127
8128
8129
        sb.append("active=").append(subClass.isActive() ? 1 : 0).append(",");
        sb.append("isBase=").append(subClass.isBase() ? 1 : 0).append(",");
        sb.append("death_penalty=").append(subClass.getDeathPenalty().getLevelOnSaveDB()).append(",");
        sb.append("skills='").append(subClass.getSkills()).append("'");
        sb.append(" WHERE char_obj_id=").append(getObjectId()).append(" AND class_id=").append(subClass.getClassId()).append(" LIMIT 1");
        statement.executeUpdate(sb.toString());
      }
      sb = new StringBuilder("UPDATE LOW_PRIORITY character_subclasses SET ");
      sb.append("maxHp=").append(getMaxHp()).append(",");
      sb.append("maxMp=").append(getMaxMp()).append(",");
      sb.append("maxCp=").append(getMaxCp());
View Full Code Here
8126
8127
8128
8129
8130
8131
8132
8133
8134
8135
8136
      sb = new StringBuilder("UPDATE LOW_PRIORITY character_subclasses SET ");
      sb.append("maxHp=").append(getMaxHp()).append(",");
      sb.append("maxMp=").append(getMaxMp()).append(",");
      sb.append("maxCp=").append(getMaxCp());
      sb.append(" WHERE char_obj_id=").append(getObjectId()).append(" AND active=1 LIMIT 1");
      statement.executeUpdate(sb.toString());
    }
    catch(final Exception e)
    {
      _log.warning("Could not store char sub data: " + e);
      e.printStackTrace();
View Full Code Here
387
388
389
390
391
392
393
394
395
396
397
          b.write(sb.toString());
        }
      }
      if(!b.isEmpty())
      {
        statement.executeUpdate(b.close());
      }
    }
    catch(SQLException e)
    {
      _log.warning("RaidBossSpawnManager: Couldnt update raidboss_points table");
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.