für than, wenn es dir langweilig ist:
Code
#----------------------------
# Table structure for lhp_einheit
#----------------------------
drop table if exists lhp_einheit;
CREATE TABLE `lhp_einheit` (
`bereich` tinyint(3) unsigned NOT NULL default '0',
`lfdnr` tinyint(3) unsigned NOT NULL default '0',
`einheit_id` tinyint(3) unsigned NOT NULL default '0',
`einheit_name` varchar(100) NOT NULL default '',
`forschung_id` tinyint(3) unsigned NOT NULL default '0',
`wasser` tinyint(3) unsigned NOT NULL default '0',
`kosten_ew` mediumint(8) unsigned NOT NULL default '0',
`kosten_gold` mediumint(8) unsigned NOT NULL default '0',
`kosten_holz` mediumint(8) unsigned NOT NULL default '0',
`kosten_stoff` mediumint(8) unsigned NOT NULL default '0',
`kosten_stein` mediumint(8) unsigned NOT NULL default '0',
`kosten_eisen` mediumint(9) unsigned NOT NULL default '0',
`ticks` smallint(5) unsigned NOT NULL default '0',
`unterhalt` mediumint(8) unsigned NOT NULL default '0',
`a` tinyint(3) unsigned NOT NULL default '0',
`v` tinyint(3) unsigned NOT NULL default '0',
`b` tinyint(3) unsigned NOT NULL default '0',
`transport` tinyint(3) unsigned NOT NULL default '0',
`terrain` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`einheit_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#----------------------------
# Records for table lhp_einheit
#----------------------------
insert into lhp_einheit values (1, 2, 2, 'Siedler', 0, 0, 0, 0, 0, 0, 0, 0, 120, 1, 0, 2, 2, 0, 1) ;
insert into lhp_einheit values (1, 3, 3, 'Bauarbeiter', 0, 0, 50, 20, 20, 100, 0, 10, 120, 1, 0, 2, 2, 0, 1) ;
insert into lhp_einheit values (2, 1, 6, 'Miliz', 0, 0, 0, 10, 20, 5, 0, 5, 120, 1, 2, 2, 2, 0, 1) ;
insert into lhp_einheit values (2, 8, 13, 'Speerkämpfer', 3, 0, 50, 20, 50, 10, 0, 10, 120, 1, 2, 4, 2, 0, 1) ;
insert into lhp_einheit values (2, 10, 15, 'Streitwagen', 4, 0, 70, 50, 100, 30, 0, 30, 120, 2, 6, 2, 3, 0, 1) ;
insert into lhp_einheit values (2, 2, 7, 'Schwertkämpfer', 5, 0, 100, 70, 5, 50, 0, 20, 120, 2, 6, 4, 2, 0, 1) ;
insert into lhp_einheit values (2, 3, 8, 'Axtkämpfer', 5, 0, 100, 70, 20, 50, 0, 10, 120, 16, 4, 6, 2, 0, 1) ;
insert into lhp_einheit values (3, 1, 31, 'Galeere', 8, 1, 120, 800, 600, 300, 10, 30, 120, 3, 2, 2, 3, 2, 2) ;
insert into lhp_einheit values (2, 5, 10, 'Bogenschütze', 10, 0, 100, 120, 100, 10, 0, 10, 120, 10, 4, 2, 2, 0, 1) ;
insert into lhp_einheit values (2, 22, 27, 'Katapult', 12, 0, 50, 500, 200, 100, 500, 40, 120, 4, 8, 2, 2, 0, 1) ;
insert into lhp_einheit values (2, 11, 16, 'Reiter', 17, 0, 100, 180, 20, 100, 0, 20, 120, 1, 4, 2, 3, 0, 1) ;
insert into lhp_einheit values (1, 4, 4, 'Aufklärer', 22, 0, 10, 20, 10, 10, 0, 10, 120, 32, 0, 4, 3, 0, 1) ;
insert into lhp_einheit values (3, 2, 32, 'Karavelle', 22, 1, 150, 1600, 1000, 800, 50, 120, 120, 1, 2, 4, 3, 3, 2) ;
insert into lhp_einheit values (1, 5, 5, 'Spion', 23, 0, 1, 50, 1, 1, 0, 0, 120, 5, 0, 2, 3, 0, 1) ;
insert into lhp_einheit values (2, 6, 11, 'Langbogenschütze', 28, 0, 120, 220, 200, 70, 0, 20, 120, 5, 8, 2, 2, 0, 1) ;
insert into lhp_einheit values (2, 7, 12, 'Armbrustschütze', 28, 0, 120, 250, 250, 70, 0, 30, 120, 5, 8, 4, 2, 0, 1) ;
insert into lhp_einheit values (2, 9, 14, 'Pikenier', 29, 0, 100, 250, 220, 100, 0, 40, 120, 19, 2, 6, 2, 0, 1) ;
insert into lhp_einheit values (2, 23, 28, 'Trebuchet', 33, 0, 80, 950, 700, 250, 1000, 90, 120, 60, 12, 2, 2, 0, 1) ;
insert into lhp_einheit values (3, 3, 33, 'Galeone', 34, 1, 250, 3000, 1800, 1500, 100, 220, 120, 70, 2, 4, 4, 4, 2) ;
insert into lhp_einheit values (3, 5, 35, 'Fregatte', 34, 1, 200, 3500, 1600, 1600, 80, 360, 120, 9, 4, 4, 5, 0, 2) ;
insert into lhp_einheit values (2, 24, 29, 'Kanone', 35, 0, 60, 450, 300, 50, 0, 300, 120, 9, 16, 2, 2, 0, 1) ;
insert into lhp_einheit values (2, 13, 18, 'Paladin', 36, 0, 150, 450, 30, 70, 0, 40, 120, 7, 16, 8, 3, 0, 1) ;
insert into lhp_einheit values (2, 14, 19, 'Kavallerie', 36, 0, 150, 350, 80, 50, 0, 50, 120, 8, 12, 6, 3, 0, 1) ;
insert into lhp_einheit values (2, 12, 17, 'Ritter', 41, 0, 150, 370, 50, 90, 0, 80, 120, 10, 8, 6, 3, 0, 1) ;
insert into lhp_einheit values (2, 15, 20, 'Musketenmann', 42, 0, 180, 500, 100, 100, 0, 250, 120, 110, 4, 8, 2, 0, 1) ;
insert into lhp_einheit values (3, 6, 36, 'Panzerschiff', 47, 1, 300, 5500, 50, 50, 0, 1000, 120, 7, 8, 8, 5, 0, 2) ;
insert into lhp_einheit values (2, 4, 9, 'Guerilla', 50, 0, 100, 350, 50, 50, 0, 25, 120, 14, 12, 12, 2, 0, 1) ;
insert into lhp_einheit values (2, 17, 22, 'Infanterie', 50, 0, 220, 700, 100, 100, 0, 300, 120, 14, 12, 20, 2, 0, 1) ;
insert into lhp_einheit values (2, 21, 26, 'Sturmgeschütz', 50, 0, 160, 700, 200, 70, 0, 500, 120, 22, 16, 4, 2, 0, 1) ;
insert into lhp_einheit values (2, 25, 30, 'Artillerie', 50, 0, 200, 1100, 250, 90, 0, 800, 120, 200, 24, 4, 2, 0, 1) ;
insert into lhp_einheit values (3, 9, 39, 'Schlachtschiff', 56, 1, 500, 10000, 300, 300, 0, 1200, 120, 22, 36, 24, 5, 0, 2) ;
insert into lhp_einheit values (2, 19, 24, 'Jagdpanzer', 58, 0, 200, 1100, 10, 10, 0, 10, 120, 18, 32, 16, 4, 0, 1) ;
insert into lhp_einheit values (2, 16, 21, 'Schütze', 59, 0, 200, 900, 150, 150, 0, 450, 120, 40, 8, 12, 2, 0, 1) ;
insert into lhp_einheit values (3, 4, 34, 'Transporter', 64, 1, 100, 2000, 100, 100, 0, 400, 120, 160, 2, 8, 5, 8, 2) ;
insert into lhp_einheit values (3, 7, 37, 'Zerstörer', 64, 1, 150, 8000, 100, 100, 0, 600, 120, 190, 24, 16, 5, 0, 2) ;
insert into lhp_einheit values (3, 8, 38, 'Kreuzer', 64, 1, 250, 9500, 120, 120, 0, 800, 120, 20, 30, 20, 5, 0, 2) ;
insert into lhp_einheit values (4, 1, 40, 'Schwimmpanzer', 64, 0, 200, 1000, 10, 10, 0, 10, 120, 30, 6, 8, 5, 0, 3) ;
insert into lhp_einheit values (2, 18, 23, 'Mech. Infanterie', 66, 0, 250, 1500, 200, 200, 0, 600, 120, 40, 24, 36, 4, 0, 1) ;
insert into lhp_einheit values (2, 20, 25, 'Kampfpanzer', 81, 0, 400, 2000, 200, 200, 0, 1500, 120, 22, 48, 32, 3, 0, 1) ;
insert into lhp_einheit values (4, 2, 41, 'Hovercraft-Transporter', 81, 0, 200, 1100, 100, 100, 0, 200, 120, 16, 2, 10, 5, 5, 3) ;
insert into lhp_einheit values (4, 3, 42, 'Mini-Hovercraft', 81, 0, 200, 800, 100, 100, 0, 100, 120, 14, 6, 4, 5, 0, 3) ;
insert into lhp_einheit values (4, 4, 43, 'Hovercraft-Schlachter', 81, 0, 200, 700, 300, 300, 0, 600, 120, 0, 20, 4, 5, 0, 3) ;
insert into lhp_einheit values (1, 1, 1, 'Startsiedler', 255, 0, 0, 0, 0, 0, 0, 0, 120, 0, 0, 99, 16, 0, 3) ;
Alles anzeigen
judith: ew-kosten ist leider nicht machbar