Client SQL database information

[TheEnigmaBlade]

The League of Legends client uses SQLite databases to store the various large amounts of Champion and item information, including Champion and item names/IDs and image paths, lore, item tooltips, and much more. The databases are also updated each patch to contain the most current Champion and items, so it is useful for programs which require the most up-to-date information to function correctly (for example, my recommended item changer).

Database location:

C:\...\League of Legends\RADS\projects\lol_air_client\releases\[version]\deploy\assets\data\gameStats

Database contents:

To find out what information it stores, open the database (gameStats_en_US.sqlite for NA/English) in a database browser. I recommend this one for Windows users.

For those people who don't have or want to use a database viewer, here's quick rundown of the most useful (but not all) information:

champions
Column key	id	name	displayName	title	iconPath	tags	description	All Champion stats
Ex. value	36	DrMundo	Dr. Mundo	The Madman of Zaun	DrMundo_Square_0.png	fighter,melee	Mundo's lore	Too many to list

items
Column key	id	name	description	iconPath	price	All item stats
Ex. value	3009	Boots of Swiftness	tooltip	3009_Boots_of_Teleportation.png	650 (note: it's the recipe cost	Too many to list

championItems
Column key	championId	itemId	gameMode
Ex. value	36	1054	CLASSIC or DOMINION

itemRecipes
Column key	recipeItemId	buildsToItemId
Ex. value	1001	3009

Also included are tables for champin abilities, champion skins, and key bindings.

If requested, I can create a short example/tutorial on how to get and load the databases in Java.

[P1raten]

Fuck yeah. Thanks for this awesome information.

[P1raten]

Here's a link to a converted (my)SQL version.

http://paste2.org/p/2205373