public function GetOutput($Db)
{
global $shpgroups, $owngroups, $interesting, $facmods, $offmods, $sort, $ord, $cols;
$Members = new eveApiMembers($Db);
$full_url = FULL_URL;
// TODO
$time_start = microtime_float();
if (!$Members->fetch(CHAR_ID, USER_ID, API_KEY, KEY_MASK & corp_MemberTrackingExtended == corp_MemberTrackingExtended)) {
$this->Output = $Members->Error;
return false;
}
$time_end = microtime_float();
$time_api = $time_end - $time_start;
date_default_timezone_set("UTC");
$this->Updated = APITime($Members);
$this->Title = isset($_GET['char']) ? "Character roles info" : USER_NAME . " Membership";
if (isset($_GET['char'])) {
// TODO
/* $result = $Members->entries->xpath("//*[@characterID=".$_GET['char']."]");
if (count($result) != 0) {
$char = $result[0];
$this->Output .= "<h3>Roles for " . $char["name"]."</h3>";
$roles = bin((float)$char["roles"]);
$roleDescriptions = array(1=>"pos fueler",7=>
'personal manager','accountant','security officer',
'factory manager','station manager','auditor',
'hanger can take division 1','hanger can take division 2',
'hanger can take division 3','hanger can take division 4',
'hanger can take division 5','hanger can take division 6',
'hanger can take division 7',
'hanger can query division 1','hanger can query division 2',
'hanger can query division 3','hanger can query division 4',
'hanger can query division 5','hanger can query division 6',
'hanger can query division 7',
'account can take division 1','account can take division 2',
'account can take division 3','account can take division 4',
'account can take division 5','account can take division 6',
'account can take division 7',
'account can query division 1','account can query division 2',
'account can query division 3','account can query division 4',
'account can query division 5','account can query division 6',
'account can query division 7',
'equipment config',
'container can take division 1','container can take division 2',
'container can take division 3','container can take division 4',
'container can take division 5','container can take division 6',
'container can take division 7',
'can rent office','can rent factory slot','can rent research slot',
'junior accountant','starbase config','starbase fuel'
);
$this->Output .= "<br>";
} else
$this->Output .= "Character not found";
*/
} else {
/////////////////////////////////////////////////
$sql = "SELECT groupName, groupID FROM " . DB_PREFIX . "invGroups WHERE categoryID = 6";
$result = mysql_query($sql, $Db->link);
$shpgroups = array();
while ($row = mysql_fetch_assoc($result)) {
$shpgroups[$row["groupID"]] = $row["groupName"];
}
mysql_free_result($result);
$owngroups = array();
function ship_group_Add($type)
{
global $Db, $shpgroups, $owngroups;
if (array_key_exists((int) $type["groupID"], $shpgroups)) {
if (!isset($owngroups[$type["groupID"]])) {
$owngroups[$type["groupID"]] = 1;
} else {
$owngroups[$type["groupID"]]++;
}
}
}
/////
function shortloc($loc)
{
if (strpos($loc, " - ") != false) {
return substr($loc, 0, strpos($loc, " - "));
}
return $loc;
}
$result = $Members->entries;
$ord = "ASC";
$cols = array("name", "joined", "title", "laston", "location", "ship", "hasroles");
foreach ($result as $entry) {
if (!isset($entry["logoffDateTime"])) {
$cols = array("name", "joined", "title");
$lofi = true;
}
break;
}
$sort = null;
if (!isset($nosorting) && isset($_GET['sort'])) {
if (in_array($_GET['sort'], $cols)) {
$sort = $_GET['sort'];
if (isset($_GET['order'])) {
if ($_GET['order'] == "DESC") {
$ord = "DESC";
}
}
$this->Output .= "<br>sorting by {$sort}, " . strtolower($ord) . " <a href=\"{$full_url}&view=members\">[no sort]</a><br><br>";
}
} else {
$this->Output .= "<br>";
}
if (count($result) > 0) {
$entries = array();
//"name","joined","title","laston","ship","has roles"
foreach ($result as $entry) {
$new = array();
$new["id"] = (string) $entry["characterID"];
$new["name"] = (string) $entry["name"];
$new["joined"] = (string) $entry["startDateTime"];
$new["title"] = (string) $entry["title"];
$new["laston"] = (string) $entry["logoffDateTime"];
$new["ship"] = (string) $entry["shipType"];
$new["hasroles"] = (int) $entry["roles"] != 0 ? (string) $entry["roles"] == "9223372036854775807" ? "DIRECTOR" : "yes" : "";
$new["location"] = shortloc((string) $entry["location"]);
if ((int) $entry["shipTypeID"] != -1) {
ship_group_Add($Db->getTypeFromTypeId((int) $entry["shipTypeID"]));
}
$entries[] = $new;
}
if ($sort != null && array_key_exists($sort, $entries[0])) {
usort($entries, "globl_sortfunc");
} else {
$sort = "name";
usort($entries, "globl_sortfunc");
}
$namedowngroups = array();
foreach ($owngroups as $group_id => $cnt) {
$namedowngroups[$shpgroups[$group_id]] = $cnt;
}
ksort($namedowngroups);
$this->Output .= "<table><tr><td>";
$this->Output .= count($result) . " members<br>";
$this->Output .= "<table class=\"fancy members\" style=\"font-size:83%;\" border=1>";
$this->Output .= "<tr>";
foreach ($cols as $col) {
$this->Output .= "<th>";
if (!isset($nosorting)) {
$this->Output .= "<a href=\"{$full_url}&view=members&sort={$col}&order=" . ($sort == $col && $ord == "ASC" ? "DESC" : "ASC") . "\">";
}
$this->Output .= $col;
if (!isset($nosorting)) {
$this->Output .= "</a>";
}
$this->Output .= "</th>";
}
$this->Output .= "</tr>";
$alt = " class=\"main\"";
//"name","timeincorp","title","laston","ship","hasroles");
foreach ($entries as $entry) {
if ($alt == " class=\"main\"") {
$alt = " class=\"alt\"";
} else {
$alt = " class=\"main\"";
}
$this->Output .= "<tr {$alt}>";
$this->Output .= "<th scope=\"row\">" . str_replace(" ", " ", $entry["name"]) . " </th>";
$this->Output .= "<td>" . str_replace(" ", " ", ptime($entry["joined"])) . "</td>";
$this->Output .= "<td width=200>" . str_replace(" ", " ", $entry["title"]) . "</td>";
if (!isset($lofi)) {
$this->Output .= "<td>" . str_replace(" ", " ", ptime($entry["laston"])) . "</td>";
$this->Output .= "<td>" . str_replace(" ", " ", $entry["location"]) . "</td>";
$this->Output .= "<td>" . str_replace(" ", " ", $entry["ship"]) . "</td>";
//$this->Output .= "<td><a href=\"$full_url&view=members&char=".$entry["id"]."\">".$entry["hasroles"]."</a></td>";
$this->Output .= "<td>" . $entry["hasroles"] . "</td>";
}
$this->Output .= "</tr>\n";
}
$this->Output .= "</table>";
$this->Output .= "</td><td valign=\"top\">";
///// shiptypes
if (!isset($lofi)) {
$this->Output .= "<table>";
$this->Output .= "<tr><th>type</th><th># owned</th></tr>";
foreach ($namedowngroups as $group => $cnt) {
$this->Output .= "<tr><td> " . str_replace(" ", " ", $group) . " </td><td>{$cnt}</td></tr>\n";
}
$this->Output .= "</table><br>";
}
$this->Output .= "</td></tr></table><br>";
}
}
$this->Times = getPageTimes($Db, $time_api, microtime_float() - $time_start);
return true;
}
die;
}
if ($argv[1] == "--compile") {
compile();
die;
}
if ($argv[1] == "--status") {
BuildDatabaseStatus();
die;
}
if ($argv[1] == "--refresh-index") {
GET_MD5S_REMOTE();
die;
}
if ($argv[1] == "--ptime") {
ptime();
die;
}
Execute();
function ptime()
{
$unix = new unix();
echo $unix->IsProductionTime() . "\n";
}
function build_progress($text, $pourc)
{
ufdbevents("{$pourc}% {$text}");
$GLOBALS["CACHEFILE"] = "/usr/share/artica-postfix/ressources/logs/web/toulouse-unversity.progress";
WriteMyLogs("{$pourc}% {$text}", __FUNCTION__, __FILE__, __LINE__);
$array["POURC"] = $pourc;
$array["TEXT"] = $text;