Show
Ignore:
Timestamp:
09/06/07 10:07:07 (15 years ago)
Author:
ralle030583
Message:

- changed summarytable format to 5 rows each cause of cap. industrial
- bugfix in autoupgrade of navigation table (Kills were linked to Home :-/)
- added chk_cap_industrial to autoupgrade
- added Capital Industrial to sql install files

Files:
1 modified

Legend:

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

    r221 r233  
    1919        PRIMARY KEY ( `ID` ) 
    2020        ) TYPE = MYISAM'; 
     21    $qry->execute($query); 
     22} 
     23 
     24function check_cap_industrial() 
     25{ 
     26    $qry = new DBQuery(); 
     27    $query = 'select count(*) as cnt from kb3_ship_classes where scl_class="Cap. Industrial";'; 
     28    $result = $qry->execute($query); 
     29        if ($result['cnt'] == 1) 
     30    { 
     31        return; 
     32    } 
     33    $query =    "INSERT IGNORE INTO kb3_ship_classes(scl_id,scl_class,scl_value,scl_points) 
     34                                        values ('','Cap. Industrial','1850000000','5000'); 
     35                                INSERT IGNORE INTO kb3_ships(shp_id,shp_name,shp_class,shp_externalid,shp_rce_id,shp_baseprice,shp_techlevel) 
     36                                        values ('','Rorqual','','28352','0','1850000000','1'); 
     37                                UPDATE kb3_ships set kb3_ships.shp_class=(select scl_id from kb3_ship_classes where scl_class='Cap. Industrial') where kb3_ships.shp_name='Rorqual'; 
     38                                INSERT IGNORE INTO kb3_ships_values(shp_id,shp_value) 
     39                                        values ((select kb3_ships.shp_id from kb3_ships where kb3_ships.shp_name='Rorqual'),'1850000000');"; 
    2140    $qry->execute($query); 
    2241} 
     
    4665                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Campaings','?a=campaigns','_self',2,'ALL_PAGES','".KB_SITE."'); 
    4766                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Contracts','?a=contracts','_self',3,'ALL_PAGES','".KB_SITE."'); 
    48                                                         INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Kills','?a=home','_self',4,'ALL_PAGES','".KB_SITE."'); 
     67                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Kills','?a=kills','_self',4,'ALL_PAGES','".KB_SITE."'); 
    4968                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Losses','?a=losses','_self',5,'ALL_PAGES','".KB_SITE."'); 
    5069                                                        INSERT IGNORE INTO `kb3_navigation` (`nav_type`,`intern`,`descr` ,`url` ,`target`,`posnr` ,`page`,`KBSITE`) VALUES ('top',1,'Post Mail','?a=post','_self',6,'ALL_PAGES','".KB_SITE."');