Skip to content

Latest commit

 

History

History
121 lines (105 loc) · 3.6 KB

README.md

File metadata and controls

121 lines (105 loc) · 3.6 KB
Raw

XIV Stats

XIV Stats is primarily a script to produce a database of player information for FFXIV. The information is pulled from directly from the lodestone. An example PHP file is available here to demonstrate visualising the statistics. You can also view a live demo of the example web page by visiting ffxivcensus.com.

The aim of this project is to allow people to build their own projects using this data. For example, creating a website to compare players.

If you would rather download a pre-populated database containing every player (as of 2015-04-23), please see the "Notes" section below.

The project is inspired by xivsoul.com.

Configuration

The path for the database to be used is specified on the line beginning "db_path" in xiv_stats.rb.

Usage

The script will collect information on all players with IDs in the specified range, as shown below:

./xiv_stats.rb <lowest ID> <highest ID>

The player ID can be determined by looking at the URL for the lodestone profile page of a given player.

Notes

The script deliberately only retrieves between 1-2 players per second. This is to avoid excessive load on the lodestone's servers. Due to the slow execution, a complete copy of the database has been compiled and is avaiable from the following URLs.

Release Live Patch Live Expansion Download
April 2015 2.5 A Realm Reborn Link
July 2015 3.0 Heavensward Link

Data Structure

All information is stored in a single table called "players".

This table contain the following columns:

  • id (derived from the player's lodestone profile URL)
  • realm
  • player_name
  • race
  • gender
  • grand_company
  • level_gladiator
  • level_pugilist
  • level_marauder
  • level_lancer
  • level_archer
  • level_rogue
  • level_conjurer
  • level_thaumaturge
  • level_arcanist
  • level_darkknight
  • level_machinist
  • level_astrologian
  • level_carpenter
  • level_blacksmith
  • level_armorer
  • level_goldsmith
  • level_leatherworker
  • level_weaver
  • level_alchemist
  • level_culinarian
  • level_miner
  • level_botanist
  • level_fisher
  • 30days (subscription time)
  • 60days
  • 90days
  • 180days
  • 270days
  • 360days
  • 450days
  • 630days
  • prearr (pre-ordered A Realm Reborn)
  • prehw (pre-ordered Heavensward)
  • artbook (bought "The Art of Eorzea")
  • beforemeteor (bought "Before Meteor" soundtrack)
  • beforethefall (bought "Before The Fall" soundtrack)
  • soundtrack (bought "A Realm Reborn OST" soundtrack)
  • saweternalbond (guest at a ceremony of eternal bonding)
  • sightseeing (completed all 80 entries in the ARR sightseeing log)
  • arr_25_complete (completed patch 2.5)
  • comm50 (attained 50 player commendations)
  • moogleplush (bought a moogle plush)
  • hildibrand (Completed the 2.5 hildibrand quest line)
  • ps4collectors (Bought the PS4 collectors edition for A Realm Reborn)
  • dideternalbond (has been married)
  • arrcollector (bought the collectors edition for A Realm Reborn)
  • kobold (Got the maximum kobold reputation)
  • sahagin (Got the maximum sahagin reputation)
  • amaljaa (Got the maximum amalj'aa reputation)
  • sylph (Got the maximum sylph reputation)
  • hw_complete (Completed the 3.0 storyline)
  • hw_31_complete (Completed patch 3.1)
  • legacy_player (Played during 1.x)
  • ifrit_ex_mount
  • garuda_ex_mount
  • titan_ex_mount
  • levi_ex_mount
  • ramuh_ex_mount
  • shiva_ex_mount
  • all_6_ponies_mount
  • diadem_99_mount
  • bismarck_ex_mount
  • thordan_ex_mount
  • ravana_ex_mount
  • sepi_ex_mount
  • nidhogg_ex_mount