1 / 13

League of Legends ( LoL ) Guidance Database

League of Legends ( LoL ) Guidance Database. By: Evie Phan I257 – Database Management. Game Description. Game played team vs team, 5 players/team Each player selects 1 “Champion” to play Usually teams take turns to make these selections Each champion has different abilities

candid
Download Presentation

League of Legends ( LoL ) Guidance Database

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. League of Legends (LoL)Guidance Database By: EviePhan I257 – Database Management

  2. Game Description • Game played team vs team, 5 players/team • Each player selects 1 “Champion” to play • Usually teams take turns to make these selections • Each champion has different abilities • Strong against some, weak against other enemies • Map zones (“lanes”): Top, Mid, Bottom, Jungle • Each champion plays well only certain lanes • Players buy items during the game

  3. Problem Statement • Many LoL websites, but information scattered • Database puts it all together • Anyone who plays on Summoners Rift map can use this database • Especially those playing Draft or Ranked

  4. Use Cases • What champions or items are good at countering another champion? • What items should I buy for a championand how much they will cost? • Which champions work well together? • Champion recommendation for a certain lane based on enemy champion picks

  5. Design • Create all the tables that I might need • Start with only a few queries, add more over time • Provide web interface for all the queries but not for adding information • I will update the tables myself as the game changes

  6. Design – Several Identical Items Option 1 Option 2

  7. Design – Symmetric Unary Relationships Synergy Table Option 1 • Queries are simpler • Updates are more tedious Option 2 • Queries are more tedious • Updates are simpler

  8. Implementation – Populating Tables • Most of the data came from online sources • https://docs.google.com/spreadsheet/ccc?key=0Al8z9Z7RVccedGtsaVZCeFE5QzBaWFRaZ3dMb1VjOFE#gid=0 • http://lolcounter.com/list.php • http://na.leagueoflegends.com/items • I had to clean up a lot of data • Dealing with typos: SELECT DISTINCT CounterItems.CounterItem, Items.Item FROM CounterItems LEFT JOIN Items ON CounterItems.CounterItem=Items.Item WHERE Items.Item is NULL

  9. Implementation – Queries • Get champion selection recommendations • Enemy choices: Veigar, Sona, Lee Sin • Lane: Top Select Laning.Lane, Laning.Champion, CounterChampions.EnemyFrom Laning, CounterChampionsWHERE Laning.Lane='Top' AND CounterChampions.Counterpick=Laning.Champion AND (CounterChampions.Enemy='Veigar' OR CounterChampions.Enemy='Sona' OR CounterChampions.Enemy='Lee Sin')

  10. User Interaction – Queries • Go to Navicat for Examples

  11. User Interaction: Demo • Countering an enemy

More Related