Printable View
Probably the problem is in the land but have not found it, that we should be thereCode: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');
or
"mysql_query("SELECT `en`, `nl` FROM `landen`")"
The id is not a number but abbreviations are replaced.
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.
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?
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!
Good Night dude. :)
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..
Haha, If you release a source do it then good ;-) (FUCK: 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 :D
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.
No idea what you're talking about but the downloads provided on the first page of the thread contain the source code.Quote:
Originally Posted by fitim
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.
Maar ik kan lezen en typen in een beetje Nederlands. Dus je argument is ongeldig.Quote:
Originally Posted by fitim
idk what the word for arguement is :( i think it's somethign like twistgesprak
@MrSunny
You're gonna need ALL of the pokemon, items and npc data xD
argument is argument in dutch :pQuote:
Originally Posted by DeathLord17
Someone is trying to have it?
I think it was not good. The table has been successfully created.Code:CREATE TABLE IF NOT EXISTS `laden`(
`country` tinyint(2) NOT NULL,
`nl` text NOT NULL,
`en` text NOT NULL,
PRIMARY KEY (`country`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I don't think that table is needed, isn't it supposed to be aanval?
I'm sorry. I give up. I can not do. I tried but without much success. Thank you for your help DeatLord17. Good luck to everyone.
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');
------
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;
------
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 ;
------
CREATE TABLE IF NOT EXISTS `aanval_log` (
`id` int(9) NOT NULL auto_increment,
`user_id` varchar(32) NOT NULL,
`gebied` varchar(32) NOT NULL,
`trainer` varchar(32) NOT NULL,
`laatste_aanval` varchar(32) NOT NULL,
`beurten` int(9) NOT NULL,
`tegenstanderid` varchar(16) NOT NULL,
`pokemonid` varchar(16) NOT NULL,
`gedaan` varchar(16) NOT NULL,
`aanval_bezig_speler` varchar(32) NOT NULL,
`aanval_bezig_computer` varchar(32) NOT NULL,
`schadeaantegenstander` int(9) NOT NULL,
`schadeaanspeler` int(9) NOT NULL,
`gebruikt_id` text NOT NULL,
`effect_speler` varchar(32) NOT NULL,
`effect_computer` varchar(32) NOT NULL,
`laatste_aanval_speler` varchar(32) NOT NULL,
`laatste_aanval_computer` varchar(32) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5478838 ;
------
CREATE TABLE IF NOT EXISTS `gebruikers` (
`user_id` int(11) NOT NULL auto_increment,
`aanmeld_datum` datetime NOT NULL,
`datum` datetime NOT NULL,
`account_code` mediumint(9) NOT NULL,
`username` varchar(10) NOT NULL,
`wachtwoord` varchar(32) NOT NULL,
`email` varchar(40) NOT NULL,
`ip_aangemeld` varchar(15) NOT NULL,
`ip_ingelogd` varchar(15) NOT NULL,
`premiumaccount` int(4) NOT NULL default '1',
`admin` tinyint(1) NOT NULL default '0',
`test` tinyint(2) NOT NULL,
`spec` tinyint(3) NOT NULL default '0',
`wereld` varchar(6) NOT NULL,
`silver` int(10) unsigned NOT NULL default '75',
`gold` int(10) unsigned NOT NULL default '0',
`bank` int(10) unsigned NOT NULL default '0',
`storten` tinyint(1) NOT NULL default '5',
`stelen` tinyint(1) NOT NULL default '3',
`races` tinyint(4) NOT NULL default '5',
`races_winst` int(11) NOT NULL default '0',
`races_verlies` int(11) NOT NULL default '0',
`werkervaring` int(10) NOT NULL,
`reclame` tinyint(1) NOT NULL default '0',
`online` varchar(10) NOT NULL,
`voornaam` varchar(12) NOT NULL,
`achternaam` varchar(12) NOT NULL,
`geb_datum` date NOT NULL,
`land` varchar(14) NOT NULL,
`character` varchar(7) NOT NULL,
`profiel` longtext NOT NULL,
`teamzien` tinyint(1) NOT NULL default '1',
`badgeszien` tinyint(1) NOT NULL default '0',
`dueluitnodiging` tinyint(1) NOT NULL default '1',
`buddy` text NOT NULL,
`blocklist` text NOT NULL,
`huis` varchar(5) NOT NULL default 'doos',
`geluksrad` tinyint(1) NOT NULL default '3',
`wiequiz` datetime NOT NULL,
`rank` tinyint(2) NOT NULL default '1',
`rankexp` int(9) unsigned NOT NULL default '0',
`rankexpnodig` int(9) NOT NULL default '245',
`soortwerk` tinyint(2) NOT NULL,
`werktijd` smallint(3) NOT NULL,
`werktijdbegin` datetime NOT NULL,
`pokecentertijd` smallint(3) NOT NULL,
`pokecentertijdbegin` datetime NOT NULL,
`gevangenistijd` smallint(3) NOT NULL,
`gevangenistijdbegin` datetime NOT NULL,
`captcha_time` int(11) NOT NULL,
`captcha_tevaak_fout` int(11) NOT NULL,
`aantalpokemon` int(9) unsigned NOT NULL,
`badges` tinyint(2) NOT NULL,
`pagina` varchar(20) NOT NULL,
`gewonnen` int(8) NOT NULL,
`verloren` int(8) NOT NULL,
`eigekregen` tinyint(1) NOT NULL default '0',
`lvl_choose` varchar(6) NOT NULL,
`pok_gezien` text NOT NULL,
`pok_bezit` text NOT NULL,
`pok_gehad` text NOT NULL,
PRIMARY KEY (`user_id`),
KEY `naam` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6693 ;