Hallo ,
ich würde gerne wissen , wieso der MySQLscript nicht funktioniert.
Andauernt kommt der selbe Fehler
Server: localhost
Fehler
SQL-Befehl:
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 15, 2006 at 06:40 PM
-- Server version: 4.1.12
-- PHP Version: 4.4.0-3ubuntu2
--
-- Database: `geldsack`
--
-- --------------------------------------------------------
--
-- Table structure for table `action`
--
CREATE TABLE `action` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`building` int( 10 ) unsigned NOT NULL default '0',
`cmd` int( 10 ) unsigned NOT NULL default '0',
`param1` int( 10 ) unsigned NOT NULL default '0',
`param2` int( 10 ) unsigned NOT NULL default '0',
`starttime` int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `building` ( `building` ) ,
KEY `cmd` ( `cmd` )
) TYPE = MYISAM AUTO_INCREMENT =1
MySQL meldet:
#1046 - No database selected
[ Zurück ]
Ich habe die Datei Importiert (Diese Fehlermeldung).
Wenn ich ihn eingebe dann kommt der Fehler :
Server: localhost Datenbank: geldsack
Fehler
SQL-Befehl:
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 15, 2006 at 06:40 PM
-- Server version: 4.1.12
-- PHP Version: 4.4.0-3ubuntu2
--
-- Database: `geldsack`
--
-- --------------------------------------------------------
--
-- Table structure for table `action`
--
CREATE TABLE `action` (
`id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`building` int( 10 ) unsigned NOT NULL default '0',
`cmd` int( 10 ) unsigned NOT NULL default '0',
`param1` int( 10 ) unsigned NOT NULL default '0',
`param2` int( 10 ) unsigned NOT NULL default '0',
`starttime` int( 10 ) unsigned NOT NULL default '0',
PRIMARY KEY ( `id` ) ,
KEY `building` ( `building` ) ,
KEY `cmd` ( `cmd` )
) TYPE = MYISAM AUTO_INCREMENT =1
MySQL meldet:
#1050 - Table 'action' already exists
[ Zurück ]
hier der Code :
[code]
-- phpMyAdmin SQL Dump
-- version 2.7.0-pl2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 15, 2006 at 06:40 PM
-- Server version: 4.1.12
-- PHP Version: 4.4.0-3ubuntu2
--
-- Database: `geldsack`
--
-- --------------------------------------------------------
--
-- Table structure for table `action`
--
CREATE TABLE `action` (
`id` int(10) unsigned NOT NULL auto_increment,
`building` int(10) unsigned NOT NULL default '0',
`cmd` int(10) unsigned NOT NULL default '0',
`param1` int(10) unsigned NOT NULL default '0',
`param2` int(10) unsigned NOT NULL default '0',
`starttime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `building` (`building`),
KEY `cmd` (`cmd`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `action`
--
-- --------------------------------------------------------
--
-- Table structure for table `army`
--
CREATE TABLE `army` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` char(64) NOT NULL default '',
`user` int(11) NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`x` int(11) NOT NULL default '0',
`y` int(11) NOT NULL default '0',
`nextactiontime` int(10) unsigned NOT NULL default '0',
`frags` double NOT NULL default '0',
`lumber` int(15) NOT NULL default '0',
`stone` int(15) NOT NULL default '0',
`food` int(15) NOT NULL default '0',
`metal` int(15) NOT NULL default '0',
`runes` int(15) NOT NULL default '0',
`type` tinyint(3) unsigned NOT NULL default '0',
`idle` int(10) unsigned NOT NULL default '0',
`quest` int(10) unsigned NOT NULL default '0',
`hellhole` int(10) unsigned NOT NULL default '0',
`follow` int(10) unsigned NOT NULL default '0',
`counttolimit` tinyint(3) unsigned NOT NULL default '1',
`useditem` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `pos` (`x`,`y`),
KEY `user` (`user`),
KEY `type` (`type`),
KEY `counttolimit` (`counttolimit`),
KEY `useditem` (`useditem`),
KEY `y` (`y`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `army`
--
-- --------------------------------------------------------
--
-- Table structure for table `armyaction`
--
CREATE TABLE `armyaction` (
`id` int(10) unsigned NOT NULL auto_increment,
`army` int(10) unsigned NOT NULL default '0',
`starttime` int(10) unsigned NOT NULL default '0',
`cmd` int(11) NOT NULL default '0',
`param1` int(11) NOT NULL default '0',
`param2` int(11) NOT NULL default '0',
`param3` int(11) NOT NULL default '0',
`orderval` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `army` (`army`),
KEY `cmd` (`cmd`),
KEY `starttime` (`starttime`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `armyaction`
--
-- --------------------------------------------------------
--
-- Table structure for table `armytransfer`
--
CREATE TABLE `armytransfer` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`sourcebuildingtype` int(10) unsigned NOT NULL default '0',
`sourcearmytype` int(10) unsigned NOT NULL default '0',
`sourcetransport` int(10) unsigned NOT NULL default '0',
`targetarmytype` int(10) unsigned NOT NULL default '0',
`transportarmytype` int(10) unsigned NOT NULL default '0',
`unitsbuildingtype` int(10) unsigned NOT NULL default '0',
`idlemod` int(10) unsigned NOT NULL default '0',
`transportertype` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=22 ;
--
-- Dumping data for table `armytransfer`
--
INSERT INTO `armytransfer` VALUES (1, 'Maschinen', 11, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (2, 'Viecher', 9, 0, 0, 4, 0, 9, 0, 0);
INSERT INTO `armytransfer` VALUES (3, 'Armeen', 8, 0, 0, 4, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (4, 'Stationierung', 47, 0, 0, 1, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (5, 'Stationierung', 47, 0, 0, 4, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (6, 'Flotten', 47, 0, 0, 3, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (7, 'Verschiffen', 47, 0, 0, 3, 4, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (8, 'Austausch(Besatzung)', 0, 3, 1, 3, 4, 0, 3, 0);
INSERT INTO `armytransfer` VALUES (9, 'Landung(Maschine)', 0, 3, 1, 1, 0, 0, 30, 0);
INSERT INTO `armytransfer` VALUES (10, 'Landung(Armee)', 0, 3, 1, 4, 0, 0, 60, 0);
INSERT INTO `armytransfer` VALUES (11, 'Austausch', 0, 4, 0, 4, 0, 0, 3, 0);
INSERT INTO `armytransfer` VALUES (12, 'Austausch(Schiffe)', 0, 3, 0, 3, 0, 0, 3, 0);
INSERT INTO `armytransfer` VALUES (13, 'Karawane', 16, 0, 0, 5, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (14, 'Arbeiter', 7, 0, 0, 6, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (15, 'Austausch', 0, 5, 0, 5, 0, 0, 3, 0);
INSERT INTO `armytransfer` VALUES (16, 'Austausch', 0, 6, 0, 6, 0, 0, 3, 0);
INSERT INTO `armytransfer` VALUES (17, 'Stationierung', 47, 0, 0, 6, 0, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (18, 'Verschiffen', 47, 0, 0, 3, 6, 0, 0, 0);
INSERT INTO `armytransfer` VALUES (19, 'Landung(Arbeiter)', 0, 3, 1, 6, 0, 0, 30, 0);
INSERT INTO `armytransfer` VALUES (20, 'Austausch(Besatzung)', 0, 3, 1, 3, 1, 0, 3, 0);
INSERT INTO `armytransfer` VALUES (21, 'Austausch(Besatzung)', 0, 3, 1, 3, 6, 0, 3, 0);
-- --------------------------------------------------------
--
-- Table structure for table `armytype`
--
CREATE TABLE `armytype` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`limit` int(10) NOT NULL default '0',
`ownerflags` int(10) unsigned NOT NULL default '0',
`addtechs` varchar(255) NOT NULL default '',
`subtechs` varchar(255) NOT NULL default '',
`weightlimit` int(10) NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=8 ;
--
-- Dumping data for table `armytype`
--
INSERT INTO `armytype` VALUES (1, 'Maschine', 1, 470090979, '', '', 1500);
INSERT INTO `armytype` VALUES (3, 'Flotte', 4, 593631, '', '', 5000000);
INSERT INTO `armytype` VALUES (4, 'Armee', 4, 471432415, '', '', 5000000);
INSERT INTO `armytype` VALUES (5, 'Karawane', 4, 591051, '', '', 1000000);
INSERT INTO `armytype` VALUES (6, 'Arbeiter', 10, 29979851, '', '', 100000);
INSERT INTO `armytype` VALUES (7, 'Magier', 0, 0, '', '', 0);
-- --------------------------------------------------------
--
-- Table structure for table `bug`
--
CREATE TABLE `bug` (
`id` int(10) unsigned NOT NULL auto_increment,
`finder` int(10) unsigned NOT NULL default '0',
`creator` int(10) unsigned NOT NULL default '0',
`created` int(10) unsigned NOT NULL default '0',
`closed` int(10) unsigned NOT NULL default '0',
`name` varchar(128) NOT NULL default '',
`text` text NOT NULL,
`desc` text NOT NULL,
`topic` tinyint(4) NOT NULL default '0',
`assigned_user` int(10) unsigned NOT NULL default '0',
`prio` tinyint(3) unsigned NOT NULL default '0',
`status` tinyint(3) unsigned NOT NULL default '0',
`x` int(11) NOT NULL default '0',
`y` int(11) NOT NULL default '0',
`img` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`),
KEY `finder` (`finder`,`creator`,`created`,`topic`,`assigned_user`,`prio`),
KEY `status` (`status`),
KEY `closed` (`closed`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `bug`
--
-- --------------------------------------------------------
--
-- Table structure for table `building`
--
CREATE TABLE `building` (
`id` int(10) unsigned NOT NULL auto_increment,
`x` int(11) NOT NULL default '0',
`y` int(11) NOT NULL default '0',
`user` int(10) unsigned NOT NULL default '0',
`type` tinyint(4) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`level` int(10) unsigned NOT NULL default '0',
`upgrades` int(10) unsigned NOT NULL default '0',
`upgradetime` int(10) unsigned NOT NULL default '0',
`hp` float NOT NULL default '0',
`mana` float NOT NULL default '0',
`construction` int(10) unsigned NOT NULL default '0',
`param` char(4) NOT NULL default '',
`nwse` tinyint(3) unsigned NOT NULL default '0',
`supportslots` tinyint(3) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `pos` (`x`,`y`),
KEY `user` (`user`),
KEY `type` (`type`),
KEY `construction` (`construction`),
KEY `flags` (`flags`),
KEY `hp` (`hp`),
KEY `y` (`y`)
) TYPE=MyISAM AUTO_INCREMENT=567427 ;
--
-- Dumping data for table `building`
--
INSERT INTO `building` VALUES (32191, 734, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32190, 735, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32188, 735, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32187, 737, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32166, 736, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32186, 736, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32106, 736, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32165, 737, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32185, 738, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32105, 738, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32192, 734, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32020, 731, -28, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (459323, 720, -34, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (459333, 742, -18, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32345, 720, -39, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32207, 728, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32180, 725, -33, 249, 10, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32179, 727, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32104, 738, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32258, 721, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32103, 737, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32173, 724, -33, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32164, 737, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32100, 739, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32099, 739, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32030, 733, -27, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32098, 739, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32163, 738, -34, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32097, 739, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (459328, 726, -18, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32019, 730, -29, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32162, 720, -36, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32161, 738, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32095, 739, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 6, 0);
INSERT INTO `building` VALUES (32094, 738, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32198, 727, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32160, 738, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32092, 737, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32172, 735, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (32091, 736, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32159, 739, -33, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32090, 735, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32089, 734, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (32088, 739, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32158, 739, -34, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32087, 738, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32157, 739, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32084, 736, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32083, 735, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32269, 727, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32082, 734, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 12, 0);
INSERT INTO `building` VALUES (32081, 723, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (32080, 724, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32079, 725, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32153, 737, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32101, 735, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32156, 739, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32155, 739, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 6, 0);
INSERT INTO `building` VALUES (32315, 742, -39, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32152, 736, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32151, 735, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 12, 0);
INSERT INTO `building` VALUES (32078, 726, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32077, 727, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32076, 728, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 6, 0);
INSERT INTO `building` VALUES (32181, 735, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32075, 727, -33, 249, 2, 0, 127, 0, 0, 1395, 1280, 0, '', 0, 0);
INSERT INTO `building` VALUES (32337, 724, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32260, 722, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32250, 720, -23, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32167, 737, -33, 249, 16, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32265, 724, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32333, 727, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32150, 726, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32149, 725, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32148, 724, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32067, 728, -28, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32154, 738, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32145, 720, -37, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32142, 720, -38, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32143, 724, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32026, 732, -30, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 6, 0);
INSERT INTO `building` VALUES (32177, 725, -34, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32140, 735, -35, 249, 12, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32139, 727, -35, 249, 11, 0, 127, 0, 0, 581, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32063, 732, -32, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 55);
INSERT INTO `building` VALUES (32137, 723, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32299, 742, -28, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32285, 740, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (459314, 723, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32135, 723, -33, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (459331, 736, -18, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32133, 724, -34, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32062, 730, -32, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 55);
INSERT INTO `building` VALUES (32297, 742, -26, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32332, 728, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32146, 724, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32279, 735, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32132, 725, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32277, 733, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32131, 726, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32130, 727, -37, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 6, 0);
INSERT INTO `building` VALUES (32129, 724, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32271, 729, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (459325, 731, -40, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32128, 725, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32127, 724, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32126, 724, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32125, 723, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32124, 723, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32123, 723, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32122, 723, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 12, 0);
INSERT INTO `building` VALUES (32121, 723, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32120, 726, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32119, 727, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32061, 731, -33, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 55);
INSERT INTO `building` VALUES (32060, 732, -34, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 55);
INSERT INTO `building` VALUES (32118, 727, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32117, 726, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32116, 725, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32059, 730, -34, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 69);
INSERT INTO `building` VALUES (32115, 728, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32058, 731, -35, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 55);
INSERT INTO `building` VALUES (32113, 726, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32112, 725, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32111, 724, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32110, 738, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32109, 737, -21, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 11, 0);
INSERT INTO `building` VALUES (32057, 732, -36, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 96);
INSERT INTO `building` VALUES (32056, 730, -36, 249, 9, 0, 127, 0, 0, 291, 0, 0, '', 0, 96);
INSERT INTO `building` VALUES (32246, 720, -25, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32069, 724, -28, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (459332, 742, -24, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32254, 720, -19, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32270, 728, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32286, 741, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (459324, 720, -29, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32055, 732, -24, 249, 13, 0, 200, 0, 0, 400, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32251, 720, -22, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32054, 732, -22, 249, 13, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32053, 730, -22, 249, 13, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32052, 731, -23, 249, 13, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32051, 730, -24, 249, 13, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32278, 734, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32049, 732, -26, 249, 13, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32048, 730, -26, 249, 13, 0, 200, 0, 0, 400, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32031, 733, -31, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32047, 738, -30, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32018, 731, -29, 249, 1, 0, 127, 0, 0, 14525, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32073, 735, -33, 249, 2, 0, 127, 0, 0, 1395, 1280, 0, '', 0, 0);
INSERT INTO `building` VALUES (32296, 742, -25, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32046, 738, -28, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32169, 737, -34, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (32045, 737, -29, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32044, 736, -30, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32043, 736, -28, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32024, 730, -28, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (32042, 735, -29, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32023, 730, -30, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 12, 0);
INSERT INTO `building` VALUES (32022, 732, -29, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32021, 732, -28, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32041, 734, -30, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32040, 734, -28, 249, 14, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32065, 727, -29, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32068, 725, -29, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32070, 724, -30, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32071, 726, -30, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32183, 736, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32025, 731, -30, 249, 7, 0, 127, 0, 0, 581, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32184, 737, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32147, 725, -36, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (459334, 742, -29, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32102, 736, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32086, 737, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32267, 725, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32028, 729, -31, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32029, 729, -27, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32294, 742, -23, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32195, 734, -22, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32138, 723, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32320, 739, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32176, 720, -35, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32178, 726, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 3, 0);
INSERT INTO `building` VALUES (32168, 738, -33, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (32064, 728, -30, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32171, 736, -35, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 9, 0);
INSERT INTO `building` VALUES (32144, 723, -34, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32199, 725, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32050, 731, -25, 249, 13, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (459327, 720, -18, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32241, 720, -26, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32307, 742, -33, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32194, 734, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 13, 0);
INSERT INTO `building` VALUES (32066, 726, -28, 249, 15, 0, 127, 0, 0, 291, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32263, 723, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (459317, 726, -40, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32204, 728, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32203, 726, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32202, 725, -25, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32201, 724, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32200, 726, -26, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (32197, 720, -33, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32205, 728, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32206, 728, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 7, 0);
INSERT INTO `building` VALUES (32208, 727, -24, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32209, 727, -23, 249, 6, 0, 127, 0, 0, 291, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (32210, 720, -32, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32211, 720, -31, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32214, 720, -30, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32224, 720, -28, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32335, 725, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32331, 729, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32232, 720, -27, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (459329, 731, -18, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (459326, 720, -24, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32252, 720, -21, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32253, 720, -20, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32340, 722, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32325, 734, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32322, 737, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32281, 737, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32274, 730, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32288, 742, -19, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32338, 723, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32312, 742, -37, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32290, 742, -20, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32324, 735, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32276, 732, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32291, 742, -21, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32282, 738, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32284, 739, -18, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32327, 733, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32310, 742, -35, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32329, 732, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32292, 742, -22, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32311, 742, -36, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32298, 742, -27, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32321, 738, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (459318, 736, -40, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32302, 742, -30, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32305, 742, -31, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (32306, 742, -32, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (459322, 742, -34, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32314, 742, -38, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (459315, 720, -40, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32342, 721, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (459319, 742, -40, 249, 73, 768, 127, 0, 0, 349, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (32318, 741, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32319, 740, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (32330, 730, -40, 249, 5, 0, 127, 0, 0, 349, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (151502, 459, -483, 249, 3, 0, 10, 0, 0, 6, 0, 0, '', 8, 0);
INSERT INTO `building` VALUES (151501, 461, -482, 249, 3, 0, 10, 0, 0, 6, 0, 0, '', 1, 0);
INSERT INTO `building` VALUES (151500, 461, -483, 249, 3, 0, 10, 0, 0, 6, 0, 0, '', 6, 0);
INSERT INTO `building` VALUES (151499, 460, -483, 249, 3, 0, 10, 0, 0, 6, 0, 0, '', 10, 0);
INSERT INTO `building` VALUES (151503, 460, -482, 249, 46, 0, 10, 0, 0, 115, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (151504, 461, -484, 249, 47, 0, 15, 0, 0, 147, 0, 0, '', 8, 0);
INSERT INTO `building` VALUES (151505, 461, -485, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (151506, 461, -486, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 15, 0);
INSERT INTO `building` VALUES (151507, 461, -487, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 5, 0);
INSERT INTO `building` VALUES (151508, 461, -488, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 14, 0);
INSERT INTO `building` VALUES (151509, 460, -486, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 8, 0);
INSERT INTO `building` VALUES (151510, 462, -486, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 2, 0);
INSERT INTO `building` VALUES (151511, 460, -488, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 8, 0);
INSERT INTO `building` VALUES (151512, 462, -488, 249, 48, 0, 10, 0, 0, 35, 0, 0, '', 2, 0);
INSERT INTO `building` VALUES (151513, 462, -483, 249, 8, 0, 10, 0, 0, 173, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (261109, 725, -39, 249, 64, 0, 10, 0, 0, 58, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (459777, 731, -27, 249, 51, 0, 100, 0, 0, 375, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567426, 731, -31, 249, 10, 0, 10, 0, 0, 115, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567386, 733, -32, 249, 14, 256, 15, 112, 1147644997, 123, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567387, 733, -33, 249, 14, 256, 15, 112, 1147645117, 123, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567388, 733, -34, 249, 14, 256, 15, 112, 1147645252, 123, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567389, 734, -34, 249, 14, 256, 15, 112, 1147645432, 123, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567390, 734, -33, 249, 14, 256, 15, 112, 1147645553, 123, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567391, 734, -32, 249, 14, 256, 15, 112, 1147645612, 123, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567392, 728, -32, 249, 6, 256, 13, 114, 1147646800, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567393, 728, -33, 249, 6, 256, 13, 114, 1147646861, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567394, 728, -34, 249, 6, 256, 13, 114, 1147646980, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567395, 728, -31, 249, 6, 256, 13, 114, 1147647101, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567396, 729, -33, 249, 7, 256, 11, 116, 1147644109, 233, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567397, 727, -34, 249, 6, 256, 13, 114, 1147647340, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567398, 726, -34, 249, 6, 256, 13, 114, 1147647460, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567399, 726, -33, 249, 6, 256, 13, 114, 1147647581, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567400, 726, -32, 249, 6, 256, 13, 114, 1147647701, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567401, 727, -32, 249, 6, 256, 13, 114, 1147647821, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567402, 727, -31, 249, 6, 256, 13, 114, 1147647941, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567403, 726, -31, 249, 6, 256, 13, 114, 1147648060, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567404, 725, -31, 249, 6, 256, 13, 114, 1147648180, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567405, 725, -32, 249, 6, 256, 13, 114, 1147648301, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567406, 724, -32, 249, 6, 256, 13, 114, 1147648420, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567407, 724, -31, 249, 6, 256, 13, 114, 1147648540, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567408, 723, -31, 249, 6, 256, 13, 114, 1147648600, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567409, 723, -32, 249, 6, 256, 13, 114, 1147648721, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567410, 722, -31, 249, 6, 256, 13, 114, 1147648840, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567411, 721, -31, 249, 6, 256, 13, 114, 1147649021, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567412, 722, -33, 249, 6, 256, 13, 114, 1147649140, 120, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567413, 722, -34, 249, 6, 256, 12, 115, 1147643821, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567414, 722, -35, 249, 6, 256, 12, 115, 1147644002, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567415, 721, -35, 249, 6, 256, 12, 115, 1147644122, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567416, 721, -36, 249, 6, 256, 12, 115, 1147644241, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567417, 722, -36, 249, 6, 256, 12, 115, 1147644301, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567418, 722, -37, 249, 6, 256, 12, 115, 1147644481, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567419, 721, -37, 249, 6, 256, 12, 115, 1147644601, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567420, 722, -32, 249, 6, 256, 12, 115, 1147644722, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567421, 721, -32, 249, 6, 256, 12, 115, 1147644842, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567422, 721, -33, 249, 6, 256, 12, 115, 1147644961, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567423, 728, -37, 249, 6, 256, 12, 115, 1147645082, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567424, 728, -36, 249, 6, 256, 12, 115, 1147645201, 118, 0, 0, '', 0, 0);
INSERT INTO `building` VALUES (567425, 728, -35, 249, 6, 256, 12, 115, 1147645262, 118, 0, 0, '', 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `buildinglevel`
--
CREATE TABLE `buildinglevel` (
`id` int(10) unsigned NOT NULL auto_increment,
`building` int(10) unsigned NOT NULL default '0',
`user` int(10) unsigned NOT NULL default '0',
`type` int(10) unsigned NOT NULL default '0',
`subtype` int(10) unsigned NOT NULL default '0',
`level` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
--
-- Dumping data for table `buildinglevel`
--
-- --------------------------------------------------------
--
-- Table structure for table `buildingname`
--
CREATE TABLE `buildingname` (
`id` int(10) unsigned NOT NULL default '0',
`name` varchar(128) NOT NULL default '',
PRIMARY KEY (`id`)
) TYPE=MyISAM;
--
-- Dumping data for table `buildingname`
--
-- --------------------------------------------------------
--
-- Table structure for table `buildingparam`
--
CREATE TABLE `buildingparam` (
`id` int(10) unsigned NOT NULL auto_increment,
`building` int(10) unsigned NOT NULL default '0',
`name` varchar(32) NOT NULL default '0',
`value` text NOT NULL,
PRIMARY KEY (`id`),
KEY `building` (`building`)
) TYPE=MyISAM AUTO_INCREMENT=134901 ;
--
-- Dumping data for table `buildingparam`
--
INSERT INTO `buildingparam` VALUES (124013, 459323, 'tax', '');
INSERT INTO `buildingparam` VALUES (124014, 459333, 'tax', '');
INSERT INTO `buildingparam` VALUES (124015, 459328, 'tax', '');
INSERT INTO `buildingparam` VALUES (124016, 459331, 'tax', '');
INSERT INTO `buildingparam` VALUES (124017, 459325, 'tax', '');
INSERT INTO `buildingparam` VALUES (124018, 459332, 'tax', '');
INSERT INTO `buildingparam` VALUES (124019, 459324, 'tax', '');
INSERT INTO `buildingparam` VALUES (124020, 459334, 'tax', '');
INSERT INTO `buildingparam` VALUES (124021, 459327, 'tax', '');
INSERT INTO `buildingparam` VALUES (124022, 459317, 'tax', '');
INSERT INTO `buildingparam` VALUES (124023, 459329, 'tax', '');
INSERT INTO `buildingparam` VALUES (124024, 459326, 'tax', '');
INSERT INTO `buildingparam` VALUES (124025, 459318, 'tax', '');
INSERT INTO `buildingparam` VALUES (124026, 459322, 'tax', '');
INSERT INTO `buildingparam` VALUES (124027, 459315, 'tax', '');
INSERT INTO `buildingparam` VALUES (124028, 459319, 'tax', '');
-- --------------------------------------------------------
--
-- Table structure for table `buildingtype`
--
CREATE TABLE `buildingtype` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(128) NOT NULL default '',
`descr` text NOT NULL,
`cost_lumber` int(10) unsigned NOT NULL default '0',
`cost_stone` int(10) unsigned NOT NULL default '0',
`cost_food` int(10) unsigned NOT NULL default '0',
`cost_metal` int(10) unsigned NOT NULL default '0',
`cost_runes` int(10) unsigned NOT NULL default '0',
`req_geb` varchar(128) NOT NULL default '',
`req_tech` varchar(128) NOT NULL default '',
`buildtime` int(10) unsigned NOT NULL default '0',
`maxhp` int(11) NOT NULL default '0',
`basemana` int(11) NOT NULL default '0',
`script` varchar(64) NOT NULL default '',
`color` varchar(8) NOT NULL default '',
`letter` varchar(8) NOT NULL default '',
`lettercolor` varchar(8) NOT NULL default '',
`speed` int(11) NOT NULL default '0',
`gfx` varchar(128) NOT NULL default '',
`special` int(10) unsigned NOT NULL default '0',
`flags` int(10) unsigned NOT NULL default '0',
`weightlimit` int(10) unsigned NOT NULL default '0',
`cssclass` varchar(64) NOT NULL default '',
`orderval` tinyint(4) NOT NULL default '0',
`ruinbtype` int(10) unsigned NOT NULL default '0',
`race` tinyint(3) unsigned NOT NULL default '1',
`terrain_needed` tinyint(3) unsigned NOT NULL default '0',
`mod_a` float NOT NULL default '1',
`mod_v` float NOT NULL default '1',
`mod_f` float NOT NULL default '1',
`connectto_terrain` varchar(255) NOT NULL default '',
`connectto_building` varchar(255) NOT NULL default '',
`neednear_building` varchar(255) NOT NULL default '',
`require_building` varchar(255) NOT NULL default '',
`exclude_building` varchar(255) NOT NULL default '',
`border` tinyint(3) unsigned NOT NULL default '1',
`movable_flag` int(10) unsigned NOT NULL default '0',
`movable_override_terrain` tinyint(3) unsigned NOT NULL default '1',
`convert_into_terrain` int(10) unsigned NOT NULL default '0',
`maxgfxlevel` int(10) unsigned NOT NULL default '1',
`maxrandcenter` int(10) unsigned NOT NULL default '0',
`maxrandborder` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `race` (`race`),
KEY `maxhp` (`maxhp`),
KEY `movable_flag` (`movable_flag`)
) TYPE=MyISAM AUTO_INCREMENT=76 ;
--
-- Dumping data for table `buildingtype`
--
INSERT INTO `buildingtype` VALUES (1, 'Haupthaus', '+12 Bevölkerungsmaximum + 12 je Stufe
+10 Slots je Rohstoff Produktion + 10 je Stufe
+250 Lagerkapazität je Rohstoff + 250 je Stufe
\r\nDas maximale Level andere Gebäude ist anfangs 3.
mit jedem Haupthaus-Level sind 3 weitere upgrades möglich.
Wenn das Haupthaus zerstört oder abgerissen wird,
werden auch alle Gebäude, Armeen und Forschungen zerstört.', 800, 800, 800, 800, 0, '', '', 36, 5000, 0, 'hq', '#FFFF00', 'H', 'black', 0, 'gebaeude-r%R%/hq-%L%.png', 0, 0, 0, 'hq', 1, 42, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (2, 'Magieturm', 'hier kann man Zauber erforschen, Runen produzieren und Zauberer ausbilden
\r\n\r\nProduktion:
\r\n* Turmzauberer
\r\n* Runen
\r\n\r\nForschung:
\r\n* Effiziente Runenproduktion
\r\n\r\nZauber:
\r\n* Spieler Defensiv
\r\n* Spieler Offensiv
\r\n* Area Defensiv
\r\n* Area Offensiv
\r\n* Armee Defensiv
\r\n* Armee Offensiv
\r\n* Armeezauberer', 5000, 5000, 5000, 5000, 0, '1:5', '', 69120, 480, 10, 'magic_tower', '#8888FF', 'T', 'yellow', 0, 'gebaeude-r%R%/magitower-%L%.png', 0, 512, 2400, 'magitower', 20, 27, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (3, 'Weg', 'auch der längste Weg beginnt mit dem ersten Schritt,\r\n
hier läuft die Armee schneller.', 5, 5, 0, 0, 0, '1:0', '', 2880, 5, 0, 'way', '#949454', '#', 'black', 60, 'path/path-%NWSE%-%L%.png', 0, 0, 0, 'path_%NWSE%', 11, 0, 0, 0, 1, 1, 1, '', '', '', '', '', 0, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (4, 'BROID - Obelisk', 'Blue Ray Of Instant Death - besser nicht in die nähe kommen =), kann Felder niederbrennen', 9999999, 9999999, 9999999, 9999999, 0, '', '', 69120, 999999999, 0, 'broid', 'black', 'i', 'white', 0, 'gebaeude-r%R%/broid-%L%.png', 1, 512, 0, 'broid', 0, 39, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (5, 'Wall', 'eine fette dicke Mauer, versperrt Armeen den Weg.', 5, 10, 0, 0, 0, '11:0,1:0', '', 5760, 120, 0, 'wall', 'gray', 'W', 'black', 0, 'wall/wall-%NWSE%-%L%.png', 0, 0, 0, 'wall_%NWSE%', 12, 0, 0, 0, 1, 1, 1, '', '73', '', '', '', 0, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (6, 'Haus', 'Ein schönes Wohnhaus, damit die Bevölkerung\r\n
nicht beim Haupthaus kampieren muss.\r\n
+10 Bevölkerungsmaximum + 10 je Stufe', 100, 100, 0, 0, 0, '1:0', '', 11520, 100, 0, 'house', 'red', 'm', 'yellow', 0, 'gebaeude-r%R%/house-%L%.png', 0, 0, 0, 'house', 2, 41, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 2, 0, 0);
INSERT INTO `buildingtype` VALUES (7, 'Lager', 'das Rohstofflager, je weiter Baustellen vom Lager entfernt\r\n
sind, desto länger brauchen sie zum bauen\r\n
+250 Lagerkapazität je Rohstoff + 250 je Stufe', 50, 50, 0, 0, 0, '1:0', '', 14400, 200, 0, 'lager', '#FFFF96', 'L', 'black', 0, 'gebaeude-r%R%/lager-%L%.png', 0, 0, 0, 'lager', 3, 26, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 2, 0, 0);
INSERT INTO `buildingtype` VALUES (8, 'Kaserne', 'hier kann man folgende Einheiten produzieren
\r\n\r\nProduktion:
\r\n* Miliz
\r\n* Kämpfer
\r\n* SchwertKrieger
\r\n* LanzenTräger
\r\n* Berserker
\r\n* Ritter', 80, 50, 0, 50, 0, '12:0,1:0', '', 34560, 150, 0, 'kaserne', '#FF80FF', 't', 'white', 0, 'gebaeude-r%R%/barracks-%L%.png', 0, 512, 0, 'barracks', 10, 38, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (9, 'Bauernhof', 'kikerikiiiii! gack-gack-gack-gack.. grunz-grunz
\r\n+10 Slots für Nahrungs-Produktion + 10 je Stufe
\r\n+2 extra für angrenzende Getreidefelder
\r\n\r\nForschung:
\r\n* Sense', 20, 15, 0, 0, 0, '1:0', '', 8640, 100, 0, 'farm', '#ffcc44', 'F', 'black', 0, 'gebaeude-r%R%/farm-%L%.png', 0, 0, 0, 'farm', 6, 35, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (10, 'Entwickleranstalt', 'Hier sind all die fleißigen Entwickler dieses tollen Spiels, wenn Sie nicht gerade ganz fleißig weiter daran baun :). Vielleicht sollte man sie auch einfach hier drin lassen *G*, aber machen kann man hiermit trotzdem nix.', 5000, 5000, 5000, 5000, 0, '', '', 69120, 100, 0, 'hospital', 'blue', 'h', 'yellow', 0, 'gebaeude-r%R%/hospital-%L%.png', 1, 512, 0, 'hospital', 16, 37, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (11, 'Werkstatt', 'lustige spielzeuge hehehe...
\r\nHier werden die mächtigen Rammböcke gefertigt,
\r\ndie Mauern und Gebäude dem Erdboden gleichmachen.
\r\n\r\nProduktion:
\r\n* Rammen
\r\n\r\nForschung:
\r\n* Architektur', 100, 50, 0, 150, 0, '1:2', '', 34560, 200, 0, 'werkstatt', '#CC8800', 'W', 'black', 0, 'gebaeude-r%R%/werkstatt-%L%.png', 0, 512, 1000, 'werkstatt', 8, 34, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (12, 'Schmiede', 'hier werden Klingen geschmiedet, Pfeilspitzen gegossen und Rüstungen gefertigt.
\r\n\r\nForschung:
\r\n* Kettenrüstung
\r\n* gehärtete Klingen
\r\n* Plattenpanzer
\r\n* Lederrüstung', 50, 100, 0, 300, 0, '1:3', '', 34560, 100, 0, 'schmiede', '#444444', 'S', 'white', 0, 'gebaeude-r%R%/schmiede-%L%.png', 0, 512, 0, 'schmiede', 9, 31, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (13, 'Holzfäller', 'hier wird fleissig das Hackebeil geschwungen
\r\n+10 Slots für Holz Produktion + 10 je Stufe
\r\n+2 extra für jeden angrenzenden Wald
\r\n\r\nForschung:
\r\n* Axt', 20, 15, 0, 0, 0, '1:0', '', 8640, 100, 0, 'farm', '#ffcc44', 'H', 'black', 0, 'gebaeude-r%R%/holzfaeller-%L%-b%BUSY%.png', 0, 0, 0, 'holzfaeller', 4, 40, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (14, 'Steinmetz', 'Hau Druff, Hau Druff, Hau Druff, AUA MEIN DAUMEN!
\r\n+10 Slots für Stein Produktion + 10 je Stufe
\r\n+2 extra für jeden angrenzenden Berg
\r\n\r\nForschung:
\r\n* Hammer', 20, 15, 0, 0, 0, '1:0', '', 8640, 100, 0, 'steinmetz', '#ffcc44', 'S', 'black', 0, 'gebaeude-r%R%/steinmetz-%L%-b%BUSY%.png', 0, 0, 0, 'steinmetz', 5, 32, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (15, 'Eisenmine', 'in dunstigen, spärlich beleuchteten Stollen, tief unter
der Erde, verrichten hier die Bergarbeiter ihr Tagwerk
und fördern das wertvolle Eisenerz zu Tage, das dann
hauptsächlich für das Schmieden von Waffen verwendet wird.
\r\n+10 Slots für Eisen Produktion + 10 je Stufe
\r\n+2 extra für jeden angrenzenden Berg
\r\n\r\nForschung:
\r\n* Spitzhacke', 20, 15, 0, 0, 0, '1:0', '', 8640, 100, 0, 'eisenmine', '#ffcc44', 'S', 'black', 0, 'gebaeude-r%R%/eisenmine-%L%-b%BUSY%.png', 0, 0, 0, 'eisenmine', 7, 36, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (16, 'Marktplatz', 'Frische Datteln, schöööne frische Datteln...\r\n
hier kann man Rohstoffhandel betreiben', 50, 50, 0, 10, 0, '', '', 17280, 100, 0, 'marketplace', 'red', 'M', 'white', 0, 'gebaeude-r%R%/marketplace-%L%.png', 0, 512, 0, 'marketplace', 26, 28, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (17, 'Tor', 'man selber kann immer durch seine Tore, aber die anderen\r\n
(zB Gildemitglieder, Fremde) nur wenn es offen ist.', 50, 60, 0, 10, 0, '11:2,1:0', '', 5760, 90, 0, 'gate', '#eeeeee', 'G', 'black', 60, 'gate/tor-zu-%NWSE%-%L%.png', 0, 0, 0, 'gate_%NWSE%', 13, 0, 0, 0, 1, 1, 1, '', '', '', '', '', 0, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (18, 'Brücke', '...', 80, 50, 0, 10, 0, '11:2,1:0', '', 5760, 10, 0, 'way', 'red', 'B', 'green', 60, 'gate/bridge-%NWSE%-%L%.png', 0, 0, 0, 'bridge_%NWSE%', 11, 0, 0, 2, 1, 1, 1, '', '', '', '', '', 0, 15, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (19, 'Schild', 'ein kleines nettes Schild, auf das man ganz viele Dinge schreiben kann', 15, 0, 0, 0, 0, '1:0', '', 2880, 10, 0, 'schild', 'brown', 'S', 'black', 60, 'gebaeude-r%R%/schild-%L%.png', 0, 0, 0, 'schild', 30, 0, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (20, 'Tempel', 'hier kann man seine Bewohner opfern, um irgendwelchen Göttern zu huldigen.', 5, 200, 50, 0, 0, '1:5', '', 11520, 60, 0, 'tempel', 'blue', 'T', 'white', 0, 'gebaeude-r%R%/tempel-%L%-%M%.png', 0, 512, 0, 'tempel', 24, 33, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (21, 'Höllenschlund', 'hier erscheinen böse Monster', 99999, 99999, 99999, 99999, 0, '', '', 34560, 300, 0, 'hellhole', '#FF0000', 'H', 'black', 0, 'landschaft/hellhole-%L%.gif', 1, 0, 0, 'hellhole', 0, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (22, 'Schachplatz', 'Lust auf eine kleines Schachspiel gegen andere Leute aus der Zwischenwelt...\r\n
kein Problem einfach hier Spielen', 500, 500, 50, 50, 0, '1:0', '', 11520, 50, 0, 'schachplatz', 'black', 'C', 'white', 0, 'gebaeude-r%R%/schachplatz-%L%.png', 0, 512, 0, 'schachplatz', 44, 29, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (23, 'Portal', 'Eine wunderbare Möglichkeit über weite Strecken zu reisen, man baut sein eigenes Portal, muss Zugang zu seinem Zielportal haben und los gehts, zum Aktivieren ist natürlich eine gewisse Aufwandsentschädigung zu zahlen, ausserdem kann die andere Seite Zoll verlangen\r\n
\r\nReichweite: 100 Pro Stufe\r\n
Aktiviert für: 1+stufe/3 transporte</br></p>\r\n', 5500, 5500, 2500, 7500, 5000, '11:15,1:10,2:3', '', 36000, 900, 0, 'portal', '#ccccaa', 'P', 'black', 0, 'gate/portal-zu-%L%.png', 0, 512, 0, 'portal', 21, 0, 0, 0, 1, 1, 1, '', '', '', '', '', 1, 0, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (24, 'Torbrücke', 'wie die Towerbridge in London ....', 100, 80, 0, 20, 0, '11:3,1:0', '', 5725, 90, 0, 'gate_bridge', '', 'GB', '', 120, 'gate/gb-zu-%NWSE%-%L%.png', 0, 0, 0, 'gb_%NWSE%', 13, 0, 0, 2, 1, 1, 1, '', '', '', '', '', 0, 15, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (25, 'Brunnen', 'kleiner Brunnen, der das Stadtbild verschönert', 0, 15, 0, 0, 0, '1:0', '', 2880, 10, 0, 'brunnen', '#666666', '', '', 60, 'gebaeude-r%R%/brunnen-%L%.png', 0, 0, 0, 'brunnen', 31, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (26, 'LagerRuine', 'das Rohstofflager, je weiter Baustellen vom Lager entfernt\r\n
sind, desto länger brauchen sie zum bauen\r\n
+250 Lagerkapazität je Rohstoff + 250 je Stufe', 50, 50, 0, 0, 0, '1:0', '', 28800, 200, 0, '', '#FFFF96', 'L', 'black', 180, 'gebaeude-r%R%/lager-dead.png', 1, 0, 0, 'lager_dead', 3, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (27, 'MagieturmRuine', 'hier kann man Zauber erforschen, Runen produzieren und Zauberer ausbilden
\r\n\r\nProduktion:
\r\n* Turmzauberer
\r\n* Runen
\r\n\r\nForschung:
\r\n* Effiziente Runenproduktion
\r\n\r\nZauber:
\r\n* Spieler Defensiv
\r\n* Spieler Offensiv
\r\n* Area Defensiv
\r\n* Area Offensiv
\r\n* Armee Defensiv
\r\n* Armee Offensiv
\r\n* Armeezauberer', 5000, 5000, 5000, 5000, 0, '1:5', '', 69120, 480, 10, '', '#8888FF', 'T', 'yellow', 180, 'gebaeude-r%R%/magitower-dead.png', 1, 0, 0, 'magitower_dead', 15, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (28, 'MartkplatzRuine', 'Frische Datteln, schöööne frische Datteln...\r\n
hier kann man Rohstoffhandel betreiben', 50, 50, 0, 10, 0, '', '', 17280, 100, 0, '', 'red', 'M', 'white', 180, 'gebaeude-r%R%/marketplace-dead.png', 1, 0, 0, 'marketplace_dead', 14, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (29, 'SchachplatzRuine', 'Lust auf eine kleines Schachspiel gegen andere Leute aus der Zwischenwelt...\r\n
kein Problem einfach hier Spielen', 500, 500, 50, 50, 0, '1:0', '', 11520, 50, 0, '', 'black', 'C', 'white', 180, 'gebaeude-r%R%/schachplatz-dead.png', 1, 0, 0, 'schachplatz_dead', 18, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (30, 'SchildRuine', 'ein kleines nettes Schild, auf das man ganz viele Dinge schreiben kann', 15, 0, 0, 0, 0, '1:0', '', 240, 10, 0, '', 'brown', 'S', 'black', 180, 'gebaeude-r%R%/schild-dead.png', 1, 0, 0, 'schild_dead', 19, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (31, 'SchmiedeRuine', 'hier werden Klingen geschmiedet, Pfeilspitzen gegossen und Rüstungen gefertigt.
\r\n\r\nForschung:
\r\n* Kettenrüstung
\r\n* gehärtete Klingen
\r\n* Plattenpanzer
\r\n* Lederrüstung', 50, 100, 0, 300, 0, '1:3', '', 34560, 100, 0, '', '#444444', 'S', 'white', 180, 'gebaeude-r%R%/schmiede-dead.png', 1, 0, 0, 'schmiede_dead', 9, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (32, 'SteinmetzRuine', 'Hau Druff, Hau Druff, Hau Druff, AUA MEIN DAUMEN!
\r\n+10 Slots für Stein Produktion + 10 je Stufe
\r\n+2 extra für jeden angrenzenden Berg
\r\n\r\nForschung:
\r\n* Hammer', 20, 15, 0, 0, 0, '1:0', '', 17280, 100, 0, '', '#ffcc44', 'S', 'black', 180, 'gebaeude-r%R%/steinmetz-dead.png', 1, 0, 0, 'steinmetz_dead', 5, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (33, 'TempelRuine', 'hier kann man seine Bewohner opfern, um irgendwelchen Göttern zu huldigen.', 5, 200, 50, 0, 0, '1:5', '', 11520, 60, 0, '', 'blue', 'T', 'white', 180, 'gebaeude-r%R%/tempel-dead.png', 1, 0, 0, 'tempel_dead', 16, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (34, 'WerkstattRuine', 'lustige spielzeuge hehehe...
\r\nHier werden die mächtigen Rammböcke gefertigt,
\r\ndie Mauern und Gebäude dem Erdboden gleichmachen.
\r\n\r\nProduktion:
\r\n* Rammen
\r\n\r\nForschung:
\r\n* Architektur', 100, 50, 0, 150, 0, '1:2', '', 34560, 200, 0, '', '#CC8800', 'W', 'black', 180, 'gebaeude-r%R%/werkstatt-dead.png', 1, 0, 0, 'werkstatt_dead', 8, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (35, 'BauernhofRuine', 'kikerikiiiii! gack-gack-gack-gack.. grunz-grunz
\r\n+10 Slots für Nahrungs-Produktion + 10 je Stufe
\r\n+2 extra für jeden angrenzenden Fluss + Bonus für angrenzende Getreidefelder
\r\n\r\nForschung:
\r\n* Sense', 20, 15, 0, 0, 0, '1:0', '', 17280, 100, 0, '', '#ffcc44', 'F', 'black', 180, 'gebaeude-r%R%/farm-dead.png', 1, 0, 0, 'farm_dead', 6, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (36, 'EisenminenRuine', 'in dunstigen, spärlich beleuchteten Stollen, tief unter
der Erde, verrichten hier die Bergarbeiter ihr Tagwerk
und fördern das wertvolle Eisenerz zu Tage, das dann
hauptsächlich für das Schmieden von Waffen verwendet wird.
\r\n+10 Slots für Eisen Produktion + 10 je Stufe
\r\n+2 extra für jeden angrenzenden Berg
\r\n\r\nForschung:
\r\n* Spitzhacke', 20, 15, 0, 0, 0, '1:0', '', 17280, 100, 0, '', '#ffcc44', 'S', 'black', 180, 'gebaeude-r%R%/eisenmine-dead.png', 1, 0, 0, 'eisenmine_dead', 7, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (37, 'EntwickleranstaltRuine', 'Hier sind all die fleißigen Entwickler dieses tollen Spiels, wenn Sie nicht gerade ganz fleißig weiter daran baun :). Vielleicht sollte man sie auch einfach hier drin lassen *G*, aber machen kann man hiermit trotzdem nix.', 5000, 5000, 5000, 5000, 0, '', '', 69120, 100, 0, '', 'blue', 'h', 'yellow', 180, 'gebaeude-r%R%/hospital-dead.png', 1, 0, 0, 'hospital_dead', 16, 0, 1, 0, 1, 1, 1, '', '', '', '', '', 1, 7, 1, 0, 1, 0, 0);
INSERT INTO `buildingtype` VALUES (38, 'Kase