Beiträge von Salamanter

Jup tut er

Ich habe als werbung immer nur 1 Banner sonst nix.
Ich weiß nicht was ihr wollt.
Geklaut ist das Script schonmal garnicht.
Ich hab nicht alle Datein auf Secret World umgebastelt.

Und auffliegen nene was soll da auffliegen ?

Lg

Hallo ,

mir was mal wieder langweilig , da hab ich mal schnell ein Browsergame gezaubert ^^.

http://secret-world.de.tc/

Viel Spaß

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&uuml;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

Hallo ,

ich weiß der Theard ist schon über 1 Jahr alt aber neija ...

Ich hab ein Ganzes Script. Keine Ahnung woher ich das Script habe aber ich hab insgesammt 8 stück XD Ein Browsergame zu basteln ist schwer das geb ich zu aber eine Manschafft von 20 Leuten zusammen zu trommeln und die dazu bewegen ein BG zu machen ist viel leichter.

Macht einfach eine AG in der Schule auf o.ä. .
Ihr braucht viele PC's viel Zeit und gute Programmierer.

Bei Fragen an mich ICQ 452-211-023
Ich beantworte fast alle.

Lg

Aha die "Animation" soll ja recht einfach sein.
Ich werd mich mal in den nächsten Tagen darum bemühen, flash zu studieren.

lg

flash klingt gut

thx ihr seid echt spitze!

Ich wollte nur wissen ob ihr ohne probleme auf die seite gelangen könnt.
Denn manche haben da probleme mit.

http://geldsack.ge.funpic.de/phpauction-gpl-2.5/index.php?

Hallo ,

wer kann mir phpauktion auf seinem Server installieren ?

Wäre echt nett (Ehrenamtlich).

Lg

Hallo ,

ich habe mir webauction geholt angepasst und aufm Server (Funpic) geladen.
Es läuft aber nicht... datenbank zugriffsfehler ... das hatte ich behoben nur jede Auktion wo ich reinstelle ist sofort beendet.

Wer kann mir Webauction installieren ?

Wichtig: min. 100 mb Traffic
Sonst läuft das ganze nicht.

Lg
Sala

ok ich versuchs mal ... 24 Bilder in der Sek. ? hmm... für ein Intro von 10 Sek. 240 Bilder. Ist n bissel Arbeit...

Hallo ,

ich würde gerne einen eigenen Cartoon machen.
Mit eigenen Figuren und Requisiten.

Sollte möglichst Freeware (Kostenlos) sein.

Danke im vorraus
lg
Salamant/der

Der richtige Code ist :

<embed src="http://" width="200" height="200" type="application/x-mplayer2" name=MediaPlayer autostart=0 showcontrols=1 showstatusbar=0 autorewind=1 showdisplay=0></embed>

.Embed klappt in meinen Augen immer.

Lg
Salamanter

Weil Du (tim) den Zahlencode falsch angiebst.
Versuch es einfach immer und immer wieder irgendwann klappt es schon.
Wenn nicht guck mal im Forum oder im Support rein.

Lg
Salamanter

Die sieht doch schön aus !

Hab nichts einzuwenden für mich ist die OK

Lg
Salamant/der

Hallo ,

SpyClip ist seit heute in der Open Beta !

Dort kann man sich richtig lustige Clips anschauen und sogar bald chatten.
Derzeit sind nur wenige Videos onine aber das endert sich nach ein par Tagen.

Im Forum werden Moderatoren gesucht bei intresse pn an mich oder ne e-mail an : timo - feick @ web .de

http://www.spyclip.de.tc

Lg
euer Salamant/der

Eine Umfrage wie euch die Seite gefällt ist auch dabei![/url]

Hat sich alles geklärt ... hab n Anbieter gefunden das mit denic oder wie auch immer ist mir zu dumm

http://www.spyclip.de.tc/

Lg Salamanter

PS: Can closed !!!

also nicht volljährig um es anders aus zu drücken.

durfte nochmal on also das Projekt hat bisher 0€ Kosten verbraucht. Alles wurde gesponsort oder in anderen Worten kostenlos zur verfügung gestellt. beeven ist ein guter Anbieter ohne Werbung ... Das Desing hab ich von einem guten Anbieter.

Ich brauche nur eine Umleitung auf meiner Adresse.
Auserdem bin ich minderjährig!

Lg
Timo Feick

alles sry aber ich muss dringenst off... morgen geht es weiter.