Posts: 44
Threads: 0
Joined: Feb 2009
Reputation:
0
is ja geil übers inet??
soll ich mal mein gesammtes Stämme Profil hier reinkopieren
Posts: 704
Threads: 17
Joined: Feb 2009
Reputation:
38
ja aber ich werde es nicht veröffentlichen. nur ich weiß nicht warum das so ist.
Posts: 1'004
Threads: 101
Joined: Jun 2008
meinst du übers internet über deine ip -.-
Posts: 44
Threads: 0
Joined: Feb 2009
Reputation:
0
(This post was last modified: 21.02.2009, 12:25 by Pizzaservice123 .)
21.02.2009, 12:23
hmm da scheint wohl ein progger ein bissel geträumt zu haben^^
ich werds bei mir mal probieren^^
machs aber auch
NICHT öffentlich... wozu sollte ich auch!? Hab ich nicht nötig... Hab sowieso sc hon jeden Tag bange das ne rechnung von meiner ganzen "medizin" im Briefkasten ist...^^ Warum soll ich mich dann auch noch mit ner Online Lan version von DS strafbarmachen. Ich kann PHP & mySQL, kann ein eigenes BG proggen wenn ich will... Und dann könnte man ja außer Geschwindigkeit, einheiten Gebäude nicht mal was verändern...
soll ich mal mein gesammtes Stämme Profil hier reinkopieren
Posts: 704
Threads: 17
Joined: Feb 2009
Reputation:
38
schon wieder spam der nicht zum tread gehört
i wie hört das nie auf
~spam bitte löschen
Posts: 1'946
Threads: 58
Joined: Aug 2008
Reputation:
82
Ich hab es mal auf nachfrage auf Englisch übersetzt:
How to make more Worlds:
1. You need to download DSLan. (
)
2. Open htdocs
3. Create a new Directory
4. >>Copy<< all from htdocs in the new Directory
5. Rename the new Directory in world1
6. Go to the new Directory. Then open include/config.php From the new Directory
7.1 Search:
// Datenbankverbindung:
$config['db_host'] = 'localhost';
$config['db_user'] = 'root';
$config['db_pw'] = '';
$config['db_name'] = 'lan';
7.2 Rename the db_name:
// Datenbankverbindung:
$config['db_host'] = 'localhost';
$config['db_user'] = 'root';
$config['db_pw'] = '';
$config['db_name'] = 'lan-w1';
8. Start Apache_Start and Mysql_Start
9. Open localhost/phpmyadmin
10. Go to SQL and give this code= CREATE DATABASE lan-w1
11. Copy the Database "Lan" into lan-w1! How to make?:
Go to SQL and give this code:
Code:
-- phpMyAdmin SQL Dump
-- version 2.9.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 22. Februar 2009 um 17:42
-- 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,
`intro_igm` text 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_contracts`
--
CREATE TABLE `ally_contracts` (
`from_ally` int(11) NOT NULL,
`type` varchar(10) collate latin1_general_ci NOT NULL,
`to_ally` int(11) NOT NULL,
`short` varchar(6) collate latin1_general_ci NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `ally_contracts`
--
-- --------------------------------------------------------
--
-- 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=3 ;
--
-- 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`
--
INSERT INTO `create_village` VALUES (1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 6);
-- --------------------------------------------------------
--
-- 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=1 ;
--
-- Daten für Tabelle `logins`
--
-- --------------------------------------------------------
--
-- 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 `quickbar`
--
CREATE TABLE `quickbar` (
`id` int(11) NOT NULL auto_increment,
`name` text collate latin1_general_ci NOT NULL,
`img` text collate latin1_general_ci NOT NULL,
`href` text collate latin1_general_ci NOT NULL,
`target` int(11) NOT NULL,
`uid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `quickbar`
--
-- --------------------------------------------------------
--
-- 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=1 ;
--
-- Daten für Tabelle `sessions`
--
-- --------------------------------------------------------
--
-- 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`
--
-- --------------------------------------------------------
--
-- 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',
`winter` varchar(30) collate utf8_unicode_ci NOT NULL,
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=1 ;
--
-- Daten für Tabelle `users`
--
-- --------------------------------------------------------
--
-- 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 '1',
`barracks` int(5) default '0',
`stable` int(5) default '0',
`garage` int(5) default '0',
`snob` int(5) default '0',
`smith` int(5) default '0',
`place` int(5) default '1',
`market` int(5) default '0',
`wood` int(5) default '0',
`stone` int(5) default '0',
`iron` int(5) default '0',
`storage` int(5) default '1',
`farm` int(5) default '1',
`hide` int(5) default '1',
`wall` int(5) default '0',
`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=1 ;
--
-- Daten für Tabelle `villages`
--
12. Copy DSLan_Start.bat
13. Rename the Copy of DSLan_Start.bat to DSLan_Start_W1.bat
14. Insert into DSLan_Start_W1.bat:
cd htdocs\welt1\daemons
:endlos
..\..\..\apache\bin\php.exe event.php
goto endlos
15. Open DSLan_Start_W1.bat
16. Go to localhost/world1
Sorry my english its not so good
✝ RiP ✝
Weiter geht's
Posts: 1'107
Threads: 37
Joined: May 2008
Reputation:
47
Nochmal: Es ist nicht legal die Lan übers Internet laufen zu lassen und auch der Manipulationsversuch ist nicht gestattet!
Posts: 175
Threads: 20
Joined: Jun 2008
Reputation:
2
back to the topic.
hab alles gemacht.
steht aber immer noch alle sso wie es davor war.
Also net wi ebei ds.de dass ich zwishcen den welten aussuchen kann und so..
kann da jemand helfen?
mfg
nob:
Posts: 1'946
Threads: 58
Joined: Aug 2008
Reputation:
82
(This post was last modified: 19.03.2009, 18:09 by Milu2K .)
19.03.2009, 18:07
In index.tpl kannst du Links einfügen. Also so:
Code:
[...]
<a href="localhost/weltX">WeltX</a>
[...]
Mit Bildern:
Code:
[...]
<a href="localhost/weltX"><img scr="lol.jpg"></a>
[...]
Edit: Noch bessert ist das: (htdocs/Templates/index.tpl mit dem ersetzen!)
Code:
<?xml version="1.0"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0
Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-
transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Die
Stämme</title>
<link rel="stylesheet" type="text/css" href="stamm.css"
/>
<meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">
<script type="text/javascript">
if(top!=self)
top.location=self.location;
</script>
</head>
<body>
<script src="http://add.gfx-dose.de/layer.js/dslan-
intern" type="text/javascript"></script>
<table align="center" cellspacing="0"
cellpaddin="0" border="0">
<tr>
<td width="100"/>
<td width="7" height="8"
style="background-image: url(graphic/border/r1.png);"/>
<td style="background
-image: url(graphic/border/r2.png);"/>
<td width="7" style="background-image:
url(graphic/border/r3.png);"/>
<td width="100"/>
</tr>
<tr>
<td/>
<td width="7"
style="background-image: url(graphic/border/r4.png);"/>
<td>
<img alt="Die
Stämme Lan" src="graphic/header.jpg"/>
</td>
<td width="7" style="background-
image: url(graphic/border/r5.png);"/>
</tr>
<tr>
<td/>
<td height="7"
style="background-image: url(graphic/border/r6.png);"/>
<td style="background
-image: url(graphic/border/r7.png);"/>
<td style="background-image: url
(graphic/border/r8.png);"/>
<td/>
</tr>
</table>
<div align="center">
<table
class="blind"><tr>
<td valign="top">
<table class="blind" cellspacing="0"
style="margin:6px">
<tr><td width="8" height="8" style="background-image:url
(graphic/border/r1.png);"></td><td style="background-image:url
(graphic/border/r2.png);"></td><td width="8" style="background-image:url
(graphic/border/r3.png);"></td></tr>
<tr>
<td style="background-image:url
(graphic/border/r4.png);"></td>
<td class="in_border">
<table class="intro"
width="450">
<tr><td valign="top">
<img
src="graphic/rabe_80x80.png" style="float:left; padding-right:10px" alt=""
/><strong>Die Stämme</strong> ist ein browserbasiertes Onlinespiel.
Jeder Spieler ist Herrscher eines kleinen Dorfes, dem er zu Ruhm und Macht
verhelfen soll.
</td><td rowspan="2" valign="top" width="120">
<ul
style="padding-left:12px; margin:0px 0px 20px">
<li>{$players}
Spieler</li>
<li>1 Spielwelt</li>
<li>Anfängerschutz</li>
<li>graphische
Dorfübersicht</li>
</ul>
<div style="line-
height:1em;font-size:12px"><a href="intro.php">» weitere Infos</a><br
/>
<span style="font-size:9px; font-weight:bold; font-
style:italic">(Bilder vom Spiel)</span></div>
</td></tr>
<tr><td>
<table class="blind" cellspacing="0"><tr><td>Erbaue ein Dorf,<br
/>werde Mitglied eines Stammes,<br />hilf deinen Freunden,<br />kämpfe
gegen deine Feinde!</td><td>
<img
src="graphic/big_buildings/snob_ani.gif" style="padding:4px" alt="" />
</td></tr>
</table>
</td></tr>
<tr><td colspan="2">
<a style="font-size:16pt;" href="register.php?ref=start">»
JETZT KOSTENLOS ANMELDEN!</a>
</td></tr>
</table>
</td>
<td
style="background-image:url(graphic/border/r5.png);"></td>
</tr>
<tr><td
height="8" style="background-image:url(graphic/border/r6.png);"></td><td
style="background-image:url(graphic/border/r7.png);"></td><td
style="background-image:url(graphic/border/r8.png);"></td></tr>
</table></td>
<td valign="top"><table class="blind" cellspacing="0" style="margin:6px">
<tr><td width="8" height="8" style="background-image:url
(graphic/border/r1.png);"></td><td style="background-image:url
(graphic/border/r2.png);"></td><td width="8" style="background-image:url
(graphic/border/r3.png);"></td></tr>
<tr>
<td style="background-image:url
(graphic/border/r4.png);"></td>
<td>
<form
action="{$smarty.post.world}/index.php?action=login" method="post">
<table class="in_border" width="252">
{if $error!=""}
<tr><td colspan="2" class="error">{$error}
</td></tr>
{/if}
<tr><td
colspan="2"><h4>Login</h4></td></tr>
{if
$row_login.login_locked=='yes'}
<tr><td
colspan="2"><h3>Der Login wurde gesperrt!</h3></td></tr>
{else}
<tr><td
align="right">Benutzername:</td><td><input name="user" type="text" size="15"
maxlength="30" value=""/></td></tr>
<tr><td
align="right">Passwort:</td><td><input name="clear" type="hidden"
value="true" /><input name="password" type="password" size="15"
maxlength="20" /></td></tr>
<td>
<p align="right">Welt</td><td
align="center">
<p align="left"><select size="1"
name="world">
<option selected
value="welt1">Welt1</option>
<option value="welt2">Welt2</option>
</select></td><tr><td><input
id="cookie" type="checkbox" name="cookie" value="true" /><label
for="cookie">Dauerhaft einloggen</label></td><td align="center"><input
type="image" src="graphic/lang/de/login.png" /></td></tr>
{/if}
<tr><td colspan="2"><br /><a href="http://www.die-
staemme.de/lost_pw.php">Passwort vergessen/ändern</a></td></tr>
</table>
</form>
</td>
<td style="background-
image:url(graphic/border/r5.png);"></td>
</tr>
<tr><td height="8"
style="background-image:url(graphic/border/r6.png);"></td><td
style="background-image:url(graphic/border/r7.png);"></td><td
style="background-image:url(graphic/border/r8.png);"></td></tr>
</table></td>
</tr></table>
<div style="margin-top:15px;margin-bottom:15px">
<a
href="help.php">Hilfe</a>
- <a href="http://dslan.gfx-dose.de">Support
Forum</a>
- <a href="sds_rounds.php">SDS-Runden</a>
- <a
href="first_steps.php">Erste Schritte</a>
- <a href="stats.php">Statistik</a>
-
<a href="impressum.php">Impressum</a>
</div>
{if count($announcement)>0}
<table class="blind" cellspacing="0" style="margin:6px">
<tr><td
width="8" height="8" style="background-image:url
(graphic/border/r1.png);"></td><td style="background-image:url
(graphic/border/r2.png);"></td><td width="8" style="background-image:url
(graphic/border/r3.png);"></td></tr>
<tr>
<td style="background-
image:url(graphic/border/r4.png);"></td>
<td>
<table class="vis"
width="450">
{foreach from=$announcement item=item
key=f_id}
<tr>
<td
align="center" width="5"><img src="./graphic/minibutton/
{$announcement.$f_id.graphic}.png" /></td>
<td
align="left">
{$announcement.$f_id.text}<br
/>
<table width="100%" cellpadding="0"
cellspacing="0">
<tr>
{if !empty
($announcement.$f_id.link)}
<td align="left" style="font-size: xx-small;"><a
href="{$announcement.$f_id.link}">» mehr</a></td>
{/if}
<td align="right" style="font-size: xx-small;">{$announcement.$f_id.time}
</td>
</tr>
</table>
</td>
</tr>
{/foreach}
</table>
</td>
<td style="background-image:url(graphic/border/r5.png);"></td>
</tr>
<tr><td height="8" style="background-image:url
(graphic/border/r6.png);"></td><td style="background-image:url
(graphic/border/r7.png);"></td><td style="background-image:url
(graphic/border/r8.png);"></td></tr>
</table>
{/if}
</div>
</body>
</html>
✝ RiP ✝
Weiter geht's
Posts: 66
Threads: 8
Joined: Mar 2009
Reputation:
0
Hab ein Problem!
wenn ich die andere welt öffnen will komm immer dies hier
Es konnte keine Verbindung zur DB hergestelt werden.
Posts: 175
Threads: 20
Joined: Jun 2008
Reputation:
2
Hab keine index.tpl?^^
nob:
Posts: 1'946
Threads: 58
Joined: Aug 2008
Reputation:
82
Doch in Templates von htdocs hast du eins
✝ RiP ✝
Weiter geht's
Posts: 175
Threads: 20
Joined: Jun 2008
Reputation:
2
Achso okay.
SOll ich die komplette index.tpl ersetzen?
nob:
Posts: 1'946
Threads: 58
Joined: Aug 2008
Reputation:
82
Eine Kopie kann man schon machen. Aber dann die Original ersetzen
✝ RiP ✝
Weiter geht's
Posts: 175
Threads: 20
Joined: Jun 2008
Reputation:
2
Ja also den Code von dir den du gesagt hast mit dem originalen index.tpl ersetzen..
das prob ist nur, ich hab das neue DS, halt v.5 .. mit deinem code, krieg ich da das alte wieder oder ist es für das neue?
nob:
Posts: 1'946
Threads: 58
Joined: Aug 2008
Reputation:
82
Das Alte. Ich werde Schnell einen vom neuen Code machen
Edit:
Code:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>Die Stämme - Das Browsergame im
Mittelalter</title>
<meta http-equiv="Content-Type" content="text/html;
charset=UTF-8" />
<link rel="stylesheet" type="text/css" href="start.css" />
<meta name="description" content="Die Stämme ist ein
Browsergame. Jeder Spieler ist Herrscher eines kleinen Dorfes, dem er zu Ruhm
und Macht verhelfen soll." />
<meta name="keywords" content="Browsergame, Browsergames,
Browserspiel, Onlinespiel, Onlinegame, Mittelalter, Ritter, Burg, Burgen,
Dorf, Krieg, Kampf, Kämpfen, Ruhm, Ehre, Die Stämme" />
<link rel="stylesheet" type="text/css" href="index.css?
1232382056" />
<!--[if lt IE 7]>
<link rel="stylesheet" type="text/css" href="index_ie6.css"
media="screen"/>
<![endif]-->
<script type="text/javascript">
if(top!=self)
top.location=self.location;
</script>
<style type="text/css">
</style>
</head>
<body>
<div id="index_body">
<div id="main">
<div id="header">
<h1><a href="/index.php"
style="background:url(graphic/lang/de/bg-logo.jpg) no-repeat 100% 0;">Die
Stämme</a></h1>
<div class="navigation">
<div class="navigation-holder">
<div class="navigation-
wrapper">
<div
id="navigation_span">
<a
href="help.php">Hilfe</a> - <a href="http://dslan.gfx-dose.de">DSLan
Forum</a> - <a href="sds_rounds.php">SDS-Runden</a> - <a
href="stats.php">Statistik</a>
</div>
</div>
</div>
</div>
<span class="paladin"><img
src="graphic/index/bg-paladin.png" alt="" /></span>
</div> <div id="content">
<div class="container-block">
<div class="container-
top"></div>
<div class="container">
<div class="info-block">
<img src="http://www.die-staemme.de/graphic/index/bg-raven.gif"
alt="" />
<h2>Die Stämme</h2>
<p>Die Stämme ist ein Browsergame, das im Mittelalter spielt.
Jeder Spieler ist Herrscher eines kleinen Dorfes, dem er zu Ruhm und Macht
verhelfen soll.</p>
<a class="btn-kostenlos-anmelden" href="register.php">Jetzt
kostenlos anmelden!</a>
<strong>Bilder vom Spiel:</strong>
<ul class="screenshots">
<li><a href="javascript:toggle_screenshot(1)"><img src="graphic/index/bg-
screenshots-thumb-1.jpg" alt="" /></a></li>
<li><a href="javascript:toggle_screenshot(2)"><img
src="graphic/index/bg-screenshots-thumb-2.jpg" alt="" /></a></li>
<li class="last"><a
href="javascript:toggle_screenshot(3)"><img src="graphic/index/bg-
screenshots-thumb-3.jpg" alt="" /></a></li>
</ul>
<br style="clear:both;" />
<strong style="padding-top:10px;">Schon {$players} Spieler sind
dabei!</strong>
</div>
<div class="login-block">
<h2 style="text-align:left;margin-bottom:15px;">Die Stämme -
Login</h2>
<form action="{$smarty.post.world}/index.php?action=login"
method="post">
<div>
<label for="user">
Benutzername:</strong>
<span><input id="user" name="user"
class="text" type="text" value="" /></span>
</label>
<label for="password">
<strong>Passwort:</strong>
<span><input name="clear" type="hidden"
value="true" /><input id="password" name="password" class="text"
type="password" /></span>
<select size="1" name="world">
<option value="welt1" selected>Welt1</option>
<option value="welt2">Welt2</option>
</select> </label><input type="submit" value=""
id="login-btn-input" onmouseover="javascript:hover_toggle_css('login-btn-
input','login-btn-input-hover',false);return true;"
onmouseout="javascript:hover_toggle_css('login-btn-input','login-btn-input-
hover',false);return true;" />
<br style="clear:both;"/>
<label for="cookie" style="text-align:right;">
<input id="cookie" type="checkbox"
name="cookie" value="true" />
Dauerhaft einloggen
</label>
<p><a href="http://www.die-
staemme.de/lost_pw.php">Passwort vergessen/ändern</a></p>
</div>
</form>
</div>
</div>
<div class="container-
bottom"></div>
</div>
</div><!-- content -->
<div class="closure">
© 2003 -
2009 InnoGames GmbH · DSLan Version by marhei
</div> </div><!-- main -->
<script type="text/javascript"
src="mootools.js?1232382056" ></script>
<script type="text/javascript" src="index.js?
1232382056"></script>
<div id="screenshot"
style="visibility:hidden" onclick="hide_screenshot();">
<div id="screenshot_image"></div>
</div>
</div>
</body>
</html>
✝ RiP ✝
Weiter geht's
Posts: 23
Threads: 2
Joined: Mar 2009
Reputation:
0
Can someone please translate me a totourial on how to get more than 1 server?
Mfg Kristure
Sry for my bad english
Posts: 1'946
Threads: 58
Joined: Aug 2008
Reputation:
82
✝ RiP ✝
Weiter geht's
Posts: 175
Threads: 20
Joined: Jun 2008
Reputation:
2
(22.02.2009, 17:43) milos Wrote: Ich hab es mal auf nachfrage auf Englisch übersetzt:
How to make more Worlds:
1. You need to download DSLan. ( )
2. Open htdocs
3. Create a new Directory
4. >>Copy<< all from htdocs in the new Directory
5. Rename the new Directory in world1
6. Go to the new Directory. Then open include/config.php From the new Directory
7.1 Search:
// Datenbankverbindung:
$config['db_host'] = 'localhost';
$config['db_user'] = 'root';
$config['db_pw'] = '';
$config['db_name'] = 'lan';
7.2 Rename the db_name:
// Datenbankverbindung:
$config['db_host'] = 'localhost';
$config['db_user'] = 'root';
$config['db_pw'] = '';
$config['db_name'] = 'lan-w1';
8. Start Apache_Start and Mysql_Start
9. Open localhost/phpmyadmin
10. Go to SQL and give this code= CREATE DATABASE lan-w1
11. Copy the Database "Lan" into lan-w1! How to make?:
Go to SQL and give this code:
Code:
-- phpMyAdmin SQL Dump
-- version 2.9.0.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Erstellungszeit: 22. Februar 2009 um 17:42
-- 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,
`intro_igm` text 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_contracts`
--
CREATE TABLE `ally_contracts` (
`from_ally` int(11) NOT NULL,
`type` varchar(10) collate latin1_general_ci NOT NULL,
`to_ally` int(11) NOT NULL,
`short` varchar(6) collate latin1_general_ci NOT NULL,
`id` int(11) NOT NULL auto_increment,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `ally_contracts`
--
-- --------------------------------------------------------
--
-- 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=3 ;
--
-- 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`
--
INSERT INTO `create_village` VALUES (1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 6);
-- --------------------------------------------------------
--
-- 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=1 ;
--
-- Daten für Tabelle `logins`
--
-- --------------------------------------------------------
--
-- 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 `quickbar`
--
CREATE TABLE `quickbar` (
`id` int(11) NOT NULL auto_increment,
`name` text collate latin1_general_ci NOT NULL,
`img` text collate latin1_general_ci NOT NULL,
`href` text collate latin1_general_ci NOT NULL,
`target` int(11) NOT NULL,
`uid` int(11) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci AUTO_INCREMENT=1 ;
--
-- Daten für Tabelle `quickbar`
--
-- --------------------------------------------------------
--
-- 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=1 ;
--
-- Daten für Tabelle `sessions`
--
-- --------------------------------------------------------
--
-- 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`
--
-- --------------------------------------------------------
--
-- 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',
`winter` varchar(30) collate utf8_unicode_ci NOT NULL,
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=1 ;
--
-- Daten für Tabelle `users`
--
-- --------------------------------------------------------
--
-- 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 '1',
`barracks` int(5) default '0',
`stable` int(5) default '0',
`garage` int(5) default '0',
`snob` int(5) default '0',
`smith` int(5) default '0',
`place` int(5) default '1',
`market` int(5) default '0',
`wood` int(5) default '0',
`stone` int(5) default '0',
`iron` int(5) default '0',
`storage` int(5) default '1',
`farm` int(5) default '1',
`hide` int(5) default '1',
`wall` int(5) default '0',
`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=1 ;
--
-- Daten für Tabelle `villages`
--
12. Copy DSLan_Start.bat
13. Rename the Copy of DSLan_Start.bat to DSLan_Start_W1.bat
14. Insert into DSLan_Start_W1.bat:
cd htdocs\welt1\daemons
:endlos
..\..\..\apache\bin\php.exe event.php
goto endlos
15. Open DSLan_Start_W1.bat
16. Go to localhost/world1
Sorry my english its not so good
nob:
Posts: 69
Threads: 2
Joined: May 2009
Reputation:
0
Hi,
ich kann irgendwie nicht zwischen den Verschiedenen Welten Tauschen, wollte mir 2 Welten erstellen. 1 SDS und 1 Normale Langsame, aber ich habe immer nur die Welt die ich gaaanz am Anfang im Normalen HTDOCS Ordner habe.
Kann mir wer Helfen?