hallo cpers
Ik wil een opensource travian (look a like) maken.
Het is niet zo dat hij op travain lijkt, maar hetzelfde principe.
Ik wil op deze pagina alles updaten wat er allemaal af is enzo.
Ik heb al bezig met de database, maar scripters en designers zijn welkom, ik kan gerust wat hulp gebruiken.
database.sql (tot nu toe)
PHP
CREATE TABLE `User` (
`id` int(10) NOT NULL auto_increment,
`start` datetime NOT NULL default '0000-00-00 00:00:00',
`name` varchar(20) NOT NULL default '',
`password` varchar(20) NOT NULL default '',
`email` varchar(20) NOT NULL default '',
`online` datetime NOT NULL default '0000-00-00 00:00:00',
`village` varchar(20) NOT NULL default '',
`sex` varchar(20) NOT NULL default '',
`city` varchar(20) NOT NULL default '',
`info` text NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY `name` (name)
) TYPE=MyISAM;
CREATE TABLE `Village` (
`id` int(10) NOT NULL auto_increment,
`name` varchar(20) NOT NULL default '',
`iron` varchar(20) NOT NULL default '',
`stone` varchar(20) NOT NULL default '',
`wood` varchar(20) NOT NULL default '',
`points` varchar(20) NOT NULL default '',
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE `Main` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Farm` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`population` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Barracks` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Storage` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`capacity` int(10) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Hide` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Place` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Wall` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`protection` int(5) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Iron` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`production` int(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Stone` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`production` int(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Wood` (
`village` varchar(20) NOT NULL default '',
`level` int(5) NOT NULL default '0',
`production` int(20) NOT NULL default '0',
`time` datetime NOT NULL default '0000-00-00 00:00:00',
) TYPE=MyISAM;
CREATE TABLE `Hash` (
`name` varchar(20) NOT NULL default '',
`hash` varchar(20) NOT NULL default '',
UNIQUE KEY `hash` (hash)
) TYPE=MyISAM;
CREATE TABLE `Position` (
`village` varchar(20) NOT NULL default '',
`x-position` int(5) NOT NULL default '0',
`y-position` int(5) NOT NULL default '0'
) TYPE=MyISAM;
CREATE TABLE `Buddy` (
`name` varchar(20) NOT NULL default '',
`buddy` varchar(20) NOT NULL default ''
) TYPE=MyISAM;
CREATE TABLE `Message` (
`id` int(10) NOT NULL auto_increment,
`time` datetime NOT NULL default '0000-00-00 00:00:00',
`from` varchar(20) NOT NULL default '',
`to` varchar(20) NOT NULL default '',
`message` varchar(20) NOT NULL default '',
`read` int(1) NOT NULL default '0',
PRIMARY KEY (id)
) TYPE=MyISAM;
CREATE TABLE `Built` (
`village` varchar(20) NOT NULL default '',
`main` datetime NOT NULL default '0000-00-00 00:00:00',
`farm` datetime NOT NULL default '0000-00-00 00:00:00',
`barracks` datetime NOT NULL default '0000-00-00 00:00:00',
`storage` datetime NOT NULL default '0000-00-00 00:00:00',
`hide` datetime NOT NULL default '0000-00-00 00:00:00',
`place` datetime NOT NULL default '0000-00-00 00:00:00',
`wall` datetime NOT NULL default '0000-00-00 00:00:00'
) TYPE=MyISAM;Als jullie zin hebben om mee te werken, dan hoor ik dat graag.