Changeset 96

Timestamp:

11/28/06 10:00:12 (16 years ago)

Author:

exi

Message:

Added a link to item_values/settings.php.
Fixed the iconicon bug.
Added $ship->getPrice() which takes custom ship values into account.

Location:

dev

Files:

• common/class.item.php (modified) (1 diff)
• common/class.ship.php (modified) (2 diffs)
• mods/item_values/kill_detail.php (modified) (1 diff)
• mods/item_values/settings.php (modified) (2 diffs)

dev/common/class.item.php

@@ -33 +33 @@
         {
             // fix for new db structure, just make sure old clients dont break
-            if (!strpos($this->row_['itm_icon'], 'icon'))
+            if (!strstr($this->row_['itm_icon'], 'icon'))
             {
                 $this->row_['itm_icon'] = 'icon'.$this->row_['itm_icon'];

dev/common/class.ship.php

@@ -60 +60 @@
     }
 
+    function getPrice()
+    {
+        return $this->value_;
+    }
+
     function execQuery()
     {
         if (!$this->qry_)
         {
+            global $config;
             $this->qry_ = new DBQuery();
 
             $this->sql_ = "select *
-                           from kb3_ships shp, kb3_ship_classes scl
-                                   where shp_id = ".$this->id_."
-                               and shp.shp_class = scl.scl_id";
+                           from kb3_ships shp
+                           inner join kb3_ship_classes scl on shp.shp_class = scl.scl_id";
+            if ($config->getConfig('ship_values'))
+            {
+                $this->sql_ .= ' left join kb3_ships_values ksv on (shp.shp_id = ksv.shp_id) ';
+            }
+            $this->sql_ .= "where shp.shp_id = ".$this->id_;
 
             $this->qry_->execute($this->sql_);
@@ -77 +87 @@
             $this->shiptechlevel_ = $row['shp_techlevel'];
             $this->externalid_ = $row['shp_externalid'];
+            if ($config->getConfig('ship_values'))
+            {
+                if (!$this->value_ = $row['shp_value'])
+                {
+                    $this->value_ = $row['shp_baseprice'];
+                }
+            }
+            else
+            {
+                $this->value_ = $row['shp_baseprice'];
+            }
         }
     }

dev/mods/item_values/kill_detail.php

@@ -250 +250 @@
 
         }
-                //Get Ship Value
-        $qry = new DBQuery();
-        $qry->execute("SELECT shp_baseprice FROM kb3_ships WHERE shp_id =" . $ship->getID());
-        $row = $qry->getRow();
-        $ShipValue = $row['shp_baseprice'];
-
+        //Get Ship Value
+        $ShipValue = $ship->getPrice();
 
         $TotalLoss = number_format($TotalValue + $ShipValue,2);

dev/mods/item_values/settings.php

@@ -1 @@
-<?php 
+<?php
 // This script goies out and sync's the ship values to the database.
 //Ebil Hax by coni cus hes and ass ;)
@@ -12 +12 @@
 $page = new Page("Settings - ship price import");
 
-//http://eve-central.com/home/marketstat_xml.html?typeid=
-print("Querying Database for Ship Item Numbers<br>");
-$qry = new DBQuery();
-$qry->execute("SELECT shp_externalid FROM kb3_ships WHERE shp_externalid > '0'");
-$uqry = new DBQuery();
+if ($_REQUEST['do'] == 'scan')
+{
+    //http://eve-central.com/home/marketstat_xml.html?typeid=
+    $html = "Querying Database for Ship Item Numbers<br>";
+    $qry = new DBQuery();
+    $qry->execute("SELECT shp_externalid FROM kb3_ships WHERE shp_externalid > '0'");
+    $uqry = new DBQuery();
 
-while ($row = $qry->getRow()){
-        //$row = $qry->getRow();
-        //Get data for every single ship in the database
-        //Get the information from eve central;
-        print("Getting Value of ship: " . $row['shp_externalid'] . "<br>");
-        $pricedata = file_get_contents ("http://eve-central.com/home/marketstat_xml.html?typeid=" . $row['shp_externalid']);
-        $pdata = XML_unserialize($pricedata);
-        print("Got Price for " . $row['shp_externalid'] . " : " .$pdata['market_stat']['avg_sell_price'] . "<br>");
-        //Update the database
-        $updateSQL = "UPDATE kb3_ships SET shp_baseprice ='" . $pdata['market_stat']['avg_sell_price'] . "' WHERE shp_externalid = '" . $row['shp_externalid'] ."'";
-        $uqry->execute($updateSQL);
-        
+    while ($row = $qry->getRow())
+    {
+        //$row = $qry->getRow();
+        //Get data for every single ship in the database
+        //Get the information from eve central;
+        $html .= "Getting Value of ship: " . $row['shp_externalid'] . "<br>";
+        $pricedata = file_get_contents ("http://eve-central.com/home/marketstat_xml.html?typeid=" . $row['shp_externalid']);
+        $pdata = XML_unserialize($pricedata);
+        $html .= "Got Price for " . $row['shp_externalid'] . " : " .$pdata['market_stat']['avg_sell_price'] . "<br>";
+        //Update the database
+        $updateSQL = "UPDATE kb3_ships SET shp_baseprice ='" . $pdata['market_stat']['avg_sell_price'] . "' WHERE shp_externalid = '" . $row['shp_externalid'] ."'";
+        $uqry->execute($updateSQL);
+        usleep(200);
+    }
+    $html = "Finished";
+
+if (false)
+{
+    // this is a BAD idea for users
+    $html .= "Querying Database for Item Numbers<br>";
+    $qry = new DBQuery();
+    $qry->execute("SELECT itm_id,itm_name,itm_externalid FROM kb3_items WHERE itm_value = 0");
+    $uqry = new DBQuery();
+
+    while ($row = $qry->getRow())
+    {
+        //$row = $qry->getRow();
+        //Get data for every single ship in the database
+        //Get the information from eve central;
+//      $html .= "Getting Value of item: " . $row['itm_name'] . "<br>";
+        $pricedata = file_get_contents("http://eve-central.com/home/marketstat_xml.html?typeid=" . $row['itm_externalid']);
+        $pdata = XML_unserialize($pricedata);
+        $html .= "Got Price for " . $row['itm_name'] . " : " .$pdata['market_stat']['avg_sell_price'] . "<br/>";
+        //Update the database
+        if ($pdata['market_stat']['avg_sell_price'] == 0)
+        {
+            $pdata['market_stat']['avg_sell_price'] = 1;
+        }
+        $updateSQL = "UPDATE kb3_items SET itm_value ='" . $pdata['market_stat']['avg_sell_price'] . "' WHERE itm_id = '" . $row['itm_id'] ."'";
+        $uqry->execute($updateSQL);
+        usleep(200);
+    }
+    $html .= "Finished";
 }
-//print_r($pdata);
-$html = "Finished";
+}
+else
+{
+    $html .= '<a href="?a=settings_item_values&do=scan">Scan</a><br/>';
+}
 $page->setContent($html);
 $page->addContext($menubox->generate());
 $page->generate();
-
-
-
-
 ?>