Changeset 308

Timestamp:

12/31/07 15:37:10 (13 years ago)

Author:

ralle030583

Message:

DB Update002
- fixing already posted Salvager I

Location:

dev/common/includes

Files:

• autoupgrade.php (modified) (5 diffs)
• globals.php (modified) (1 diff)

dev/common/includes/autoupgrade.php

@@ -6 +6 @@
 //
 //
+if (!config::get("DBUpdate"))
+        config::set("DBUpdate","000");
+        
 // Current update version of Database
 define(CURRENT_DB_UPDATE,config::get("DBUpdate"));
 //Update version of this autoupgrade.php
-define(LASTEST_DB_UPDATE,"001");
+define(LASTEST_DB_UPDATE,"002");
 
 function updateDB(){
@@ -15 +18 @@
         if (CURRENT_DB_UPDATE < LASTEST_DB_UPDATE ){
                 update001();
+                update002();
         }
 }
@@ -20 +24 @@
 function update001(){
         //Checking if this Update already done
-        if (CURRENT_DB_UPDATE < "001" ){
+        if (CURRENT_DB_UPDATE < "001" )
+        {
                 require_once("common/includes/class.item.php");
-                
                 // Changing ShieldBooster Slot from None to Mid Slot
                 $ShieldBoosterGroup = item::get_group_id("Small Shield Booster I");
@@ -58 +62 @@
                 $TractorBeam    =  item::get_group_id("Small Tractor Beam I");  
                 move_item_to_group($SalvagerTypeId,$SalvagerGroup ,$TractorBeam);
+
+                
+                update_slot_of_group($TractorBeam,
+                
                 
                 //writing Update Status into ConfigDB
@@ -64 +72 @@
 }
 
+function update002(){
+        // to correct the already existing Salvager in med slots. 
+        // missed it in update001
+        if (CURRENT_DB_UPDATE < "002" )
+        {
+                require_once("common/includes/class.item.php");
+                $SalvagerGroup  =  item::get_group_id("Salvager I");
+                update_slot_of_group($SalvagerGroup,2,1);
+        }
+}
+
 function update_slot_of_group($id,$oldSlot = 0 ,$newSlot){
         $qry  = new DBQuery();
         $query = "UPDATE kb3_item_types
-                                                SET itt_slot = $newSlot WHERE itt_id = $id;";
+                                SET itt_slot = $newSlot WHERE itt_id = $id amd itt_slot = $oldSlot;";
         $qry->execute($query);
         $query = "UPDATE kb3_items_destroyed

dev/common/includes/globals.php

@@ -1 +1 @@
 <?php
 // current subversion revision
-preg_match('/\$Re'.'vision: (.*?) \$/', '$Revision: 307 $', $match);
+preg_match('/\$Re'.'vision: (.*?) \$/', '$Revision: 308 $', $match);
 define('SVN_REV', $match[1]);