TWLan Forum
neue version - flüchtlingslager und andere Dörfer - Printable Version

+- TWLan Forum (https://twlan.org)
+-- Forum: Legacy (https://twlan.org/forumdisplay.php?fid=61)
+--- Forum: TWLan 1.x (DSLan) (https://twlan.org/forumdisplay.php?fid=62)
+---- Forum: Deutsche Community (https://twlan.org/forumdisplay.php?fid=65)
+----- Forum: Fragen & Probleme (https://twlan.org/forumdisplay.php?fid=7)
+----- Thread: neue version - flüchtlingslager und andere Dörfer (/showthread.php?tid=795)

neue version - flüchtlingslager und andere Dörfer - OpEG - 25.11.2008

Hallo,

ich kann bei der neuen Version keine Flüchtlingslager einbauen und wenn ich mehr als 2 Döfer angebe (beic dem Punkt mit den Startdörfern) lädt der nicht mehr als 1, sondern es kommt nur ne Fehlermeldung.

Was können das für Fehler sein?

RE: neue version - flüchtlingslager und andere Dörfer - f4nt4Zy - 25.11.2008

lad mal den fix zur 1.13er ers
müsste dann gehen

RE: neue version - flüchtlingslager und andere Dörfer - OpEG - 25.11.2008

habe ich versucht

RE: neue version - flüchtlingslager und andere Dörfer - f4nt4Zy - 25.11.2008

schreib mal pls die fehler meldung Wink

RE: neue version - flüchtlingslager und andere Dörfer - pL4n3 - 25.11.2008

Es wird mit Sicherheit ein Fehler kommen, der in etwa so aussieht:

Code:
Warning: Division by zero in functions.php on line 239

Wenn du die Datei db-fix.php schon ausgeführt hast, wechsle bitte nach localhost/phpmyadmin, wähle dort die Datenbank lan aus und gehe oben auf Exportieren. Den Code dann bitte hier ins Forum schreiben...

Wenn ich Zeit habe werde ich die aktuelle Version fixen, sodass man sich den Bugfix nicht mehr runterladen muss.

MfG

RE: neue version - flüchtlingslager und andere Dörfer - OpEG - 25.11.2008

Quote:Warning: Division by zero in C:\Users\Marco\Documents\dslan1.13\dslan_v1.13\htdocs\lib\functions.php on line 239

und das tausend mal

RE: neue version - flüchtlingslager und andere Dörfer - pL4n3 - 25.11.2008

Jap, liegt daran, dass du den Bugfix nicht ausgeführt hast...

Code:
!!!ACHTUNG: BUGFIX!!!

Es ist bei der DSLan zu einem Fehler bekommen (Flüchtlingslager erstellen und teilweise auch beim Erstellen eines Dorfes.

Daher ladet euch den db-fix runter und macht folgendes:

1. Das Archiv extrahieren in den htdocs-Ordner der DSLan
2. localhost/db-fix.php aufrufen, ACHTUNG: NUR EINMAL!
3. Danach db-fix.php löschen.

Download db-fix: http://dslan.gfx-dose.de/download/db-fix.zip

Das einmal machen.

MfG

RE: neue version - flüchtlingslager und andere Dörfer - f4nt4Zy - 25.11.2008

entpacke die datei in den htdocs ordner der rest steht da Wink
finde das wort extrahieren auch nich so toll entpacken verstehen mehr Wink

RE: neue version - flüchtlingslager und andere Dörfer - OpEG - 25.11.2008

-- phpMyAdmin SQL Dump
-- version 2.9.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 25. November 2008 um 20:50
-- Server Version: 5.0.24
-- PHP-Version: 4.4.4
--
-- Datenbank: `lan`
--

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ally`
--

CREATE TABLE `ally` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL,
`short` varchar(100) character set latin1 collate latin1_german1_ci NOT NULL,
`points` int(20) NOT NULL,
`rank` int(11) NOT NULL,
`best_points` int(20) NOT NULL,
`members` int(11) NOT NULL,
`villages` int(11) NOT NULL,
`intern_text` text character set latin1 collate latin1_german1_ci NOT NULL,
`description` text character set latin1 collate latin1_german1_ci NOT NULL,
`homepage` varchar(640) collate utf8_unicode_ci NOT NULL,
`irc` varchar(640) collate utf8_unicode_ci NOT NULL,
`image` varchar(20) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `rank` (`rank`),
KEY `name` (`name`),
KEY `short` (`short`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `ally`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ally_events`
--

CREATE TABLE `ally_events` (
`id` int(11) NOT NULL auto_increment,
`ally` int(11) NOT NULL,
`time` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL,
`message` text character set latin1 collate latin1_german1_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `ally` (`ally`),
KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `ally_events`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `ally_invites`
--

CREATE TABLE `ally_invites` (
`id` int(11) NOT NULL auto_increment,
`from_ally` int(11) NOT NULL,
`to_userid` int(11) NOT NULL,
`to_username` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL,
`time` int(40) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `ally_invites`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `announcement`
--

CREATE TABLE `announcement` (
`id` int(11) NOT NULL auto_increment,
`text` text character set latin1 collate latin1_german1_ci NOT NULL,
`link` varchar(320) character set latin1 collate latin1_german1_ci NOT NULL,
`graphic` varchar(100) character set latin1 collate latin1_german1_ci NOT NULL,
`time` int(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `announcement`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `build`
--

CREATE TABLE `build` (
`id` int(11) NOT NULL auto_increment,
`building` varchar(30) character set latin1 collate latin1_german1_ci NOT NULL,
`villageid` int(11) default NULL,
`end_time` int(25) NOT NULL,
`build_time` int(25) NOT NULL,
PRIMARY KEY (`id`),
KEY `villageid` (`villageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `build`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `create_village`
--

CREATE TABLE `create_village` (
`nw_c` int(10) NOT NULL default '1',
`no_c` int(10) NOT NULL default '1',
`so_c` int(10) NOT NULL default '1',
`sw_c` int(10) NOT NULL default '1',
`nw` int(10) NOT NULL default '0',
`no` int(10) NOT NULL default '0',
`so` int(10) NOT NULL default '0',
`sw` int(10) NOT NULL default '0',
`no_alpha` int(10) NOT NULL default '0',
`nw_alpha` int(10) NOT NULL default '0',
`so_alpha` int(10) NOT NULL default '0',
`sw_alpha` int(10) NOT NULL default '0',
`next_left` int(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `create_village`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `dealers`
--

CREATE TABLE `dealers` (
`id` int(11) NOT NULL auto_increment,
`from_userid` int(11) NOT NULL,
`to_userid` int(11) NOT NULL,
`from_village` int(11) NOT NULL,
`to_village` int(11) NOT NULL,
`wood` int(11) NOT NULL,
`stone` int(11) NOT NULL,
`iron` int(11) NOT NULL,
`start_time` int(11) NOT NULL,
`end_time` int(11) NOT NULL,
`is_offer` int(1) NOT NULL default '0',
`dealers` int(6) NOT NULL default '0',
`type` varchar(4) character set latin1 collate latin1_german1_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `from_village` (`from_village`),
KEY `to_village` (`to_village`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `dealers`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `events`
--

CREATE TABLE `events` (
`id` int(11) NOT NULL auto_increment,
`event_time` int(11) default '0',
`event_type` varchar(15) character set latin1 collate latin1_german1_ci default NULL,
`event_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`villageid` int(15) default NULL,
`knot_event` int(15) NOT NULL,
`cid` varchar(32) character set latin1 collate latin1_german1_ci default '0',
`can_knot` int(1) NOT NULL default '0',
`is_locked` int(1) NOT NULL,
PRIMARY KEY (`id`),
KEY `event_type` (`event_type`),
KEY `event_id` (`event_id`),
KEY `event_time` (`event_time`),
KEY `user_id` (`user_id`),
KEY `villageid` (`villageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `events`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `login`
--

CREATE TABLE `login` (
`login_locked` enum('yes','no') character set latin1 collate latin1_german1_ci NOT NULL default 'no',
`start` varchar(50) character set latin1 collate latin1_german1_ci NOT NULL,
`first_visit` tinyint(1) NOT NULL default '0',
`extern_auth` varchar(32) collate utf8_unicode_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `login`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `logins`
--

CREATE TABLE `logins` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(250) character set latin1 collate latin1_german1_ci NOT NULL,
`time` int(33) NOT NULL,
`ip` varchar(30) character set latin1 collate latin1_german1_ci NOT NULL,
`userid` int(11) NOT NULL,
`uv` varchar(250) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=21 ;

--
-- Daten für Tabelle `logins`
--

INSERT INTO `logins` VALUES (1, 'exception', 1227640025, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (2, 'exception', 1227640033, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (3, 'exception', 1227640269, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (4, 'exception', 1227640367, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (5, 'exception', 1227640448, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (6, 'exception', 1227640569, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (7, 'exception', 1227640596, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (8, 'exception', 1227640597, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (9, 'exception', 1227640597, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (10, 'exception', 1227640597, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (11, 'exception', 1227640597, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (12, 'exception', 1227640598, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (13, 'exception', 1227640598, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (14, 'exception', 1227640599, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (15, 'exception', 1227640644, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (16, 'exception', 1227640976, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (17, 'exception', 1227640979, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (18, 'exception', 1227640998, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (19, 'exception', 1227640998, '127.0.0.1', 1, '');
INSERT INTO `logins` VALUES (20, 'exception', 1227642330, '127.0.0.1', 1, '');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `logs`
--

CREATE TABLE `logs` (
`id` int(11) NOT NULL auto_increment,
`user` varchar(320) character set latin1 collate latin1_german1_ci NOT NULL,
`village` varchar(320) character set latin1 collate latin1_german1_ci NOT NULL,
`time` int(40) NOT NULL,
`log` text character set latin1 collate latin1_german1_ci NOT NULL,
`event_id` int(11) NOT NULL,
`event_type` varchar(25) character set latin1 collate latin1_german1_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `logs`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mail_archiv`
--

CREATE TABLE `mail_archiv` (
`id` int(11) NOT NULL auto_increment,
`from_id` int(11) NOT NULL default '0',
`from_username` varchar(100) character set latin1 NOT NULL default '',
`to_id` int(11) NOT NULL default '0',
`to_username` varchar(100) character set latin1 NOT NULL default '',
`subject` varchar(150) character set latin1 NOT NULL default '',
`text` text character set latin1 NOT NULL,
`time` int(35) NOT NULL default '0',
`owner` int(11) NOT NULL,
`type` varchar(3) character set latin1 NOT NULL,
PRIMARY KEY (`id`),
KEY `to_id` (`to_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `mail_archiv`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mail_block`
--

CREATE TABLE `mail_block` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL,
`blocked_id` int(11) NOT NULL,
`blocked_name` varchar(150) character set latin1 collate latin1_german1_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `blocked_id` (`blocked_id`),
KEY `blocked_name` (`blocked_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `mail_block`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mail_in`
--

CREATE TABLE `mail_in` (
`id` int(11) NOT NULL auto_increment,
`from_id` int(11) NOT NULL default '0',
`from_username` varchar(100) character set latin1 NOT NULL default '',
`to_id` int(11) NOT NULL default '0',
`to_username` varchar(100) character set latin1 NOT NULL default '',
`subject` varchar(150) character set latin1 NOT NULL default '',
`text` text character set latin1 NOT NULL,
`is_read` int(1) NOT NULL default '0',
`is_answered` int(1) NOT NULL default '0',
`output_id` int(11) NOT NULL default '0',
`time` int(35) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `to_id` (`to_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `mail_in`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `mail_out`
--

CREATE TABLE `mail_out` (
`id` int(11) NOT NULL auto_increment,
`from_id` int(11) NOT NULL default '0',
`from_username` varchar(100) character set latin1 NOT NULL default '',
`to_id` int(11) NOT NULL default '0',
`to_username` varchar(100) character set latin1 NOT NULL default '',
`subject` varchar(150) character set latin1 NOT NULL default '',
`text` text character set latin1 NOT NULL,
`is_read` int(1) NOT NULL default '0',
`time` int(35) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `from_id` (`from_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `mail_out`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `movements`
--

CREATE TABLE `movements` (
`id` int(11) NOT NULL auto_increment,
`from_village` int(11) default NULL,
`to_village` int(11) default NULL,
`units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`type` varchar(15) character set latin1 collate latin1_german1_ci NOT NULL,
`start_time` int(25) NOT NULL,
`end_time` int(25) NOT NULL,
`building` varchar(60) character set latin1 collate latin1_german1_ci default NULL,
`from_userid` int(11) NOT NULL,
`to_userid` int(11) NOT NULL,
`to_hidden` int(1) default '0',
`wood` int(12) NOT NULL default '0',
`stone` int(12) NOT NULL default '0',
`iron` int(12) NOT NULL default '0',
`send_from_village` int(12) NOT NULL,
`send_from_user` int(12) NOT NULL,
`send_to_user` int(15) NOT NULL,
`send_to_village` int(15) NOT NULL,
`die` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `end_time` (`end_time`),
KEY `send_from_village` (`send_from_village`),
KEY `send_from_user` (`send_from_user`),
KEY `send_to_user` (`send_to_user`),
KEY `send_to_village` (`send_to_village`),
KEY `from_hidden` (`to_hidden`),
KEY `type` (`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `movements`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `offers`
--

CREATE TABLE `offers` (
`id` int(11) NOT NULL auto_increment,
`sell` int(11) NOT NULL,
`buy` int(11) NOT NULL,
`sell_ress` varchar(5) character set latin1 collate latin1_german1_ci NOT NULL,
`buy_ress` varchar(5) character set latin1 collate latin1_german1_ci NOT NULL,
`multi` int(11) NOT NULL,
`from_village` int(11) NOT NULL,
`time` int(40) NOT NULL,
`do_action` varchar(10) character set latin1 collate latin1_german1_ci NOT NULL,
`ratio_max` double NOT NULL,
`userid` int(11) NOT NULL,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `offers`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `offers_multi`
--

CREATE TABLE `offers_multi` (
`id` int(11) NOT NULL,
KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `offers_multi`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `recruit`
--

CREATE TABLE `recruit` (
`id` int(11) NOT NULL auto_increment,
`unit` varchar(40) character set latin1 collate latin1_german1_ci NOT NULL,
`num_unit` int(15) default '0',
`num_finished` int(15) default '0',
`last_reload` int(15) default '-1',
`time_finished` int(15) NOT NULL,
`time_start` int(15) NOT NULL,
`time_per_unit` varchar(30) character set latin1 collate latin1_german1_ci default NULL,
`building` varchar(35) character set latin1 collate latin1_german1_ci NOT NULL,
`villageid` int(11) NOT NULL,
PRIMARY KEY (`id`),
KEY `building` (`building`),
KEY `villageid` (`villageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `recruit`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `reports`
--

CREATE TABLE `reports` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(230) character set latin1 collate latin1_german1_ci NOT NULL,
`title_image` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL,
`time` int(25) NOT NULL,
`type` varchar(40) character set latin1 collate latin1_german1_ci NOT NULL,
`a_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`b_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`c_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`d_units` varchar(350) character set latin1 collate latin1_german1_ci NOT NULL,
`e_units` varchar(350) character set latin1 collate latin1_german1_ci default NULL,
`agreement` varchar(20) character set latin1 collate latin1_german1_ci NOT NULL,
`ram` varchar(15) character set latin1 collate latin1_german1_ci NOT NULL,
`catapult` varchar(40) character set latin1 collate latin1_german1_ci NOT NULL,
`message` text character set latin1 collate latin1_german1_ci NOT NULL,
`to_user` int(11) NOT NULL,
`from_user` int(11) NOT NULL,
`to_village` int(11) NOT NULL,
`from_village` int(11) NOT NULL,
`receiver_userid` int(11) NOT NULL,
`is_new` int(1) NOT NULL default '1',
`in_group` varchar(40) character set latin1 collate latin1_german1_ci default NULL,
`luck` varchar(6) character set latin1 collate latin1_german1_ci default NULL,
`moral` int(6) default NULL,
`wins` varchar(15) character set latin1 collate latin1_german1_ci NOT NULL,
`hives` varchar(100) character set latin1 collate latin1_german1_ci NOT NULL,
`see_def_units` int(1) NOT NULL default '1',
`ally` int(11) NOT NULL,
`allyname` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL,
`from_username` varchar(200) collate utf8_unicode_ci NOT NULL,
`to_username` varchar(200) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
KEY `receiver_userid` (`receiver_userid`),
KEY `group` (`in_group`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `reports`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `research`
--

CREATE TABLE `research` (
`id` int(11) NOT NULL auto_increment,
`research` varchar(30) character set latin1 collate latin1_german1_ci NOT NULL,
`villageid` int(11) NOT NULL,
`end_time` int(25) NOT NULL,
PRIMARY KEY (`id`),
KEY `villageid` (`villageid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

--
-- Daten für Tabelle `research`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `run_events`
--

CREATE TABLE `run_events` (
`id` int(11) NOT NULL,
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

--
-- Daten für Tabelle `run_events`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `save_players`
--

CREATE TABLE `save_players` (
`id` int(11) NOT NULL auto_increment,
`round_id` int(11) NOT NULL default '0',
`username` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL default '',
`rank` int(20) NOT NULL default '0',
`ally` varchar(20) character set latin1 collate latin1_german1_ci NOT NULL default '',
`points` int(20) NOT NULL default '0',
`villages` int(20) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=9 ;

--
-- Daten für Tabelle `save_players`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `save_rounds`
--

CREATE TABLE `save_rounds` (
`id` int(11) NOT NULL auto_increment,
`start` varchar(80) character set latin1 collate latin1_german1_ci NOT NULL default '',
`end` varchar(80) character set latin1 collate latin1_german1_ci NOT NULL default '',
`description` text character set latin1 collate latin1_german1_ci NOT NULL,
`speed_units` varchar(10) character set latin1 collate latin1_german1_ci NOT NULL default '',
`moral` int(1) NOT NULL default '0',
`speed` int(20) NOT NULL default '0',
`name` varchar(200) character set latin1 collate latin1_german1_ci NOT NULL default '',
`map` int(1) NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=3 ;

--
-- Daten für Tabelle `save_rounds`
--


-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `sessions`
--

CREATE TABLE `sessions` (
`id` int(11) NOT NULL auto_increment,
`userid` int(11) NOT NULL,
`sid` varchar(32) character set latin1 collate latin1_german1_ci NOT NULL,
`hkey` varchar(4) character set latin1 collate latin1_german1_ci NOT NULL,
`is_vacation` int(1) NOT NULL default '0',
PRIMARY KEY (`id`),
KEY `sid` (`sid`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=21 ;

--
-- Daten für Tabelle `sessions`
--

INSERT INTO `sessions` VALUES (20, 1, '7HEI5q8sv1DGn5RK9J2uNxTfMADS4vYI', '9m9B', 0);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `unit_place`
--

CREATE TABLE `unit_place` (
`unit_spear` int(11) default '0',
`unit_sword` int(11) default '0',
`unit_axe` int(11) default '0',
`unit_spy` int(11) default '0',
`unit_light` int(11) default '0',
`unit_heavy` int(11) default '0',
`unit_ram` int(11) default '0',
`unit_catapult` int(11) default '0',
`unit_snob` int(5) default '0',
`villages_from_id` int(11) NOT NULL default '0',
`villages_to_id` int(11) NOT NULL default '0',
KEY `villages_from_id` (`villages_from_id`),
KEY `villages_to_id` (`villages_to_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Daten für Tabelle `unit_place`
--

INSERT INTO `unit_place` VALUES (0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1);

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `users`
--

CREATE TABLE `users` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(150) collate utf8_unicode_ci default NULL,
`password` varchar(32) collate utf8_unicode_ci NOT NULL default '',
`banned` enum('Y','N') collate utf8_unicode_ci NOT NULL default 'N',
`villages` int(10) NOT NULL,
`points` int(20) NOT NULL,
`ennobled_by` varchar(90) collate utf8_unicode_ci NOT NULL,
`ally` int(11) NOT NULL default '-1',
`ally_titel` varchar(200) collate utf8_unicode_ci NOT NULL,
`ally_found` int(1) NOT NULL default '0',
`ally_lead` int(1) NOT NULL default '0',
`ally_invite` int(1) NOT NULL default '0',
`ally_diplomacy` int(1) NOT NULL default '0',
`ally_mass_mail` int(1) NOT NULL default '0',
`rang` int(11) NOT NULL,
`villages_mode` varchar(25) collate utf8_unicode_ci NOT NULL default 'prod',
`attacks` int(5) default '0',
`new_report` int(1) NOT NULL default '0',
`new_mail` int(1) default '0',
`market_sell` varchar(10) collate utf8_unicode_ci NOT NULL default 'all',
`market_buy` varchar(10) collate utf8_unicode_ci NOT NULL default 'all',
`market_ratio_max` varchar(5) collate utf8_unicode_ci NOT NULL default '3',
`killed_units_att` int(25) NOT NULL,
`killed_units_att_rank` int(11) NOT NULL,
`killed_units_def` int(25) NOT NULL,
`killed_units_def_rank` int(25) NOT NULL,
`killed_units_altogether` int(25) NOT NULL,
`killed_units_altogether_rank` int(11) NOT NULL,
`do_action` varchar(32) collate utf8_unicode_ci NOT NULL,
`last_activity` int(35) NOT NULL,
`birthday` varchar(10) collate utf8_unicode_ci NOT NULL,
`vacation_id` int(11) NOT NULL default '-1',
`vacation_name` varchar(150) collate utf8_unicode_ci NOT NULL,
`vacation_accept` int(1) NOT NULL default '0',
`b_day` int(2) NOT NULL,
`b_month` int(2) NOT NULL,
`b_year` int(4) NOT NULL,
`sex` enum('f','m','x') collate utf8_unicode_ci NOT NULL default 'x',
`home` varchar(150) collate utf8_unicode_ci NOT NULL,
`image` varchar(20) collate utf8_unicode_ci NOT NULL,
`personal_text` text collate utf8_unicode_ci NOT NULL,
`window_width` int(4) NOT NULL default '840',
`show_toolbar` int(1) NOT NULL default '1',
`dyn_menu` int(1) NOT NULL default '1',
`confirm_queue` int(1) NOT NULL default '1',
`map_size` int(2) NOT NULL default '9',
`memo` text collate utf8_unicode_ci NOT NULL,
`map_reload` text collate utf8_unicode_ci NOT NULL,
`graphical_overwiev` tinyint(1) NOT NULL default '1',
`overview` varchar(5) collate utf8_unicode_ci NOT NULL default 'new',
`stufen` varchar(5) collate utf8_unicode_ci NOT NULL default 'yes',
PRIMARY KEY (`id`),
KEY `username` (`username`),
KEY `rang` (`rang`),
KEY `vacation_id` (`vacation_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `users`
--

INSERT INTO `users` VALUES (1, 'exception', '8933720b03f432b3fe3877635e27975f', 'N', 1, 12355, '', -1, '', 0, 0, 0, 0, 0, 1, 'combined', 0, 0, 0, 'all', 'all', '3', 0, 0, 0, 0, 0, 0, '1227640694', 1227642330, '', -1, '', 0, 0, 0, 0, 'x', '', '', '', 840, 1, 1, 1, 9, '', 'a:1:{s:6:"55-0-0";i:1227640651;}', 1, 'new', 'yes');

-- --------------------------------------------------------

--
-- Tabellenstruktur für Tabelle `villages`
--

CREATE TABLE `villages` (
`id` int(11) NOT NULL auto_increment,
`x` int(11) NOT NULL,
`y` int(11) NOT NULL,
`name` varchar(100) collate utf8_unicode_ci default NULL,
`userid` int(11) NOT NULL,
`r_wood` varchar(230) collate utf8_unicode_ci default '500',
`r_stone` varchar(230) collate utf8_unicode_ci default '500',
`r_iron` varchar(230) collate utf8_unicode_ci default '400',
`r_bh` int(15) NOT NULL default '0',
`last_prod_aktu` int(35) NOT NULL,
`points` int(11) NOT NULL,
`continent` int(6) NOT NULL,
`main` int(5) default '30',
`barracks` int(5) default '25',
`stable` int(5) default '20',
`garage` int(5) default '15',
`snob` int(5) default '3',
`smith` int(5) default '20',
`place` int(5) default '1',
`market` int(5) default '25',
`wood` int(5) default '30',
`stone` int(5) default '30',
`iron` int(5) default '30',
`storage` int(5) default '30',
`farm` int(5) default '30',
`hide` int(5) default '10',
`wall` int(5) default '20',
`unit_spear_tec_level` int(11) default '1',
`unit_sword_tec_level` int(11) default '0',
`unit_axe_tec_level` int(11) default '0',
`unit_spy_tec_level` int(11) default '1',
`unit_light_tec_level` int(11) default '0',
`unit_heavy_tec_level` int(11) default '0',
`unit_ram_tec_level` int(11) default '0',
`unit_catapult_tec_level` int(11) default '0',
`unit_snob_tec_level` int(11) default '1',
`trader_away` int(5) default '0',
`main_build` varchar(200) collate utf8_unicode_ci NOT NULL,
`all_unit_spear` int(6) NOT NULL default '0',
`all_unit_sword` int(6) default '0',
`all_unit_axe` int(6) default '0',
`all_unit_spy` int(6) default '0',
`all_unit_light` int(6) default '0',
`all_unit_heavy` int(6) default '0',
`all_unit_ram` int(6) default '0',
`all_unit_catapult` int(6) default '0',
`all_unit_snob` int(6) default '0',
`recruited_snobs` int(5) default '0',
`control_villages` int(5) default '0',
`attacks` int(5) default '0',
`agreement` varchar(200) collate utf8_unicode_ci default '100',
`agreement_aktu` int(35) NOT NULL,
`snobed_by` int(11) default '-1',
`dealers_outside` int(6) NOT NULL default '0',
`create_time` int(40) NOT NULL,
`smith_tec` varchar(200) collate utf8_unicode_ci NOT NULL,
`conmap_con` varchar(10) collate utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `x_2` (`x`,`y`),
KEY `name` (`name`),
KEY `userid` (`userid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=2 ;

--
-- Daten für Tabelle `villages`
--

INSERT INTO `villages` VALUES (1, 525, 525, '001', 1, '946', '946', '846', 4412, 1227640694, 12355, 55, 30, 25, 20, 15, 3, 20, 1, 25, 30, 30, 30, 30, 30, 10, 20, 1, 0, 0, 1, 0, 0, 0, 0, 1, 0, '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '100', 0, -1, 0, 1227640025, '', '55-0-0');

RE: neue version - flüchtlingslager und andere Dörfer - pL4n3 - 25.11.2008

Jap, zeigt in der Tabelle create_village eindeutig, dass der Bugfix noch nicht ausgeführt wurde.

RE: neue version - flüchtlingslager und andere Dörfer - OpEG - 25.11.2008

super, danke! hat geklappt!