Package l2p.database

Examples of l2p.database.FiltredStatement.addBatch()

5127
5128
5129
5130
5131
5132
5133
5134
5135
5136
5137
          {
            TextBuilder sb = TextBuilder.newInstance();
            fs = con.createStatement();
            for(Entry<Integer, Long> tmp : _StatKills.entrySet())
            {
              fs.addBatch(sb.append("REPLACE DELAYED INTO `killcount` SET `npc_id`=").append(tmp.getKey()).append(", `count`=").append(tmp.getValue()).append(", `char_id`=").append(_objectId).toString());
              sb.clear();
            }
            TextBuilder.recycle(sb);
            fs.executeBatch();
            DatabaseUtils.closeStatement(fs);
View Full Code Here
5140
5141
5142
5143
5144
5145
5146
5147
5148
5149
5150
          {
            TextBuilder sb = TextBuilder.newInstance();
            fs = con.createStatement();
            for(Entry<Integer, Long> tmp : _StatCraft.entrySet())
            {
              fs.addBatch(sb.append("REPLACE DELAYED INTO `craftcount` SET `item_id`=").append(tmp.getKey()).append(", `count`=").append(tmp.getValue()).append(", `char_id`=").append(_objectId).toString());
              sb.clear();
            }
            TextBuilder.recycle(sb);
            fs.executeBatch();
            DatabaseUtils.closeStatement(fs);
View Full Code Here
5153
5154
5155
5156
5157
5158
5159
5160
5161
5162
5163
          {
            TextBuilder sb = TextBuilder.newInstance();
            fs = con.createStatement();
            for(Entry<Integer, Long> tmp : _StatDrop.entrySet())
            {
              fs.addBatch(sb.append("REPLACE DELAYED INTO `craftcount` SET `item_id`=").append(tmp.getKey()).append(", `count`=").append(tmp.getValue()).append(", `char_id`=").append(_objectId).toString());
              sb.clear();
            }
            TextBuilder.recycle(sb);
            fs.executeBatch();
            DatabaseUtils.closeStatement(fs);
View Full Code Here
640
641
642
643
644
645
646
647
648
649
650
      fs = con.createStatement();
      for(L2NpcTemplate t : NpcTable.getAll())
      {
        if(t != null && t.killscount > 0)
        {
          fs.addBatch(sb.append("REPLACE INTO `killcount` SET `npc_id`=").append(t.npcId).append(", `count`=").append(t.killscount).append(", `char_id`=-1").toString());
          sb.clear();
        }
      }
      TextBuilder.recycle(sb);
      fs.executeBatch();
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.