Downloading
Each of the CSV files has a link in the description where you can either download or copy the link to insert in a spreadsheet. To insert in a spreadsheet right click the link and select Copy Link (or similar) from the popup menu. The files from the dev produced datafiles should be inserted using the import (or similar) function in your spreadsheet so they will be updated as needed while the ones from my datasets (which are static) will give best performance by first downloading to your device and then uploading to your spreadsheet.
Dev Datafiles
These files are regenerated every day from the datafiles published by the devs. Bear in mind that these files are NOT live (neither are the xML files from the devs). They are re-generated each day at approximately 00:30 Illy time.
Players |
Towns |
Coastal Towns |
Alliances |
Alliance Roles |
Alliance Relationships |
Items
These are static files which are generated from various datasets I've gathered over the years of making tools for Illy.
All(?) Items |
Crafted Item Effects |
Crafted Item Recipes |
Faction Trade Hubs |
Description
Player Data
This is the csv version of the players datafile and has one players data on each line. The first line of the file holds descriptors for the various fields. Save
dated,id,playername,allianceid,allianceroleid,raceid
- dated
- The server date-time the snapshot was taken at.
- id
- The unique identifier for a player account. This id stays the same for a player from the moment the account is created.
- playername
- The current name for the player.
- allianceid
- The unique identifier for the alliance the player is currently a member of.
- allianceroleid
- The unique identifier for the role the player holds in their alliance.
- raceid
- The identifier for the player race.
Town Data
This is the csv version of the towns datafile. As the main purpose of these CSV files is to allow very easy loading into a spreadsheet it was necessary to split this into 3 individual files as there are simply too many towns for Google Sheets to load. The structure of each file is the same.
The towns are split by the Y coord as shown below:
The first line of the file holds descriptors for the various fields in the files.
dated, townnameid, mapx, mapy, terraintypeid, terraintype, terrainoveralltypeid, terrainoveralltype, playernameid, playername, playerrace, alliancenameid, alliancename, allianceticker, alliancetaxrate, townname, foundeddatetime, population, iscapitalcity, isalliancecapitalcity
- dated
- The server date-time the snapshot was taken at.
- townnameid
- The unique identifier for the town.
- mapx
- The X coord of the town
- mapy
- The Y coord of the town
- terraintypeid
- The combat terrain code for the tile the town is on
- terraintype
- The combat terrain name
- terrainoveralltypeid
- The code for the terrain the town is on
- terrainoveralltype
- The terrain name
- playernameid
- The id of the owning player
- playername
- The name of the owning player
- playerrace
- The id of the owning players race
- alliancenameid
- The id of the alliance the owner belongs to
- alliancename
- The name of the alliance the owner belongs to
- allianceticker
- The ticker of the owners alliance
- alliancetaxrate
- The tax rate of the owners alliance
- townname
- The name of the town
- foundeddatetime
- The date-time the town was founded
- population
- The population of the town
- iscapitalcity
- 1 if this is the players capital city
- isalliancecapitalcity
- 1 if the town is the capital city of the owners alliance
Coastal Towns
This is a subset of the towns data where the town is within a set distance of a salt water tile (ie on/near the coast). All data is exactly the same as the other town files. Save
Alliances
This is the first of 3 files that contain csv versions of the alliances xml file. It contains the main info for each alliance with the relationship and roles data in the other two. Save
The first line of the file holds descriptors for the various fields in the files.
dated, id, alliance, foundedbyplayerid, alliancecapitaltownid, allianceticker, foundeddatetime, alliancecapitallastmoved, alliancetaxrate, alliancetaxratelastchanged, membercount, totalpopulation
- dated
- The server date-time the snapshot was taken at.
- id
- The unique id of the alliance
- alliance
- The name of the alliance
- foundedbyplayerid
- Id of the player who founded the alliance
- alliancecapitaltownid
- Id of the town currently set as the alliance capital
- allianceticker
- ticker of the alliance
- foundeddatetime
- the date-time the alliance was created
- alliancecapitallastmoved
- The date-time the alliance capital last moved
- alliancetaxrate
- tax rate all members of the alliance pay
- alliancetaxratelastchanged
- Date-time the tax rate was last changed
- membercount
- Number of members in the alliance
- totalpopulation
- Population of all towns owned by members of the alliance
Alliance Roles
This contains details of the various roles that have been defined for each alliance. Save
The first line of the file holds descriptors for the various fields in the files.
dated, allianceid, roleid, role, heirarchyid
- dated
- Date-time the snapshot was taken
- allianceid
- Id of the alliance
- roleid
- Id of the role
- role
- Title of the role
- heirarchyid
- Id denoting where in the alliance heirarchy this role fits
Alliance Relationships
This contains details of the various relationships that have been declared between alliances. Note that there are multiple entries for each relationship - one for the proposing alliance and one for the accepting alliance. Save
The first line of the file holds descriptors for the various fields in the files.
dated, allianceid, proposedbyalliance, acceptedbyalliance, relationshiptypeid, relationshiptype, establishedsince
- dated
- Date-time the snapshot was taken
- allianceid
- Unique id of the alliance
- proposedbyalliance
- Unique id of the alliance that proposed the alliance
- acceptedbyalliance
- Unoque id of the alliance that accepted the alliance
- relationshiptypeid
- Id of the type of relationship
- relationshiptype
- Name of the relationship type
- establishedsince
- The date-time the relationship was accepted
Items
This contains details of the various relationships that have been declared between alliances. Save
The first line of the file holds descriptors for the various fields in the files.
id, name
- id
- The unique id of the item in-game.
- name
- The name of the item
Crafted Item Effects
Details of all the effects each crafted item has. Save
The first line of the file holds descriptors for the various fields in the files.
Id, Name, , Arctic, Desert, Jungle, Forests, Hills, Mountains, Plains, Day, Night, Dwarves, Elves, Humans, Orcs, Animals, Monsterous, , Bow Def, Cav Def, Spear Def, Sword Def, Attack, Move, Carry, Magic Resist, Spear, Sword, Bow, Mount, Leather, Chain,Plate, Undead
- id
- The unique id of the item in-game.
- name
- The name of the item
- Unused
- Not currently used
- Arctic Biome
- Bonus/penalty when used in the Arctic biome
- Desert
- Bonus/penalty when used in the Desert biome
- Jungle
- Bonus/penalty when used in the jungle biome
- Forests
- Bonus/penalty when used on a forest tile
- Hills
- Bonus/penalty when used on a hill tile
- Mountains
- Bonus/penalty when used on a mountain tile
- Plains
- Bonus/penalty when used on a plains tile
- Day
- Bonus/penalty when used during the day in Illy
- Night
- Bonus/penalty when used during the night in Illy
- Dwarves
- Bonus/penalty when used by Dwarves
- Elves
- Bonus/penalty when used by Elves
- Humans
- Bonus/penalty when used by Humans
- Orcs
- Bonus/penalty when used by Orcs
- Animals
- Bonus/penalty when used against animals (Natural) NPCs
- Monsterous
- Bonus/penalty when used against monsterous NPCs
- Unused
- Not currently used
- Bow Def
- Bonus/penalty to a units defence vs ranged units
- Cav Def
- Bonus/penalty to a units defence vs cavalry units
- Spear Def
- Bonus/penalty to a units defence vs spear units
- Sword Def
- Bonus/penalty to a units defence vs infantry units
- Attack
- Bonus/penalty to a units attack score
- Move
- Bonus/penalty to a units movement speed
- Carry
- Bonus/penalty to a units carry capacity
- Magic Resist
- Bonus/penalty to a units ability to resist magic
- Spear
- This item is a spear
- Sword
- This item is a sword
- Bow
- This item is a ranged weapon
- Mount
- This item is a mount
- Leather
- This item is leather armour
- Chain
- This item is chainmail
- Plate
- This item is plate armour
- Undead
- Bonus/penalty to a units attack vs undead units
Crafted Items Recipes
Details of what is used to make each crafted item. There is a line for each sub-item used in each item. Save
The first line of the file contains the descriptors for each of the fields.
ItemId, Item Name, Sub-Item Name, Qty
- ItemId
- Unique id of the main item
- Item Name
- Name of the main item
- Sub-Item Name
- Name of the sub-item
- Qty
- Quantity of the sub-item needed to make the main item
Faction Trade Hubs
Info on each of the Faction trade hubs. Save
The first line of the file contains the descriptors for each of the fields.
Hub Id, Hub Name, Chat Code, X, Y, Region Id, Region Name, Owner Faction Id, Owner Faction Name
- Hub Id
- Unique id of the Hub
- Hub Name
- Name of the hub
- Chat Code
- Code to use in GC
- X
- X coord of the hub
- Y
- Y coord of the hub
- Region Id
- Id of the region the hub is in
- Region Name
- Name of the region the hub is in
- Owner Faction Id
- Id of the faction owning the hub
- Owner Faction Name
- Name of the faction owning the hub