/** * API::API_UpdatePrices() * Using EVE Marketdata for now only. * @return */ function API_UpdatePrices($args) { if ($args <= 999999) { $args = 10000002; //Default to Jita(The Forge) } $url = "http://eve-marketdata.com/api/item_prices.xml?type_ids=44,3683,3689,9832,9848,16274,17889,17887,17888,16273,16272,4247,4051,4312,4246®ion_ids=" . $args; $xml = $this->API_Connect2($url); if (!$xml) { return false; } $fail = 0; $time = time(); $dbconn =& DBGetConn(true); $count = 0; foreach ($xml->xpath('//price') as $row) { $sql = "UPDATE " . TBL_PREFIX . "prices\n SET Value = '" . Eve::VarPrepForStore($row) . "'\n WHERE typeID = '" . Eve::VarPrepForStore($row['id']) . "'"; $dbconn->Execute($sql); if ($dbconn->ErrorNo() != 0) { Eve::SessionSetVar('errormsg', 'Could not update prices! ; ' . $dbconn->ErrorMsg()); return false; } $count = $count + 1; } return $count; }
function GetMinmatarTowers() { $dbconn =& DBGetConn(true); $sql = "SELECT *\n FROM " . TBL_PREFIX . "tower_info\n WHERE pos_race = '4'"; $result = $dbconn->Execute($sql); if ($dbconn->ErrorNo() != 0) { Eve::SessionSetVar('errormsg', $dbconn->ErrorMsg() . $sql); return false; } for (; !$result->EOF; $result->MoveNext()) { $rows[] = $result->GetRowAssoc(2); } $result->Close(); return $rows; }
function AddNewMoonMaterial($args) { if (!$args) { Eve::SessionSetVar('errormsg', 'No Arguments!'); return false; } $userinfo = POSMGMT::GetUserInfo(); $characterID = $userinfo['eve_id']; $dbconn =& DBGetConn(true); $sql = "INSERT INTO " . TBL_PREFIX . "moonmaterials (moonID,\n material_id,\n abundance,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t notes,\n taken,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t characterID,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t datetime)\n VALUES ('" . Eve::VarPrepForStore($args['moonID']) . "',\n '" . Eve::VarPrepForStore($args['material_id']) . "',\n '" . Eve::VarPrepForStore($args['abundance']) . "',\n '" . Eve::VarPrepForStore($args['notes']) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t '" . Eve::VarPrepForStore($args['taken']) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t '" . Eve::VarPrepForStore($characterID) . "',\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t '" . Eve::VarPrepForStore(time()) . "')"; $dbconn->Execute($sql); if ($dbconn->ErrorNo() != 0) { Eve::SessionSetVar('errormsg', $dbconn->ErrorMsg() . $sql); return false; } return true; }
function MoonDB_uninstall() { global $posmgmt; $tables = array(TBL_PREFIX . 'moonmaterials'); $values = array('test', 'test1', 'test2'); $dbconn =& DBGetConn(true); foreach ($tables as $table) { $dbconn->Execute("DROP TABLE IF EXISTS " . $table); if ($dbconn->ErrorNo() != 0) { Eve::SessionSetVar('errormsg', "Problem with table: " . $table); return false; } } foreach ($values as $value) { $posmgmt->ModuleDelVar('MoonDB', $value); } return 0; }
function Ajax_CheckDB() { global $eve, $eveRender, $stoppage; $host = $eve->VarCleanFromInput('dbhost'); $user = $eve->VarCleanFromInput('dbuname'); $pass = $eve->VarCleanFromInput('dbpass'); $db = $eve->VarCleanFromInput('dbname'); if (empty($host)) { $host = 'localhost'; } $dbok = false; $server = false; $goforit = false; include_once 'includes/dbfunctions.php'; $GLOBALS['dbconfig']['dbtype'] = 'mysql'; $GLOBALS['dbconfig']['dbhost'] = $host; $GLOBALS['dbconfig']['dbname'] = $db; $GLOBALS['dbconfig']['dbuname'] = $user; $GLOBALS['dbconfig']['dbpass'] = $pass; $GLOBALS['dbconfig']['pconnect'] = 0; $GLOBALS['dbconfig']['encoded'] = 0; $GLOBALS['dbconfig']['debug'] = 0; $GLOBALS['dbdebug']['debug_sql'] = 0; $answer = ''; if (empty($user)) { return 'No database username'; } if (!DBInit()) { $mysqlerror = 'Database Failure!'; //$dbconn->ErrorMsg(); $server = false; $selectdb = false; $stoppage = true; } else { $server = true; if (!($dbconn =& DBGetConn(true))) { $answer .= 'Connection Failed!'; $stoppage = true; } else { $selectdb = $dbconn->SelectDB($db); if (!$selectdb) { $mysqlerror = 'Unknown Database'; $stoppage = true; } if (!$stoppage) { $result = $dbconn->Execute('SELECT VERSION() AS version'); if ($dbconn->ErrorNo() != 0) { $selectdb = true; $mysqlerror = $dbconn->ErrorMsg(); $stoppage = true; } else { list($version) = $result->fields; } } } if (!$stoppage) { $goforit = true; } } if ($goforit) { $answer .= 'DATABASE OK - Version: ' . $version . ' - Hit the Write button to save the configuration.'; } else { $answer .= $mysqlerror; } return $answer; }
$eve->SessionSetVar('errormsg', 'Admin Not Logged In!'); $eve->RedirectUrl('login.php'); } $upgradeList = array(333 => 'FG Update for Tyrannis', 501 => 'v5.0.1 - Material Volume Fix', 502 => 'v5.0.2 - Theme Install', 511 => 'v5.1.1 - Incursion DB & Corp Jobs Install', 512 => 'v5.1.2 - Prices & Ship Assembly Array Fix', 514 => 'v5.1.4 - User & Global Settings Update', 517 => 'v5.1.7 - Hyasyoda ML & Wormhole Update', 520 => 'v5.2.0 - Fuel Block Support'); $eveRender->Assign('upgradeList', $upgradeList); $step = $eve->VarCleanFromInput('step'); $step = empty($step) ? $step = 1 : $step; if ($step <= 1) { $install = false; } $upgrade = $eve->VarCleanFromInput('upgrade'); if ($step == 1) { $eveRender->Assign('step', $step); } if ($step == 2) { $dbconn =& DBGetConn(true); $sql = file_get_contents('install/upgrade/' . $upgrade . '.sql'); $sql = preg_replace('/%prefix%/', TBL_PREFIX, $sql); $sql = trim($sql); $sql = explode(';', $sql); foreach ($sql as $query) { $query = trim($query); $dbconn->Execute($query); if (empty($query)) { continue; } $sqls[] = $query; } $eveRender->Assign('querycount', 0); $eveRender->Assign('querytotal', count($sqls)); $eveRender->Assign('step', $step);
/** * POSMGMT::ModuleLoadVars() * * @return */ function ModuleLoadVars() { unset($GLOBALS['modconfig']); $dbconn =& DBGetConn(true); $sql = "SELECT modname,\n name,\n value\n FROM " . TBL_PREFIX . "module_vars"; $result = $dbconn->Execute($sql); if ($dbconn->ErrorNo() != 0) { echo $dbconn->ErrorMsg() . ($this->debug ? '<br />' . $sql : ''); return false; } //$values = array(); $GLOBALS['modconfig'] = array(); for (; !$result->EOF; $result->MoveNext()) { list($modname, $key, $value) = $result->fields; $GLOBALS['modconfig'][$modname][$key] = is_array(unserialize($value)) ? unserialize($value) : $value; } $result->Close(); return $GLOBALS['modconfig']; }
function UpdateSiloAmount($args) { global $eve; if (!isset($args['structure_id']) || !is_numeric($args['structure_id'])) { return false; } if (!isset($args['new_amount']) || !is_numeric($args['new_amount'])) { return false; } $dbconn =& DBGetConn(true); $sql = "UPDATE " . TBL_PREFIX . "silo_info SET material_ammount = '" . Eve::VarPrepForStore($args['new_amount']) . "' WHERE silo_id = '" . Eve::VarPrepForStore($args['structure_id']) . "'"; $dbconn->Execute($sql); if ($dbconn->ErrorNo() != 0) { echo $dbconn->ErrorMsg() . $sql; return false; } $time = time(); $sql = "INSERT INTO " . TBL_PREFIX . "update_log VALUES ('NULL', '1', '" . Eve::VarPrepForStore($args['structure_id']) . "', '2', 'Update Silo', '" . Eve::VarPrepForStore($time) . "')"; $dbconn->Execute($sql); if ($dbconn->ErrorNo() != 0) { echo $dbconn->ErrorMsg() . $sql; return false; } $filter_regionID = $eve->VarCleanFromInput('filter_regionID'); $filter_systemID = $eve->VarCleanFromInput('filter_systemID'); $filter_pos_id = $eve->VarCleanFromInput('filter_pos_id'); $url = 'production.php'; //if ($filter_systemID || $filter_regionID) { $eve->RedirectUrl('production.php?filter_regionID=' . $filter_regionID . '&filter_systemID=' . $filter_systemID . '&filter_pos_id=' . $filter_pos_id); }