Changeset a6ba521627f8efaa7b838a0963820431ae8001d4

Show
Ignore:
Timestamp:
03/24/07 12:28:29 (2 years ago)
Author:
Christopher Jung <bktheg@web.de>
git-committer:
Christopher Jung <bktheg@web.de> 1174735709 +0100
git-parent:

[ebeff435b16271673105db99dd5b9924d930855f]

git-author:
Christopher Jung <bktheg@web.de> 1174735709 +0100
Message:

Mapping von php-Gebaeudemodulen auf java-Gebaeudemodule entfernt

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • db/tables/buildings.sql

    r425acaa ra6ba521  
    1717  `ucomplex` tinyint(3) unsigned NOT NULL default '0', 
    1818  `deakable` tinyint(1) unsigned NOT NULL default '1', 
    19   `module` varchar(30) NOT NULL default 'default', 
     19  `module` varchar(60) NOT NULL default 'net.driftingsouls.ds2.server.bases.DefaultBuilding', 
    2020  PRIMARY KEY  (`id`), 
    2121  KEY `category` (`category`) 
    2222) ENGINE=InnoDB DEFAULT CHARSET=utf8;  
    2323 
    24 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (1, 'Kommandozentrale', 'data/buildings/basis.png', '0,0,100,400,0,0,50,120,80,0,0,0,0,0,0,0,0,0,', '0,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,', '500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 20, 500, 0, 20, 1, 0, 4, 0, 1, 'kommandozentrale'); 
    25 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (2, 'Reaktor (Uran)', 'data/buildings/ureaktor.png', '0,0,60,180,0,0,0,10,5,0,0,0,0,0,0,0,0,0,', '0,0,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 50, 0, 30, 0, 0, 70, 0, 0, 0, 0, 1, 'default'); 
    26 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (3, 'Hydroponicfarm', 'data/buildings/hydro.png', '0,0,20,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 5, 0, 80, 0, 0, 0, 0, 1, 0, 1, 'default'); 
    27 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (4, 'Mine', 'data/buildings/umine.png', '0,0,20,140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,12,0,0,0,0,0,0,0,', 80, 5, 0, 0, 0, 20, 0, 0, 2, 0, 1, 'default'); 
    28 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (5, 'Erzverarbeitungsanlage', 'data/buildings/normerzverarb.png', '0,0,40,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,18,0,0,0,0,0,0,0,', '0,0,0,12,8,0,0,4,2,0,0,0,0,0,0,0,0,0,', 60, 6, 0, 0, 0, 10, 0, 0, 2, 0, 1, 'default'); 
    29 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (6, 'Wohnkuppel', 'data/buildings/habitat.png', '0,0,140,60,0,0,0,20,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 8, 0, 300, 0, 0, 0, 0, 1, 0, 1, 'default'); 
    30 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (7, 'Kunststofffabrik', 'data/buildings/raffin.png', '0,0,20,80,0,0,0,20,0,0,0,0,0,0,0,0,0,0,', '40,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 50, 5, 0, 0, 0, 0, 0, 0, 3, 0, 1, 'default'); 
    31 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (8, 'Fusionsreaktor', 'data/buildings/fusi.png', '0,50,60,80,0,0,40,30,15,0,0,0,0,0,0,0,0,0,', '0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 0, 40, 0, 1, 0, 0, 0, 0, 0, 1, 'default'); 
    32 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (9, 'Werft', 'data/buildings/werft.png', '0,0,100,200,0,0,50,100,40,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 2, 0, 1, 0, 4, 0, 0, 'werft'); 
    33 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (10, 'Thermalbohrer', 'data/buildings/thermalbohr.png', '0,0,100,150,0,0,50,50,25,25,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,36,0,0,0,0,0,0,0,', 70, 15, 0, 0, 11, 0, 0, 0, 2, 0, 1, 'default'); 
    34 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (11, 'Antimateriereaktor', 'data/buildings/amreaktor.png', '0,0,100,150,0,0,100,80,40,60,0,3,0,0,0,0,0,0,', '0,4,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 120, 0, 125, 0, 4, 0, 0, 0, 0, 0, 1, 'default'); 
    35 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (12, 'Verbesserter Erzverarbeiter', 'data/buildings/erzverarb.png', '0,0,50,100,0,0,60,30,75,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,48,0,0,0,0,0,0,0,', '0,0,0,14,18,0,6,6,4,2,0,0,0,0,0,0,0,0,', 120, 18, 0, 0, 9, 0, 0, 0, 2, 0, 1, 'default'); 
    36 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (13, 'Wohnpyramide', 'data/buildings/wohnp.png', '0,0,100,50,0,0,50,20,0,10,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 18, 0, 600, 10, 0, 0, 0, 1, 0, 1, 'default'); 
    37 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (14, 'Teilchenbeschleuniger', 'data/buildings/teilbeschleunig.png', '0,0,50,100,0,0,100,100,80,50,0,2,0,0,0,0,0,0,', '0,0,0,0,0,0,0,8,8,1,0,0,0,0,0,0,0,0,', '0,0,0,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 60, 0, 0, 5, 0, 0, 0, 3, 0, 1, 'default'); 
    38 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (15, 'Chippresse', 'data/buildings/chippresse.png', '0,0,50,100,0,0,100,100,100,50,0,0,0,0,0,0,0,0,', '0,0,6,4,0,0,2,14,6,1,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,', 80, 80, 0, 0, 8, 0, 0, 0, 3, 0, 1, 'default'); 
    39 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (16, 'Titanveredler', 'data/buildings/titanv.png', '0,0,50,70,0,0,0,20,20,0,0,0,0,0,0,0,0,0,', '0,0,0,8,0,0,0,6,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,', 30, 8, 0, 0, 3, 0, 0, 0, 2, 0, 1, 'default'); 
    40 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (17, 'Forschungszentrum', 'data/buildings/fz.png', '0,0,300,200,0,0,0,150,150,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 0, 0, 1, 0, 4, 0, 0, 'forschungszentrum'); 
    41 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (18, 'Flottenakademie', 'data/buildings/akademie.png', '0,0,200,100,0,0,50,50,50,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 21, 0, 1, 0, 4, 0, 0, 'academy'); 
    42 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (19, 'Adamatiumveredler', 'data/buildings/xentv.png', '0,0,80,60,0,0,30,30,40,0,0,0,0,0,0,0,0,0,', '0,0,0,4,0,0,3,2,1,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,', 60, 14, 0, 0, 9, 0, 0, 0, 2, 0, 1, 'default'); 
    43 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (20, 'Unterirdische Farm', 'data/buildings/farm.png', '0,0,120,150,0,0,60,40,30,5,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '1400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 80, 18, 0, 0, 25, 0, 0, 0, 1, 1, 1, 'default'); 
    44 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (21, 'Tiefenreaktor', 'data/buildings/tiefen.png', '0,0,150,200,0,0,70,120,60,30,0,1,0,0,0,0,0,0,', '0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 0, 75, 0, 25, 0, 0, 0, 0, 1, 1, 'default'); 
    45 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (22, 'Waffenfabrik', 'data/buildings/kst.png', '0,0,200,200,0,0,100,100,100,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 21, 0, 0, 24, 4, 0, 0, 'waffenfabrik'); 
    46 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (24, 'Shivanische Energiequelle', 'data/buildings/shive.png', '0,0,400,0,0,100,0,200,200,300,0,8,0,0,0,0,0,0,', '0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 40, 0, 220, 0, 44, 0, 0, 0, 0, 0, 1, 'default'); 
    47 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (29, 'Vasudanischer Antimateriereaktor', 'data/buildings/vamreaktor.png', '0,0,100,150,0,0,100,80,40,60,0,3,0,0,0,0,0,0,', '0,4,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 120, 0, 180, 0, 72, 0, 0, 0, 0, 0, 1, 'default'); 
    48 INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (30, 'Tiefenreaktor', 'data/buildings/tamreaktor.png', '0,0,150,200,0,0,70,120,60,30,0,1,0,0,0,0,0,0,', '0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 0, 180, 0, 73, 0, 0, 0, 0, 1, 1, 'default'); 
     24INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (1, 'Kommandozentrale', 'data/buildings/basis.png', '0,0,100,400,0,0,50,120,80,0,0,0,0,0,0,0,0,0,', '0,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,0,0,', '500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 20, 500, 0, 20, 1, 0, 4, 0, 1, 'net.driftingsouls.ds2.server.bases.Kommandozentrale'); 
     25INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (2, 'Reaktor (Uran)', 'data/buildings/ureaktor.png', '0,0,60,180,0,0,0,10,5,0,0,0,0,0,0,0,0,0,', '0,0,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 50, 0, 30, 0, 0, 70, 0, 0, 0, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     26INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (3, 'Hydroponicfarm', 'data/buildings/hydro.png', '0,0,20,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '800,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 5, 0, 80, 0, 0, 0, 0, 1, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     27INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (4, 'Mine', 'data/buildings/umine.png', '0,0,20,140,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,12,0,0,0,0,0,0,0,', 80, 5, 0, 0, 0, 20, 0, 0, 2, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     28INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (5, 'Erzverarbeitungsanlage', 'data/buildings/normerzverarb.png', '0,0,40,80,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,18,0,0,0,0,0,0,0,', '0,0,0,12,8,0,0,4,2,0,0,0,0,0,0,0,0,0,', 60, 6, 0, 0, 0, 10, 0, 0, 2, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     29INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (6, 'Wohnkuppel', 'data/buildings/habitat.png', '0,0,140,60,0,0,0,20,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 8, 0, 300, 0, 0, 0, 0, 1, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     30INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (7, 'Kunststofffabrik', 'data/buildings/raffin.png', '0,0,20,80,0,0,0,20,0,0,0,0,0,0,0,0,0,0,', '40,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,8,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 50, 5, 0, 0, 0, 0, 0, 0, 3, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     31INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (8, 'Fusionsreaktor', 'data/buildings/fusi.png', '0,50,60,80,0,0,40,30,15,0,0,0,0,0,0,0,0,0,', '0,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 0, 40, 0, 1, 0, 0, 0, 0, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     32INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (9, 'Werft', 'data/buildings/werft.png', '0,0,100,200,0,0,50,100,40,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 2, 0, 1, 0, 4, 0, 0, 'net.driftingsouls.ds2.server.bases.Werft'); 
     33INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (10, 'Thermalbohrer', 'data/buildings/thermalbohr.png', '0,0,100,150,0,0,50,50,25,25,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,36,0,0,0,0,0,0,0,', 70, 15, 0, 0, 11, 0, 0, 0, 2, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     34INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (11, 'Antimateriereaktor', 'data/buildings/amreaktor.png', '0,0,100,150,0,0,100,80,40,60,0,3,0,0,0,0,0,0,', '0,4,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 120, 0, 125, 0, 4, 0, 0, 0, 0, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     35INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (12, 'Verbesserter Erzverarbeiter', 'data/buildings/erzverarb.png', '0,0,50,100,0,0,60,30,75,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,48,0,0,0,0,0,0,0,', '0,0,0,14,18,0,6,6,4,2,0,0,0,0,0,0,0,0,', 120, 18, 0, 0, 9, 0, 0, 0, 2, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     36INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (13, 'Wohnpyramide', 'data/buildings/wohnp.png', '0,0,100,50,0,0,50,20,0,10,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 18, 0, 600, 10, 0, 0, 0, 1, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     37INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (14, 'Teilchenbeschleuniger', 'data/buildings/teilbeschleunig.png', '0,0,50,100,0,0,100,100,80,50,0,2,0,0,0,0,0,0,', '0,0,0,0,0,0,0,8,8,1,0,0,0,0,0,0,0,0,', '0,0,0,0,0,6,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 60, 0, 0, 5, 0, 0, 0, 3, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     38INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (15, 'Chippresse', 'data/buildings/chippresse.png', '0,0,50,100,0,0,100,100,100,50,0,0,0,0,0,0,0,0,', '0,0,6,4,0,0,2,14,6,1,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0,', 80, 80, 0, 0, 8, 0, 0, 0, 3, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     39INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (16, 'Titanveredler', 'data/buildings/titanv.png', '0,0,50,70,0,0,0,20,20,0,0,0,0,0,0,0,0,0,', '0,0,0,8,0,0,0,6,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,5,0,0,0,0,0,0,0,0,0,0,0,', 30, 8, 0, 0, 3, 0, 0, 0, 2, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     40INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (17, 'Forschungszentrum', 'data/buildings/fz.png', '0,0,300,200,0,0,0,150,150,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 0, 0, 1, 0, 4, 0, 0, 'net.driftingsouls.ds2.server.bases.Forschungszentrum'); 
     41INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (18, 'Flottenakademie', 'data/buildings/akademie.png', '0,0,200,100,0,0,50,50,50,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 21, 0, 1, 0, 4, 0, 0, 'net.driftingsouls.ds2.server.bases.Academy'); 
     42INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (19, 'Adamatiumveredler', 'data/buildings/xentv.png', '0,0,80,60,0,0,30,30,40,0,0,0,0,0,0,0,0,0,', '0,0,0,4,0,0,3,2,1,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,', 60, 14, 0, 0, 9, 0, 0, 0, 2, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     43INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (20, 'Unterirdische Farm', 'data/buildings/farm.png', '0,0,120,150,0,0,60,40,30,5,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '1400,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 80, 18, 0, 0, 25, 0, 0, 0, 1, 1, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     44INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (21, 'Tiefenreaktor', 'data/buildings/tiefen.png', '0,0,150,200,0,0,70,120,60,30,0,1,0,0,0,0,0,0,', '0,0,0,0,20,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 0, 75, 0, 25, 0, 0, 0, 0, 1, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     45INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (22, 'Waffenfabrik', 'data/buildings/kst.png', '0,0,200,200,0,0,100,100,100,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 0, 0, 0, 0, 21, 0, 0, 24, 4, 0, 0, 'net.driftingsouls.ds2.server.bases.Waffenfabrik'); 
     46INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (24, 'Shivanische Energiequelle', 'data/buildings/shive.png', '0,0,400,0,0,100,0,200,200,300,0,8,0,0,0,0,0,0,', '0,0,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 40, 0, 220, 0, 44, 0, 0, 0, 0, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     47INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (29, 'Vasudanischer Antimateriereaktor', 'data/buildings/vamreaktor.png', '0,0,100,150,0,0,100,80,40,60,0,3,0,0,0,0,0,0,', '0,4,0,0,0,2,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 120, 0, 180, 0, 72, 0, 0, 0, 0, 0, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
     48INSERT INTO `buildings` (`id`, `name`, `picture`, `buildcosts`, `consumes`, `produces`, `arbeiter`, `ever`, `eprodu`, `bewohner`, `techreq`, `eps`, `perplanet`, `perowner`, `category`, `ucomplex`, `deakable`, `module`) VALUES (30, 'Tiefenreaktor', 'data/buildings/tamreaktor.png', '0,0,150,200,0,0,70,120,60,30,0,1,0,0,0,0,0,0,', '0,30,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', '0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,', 60, 0, 180, 0, 73, 0, 0, 0, 0, 1, 1, 'net.driftingsouls.ds2.server.bases.DefaultBuilding'); 
    4949         
  • db/updates.xml

    r5fac4d5 ra6ba521  
    55                Aenderungen an den Daten gehalten werden. Dies erleichtert das aktualliseren des Servers 
    66                und auch eigener Datenbestaende, die man ggf angepasst hat.  
    7                 Ausgenommen sind Aenderungen an den Daten, die in Folge von Strukturaenderungen zwingent notwendig 
     7                Ausgenommen sind Aenderungen an den Daten, die in Folge von Strukturaenderungen zwingend notwendig 
    88                sind. Diese sollten jedoch generisch formuliert sein, so dass sie nicht nur auf den Beispiedaten 
    99                funktionieren. 
     
    214214                ALTER TABLE weaponfactory ADD CONSTRAINT weaponfactory_fk_bases FOREIGN KEY (col) REFERENCES bases(id); 
    215215        ]]></update> 
     216        <update type="structure" datum="2007-03-24"><![CDATA[ 
     217                 ALTER TABLE buildings CHANGE module module VARCHAR( 60 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'net.driftingsouls.ds2.server.bases.DefaultBuilding'; 
     218        ]]></update> 
     219        <update type="data" datum="2007-03-24"><![CDATA[ 
     220                 UPDATE buildings SET module='net.driftingsouls.ds2.server.bases.DefaultBuilding' WHERE module='default'; 
     221                 UPDATE buildings SET module='net.driftingsouls.ds2.server.bases.Kommandozentrale' WHERE module='kommandozentrale'; 
     222                 UPDATE buildings SET module='net.driftingsouls.ds2.server.bases.Forschungszentrum' WHERE module='forschungszentrum'; 
     223                 UPDATE buildings SET module='net.driftingsouls.ds2.server.bases.Academy' WHERE module='academy'; 
     224                 UPDATE buildings SET module='net.driftingsouls.ds2.server.bases.Werft' WHERE module='werft'; 
     225                 UPDATE buildings SET module='net.driftingsouls.ds2.server.bases.Waffenfabrik' WHERE module='waffenfabrik'; 
     226        ]]></update> 
    216227</updates> 
  • src/net/driftingsouls/ds2/server/bases/Building.java

    r31f53b6 ra6ba521  
    6363        } 
    6464         
    65         // TODO: remove me 
    66         private static String fixPhpClassNames(String module) { 
    67                 String prefix = Building.class.getPackage().getName()+"."; 
    68                 if( module.equals("default") ) { 
    69                         return prefix+"DefaultBuilding"; 
    70                 } 
    71                 if( module.equals("kommandozentrale") ) { 
    72                         return prefix+"Kommandozentrale"; 
    73                 } 
    74                 if( module.equals("forschungszentrum") ) { 
    75                         return prefix+"Forschungszentrum"; 
    76                 } 
    77                 if( module.equals("academy") ) { 
    78                         return prefix+"Academy"; 
    79                 } 
    80                 if( module.equals("werft") ) { 
    81                         return prefix+"Werft"; 
    82                 } 
    83                 if( module.equals("waffenfabrik") ) { 
    84                         return prefix+"Waffenfabrik"; 
    85                 } 
    86                 return prefix+"DefaultBuilding"; 
    87         } 
    88          
    8965        /** 
    9066         * Gibt eine Instanz der Gebaudeklasse des angegebenen Gebaeudetyps zurueck. 
     
    10379                        String module = row.getString("module"); 
    10480                        try { 
    105                                 Class<?> cls = Class.forName(fixPhpClassNames(module)); 
     81                                Class<?> cls = Class.forName(module); 
    10682                                Class<? extends Building> buildingCls = cls.asSubclass(Building.class); 
    10783                                Constructor<? extends Building> constr = buildingCls.getConstructor(SQLResultRow.class);