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` (
`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,
);
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`)
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 .
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 ;
Any chance to upload some where else please? the link above wont allow me to downloadYou must be registered to see links
I dont know how to use it or something...
You must be registered to see links
Well, im waiting for others to release their attempts before i give it away.