Changeset 94

Timestamp:

11/25/06 17:01:24 (14 years ago)

Author:

exi

Message:

Update to item_values mod to reflect the db changes.

Location:

dev

Files:

• common/class.kill.php (modified) (1 diff)
• mods/item_values/kill_detail.php (modified) (8 diffs)

dev/common/class.kill.php

@@ -780 +780 @@
                 $id = $this->item_->getID(); // get Item ID
                 $qry = new DBQuery();
-        $qry->execute("select value from kb3_items where itm_id= '".$id."'");
+        $qry->execute("select itm_value from kb3_items where itm_id= '".$id."'");
         $row = $qry->getRow();
-        $value = $row['value'];
-                if ($value == "")
+        $value = $row['itm_value'];
+                if ($value == '')
         {
                         $value = 0;

dev/mods/item_values/kill_detail.php

@@ -1 @@
-<?php 
+<?php
 //Version 1.3 of the item_values mod
 // ChangeLog
@@ -5 +5 @@
 //Made change to class.ship.php to be pushed to core, rounding ship values is fucking retarded
 //Using this change added ship value loss and total loss to the ItemValue. Probably need to change this to smarty now but beyond that it is done done done!
-//Ship value is calculated using the base value in the kb3_ships, this is where the values need to be changed, the settings file will update the database to current 
+//Ship value is calculated using the base value in the kb3_ships, this is where the values need to be changed, the settings file will update the database to current
 //values from eve-central, beware this will take a while and dont do it lots or they will ban your ass.
 
@@ -20 +20 @@
 
 if($page->isAdmin()) {
-        if (isset($_POST['submit'])) { 
+        if (isset($_POST['submit'])) {
                 // Send new value for item to the database
                 $IID = $_POST['IID'];
                 $Val = $_POST[$IID];
-                
+
                 $qry = new DBQuery();
-                $qry->execute("UPDATE kb3_items SET Value ='" . $Val . "' WHERE itm_id='" . $IID . "'") or die($qry->getErrorMsg());
-        
-        }       
+                $qry->execute("UPDATE kb3_items SET itm_value ='" . $Val . "' WHERE itm_id='" . $IID . "'") or die($qry->getErrorMsg());
+
+        }
 }
 
@@ -147 +147 @@
     $html .= "<table class=kb-table width=360 border=\"0\" cellspacing=\"1\">";
     $imgid = 0;
-    
+
         if($page->isAdmin()) {
-                
+
         }
         foreach($kill->destroyeditems_ as $destroyed)
@@ -201 +201 @@
                         $value = $destroyed->getValue() * $destroyed->getQuantity();
                         $TotalValue = $TotalValue + $value;
-                        
+
                         // Value Manipulation for prettyness.
-        
+
                         if (strlen($value) >1) {        // 1000's ?
-                                $Formatted = number_format($value,2);   
+                                $Formatted = number_format($value,2);
                                 $Formatted = $Formatted . " isk";
-                        }                       
-                        
+                        }
+
                         if (strlen($value) >3) {        // 1000's ?
                                 $Formatted = round($value / 1000,2);
-                                
-                                $Formatted = number_format($Formatted,2);       
+
+                                $Formatted = number_format($Formatted,2);
                                 $Formatted = $Formatted . " K";
                         }
-                        
+
                         if (strlen($value) >6) {        // Is this value in the millions?
                                 $Formatted = round($value / 1000000,2);
-                                $Formatted = number_format($Formatted,2);       
+                                $Formatted = number_format($Formatted,2);
                                 $Formatted = $Formatted . " M";
                         }
-                
+
                 }
                 if($page->isAdmin()) {
@@ -227 +227 @@
                         $html .= "<td class=kb-table-cell colspan=1><b>$value</b>";
                         $html .= "<input checked='checked' name='IID' value="  . $item->getID() .  " type='hidden'></td>"; // Hidden Item Id Indicator
-                        
+
                         $html .= "<tr class=kb-table-row-even>";
                         $html .= "<td class=kb-table-cell></td>";
@@ -244 +244 @@
     //$html .= "<td width=\"32\"></td>";
     $html .= "<td class=kb-table-cell colspan=2 align=right><b>" . "Total Module Loss:" . "</b></td>";
-        
+
     if ($TotalValue > 0) {
 
                 $Formatted = number_format($TotalValue,2);
-                
+
         }
                 //Get Ship Value
-        $qry = new DBQuery();           
+        $qry = new DBQuery();
         $qry->execute("SELECT shp_baseprice FROM kb3_ships WHERE shp_id =" . $ship->getID());
         $row = $qry->getRow();
         $ShipValue = $row['shp_baseprice'];
-        
-        
+
+
         $TotalLoss = number_format($TotalValue + $ShipValue,2);
-                
+
         $html .= "<td class=kb-table-cell colspan=2 align=right><b>" . $Formatted . "</b>";
         $html .="</td>";
@@ -270 +270 @@
         $html .= "<td class=kb-table-cell colspan=2 align=right><b>" . $TotalLoss . "</b></td>";
         $html .= "</tr>";
-        
+
         $html .= "</table>";
 }