/viewpos.php

<?php

/*

* Pos-Tracker2

*

* Starbase View page

*

* PHP version 5

*

* LICENSE: This file is part of POS-Tracker2.

* POS-Tracker2 is free software: you can redistribute it and/or modify

* it under the terms of the GNU General Public License as published by

* the Free Software Foundation, version 3 of the License.

*

* POS-Tracker2 is distributed in the hope that it will be useful,

* but WITHOUT ANY WARRANTY; without even the implied warranty of

* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the

* GNU General Public License for more details.

*

* You should have received a copy of the GNU General Public License

* along with POS-Tracker2.  If not, see <http://www.gnu.org/licenses/>.

*



* @author     Stephen Gulickk <stephenmg12@gmail.com>

* @author     DeTox MinRohim <eve@onewayweb.com>

* @author      Andy Snowden <forumadmin@eve-razor.com>

* @copyright  2007-2009 (C)  Stephen Gulick, DeTox MinRohim, and Andy Snowden

* @license    http://www.gnu.org/licenses/gpl-3.0.html GPL 3.0

* @package    POS-Tracker2

* @version    SVN: $Id: viewpos.php 305 2010-01-12 00:27:16Z stephenmg12 $

* @link       https://sourceforge.net/projects/pos-tracker2/

* @link       http://www.eve-online.com/

*/



if(!$index)

	die('Hack Attempt...');



EveDBInit();



include_once 'includes/production.php';



$eve->SessionSetVar('userlogged', 1);



$userinfo = $posmgmt->GetUserInfo();



$access = $eve->SessionGetVar('access');



$eveRender->Assign('access', $access);

$eveRender->Assign('config', $config);

//echo '<pre>';print_r($_SESSION); echo '</pre>';exit;



if ($access >= 1)

{

    $pos_id = $eve->VarCleanFromInput('i');

    if (!empty($pos_id))

	{

        $tower = $posmgmt->GetTowerInfo($pos_id);

        if ($tower)

		{

            $current_isotope         = $tower['isotope'];

            $outpost_id              = $tower['outpost_id'];

            $current_oxygen          = $tower['oxygen'];

            $current_mechanical_parts= $tower['mechanical_parts'];

            $current_coolant         = $tower['coolant'];

            $current_robotics        = $tower['robotics'];

            $current_uranium         = $tower['uranium'];

            $current_ozone           = $tower['ozone'];

            $current_heavy_water     = $tower['heavy_water'];

            $current_strontium       = $tower['strontium'];

            $current_charters        = $tower['charters'];

            $pos_size                = $tower['pos_size'];

            $pos_race                = $tower['pos_race'];

            $towerName               = $tower['towerName'];

            $systemID                = $tower['systemID'];

            $location                = $tower['moonName'];

            $tower_cpu               = $tower['cpu'];

            $tower_pg                = $tower['powergrid'];

            $systemName               = $posmgmt->getSystemName($systemID); //New Call to Function to get System Name from database

            //New Sovereingty Function to retrieve Sovereingty Status

            $tower['sovereignty']     = $posmgmt->getSovereignty($systemID);

            //$sovereignty              = $tower['sovereignty'] = $sov['sovereignty'];

            $allianceid               = $tower['allianceid'];

            $tower['sovfriendly']     = $posmgmt->getSovereigntyStatus($systemID, $allianceid);

            //if ($_SESSION['allainceid'] == $sov['allianceID']) {

            //    $sovfriendly            = $tower['sovfriendly'] = true;

            $charters_needed          = $tower['charters_needed'];

            //$system = $row['system'];

            $pos_id                   = $tower['pos_id'];

            // grabs the new allianceid off the table



            $owner_info=$posmgmt->GetUserInfofromID($tower['owner_id']);

            $tower['owner_name']=$owner_info['name'];



            $sec_owner_info=$posmgmt->GetUserInfofromID($tower['secondary_owner_id']);

            $tower['secondary_owner_name']=$sec_owner_info['name'];



        }



        $display_hangar = false;



        $hangars = $posmgmt->GetPosHangars($pos_id);



        $i = 0;

        if($hangars) {

            foreach ($hangars as $row) { //while ($row = mysql_fetch_assoc($res)) {

                $display_hangar = true;

                $hangar[$i]['online']           = $row['online'];

                $hangar[$i]['isotope']          = $row['isotope'];

                $hangar[$i]['oxygen']           = $row['oxygen'];

                $hangar[$i]['mechanical_parts'] = $row['mechanical_parts'];

                $hangar[$i]['coolant']          = $row['coolant'];

                $hangar[$i]['robotics']         = $row['robotics'];

                $hangar[$i]['uranium']          = $row['uranium'];

                $hangar[$i]['ozone']            = $row['ozone'];

                $hangar[$i]['heavy_water']      = $row['heavy_water'];

                $hangar[$i]['strontium']        = $row['strontium'];

                $hangar[$i]['charters']         = $row['charters'];

                $i++;

            }

        }



        //Feul table selection

        $db = $posmgmt->selectstaticdb($systemID, $allianceid);

        //End Fuel table selection



        $row = $posmgmt->GetStaticTowerInfo(array('pos_race' => $pos_race, 'pos_size' => $pos_size, 'db' => $db));



        if ($row) {

            $tower['required_isotope']           = $row['isotopes'];

            $tower['required_oxygen']            = $row['oxygen'];

            $tower['required_mechanical_parts']  = $row['mechanical_parts'];

            $tower['required_coolant']           = $row['coolant'];

            $tower['required_robotics']          = $row['robotics'];

            $tower['required_uranium']           = $row['uranium'];

            $tower['required_ozone']             = $row['ozone'];

            $tower['required_heavy_water']       = $row['heavy_water'];

            $tower['required_strontium']         = $row['strontium'];

            $tower['required_charters']          = $charters_needed?1:0;

            $tower['race_isotope']               = $result['race_isotope'];

            $tower['total_pg']                   = $row['pg'];

            $tower['total_cpu']                  = $row['cpu'];

            $required_isotope                    = $row['isotopes'];

            $required_oxygen                     = $row['oxygen'];

            $required_mechanical_parts           = $row['mechanical_parts'];

            $required_coolant                    = $row['coolant'];

            $required_robotics                   = $row['robotics'];

            $required_uranium                    = $row['uranium'];

            $required_ozone                      = $row['ozone'];

            $required_heavy_water                = $row['heavy_water'];

            $required_strontium                  = $row['strontium'];

            $required_charters                   = $charters_needed?1:0;

            $race_isotope                        = $result['race_isotope'];

            $total_pg                            = $row['pg'];

            $total_cpu                           = $row['cpu'];

            $tower['uptimecalc']                 = $posmgmt->uptimecalc($pos_id);

            $tower['pos_capacity']=$tower['fuel_hangar']=$row['fuel_hangar'];

            $tower['strontium_capacity']=$row['strontium_hangar'];



        }



        //$mods = $posmgmt->GetPosStructures($pos_id);

        $mods = $posmgmt->GetAllPosMods($pos_id);

//echo '<pre>';print_r($tower);echo '</pre>';exit;

        if ($mods) { //if (mysql_num_rows($result) != 0) {

            $current_pg  = 0;

            $current_cpu = 0;

            foreach($mods as $row) { //while ($row = mysql_fetch_array($result)) {

                if ($row['online']) {

                    $current_pg  = $current_pg  + $row['pg'];

                    $current_cpu = $current_cpu + $row['cpu'];

                }

            }

        } else {

            $current_pg = 0;

            $current_cpu = 0;

        }

        if($current_cpu<=0 && $tower['cpu']>0) {

            $current_cpu=$tower_cpu;

        }

        if($current_pg<=0 && $tower_pg>0) {

            $current_pg=$tower_pg;

        }



        $tower['current_pg']  = $current_pg;

        $tower['current_cpu'] = $current_cpu;

        $row2 = $posmgmt->GetLastPosUpdate($pos_id);

        $last_update = gmdate("Y-m-d H:i:s", $row2['datetime']);



        $hoursago = $posmgmt->hoursago($pos_id, 1);



        $optimal=$posmgmt->posoptimaluptime($tower);

        $optimalDiff=$posmgmt->getOptimalDifference($optimal, $tower);



        // $avail_uranium          = ($current_uranium          - ($required_uranium * $hoursago)); - Old Version. Now using the API to handle what's in the DB.

		

		$avail_uranium          = $current_uranium;

        $avail_oxygen           = $current_oxygen;

        $avail_mechanical_parts = $current_mechanical_parts;

        $avail_coolant          = $current_coolant;

        $avail_robotics         = $current_robotics;

        $avail_isotope          = $current_isotope;

        $avail_ozone            = $current_ozone;

        $required_ozone2        = ceil(($current_pg / $total_pg) * $required_ozone);

        $avail_heavy_water      = $current_heavy_water;

        $required_heavy_water2  = ceil(($current_cpu / $total_cpu) * $required_heavy_water);

        $avail_strontium        = $current_strontium;

        $avail_charters         = $current_charters;

		

        if ($avail_uranium <= 0) {

            $avail_uranium = ($current_uranium - ($required_uranium * (floor($current_uranium / $required_uranium))));

        }

        if ($avail_oxygen <= 0) {

            $avail_oxygen = ($current_oxygen - ($required_oxygen * (floor($current_oxygen / $required_oxygen))));

        }

        if ($avail_mechanical_parts <= 0) {

            $avail_mechanical_parts = ($current_mechanical_parts - ($required_mechanical_parts * (floor($current_mechanical_parts / $required_mechanical_parts))));

        }

        if ($avail_coolant <= 0) {

            $avail_coolant = ($current_coolant - ($required_coolant * (floor($current_coolant / $required_coolant))));

        }

        if ($avail_robotics <= 0) {

            $avail_robotics = ($current_robotics - ($required_robotics * (floor($current_robotics / $required_robotics))));

        }

        if ($avail_isotope <= 0) {

            $avail_isotope = ($current_isotope - ($required_isotope * (floor($current_isotope / $required_isotope))));

        }

        if ($avail_ozone <= 0 && $current_pg) {

            $avail_ozone = ($current_ozone - ((ceil(($current_pg / $total_pg) * $required_ozone)) * (floor($current_ozone / (ceil(($current_pg / $total_pg) * $required_ozone))))));

        }

        if ($avail_heavy_water <= 0 && $current_cpu) {

            $avail_heavy_water = ($current_heavy_water - ((ceil(($current_cpu / $total_cpu) * $required_heavy_water)) * (floor($current_heavy_water / (ceil(($current_cpu / $total_cpu) * $required_heavy_water))))));

        }

        if ($avail_charters <= 0 && $required_charters) {

            $avail_charters = ($current_charters - ($required_charters * (floor($current_charters / $required_charters))));

        }



        $tower['avail_uranium']           = $avail_uranium;

        $tower['avail_oxygen']            = $avail_oxygen;

        $tower['avail_mechanical_parts']  = $avail_mechanical_parts;

        $tower['avail_coolant']           = $avail_coolant;

        $tower['avail_robotics']          = $avail_robotics;

        $tower['avail_isotope']           = $avail_isotope;

        $tower['avail_ozone']             = $avail_ozone;

        $tower['required_ozone2']         = $required_ozone2;

        $tower['avail_heavy_water']       = $avail_heavy_water;

        $tower['required_heavy_water2']   = $required_heavy_water2;

        $tower['avail_strontium']         = $avail_strontium;

        $tower['avail_charters']          = $avail_charters;







        //Begin Silo Tracking Code

        //$sql0 = "SELECT * FROM ".TBL_PREFIX."silo_info WHERE pos_id=".my_escape($pos_id);

        //$res0 = mysql_query($sql0);



		silos($pos_id, $tower);

		$silo = $allsilos[$pos_id]['silos'];



        //End Silo Tracking Code



        $tower['silos'] = $silo;

        $tower['mods']  = $mods;

        $last_update = gmdate("Y-m-d H:i:s", $row2['datetime']);





        $eveRender->Assign('tower',       $tower);

        $eveRender->Assign('last_update', $last_update);

        $eveRender->Assign('hoursago',    $hoursago);



        $arrposize = array(1  => 'Small', 2 => 'Medium', 3 => 'Large');

        $arrporace = array(1  => 'Amarr CT',

                           2  => 'Caldari CT',

                           3  => 'Gallente CT',

                           4  => 'Minmatar CT',

                           5  => 'Angel CT',

                           6  => 'Blood CT',

                           7  => 'Dark Blood CT',

                           8  => 'Domination CT',

                           9  => 'Dread Guristas CT',

                           10 => 'Guristas CT',

                           11 => 'Sansha CT',

                           12 => 'Serpentis CT',

                           13 => 'Shadow CT',

                           14 => 'True Sansha CT');



        $tower['lines']     = $lines;

        $tower['linecount'] = $linecount;



        $eveRender->Assign('linecount',   $linecount);

        $eveRender->Assign('lines',       $lines);

        $eveRender->Assign('arrposize',   $arrposize);

        $eveRender->Assign('arrporace',   $arrporace);

        $eveRender->Assign('towerstatus', array(0 => 'Unanchored', 1 => 'Anchored', 2 => 'Onlining', 3 => 'Reinforced', 4 => 'Online'));

        $eveRender->Assign('display_hangar',   $display_hangar);

        $eveRender->Assign('hangars',   $hangar);

        $eveRender->Assign('optimal',   $optimal);

        $eveRender->Assign('optimalDiff',   $optimalDiff);

        $eveRender->Display('viewpos.tpl');



    } else {

        $eve->SessionSetVar('errormsg', 'You forgot something');

        $eve->RedirectUrl('index.php');

    }

} else {

    $eve->SessionSetVar('errormsg', 'You do not have access, ask your CEO for access.');

    $eve->RedirectUrl('index.php');

}



?>