Changeset 156

Show
Ignore:
Timestamp:
12/15/06 18:38:56 (14 years ago)
Author:
exi
Message:

HotFix? for autoupgrade.php to use correct table.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • dev/common/autoupgrade.php

    r154 r156  
    198198{ 
    199199    $qry = new DBQuery(); 
    200     $query = 'select count(*) from kb3_item_values where itt_id = 771'; 
    201     $result = mysql_query($query); 
     200    $query = 'select count(*) from kb3_item_types where itt_id = 771'; 
     201    $result = mysql_query($query); 
     202    $result = mysql_fetch_array($result); 
    202203    if ($result['cnt'] == 1) 
    203204    { 
    204205        return; 
    205206    } 
    206     $qry->execute("INSERT INTO kb3_item_types VALUES (737,'Gas Cloud Harvester',1)"); 
    207     $qry->execute("INSERT INTO kb3_item_types VALUES (762,'Inertia Stabilizer',3)"); 
    208     $qry->execute("INSERT INTO kb3_item_types VALUES (763,'Nanofiber Internal Structure',3)"); 
    209     $qry->execute("INSERT INTO kb3_item_types VALUES (764,'Overdrive Injector System',3)"); 
    210     $qry->execute("INSERT INTO kb3_item_types VALUES (765,'Expanded Cargohold',3)"); 
    211     $qry->execute("INSERT INTO kb3_item_types VALUES (766,'Power Diagnostic System',3)"); 
    212     $qry->execute("INSERT INTO kb3_item_types VALUES (767,'Capacitor Power Relay',3)"); 
    213     $qry->execute("INSERT INTO kb3_item_types VALUES (768,'Capacitor Flux Coil',3)"); 
    214     $qry->execute("INSERT INTO kb3_item_types VALUES (769,'Reactor Control Unit',3)"); 
    215     $qry->execute("INSERT INTO kb3_item_types VALUES (770,'Shield Flux Coil',3)"); 
    216     $qry->execute("INSERT INTO kb3_item_types VALUES (771,'Missile Launcher Heavy Assault',1)"); 
     207    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (737,'Gas Cloud Harvester',1)"); 
     208    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (762,'Inertia Stabilizer',3)"); 
     209    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (763,'Nanofiber Internal Structure',3)"); 
     210    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (764,'Overdrive Injector System',3)"); 
     211    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (765,'Expanded Cargohold',3)"); 
     212    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (766,'Power Diagnostic System',3)"); 
     213    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (767,'Capacitor Power Relay',3)"); 
     214    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (768,'Capacitor Flux Coil',3)"); 
     215    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (769,'Reactor Control Unit',3)"); 
     216    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (770,'Shield Flux Coil',3)"); 
     217    $qry->execute("INSERT IGNORE INTO kb3_item_types VALUES (771,'Missile Launcher Heavy Assault',1)"); 
    217218} 
    218219?>