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

<?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,"005");

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

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 update005(){
        // Blueprints and small fixes
        if (CURRENT_DB_UPDATE < "005" )
        {
                $qry = new DBQuery();
$query = <<<EOF
INSERT INTO `kb3_invtypes` (`typeID`, `groupID`, `typeName`, `description`, `icon`, `radius`, `mass`, `volume`, `capacity`, `portionSize`, `raceID`, `basePrice`, `marketGroupID`) VALUES (29249, 105, 'Magnate Blueprint', '', '0', 0, 0, 0.01, 0, 1, 0, 0, 0);

INSERT INTO `kb3_invtypes` (`typeID`, `groupID`, `typeName`, `description`, `icon`, `radius`, `mass`, `volume`, `capacity`, `portionSize`, `raceID`, `basePrice`, `marketGroupID`) VALUES (29267, 111, 'Apotheosis Blueprint', '', '0', 0, 0, 0.01, 0, 1, 0, 0, 0);

INSERT INTO `kb3_invtypes` (`typeID`, `groupID`, `typeName`, `description`, `icon`, `radius`, `mass`, `volume`, `capacity`, `portionSize`, `raceID`, `basePrice`, `marketGroupID`) VALUES (29338, 106, 'Omen Navy Issue Blueprint', '', '0', 0, 0, 0.01, 0, 1, 0, 0, 0);

INSERT INTO `kb3_invtypes` (`typeID`, `groupID`, `typeName`, `description`, `icon`, `radius`, `mass`, `volume`, `capacity`, `portionSize`, `raceID`, `basePrice`, `marketGroupID`) VALUES (29339, 106, 'Scythe Fleet Issue Blueprint', '', '0', 0, 0, 0.01, 0, 1, 0, 0, 0);

INSERT INTO `kb3_invtypes` (`typeID`, `groupID`, `typeName`, `description`, `icon`, `radius`, `mass`, `volume`, `capacity`, `portionSize`, `raceID`, `basePrice`, `marketGroupID`) VALUES (29341, 106, 'Osprey Navy Issue Blueprint', '', '0', 0, 0, 0.01, 0, 1, 0, 0, 0);

INSERT INTO `kb3_invtypes` (`typeID`, `groupID`, `typeName`, `description`, `icon`, `radius`, `mass`, `volume`, `capacity`, `portionSize`, `raceID`, `basePrice`, `marketGroupID`) VALUES (29345, 106, 'Exequror Navy Issue Blueprint', '', '0', 0, 0, 0.01, 0, 1, 0, 0, 0);

INSERT INTO `kb3_dgmtypeattributes` (`typeID`, `attributeID`, `value`) VALUES ('29249', '422', '1');

UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='180';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='181';

UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='182';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='183';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='184';

UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='228';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='229';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='230';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='231';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='232';

UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='277';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='278';
UPDATE `kb3_dgmattributetypes` SET `icon` = '50_11' WHERE `attributeID`='279';

UPDATE `kb3_dgmattributetypes` SET `icon` = '04_12' WHERE `attributeID`='193';
UPDATE `kb3_dgmattributetypes` SET `icon` = '04_12' WHERE `attributeID`='235';

UPDATE `kb3_dgmattributetypes` SET `icon` = '22_14' WHERE `attributeID`='108';
UPDATE `kb3_dgmattributetypes` SET `icon` = '22_14' WHERE `attributeID`='197';

UPDATE `kb3_dgmattributetypes` SET `icon` = '07_15' WHERE `attributeID`='137';

UPDATE `kb3_dgmattributetypes` SET `icon` = '24_01' WHERE `attributeID`='77';

UPDATE `kb3_dgmattributetypes` SET `icon` = '22_08' WHERE `attributeID`='153';

UPDATE `kb3_dgmattributetypes` SET `icon` = '07_15' WHERE `attributeID`='484';
EOF;

        $qry->execute($query);
        config::set("DBUpdate","005");

        }
}

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);
}

?>