Als ik me oude sql doe , Dan bugt hij niett.
Maar als ik deze doe:
Dan bugt me site , Weet iemand waar dat aan ligt.
HELP me
-- phpMyAdmin SQL Dump
-- version 3.2.1
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 21 Aug 2009 om 20:22
-- Serverversie: 5.1.37
-- PHP-Versie: 5.2.10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `shahiem_hr2`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `leden`
--
CREATE TABLE IF NOT EXISTS `leden` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`naam` varchar(25) NOT NULL,
`wachtwoord` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`activatie` varchar(8) NOT NULL,
`laatst_actief` varchar(255) NOT NULL DEFAULT Nooit,
`lid_sinds` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip` varchar(15) NOT NULL,
`rang` int(10) NOT NULL DEFAULT 1,
`wwvergeten` varchar(8) NOT NULL,
`muntjes` varchar(255) NOT NULL DEFAULT 100,
`waarschuwingen` int(100) NOT NULL,
`grootprofiel` longtext NOT NULL,
`signature` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;
--
-- Gegevens worden uitgevoerd voor tabel `leden`
--
INSERT INTO `leden` (`id`, `naam`, `wachtwoord`, `email`, `activatie`, `laatst_actief`, `lid_sinds`, `ip`, `rang`, `wwvergeten`, `muntjes`, `waarschuwingen`, `grootprofiel`, `signature`) VALUES
(1, SuperID, 88ac84acf92b180cd3a0dc61a241c13e, erik.juhh@hotmail.com, 1, 2009-08-21 20:09:24, 2009-08-15 10:20:24, 88.159.203.72, 4, , 1000, 0, [url=www.habbofarm.nl]Habbofarm[/url] ownt!, ),
(2, Spruitertje1, 228106c72f05e1cc2cb5a168b453e2f2, shahiem_12@live.nl, 1, 2009-08-21 18:33:17, 2009-08-15 10:31:54, 212.187.15.100, 4, , 980, 10, Welkom op me grootprofiel!
Ik ben eigenaar van Habboregio samen met Markbruil(o) xD!
Veel plezier :D!, Elke dag begin je met een nieuwe lach!),
(3, Markbruil, 8237e629954d7953ff81151d2c22eba3, markbruil@hotmail.com, 1, 2009-08-21 18:38:06, 2009-08-15 10:42:25, 77.163.165.136, 4, , 2, 0, Hoi, ),
(4, Testaccount, 098f6bcd4621d373cade4e832627b4f6, bruilmark@gmail.com, 1, Nooit, 2009-08-15 15:40:20, 77.163.165.136, 1, , 100, 0, , ),
(5, Iriskid, 9bc224bb5b9a6c0acbd98bc988445db7, iriskeulemans@live.nl, 1, Nooit, 2009-07-14 11:53:01, 81.205.171.247, 1, , 100, 0, , ),
(6, Avondkrant, 4ddd10de5af0c2315852d97b9f646a9f, markboeters@hotmail.com, 1, Nooit, 2009-08-21 14:43:39, , 1, , 100, 0, , ); Maar als ik deze doe:
-- phpMyAdmin SQL Dump
-- version 3.2.1
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 21 Aug 2009 om 20:51
-- Serverversie: 5.1.37
-- PHP-Versie: 5.2.10
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `shahiem_hr2`
--
-- --------------------------------------------------------
--
-- Tabelstructuur voor tabel `leden`
--
CREATE TABLE IF NOT EXISTS `leden` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`naam` varchar(25) NOT NULL,
`wachtwoord` varchar(50) NOT NULL,
`email` varchar(50) NOT NULL,
`activatie` varchar(8) NOT NULL,
`laatst_actief` varchar(255) NOT NULL DEFAULT Nooit,
`lid_sinds` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`ip` varchar(15) NOT NULL,
`rang` int(10) NOT NULL DEFAULT 1,
`wwvergeten` varchar(8) NOT NULL,
`muntjes` varchar(255) NOT NULL DEFAULT 100,
`waarschuwingen` int(100) NOT NULL,
`grootprofiel` longtext NOT NULL,
`signature` longtext NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=109 ;
--
-- Gegevens worden uitgevoerd voor tabel `leden`
--
INSERT INTO `leden` (`id`, `naam`, `wachtwoord`, `email`, `activatie`, `laatst_actief`, `lid_sinds`, `ip`, `rang`, `wwvergeten`, `muntjes`, `waarschuwingen`, `grootprofiel`, `signature`) VALUES
(8, Spruitertje1, 054a71fe441869f471d0dd38b2b8fea9, test@email.com, 6, Nooit, 2007-08-29 22:28:53, 127.0.0.1, 1, , 100, 0, , ),
(9, markbruil, 381e23f8d00be94c13559f76d488f64f, markbruil@hotmail.com, 6, Nooit, 2009-07-10 21:57:41, 77.163.165.136, 1, , 100, 0, , ),
(10, Iriskid, 9bc224bb5b9a6c0acbd98bc988445db7, iriskeulemans@live.nl, 7, Nooit, 2009-07-14 11:53:11, 81.205.171.247, 1, , 100, 0, , ),
(11, Avondkrant, 4ddd10de5af0c2315852d97b9f646a9f, markboeters@hotmail.com, 9, Nooit, 2009-07-14 11:54:37, 83.87.172.116, 1, , 100, 0, , ),
(12, provista., c5253e5021912da077cc1fbd52e2de5d, yorrick.h2@hotmail.com, 1, Nooit, 2009-07-14 16:40:07, 77.250.250.182, 1, , 100, 0, , ),
(13, SuperID, 88ac84acf92b180cd3a0dc61a241c13e, erik.juhh@hotmail.com, 5, Nooit, 2009-07-14 18:38:30, 88.159.203.72, 1, , 100, 0, , ),
(14, One2three, 515ffc541c7fbe02468c2248037d29a5, wae@live.nl, 1, Nooit, 2009-07-14 22:41:22, 87.210.69.179, 1, , 100, 0, , ),
(15, Systeem, 4216455ceebbc3038bd0550c85b6a3bf, bruilmark@gmail.com, 1, Nooit, 2009-07-15 11:22:53, 77.163.165.136, 1, , 100, 0, , ),
(16, erwir, 12cc9d979ec241a267a3f4e78125f750, erwir-habbo@hotmail.com, 1, Nooit, 2009-07-16 12:53:09, 86.86.134.146, 1, , 100, 0, , ),
(44, !.Raymond.!, bf20bba6f3e1f3dbb1c71f68f9d478f2, raymond-dv@live.nl, 1, Nooit, 2009-07-26 15:11:36, 82.95.93.115, 1, , 100, 0, , ),
(18, cavia-romie, 216a9901c3f0a905b79a0de213feb595, doetje-albers@hotmail.com, 5, Nooit, 2009-07-17 12:27:18, 80.101.147.151, 1, , 100, 0, , ),
(19, Cranktastic, c00ea6752473fa7dc8603e443965cb84, shahrukh_khan@live.nl, 2, Nooit, 2009-07-17 21:22:24, 77.168.74.170, 1, , 100, 0, , ),
(47, Dokterrob, d41d8cd98f00b204e9800998ecf8427e, , 1, Nooit, 2009-07-26 19:17:38, 81.83.52.123, 1, , 100, 0, , ),
(21, GameStyle, 2b3b038e3dbd50c21f74beb29d92dad7, hebikniet@?.com, 5, Nooit, 2009-07-19 11:44:44, 87.208.3.128, 1, , 100, 0, , ),
(22, erben16, f3b23cf35e091fe6d619341858fd6c98, hebbobestuur@live.nl, 1, Nooit, 2009-07-19 12:12:42, 83.82.44.221, 1, , 100, 0, , ),
(23, tysju, d72fd37f429e14fb45b39a6cfecc723b, thijssnoek@hotmail.com, 1, Nooit, 2009-07-19 14:42:36, 82.173.184.37, 1, , 100, 0, , ),
(46, ==Yessin==, f8656c4956fa2db9afca86e657467992, yessinbakema@hotmail.com, 1, Nooit, 2009-07-26 15:45:09, 84.85.98.105, 1, , 100, 0, , ),
(68, Habbo?Draait, 60d19e96c784746a824f3c853c1cc65b, tonnyboyy@live.nl, 1, Nooit, 2009-07-30 19:31:34, 87.195.98.6, 1, , 100, 0, , ),
(32, gnome, a9c52a81dac874d70c2a9bfb9bcc4ac1, gnome@gnomewood.nl, 1, Nooit, 2009-07-19 21:06:38, 87.212.124.72, 1, , 100, 0, , ),
(27, NeedRain, 9cdfb439c7876e703e307864c9167a15, geheim@man.lol, 1, Nooit, 2009-07-19 20:41:35, 80.126.53.45, 1, , 100, 0, , ),
(67, Power.Mark.D, 16d751c3a9e8aa2a54b54547576f2fc2, rhandy1997@hotmail.com, 5, Nooit, 2009-07-30 19:10:36, 94.213.224.61, 1, , 100, 0, , ),
(55, ricardo=, e8636ea013e682faf61f56ce1cb1ab5c, ricardo@habbstars.nl, 1, Nooit, 2009-07-28 19:06:18, 94.211.87.27, 1, , 100, 0, , ),
(54, Steeger, 9cdfb439c7876e703e307864c9167a15, steeger@habbowereld.nl, 1, Nooit, 2009-07-28 15:13:19, 213.17.52.132, 1, , 100, 0, , ),
(53, megadreams, d8ab3984b9bc7065da6caa63caa8af16, sleeubusjordy@hotmail.com, 1, Nooit, 2009-07-28 13:06:37, 84.196.97.114, 1, , 100, 0, , ),
(79, Superginjaar, 0bd45470b11e9cd84afe28387bd98b48, glennleiden@msn.com, 1, Nooit, 2009-07-31 20:29:01, 83.85.28.91, 1, , 100, 0, , ),
(60, Tentiel, 77963b7a931377ad4ab5ad6a9cd718aa, ddddddd@tabboregio.nl, 1, Nooit, 2009-07-29 17:49:11, 84.83.40.18, 1, , 100, 0, , ),
(61, bryan, 1aa68792a86484bdd49773152619caba, lol@live.nl, 1, Nooit, 2009-07-29 18:35:34, 83.85.217.145, 1, , 100, 0, , ),
(66, Geurtvdb, 6cf7212707555c962a184ecd7cd47823, geurtvdb@hotmail.com, 1, Nooit, 2009-07-30 18:28:13, 212.45.32.211, 1, , 100, 0, , ),
(65, zeelandman, f79cfeef371df4c20aa1fdc7252c2ce9, florishihi@hotmail.com, 1, Nooit, 2009-07-30 18:17:30, 84.82.100.31, 1, , 100, 0, , ),
(80, Real-Crimii, df780a97b7d6a8f779f14728bccd3c4c, wimborgerdijn@hotmail.com, 1, Nooit, 2009-07-31 20:55:09, 83.162.6.102, 1, , 100, 0, , ),
(70, icct, 16d751c3a9e8aa2a54b54547576f2fc2, jhef@live.nl, 1, Nooit, 2009-07-30 20:44:27, 94.213.224.61, 1, , 100, 0, , ),
(71, sylvia123?!, e53a27222e6e4a1828bd89996124e73e, silly_bloemen@hotmail.com, 1, Nooit, 2009-07-30 21:11:26, 83.82.168.197, 1, , 100, 0, , ),
(72, dj-bulll, 8301c321580a01c02e02df1f0a11387e, ferry-holla@telfort.nl, 1, Nooit, 2009-07-31 10:06:59, 82.169.57.123, 1, , 100, 0, , ),
(73, 2jessie2, c98052e3a99915412f1669f9037fa988, habbo.pagina@live.nl, 1, Nooit, 2009-07-31 10:15:45, 82.169.84.13, 1, , 100, 0, , ),
(74, !!-=funky=-!!, ed87fb4e07739a751a59ce8be24ea0f5, arjenfroma@gmail.com, 1, Nooit, 2009-07-31 10:21:56, 77.170.104.146, 1, , 100, 0, , ),
(75, superjoppop, 4a6339d4e0ade5b8a007803ee1307bba, daan_taro@hotmailcom, 1, Nooit, 2009-07-31 10:34:28, 77.61.110.49, 1, , 100, 0, , ),
(77, dloydy, 0b3248656b132137bca60266a86d488f, downloyd@live.nl, 1, Nooit, 2009-07-31 16:53:49, 87.195.98.6, 1, , 100, 0, , ),
(78, p.jongsma1, e10adc3949ba59abbe56e057f20f883e, p.jongsma1@hotmail.com, 1, Nooit, 2009-07-31 19:23:22, 81.92.182.227, 1, , 100, 0, , ),
(81, niels, a0bf0864132a37101efc9e9b9ce11ab8, nelisvanvelzen@live.nl, 1, Nooit, 2009-08-01 11:56:00, 83.119.205.192, 1, , 100, 0, , ),
(82, Sligman, 7087887ea16b6b7f1756f7cacebf17e3, s-ligman@hotmail.com, 1, Nooit, 2009-08-01 15:40:10, 82.169.54.242, 1, , 100, 0, , ),
(83, dj-hcs, 29d216080f0351bc083d0e604251acbe, bo_wien@live.nl, 1, Nooit, 2009-08-01 15:43:08, 87.210.184.53, 1, , 100, 0, , ),
(84, ggmi100, 805ba006f16c54dfea592434f6c32605, mika-vermeulen@live.nl, 1, Nooit, 2009-08-01 15:49:26, 84.30.236.155, 1, , 100, 0, , ),
(85, test, 098f6bcd4621d373cade4e832627b4f6, test@live.nl, 1, Nooit, 2009-08-01 18:46:55, 62.45.216.72, 1, , 100, 0, , ),
(86, d-d-d, 84c872d2eb7dff21fd936aceae9a53a9, rubbb@live.nl, 1, Nooit, 2009-08-01 19:06:15, 81.206.156.37, 1, , 100, 0, , ),
(87, -zaka, 0d3ac0b633f0b78c315785456a36b2e1, zaka_maroc_6@hotmail.com, 1, Nooit, 2009-08-01 20:49:40, 83.86.68.235, 1, , 100, 0, , ),
(88, hond:spikry, 5fee40e790ee99d535679671a2c3a55d, rogier_9@msn.com, 1, Nooit, 2009-08-02 12:13:22, 83.94.132.14, 1, , 100, 0, , ),
(89, smoesjes, cd0f66a312a9c26d7741eefa3a6e1cce, smoesjes@live.com, 1, Nooit, 2009-08-02 14:03:01, 95.96.78.54, 1, , 100, 0, , ),
(90, jojo, c05f33491177cf867c280994bb22b19c, <plaintext>@hotmail.com, 1, Nooit, 2009-08-02 15:37:50, 77.161.234.200, 1, , 100, 0, , ),
(91, HabSeason, 54172635c80bebf9d32ac498155e251e, Mark-Habbo@live.nl, 1, Nooit, 2009-08-02 16:25:31, 94.214.106.56, 1, , 100, 0, , ),
(92, NAOMii, 315751b2e5d1d01250b30414fb8935ce, naomiozdemir_13@msn.com, 1, Nooit, 2009-08-02 18:24:51, 84.87.102.117, 1, , 100, 0, , ),
(93, ricky02, cff1f0f0eff214cf9011d2e73d6e0b40, rickbrandsma@msn.com, 1, Nooit, 2009-08-03 10:06:58, 86.95.214.4, 1, , 100, 0, , ),
(94, jochem725, 47aff45f08c6df1736ec6dc930fa1419, doemarwat3@hotmail.com, 1, Nooit, 2009-08-03 13:12:57, 82.95.127.116, 1, , 100, 0, , ),
(95, 1ddg1, 19018c54412b484d48c134a69d19fe2e, tjalling.r@gmail.com, 1, Nooit, 2009-08-03 18:03:34, 86.93.16.97, 1, , 100, 0, , ),
(96, Sk!p,,, 74a565c05bbcce4c49a1b5bcbecf14fd, daancrefcoeur@gmail.com, 1, Nooit, 2009-08-03 21:30:39, 217.122.18.176, 1, , 100, 0, , ),
(97, Crazydog100, 83665c1ae1e3cb6e8bbab006494fcd8a, robert@compear.nl, 1, Nooit, 2009-08-04 00:28:59, 83.119.77.235, 1, , 100, 0, , ),
(98, kleine4444, 2737ad4602db471f9e3f05ac29044dfc, anne-nieland@hotmail.com, 1, Nooit, 2009-08-04 08:01:08, 94.209.208.42, 1, , 100, 0, , ),
(99, -=TheXmen=-, f4a4aa2d7eff52d9211077e6628e9b93, jordydaamen@live.n, 1, Nooit, 2009-08-04 22:41:52, 83.162.33.99, 1, , 100, 0, , ),
(100, superwomen194, 4b67868bdba4ff9c2dc3f796bcafbb4e, kim_jansenspk@live.nl, 1, Nooit, 2009-08-05 20:38:11, 77.250.91.240, 1, , 100, 0, , ),
(101, Nika-queen, acbef4ce045c006e9b547a69134fec75, nika-queen@hotmail.com, 1, Nooit, 2009-08-06 12:41:10, 77.248.12.50, 1, , 100, 0, , ),
(102, bastiaande2e, a73d21f88a51f6937dd92e698876f420, bastiaan.vankuik@yahoo.com, 1, Nooit, 2009-08-06 18:19:16, 84.24.249.193, 1, , 100, 0, , ),
(103, GranDez, 86482691dc557a158de4748c6e00d0b4, fati1@hotmail.com, 1, Nooit, 2009-08-06 21:16:59, 83.61.198.180, 1, , 100, 0, , ),
(104, danique23lovexx, 9cb62c7cddea6140b23cdbdcfcc30c50, danique24@hotmail.nl, 1, Nooit, 2009-08-06 21:18:53, 84.26.25.120, 1, , 100, 0, , ),
(105, HS-DJs, 98df64814c2c5d1b13d38938ad08b62d, deejay@hahah.nl, 1, Nooit, 2009-08-07 11:21:11, 84.25.78.176, 1, , 100, 0, , ),
(106, boude, 9efb1e7f118fa0ec95b31b9dff40eb45, boudewijn_bal@hotmail.com, 1, Nooit, 2009-08-07 12:52:27, 81.206.232.13, 1, , 100, 0, , ),
(107, andy1234567891234567, 708718e82ccc4c78ffb67b33737cd436, andygilliot@hotmail.com, 1, Nooit, 2009-08-07 16:01:46, 94.224.112.114, 1, , 100, 0, , ),
(108, HabbKies, 7fe8c80150393a0aaadb74f4f864a87f, admin@habbkies.nl, 1, Nooit, 2009-08-08 14:55:15, 92.68.213.226, 1, , 100, 0, , ); Dan bugt me site , Weet iemand waar dat aan ligt.
HELP me


