Ejemplo n.º 1
0
 /**
  * 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&region_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;
 }
Ejemplo n.º 4
0
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;
}
Ejemplo n.º 5
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;
}
Ejemplo n.º 6
0
    $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);
Ejemplo n.º 7
0
 /**
  * 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);
}