All pastes #24931 Raw Edit

Anonymous

public text v1 · immutable
#24931 ·published 2005-10-08 14:26 UTC
rendered paste body
			try {
			PreparedStatement statement2 = con.prepareStatement("SELECT mobId, itemId, min, max, sweep, chance FROM raid_droplist ORDER BY mobId,chance DESC");
			ResultSet dropData = statement2.executeQuery();
			L2DropData dropDat = null;
			L2NpcTemplate npcDat = null;
			
			while (dropData.next())
			{
			    int mobId = dropData.getInt("mobId");
			    npcDat = _npcs.get(mobId);
				dropDat = new L2DropData();

				dropDat.setItemId(dropData.getInt("itemId"));
				dropDat.setMinDrop(dropData.getInt("min"));
				dropDat.setMaxDrop(dropData.getInt("max"));
				dropDat.setSweep(dropData.getInt("sweep") == 1);
				dropDat.setChance(dropData.getInt("chance"));
				npcDat.addDropData(dropDat);
			}

			dropData.close();
			statement2.close();
			} catch (Exception e) {
				_log.log(Level.SEVERE, "error reading raidboss drops ", e);
			}