<?php
include( 'riot/php-riot-api.php' );
include( 'riot/FileSystemCache.php' );


$test = new riotapi( 'na' );


$testCache = new riotapi( 'na', new FileSystemCache( 'cache/' ) );
//$r = $test->getSummonerByName($summoner_name);

//$r = $test->getSummoner($summoner_id);
//$r = $test->getSummoner($summoner_id,'masteries');
//$r = $test->getSummoner($summoner_id,'runes');
//$r = $test->getSummoner($summoner_id,'name');
//$r = $test->getStats($summoner_id);
//$r = $test->getStats($summoner_id,'ranked');
//$r = $test->getTeam($summoner_id);
//$r = $test->getLeague($summoner_id);
//$r = $test->getGame($summoner_id);
//$r = $test->getChampion();
// dohvacanje novih imena
$r = $test->getMaster();


// Spajanje s bazom
$username = "root";
$password = "root";
$database = "league1db";
$host = "localhost";
$con = mysqli_connect( $host, $username, $password, $database );

$con->query( 'TRUNCATE players' );
// usporedi svako dohvaceno ime sa imenom u bazi. ako vec postoji, updejt, ako ne, new entry
//var_dump( $r[ 'entries' ] );

foreach ( $r[ 'entries' ] as $row ) {

    $sql = vsprintf(
        'INSERT INTO players (active, updated, summoner_id, summoner_name) VALUES (1, 0, %d, "%s")', [
            $row[ 'playerOrTeamId' ],
            $row[ 'playerOrTeamName' ]
        ]
    );
    var_dump($sql);
    $con->query( $sql );
}


//
//    foreach ( $db_summoner_ids as $summid2 ) {
//        $postoji = 0;
//        foreach ( $r[ 'entries' ] as $row ) {
//            if ( $row[ 'playerOrTeamId' ] == $summid2 ) {
//                $postoji = 1;
//                break;
//            }
//        }
//        if ( $postoji == 0 ) {
//            $sql = 'UPDATE players SET active=0 WHERE id_summoner=' . $summid2;
//            $con->query( $sql );
//            // provjera jednog imena iz baze
//            // stavi flag na tom imenu u bazii_close( $con );
//            // ne postoji u dohvacenim podatcima takvo ime


?>