· 9 years ago · Jan 02, 2017, 09:42 AM
1-- phpMyAdmin SQL Dump
2-- version 4.1.14
3-- http://www.phpmyadmin.net
4--
5-- Client : db1.free-h.org
6-- Généré le : Lun 02 Janvier 2017 à 10:36
7-- Version du serveur : 5.5.34-MariaDB-1~wheezy
8-- Version de PHP : 5.5.30-1~dotdeb+7.1
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19--
20-- Base de données : `freeh_db_92063`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Structure de la table `users`
27--
28
29CREATE TABLE IF NOT EXISTS `users` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `username` varchar(125) NOT NULL,
32 `password` varchar(255) DEFAULT NULL,
33 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
34 `auth_ticket` varchar(60) DEFAULT NULL,
35 `rank` int(1) unsigned DEFAULT '1',
36 `rank_vip` int(1) DEFAULT '0',
37 `credits` int(11) DEFAULT '50000',
38 `seasonal_currency` int(11) NOT NULL DEFAULT '0',
39 `vip_points` int(11) DEFAULT '0',
40 `activity_points` int(11) DEFAULT '5000',
41 `look` char(255) DEFAULT NULL,
42 `gender` enum('M','F') DEFAULT 'M',
43 `motto` char(50) DEFAULT NULL,
44 `account_created` char(12) DEFAULT '0',
45 `last_online` int(11) DEFAULT '0',
46 `online` enum('0','1') DEFAULT '0',
47 `ip_last` varchar(45) DEFAULT '',
48 `ip_reg` varchar(45) DEFAULT NULL,
49 `home_room` int(10) DEFAULT '0',
50 `is_muted` enum('0','1') DEFAULT '0',
51 `block_newfriends` enum('0','1') DEFAULT '0',
52 `hide_online` enum('0','1') DEFAULT '0',
53 `hide_inroom` enum('0','1') DEFAULT '0',
54 `vip` enum('0','1') DEFAULT '0',
55 `volume` varchar(15) DEFAULT '100,100,100',
56 `last_change` int(20) DEFAULT '0',
57 `machine_id` varchar(125) DEFAULT '',
58 `focus_preference` enum('0','1') DEFAULT '0',
59 `chat_preference` enum('0','1') DEFAULT '0',
60 `pets_muted` enum('0','1') DEFAULT '0',
61 `bots_muted` enum('0','1') DEFAULT '0',
62 `advertising_report_blocked` enum('0','1') DEFAULT '0',
63 `gotw_points` int(11) DEFAULT '0',
64 `ignore_invites` enum('0','1') DEFAULT '0',
65 `time_muted` double DEFAULT '0',
66 `allow_gifts` enum('0','1') DEFAULT '1',
67 `trading_locked` double DEFAULT '0',
68 `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
69 `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
70 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
71 `rangovandeweek` enum('1','0') CHARACTER SET utf8 DEFAULT '0',
72 `staff_sinds` text,
73 `rank_lijst` text CHARACTER SET utf8,
74 `bcrypt_on` enum('1','0') CHARACTER SET utf8 DEFAULT '1',
75 `rank_name` text CHARACTER SET utf8,
76 `team` int(10) DEFAULT NULL,
77 `staff_mail` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
78 `rankup` mediumtext CHARACTER SET utf8,
79 `last_offline` double NOT NULL,
80 `disabled` int(6) NOT NULL,
81 `hote_id` int(11) NOT NULL,
82 `avatars` int(11) NOT NULL DEFAULT '49',
83 PRIMARY KEY (`id`),
84 UNIQUE KEY `id` (`id`) USING HASH,
85 UNIQUE KEY `username` (`username`) USING BTREE,
86 KEY `rank` (`rank`),
87 KEY `ip_last` (`ip_last`),
88 KEY `ip_reg` (`ip_reg`),
89 KEY `credits` (`credits`),
90 KEY `activity_points` (`activity_points`),
91 KEY `online` (`online`),
92 KEY `mail` (`mail`),
93 KEY `machine_id` (`machine_id`),
94 KEY `auth_ticket` (`auth_ticket`),
95 KEY `last_online` (`last_online`),
96 KEY `home_room` (`home_room`),
97 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
98) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=135 ;
99
100--
101-- Contenu de la table `users`
102--
103
104INSERT INTO `users` (`id`, `username`, `password`, `mail`, `auth_ticket`, `rank`, `rank_vip`, `credits`, `seasonal_currency`, `vip_points`, `activity_points`, `look`, `gender`, `motto`, `account_created`, `last_online`, `online`, `ip_last`, `ip_reg`, `home_room`, `is_muted`, `block_newfriends`, `hide_online`, `hide_inroom`, `vip`, `volume`, `last_change`, `machine_id`, `focus_preference`, `chat_preference`, `pets_muted`, `bots_muted`, `advertising_report_blocked`, `gotw_points`, `ignore_invites`, `time_muted`, `allow_gifts`, `trading_locked`, `friend_bar_state`, `disable_forced_effects`, `allow_mimic`, `rangovandeweek`, `staff_sinds`, `rank_lijst`, `bcrypt_on`, `rank_name`, `team`, `staff_mail`, `rankup`, `last_offline`, `disabled`, `hote_id`, `avatars`) VALUES
105(113, 'DzMarcy', 'c3b41533bd9e3f2610b31c6b9b3f987aa5c67e12', 'ggdsgvsdg@live.fr', '', 1, 0, 9001250, 0, 0, 9430, 'ch-680-1.hr-175-1.lg-280-64.sh-295-62.ha-1010-1.hd-180-3.fa-3474-63', 'M', 'dev', '1482320310', 1482944278, '0', '86.220.181.8', '92.160.234.115', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~7668d1b577b523774412293725e73396', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1482943938, 0, 0, 49),
106(114, 'Mojito', '83d4f12c0b6bb58da06e3d723d295aacc1d0919b', 'Mojito29@outlook.fr', '765867e551ed860445867e551ed89d335867e551ed8d8', 9, 0, 8985776, 0, 100010, 10280, 'ca-3292-92.hr-831-38.ch-3321-1408.he-3329-92-81.fa-3276-100.hd-180-5.sh-290-80.lg-3391-92-1408', 'M', '# Le sang de la veine. SÆ’', '1482320475', 1483177970, '1', '85.68.153.109', '85.68.153.109', 0, '0', '1', '0', '0', '0', '100,100,100', 0, '~1b5cd2671ddc77fb66d9c334057585b0', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483203914, 0, 0, 49),
107(116, 'Alezz.', '2bbb0084779c5d6a8e9c241d89cef4a3b5687da0', 'Alezz@outlook.fr', '', 9, 0, 8998902, 0, 1000000, 8965, 'ch-255-1408.sh-290-1408.ca-1816-90.lg-280-1408.hd-190-5.hr-831-61.ha-1004-1408.cc-3158-110.fa-3193-1420', 'M', '* 04.11.16 *', '1482343426', 1483188486, '0', '107.178.33.229', '85.68.153.109', 0, '0', '0', '0', '0', '0', '0,0,0', 0, '~b726bbfb8b22565af84aa54e160feab2', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483188060, 0, 0, 49),
108(117, 'Poliacove', '1e2932a4a94045de3eaaa67dadce1878febae041', 'poliacove@gmail.com', '', 1, 0, 8786174, 0, 0, 1001877328, 'ea-1406-66.hd-209-5.ca-3292-85.cp-3284-66.hr-3278-1395-40.ch-3222-92.sh-3016-85.lg-3391-92-1408', 'M', '#Poliacove Æ’', '1482513190', 1483195695, '1', '45.33.138.245', '85.68.153.109', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~4dca05732984a271426fc24b97f32ab9', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483194704, 0, 0, 49),
109(121, 'Queen.', 'ac8cfb95d0e327f2554c82e6f199e78af18f0eba', 'oxyde.gaming@outlook.fr', '', 1, 0, 9000200, 0, 0, 13208, 'he-3295-67-1328.hr-3273-38-1348.hd-625-5.ch-665-98.lg-3391-82-1408.sh-725-1408.ca-1816-63', 'F', '¥ AdoZone The Best ¥', '1482954091', 1482956849, '0', '85.68.153.109', '85.68.153.109', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~1b5cd2671ddc77fb66d9c334057585b0', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1482957004, 0, 0, 49),
110(122, 'tony.', '32d9bcaa9e305c546f99489a87d38f2a7d2acd72', 'tony@outlook.fr', '', 2, 0, 9825582, 0, 0, 9995133, 'sh-290-110.ha-1004-100.ca-1816-1408.hr-831-61.ch-3111-110-66.hd-180-4.fa-1201-63.lg-275-100', 'M', '¥ AdoZone The Best ¥', '1482954275', 1483102136, '0', '85.68.153.109', '85.68.153.109', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~791ef003cdad64151822c710d9b01e5c', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483098650, 0, 0, 49),
111(123, 'DayStar', '83d4f12c0b6bb58da06e3d723d295aacc1d0919b', 'shan17@outlook.fr', '', 1, 0, 8974055, 0, 0, 14718, 'sh-3277-100-1408.hr-3255-39-59.lg-3174-92-1408.ch-826-92-73.hd-625-4.fa-3276-100.ca-3292-100', 'F', '¥ AdoZone The Best ¥', '1482957504', 1483038373, '0', '89.2.61.218', '85.68.153.109', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~f87082e419b4b09b1bdfc18fceeee038', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483035439, 0, 0, 49),
112(124, 'Alone-', 'b8bb912d8f823d28145458f340988eebcd8f45d0', 'raphaellebreton9@gmail.com', '', 1, 0, 9000000, 0, 0, 5003, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '¥ AdoZone The Best ¥', '1483012659', 1483012974, '0', '88.124.160.171', '88.124.160.171', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~7164875614c8ee396ecf5ddcf5590c11', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483012670, 0, 0, 49),
113(125, 'Gwen', '1e9fa7abdf48f851802e4a0409c3bdd1e5b5a1ad', 'rollandtheo29280@gmail.com', '', 1, 0, 9000000, 0, 0, 5003, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '¥ AdoZone The Best ¥', '1483012701', 1483012807, '0', '77.146.89.240', '77.146.89.240', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~94e06da29ecb2c5ec28c0ab519bb5054', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483012701, 0, 0, 49),
114(126, 'Creme', '497f24838c0031f307160172a2998da3f0e0c392', 'jirrrvvrvr@live.fr', '', 1, 0, 9000200, 0, 0, 5203, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '¥ AdoZone The Best ¥', '1483031412', 1483033414, '0', '91.88.26.135', '91.88.26.135', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~f8d5eb5663cc66a5e75aaf0f0482588f', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483031412, 0, 0, 49),
115(127, 'Keneki', '0d2efc5fc857c0cfc8cf9cd66e61e9aa5851b725', 'Kenek93@gmail.com', '545865444e1498a385865444e149c5185865444e149ff', 1, 0, 9000000, 0, 0, 5003, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '¥ AdoZone The Best ¥', '1483031622', 0, '0', '2a01:0e35:2e54:3f40:eddc:a675:e826:cc7e', '2a01:0e35:2e54:3f40:eddc:a675:e826:cc7e', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483031622, 0, 0, 49),
116(128, 'DaffyDuck', 'e04ed3b65544a639c98e88c8dbbaed8a88f2b351', 'DaffyDucklecanard@gmail.com', '', 1, 0, 9000000, 0, 0, 5003, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '¥ AdoZone The Best ¥', '1483031627', 1483031964, '0', '82.196.1.179', '82.196.1.179', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~4f66a1babf24955fbd50805279ec296e', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483031627, 0, 0, 49),
117(129, 'AceZer', '3a3d4afb4bbe4f8bc84d59a870c83a9c1c1429e9', 'email@mail.fr', '', 1, 0, 9000200, 0, 0, 5505, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '¥ AdoZone The Best ¥', '1483104525', 1483186772, '0', '81.220.90.67', '81.220.90.67', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~3feff9881a9e0ae8b9b8615ef0b8c7b3', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483186454, 0, 0, 49),
118(132, 'Plowyy', 'd325baf969a909ba4a442f048971bca6e9dd46d4', 'eee@eee.eee', NULL, 1, 0, 9000000, 0, 0, 5000, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '¥ AdoZone The Best ¥', '1483136666', 0, '0', '90.53.127.97', '90.53.127.97', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483136666, 0, 0, 49),
119(133, 'Sarwa', '40cfd9b76d1cd224ca37b9def3aa9f50090dbda5', 'zzf@gmail.com', '', 1, 0, 9000000, 0, 0, 5005, 'hr-175-1.lg-3019-82.ch-680-1.hd-600-1370.sh-740-1', 'F', '¥ AdoZone The Best ¥', '1483139368', 1483192522, '0', '2.7.28.146', '2.7.28.146', 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~976ef2bcaedd673c959a2f3a530c17d5', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '0', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 1483192487, 0, 0, 49);
120
121/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
122/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
123/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;