Download Version 2.A3 alpha | Installation guide | FAQ
TWLan Forum › Legacy › TWLan 1.x (DSLan) › Deutsche Community › Fragen & Probleme v
neue version - flüchtlingslager und andere Dörfer

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Threaded Mode
neue version - flüchtlingslager und andere Dörfer
OpEG Offline
Anfänger
**
Posts: 18
Threads: 6
Joined: Aug 2008
Reputation: 0
#1
25.11.2008, 20:21
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?
Find
Reply
f4nt4Zy Offline
Neuling
*
Posts: 8
Threads: 1
Joined: Nov 2008
Reputation: 0
#2
25.11.2008, 20:32
lad mal den fix zur 1.13er ers
müsste dann gehen
Find
Reply
OpEG Offline
Anfänger
**
Posts: 18
Threads: 6
Joined: Aug 2008
Reputation: 0
#3
25.11.2008, 20:40
habe ich versucht
Find
Reply
f4nt4Zy Offline
Neuling
*
Posts: 8
Threads: 1
Joined: Nov 2008
Reputation: 0
#4
25.11.2008, 20:43
schreib mal pls die fehler meldung Wink
Find
Reply
pL4n3 Away
Chillkröte
Posts: 671
Threads: 43
Joined: May 2008
Reputation: 31
#5
25.11.2008, 20:46
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
Find
Reply
OpEG Offline
Anfänger
**
Posts: 18
Threads: 6
Joined: Aug 2008
Reputation: 0
#6
25.11.2008, 20:47
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
Find
Reply
pL4n3 Away
Chillkröte
Posts: 671
Threads: 43
Joined: May 2008
Reputation: 31
#7
25.11.2008, 20:49
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
Find
Reply
f4nt4Zy Offline
Neuling
*
Posts: 8
Threads: 1
Joined: Nov 2008
Reputation: 0
#8
25.11.2008, 20:51
entpacke die datei in den htdocs ordner der rest steht da Wink
finde das wort extrahieren auch nich so toll entpacken verstehen mehr Wink
Find
Reply
OpEG Offline
Anfänger
**
Posts: 18
Threads: 6
Joined: Aug 2008
Reputation: 0
#9
25.11.2008, 20:51
-- 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');
Find
Reply
pL4n3 Away
Chillkröte
Posts: 671
Threads: 43
Joined: May 2008
Reputation: 31
#10
25.11.2008, 20:53
Jap, zeigt in der Tabelle create_village eindeutig, dass der Bugfix noch nicht ausgeführt wurde.
Find
Reply
OpEG Offline
Anfänger
**
Posts: 18
Threads: 6
Joined: Aug 2008
Reputation: 0
#11
25.11.2008, 20:55
super, danke! hat geklappt!
Find
Reply




Users browsing this thread: 3 Guest(s)