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...