Title says it all.
I know they were leaked in this thread - http://forum.ragezone.com/f705/delete-889557/ 2 weeks ago, however they have been removed
Printable View
Title says it all.
I know they were leaked in this thread - http://forum.ragezone.com/f705/delete-889557/ 2 weeks ago, however they have been removed
Pokemon-Area.com.rar download - 2shared
I dont know how to use it or something...
Can not be used because it contains the database.
...
heres one table for you...
Have fun with it :DCode: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 ;
Thanks. :D Today is my birthday. Gift from the other table also. :D
Can someone release the database??
The database is 100% dutch, and is only use-able if you have some weird program that isn't very compatible and can be hard to actually get.
I'm 100% dutch too, so that can't be a problem. Maybe if someone gives me the database, I can translate it in English?
The Database for creating account, i'm not good on making SQL's queries, the table is fully working but not done .Code:CREATE TABLE IF NOT EXISTS `gebruikers` (
`account_code` int(9) NOT NULL,
`voornaam` varchar(32) NOT NULL,
`achternaam` varchar(32) NOT NULL,
`land` varchar(32) NOT NULL,
`character` varchar(32) NOT NULL,
`username` varchar(32) NOT NULL,
`geb_datum` varchar(32) NOT NULL,
`datum` varchar(32) NOT NULL,
`aanmeld_datum` varchar(32) NOT NULL,
`wachtwoord` varchar(32) NOT NULL,
`email` varchar(32) NOT NULL,
`ip_aangemeld` varchar(32) NOT NULL,
`wereld` varchar(32) NOT NULL,
);
Quote:
Originally Posted by Register.php
Not quite fully working, it won't work when using other stuff. But for your effort i'll give you the whole table:Quote:
Originally Posted by tanomist
Code: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 ;
Very nice job guys. :thumbup1: You guys are the best.
Any chance to upload some where else please? the link above wont allow me to downloadQuote:
Originally Posted by tomad
thanks :) anyone got the full sql so i can start translating it to englishQuote:
Originally Posted by tomad
Waiting for the full sql too...
Well, im waiting for others to release their attempts before i give it away.
Not a problem boss :ott1:Quote:
Originally Posted by DeathLord17
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...
I thin kthe auto_increment should be 243, not 256.Quote:
Originally Posted by KiruHoshino
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.
Not sure if it works.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 ;
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.Quote:
Originally Posted by DeathLord17
The character of the Island and tables should have done it anyway.
Thanks for your help. :)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');
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!
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 ;
Not a bad attempt, i shall reward you :D
Code:(1, 'Hypnosis', 0, 0, 0, 'Psychic', '0', '1', '60', 'Sleep', 1, '', 1, '', '', '', '', 'ja'),
(3, 'Lick', 20, 0, 0, 'Ghost', '3', '1', '5', 'Paralyzed', 1, '', 1, '', '', '', '', 'ja'),
(5, 'Tail Whip', 0, 0, 0, 'Normal', '0', '1', '100', 'Defence_down', 1, '', 1, '', '', '', '', 'ja'),
(6, 'Poison Sting', 15, 0, 0, 'Poison', '10', '1', '20', 'Poisoned', 1, '', 1, '', '', '', '', 'ja'),
(11, 'Defense Curl', 0, 0, 0, 'Normal', '0', '1', '100', 'Defence_up', 1, '', 1, '', '', '', 'Raises Defense up one stage. Damage from Rollout will increase. ', 'ja'),
(10, 'Tackle', 35, 0, 0, 'Normal', '5', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(12, 'Mud Sport', 0, 0, 0, 'Ground', '0', '1', '100', 'Electric_attacks', 1, '', 1, '', '', '', '', 'ja'),
(13, 'Low Kick', 40, 0, 0, 'Fighting', '5', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(14, 'Leer', 0, 0, 0, 'Normal', '0', '1', '100', 'Defence_down', 1, '', 1, '', '', '', '', 'ja'),
(15, 'Bubble', 20, 0, 0, 'Water', '5', '1', '5', 'Speed_down', 1, '', 1, '', '', '', 'May lower opponent''s Speed ability down one stage. ', 'ja'),
(17, 'Vice Grip', 55, 0, 0, 'Normal', '5', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(18, 'Solar Beam', 120, 0, 0, 'Grass', '0', '1', '0', '', 2, 'voor', 1, '', '', '', '', 'ja'),
(21, 'Absorb', 20, 0, 0, 'Grass', '3', '1', '0', '', 1, '', 1, 'half_attack_recover', '', '', 'User recovers half damage dealt. ', ''),
(22, 'Acid', 40, 0, 0, 'Poison', '3', '1', '50', 'Defence_down', 1, '', 1, '', '', '', 'May lower opponent''s Defense ability down one stage. ', 'ja'),
(23, 'Acid Armor', 0, 0, 0, 'Poison', '0', '1', '100', 'Defence_up', 1, '', 1, '', '', '', 'Raises user''s Defense ability up two stages. ', 'ja'),
(24, 'Aerial Ace', 60, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 1, 'lucht_grond_mis', '', '', 'If opponent is on screen, hits without fail. ', ''),
(25, 'Aeroblast', 100, 0, 1, 'Flying', '5', '1', '0', '', 1, '', 1, '', '', '', 'Has a high critical hit rate. ', 'ja'),
(26, 'Agility', 0, 0, 0, 'Psychic', '0', '1', '100', 'Speed_up', 1, '', 1, '', '', '', 'Raises user''s Speed ability up two stages. ', 'ja'),
(27, 'Air Cutter', 55, 0, 1, 'Flying', '5', '1', '0', '', 1, '', 1, '', '', '', 'Has a high critical hit rate. ', 'ja'),
(28, 'Amnesia', 0, 0, 0, 'Psychic', '0', '1', '100', 'Spc.defence_up', 1, '', 1, '', '', '', 'Raises user''s Special Defense ability up two stages. ', 'ja'),
(29, 'Ancientpower', 60, 0, 0, 'Rock', '3', '1', '55', 'All_up', 1, '', 1, '', '', '', 'May raise all of user''s abilities up one stage. ', 'ja'),
(30, 'Arm Thrust', 15, 0, 0, 'Fighting', '0', '2-5', '0', '', 1, '', 1, '', '', '', 'Attacks 2-5 times, Has a 37,5% chance each of hitting 2 or 3 times and a 12,5% chance each of hitting 4 or 5 times. ', 'ja'),
(31, 'Aromatherapy', 0, 0, 0, 'Grass', '0', '1', '0', '', 1, '', 1, 'all_status_recover', '', '', 'Party recovers from all status ailments. ', ''),
(32, 'Assist', 0, 0, 0, 'Normal', '3', '1', '0', '', 1, '', 1, '', 'random_attack_party', '', 'An Attack chosen in random from the other Pokemon in your team. ', ''),
(33, 'Astonish', 30, 0, 0, 'Ghost', '3', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause opponent to Flinch. ', 'ja'),
(34, 'Attract', 10, 0, 0, 'Normal', '3', '1', '0', '', 1, '', 1, '', '', '', 'Induces opponent with Attract condition. ', 'ja'),
(35, 'Aurora Beam', 65, 0, 0, 'Ice', '3', '1', '40', 'Defence_down', 1, '', 1, '', '', '', 'May lower opponent''s Attack ability down one stage. ', 'ja'),
(36, 'Barrage', 15, 0, 0, 'Normal', '15', '2-5', '0', '', 1, '', 1, '', '', '', 'Attacks 2-5 times. Has a 37.5% chance each of hitting 2 or 3 times and a 12.5% chance each of hitting 4 or 5 times. ', 'ja'),
(37, 'Barrier', 0, 0, 0, 'Psychic', '0', '1', '100', 'Defence_up', 1, '', 1, '', '', '', 'Raises user''s Defense ability up two stages. ', 'ja'),
(38, 'Baton Pass', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Allows you to switch Pokemon during battle, new Pokemon retains any stat changes the previous Pokemon had. \r\nINACTIEF!', ''),
(39, 'Beat Up', 10, 0, 0, 'Dark', '3', 'gezond_opzak', '0', '', 1, '', 1, '', '', '', 'Your Pokemon Attacks as many times as the number of Pokemon you are currently carrying, afflicted (Poison, Sleep, etc) Pokemon don''t count. ', 'ja'),
(40, 'Belly Drum', 0, 0, 0, 'Normal', '0', '1', '100', 'Attack_up2', 1, '', 1, '', '', '', 'Raises user''s Attack ability up very high, Will consume half of the user''s maximum HP is available. ', 'ja'),
(41, 'Bide', 0, 0, 0, 'Normal', '3', '1', '0', '', 2, '', 1, '', '', '', 'Withstands Attacks for 2, 3 turns, then deals back double the damage. ', 'ja'),
(42, 'Bind', 15, 0, 0, 'Normal', '25', '1', '0', '', 1, '', 1, '', '', '', '', ''),
(43, 'Bite', 60, 0, 0, 'Dark', '3', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause opponent to Flinch. ', 'ja'),
(44, 'Blast Burn', 150, 0, 0, 'Fire', '10', '1', '', '', 2, 'na', 1, '', '', '', 'Attacks in two turns, The second turn, user does not Attack. ', 'ja'),
(45, 'Blaze Kick', 85, 0, 1, 'Fire', '10', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May induce opponent with Burn status, Has a high critical hit ratio. ', 'ja'),
(46, 'Blizzard', 120, 0, 0, 'Ice', '30', '1', '10', 'Freeze', 1, '', 1, '', '', '', 'May induce opponent with Freeze status. ', 'ja'),
(47, 'Block', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Opponent cannot escape as long as user remains in battle. ', ''),
(48, 'Body Slam', 85, 0, 0, 'Normal', '0', '1', '5', 'Paralyzed', 1, '', 1, '', '', '', 'May induce opponent with Paralysis status. ', 'ja'),
(49, 'Bone Club', 65, 0, 0, 'Ground', '15', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause opponent to Flinch. ', 'ja'),
(50, 'Bone Rush', 25, 0, 0, 'Ground', '20', '2-5', '0', '', 1, '', 1, '', '', '', 'Attacks 2-5 times, Has a 37,5% chance each of hitting 2 or 3 times and a 12,5% chance each of hitting 4 or 5 times. ', 'ja'),
(51, 'Bonemerang', 50, 0, 0, 'Ground', '10', '2', '0', '', 1, '', 1, '', '', '', 'Attacks twice. ', 'ja'),
(52, 'Bounce', 85, 0, 0, 'Flying', '15', '1', '0', '', 2, 'voor', 1, '', '', '', 'Attacks in two turns. The first turn, user does not take damage. ', 'ja'),
(53, 'Brick Break', 75, 0, 0, 'Fighting', '3', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(55, 'Bubblebeam', 65, 0, 0, 'Water', '3', '1', '10', 'Speed_down', 1, '', 1, '', '', '', 'May lower opponent''s Speed ability down one stage. ', 'ja'),
(56, 'Bulk Up', 0, 0, 0, 'Fighting', '0', '1', '100', 'attack_defence_up', 1, '', 1, '', '', '', 'Raises user''s Attack and Defense abilities each up one stage. ', 'ja'),
(57, 'Bullet Seed', 10, 0, 0, 'Grass', '3', '2-5', '0', '', 1, '', 1, '', '', '', 'Attacks 2-5 times. Has a 37.5% chance each of hitting 2 or 3 times and a 12.5% chance each of hitting 4 or 5 times. ', 'ja'),
(58, 'Calm Mind', 0, 0, 0, 'Psychic', '0', '1', '100', 'spc_up', 1, '', 1, '', '', '', 'Raises user''s Special Attack and Special Defense abilities each up one stage. ', 'ja'),
(59, 'Camouflage', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, 'camouflage_1', '', '', 'Type changes based on surroundings. On and under water, changes to Water type. In caves and on rocks, changes to Rock type. Elsewhere, changes to Normal type. ', ''),
(60, 'Charge', 0, 0, 0, 'Electric', '0', '1', '0', '', 1, '', 1, '', '', '', 'Stores electricity to increase the power of the next electric Attack. ', ''),
(61, 'Charm', 0, 0, 0, 'Normal', '0', '1', '100', 'Defence_down_2', 1, '', 1, '', '', '', 'Lowers opponent''s Attack ability down two stages. ', 'ja'),
(62, 'Clamp', 35, 0, 0, 'Water', '25', '1', '0', '', 1, '', 1, '', '', '', '', ''),
(80, 'Destiny Bond', 0, 0, 0, 'Ghost', '0', '1', '0', '', 1, '', 1, '', '', '', 'If user is knocked out by opponent''s next move, then opponent is also knocked out. ', ''),
(81, 'Detect', 0, 0, 0, 'Fighting', '0', '1', '0', '', 1, '', 1, '', '', '', 'Takes no damage from opponent''s Attack. May fail if used more than once in a row. ', ''),
(82, 'Dig', 60, 0, 0, 'Ground', '3', '1', '0', '', 2, 'voor', 1, '', '', 'Alles', 'Attacks in two turns. The first turn, user does not take damage. ', 'ja'),
(83, 'Disable', 0, 0, 0, 'Normal', '45', '1', '0', '', 1, '', 1, '', '', '', '', ''),
(84, 'Dive', 60, 0, 0, 'Water', '3', '1', '0', '', 2, 'voor', 1, '', '', '', 'Attacks in two turns. The first turn, user does not take damage. ', 'ja'),
(85, 'Dizzy Punch', 70, 0, 0, 'Normal', '3', '1', '10', 'Confused', 1, '', 1, '', '', '', 'May induce opponent with Confusion condition. ', 'ja'),
(86, 'Doom Desire', 120, 0, 0, 'Steel', '15', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(87, 'Double Kick', 30, 0, 0, 'Fighting', '3', '2', '0', '', 1, '', 1, '', '', '', 'Attacks twice. ', 'ja'),
(105, 'Explosion', 170, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', '', ''),
(106, 'Extrasensory', 80, 0, 0, 'Psychic', '0', '1', '33', 'Flinch', 1, '', 1, '', '', '', 'May cause opponent to Flinch. ', 'ja'),
(107, 'Extremespeed', 80, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(108, 'Facade', 70, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Attack power is double if user is inflicted with Poison, Paralyze, or Burn. ', ''),
(109, 'Faint Attack', 60, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(110, 'Fake Out', 40, 0, 0, 'Normal', '0', '1', '33', 'Flinch', 1, '', 1, '', '', '', '', 'ja'),
(111, 'Fake Tears', 0, 0, 0, 'Dark', '0', '1', '100', 'Spc.defence_down_2', 1, '', 1, '', '', '', 'Lowers opponent''s Special Defense ability down two stages. ', 'ja'),
(112, 'False Swipe', 40, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Always leaves opponent with at least 1 HP.', ''),
(113, 'Featherdance', 0, 0, 0, 'Flying', '0', '1', '100', 'Attack_down_2', 1, '', 1, '', '', '', 'Lowers opponent''s Attack ability down two stages. ', 'ja'),
(114, 'Fire Blast', 120, 0, 0, 'Fire', '15', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May induce opponent with Burn status. ', 'ja'),
(115, 'Fire Punch', 75, 0, 0, 'Fire', '0', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May induce opponent with Burn status. ', 'ja'),
(116, 'Fire Spin', 15, 0, 0, 'Fire', '30', '2-5', '0', '', 1, '', 1, '', '', '', 'Traps opponent for 2-5 turns. Deals 1/16 HP of damage each turn. ', 'ja'),
(117, 'Fissure', 0, 0, 0, 'Ground', '70', '1', '0', '', 1, '', 1, '', '', '', 'Knocks out opponent in one hit. Accuracy increases by an amount equal to the difference between user and enemy''s experience levels, then divided by 128. ', ''),
(118, 'Flail', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'The less HP user has, the higher the Attack power. When HP is very low, Attack power is 200. When HP is highest, Attack power is 20. ', ''),
(119, 'Flame Wheel', 60, 0, 0, 'Fire', '0', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May induce opponent with Burn status. ', 'ja'),
(120, 'Flamethrower', 95, 0, 0, 'Fire', '0', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May induce opponent with Burn status. ', 'ja'),
(121, 'Flash', 0, 0, 0, 'Normal', '30', '1', '100', 'Hit_ratio_down', 1, '', 1, '', '', '', 'Lowers opponent''s Hit Ratio ability down one stage. ', 'ja'),
(122, 'Flatter', 0, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'Raises opponent''s Special Attack ability up two stages, then induces opponent with Confusion condition. ', ''),
(123, 'Fly', 70, 0, 0, 'Flying', '5', '1', '0', '', 2, 'voor', 1, '', '', '', 'Attacks in two turns. The first turn, user does not take damage. ', 'ja'),
(124, 'Focus Energy', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Increases user''s critical hit rate. ', ''),
(125, 'Focus Punch', 150, 0, 0, 'Fighting', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(126, 'Follow Me', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'User takes all hits from opponents'' Attacks. Best used in 2VS2 battles. ', ''),
(127, 'Foresight', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'After use, opponent''s raised evasion will be ignored. ', ''),
(128, 'Frenzy Plant', 150, 0, 0, 'Grass', '10', '1', '0', '', 2, 'na', 1, '', '', '', 'Attacks in two turns. The second turn, user does not Attack. ', 'ja'),
(129, 'Frustration', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Power is greater when Pokémon is not happy. ', ''),
(130, 'Fury Attack', 15, 0, 0, 'Normal', '15', '2-5', '0', '', 1, '', 1, '', '', '', 'Attacks 2-5 times. Has a 37.5% chance each of hitting 2 or 3 times and a 12.5% chance each of hitting 4 or 5 times. ', 'ja'),
(131, 'Fury Cutter', 10, 0, 0, 'Bug', '5', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(132, 'Fury Swipes', 18, 0, 0, 'Normal', '20', '2-5', '0', '', 1, '', 1, '', '', '', 'Attacks 2-5 times. Has a 37.5% chance each of hitting 2 or 3 times and a 12.5% chance each of hitting 4 or 5 times. ', 'ja'),
(133, 'Future Sight', 80, 0, 0, 'Psychic', '10', '2', '0', '', 1, '', 1, '', '', '', 'Attack hits 2 turns later. ', 'ja'),
(134, 'Giga Drain', 60, 0, 0, 'Grass', '0', '1', '0', '', 1, '', 1, 'half_attack_recover', '', '', 'User recovers half damage dealt. ', ''),
(135, 'Glare', 0, 0, 0, 'Normal', '25', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'Induces opponent with Paralysis status. ', 'ja'),
(136, 'Grasswhistle', 0, 0, 0, 'Grass', '45', '1', '10', 'Sleep', 1, '', 1, '', '', '', 'May induce opponent with Sleep status. ', 'ja'),
(137, 'Growl', 0, 0, 0, 'Normal', '0', '1', '100', 'Attack_down', 1, '', 1, '', '', '', 'Lowers opponent''s Attack ability down one stage. ', 'ja'),
(138, 'Growth', 0, 0, 0, 'Normal', '0', '1', '100', 'Spc.attack_up', 1, '', 1, '', '', '', 'Raises user''s Special Attack ability up one stage. ', 'ja'),
(139, 'Grudge', 0, 0, 0, 'Ghost', '0', '1', '0', '', 1, '', 1, '', '', '', 'If user is fainted by opponent''s next move, then that move''s PP drops to 0. ', ''),
(140, 'Guillotine', 0, 0, 0, 'Normal', '70', '1', '0', '', 1, '', 1, '', '', '', 'Knocks out opponent in one hit. Accuracy increases by an amount equal to the difference between user and enemy''s experience levels, then divided by 128. ', ''),
(141, 'Gust', 40, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 1, '', '', '', 'Forces opponent to switch. Also hits while opponent is using Fly. ', ''),
(142, 'Hail', 0, 0, 0, 'Ice', '0', '1', '0', '', 1, '', 1, '', '', '', 'Causes hailstorm for 5 turns. ', ''),
(143, 'Harden', 0, 0, 0, 'Normal', '0', '1', '100', 'Defence_up', 1, '', 1, '', '', '', 'Raises user''s Defense ability up one stage. ', 'ja'),
(144, 'Haze', 0, 0, 0, 'Ice', '0', '1', '0', '', 1, '', 1, '', '', '', 'Resets all ability stages. ', ''),
(145, 'Headbutt', 70, 0, 0, 'Normal', '0', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause opponent to Flinch. ', 'ja'),
(146, 'Heal Bell', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Party recovers from all status ailments. ', ''),
(147, 'Heat Wave', 100, 0, 0, 'Fire', '10', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May induce opponent with Burn status. ', 'ja'),
(148, 'Helping Hand', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'During a 2VS2 battle, the partner''s Attacks are 1.5x Attack power. Best used in 2VS2 battles. ', ''),
(149, 'Hi Jump Kick', 85, 0, 0, 'Fighting', '10', '1', '0', '', 1, '', 1, '', '', '', 'If Attack misses, user takes 1/8 HP of damage. ', ''),
(150, 'Hidden Power', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Power and type varies from Pokémon to Pokémon. ', ''),
(151, 'Horn Attack', 65, 0, 0, 'Normal', '3', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(152, 'Horn Drill', 0, 0, 0, 'Normal', '70', '1', '0', '', 1, '', 1, '', '', '', 'Knocks out opponent in one hit. Accuracy increases by an amount equal to the difference between user and enemy''s experience levels, then divided by 128. ', ''),
(153, 'Howl', 0, 0, 0, 'Normal', '0', '1', '100', 'Attack_up', 1, '', 1, '', '', '', 'Raises user''s Attack ability up one stage. ', 'ja'),
(154, 'Hydro Cannon', 150, 0, 0, 'Water', '10', '1', '0', '', 2, 'na', 1, '', '', '', 'Attacks in two turns. The second turn, user does not Attack. ', 'ja'),
(155, 'Hydro Pump', 120, 0, 0, 'Water', '20', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(156, 'Hyper Beam', 150, 0, 0, 'Normal', '10', '1', '0', '', 2, 'na', 1, '', '', '', 'Attacks in two turns. The second turn, user does not Attack. ', 'ja'),
(157, 'Hyper Fang', 80, 0, 0, 'Normal', '10', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause opponent to Flinch. ', 'ja'),
(158, 'Hyper Voice', 90, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(173, 'Leaf Blade', 70, 0, 1, 'Grass', '0', '1', '0', '', 1, '', 1, '', '', '', 'Has a high critical hit rate. ', 'ja'),
(174, 'Leech Life', 20, 0, 0, 'Bug', '0', '1', '0', '', 1, '', 1, 'half_attack_recover', '', '', 'User recovers half damage dealt. ', ''),
(175, 'Leech Seed', 0, 0, 0, 'Grass', '10', '1', '0', '', 1, '', 1, '', '', '', 'Absorbs a small amount of HP from the opponent every turn. ', ''),
(178, 'Light Screen', 0, 0, 0, 'Psychic', '100', '1', '0', '', 1, '', 1, '', '', '', 'Special type moves deal half damage to user for five turns. ', ''),
(179, 'Lock-On', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Ensures that user''s next Attack will hit without fail. ', ''),
(180, 'Lovely Kiss', 0, 0, 0, 'Normal', '25', '1', '10', 'Sleep', 1, '', 1, '', '', '', 'May induce opponent with Sleep status. ', 'ja'),
(181, 'Low Kick', 50, 0, 0, 'Fighting', '3', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'Power depends on the user''s weight. ', 'ja'),
(182, 'Luster Purge', 70, 0, 0, 'Psychic', '0', '1', '10', 'Spc.defence_down', 1, '', 1, '', '', '', 'May lower opponent''s Special Defense ability down one stage. ', 'ja'),
(183, 'Mach Punch', 40, 0, 0, 'Fighting', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(184, 'Magic Coat', 0, 0, 0, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', 'The effect of any Special move will rebound and return to opponent. ', ''),
(185, 'Magical Leaf', 60, 0, 0, 'Grass', '3', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(186, 'Magnitude', 0, 0, 0, 'Ground', '0', '1', '0', '', 1, '', 1, '', '', '', 'Attack power is randomly 10, 30, 50, 70, 90, 110, or 150, based on the magnitude of the Attack (4 through 20 respectively). ', ''),
(187, 'Mean Look', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Opponent cannot escape as long as user remains in battle. ', ''),
(188, 'Meditate', 0, 0, 0, 'Psychic', '0', '1', '100', 'Attack_up', 1, '', 1, '', '', '', 'Raises user''s Attack ability up one stage. ', 'ja'),
(189, 'Mega Drain', 40, 0, 0, 'Grass', '0', '1', '0', '', 1, '', 1, 'half_attack_recover', '', '', 'User recovers half damage dealt. ', ''),
(190, 'Mega Kick', 120, 0, 0, 'Normal', '25', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(191, 'Mega Punch', 80, 0, 0, 'Normal', '15', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(192, 'Megahorn', 120, 0, 0, 'Bug', '15', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(193, 'Memento', 0, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'User faints and opponent''s abilities lower. ', ''),
(194, 'Metal Claw', 50, 0, 0, 'Steel', '5', '1', '10', 'Attack_up', 1, '', 1, '', '', '', 'May raise user''s Attack ability up one stage. ', 'ja'),
(195, 'Metal Sound', 0, 0, 0, 'Steel', '15', '1', '100', 'Spc.defence_down_2', 1, '', 1, '', '', '', 'Lowers opponent''s Special Defense ability down two stages. ', 'ja'),
(196, 'Meteor Mash', 100, 0, 0, 'Steel', '15', '1', '10', 'Attack_up', 1, '', 1, '', '', '', 'May raise user''s Attack ability up one stage. ', 'ja'),
(197, 'Metronome', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Randomly uses almost any Attack. ', ''),
(198, 'Milk Drink', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'User recovers half maximum HP. ', ''),
(199, 'Mimic', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Copies move used by opponent. ', ''),
(200, 'Mind Reader', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Ensures that user''s next Attack will hit without fail. ', ''),
(201, 'Minimize', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Raises user''s Evasion ability up one stage. STOMP deals double damage to user as long as user remains in battle. ', ''),
(202, 'Mirror Coat', 0, 0, 0, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', 'If hit by a Special Attack, deals back double the damage. ', ''),
(203, 'Mirror Move', 0, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 1, '', '', '', 'Move is replaced by the last move used by opponent. ', ''),
(204, 'Mist', 0, 0, 0, 'Ice', '0', '1', '0', '', 1, '', 1, '', '', '', 'Prevents user''s abilities from being lowered. ', ''),
(205, 'Mist Ball', 70, 0, 0, 'Psychic', '0', '1', '10', 'Spc.attack_down', 1, '', 1, '', '', '', 'May lower opponent''s Special Attack ability down one stage. ', 'ja'),
(206, 'Moonlight', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Restores HP, amount restored is based on time, most effective during the night. ', ''),
(207, 'Morning Sun', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Restores HP, amount restored is based on time, most effective during the day time ', ''),
(208, 'Mud Shot', 55, 0, 0, 'Ground', '5', '1', '10', 'Speed_down', 1, '', 1, '', '', '', 'May lower opponent''s Speed ability down one stage. ', 'ja'),
(210, 'Muddy Water', 95, 0, 0, 'Water', '15', '1', '10', 'Hit_ratio_down', 1, '', 1, '', '', '', 'May lower opponent''s Hit Ratio ability down one stage. ', 'ja'),
(211, 'Mud-Slap', 20, 0, 0, 'Ground', '0', '1', '10', 'Hit_ratio_down', 1, '', 1, '', '', '', 'May lower opponent''s Hit Ratio ability down one stage. ', 'ja'),
(212, 'Nature Power', 0, 0, 0, 'Normal', '5', '1', '0', '', 1, '', 1, '', '', '', 'Move used depends on battle location. ', ''),
(213, 'Needle Arm', 60, 0, 0, 'Grass', '0', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause opponent to Flinch. ', 'ja'),
(214, 'Night Shade', 0, 0, 0, 'Ghost', '0', '1', '0', '', 1, '', 1, '', '', '', 'Deals HP of damage equal to user''s level. ', ''),
(215, 'Nightmare', 0, 0, 0, 'Ghost', '0', '1', '0', '', 1, '', 1, '', '', '', 'Inflicts 1/4 damage every turn. Only works if opponent is induced with Sleep condition. ', ''),
(264, 'Sacred Fire', 100, 0, 0, 'Fire', '5', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May induce opponent with Burn status. ', 'ja'),
(265, 'Safeguard', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Protects your Pokemon from Special effects like Paralysis and Sleep, this effect lasts temporary. ', ''),
(266, 'Sand Tomb', 15, 0, 0, 'Ground', '30', '2-5', '0', '', 1, '', 1, '', '', '', 'Traps opponent for 2-5 turns. Deals 1/16 HP of damage each turn. ', 'ja'),
(267, 'Sand-Attack', 0, 0, 0, 'Ground', '0', '1', '100', 'Hit_ratio_down', 1, '', 1, '', '', '', 'Lowers opponent''s Hit Ratio ability down one stage. ', 'ja'),
(268, 'Sandstorm', 0, 0, 0, 'Rock', '0', '1', '0', '', 1, '', 1, '', '', '', 'Causes sandstorm weather for five turns. ', ''),
(269, 'Scary Face', 0, 0, 0, 'Normal', '10', '1', '100', 'Speed_down_2', 1, '', 1, '', '', '', 'Lowers opponent''s Speed ability down two stages. ', 'ja'),
(270, 'Scratch', 40, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(271, 'Screech', 0, 0, 0, 'Normal', '15', '1', '100', 'Defence_down_2', 1, '', 1, '', '', '', 'Lowers opponent''s Defense ability down two stages. ', 'ja'),
(272, 'Secret Power', 70, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Effect depends on surroundings. In grass, effect is Poison. In tall grass, effect is Sleep. On the ocean, Attack lowers one stage. Underwater, Defense lowers one stage. In a pond, Speed lowers one stage. In sand, accuracy lowers one stage. In a cave, effect is Flinch. On rocks, effect is Confusion. Elsewhere, effect is Paralyze. ', ''),
(273, 'Seismic Toss', 0, 0, 0, 'Fighting', '0', '1', '0', '', 1, '', 1, '', '', '', 'Deals HP of damage equal to user''s level. ', ''),
(274, 'Selfdestruct', 200, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Attack deals double damage. User faints. ', ''),
(275, 'Shadow Ball', 80, 0, 0, 'Ghost', '0', '1', '10', 'Spc.defence_down', 1, '', 1, '', '', '', 'May lower opponent''s Special Defense ability down one stage. ', 'ja'),
(276, 'Shadow Punch', 60, 0, 0, 'Ghost', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(277, 'Sharpen', 0, 0, 0, 'Normal', '0', '1', '100', 'Attack_up', 1, '', 1, '', '', '', 'Raises user''s Attack ability up one stage. ', 'ja'),
(278, 'Sheer Cold', 0, 0, 0, 'Ice', '70', '1', '0', '', 1, '', 1, '', '', '', 'Knocks out opponent in one hit. Accuracy increases by an amount equal to the difference between user and enemy''s experience levels, then divided by 128. ', ''),
(279, 'Shock Wave', 60, 0, 0, 'Electric', '3', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(280, 'Signal Beam', 75, 0, 0, 'Bug', '0', '1', '10', 'Confused', 1, '', 1, '', '', '', 'May induce opponent with Confusion condition. ', 'ja'),
(281, 'Silver Wind', 60, 0, 0, 'Bug', '0', '1', '10', 'All_up', 1, '', 1, '', '', '', 'May raise all of user''s abilities up one stage. ', 'ja'),
(282, 'Sing', 0, 0, 0, 'Normal', '45', '1', '10', 'Sleep', 1, '', 1, '', '', '', 'May induce opponent with Sleep status. ', 'ja'),
(283, 'Sketch', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Permanently copies opponent''s last move. ', ''),
(284, 'Skill Swap', 0, 0, 0, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', 'Swap characteristics with opponent. ', ''),
(285, 'Skull Bash', 100, 0, 0, 'Normal', '0', '1', '0', '', 2, 'voor', 1, '', '', '', 'Attacks second turn. ', 'ja'),
(286, 'Sky Attack', 140, 0, 0, 'Flying', '10', '1', '10', 'Flinch', 2, 'voor', 1, '', '', '', 'Attacks in two turns. May cause opponent to Flinch. ', 'ja'),
(287, 'Sky Uppercut', 85, 0, 0, 'Fighting', '10', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(288, 'Slack Off', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Restores half of user''s maximum HP. ', ''),
(314, 'Strength', 80, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(315, 'String Shot', 0, 0, 0, 'Bug', '5', '1', '100', 'Speed_down', 1, '', 1, '', '', '', 'Lowers opponent''s Speed ability down one stage. ', 'ja'),
(316, 'Struggle', 50, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(317, 'Stun Spore', 0, 0, 0, 'Grass', '25', '1', '100', 'Paralyzed', 1, '', 1, '', '', '', 'Induces opponent with Paralysis status. ', 'ja'),
(318, 'Submission', 80, 0, 0, 'Fighting', '20', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(319, 'Substitute', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Uses 1/4 of the user''s HP to make a decoy. Decoy takes damage from opponent''s Attacks until it breaks. ', ''),
(320, 'Sunny Day', 0, 0, 0, 'Fire', '0', '1', '0', '', 1, '', 1, '', '', '', 'Causes "Clear Skies" weather for five turns. ', ''),
(340, 'Thrash', 90, 0, 0, 'Normal', '0', '1', '30', 'Confused', 1, '', 1, '', '', '', 'induces user with Confusion condition. ', 'ja'),
(341, 'Thunder', 120, 0, 0, 'Electric', '30', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May induce opponent with Paralysis. ', 'ja'),
(342, 'Thunder Wave', 0, 0, 0, 'Electric', '0', '1', '100', 'Paralyzed', 1, '', 1, '', '', '', 'Induces opponent with Paralysis status. ', 'ja'),
(343, 'Thunderbolt', 95, 0, 0, 'Electric', '0', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May induce opponent with Paralysis status. ', 'ja'),
(344, 'Thunderpunch', 75, 0, 0, 'Electric', '0', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May induce opponent with Paralysis status. ', 'ja'),
(345, 'Thundershock', 40, 0, 0, 'Electric', '0', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May induce opponent with Paralysis status. ', 'ja'),
(346, 'Tickle', 0, 0, 0, 'Normal', '0', '1', '100', 'Attack_defence_down', 1, '', 1, '', '', '', 'Lowers opponent''s Attack and Defense abilities each down one stage. ', 'ja'),
(347, 'Torment', 0, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'The same move cannot be used twice in a row. ', ''),
(348, 'Toxic', 0, 0, 0, 'Poison', '15', '1', '100', 'Poisoned', 1, '', 1, '', '', '', 'Induces opponent with TOXIC status. ', 'ja'),
(349, 'Transform', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'User''s abilities (except for HP) become that of opponent. User''s ability changes and status inducement also become that of opponent. Users moves become those of opponent, but only have 5 PP each. ', ''),
(350, 'Tri Attack', 80, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'May induce opponent with either Burn, Freeze, or Paralysis. ', ''),
(351, 'Trick', 0, 0, 0, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', 'User and opponent exchange held items. ', ''),
(352, 'Triple Kick', 10, 0, 0, 'Fighting', '10', '1-3', '0', '', 1, '', 1, '', '', '', 'Attacks 1 to 3 times. ', 'ja'),
(353, 'Twineedle', 25, 0, 0, 'Bug', '0', '2', '10', 'Poisoned', 1, '', 1, '', '', '', 'Attacks 2 times. May induce opponent with Poison condition. ', 'ja'),
(354, 'Twister', 40, 0, 0, 'Dragon', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(355, 'Uproar', 50, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', ' ', 'ja'),
(357, 'Vine Whip', 35, 0, 0, 'Grass', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(358, 'Vital Throw', 70, 0, 0, 'Fighting', '0', '1', '0', '', 1, '', 1, '', '', '', 'Hits opponent without fail. Always goes last. ', 'ja'),
(359, 'Volt Tackle', 120, 0, 0, 'Electric', '0', '1', '0', '', 1, '', 33, '', '', '', 'User is dealt recoil damage equal to 1/3 damage dealt to opponent. ', 'ja'),
(360, 'Water Gun', 40, 0, 0, 'Water', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(361, 'Water Pulse', 60, 0, 0, 'Water', '0', '1', '10', 'Confused', 1, '', 1, '', '', '', 'May induce opponent with Confusion condition. ', 'ja'),
(362, 'Water Sport', 0, 0, 0, 'Water', '0', '1', '0', '', 1, '', 1, '', '', '', 'As long as user remains in battle, Fire type moves deal less damage to user and opponent. ', ''),
(363, 'Water Spout', 150, 0, 0, 'Water', '0', '1', '0', '', 1, '', 1, '', '', '', 'Power decreases as user''s HP lowers. ', ''),
(364, 'Waterfall', 80, 0, 0, 'Water', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(365, 'Weather Ball', 50, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(366, 'Whirlpool', 15, 0, 0, 'Water', '30', '2-5', '0', '', 1, '', 1, '', '', '', 'Traps opponent for 2-5 turns. Deals 1/16 HP of damage each turn. ', 'ja'),
(367, 'Whirlwind', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Escape from a wild battle. Switch opponent''s Pokémon in a link battle. ', ''),
(368, 'Will-O-Wisp', 0, 0, 0, 'Fire', '25', '1', '100', 'Burn', 1, '', 1, '', '', '', 'Induces opponent with Burn status. ', 'ja'),
(369, 'Wing Attack', 60, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 1, '', '', '', 'No special effect. ', 'ja'),
(370, 'Wish', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Half maximum HP is recovered at the end of the next turn. Still recovers, even if user switches. ', '');
INSERT INTO `aanval` (`id`, `naam`, `sterkte`, `hp_schade`, `critical`, `soort`, `mis`, `aantalkeer`, `effect_kans`, `effect_naam`, `stappen`, `laden`, `recoil`, `extra`, `andereaanval`, `ontwijk`, `commentaar`, `klaar`) VALUES
(371, 'Withdraw', 0, 0, 0, 'Water', '0', '1', '100', 'Defence_up', 1, '', 1, '', '', '', 'Raises user''s Defense ability up one stage. ', 'ja'),
(372, 'Wrap', 15, 0, 0, 'Normal', '15', '2-5', '0', '', 1, '', 1, '', '', '', 'Traps opponent for 2-5 turns. Deals 1/16 HP of damage each turn. ', 'ja'),
(373, 'Yawn', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'If the opponent remains in battle, it will be induced with Sleep on the following turn. ', ''),
(374, 'Zap Cannon', 100, 0, 0, 'Electric', '50', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May induce opponent with Paralysis status. ', 'ja'),
(376, 'Acupressure ', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Randomly raises one of the user''s stats by two stages. ', ''),
(377, 'Air Slash ', 75, 0, 0, 'Flying', '5', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause flinching. ', 'ja'),
(378, 'Aqua Jet ', 40, 0, 0, 'Water', '0', '1', '0', '', 1, '', 1, '', '', '', 'User goes first. ', 'ja'),
(379, 'Aqua Ring ', 0, 0, 0, 'Water', '0', '1', '0', '', 1, '', 1, '', '', '', 'Restores a little HP each turn. ', ''),
(380, 'Aqua Tail ', 90, 0, 0, 'Water', '10', '1', '0', '', 1, '', 1, '', '', '', ' ', 'ja'),
(381, 'Assurance ', 50, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(382, 'Attack Order', 90, 0, 1, 'Bug', '0', '1', '0', '', 1, '', 1, '', '', '', 'High Critical-Hit ratio. ', 'ja'),
(383, 'Aura Sphere ', 90, 0, 0, 'Fighting', '2', '1', '0', '', 1, '', 1, '', '', '', 'Cannot miss, regardless of Accuracy or Evasiveness. ', 'ja'),
(384, 'Avalanche ', 60, 0, 0, 'Ice', '0', '1', '0', '', 1, '', 1, '', '', '', 'Power doubles if user took damage first. ', 'ja'),
(385, 'Brave Bird ', 120, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 33, '', '', '', 'User receives recoil damage. ', 'ja'),
(386, 'Brine ', 65, 0, 0, 'Water', '0', '1', '0', '', 1, '', 1, '', '', '', 'Power doubles if opponent''s HP is less than 50%. ', ''),
(387, 'Bug Bite ', 60, 0, 0, 'Bug', '0', '1', '0', '', 1, '', 1, '', '', '', 'Receives the effect from the opponent''s held berry. ', 'ja'),
(388, 'Bug Buzz ', 90, 0, 0, 'Bug', '0', '1', '10', 'Spc.defence_down', 1, '', 1, '', '', '', 'May lower opponent''s Special Defense by one stage. ', 'ja'),
(389, 'Bullet Punch', 40, 0, 0, 'Steel', '0', '1', '0', '', 1, '', 1, '', '', '', 'User goes first. ', 'ja'),
(391, 'Charge Beam ', 50, 0, 0, 'Electric', '10', '1', '10', 'Spc.attack_down', 1, '', 1, '', '', '', 'Likely to lower opponent''s Special Attack by one stage. ', 'ja'),
(392, 'Chatter ', 60, 0, 0, 'Flying', '0', '1', '10', 'Confused', 1, '', 1, '', '', '', 'Likely to confuse the opponent. ', 'ja'),
(393, 'Close Combat', 120, 0, 0, 'Fighting', '0', '1', '100', 'defence_spc.defence_up', 1, '', 1, '', '', '', 'Decreases user''s Defense and Special Defense by one stage. ', 'ja'),
(394, 'Copycat ', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Copies opponent''s last move. ', ''),
(395, 'Cross Poison', 70, 0, 1, 'Poison', '0', '1', '10', 'Poisoned', 1, '', 1, '', '', '', 'Likely to land a Critical Hit, may poison opponent. ', 'ja'),
(396, 'Crush Grip ', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Attack power depends on opponent''s remaining HP. ', ''),
(397, 'Dark Pulse ', 80, 0, 0, 'Dark', '0', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause flinching. ', 'ja'),
(398, 'Dark Void ', 0, 0, 0, 'Dark', '20', '1', '100', 'Sleep', 1, '', 1, '', '', '', 'Puts all Pokemon on the field to sleep. ', 'ja'),
(399, 'Defend Order', 0, 0, 0, 'Bug', '0', '1', '100', 'defence_spc.defence_up', 1, '', 1, '', '', '', 'Increases user''s Defense and Special Defense by one stage each. ', 'ja'),
(400, 'Defog ', 0, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 1, '', '', '', 'Lowers opponent''s Evasiveness by one stage. ', ''),
(401, 'Discharge ', 80, 0, 0, 'Electric', '0', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May cause paralysis. ', 'ja'),
(402, 'Double Hit ', 35, 0, 0, 'Normal', '10', '2', '0', '', 1, '', 1, '', '', '', 'Hits twice. ', 'ja'),
(403, 'Draco Meteor', 140, 0, 0, 'Dragon', '10', '1', '100', 'Spc.attack_down_2', 1, '', 1, '', '', '', 'Decreases user''s Special Attack by 2 stages. ', 'ja'),
(404, 'Dragon Pulse', 90, 0, 0, 'Dragon', '0', '1', '0', '', 1, '', 1, '', '', '', ' ', 'ja'),
(405, 'Dragon Rush ', 100, 0, 0, 'Dragon', '25', '1', '30', 'Flinch', 1, '', 1, '', '', '', 'May cause flinching. ', 'ja'),
(406, 'Drain Punch ', 60, 0, 0, 'Fighting', '0', '1', '0', '', 1, '', 1, 'half_attack_recover', '', '', 'User recovers half of the damage inflicted on opponent. ', ''),
(407, 'Earth Power ', 90, 0, 0, 'Ground', '0', '1', '10', 'Spc.defence_down', 1, '', 1, '', '', '', 'May decrease opponent''s Special Defense by on stage. ', 'ja'),
(408, 'Embargo ', 0, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'Opponent cannot use hold items. ', ''),
(409, 'Energy Ball ', 80, 0, 0, 'grass ', '0', '1', '10', 'Spc.defence_down', 1, '', 1, '', '', '', 'May decrease opponent''s Special Defense by one stage. ', 'ja'),
(410, 'Feint ', 50, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(411, 'Fire Fang ', 65, 0, 0, 'Fire', '5', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May cause a burn or flinching. ', 'ja'),
(412, 'Flare Blitz ', 120, 0, 0, 'Fire', '0', '1', '0', '', 1, '', 33, '', '', '', 'User receives recoil damage. ', 'ja'),
(413, 'Flash Cannon', 80, 0, 0, 'Steel', '0', '1', '10', 'Spc.attack_down', 1, '', 1, '', '', '', 'May decrease opponent''s Sp. Attack or Sp. Defense by one stage. ', 'ja'),
(414, 'Fling ', 0, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'Power depends on held item. ', ''),
(415, 'Focus Blast ', 120, 0, 0, 'Fighting', '30', '1', '10', 'Spc.defence_down', 1, '', 1, '', '', '', 'May decrease opponent''s Special Defense by one stage. ', 'ja'),
(416, 'Force Palm ', 60, 0, 0, 'Fighting', '0', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May cause paralysis. ', 'ja'),
(417, 'Gastro Acid ', 0, 0, 0, 'Poison', '0', '1', '0', '', 1, '', 1, '', '', '', 'Cancels out the effect of the opponent''s Ability. ', ''),
(418, 'Giga Impact ', 150, 0, 0, 'Normal', '10', '1', '0', '', 2, 'na', 1, '', '', '', 'User cannot move in the following turn. ', 'ja'),
(419, 'Grass Knot ', 0, 0, 0, 'grass ', '0', '1', '0', '', 1, '', 1, '', '', '', 'The heavier the opponent, the stronger the attack. ', ''),
(420, 'Gravity ', 0, 0, 0, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', 'Prevents moves like Fly and Bounce and the Ability Levitate for 5 turns. ', ''),
(435, 'Lava Plume ', 80, 0, 0, 'Fire', '0', '1', '10', 'Burn', 1, '', 1, '', '', '', 'May cause a burn. ', 'ja'),
(436, 'Leaf Storm ', 140, 0, 0, 'Grass', '10', '1', '100', 'Spc.attack_down_2', 1, '', 1, '', '', '', 'Decreases user''s Special Attack by two stages. ', 'ja'),
(437, 'Lucky Chant ', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'Opponent cannot land Critical Hits for 5 turns. ', ''),
(438, 'Lunar Dance ', 0, 0, 0, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', 'The user faints but the next Pokemon released is fully healed. ', ''),
(439, 'Magma Storm ', 120, 0, 0, 'Fire', '30', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(440, 'Magnet Bomb ', 60, 0, 0, 'steel ', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(441, 'Magnet Rise ', 0, 0, 0, 'Steel', '0', '1', '0', '', 1, '', 1, '', '', '', 'Changes user''s Ability to Levitate. ', ''),
(442, 'Me First ', 0, 0, 0, 'Normal', '0', '1', '0', '', 1, '', 1, '', '', '', 'User goes first with the opponent''s attack at 1.5x power. ', ''),
(443, 'Metal Burst ', 0, 0, 0, 'Steel', '0', '1', '0', '', 1, '', 1, '', '', '', 'Deals opponent damage equal to its last attack x 2. ', ''),
(458, 'Psycho Cut ', 70, 0, 0, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', 'High Critical-Hit ratio. ', 'ja'),
(459, 'Psycho Shift', 0, 0, 0, 'Psychic', '10', '1', '0', '', 1, '', 1, '', '', '', 'Gives the opponent the user''s status condition, if it hits. ', ''),
(460, 'Punishment ', 0, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'Power depends on opponent''s stats. ', ''),
(461, 'Roar of Time', 150, 0, 0, 'Dragon', '10', '1', '0', '', 2, 'na', 1, '', '', '', 'The user cannot move in the following turn. ', 'ja'),
(462, 'Rock Climb ', 90, 0, 0, 'Normal', '15', '1', '10', 'Confused', 1, '', 1, '', '', '', 'May cause confusion. ', 'ja'),
(463, 'Rock Polish ', 0, 0, 0, 'Rock', '0', '1', '100', 'Speed_up_2', 1, '', 1, '', '', '', 'Increases the user''s Speed by two stages. ', 'ja'),
(464, 'Rock Wrecker', 150, 0, 0, 'Rock', '10', '1', '0', '', 2, 'na', 1, '', '', '', 'The user cannot move in the following turn. ', 'ja'),
(465, 'Roost ', 0, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 1, '', '', '', 'User recovers 50% of its max HP. Flying-type users are not immune to Ground-type moves immediately following this move. ', ''),
(466, 'Seed Bomb ', 80, 0, 0, 'Grass', '0', '1', '0', '', 1, '', 1, '', '', '', ' ', 'ja'),
(467, 'Seed Flare ', 120, 0, 0, 'Grass', '15', '1', '10', 'Spc.defence_down', 1, '', 1, '', '', '', 'May decrease the opponent''s Special Defense by one stage. ', 'ja'),
(468, 'Shadow Claw ', 70, 0, 0, 'Ghost', '0', '1', '0', '', 1, '', 1, '', '', '', 'High Critical-Hit ratio. ', 'ja'),
(469, 'Shadow Force', 120, 0, 0, 'Ghost', '0', '1', '0', '', 2, 'voor', 1, '', '', '', 'Disappears on the 1st turn, attacks on the 2nd turn. ', 'ja'),
(470, 'Shadow Sneak', 40, 0, 0, 'Ghost ', '3', '1', '0', '', 1, '', 1, '', '', '', 'User goes first. ', 'ja'),
(471, 'Spacial Rend', 100, 0, 1, 'Dragon', '5', '1', '0', '', 1, '', 1, '', '', '', 'High Critical-Hit ratio. ', 'ja'),
(472, 'Stealth Rock', 0, 0, 0, 'Rock', '0', '1', '0', '', 1, '', 1, '', '', '', 'Damages opponent when they switch into battle. ', ''),
(473, 'Stone Edge ', 100, 0, 0, 'Rock', '20', '1', '0', '', 1, '', 1, '', '', '', 'High Critical-Hit ratio. ', 'ja'),
(474, 'Sucker Punch', 80, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'User goes first, but won''t work if opponent doesn''t use an attacking move. ', 'ja'),
(475, 'Switcheroo ', 0, 0, 0, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', 'Swaps held items with the opponent. ', ''),
(476, 'Tailwind', 0, 0, 0, 'Flying', '0', '1', '0', '', 1, '', 1, '', '', '', 'The user''s party''s Speed is increased by one stage for 5 turns. ', ''),
(477, 'Thunder Fang', 65, 0, 0, 'Electric', '5', '1', '10', 'Paralyzed', 1, '', 1, '', '', '', 'May cause paralysis and flinching. ', 'ja'),
(509, 'Boiling Water', 80, 0, 0, 'Water', '0', '1', '10', 'Burn', 0, '', 1, '', '', '', '', 'ja'),
(510, 'Bug Repellant', 30, 0, 0, 'Bug', '0', '1', '100', 'Spc.attack_down', 0, '', 1, '', '', '', '', 'ja'),
(511, 'Butterfly Dance', 0, 0, 0, 'Bug', '0', '1', '100', 'Spc_all_speed_up', 0, '', 1, '', '', '', '', 'ja'),
(512, 'Cheer Up', 0, 0, 0, 'Normal', '0', '1', '100', 'Attack_spc.attack_up', 0, '', 1, '', '', '', '', 'ja'),
(513, 'Claw Sharpen', 0, 0, 0, 'Dark', '0', '1', '100', 'Hit_ratio_down', 0, '', 1, '', '', '', '', 'ja'),
(534, 'Gear Saucer', 50, 0, 0, 'Steel', '15', '2', '', '', 0, '', 1, '', '', '', '', 'ja'),
(535, 'Gift Pass', 0, 0, 0, 'Normal', '100', '1', '', '', 0, '', 1, '', '', '', 'The user transfers its held item to the target, which can be either an ally or an opponent. \r\n\r\nIt will always fail if the user has no held item or is holding Mail. It also fails if the target already has a held item or is behind a Substitute. Gift Pass cannot be used to give Giratina a Griseous Orb or Arceus a plate. \r\n\r\n', ''),
(536, 'Grass Mixer', 65, 0, 0, 'Grass', '10', '1', '30', 'Hit_ratio_down', 0, '', 1, '', '', '', '', 'ja'),
(537, 'Grass Oath', 50, 0, 0, 'Grass', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(538, 'Guard Share', 0, 0, 0, 'Psychic', '100', '1', '', '', 0, '', 1, '', '', '', 'Guard Share averages the user''s Defense and Special Defense stats with those of the target Pokémon. Guard Share will ignore both the user and the target''s stat changes when calculating the average. \r\n\r\n', ''),
(539, 'Hard Roller', 65, 0, 0, 'Bug', '0', '1', '30', 'Flinch', 0, '', 1, '', '', '', '', 'ja'),
(540, 'Healing Beam', 0, 0, 0, 'Psychic', '100', '1', '', '', 0, '', 1, '', '', '', 'Restores half the target''s max HP', ''),
(541, 'Heart Stamp', 60, 0, 0, 'Psychic', '0', '1', '30', 'Flinch', 0, '', 1, '', '', '', '', 'ja'),
(542, 'Heat Stamp', 80, 0, 0, 'Fire', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(543, 'Heavy Bomber', 80, 0, 0, 'Steel', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(544, 'Hurricane', 120, 0, 0, 'Flying', '30', '1', '10', 'Confused', 0, '', 1, '', '', '', '', 'ja'),
(545, 'Ice Breath', 40, 0, 0, 'Ice', '10', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(546, 'Icicle Drop', 85, 0, 0, 'Ice', '10', '1', '30', 'Flinch', 0, '', 1, '', '', '', '', 'ja'),
(547, 'Incinerate', 30, 0, 0, 'Fire', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(548, 'Knock Down', 50, 0, 0, 'Rock', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(549, 'Level Field', 60, 0, 0, 'Ground', '0', '1', '10', 'Speed_down', 0, '', 1, '', '', '', '', 'ja'),
(550, 'Life Gamble', 0, 0, 0, 'Fighting', '0', '1', '', '', 0, '', 1, '', '', '', 'Inflicts damage equal to the user''s remaining HP. User faints', ''),
(551, 'Lightning Strike', 130, 0, 0, 'Electric', '15', '1', '20', 'Paralyzed', 0, '', 1, '', '', '', '', 'ja'),
(552, 'Little By Little', 70, 0, 0, 'Normal', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(553, 'Magic Room', 0, 0, 0, 'Psychic', '100', '1', '', '', 0, '', 1, '', '', '', '', ''),
(554, 'Mirror Type', 0, 0, 0, 'Normal', '0', '1', '', '', 0, '', 1, '', '', '', 'User becomes the target''s type.', ''),
(555, 'Mountain Storm', 40, 0, 0, 'Fighting', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(556, 'Mystery Sword', 85, 0, 0, 'Fighting', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(557, 'Night Burst', 85, 0, 0, 'Dark', '5', '1', '10', 'Hit_ratio_down', 0, '', 1, '', '', '', '', 'ja'),
(558, 'Nitro Charge', 50, 0, 0, 'Fire', '0', '1', '100', 'Speed_up', 0, '', 1, '', '', '', '', 'ja'),
(559, 'Overhead Throw', 60, 0, 0, 'Fighting', '10', '1', '', '', 0, '', 1, '', '', '', 'In battles, the opponent switches. In the wild, the Pokemon runs.', ''),
(560, 'Postpone', 0, 0, 0, 'Dark', '0', '1', '', '', 0, '', 1, '', '', '', 'Makes the target act last this turn', ''),
(561, 'Powder Rage', 0, 0, 0, 'Bug', '100', '1', '', '', 0, '', 1, '', '', '', 'Redirects the target''s single-target effects to the user.', ''),
(562, 'Power Share', 0, 0, 0, 'Psychic', '100', '1', '', '', 0, '', 1, '', '', '', 'Averages Attack and Special Attack with the target.', ''),
(563, 'Psycho Break', 100, 0, 0, 'Psychic', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(564, 'Psycho Shock', 80, 0, 0, 'Psychic', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(565, 'Purgatory', 100, 0, 0, 'Fire', '50', '1', '10', 'Burn', 0, '', 1, '', '', '', '', 'ja'),
(566, 'Sacred Sword', 90, 0, 0, 'Fighting', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(567, 'Shell Blade', 75, 0, 0, 'Water', '5', '1', '50', 'Defence_down', 0, '', 1, '', '', '', '', 'ja'),
(568, 'Shell Smash', 0, 0, 0, 'Normal', '0', '1', '100', 'Speed_up', 0, '', 1, '', '', '', '', 'ja'),
(569, 'Side Change', 0, 0, 0, 'Psychic', '100', '1', '', '', 0, '', 1, '', '', '', 'User switches places with a random teammate', ''),
(584, 'Water Oath', 50, 0, 0, 'Water', '0', '1', '', '', 0, '', 1, '', '', '', '', 'ja'),
(585, 'Wide Guard', 0, 0, 0, 'Rock', '100', '1', '', '', 0, '', 1, '', '', '', 'Protects the user''s teammates from attacks for one turn.', ''),
(586, 'Wild Bolt', 90, 0, 0, 'Electric', '0', '1', '0', '', 0, '', 33, '', '', '', '', 'ja'),
(587, 'Wonder Room', 0, 0, 0, 'Psychic', '100', '1', '', '', 0, '', 1, '', '', '', 'Swaps every Pokemon''s Defense and Special Defense for 5 turns.', ''),
(588, 'Wood Horn', 75, 0, 0, 'Grass', '0', '1', '', '', 0, '', 1, 'half_attack_recover', '', '', '', ''),
(589, 'You First', 0, 0, 0, 'Normal', '0', '1', '', '', 0, '', 1, '', '', '', 'Tegenstander mag als eerste aanvallen.', ''),
(590, 'Copycat', 0, 0, 0, 'Normal', '0', '1', '', '', 0, '', 1, '', '', '', 'Kopieert aanval van de tegenstander.', ''),
(591, 'Night Slash', 70, 0, 1, 'Dark', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(592, 'Stone Edge', 100, 0, 1, 'Rock', '20', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(593, 'Shadow Claw', 70, 0, 1, 'Ghost', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja'),
(594, 'Psycho Cut', 70, 0, 1, 'Psychic', '0', '1', '0', '', 1, '', 1, '', '', '', '', 'ja');
Can you give details of the Land of the database table? Just what is missing for successful registration. Eternal gratitude will be prosecuted. :)
If the registration fails then on the other job I can see it.
Code:CREATE TABLE IF NOT EXISTS `aanval` (
`id` tinyint(4) NOT NULL auto_increment,
`naam` varchar(14) NOT NULL,
`sterkte` tinyint(3) NOT NULL,
`hp_schade` tinyint(3) NOT NULL,
`critical` tinyint(3) NOT NULL,
`soort` varchar(14) NOT NULL,
`mis` tinyint(3) NOT NULL,
`aantalkeer` tinyint(3) NOT NULL,
`effect_kans` tinyint(3) NOT NULL,
`effect_naam` varchar(14) NOT NULL,
`stappen` tinyint(3) NOT NULL,
`laden` varchar(14) NOT NULL,
`recoil` tinyint(3) NOT NULL,
`extra` varchar(14) NOT NULL,
`andereaanval` varchar(14) NOT NULL,
`ontwijk` varchar(14) NOT NULL,
`commentaar` text NOT NULL,
`klaar` varchar(2) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
I'll tell you the errors you have in that table:Quote:
Originally Posted by KiruHoshino
id is not tinyint(4), wrong data type and size
naam is wrong size
sterkte is wrong data type and size
hp_scahde is wrong data type and size
soort is wrong size
mis is wrong type (completely), and wrong size
all tinyints are either wrong size and/or wrong data type.
and wrong lengths on all varchars
I'm sorry, I'm stupid for that. I can not stop. But I still deserves a try.
Well it can be hard to get all of the sizes correct, but generally the ints and varchars can be seen by the code that is being used by them.
good?Code:CREATE TABLE IF NOT EXISTS `aanval` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`naam` varchar(16) NOT NULL,
`sterkte` smallint(5) NOT NULL,
`hp_schade` int(9) NOT NULL,
`critical` tinyint(2) NOT NULL DEFAULT '0',
`soort` varchar(32) NOT NULL,
`mis` varchar(16) NOT NULL,
`aantalkeer` varchar(32) NOT NULL DEFAULT '1',
`effect_kans` varchar(16) NOT NULL,
`effect_naam` varchar(32) NOT NULL,
`stappen` int(9) NOT NULL,
`laden` varchar(4) NOT NULL,
`recoil` int(9) NOT NULL DEFAULT '1',
`extra` varchar(32) NOT NULL,
`andereaanval` varchar(32) NOT NULL,
`ontwijk` mediumtext NOT NULL,
`commentaar` text NOT NULL,
`klaar` varchar(3) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=611 ;
100% correct.Quote:
Originally Posted by KiruHoshino
What could be the problem?
Attachment 118576
When you log into the login box, it's like if I was not logged. And anything I click on the website bans.
Because you need all the databases (bar the pokemon and npcs) for the main body to work.
Which files need to set the permissions?
I don't know exactly. I can't really tell you since most files use most database tables.
I do not want to work with the combat system.
"You don't have the permission to see this directory." - This is required if you want to learn in an attack
777 permission may be a problem.
I think you should still have a few folders.
i think you need 775 permissions
We just need to figure out what files and folders need to change the chmod values.
On my site, all files are the correct permissions i think.
Ok, well since it's been a week since my last post (i want the forums to show of this new post, rather than edit and noone see this)
And you lot have tried hard to get it all working, and done very good so far, i give you the full database.:
filehosting.org - download page for database.txt
yes it's a .txt, it doesn't matter.
if you need it on a differen't link, say the host you want and i'll upload it there
Thank you very much.
Attachment 119353
I have to share a bit of embellishment to the game.
Download the files to the game folder and overwrite.
Open for editing the index.php.
Find the following line:
Paste this below and save it:Code:<span class="cloud-02"></span>
I hope everyone likes. :)Code:<span class="cloud-03"></span>
I get 300 errors when I load in the database :S
I had no fault. The permissions problem.
Is the database supposed to have no problems?
I think I might just be putting it in wrong some how.
PhpMyAdmin I imported without any problems
I was using NaviCat. I'll try phpmyadmin. I'll tell you how it goes.
Edit:
Warning: POST Content-Length of 32989158 bytes exceeds the limit of 8388608 bytes in Unknown on line 0
You probably tried to upload too large file. Please refer to documentation for ways to workaround this limit.
Connection for controluser as defined in your configuration failed.
Connection for controluser as defined in your configuration failed.
Import the .txt file then instead of just copying the sql data into the manual sql submissionQuote:
Originally Posted by MrSunny
Same thing happens
Xampp or Wamp?
I used xampp as i did mine locally, just imported the .txt file and it uploaded perfectQuote:
Originally Posted by MrSunny
try to GZIP the sql file, that fixed my problem with too large files in phpmyadmin.Quote:
Originally Posted by MrSunny
or: Split the Database.txt with SQLDUMPSLITTER 2, then Upload first the ...DataStructure.sql File at first and then Sql Files 1-16. I tried this with phpmyadmin
Well everything uploaded fine to phpmyadmin but I still have a bunch of errors on the website. It's all text and some pictures.
Tell me the errors, if they are saying something about the eregi, look up the non deprecated verison of it and change all of the affected eregi.Quote:
Originally Posted by MrSunny
Uhhh. I don't think I can post all the errors here. You wanna team view or something?
Have changed the folder permissions from 775 to 755. And this error appears when you use an object Akkari.
"[an error occurred while processing this directive] "
He wrote back to say 755.
"You don't have the permission to see this directory."
kien kiere pan?
