Anyone got the Pokemon-area.com files

Well, im waiting for others to release their attempts before i give it away.

Quote:

---

Originally Posted by DeathLord17

Well, im waiting for others to release their attempts before i give it away.

---

Not a problem boss :ott1:

As i cannot speak it, i cannot make an attempt at creating the full database whereas if it was english i would.
However my brother has 2 friends at college which are from the Netherlands and one has helped me previously translate a habbo cms so I should have the full game and database translated within 48 hours - 72 hours based upon their availability

You can do it without knowledge of dutch. certain parts of code, similar in all languages very easy to find the db stuff.

I made the tables that DeathLord17 made into an sql file. But when I make the database and everything I get a whole bunch of text and a green background when I go on the page. Anyways heres the sql.

http://www.mediafire.com/?ixa62vz3zj9aojh

It only gives 1 table.

You need 90% of the sql for the webpages to work. AND you will need to fix deprecated variables and equations. All of which i have done.

I found.

Code:

---

CREATE TABLE IF NOT EXISTS `markt` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `soort` varchar(16) NOT NULL,
  `beschikbaar` tinyint(1) NOT NULL DEFAULT '1',
  `pokemonid` smallint(3) NOT NULL DEFAULT '0',
  `naam` varchar(14) NOT NULL,
  `silver` smallint(5) unsigned NOT NULL,
  `gold` smallint(5) unsigned NOT NULL,
  `omschrijving_nl` text NOT NULL,
  `omschrijving_en` text NOT NULL,
  `omschrijving_de` text NOT NULL,
  `omschrijving_es` text NOT NULL,
  `omschrijving_pl` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=256 ;

---

any screenshots?

Live demo: Pokemon-Area

I have it running at PokeAdventure
might not work 100% i was pissing around with it...

Quote:

---

Originally Posted by KiruHoshino

I found.

Code:

---

CREATE TABLE IF NOT EXISTS `markt` (
  `id` tinyint(4) unsigned NOT NULL AUTO_INCREMENT,
  `soort` varchar(16) NOT NULL,
  `beschikbaar` tinyint(1) NOT NULL DEFAULT '1',
  `pokemonid` smallint(3) NOT NULL DEFAULT '0',
  `naam` varchar(14) NOT NULL,
  `silver` smallint(5) unsigned NOT NULL,
  `gold` smallint(5) unsigned NOT NULL,
  `omschrijving_nl` text NOT NULL,
  `omschrijving_en` text NOT NULL,
  `omschrijving_de` text NOT NULL,
  `omschrijving_es` text NOT NULL,
  `omschrijving_pl` text NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=256 ;

---

---

I thin kthe auto_increment should be 243, not 256.
name is limited to 12, not 14
other than that, good job.

It would be great if you share with someone in a database on the website.

Unfortunately, I could not do it.

Code:

---

CREATE TABLE IF NOT EXISTS `ban` (
  `user_id` int(11) NOT NULL auto_increment,
  `ip` varchar(15) NOT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=256 ;

---

Not sure if it works.

Here's my deal, if you lot figure out the rest of the tables, this does nto include the ones for pokemon (wild , trainers, etc) i will give you the rest.
but here's the ban table:

Code:

---

CREATE TABLE IF NOT EXISTS `ban` (
  `user_id` int(11) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `tot` date NOT NULL,
  `reden` varchar(60) NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

Quote:

---

Originally Posted by DeathLord17

Here's my deal, if you lot figure out the rest of the tables, this does nto include the ones for pokemon (wild , trainers, etc) i will give you the rest.
but here's the ban table:

Code:

---

CREATE TABLE IF NOT EXISTS `ban` (
  `user_id` int(11) NOT NULL,
  `ip` varchar(15) NOT NULL,
  `tot` date NOT NULL,
  `reden` varchar(60) NOT NULL,
  PRIMARY KEY  (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

---

---

Once registered you would like to do. But so far is not working.
The character of the Island and tables should have done it anyway.

Quote:

---

CREATE TABLE IF NOT EXISTS `characters` (
`naam` varchar(32) NOT NULL,
PRIMARY KEY (`naam`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


INSERT INTO `characters` VALUES ('red');

---

Thanks for your help. :)

your missing the ID part of it,

Code:

---

CREATE TABLE IF NOT EXISTS `characters` (
  `id` tinyint(4) NOT NULL auto_increment,
  `naam` varchar(7) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=19 ;

INSERT INTO `characters` (`id`, `naam`) VALUES
(1, 'Red'),
(2, 'Leaf'),
(3, 'Ethan'),
(4, 'Lyra'),
(5, 'Brendan'),
(6, 'May'),
(7, 'Lucas'),
(8, 'Dawn'),
(9, 'Lunick'),
(10, 'Solana'),
(11, 'Ash'),
(12, 'Blue'),
(13, 'Brock'),
(14, 'Misty'),
(15, 'Tracey'),
(16, 'Max'),
(17, 'Paul'),
(18, 'J');

---

So on that basis I think the country is going. Thank you. A tremendous help.

No problem, what else would i be useful for :D
awaiting your further accomplishments of unraveling this source for it's database!