· 9 years ago · Oct 03, 2016, 08:48 PM
1________ .______. .__ ___. ___.
2\______ \ __ __ _____ ______ __| _/\_ |__ | |__ _____ \_ |__\_ |__ ____ ____ _____ ____ _________ ____ __ __
3 | | \| | \/ \\____ \ / __ | | __ \ | | \\__ \ | __ \| __ \ / _ \ ______ / _ \ / \_/ __ \ / ___\__ \ _/ __ \| | \
4 | ` \ | / Y Y \ |_> > / /_/ | | \_\ \ | Y \/ __ \| \_\ \ \_\ ( <_> ) /_____/ ( <_> ) Y Y \ ___// /_/ > __ \_ \ ___/| | /
5/_______ /____/|__|_| / __/ \____ | |___ / |___| (____ /___ /___ /\____/ \____/|__|_| /\___ >___ (____ / /\ \___ >____/
6 \/ \/|__| \/ \/ \/ \/ \/ \/ \/ \/_____/ \/ \/ \/
7
8
9
10
11
12
13
14-- phpMyAdmin SQL Dump
15-- version 4.1.14
16-- http://www.phpmyadmin.net
17--
18-- Client : db1.free-h.org
19-- Généré le : Lun 03 Octobre 2016 à 22:45
20-- Version du serveur : 5.5.34-MariaDB-1~wheezy
21-- Version de PHP : 5.5.30-1~dotdeb+7.1
22
23SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
24SET time_zone = "+00:00";
25
26
27/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
28/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
29/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
30/*!40101 SET NAMES utf8 */;
31
32--
33-- Base de données : `freeh_db_90279`
34--
35
36-- --------------------------------------------------------
37
38--
39-- Structure de la table `users`
40--
41
42CREATE TABLE IF NOT EXISTS `users` (
43 `id` int(11) NOT NULL AUTO_INCREMENT,
44 `username` varchar(125) NOT NULL,
45 `password` varchar(255) DEFAULT NULL,
46 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
47 `auth_ticket` varchar(60) DEFAULT NULL,
48 `rank` int(1) unsigned DEFAULT '1',
49 `rank_vip` int(1) DEFAULT '0',
50 `credits` int(11) DEFAULT '50000',
51 `seasonal_currency` int(11) NOT NULL DEFAULT '0',
52 `vip_points` int(11) DEFAULT '0',
53 `activity_points` int(11) DEFAULT '5000',
54 `look` char(255) DEFAULT NULL,
55 `gender` enum('M','F') DEFAULT 'M',
56 `motto` char(50) DEFAULT NULL,
57 `account_created` float DEFAULT '0',
58 `last_online` int(11) DEFAULT '0',
59 `online` enum('0','1') DEFAULT '0',
60 `ip_last` varchar(45) DEFAULT '',
61 `ip_reg` varchar(45) DEFAULT NULL,
62 `home_room` int(10) DEFAULT '0',
63 `is_muted` enum('0','1') DEFAULT '0',
64 `block_newfriends` enum('0','1') DEFAULT '0',
65 `hide_online` enum('0','1') DEFAULT '0',
66 `hide_inroom` enum('0','1') DEFAULT '0',
67 `vip` enum('0','1') DEFAULT '0',
68 `volume` varchar(15) DEFAULT '100,100,100',
69 `last_change` int(20) DEFAULT '0',
70 `machine_id` varchar(125) DEFAULT '',
71 `focus_preference` enum('0','1') DEFAULT '0',
72 `chat_preference` enum('0','1') DEFAULT '0',
73 `pets_muted` enum('0','1') DEFAULT '0',
74 `bots_muted` enum('0','1') DEFAULT '0',
75 `advertising_report_blocked` enum('0','1') DEFAULT '0',
76 `gotw_points` int(11) DEFAULT '0',
77 `ignore_invites` enum('0','1') DEFAULT '0',
78 `time_muted` double DEFAULT '0',
79 `allow_gifts` enum('0','1') DEFAULT '1',
80 `trading_locked` double DEFAULT '0',
81 `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
82 `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
83 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
84 `rangovandeweek` enum('1','0') CHARACTER SET utf8 DEFAULT '0',
85 `staff_sinds` text,
86 `rank_lijst` text CHARACTER SET utf8,
87 `bcrypt_on` enum('1','0') CHARACTER SET utf8 DEFAULT '1',
88 `rank_name` text CHARACTER SET utf8,
89 `team` int(10) DEFAULT NULL,
90 `staff_mail` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
91 `rankup` mediumtext CHARACTER SET utf8,
92 `spam` int(6) NOT NULL DEFAULT '0',
93 `jetons` int(6) NOT NULL DEFAULT '0',
94 `fonction` varchar(100) NOT NULL DEFAULT 'Utilisateur normal',
95 `last_offline` double NOT NULL,
96 `disabled` int(6) NOT NULL,
97 `hote_id` int(11) NOT NULL,
98 `avatars` int(11) NOT NULL DEFAULT '49',
99 PRIMARY KEY (`id`),
100 UNIQUE KEY `id` (`id`) USING HASH,
101 UNIQUE KEY `username` (`username`) USING BTREE,
102 KEY `rank` (`rank`),
103 KEY `ip_last` (`ip_last`),
104 KEY `ip_reg` (`ip_reg`),
105 KEY `credits` (`credits`),
106 KEY `activity_points` (`activity_points`),
107 KEY `online` (`online`),
108 KEY `mail` (`mail`),
109 KEY `machine_id` (`machine_id`),
110 KEY `auth_ticket` (`auth_ticket`),
111 KEY `last_online` (`last_online`),
112 KEY `home_room` (`home_room`),
113 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
114) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=648 ;
115
116--
117-- Contenu de la table `users`
118--
119
120INSERT 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`, `spam`, `jetons`, `fonction`, `last_offline`, `disabled`, `hote_id`, `avatars`) VALUES
121(1, 'Khamsa', '7bc3c892a1781f389db3b6d496b43645c7798870', 'Ramsa@tabbo.fr', '98cad19b-eca8-6495-3d9d-fd21dfe135c7', 10, 0, 111993, 0, 0, 66349, 'sh-300-92.lg-3407-108-64.ch-3110-108-64.hr-3247-1403.hd-180-3', 'M', 'Met nous du rose du San Pellegrino', 22, 11, '0', '90.113.117.213', NULL, 0, '0', '0', '0', '0', '0', '100,100,100', 0, '~e0d63e33a75684a23c1b52cb025464f8', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '1', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, 10, 'Grand roi de Tabbo', 3, 0, 0, 49),
122(619, 'Barksdale', '18b22b7988a79ae3b2abf9a67db90ec332b41959', 'djdddjr@live.fr', '2f0fc2e9-34d6-88ea-0ade-08a699abdedd', 9, 0, 68045, 0, 0, 28328, 'hd-600-3.lg-3057-1338.ch-3013-1408.hr-3012-32.sh-3035-1408.ea-3168-1408.wa-2003-63', 'F', 'Manager de l''hôtel', 4, 11, '0', '79.93.22.204', NULL, 0, '0', '0', '0', '0', '0', '46,45,46', 0, '~669e5c468b2856d48b3e163059411dce', '0', '0', '0', '0', '0', 0, '0', 0, '1', 0, '0', '0', '1', '0', NULL, NULL, '1', NULL, NULL, NULL, NULL, 0, 0, 'Administrateur général', 0, 0, 0, 49),
123(634, 'yankee', 'bf313879b36906d834a999f87a6fbd9eff5f8b46', 'sdefrgth@gmail.com', '', 1, 0, 100000, 0, 0, 5000, 'sh-735-92.lg-705-1195.hd-600-3.ch-665-62.hr-9534-34', 'F', 'Bienvenue sur Tabbo Hotel!', 2, 0, '0', '88.187.26.206', NULL, 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, 0, 0, 'Utilisateur normal', 0, 0, 0, 49),
124(635, 'Traxmix', 'e67ab1c94c9a322f906ee72af151a70bd76b5ac3', 'dfasfasf@gmail.com', '6fba8fd3-1706-ed5e-7f85-3e6739fcf1ac', 8, 0, 100000, 0, 0, 5000, 'ch-3323-90-153638.fa-1206-153638.ha-33821-153640-153638.hr-3256-44-158639.lg-6907-64.wa-3211-91-66.hd-3095-156627.ea-3108-153638-153638', 'M', 'Qui ne se gene pas, gene autrui.', 2, 0, '0', '93.23.51.47', NULL, 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, 0, 0, 'Hôtel Manager', 0, 0, 0, 49),
125(637, 'bhn3xak', 'bhn3xak', 'bhn3xak@anonwar-stresser.xyz', '8557f2af9ea96405757f2af9ea9680657f2af9ea96bc', 1, 0, 9000000, 0, 0, 2, 'hr-135-41.hd-207-22.ch-877-75.lg-285-69.sh-290-74.he-1610-.ea-1401-1315.fa-1204-.wa-2009-80', 'M', '', 1475520000, 0, '0', '212.83.147.226', '212.83.147.226', 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, 0, 0, 'Utilisateur normal', 1475522451, 0, 0, 49),
126(638, 'Lucas', 'aseft33', 'Lucas75016@gouv.fr', '7757f2b0cfc5ed62657f2b0cfc5f152557f2b0cfc5f52', 1, 0, 9000000, 0, 0, 2, 'hd-208-30.ch-877-91.lg-280-79.sh-290-76.ha-1020-.fa-1210-.wa-2008-', 'M', '', 1475520000, 0, '0', '78.250.66.164', '78.250.66.164', 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, 0, 0, 'Utilisateur normal', 1475522457, 0, 0, 49),
127(639, 'A2stro', 'aqwaqw', 'aqaa@gmail.com', '9157f2b07cd0c0c3457f2b07cd0c4c3157f2b07cd0c88', 1, 0, 9000000, 0, 0, 2, 'hd-190-19.ch-809-100.lg-281-67.sh-906-105.ha-1010-66.ea-1402-.fa-1205-1315.ca-1802-', 'M', '', 1475520000, 0, '0', '103.10.197.218', '103.10.197.218', 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, 0, 0, 'Utilisateur normal', 1475522480, 0, 0, 49),
128(640, 'GameShot', 'thomasmorelon57', 'thomas572004@gmail.com', '3557f2b0d7c36d98957f2b0d7c37178057f2b0d7c3753', 1, 0, 9000000, 0, 0, 2, 'hr-889-34.hd-180-23.ch-235-1315.lg-275-89.sh-290-76.ea-1406-.ca-1802-', 'M', '', 1475520000, 0, '0', '78.251.140.26', '78.251.140.26', 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, 0, 0, 'Utilisateur normal', 1475522756, 0, 0, 49),
129(641, 'yamine-', 'testtest', 'ssssss@sss.fr', '1357f2b0f6019ef957f2b0f601a2e3057f2b0f601a6a', 1, 0, 9000000, 0, 0, 2, 'hd-195-19.ch-262-103.lg-281-88.sh-906-89.ha-1005-96.fa-1210-.ca-1811-.wa-2004-94', 'M', '', 1475520000, 0, '0', '89.92.230.177', '89.92.230.177', 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, 0, 0, 'Utilisateur normal', 1475522780, 0, 0, 49),
130(642, 'ScrewMonGars', 'xdxdxd', 'ScrewMonGars@gmail.com', '5257f2b1239b1283457f2b1239b1682257f2b1239b1b1', 1, 0, 9000000, 0, 0, 2, 'hr-889-34.hd-185-16.ch-220-81.lg-280-66.sh-905-63.ha-1021-78.he-1602-68.ea-1401-65.fa-1211-.ca-1812-.wa-2004-64', 'M', '', 1475520000, 0, '0', '107.178.38.167', '107.178.38.167', 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, 0, 0, 'Utilisateur normal', 1475522836, 0, 0, 49),
131(643, 'Abek', 'annateresa', 'wallacer.de@gmail.com', '4157f2b16330c97857f2b16330cd59857f2b16330d12', 1, 0, 9000000, 0, 0, 2, 'hr-892-33.hd-185-29.ch-230-78.lg-275-65.sh-906-78.ha-1001-.ea-1404-63', 'M', '', 1475520000, 0, '0', '2.33.115.73', '2.33.115.73', 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, 0, 0, 'Utilisateur normal', 1475522886, 0, 0, 49),
132(644, 'JTEROULEDSSUS', 'omasse13', 'dtf@gmail.com', '357f2b35c38bc87457f2b35c38c082557f2b35c38c45', 1, 0, 9000000, 0, 0, 2, 'hr-893-35.hd-180-9.ch-235-64.lg-270-66.sh-295-73.ha-1014-.he-1610-.ea-1403-90', 'M', '', 1475520000, 0, '0', '90.57.127.127', '90.57.127.127', 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, 0, 0, 'Utilisateur normal', 1475523096, 0, 0, 49),
133(645, 'Michel', 'test123', 'drkuio@l.fr', '8557f2b6e9c61a9357f2b6e9c61e79957f2b6e9c6220', 1, 0, 9000000, 0, 0, 2, 'hr-831-51.hd-200-4.ch-265-108.lg-285-92.sh-300-89.ha-1018-.fa-1201-.ca-1815-88', 'M', '', 1475520000, 0, '0', '5.196.73.86', '5.196.73.86', 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, 0, 0, 'Utilisateur normal', 1475524320, 0, 0, 49),
134(646, 'ChapoDePaille', 'a2728e41b1028e95e557b5cb880fdd4291969372', 'dqffdsqfqds@live.fr', '6f06aa8e-0195-f16f-b091-8f741e2bf08a', 1, 0, 100000, 0, 0, 5000, 'lg-275-1195.ca-1802-62.ch-235-81.hr-831-1061.ha-3026-1195.sh-3016-1195.hd-180-3', 'M', 'Bienvenue sur Tabbo Hotel!', 3, 0, '0', '90.113.117.213', NULL, 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, 0, 0, 'Utilisateur normal', 3, 0, 0, 49),
135(647, 'SanMa', 'erwine', 'sleide29@gmail.com', NULL, 1, 0, 9000000, 0, 0, 2, 'sh-295-62.hr-831-45.ch-215-92.hd-180-3.lg-280-64', 'M', '', 1475530000, 0, '0', '78.231.218.42', '78.231.218.42', 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, 0, 0, 'Utilisateur normal', 1475525762, 0, 0, 49);
136
137/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
138/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
139/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;