· 6 years ago · Jun 09, 2019, 02:16 PM
1CREATE TABLE IF NOT EXISTS `jos_users` (
2 `id` int(11) NOT NULL AUTO_INCREMENT,
3 `name` varchar(255) NOT NULL DEFAULT '',
4 `username` varchar(150) NOT NULL DEFAULT '',
5 `email` varchar(100) NOT NULL DEFAULT '',
6 `password` varchar(100) NOT NULL DEFAULT '',
7 `usertype` varchar(25) NOT NULL DEFAULT '',
8 `block` tinyint(4) NOT NULL DEFAULT '0',
9 `sendEmail` tinyint(4) DEFAULT '0',
10 `gid` tinyint(3) unsigned NOT NULL DEFAULT '1',
11 `registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
12 `lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
13 `activation` varchar(100) NOT NULL DEFAULT '',
14 `params` text NOT NULL,
15 PRIMARY KEY (`id`),
16 KEY `usertype` (`usertype`),
17 KEY `idx_name` (`name`),
18 KEY `gid_block` (`gid`,`block`),
19 KEY `username` (`username`),
20 KEY `email` (`email`)
21) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=133 ;
22
23--
24-- Dumping data for table `jos_users`
25--
26
27INSERT INTO `jos_users` (`id`, `name`, `username`, `email`, `password`, `usertype`, `block`, `sendEmail`, `gid`, `registerDate`, `lastvisitDate`, `activation`, `params`) VALUES
28(128, 'samu karesz', 'karesz007', 'xxx2karesz@gmail.com', '3e8c6e8e68667cd15261e3deef3284f4:GFDqJFV7w7z7brz16Xa9beI4OjSyy6Jc', 'Registered', 0, 0, 18, '2014-08-08 19:09:16', '2014-08-08 19:11:41', '', '\n'),
29(65, 'Novák Péter', 'Péter', 'novak920218@freemail.hu', '0294d6ceca2bc03bc6f384040d7695c2:SHWWiPJ5Y1yJq5x0VJeglaIQsXDhVG0C', 'Author', 0, 0, 19, '2013-03-29 14:03:03', '0000-00-00 00:00:00', 'b7ac6321741343cbc4052248526f172a', 'language=\ntimezone=0\n\n'),
30(67, 'Gól Presszó', 'golpresszo', 'golpresszo2002@gmail.com', '7cdec31b152e005a37c1b4c5211e8137:K9haseMaulNZBV01TYaKmUZ92P9XuW2Q', 'Super Administrator', 0, 1, 25, '2013-03-29 14:39:39', '2013-06-02 09:55:00', '', 'language=\ntimezone=0\nadmin_language=\neditor=\nhelpsite=\n\n'),
31(74, 'Gemzsi Alexandra', 'Szandykah7', 'szandy14@freemail.hu', 'b45bcff37a20961d847610a406366ed1:OsAw5LREnz4nN0kDyq4VXqBTvqBE3VjB', 'Registered', 0, 0, 18, '2013-03-29 15:35:04', '2013-03-29 15:35:25', '', '\n'),
32(72, 'Tóth István', 'istvan516', 'Pisty21@postafiok.hu', 'f6a8ebe576f99c59f97dabf89e227039:egq2ekD8EJIowSvivK2kChTO6dyvoUVR', 'Registered', 0, 0, 18, '2013-03-29 15:19:38', '2013-03-29 15:19:57', '', '\n'),
33(73, 'Juhász Zoltán', 'alcasrac', 'zolika0515@hotmail.com', '583e6f746c58f831517a88a808100b36:59VGEpKb1UgEYAPBajlKbOY4cc0To5cR', 'Registered', 0, 0, 18, '2013-03-29 15:26:34', '2013-12-23 17:34:55', '', '\n'),
34(75, 'Bodnárné Koncz Melinda', 'kenyu', 'konczmelinda83@gmail.com', '53956aa61f5ddbbbbe1af2ff391b0c0a:J9joTnQFlqyq78N8giT7pbvzJxWgJFMY', 'Registered', 0, 0, 18, '2013-03-29 16:04:26', '2013-03-29 16:04:43', '', '\n'),
35(76, 'Tóth Zsolt', 'Tozsimonkey', 'toth.zsolt12@vipmail.hu', '924cd18610bb4193fc36a97ce3ce71c5:kxQrlXsNVRbOJwpfYqTSlEGH4ih4UZWM', 'Registered', 0, 0, 18, '2013-03-29 16:07:23', '0000-00-00 00:00:00', '', '\n'),
36(77, 'Euan', 'euan', 'euan.purves@gmail.com', '56a688808603b3ffd33c97917855e677:DITzqrHBNiUxNmLRdnufyG6kzHkPeKtR', 'Registered', 0, 0, 18, '2013-03-29 16:26:20', '2013-04-16 06:30:01', '', '\n'),
37(78, 'Kiss Ákos', 'Akos657', 'kimi2127@freemail.hu', '3bd864db7ee53182872c6ad84401b866:mcsLDptYLtSenXk6jcNKfuDPqO0Ms7sl', 'Registered', 0, 0, 18, '2013-03-29 17:44:55', '2013-03-29 17:45:17', '', '\n'),
38(79, 'krisztina', 'krisztina', 'horvathne123@hotmail.com', '0334245adda4f8946bda5cc748f863bb:7OTRx6mYv0R2ADb8Zh3vBxCaHXKoCevA', 'Author', 0, 0, 19, '2013-03-29 18:12:06', '0000-00-00 00:00:00', '', 'language=\ntimezone=0\n\n'),
39(80, 'Hódiné Kapin Mária', 'honey', 'Hodinekapinmaria@gmail.com', '5c0fcc0b2a71f4d93a7c218f3dfd24c4:6TEWOFsQKrtvnuRk3bycdH9dvjL10svd', 'Author', 0, 0, 19, '2013-03-29 19:11:01', '0000-00-00 00:00:00', '', 'language=\ntimezone=0\n\n'),
40(81, 'Németh Csaba', 'csaba65x', 'nemethcsaba65@citromail.hu', '365511670b1d740ea5b3d24075380209:2eUfH3hw2C2ZaSJoGFxZPYo6O9VWt134', 'Author', 0, 0, 19, '2013-03-29 20:13:43', '2013-04-01 17:24:27', '', 'language=\ntimezone=0\n\n'),
41(82, 'Szilvási István', 'Szilva', 'istvan.szilvasi@gmail.com', '16dbd9f08ddd43e6d2ac31e58754b5ca:Snu78kKHT63BI0HvckLIdbxuYxuDN7q8', 'Registered', 0, 0, 18, '2013-03-30 08:58:17', '2013-03-30 20:41:35', '', '\n'),
42(83, 'Zelenák Péter', 'Edifice', 'peter.zelenak@freemail.hu', '5a94b5c310f82388524e0ea4ff2c2471:rjWI5QNpAE4Cy8zDVDIOBGOrY9jqjotW', 'Registered', 0, 0, 18, '2013-03-30 13:09:00', '2013-03-30 13:10:02', '', '\n'),
43(84, 'Bódi István', 'reno75', 'istvan_bodi@freemail.hu', '4fe555c9acc340013a714e9e0e375202:5HqzrFoC08qTtb41g2kcyuBnUqwhT1zY', 'Author', 0, 0, 19, '2013-03-30 20:22:42', '0000-00-00 00:00:00', '', 'language=\ntimezone=0\n\n'),
44(85, 'Sándor Anita', 'Anda', 'ancsika23@citromail.hu', '75dcfcfd5c4ef8ec3038765d2a1e5242:NrWQ4b4EfvNfSZljrxew8oDOMy2YkGec', 'Registered', 0, 0, 18, '2013-03-31 08:12:40', '2013-03-31 08:14:30', '', '\n'),
45(86, 'Horváth Hajnalka', 'horvathajni28', 'horvathajni28@gmail.com', '0623ee5b520a8570f2f1da4617b4cfea:u5Ot7FqtsmtkGwwtRUzzquAlD6gwmqZ3', 'Registered', 0, 0, 18, '2013-03-31 10:29:42', '2013-04-14 09:47:30', '', '\n'),
46(88, 'Bónás Viktória', 'Viktória', 'pillango1989@indamail.hu', '5f374e04dfc4454d4ac6a15b0c8534df:I8X2jqotLcP5O8auo79sLa5otPFrZDKQ', 'Author', 0, 0, 19, '2013-04-01 14:57:48', '2013-04-01 15:00:55', '', 'language=\ntimezone=0\n\n'),
47(89, 'Kosztyu Zsolt', 'zsolesz', 'zsoltgsm1@gmail.com', '61fe40a6090609481763ec50ff2e784f:OJp5z1ed258Ah3DXucuGB5Hoe8OOApZm', 'Author', 0, 0, 19, '2013-04-02 11:58:41', '0000-00-00 00:00:00', '565acaae7b3c5d2f194feb255c4562a4', 'language=\ntimezone=0\n\n'),
48(90, 'Ungor Tibor', 'Tibi', 'szeruuu@gmail.com', 'ed3019452dcfb5efea0f3dabb6ff6525:WykObiaH9CDjroHYR6vya4e1slMQsqpj', 'Author', 0, 0, 19, '2013-04-02 18:12:26', '2014-12-14 12:57:43', '', 'language=\ntimezone=0\n\n'),
49(91, 'Tóth Anita', 'anita2121', 'anita2121@freemail.hu', '4c97d1c7627044635ae3269fcea4299e:6IY1g1kCWJI9rgF9q95Z7LzGg9ZQwI8q', 'Author', 0, 0, 19, '2013-04-02 18:29:13', '0000-00-00 00:00:00', 'ee682678296c1783e3e036617bf581c5', 'language=\ntimezone=0\n\n'),
50(92, 'Smon Krisztián', 'kiki17', 'kiki17@freemail.hu', '9e6dd8ce20158b917d8d81c568be58a4:z3Em7Js4zxeU0aFyeaRHIZxkJjdYeKeG', 'Registered', 0, 0, 18, '2013-04-02 19:59:23', '0000-00-00 00:00:00', '1be91d3aec7a509b8df6d232854e3e91', 'language=\ntimezone=0\n\n'),
51(93, 'Nagyné Kozma Beáta', 'kobea89', 'kobea89@freemail.hu', '79caeec049763bef7ade486fb4d48fe2:5juivmZaSFIFPLqg85Cww2UWGQp50S6f', 'Author', 0, 0, 19, '2013-04-03 08:17:13', '2013-04-03 13:30:03', '7a98465f1880e4d3ba08e021341bbb81', 'language=\ntimezone=0\n\n'),
52(94, 'szabolcs', 'szabolcs', 'horvathszabolcs123@gmail.com', '9219d3e9be8feacd77dd1cf26549a497:nMiDj9rixsYJx3dxnEWgcypYigsg9LHI', 'Registered', 0, 0, 18, '2013-04-03 16:38:30', '0000-00-00 00:00:00', '', '\n'),
53(95, 'Horváth Viktória', 'vikvik', 'vikvik91@gmail.com', '3b5b07ee03a46e91947c6e3d854c2387:kObmYjDwIFJ0kzJSjYSm7pbkAc9JyKCF', 'Registered', 0, 0, 18, '2013-04-03 16:51:03', '2013-04-04 08:09:16', '', '\n'),
54(96, 'Bódiné Kodák Katalin', 'Kata', 'szabika08@t-online.hu', 'dafed9cb7f0f3abdd26e357fd3a17aa1:I9HD1pgUtVD0u1bv5sOzEXBzInjjiX78', 'Registered', 0, 0, 18, '2013-04-06 14:26:46', '2013-04-06 16:45:29', '', '\n'),
55(97, 'moni', 'moni', 'moni555@freemail.hu', '74474b7ff4b07a485e73b6a8c9bc5572:mqfoT1ZQsOXqcuoAycZS3shnoC22wWCj', 'Author', 0, 0, 19, '2013-04-09 16:36:45', '2013-04-09 16:55:44', '', 'language=\ntimezone=0\n\n'),
56(98, 'Patrik', 'patrik', 'tothpatrik91@freemail.hu', '2d2b804b83009ee4b04b25eac665f2c6:UFNENhcdBBR10njwLtU6DraE0j6BVsfl', 'Registered', 0, 0, 18, '2013-04-09 16:49:28', '2013-04-09 16:56:10', '', '\n'),
57(99, 'Minyáné Juhász Beáta', 'minyanebetti', 'minyanebetti@gmail.com', '8bd7c35c4a1c9417939280038da15caf:ce6UdRXvxnuVCZW0Masj0br8fIop3uAr', 'Author', 0, 0, 19, '2013-04-17 09:23:17', '0000-00-00 00:00:00', '', 'language=\ntimezone=0\n\n'),
58(100, 'Berki Anita', 'berkianitacska', 'berkianita@freemal.hu', 'd92f6f036481b92c6c4710cd0fdcd5c3:SjIZDLhPaZPFGurknAs5HRneUP9cHchB', 'Registered', 0, 0, 18, '2013-04-21 13:02:29', '0000-00-00 00:00:00', 'd60fe3a516ba450ff119bd490b565d97', 'language=\ntimezone=0\n\n'),
59(101, 'Vámos Alexandra', 'vamos.szandi', 'vami000@freemail.hu', '9332565c9d01160fdcb605b549776fbb:Rk9J4XpXNUBTy4wgKBM2nyaSvKA7eiXw', 'Author', 0, 0, 19, '2013-04-24 13:35:53', '2013-04-24 13:37:24', '', 'language=\ntimezone=0\n\n'),
60(102, 'Erdeiné Szabó Anita', 'majacska20', 'majacska20@hotmail.com', '611eda3b4c568c8e9ce2660faf6d5772:NaAfaInAT9perOei2P1ipN9Xa2LaeuIm', 'Author', 0, 0, 19, '2013-04-24 13:42:55', '2013-04-24 13:47:41', '', 'language=\ntimezone=0\n\n'),
61(103, 'Lengyel Regina', 'Reginaa', 'lengyel.regina@freemail.hu', '704f8d3583996c7facf224da94e33b24:JHjdpSTxwdWIzX5Z7ZTv6ctIMKCozjl1', 'Author', 0, 0, 19, '2013-04-26 17:18:58', '2013-04-26 17:22:06', '', 'language=\ntimezone=0\n\n'),
62(104, 'Ungor Nikoletta', 'Niki', 'nike890515@citromail.hu', 'a40ce96a49fb0ec57d570de21c9fd6e4:SZVfi26BvVBXDbqMyvtSpgJRLfKk5doP', 'Registered', 0, 0, 18, '2013-04-29 11:51:27', '2013-04-29 11:54:37', '', '\n'),
63(105, 'Lengyel Róbertné Csoma Tünde', 'Tünde', 'csomatunde69@gmail.com', '1610c0492a2ed6297bc79b546dfe04cc:x6qZwNzJbaabClXfuzHYUSTqwgCsIC3r', 'Registered', 0, 0, 18, '2013-04-29 17:31:06', '2013-04-29 17:44:31', '', '\n'),
64(106, 'Balogh Adrienn', 'manókaa', 'barcamano7@freemail.hu', '29bbe666231a0db7cae2efe707429c44:n0cTVXDZWwYkLlJJ4Y8Mx2AeMZpolBbr', 'Registered', 0, 0, 18, '2013-04-29 17:53:25', '0000-00-00 00:00:00', '189846591f7ebfa5964c9e7ce6b49d4f', '\n'),
65(107, 'Szabó Józsefné', 'germuskaerika', 'germuskaerika@freemail.hu', '32d85f54d44b50adbf2949e015acc35e:SxkJfyiK1rNk1aUiG9ZHIc3yJ8IoAz0B', 'Author', 0, 0, 19, '2013-04-30 06:44:44', '2013-04-30 06:51:29', '', 'language=\ntimezone=0\n\n'),
66(108, 'Faragó Balázs', 'balu', 'baazska73@freemail.hu', '0ef6fd53d1b1b750ea0538f038888d88:MWYm4nhNYUl0DdRJrnKSbmMXqZmL6Wmv', 'Registered', 0, 0, 18, '2013-04-30 13:19:34', '0000-00-00 00:00:00', '2fd6c38bd12f9de5bb9b509f905974c9', '\n'),
67(109, 'Szabó Ivett', 'Vett996', 'szaboivett99@freemail.hu', 'cc1bd3b49c8e553de8ad6490b3d31601:5QYCPpyxsQBCBW9mK02kQh8PHexe2U9C', 'Author', 0, 0, 19, '2013-05-02 18:25:37', '0000-00-00 00:00:00', '29b90e37c97ff19cab03b548ea8aa897', 'language=\ntimezone=0\n\n'),
68(110, 'Csorba', 'Attiláné', 'csorba.attila75@freemail.hu', '2269712d0d76fdd846aeaec2ad2d947c:vifYa6v9ErbRzgcaZotODPv6F9wBzMIj', 'Registered', 0, 0, 18, '2013-05-03 15:13:12', '2013-05-08 13:12:03', '', '\n'),
69(111, 'Simkó András', 'Simkó András', 'iceman0514@freemail.hu', '1487e63b400cc1c8d1971a20c063db17:wfHHxlJBVqFsBpb9rObqGkAW8TYrXoSN', 'Registered', 0, 0, 18, '2013-05-03 18:21:14', '2013-05-03 18:27:48', '', '\n'),
70(112, 'Tóth Zsuzsanna', 'Zsanna', 'kicsizsu1@citromail.hu', 'b4e8fceb80e2f47bc9e6e301bb1392cd:io4c9JYbsHhPcaFSFUlZs6xUB2GV6xul', 'Author', 0, 0, 19, '2013-05-03 18:21:36', '2013-05-04 05:30:32', '', 'language=\ntimezone=0\n\n'),
71(113, 'Kovács Béla', 'becike123', 'Kovacs.Becike@freemail.hu', '48523d30415db0cd52ad8151c0651609:ouTTnlOqT7mN67CkVQelWGY4G7aCn9Pl', 'Registered', 0, 0, 18, '2013-05-07 15:49:11', '0000-00-00 00:00:00', 'ff607c52ea75c297fe75b71eb658f04b', '\n'),
72(127, 'Tóth Bernadett', 'bettoo', 'vlaki12@freemail.hu', '9119aecb1aceab67d1e562e8f23f78a1:iK2ZjkfLTOMGxGcdhK9Ira7G2LknJsgd', 'Registered', 1, 0, 18, '2014-08-07 12:06:22', '0000-00-00 00:00:00', '96d46b5fe82e3eafee4e44027c8acef0', '\n'),
73(114, 'Marics Gábor', 'cselo07', 'cselo89@gmail.com', 'edb9428426a12cf3019bb796a39786c3:OiIolsc0CZ4nq8yGvsGFO6z1yG9ARQT9', 'Registered', 0, 0, 18, '2013-05-14 13:41:12', '2013-09-24 09:37:12', '', '\n'),
74(115, 'Kiss Tamás', 'Kiss rezidencia', 'tomi.43@freemail.hu', 'e96a97643e33004a0fc771fd693e80c0:ZlgGjLiXZpVCdeyxhn3GVkNZYp9bqtZ6', 'Registered', 0, 0, 18, '2013-05-20 10:56:51', '2013-05-20 10:58:44', '', '\n'),
75(116, 'Illés László', 'ilu', 'illes.laszlo72@gmail.com', 'b6b18d6ecb7c94e99d2213bd3f1da4f2:DGrclk4VGa9b7EeZq7b9yT83SbzzXX3e', 'Author', 0, 0, 19, '2013-05-23 11:29:38', '0000-00-00 00:00:00', '74432a2ba06c286f4645e5a2ceb66b3f', 'language=\ntimezone=0\n\n'),
76(117, 'csubák zoltán', 'csubi', 'kiscsubi30@gmail.com', 'a96788e15f94591f6003450726c005fe:7wjSQnTtHdFDJe4wFfj0FbxQ0YGrFTbt', 'Author', 0, 0, 19, '2013-05-28 10:14:43', '0000-00-00 00:00:00', '', 'language=\ntimezone=0\n\n'),
77(118, 'Szaponár Zoltán', 'zozi', 'szaponarzoltan@freemail.hu', '5da12607e8c1742f36bcd0b3f0e3ffb9:BFGxegKqVucvLVVspfNHysuYWcyhJAOv', 'Registered', 0, 0, 18, '2013-06-18 15:48:18', '2013-07-12 12:57:30', '', '\n'),
78(119, 'Kerekes', 'György', 'kerekes.gyuri76@gmail.com', 'b86681954eccd093910b10237a75cf1c:GU9OxNs4N60FzpNeyzQtCbifL59bq3hH', 'Registered', 0, 0, 18, '2013-07-07 16:26:36', '2013-07-07 16:30:14', '', '\n'),
79(120, 'Geda Kinga', 'Kinga_Geda', 'geda@freemail.hu', '697317c2a46bc36a4bb6bfcbc206dfe0:87eZ2MbBLaYp7POD6PIUY16Vx4C11jvt', 'Registered', 0, 0, 18, '2013-09-02 17:45:54', '2013-09-02 17:50:10', '', '\n'),
80(121, 'Gebri Gergő', 'gatyafix', 'gatyafix@gmail.com', 'cad4e788448a7bd3267157096cf20770:MTwb9UHQX6LLuDxoeblcHAfsKPZobIEI', 'Registered', 0, 0, 18, '2013-11-28 17:46:47', '2014-09-24 14:17:19', '', '\n'),
81(122, 'Szücs Klaudia', 'Dyaa', 'klaudia9611@freemail.hu', 'fa9e55e36475ef741ce6749d0e39235e:f4WYdgjlEkZMym0Amwmju81eayux8JIZ', 'Registered', 0, 0, 18, '2013-12-13 18:52:53', '2013-12-13 18:54:32', '', '\n'),
82(123, 'Jakab József', 'józsef', 'jakabfater@gmail.com', 'cc01c0b415e960eebe07fd3006d1a702:NEAX3dt29T6Z5pmXGMNvm1nQfGadj0Z5', 'Registered', 0, 0, 18, '2014-02-04 15:41:38', '2014-02-04 15:43:34', '', '\n'),
83(124, 'Malmos József', 'Prince1983', 'jozsef.malmos@gmail.com', '9ebb6eb90ef62f12baf45fa9c9a95804:CaTddgk12AHzrhrvili869tXYo0nHhzr', 'Registered', 0, 0, 18, '2014-02-14 11:59:14', '2014-08-08 10:35:30', '', '\n'),
84(125, 'Soltész Anita', 'Anita', 'anita_soltesz@hotmail.com', '87e4a2e89d1670eb6d424f399e1814f7:VKSusZpuwc1omyc6PR3LdVjewvXJNGpG', 'Registered', 0, 0, 18, '2014-05-05 12:54:14', '2014-12-03 16:48:30', '', '\n'),
85(126, 'Takács Andrrea', 'takacsandrea', 'andus.takacs@gmail.com', '5fa2af90789e763d37b2c53ee31e01cb:INPm9kSWCrDKPEjpBou52yxtMRj40ZcA', 'Super Administrator', 0, 1, 25, '2014-07-25 09:02:42', '2015-01-04 10:21:01', '', 'admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n'),
86(129, 'kovács edina', 'edina51', 'edina51@citromail.hu', '4448dc0985dfbd1219b07ea76d486029:deXrusC4SCG1LxoUmDSheXM73CscklfL', 'Registered', 0, 0, 18, '2014-09-07 15:18:19', '2014-09-07 15:22:22', '', '\n'),
87(130, 'Kertész János', 'janikanak', 'janika77@freemail.hu', 'cfaf2c1c01f592bddbb5a5868e7ec345:L7zUqmLSwQC6SxMydGezwoek5oQRadse', 'Registered', 0, 0, 18, '2014-10-25 15:55:51', '2014-10-25 15:57:19', '', '\n'),
88(131, 'Törös Bence', 'szalon', 'bence.toros@freemail.hu', 'ff83e88fcbcfd0b22a90651a43f7a8db:44Bq3tESp09WmLjDfolGafW4GG5alp8W', 'Registered', 0, 0, 18, '2014-11-17 07:51:42', '2014-12-01 14:27:55', '', '\n'),
89(132, 'Czipka Gergő', 'czipka92', 'czipkagergo@gmail.com', 'b6d1d1a9dad7454986dc7343d90b1fa4:6djLHTPH9vTeYVBmXf8mBGEk65IXM2cV', 'Registered', 1, 0, 18, '2014-12-06 17:39:57', '0000-00-00 00:00:00', '1f79e503a4edbeabfe231df1e050790c', '\n');