root/dev/common/includes/autoupgrade.php @ 323

<?php
// for easier patching

// Note: DO UPDATES ALWAYS OVER THE ITEM NAMES, SO NO KB's
//       DATABASES GET SCREWED UP.
//
//
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,"004");

function updateDB(){
        // if update nesseary run updates
        if (CURRENT_DB_UPDATE < LASTEST_DB_UPDATE ){
                update001();
                update002();
                update003();
                update004();
        }
}

function update001(){
        //Checking if this Update already done
        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");
                update_slot_of_group($ShieldBoosterGroup,0,2);
                
                // Changing Tracking Scripts Slot from None to Mid Slot
                $ScriptGroupID1 = item::get_group_id("Optimal Range");
                update_slot_of_group($ScriptGroupID1,0,2);

                // Changing Warp Disruption Scripts Slot from None to Mid Slot
                $ScriptGroupID2 = item::get_group_id("Focused Warp Disruption");
                update_slot_of_group($ScriptGroupID2,0,2);
                
                // Changing Tracking Disruption Scripts Slot from None to Mid Slot
                $ScriptGroupID3 = item::get_group_id("Optimal Range Disruption");
                update_slot_of_group($ScriptGroupID3,0,2);
                
                // Changing Sensor Booster Scripts Slot from None to Mid Slot
                $ScriptGroupID4 = item::get_group_id("Targeting Range");
                update_slot_of_group($ScriptGroupID4,0,2);
                
                // Changing Sensor Dampener Scripts Slot from None to Mid Slot
                $ScriptGroupID5 = item::get_group_id("Scan Resolution Dampening");
                update_slot_of_group($ScriptGroupID5,0,2);
                
                // Changing Energy Weapon Slot from None to High Slot
                $EnergyWeaponGroup = item::get_group_id("Gatling Pulse Laser I");
                update_slot_of_group($EnergyWeaponGroup,0,1);
                
                // Changing Group of Salvager I to same as Small Tractor Beam I         
                $item = new Item();
                $item->lookup("Salvager I");
                $SalvagerTypeId =  $item->getId();
                $SalvagerGroup  =  item::get_group_id("Salvager I");
                $TractorBeam    =  item::get_group_id("Small Tractor Beam I");  
                move_item_to_group($SalvagerTypeId,$SalvagerGroup ,$TractorBeam);
        
                //writing Update Status into ConfigDB
                config::set("DBUpdate","001");  
        }
}

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);
                config::set("DBUpdate","002");  
        }
}

function update003(){
        // Warefare Links and Command Prozessor were midslot items in install file, should be high slot
        if (CURRENT_DB_UPDATE < "003" )
        {
                require_once("common/includes/class.item.php");
                $WarfareLinkGroup  =  item::get_group_id("Skirmish Warfare Link - Rapid Deployment");
                update_slot_of_group($WarfareLinkGroup,2,1);
                config::set("DBUpdate","003");  
        }
}

function update004(){
        // new trinity ships are wrong saved as T1 shipes
        if (CURRENT_DB_UPDATE < "004" )
        {
                $qry = new DBQuery();
                
                $query = "UPDATE kb3_ships 
                                        INNER JOIN kb3_ship_classes ON scl_id = shp_class
                                        SET shp_techlevel = 2 
                                        WHERE scl_class IN ('Electronic Attack Ship','Heavy Interdictor','Black Ops','Marauder','Heavy Interdictor','Jump Freighter')
                                        AND shp_techlevel = 1;";
                $qry->execute($query);          
                config::set("DBUpdate","004");  
        }
}

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 and itt_slot = $oldSlot;";
        $qry->execute($query);
        $query = "UPDATE kb3_items_destroyed
                                INNER JOIN kb3_invtypes ON groupID = $id AND itd_itm_id = typeID
                                SET itd_itl_id = $newSlot
                                WHERE itd_itl_id = $oldSlot;";
        $qry->execute($query);
        
        $query = "UPDATE kb3_items_dropped
                                INNER JOIN kb3_invtypes ON groupID = $id AND itd_itm_id = typeID
                                SET itd_itl_id = $newSlot
                                WHERE itd_itl_id = $oldSlot;";
        $qry->execute($query);
}

function move_item_to_group($id,$oldGroup ,$newGroup){
        $qry  = new DBQuery();
        $query = "UPDATE kb3_invtypes
                                SET groupID = $newGroup 
                                WHERE typeID = $id AND groupID = $oldGroup;";
        $qry->execute($query);
}

?>