Package l2p.database

Examples of l2p.database.ThreadConnection.createStatement()

5501
5502
5503
5504
5505
5506
5507
5508
5509
5510
5511
    ThreadConnection con = null;
    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;
      }
View Full Code Here
5661
5662
5663
5664
5665
5666
5667
5668
5669
5670
5671
    FiltredStatement statement = null;
    ResultSet rset = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      rset = statement.executeQuery("SELECT skill_id,end_time,reuse_delay_org FROM character_skills_save WHERE char_obj_id=" + getObjectId() + " AND class_index=" + getActiveClassId());
      while(rset.next())
      {
        int skillId = rset.getInt("skill_id");
        int skillLevel = Math.max(getSkillLevel(skillId), 1);
View Full Code Here
5678
5679
5680
5681
5682
5683
5684
5685
5686
5687
5688
          getSkillReuseTimeStamps().put(skillId, new SkillTimeStamp(skillId, endTime, rDelayOrg));
          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());
View Full Code Here
6921
6922
6923
6924
6925
6926
6927
6928
6929
6930
6931
    ThreadConnection con = null;
    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;
      }
View Full Code Here
8103
8104
8105
8106
8107
8108
8109
8110
8111
8112
8113
    ThreadConnection con = null;
    FiltredStatement statement = null;
    try
    {
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      StringBuilder sb;
      for(L2SubClass subClass : getSubClasses().values())
      {
        sb = new StringBuilder("UPDATE character_subclasses SET ");
        sb.append("exp=").append(subClass.getExp()).append(",");
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.