Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Anyone got the Pokemon-area.com files

Status
Not open for further replies.
RaGEZONER || Webdevloper
Banned
Joined
Oct 6, 2011
Messages
614
Reaction score
130
Can not be used because it contains the database.
 
Joined
Jul 29, 2012
Messages
527
Reaction score
71
...
heres one table for you...
Code:
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 ;
Have fun with it :D
 
RaGEZONER || Webdevloper
Banned
Joined
Oct 6, 2011
Messages
614
Reaction score
130
Thanks. :D Today is my birthday. Gift from the other table also. :D
 
Experienced Elementalist
Joined
Nov 26, 2007
Messages
284
Reaction score
21
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?
 
Joined
Nov 1, 2008
Messages
587
Reaction score
83
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,
);

The Database for creating account, i'm not good on making SQL's queries, the table is fully working but not done .

Register.php said:
mysql_query("INSERT INTO `gebruikers` (`account_code`, `voornaam`, `achternaam`, `land`, `character`, `username`, `geb_datum`, `datum`, `aanmeld_datum`, `wachtwoord`, `email`, `ip_aangemeld`, `wereld`)
 
Joined
Jul 29, 2012
Messages
527
Reaction score
71
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,
);

The Database for creating account, i'm not good on making SQL's queries, the table is fully working but not done .

Not quite fully working, it won't work when using other stuff. But for your effort i'll give you the whole table:
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 ;
 
Initiate Mage
Joined
Jul 22, 2012
Messages
32
Reaction score
3
Well, im waiting for others to release their attempts before i give it away.

Not a problem boss :eek:tt1:

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
 
Banned
Banned
Joined
Dec 20, 2011
Messages
462
Reaction score
30
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.



It only gives 1 table.
 
Last edited:
Status
Not open for further replies.
Back
Top