| 21 | $qry->execute($query); |
| 22 | } |
| 23 | |
| 24 | function 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');"; |
46 | 65 | 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."'); |
47 | 66 | 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."'); |
49 | 68 | 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."'); |
50 | 69 | 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."'); |