public static ArrayList<Item> getItemList() throws SlickException{
		QueryExecutor qe = new QueryExecutor();
		ArrayList<ArrayList<String>> items;
		ArrayList<Item> rtrItems = new ArrayList<Item>();
		for (int i = 0; i <= 30; i++) {
			rtrItems.add(null);
		}
		String query = "SELECT i.itemID,typeID,Name,icon,value,defence,damage "+ 
				"FROM RPG372DB.RPG372DB_Item AS i "+
				"LEFT JOIN RPG372DB.RPG372DB_Item_Armor AS a ON i.itemID = a.itemID "+
				"LEFT JOIN RPG372DB.RPG372DB_Item_Weapon AS w ON i.itemID = w.itemID "+
				"ORDER BY itemID ASC;";

		qe.SendQuery(query);
		items = qe.vals;
		for (int i = 0; i < items.size(); i++) {
			int itemId = Integer.parseInt(items.get(i).get(0));
			Item item = new Item(itemId);
			item.setName(qe.vals.get(i).get(2));
			item.setValue(Integer.parseInt(qe.vals.get(i).get(4)));

			//IF MISC
			if(items.get(i).get(1).equals("1")){
				item.setIcon(new Image("client/data/items/misc/misc1.png"));
				rtrItems.set(itemId, item);
				//IF ARMOR
			}else if(items.get(i).get(1).equals("2")){
				item.setIcon(new Image("client/data/items/armor/Armor"+(itemId%10)+".png"));
				Armor armor = item.getArmor();
				armor.setDefence(Integer.parseInt(items.get(i).get(5)));
				rtrItems.set(itemId, armor);
			}
			//IF WEAPON
			else if(items.get(i).get(1).equals("3")){
				item.setIcon(new Image("client/data/items/weapon/Weapon"+(itemId%10)+".png"));
				Weapon weapon = item.getWeapon();
				weapon.setDamage(Integer.parseInt(items.get(i).get(6)));
				rtrItems.set(itemId, weapon);
			}
		}
		return rtrItems;
	}