Anyone got the Pokemon-area.com files

[KiruHoshino]

I found.

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 ;

 

[Omnija]

any screenshots?

 

[KiruHoshino]

Live demo:

You must be registered to see links

 

[DeathLord17]

I have it running at

You must be registered to see links

might not work 100% i was pissing around with it...

I found.

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.

 

[KiruHoshino]

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

Unfortunately, I could not do it.

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.

 

[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:

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;

 

[KiruHoshino]

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:

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.

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.

 

[DeathLord17]

your missing the ID part of it,

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');

 

[KiruHoshino]

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

 

[DeathLord17]

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

 

[KiruHoshino]

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

INSERT INTO `landen` (`id`, `land`) VALUES
(1, 'Hungary');

Probably the problem is in the land but have not found it, that we should be there

or

"mysql_query("SELECT `en`, `nl` FROM `landen`")"

The id is not a number but abbreviations are replaced.

 

[DeathLord17]

Land doesn't exist.
remove
`land` varchar(14) NOT NULL,

It should be:
`country` tinyint(2) NOT NULL,

and country is a specific ID, plus you'll need a few more rows for that table.

 

[KiruHoshino]

Thanks for the advice. What I did do it I'll be an old man. XD Unfortunately, I am dumb to MySQL. In PHP I am more at home.
Can you give a hint?
Which php files are interested in the country?

register.php
account-options.php

Any more?

 

[DeathLord17]

Look at the webpage that has the list on it, it will have the order of the numbers there i believe, my last post for tonight. see ya in the morning!

 

[KiruHoshino]

Good Night dude.

 

[Masius]

Interesting. Didn't know this had been released.. I should check this section more often. Currently downloading the files, thanks for the tables you've provided DeathLord17. I'm going to check the source and do the rest..

 

[fitim]

Haha, If you release a source do it then good ;-) (duck: felixcruzer)
I'm the only one that knows how the source works, You can buy the source for 20$. Send my a message for it

@tomad, Die engelsen kunnen amper Nederlands dus laat ze maar praten

 

[KiruHoshino]

Nur weil du schreibst die Deutschen nicht bedeuten, dass wir nicht verstehen.

Just because you're writing the Germans did not mean that we do not understand.

 

[Masius]

Haha, If you release a source do it then good ;-) (duck: felixcruzer)
I'm the only one that knows how the source works, You can buy the source for 20$. Send my a message for it

@tomad, Die engelsen kunnen amper Nederlands dus laat ze maar praten

No idea what you're talking about but the downloads provided on the first page of the thread contain the source code.

 

[lcey]

The database isn't finished. I out all the tables in. It goes to a page and has a green background. It's all text and some of it's moving.