Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- for($i = 0; $i < 10; $i++) {
- $names[$i] = $jsonCurrent["participants"][$i]["summonerId"];
- $api_ranked_array[$i] = "https://euw1.api.riotgames.com/lol/league/v3/positions/by-summoner/$names[$i]?api_key=$api_key";
- $jsonRankedArray[$i] = json_decode(file_get_contents($api_ranked_array[$i]), true);
- if($jsonRankedArray[$i] == null) {
- $tier[$i] = "UNRANKED";
- $rank[$i] = "";
- $games[$i] = 0;
- $winrate[$i] = 0;
- $LP[$i] = 0;
- }
- else {
- $tier[$i] = $jsonRankedArray[$i][0]["tier"];
- $rank[$i] = $jsonRankedArray[$i][0]["rank"];
- $games[$i] = $jsonRankedArray[$i][0]["wins"] + $jsonRankedArray[$i][0]["losses"];
- $winrate[$i] = substr(($jsonRankedArray[$i][0]["wins"] / ($jsonRankedArray[$i][0]["losses"] + $jsonRankedArray[$i][0]["wins"])),0,5) * 100;
- $LP[$i] = $jsonRankedArray[$i][0]["leaguePoints"];
- }
- $sum1[$i] = $jsonCurrent["participants"][$i]["spell1Id"];
- $sum2[$i] = $jsonCurrent["participants"][$i]["spell2Id"];
- $champion[$i] = $jsonCurrent["participants"][$i]["championId"];
- $ban[$i] = $jsonCurrent["bannedChampions"][$i]["championId"];
- $pickTurn[$i] = $jsonCurrent["bannedChampions"][$i]["pickTurn"];
- $teamId[$i] = $jsonCurrent["bannedChampions"][$i]["teamId"];
- $perkStyle[$i] = $jsonCurrent["participants"][$i]["perks"]["perkStyle"];
- $perkSubStyle[$i] = $jsonCurrent["participants"][$i]["perks"]["perkSubStyle"];
- $perk_id1[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][0];
- $perk_id2[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][1];
- $perk_id3[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][2];
- $perk_id4[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][3];
- $perk_id5[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][4];
- $perk_id6[$i] = $jsonCurrent["participants"][$i]["perks"]["perkIds"][5];
- $championName[$i] = $championsList[$champion[$i]];
- $requestUpdateParticipants[$i] = "UPDATE participants SET pa_summonerId = $names[$i],
- pa_tier = '$tier[$i]',
- pa_rank = '$rank[$i]',
- pa_nbGames = $games[$i],
- pa_winrate = $winrate[$i],
- pa_lp = $LP[$i],
- pa_spell1Id = $sum1[$i],
- pa_spell2Id = $sum2[$i],
- pa_championId = $champion[$i]
- WHERE pa_id = ($i + 1)";
- $requestUpdateBans[$i] = "UPDATE bans SET ba_championId = $ban[$i],
- ba_pickTurn = $pickTurn[$i],
- ba_teamId = $teamId[$i]
- WHERE ba_id = ($i + 1)";
- $requestUpdatePerks[$i] = "UPDATE perks SET pe_style = $perkStyle[$i],
- pe_subStyle = $perkSubStyle[$i],
- pe_id1 = $perk_id1[$i],
- pe_id2 = $perk_id2[$i],
- pe_id3 = $perk_id3[$i],
- pe_id4 = $perk_id4[$i],
- pe_id5 = $perk_id5[$i],
- pe_id6 = $perk_id6[$i]
- WHERE pe_id = ($i + 1)";
- mysqli_query($conn, $requestUpdateParticipants[$i]) or die(mysqli_error($conn));
- mysqli_query($conn, $requestUpdateBans[$i]) or die(mysqli_error($conn));
- mysqli_query($conn, $requestUpdatePerks[$i]) or die(mysqli_error($conn));
- if($idSQL[$i] == $id || $names[$i] == $id) {
- $styleName[$i] = "text-decoration: underline;color:orange;";
- }
- else {
- $styleName[$i] = "color: black;";
- }
- if($winrate[$i] < 50) {
- $stylePlayer[$i] = "color: #BDBDBD;";
- }
- else if($winrate[$i] < 60) {
- $stylePlayer[$i] = "color: #4DB6AC;";
- }
- else if($winrate[$i] < 70) {
- $stylePlayer[$i] = "color: #2196F3;";
- }
- else if($winrate[$i] >= 70) {
- $stylePlayer[$i] = "color: #FBC02D;";
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement