Package l2p.database

Examples of l2p.database.FiltredStatement.executeQuery()


          FiltredStatement stcraft = null;
          ResultSet rstcraft = null;
          try
          {
            stcraft = con.createStatement();
            rstcraft = stcraft.executeQuery("SELECT `item_id`, `count` FROM `craftcount` WHERE `char_id`=" + objectId);
            player._StatCraft = new HashMap<Integer, Long>(32);
            while(rstcraft.next())
            {
              player._StatCraft.put(rstcraft.getInt("item_id"), rstcraft.getLong("count"));
            }
View Full Code Here


          FiltredStatement stdrop = null;
          ResultSet rstdrop = null;
          try
          {
            stdrop = con.createStatement();
            rstdrop = stdrop.executeQuery("SELECT `item_id`, `count` FROM `dropcount` WHERE `char_id`=" + objectId);
            player._StatDrop = new HashMap<Integer, Long>(128);
            while(rstdrop.next())
            {
              player._StatDrop.put(rstdrop.getInt("item_id"), rstdrop.getLong("count"));
            }
View Full Code Here

    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);
        long endTime = rset.getLong("end_time");
View Full Code Here

    try
    {
      //read raidboss points
      con = L2DatabaseFactory.getInstance().getConnection();
      statement = con.createStatement();
      rset = statement.executeQuery("SELECT owner_id, boss_id, points FROM `raidboss_points` ORDER BY owner_id ASC");
      int currentOwner = 0;
      FastMap<Integer, Integer> score = null;
      while(rset.next())
      {
        if(currentOwner != rset.getInt("owner_id"))
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.