Advertisement
Guest User

Untitled

a guest
Jan 20th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.87 KB | None | 0 0
  1. for($i = 0; $i < 10; $i++) {
  2. $names[$i] = $jsonCurrent["participants"][$i]["summonerId"];
  3. $api_ranked_array[$i] = "https://euw1.api.riotgames.com/lol/league/v3/positions/by-summoner/$names[$i]?api_key=$api_key";
  4. $jsonRankedArray[$i] = json_decode(file_get_contents($api_ranked_array[$i]), true);
  5.  
  6. if($jsonRankedArray[$i] == null) {
  7. $tier[$i] = "UNRANKED";
  8. $rank[$i] = "";
  9. $games[$i] = 0;
  10. $winrate[$i] = 0;
  11. $LP[$i] = 0;
  12. }
  13. else {
  14. $tier[$i] = $jsonRankedArray[$i][0]["tier"];
  15. $rank[$i] = $jsonRankedArray[$i][0]["rank"];
  16. $games[$i] = $jsonRankedArray[$i][0]["wins"] + $jsonRankedArray[$i][0]["losses"];
  17. $winrate[$i] = substr(($jsonRankedArray[$i][0]["wins"] / ($jsonRankedArray[$i][0]["losses"] + $jsonRankedArray[$i][0]["wins"])),0,5) * 100;
  18. $LP[$i] = $jsonRankedArray[$i][0]["leaguePoints"];
  19. }
  20.  
  21. $sum1[$i] = $jsonCurrent["participants"][$i]["spell1Id"];
  22. $sum2[$i] = $jsonCurrent["participants"][$i]["spell2Id"];
  23. $champion[$i] = $jsonCurrent["participants"][$i]["championId"];
  24. $ban[$i] = $jsonCurrent["bannedChampions"][$i]["championId"];
  25. $pickTurn[$i] = $jsonCurrent["bannedChampions"][$i]["pickTurn"];
  26. $teamId[$i] = $jsonCurrent["bannedChampions"][$i]["teamId"];
  27. $perkStyle[$i] = $jsonCurrent["participants"][$i]["perks"]["perkStyle"];
  28. $perkSubStyle[$i] = $jsonCurrent["participants"][$i]["perks"]["perkSubStyle"];
  29. $perk_id1[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][0];
  30. $perk_id2[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][1];
  31. $perk_id3[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][2];
  32. $perk_id4[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][3];
  33. $perk_id5[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][4];
  34. $perk_id6[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][5];
  35.  
  36. $championName[$i] = $championsList[$champion[$i]];
  37.  
  38. $requestUpdateParticipants[$i] = "UPDATE participants SET pa_summonerId = $names[$i],
  39. pa_tier = '$tier[$i]',
  40. pa_rank = '$rank[$i]',
  41. pa_nbGames = $games[$i],
  42. pa_winrate = $winrate[$i],
  43. pa_lp = $LP[$i],
  44. pa_spell1Id = $sum1[$i],
  45. pa_spell2Id = $sum2[$i],
  46. pa_championId = $champion[$i]
  47. WHERE pa_id = ($i + 1)";
  48.  
  49. $requestUpdateBans[$i] = "UPDATE bans SET ba_championId = $ban[$i],
  50. ba_pickTurn = $pickTurn[$i],
  51. ba_teamId = $teamId[$i]
  52. WHERE ba_id = ($i + 1)";
  53.  
  54. $requestUpdatePerks[$i] = "UPDATE perks SET pe_style = $perkStyle[$i],
  55. pe_subStyle = $perkSubStyle[$i],
  56. pe_id1 = $perk_id1[$i],
  57. pe_id2 = $perk_id2[$i],
  58. pe_id3 = $perk_id3[$i],
  59. pe_id4 = $perk_id4[$i],
  60. pe_id5 = $perk_id5[$i],
  61. pe_id6 = $perk_id6[$i]
  62. WHERE pe_id = ($i + 1)";
  63.  
  64. mysqli_query($conn, $requestUpdateParticipants[$i]) or die(mysqli_error($conn));
  65. mysqli_query($conn, $requestUpdateBans[$i]) or die(mysqli_error($conn));
  66. mysqli_query($conn, $requestUpdatePerks[$i]) or die(mysqli_error($conn));
  67.  
  68. if($idSQL[$i] == $id || $names[$i] == $id) {
  69. $styleName[$i] = "text-decoration: underline;color:orange;";
  70. }
  71. else {
  72. $styleName[$i] = "color: black;";
  73. }
  74. if($winrate[$i] < 50) {
  75. $stylePlayer[$i] = "color: #BDBDBD;";
  76. }
  77. else if($winrate[$i] < 60) {
  78. $stylePlayer[$i] = "color: #4DB6AC;";
  79. }
  80. else if($winrate[$i] < 70) {
  81. $stylePlayer[$i] = "color: #2196F3;";
  82. }
  83. else if($winrate[$i] >= 70) {
  84. $stylePlayer[$i] = "color: #FBC02D;";
  85. }
  86. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement