<?php
require_once '../RitoConnecter.php';
require_once '../DBConnecter.php';
require_once '../config.php';
set_time_limit(0);
// connect to database
$db = new SQLConnecter($db_host, $db_username, $db_pass, $db_name, $db_port);
$dbh = $db->connect();
// set item list URL
$rito = new RitoConnecter($region, $api_key, $game, $champ, $items);
$url = $rito->items_url();
echo $url, '<br>';
// get item list
$raw = $rito->get_content($url);
$jso = json_decode($raw, true);
// populate item table
foreach ($jso['data'] as $obj) {
$id = $obj['id'];
$name = $obj['name'];
if (isset($obj['stats']['FlatMagicDamageMod'])) {
$ap = $obj['stats']['FlatMagicDamageMod'];
} else {
$ap = 0;
}
$qry = 'INSERT INTO `items` (`ItemID`, `ItemName`, `AP`) VALUES (' . $id . ', "' . $name . '", ' . $ap . ');';
$result = $dbh->query($qry);
echo $qry, '<br>';
}
$dbh->close();
<?php
require '../RitoConnecter.php';
require '../DBConnecter.php';
require '../config.php';
set_time_limit(0);
// connect to database
$db = new SQLConnecter($db_host, $db_username, $db_pass, $db_name, $db_port);
$dbh = $db->connect();
// set champion URL
$rito = new RitoConnecter($region, $api_key, $game, $champ, $items);
$url = $rito->champ_url();
echo $url, '<br>';
// get champion list
$data = $rito->get_content($url);
$jso = json_decode($data, true);
// populate champ table
foreach ($jso['data'] as $obj) {
$id = $obj['id'];
$name = $obj['key'];
$qry = 'INSERT INTO `champions` (`ID`, `Name`) VALUES (' . $id . ', "' . $name . '");';
$result = $dbh->query($qry);
echo $qry, '<br>';
}
$dbh->close();