// Find Core Pathing
if (file_exists(dirname(dirname(dirname(__FILE__))) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(dirname(dirname(__FILE__))) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists(dirname(__FILE__) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists("core.class.php")) {
require_once "core.class.php";
} else {
}
$core = new Core();
$GLOBALS["core"] = $core;
// Prepares URL DATA to include price infomation for all items listed in the operational_items database.
$tempcount = 0;
$result = $core->SQL("SELECT EveTypeID FROM `production_items` WHERE Type = 2");
while ($row = mysql_fetch_assoc($result)) {
ProcessItem($row['EveTypeID']);
}
$core->Log("CRON(Eve-Central Market Data - Production) Done. All operational items were process successfully.");
function ProcessItem($itemid)
{
$core = $GLOBALS["core"];
$evecentralsite = "http://api.eve-central.com/api/marketstat?typeid=" . $itemid . "®ionlimit=10000002";
$raw = file_get_contents($evecentralsite);
if ($raw !== FALSE) {
$xml = new SimpleXMLElement($raw);
foreach ($xml->marketstat->children() as $item) {
$eveitemid = (int) $item["id"];
$registered = $core->SQL("SELECT COUNT(*) FROM `operations_marketdata` WHERE EveTypeID =" . $eveitemid);
$total_records = mysql_num_rows($registered);
// If we fail the check, the user will be redirected to an error page.
// Goto($url) is a method of the core object which is a shorthand for { header("Location: $url); exit; }
if ($core->CurrentUser()->AccessRight() < 1) {
$core->Goto('../../php/access.php');
}
// User name
$username = $core->CurrentUser()->Name;
// Browser string
$browser = @$_SERVER["HTTP_USER_AGENT"];
if (empty($browser)) {
$browser = "Unknown";
}
// Save username and browser string in our database
// SQL($query) is a method of the Core object that runs a SQL query on the plugin database
// SQLEscape($string) is also a Core method that is a shorthand for mysql_real_escape_string($string)
$core->SQL("INSERT INTO `browserstats` (`User`, `Browser`) VALUES ('" . $core->SQLEscape($username) . "', '" . $core->SQLEscape($browser) . "') ON DUPLICATE KEY UPDATE `Browser`='" . $core->SQLEscape($browser) . "'");
// Read the database
$result = $core->SQL("SELECT * FROM `browserstats`");
$browserstats = array();
while ($row = mysql_fetch_assoc($result)) {
$br = new Browser($core->SQLUnEscape($row["Browser"]));
$browsername = "{$br->Platform}, {$br->Name} {$br->Version}";
if (isset($browserstats[$browsername])) {
$browserstats[$browsername] += 1;
} else {
$browserstats[$browsername] = 1;
}
}
// We have the browser stats in an array. Now assign it to a Smarty template variable
// So that it will be availabe in the Smarty template.
// You can assign any type of variable: numbers, strings, arrays, objects... all work
<?php
require_once '../../core/core.class.php';
$core = new Core();
//Access control
if ($core->CurrentUser()->AccessRight() < 2) {
$core->Goto('../../php/access.php');
}
$action = @$_GET["action"];
if (empty($action)) {
$action = "home";
}
$names = $core->GetAllUserNames();
$core->assign("names", $names);
if ($action == "times" || @$_POST["submit"] == "Add Player" || substr(@$_POST["submit"], 0, 13) == "Remove Player") {
$result = $core->SQL("SELECT Distinct `GroupID` FROM `operations_items` Order By `GroupID`");
while ($row = mysql_fetch_assoc($result)) {
$var = "group" . $row['GroupID'];
$core->assign($var, @$_POST[$var]);
$groupnumber[$row['GroupID']] = @$_POST["group" . $row['GroupID']];
}
$core->assign("groupnumber", $groupnumber);
$opdate = @$_POST["opdate"];
if (empty($opdate)) {
$opdate = gmdate("Y-m-d");
}
$core->assign("opdate", $opdate);
$count = @$_POST["count"];
$players = array();
if (empty($count)) {
$count = 0;
require_once '../../core/core.class.php';
$core = new Core();
//Access control
if ($core->CurrentUser()->AccessRight() < 2) {
$core->Goto('../../php/access.php');
}
$action = @$_GET["action"];
if (isset($_GET["edit"]) || isset($_GET["view"])) {
if (isset($_GET["edit"])) {
$id = $_GET["edit"];
$action = "edit";
} else {
$id = $_GET["view"];
$action = "view";
}
$result = $core->SQL("SELECT * FROM operations_submissions WHERE id=" . $id . " LIMIT 1");
$row = mysql_fetch_assoc($result);
$canedit = $row["Leader"] == $core->CurrentUser()->ID || in_array($core->CurrentUser()->ID, explode(",", $row["Players"]));
// Op Status
// 0 - New
// 1 - Resubmitted
// 2 - Canceled
// 3 - Rejected
// 4 - Paid
if ($row["Status"] == 4) {
$canedit = false;
}
if ($core->IsIGB()) {
$canedit = false;
}
if ($core->CurrentUser()->AccessRight() < 3) {
//Access control
if ($core->CurrentUser()->AccessRight() < 4) {
$core->Goto('../../php/access.php');
}
$action = @$_GET["action"];
if ($action == "payout") {
$names = $core->GetAllUserNames();
$opids = array();
foreach ($_POST as $key => $value) {
if (substr($key, 0, 2) == "op" && $value == "on") {
$opids[] = substr($key, 2);
}
}
if ($_POST["submit"] == "Reject") {
// Reject selected ops
$core->SQL("UPDATE operations_submissions SET Status=3, RejectReason='" . $core->SQLEscape($_POST["reject"]) . "' WHERE FIND_IN_SET(id, '" . implode(",", $opids) . "')");
// Send messages to op leaders
$result = $core->SQL("SELECT id, OpDate, Leader FROM operations_submissions WHERE FIND_IN_SET(id, '" . implode(",", $opids) . "')");
while ($row = mysql_fetch_assoc($result)) {
$id = $row["id"];
$date = date("Y-m-d", strtotime($row["OpDate"]));
$leader = $row["Leader"];
$text = "<p>Following operation submitted by you was rejected by " . $core->CurrentUser()->Name . ".</p>";
$text .= "<p><a href='../plugins/payoutview/index.php?view=" . $id . "'>View Rejected Operation</a></p>";
$text .= "<p><b>REASON:</b><br />" . $_POST["reject"] . "</p>";
$core->SendMail($date . " Operation Rejected", $text, $leader);
}
$core->Goto("index.php");
} else {
$corpcut = $_POST["corpcut"];
$result = $core->SQL("SELECT * FROM operations_params");
}
if ($action == "home" || $action == "user" || $action == "recruitment") {
$page = @$_GET["page"];
if (empty($page)) {
$page = 1;
}
$max = 25;
$path = dirname(__FILE__) . DIRECTORY_SEPARATOR . "images";
if (!file_exists($path)) {
mkdir($path);
}
$baseurl = "http://" . $_SERVER["SERVER_NAME"] . "/plugins/gallery/images/";
$names = $core->GetAllUserNames();
if ($action == "home") {
if ($core->CurrentUser()->AccessRight() == 0) {
$result = $core->SQL("SELECT COUNT(*) FROM gallery");
$pagecount = ceil(mysql_result($result, 0) / $max);
$result = $core->SQL("SELECT * FROM gallery WHERE Owner=" . $core->CurrentUser()->ID . " AND AccessRight=1 ORDER BY Date DESC LIMIT " . $max * ($page - 1) . "," . $max);
} else {
$result = $core->SQL("SELECT COUNT(*) FROM gallery");
$pagecount = ceil(mysql_result($result, 0) / $max);
$result = $core->SQL("SELECT * FROM gallery WHERE " . $core->CurrentUser()->AccessRight() . ">=AccessRight AND AccessRight!=-1 AND AccessRight!=1 ORDER BY Date DESC LIMIT " . $max * ($page - 1) . "," . $max);
}
} elseif ($action == "recruitment") {
if ($core->CurrentUser()->AccessRight() < 3) {
$core->Goto('../../php/access.php');
}
$recruitment = $_GET["recruitment"];
if ($recruitment == "all") {
$result = $core->SQL("SELECT COUNT(*) FROM gallery");
$pagecount = ceil(mysql_result($result, 0) / $max);
require_once dirname(dirname(dirname(__FILE__))) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists(dirname(__FILE__) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists("core.class.php")) {
require_once "core.class.php";
} else {
}
$core = new Core();
$GLOBALS["core"] = $core;
$marketid = $core->GetSetting("MarketLocation");
$markethanger = $core->GetSetting("MarketHanger");
$CorpStorePrice = $core->GetSetting("CorpStorePrice");
$AllyStorePrice = $core->GetSetting("AllyStorePrice");
$result1 = $core->SQL("SELECT DISTINCT nameid, SUM(qty) as 'Totalqty' FROM info_assets WHERE itemidm = " . $marketid . " AND flag = " . $markethanger . " GROUP BY nameid");
//echo "SELECT DISTINCT nameid FROM info_assets WHERE itemidm = ".$marketid."<br>";
while ($row = mysql_fetch_assoc($result1)) {
$nameid = $row['nameid'];
$stock = $row['Totalqty'];
//Production Items Database Update.
$registered = $core->SQL("SELECT * FROM `production_items` WHERE EveTypeID = " . $nameid . " AND Type = 2");
$total_records = mysql_num_rows($registered);
if ($total_records == 0) {
$result2 = $core->EVESQL("SELECT * FROM invTypes_expanded WHERE typeID = " . $nameid);
while ($row2 = mysql_fetch_assoc($result2)) {
$typeID = $row2['typeID'];
$groupID = $row2['groupID'];
$typeName = $core->SQLEscape($row2['typeName']);
$graphicID = $row2['graphicID'];
$marketGroupID = $row2['marketGroupID'];
<?php
require_once '../../core/core.class.php';
$core = new Core();
$path = dirname(__FILE__) . DIRECTORY_SEPARATOR . "images";
if (!file_exists($path)) {
mkdir($path);
}
$baseurl = "http://" . $_SERVER["SERVER_NAME"] . "/plugins/gallery/images/";
$names = $core->GetAllUserNames();
$action = @$_GET["action"];
if (empty($action)) {
$action = "home";
}
if ($action == "home") {
$result = $core->SQL("SELECT * FROM gallery WHERE \n" . $core->CurrentUser()->AccessRight() . ">=AccessRight AND AccessRight!=-1 \nAND AccessRight!=1 ORDER BY Date DESC");
} else {
$result = $core->SQL("SELECT * FROM gallery WHERE Owner=" . $core->CurrentUser()->ID . " ORDER BY Date DESC");
}
$gallery = array();
while ($row = mysql_fetch_assoc($result)) {
$name = $row["Owner"] . "_" . $row["id"] . "." . $row["Extension"];
// Create thumbnail
$thumb = $row["Owner"] . "_" . $row["id"] . "_thumb.jpg";
if (file_exists($path . DIRECTORY_SEPARATOR . $name)) {
if (!file_exists($path . DIRECTORY_SEPARATOR . $thumb)) {
if ($row["Extension"] == "gif") {
$im = @imagecreatefromgif($path . DIRECTORY_SEPARATOR . $name);
} elseif ($row["Extension"] == "jpg") {
$im = @imagecreatefromjpeg($path . DIRECTORY_SEPARATOR . $name);
} elseif ($row["Extension"] == "png") {
<?php
require_once '../../core/core.class.php';
$core = new Core();
$item = $_GET["item"];
// Read material prices
$result = $core->SQL("SELECT EveTypeID,Price FROM operations_items");
$itemprices = array();
while ($row = mysql_fetch_assoc($result)) {
$itemprices[$row["EveTypeID"]] = (double) $row["Price"];
}
mysql_free_result($result);
// Read material quantites from EVE DB
$query = "SELECT graphics.icon AS Icon, typeReq.typeName as Name, typeReq.typeID AS EveTypeID, IF(typeReq.groupID = 332, materials.quantity, CEIL(materials.quantity*(1+bluePrint.wasteFactor/100))) AS Quantity ";
$query .= "FROM TL2MaterialsForTypeWithActivity AS materials ";
$query .= "INNER JOIN invTypes AS typeReq ON materials.requiredtypeID = typeReq.typeID ";
$query .= "INNER JOIN invGroups AS typeGroup ON typeReq.groupID = typeGroup.groupID ";
$query .= "INNER JOIN invBlueprintTypes AS bluePrint ON materials.typeID = bluePrint.blueprintTypeID ";
$query .= "INNER JOIN eveGraphics AS graphics ON typeReq.graphicID = graphics.graphicID ";
$query .= "WHERE bluePrint.productTypeID=" . $item . " AND Quantity>0 AND materials.activity = 1 AND typeGroup.categoryID NOT IN (6, 7, 16) ORDER BY typeReq.marketGroupID, Name ASC";
$result = $core->EveSQL($query);
$eveprices = array();
$total = 0;
while ($row = mysql_fetch_assoc($result)) {
if (isset($itemprices[$row["EveTypeID"]])) {
$unit = $itemprices[$row["EveTypeID"]];
$price = $itemprices[$row["EveTypeID"]] * (double) $row["Quantity"];
} else {
$unit = 0;
$price = 0;
}
if (empty($action)) {
$action = "home";
}
if ($action == "summary") {
$action = "summary";
}
if (isset($_GET["delete"])) {
$action = "delete";
}
if (isset($_GET["result"])) {
$core->assign('result', $_GET["result"]);
}
if ($action == "home") {
$names = $core->GetAllUserNames();
$names[0] = "-";
$result = $core->SQL("SELECT t1.id,t1.Notes,t1.Owner,t1.Date,t1.Priority,t1.Count,t1.IsAlly,t2.Price,t2.AlliancePrice,t1.Manager,t1.Status,t2.EveGraphicID,t2.GroupName,t2.Race,t2.Name FROM production_orders AS t1 INNER JOIN production_items AS t2 ON t1.Item=t2.id WHERE t1.IsDeleted=0 ORDER BY t1.Priority DESC, t1.Date ASC");
$orders = array();
$total = 0;
while ($row = mysql_fetch_assoc($result)) {
$price = $row["IsAlly"] ? $row["AlliancePrice"] : $row["Price"];
$orders[] = array("ID" => $row["id"], "Priority" => PriorityName($row["Priority"]), "Notes" => $core->SQLUnEscape($row["Notes"]), "Owner" => $names[$row["Owner"]], "IsAlly" => $row["IsAlly"], "Manager" => $names[$row["Manager"]], "Status" => StatusName($row["Status"]), "EveGraphicID" => $row["EveGraphicID"], "GroupName" => $core->SQLUnEscape($row["GroupName"]), "Race" => $core->SQLUnEscape($row["Race"]), "Name" => $core->SQLUnEscape($row["Name"]), "Count" => $row["Count"], "Price" => number_format($price, 0), "Cost" => number_format($row["Count"] * $price, 0), "Date" => $core->GMTToLocal($row["Date"]));
$total += $row["Count"] * $price;
}
mysql_free_result($result);
$core->assign("orders", $orders);
$core->assign("total", number_format($total, 0));
// Misc orders
$result = $core->SQL("SELECT id,Owner,Date,Notes FROM production_orders WHERE IsDeleted=0 AND Item=0 ORDER BY Date DESC");
$misc = array();
$total = 0;
while ($row = mysql_fetch_assoc($result)) {
// Find Core Pathing
if (file_exists(dirname(dirname(dirname(__FILE__))) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(dirname(dirname(__FILE__))) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists(dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(dirname(__FILE__)) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists(dirname(__FILE__) . DIRECTORY_SEPARATOR . "core.class.php")) {
require_once dirname(__FILE__) . DIRECTORY_SEPARATOR . "core.class.php";
} elseif (file_exists("core.class.php")) {
require_once "core.class.php";
} else {
}
$core = new Core();
$GLOBALS["core"] = $core;
// Prepares URL DATA to include price infomation for all items listed in the operational_items database.
$tempcount = 0;
$result = $core->SQL("SELECT EveTypeID FROM `operations_items`");
while ($row = mysql_fetch_assoc($result)) {
ProcessItem($row['EveTypeID']);
}
$core->Log("CRON(Eve-Central Market Data) Done. All operational items were process successfully.");
function ProcessItem($itemid)
{
$core = $GLOBALS["core"];
$evecentralsite = "http://api.eve-central.com/api/marketstat?typeid=" . $itemid . "®ionlimit=10000002";
$raw = file_get_contents($evecentralsite);
if ($raw !== FALSE) {
$xml = new SimpleXMLElement($raw);
foreach ($xml->marketstat->children() as $item) {
$eveitemid = (int) $item["id"];
$registered = $core->SQL("SELECT COUNT(*) FROM `operations_marketdata` WHERE EveTypeID =" . $eveitemid);
$total_records = mysql_num_rows($registered);
}
$action = @$_GET["action"];
if (empty($action)) {
$action = "home";
}
if (isset($_GET["delete"])) {
$action = "delete";
}
if (isset($_GET["edit"])) {
$action = "edit";
}
if ($action == "home" || $action == "homeships" || $action == "homerigs") {
$itemids = array();
// Read ship prices
if ($action == "homeships" || $action == "home") {
$result = $core->SQL("SELECT * FROM production_items WHERE Type=0 ORDER BY GroupName ASC, Race ASC, `Name` ASC");
$dbprices = array();
while ($row = mysql_fetch_assoc($result)) {
$dbprices[] = array("ID" => $row["id"], "EveTypeID" => $row["EveTypeID"], "EveGraphicID" => $row["EveGraphicID"], "GroupName" => $core->SQLUnEscape($row["GroupName"]), "Race" => $core->SQLUnEscape($row["Race"]), "Name" => $core->SQLUnEscape($row["Name"]), "Price" => number_format($row["Price"], 0), "AlliancePrice" => number_format($row["AlliancePrice"], 0));
$itemids[] = $row["EveTypeID"];
}
mysql_free_result($result);
$core->assign("shipprices", $dbprices);
}
// Read rig prices
if ($action == "homerigs" || $action == "home") {
$result = $core->SQL("SELECT * FROM production_items WHERE Type=1 ORDER BY GroupName ASC, `Name` ASC");
$dbprices = array();
while ($row = mysql_fetch_assoc($result)) {
$dbprices[] = array("ID" => $row["id"], "EveTypeID" => $row["EveTypeID"], "EveGraphicID" => $row["EveGraphicID"], "GroupName" => $core->SQLUnEscape($row["GroupName"]), "Race" => $core->SQLUnEscape($row["Race"]), "Name" => $core->SQLUnEscape($row["Name"]), "Price" => number_format($row["Price"], 0), "AlliancePrice" => number_format($row["AlliancePrice"], 0));
$itemids[] = $row["EveTypeID"];
$action = "home";
}
if ($portalid == "" || empty($portalid) || $portalid < 0 || $core->CharacterIDExists($portalid) == "FALSE") {
$portalid = $core->CurrentUser()->ID;
}
if ($template == "" || empty($template) || $template < 0) {
$template = 0;
}
if ($templatepost == "" || empty($templatepost) || $templatepost < 0) {
$templatepost = 0;
}
if ($return == "" || empty($return) || $return < 0) {
$return = 0;
}
if ($action == "home") {
$result = $core->SQL("SELECT * FROM operations_params");
while ($row = mysql_fetch_assoc($result)) {
if ($row["Name"] == "IndexDate") {
$core->assign("indexdate", $row["Value"]);
}
if ($row["Name"] == "IndexTime") {
$core->assign("indextime", $row["Value"]);
}
}
} elseif ($action == "qtc7" || $action == "qtc30") {
$timeperiod = 7;
if ($action == "qtc30") {
$timeperiod = 30;
}
$raw = file_get_contents("http://www.starvingpoet.net/feeds/mmi.xml");
if ($raw !== FALSE) {
}
$action = @$_GET["action"];
if (empty($action)) {
$action = "home";
}
if (isset($_GET["cancel"])) {
$action = "cancel";
}
if (isset($_GET["resubmit"])) {
$action = "resubmit";
}
if ($action == "home") {
$names = $core->GetAllUserNames();
$names[0] = "-";
if ($core->CurrentUser()->IsAlly) {
$result = $core->SQL("SELECT t1.id,t1.Date,t1.Count,t2.AlliancePrice AS Price,t1.Manager,t1.Status,t2.EveGraphicID,t2.GroupName,t2.Race,t2.Name FROM production_orders AS t1 INNER JOIN production_items AS t2 ON t1.Item=t2.id WHERE t1.Owner=" . $core->CurrentUser()->ID . " AND t1.IsDeleted=0 AND t1.Item!=0 AND t2.AlliancePrice!=0 ORDER BY t1.Date DESC LIMIT 50");
} else {
$result = $core->SQL("SELECT t1.id,t1.Date,t1.Count,t2.Price,t1.Manager,t1.Status,t2.EveGraphicID,t2.GroupName,t2.Race,t2.Name FROM production_orders AS t1 INNER JOIN production_items AS t2 ON t1.Item=t2.id WHERE t1.Owner=" . $core->CurrentUser()->ID . " AND t1.IsDeleted=0 AND t1.Item!=0 ORDER BY t1.Date DESC LIMIT 50");
}
$orders = array();
while ($row = mysql_fetch_assoc($result)) {
$orders[] = array("ID" => $row["id"], "Cost" => number_format($row["Count"] * $row["Price"], 0), "Manager" => $names[$row["Manager"]], "Status" => StatusName($row["Status"]), "StatusID" => $row["Status"], "Price" => $row["Price"], "EveGraphicID" => $row["EveGraphicID"], "GroupName" => $core->SQLUnEscape($row["GroupName"]), "Race" => $core->SQLUnEscape($row["Race"]), "Name" => $core->SQLUnEscape($row["Name"]), "Count" => $row["Count"], "Date" => $core->GMTToLocal($row["Date"]));
}
mysql_free_result($result);
$core->assign("orders", $orders);
} elseif ($action == "queue") {
$names = $core->GetAllUserNames();
$names[0] = "-";
$result = $core->SQL("SELECT t1.id,t1.Owner,t1.Date,t1.Count,t1.Manager,t1.Status,t2.EveGraphicID,t2.GroupName,t2.Race,t2.Name FROM production_orders AS t1 INNER JOIN production_items AS t2 ON t1.Item=t2.id WHERE t1.IsDeleted=0 AND t1.Item!=0 ORDER BY t1.Date DESC LIMIT 50");
$orders = array();
while ($row = mysql_fetch_assoc($result)) {
