Show
Ignore:
Timestamp:
04/05/07 02:52:14 (16 years ago)
Author:
exi
Message:

Attempt to fix various issues with the ContractListTable?-sql summary code.
The raw killmail now shows the time left for classified kills.
Added code to autoupgrade.php to add indexes to kb3_inv_crp and kb3_inv_all.

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • dev/common/includes/autoupgrade.php

    r190 r201  
    109109function check_index() 
    110110{ 
     111    check_index_invcrp(); 
     112    check_index_invall(); 
    111113    $qry = new DBQuery(); 
    112114    $qry->execute('SHOW columns from kb3_item_types like \'itt_id\''); 
     
    117119    } 
    118120    $qry->execute('ALTER TABLE `kb3_item_types` ADD PRIMARY KEY ( `itt_id` ) '); 
     121} 
     122function check_index_invcrp() 
     123{ 
     124    $qry = new DBQuery(); 
     125    $qry->execute('SHOW columns from kb3_inv_crp like \'inc_kll_id\''); 
     126    $arr = $qry->getRow(); 
     127    if ($arr['Key'] == 'MUL') 
     128    { 
     129        return; 
     130    } 
     131    $qry->execute('ALTER TABLE `kb3_inv_crp` ADD INDEX ( `inc_kll_id` ) '); 
     132} 
     133function check_index_invall() 
     134{ 
     135    $qry = new DBQuery(); 
     136    $qry->execute('SHOW columns from kb3_inv_all like \'ina_kll_id\''); 
     137    $arr = $qry->getRow(); 
     138    if ($arr['Key'] == 'MUL') 
     139    { 
     140        return; 
     141    } 
     142    $qry->execute('ALTER TABLE `kb3_inv_all` ADD INDEX ( `ina_kll_id` ) '); 
    119143} 
    120144function check_tblstrct1()