root/sovereignty/readsov.php5 @ 247

<?php
if (gmdate('H:i') != '12:59')
{
    exit;
}

include_once('evedb.php');

function startElement($parser, $name, $attrs)
{
    global $sovtime, $edb;

    if ($name == 'ROW')
    {
        $rows = join(',', array_keys($attrs));
        array_unshift($attrs, $sovtime);
        $values = join("','", $attrs);
        $query = 'INSERT INTO mapsovereignty (`date`,'.$rows.') VALUES (\''.$values.'\')';
        $edb->query($query);
    }
}

function endElement($parser, $name)
{

}

function characterData($parser, $data)
{
    global $sovtime;
    if (!isset($sovtime))
    {
        $sovtime = $data;
        global $edb;

        $query = "select count(*) as cnt from mapsovereignty where `date`='".$sovtime."'";
        $edb->query($query);
        $result = $edb->fetch_array();
        if ($result['cnt'] != 0)
        {
            exit;
            //die('found '.$result['cnt'].' rows, aborting');
        }
    }
}

if (empty($argv))
{
    $data = file_get_contents('http://api.eve-online.com/map/Sovereignty.xml.aspx');
}
else
{
    if (substr($argv[1], -2, 2) == 'gz')
    {
        $data = '';
        $p = gzopen($argv[1], 'r');
        while ($line = gzread($p, 4096))
        {
            $data .= $line;
        }
    }
    else
    {
        $data = file_get_contents($argv[1]);
    }
}

$p = xml_parser_create();
xml_set_element_handler($p, "startElement", "endElement");
xml_set_character_data_handler($p, "characterData");

xml_parse($p, $data, true);
xml_parser_free($p);

if (empty($argv))
{
    $fp = gzopen('data/Sovereignty.'.date('Y-m-d', strtotime($sovtime)).'.xml.gz', 'wb9');
    gzwrite($fp, $data);
    gzclose($fp);
}

$date1 = date('Y-m-d H:i:s', strtotime($sovtime)-24*3600);
/*
$query = "SELECT count(*) as cnt
            FROM mapsovereignty m1
            left join mapsovereignty m2 on m1.solarSystemID=m2.solarSystemID and m2.date='$date1'
            left join mapsolarsystems on m1.solarSystemID=mapsolarsystems.solarSystemID
            WHERE m1.date='$sovtime'
            and (m1.allianceID != m2.allianceID or m2.allianceID is null)
            and m1.factionID = 0";
$edb->query($query);
$num = $edb->num_rows();*/
$num = 1;
if ($num == 0)
{
    $edb->query("delete from mapsovereignty where `date` = '".$sovtime."'");
    $edb->query("delete from mapsovdates where `date`='".$sovtime."'");
}
else
{
    // update the sovdata table
    $edb->query("insert into mapsovdates (`date`) VALUES ('".$sovtime."')");
    $edb->query("insert into maprendertarget (date1,date2,added,prio) VALUES ('$date1', '$sovtime', '$sovtime', 10)");
}
include('readalli.php5');
?>