root/dev/common/sync_server.php @ 31

<?php
require_once('db.php');

// modify the header here so the client gets our version
header('X-KBVersion: '.KB_VERSION);

if (!strstr($_SERVER['HTTP_USER_AGENT'], 'EVE-KB SYNC'))
{
    echo 'Current version is '.KB_VERSION.'.<br>';
    echo 'You should not call this file directly unless you\'re told to<br>';
    return;
}

// this is an example for version checking with client ban
// in case we change the protocol/data format
preg_match("^\(VER (.*?)\)^", $_SERVER['HTTP_USER_AGENT'], $match);
$version = explode('.', $match[1]);
if ($version[0] <= 1 && $version[1] < 1)
{
    echo "Your Killboard is too old, please upgrade to 1.2.0 or newer<br>\n";
    return;
}

// check if we got a file supplied with the request
if (!file_exists($_FILES['data']['tmp_name']))
{
    echo "malformed request<br>\n";
    return;
}

// we get a file, process
$data = gzinflate(file_get_contents($_FILES['data']['tmp_name']));

// get all names we'll find
preg_match_all("^!(.*?)\|(.*?)-^", &$data, $matches);
unset($data);
$results = count($matches[1]);
if ($results == 0)
{
    // if we got no ids from the client we won't send him ours
    // bad idea for new installations
    //echo "malformed request<br>\n";
    //return;
}

// construct an array with name as key and id as value
for ($i = 0; $i<$results; $i++)
{
    $s_data[$matches[1][$i]] = $matches[2][$i];
}

// now get our list from the database
$qry = new DBQuery();
$qry->execute("select plt_name, plt_externalid from kb3_pilots where plt_externalid != 0");
while ($data = $qry->getRow())
{
    $data_array[$data['plt_name']] = $data['plt_externalid'];
}
$update = new DBQuery();

// compare the entries supplied with our own
foreach ($s_data as $name => $id)
{
    if (!$data_array[$name])
    {
        // we dont got that one in our database, update
        // TODO: we don't care about missing pilots yet
        $update->execute("update kb3_pilots set plt_externalid='".$id."' where plt_name='".$name."'");
    }
    else
    {
        // unset to save comparison time, we know the client has it
        unset($data_array[$name]);
    }
}

// $data_array now contains only unknown ids to the client
$content_file = 'DATA_START';
foreach ($data_array as $name => $id)
{
    $content_file .= '!'.$name.'|'.$id.'-';
}

// return the compressed data back to the client
echo gzdeflate($content_file);
?>