All pastes #374606 Raw Edit

Unnamed

public text v1 · immutable
#374606 ·published 2007-02-27 18:30 UTC
rendered paste body
java.sql.Connection con = null;

		try
		{
			con = L2DatabaseFactory.getInstance().getConnection();
			PreparedStatement statement = con.prepareStatement("SELECT `mobId`,`polyId`,`spawnDelay`,`condition`,`conditionValue` FROM `polymorph_monsters` ORDER BY `mobId` ASC, `order`;");
			ResultSet resultSet = statement.executeQuery();

			PolymorphMonster polymorphMonster = null;
			int lastMobId = 0,
				nextMobId = 0;

			while (resultSet.next())
			{
				if (polymorphMonster == null)
				{
					lastMobId = resultSet.getInt("mobId");
					polymorphMonster = new PolymorphMonster(lastMobId);
					polymorphMonster.addPolyInfo(resultSet.getInt("polyId"), resultSet.getInt("spawnDelay"), resultSet.getInt("condition"), resultSet.getInt("conditionValue"));
					continue;
				}

				nextMobId = resultSet.getInt("mobId");

				if (nextMobId != lastMobId)
				{
					_polymorphMonsters.add(polymorphMonster);
					polymorphMonster = new PolymorphMonster(nextMobId);
					polymorphMonster.addPolyInfo(resultSet.getInt("polyId"), resultSet.getInt("spawnDelay"), resultSet.getInt("condition"), resultSet.getInt("conditionValue"));
					lastMobId = nextMobId;
					continue;
				}

				polymorphMonster.addPolyInfo(resultSet.getInt("polyId"), resultSet.getInt("spawnDelay"), resultSet.getInt("condition"), resultSet.getInt("conditionValue"));
			}
			
			_polymorphMonsters.add(polymorphMonster);
			polymorphMonster = null;
			
			resultSet.close();
			statement.close();
		}
		catch (Exception e)
		{
			System.out.println("Error while loading polymorph monsters: " + e);
		}
		finally
		{
			try { con.close(); } catch (Exception e) {}
			System.out.println("PolymorphMonstersTable: Loaded " + _polymorphMonsters.size() + " polymorph monsters.");
		}