All pastes #750794 Raw Edit

Anonymous

public text v1 · immutable
#750794 ·published 2007-10-26 19:54 UTC
rendered paste body
	private void removeOfflineCirclets(L2PcInstance player, L2ItemInstance circlet)
	{
		Connection con = null;
		try
		{
			con = L2DatabaseFactory.getInstance().getConnection();

			PreparedStatement statement = con.prepareStatement("DELETE from items where object_id=? and item_id=? and owner_id=?");
				statement.setInt(1, circlet.getObjectId());
				statement.setInt(2, circlet.getItemId());
				statement.setInt(3, circlet.getOwnerId());

				statement.execute();
				statement.close();

			} 
			catch (SQLException se)
			{
				if (Config.DEBUG) se.printStackTrace();
			}
			finally
			{
				try { con.close(); } catch (Exception e)
				{
					if (Config.DEBUG)
						e.printStackTrace();
				}
			}
		}