Ik snap niet goed hoe ik een massa donatie doe voor mijn site?
hier te tabel voor gebruikers:
PHP
-- phpMyAdmin SQL Dump
-- version 3.5.0
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 01 mei 2012 om 13:59
-- Serverversie: 5.1.60-log
-- PHP-Versie: 5.2.17
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Databank: `stijnqg59_pkmo`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `gebruikers`
--
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',
`Adminstatus` tinyint(1) 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(12) 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,
`domass` int(10) NOT NULL DEFAULT '0',
`clan` text NOT NULL,
`missie_1` int(255) NOT NULL DEFAULT '0',
`missie_2` int(255) NOT NULL DEFAULT '0',
`missie_3` int(255) NOT NULL DEFAULT '0',
`missie_4` int(255) NOT NULL DEFAULT '0',
`missie_5` int(255) NOT NULL DEFAULT '0',
`missie_6` int(255) NOT NULL DEFAULT '0',
`missie_7` int(255) NOT NULL DEFAULT '0',
`missie_8` int(255) NOT NULL DEFAULT '0',
`missie_9` int(255) NOT NULL DEFAULT '0',
`missie_10` int(255) NOT NULL DEFAULT '0',
PRIMARY KEY (`user_id`),
KEY `naam` (`username`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14075 ;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Toon Meer
Als u me kunt helpen hoor ik het graag