root/sovereignty/readalli.php5 @ 432

<?php
include_once('evedb.php');
#include('db_mysql.php');
#$edb = new mysql('localhost', 'user', 'pass', 'database');

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

    if ($name == 'ROW')
    {
        foreach ($attrs as $key => $value)
        {
            $attrs[$key] = addslashes($value);
        }
        $rows = join(',', array_keys($attrs));
        $values = join("','", $attrs);
        $query = 'REPLACE INTO alliances ('.$rows.') VALUES (\''.$values.'\')';
        $edb->query($query);
    }
}

function endElement2($parser, $name)
{

}

function characterData2($parser, $data)
{
    global $sovtime;
    if (!isset($sovtime))
    {
        $sovtime = $data;
    }
}


if (empty($argv))
{
    $data = file_get_contents('http://api.eve-online.com/eve/AllianceList.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, "startElement2", "endElement2");
xml_set_character_data_handler($p, "characterData2");

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

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