· 9 years ago · Oct 03, 2016, 04:56 AM
1.__ __ .___ ___.
2| |__ _____ ____ | | __ ____ __| _/ \_ |__ ___.__.
3| | \\__ \ _/ ___\| |/ // __ \ / __ | | __ < | |
4| Y \/ __ \\ \___| <\ ___// /_/ | | \_\ \___ |
5|___| (____ /\___ >__|_ \\___ >____ | |___ / ____|
6 \/ \/ \/ \/ \/ \/ \/\/
7
8___. .__ ________ __ _____
9\_ |__ | |__ ____ \_____ \___ ________ | | __ / _ \ ____ ____ ______ _ _______ _______
10 | __ \| | \ / \ _(__ <\ \/ /\__ \ | |/ / / /_\ \ / \ / _ \ / \ \/ \/ /\__ \\_ __ \
11 | \_\ \ Y \ | \/ \> < / __ \| < / | \ | ( <_> ) | \ / / __ \| | \/
12 |___ /___| /___| /______ /__/\_ \(____ /__|_ \ \____|__ /___| /\____/|___| /\/\_/ (____ /__|
13 \/ \/ \/ \/ \/ \/ \/ \/ \/ \/ \/
14
15
16-- phpMyAdmin SQL Dump
17-- version 4.1.14
18-- http://www.phpmyadmin.net
19--
20-- Client : db1.free-h.org
21-- Généré le : Lun 03 Octobre 2016 à 06:48
22-- Version du serveur : 5.5.34-MariaDB-1~wheezy
23-- Version de PHP : 5.5.30-1~dotdeb+7.1
24
25SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
26SET time_zone = "+00:00";
27
28
29/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
30/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
31/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
32/*!40101 SET NAMES utf8 */;
33
34--
35-- Base de données : `freeh_db_90279`
36--
37
38-- --------------------------------------------------------
39
40--
41-- Structure de la table `users`
42--
43
44CREATE TABLE IF NOT EXISTS `users` (
45 `id` int(11) NOT NULL AUTO_INCREMENT,
46 `username` varchar(125) NOT NULL,
47 `password` varchar(255) DEFAULT NULL,
48 `mail` varchar(255) DEFAULT 'defaultuser@meth0d.org',
49 `auth_ticket` varchar(60) DEFAULT NULL,
50 `rank` int(1) unsigned DEFAULT '1',
51 `rank_vip` int(1) DEFAULT '0',
52 `credits` int(11) DEFAULT '50000',
53 `vip_points` int(11) DEFAULT '0',
54 `activity_points` int(11) DEFAULT '5000',
55 `look` char(255) DEFAULT NULL,
56 `gender` enum('M','F') DEFAULT 'M',
57 `motto` char(50) DEFAULT NULL,
58 `account_created` float DEFAULT '0',
59 `last_online` int(11) DEFAULT '0',
60 `online` enum('0','1') DEFAULT '0',
61 `ip_last` varchar(45) DEFAULT '',
62 `ip_reg` varchar(45) DEFAULT NULL,
63 `home_room` int(10) DEFAULT '0',
64 `is_muted` enum('0','1') DEFAULT '0',
65 `block_newfriends` enum('0','1') DEFAULT '0',
66 `hide_online` enum('0','1') DEFAULT '0',
67 `hide_inroom` enum('0','1') DEFAULT '0',
68 `vip` enum('0','1') DEFAULT '0',
69 `volume` varchar(15) DEFAULT '100,100,100',
70 `last_change` int(20) DEFAULT '0',
71 `machine_id` varchar(125) DEFAULT '',
72 `focus_preference` enum('0','1') DEFAULT '0',
73 `chat_preference` enum('0','1') DEFAULT '0',
74 `pets_muted` enum('0','1') DEFAULT '0',
75 `bots_muted` enum('0','1') DEFAULT '0',
76 `advertising_report_blocked` enum('0','1') DEFAULT '0',
77 `gotw_points` int(11) DEFAULT '0',
78 `ignore_invites` enum('0','1') DEFAULT '0',
79 `time_muted` double DEFAULT '0',
80 `allow_gifts` enum('0','1') DEFAULT '1',
81 `trading_locked` double DEFAULT '0',
82 `friend_bar_state` enum('0','1') NOT NULL DEFAULT '1',
83 `disable_forced_effects` enum('0','1') NOT NULL DEFAULT '0',
84 `allow_mimic` enum('1','0') NOT NULL DEFAULT '1',
85 `rangovandeweek` enum('1','0') CHARACTER SET utf8 DEFAULT '0',
86 `staff_sinds` text,
87 `rank_lijst` text CHARACTER SET utf8,
88 `bcrypt_on` enum('1','0') CHARACTER SET utf8 DEFAULT '1',
89 `rank_name` text CHARACTER SET utf8,
90 `team` int(10) DEFAULT NULL,
91 `staff_mail` varchar(50) CHARACTER SET utf8 DEFAULT NULL,
92 `rankup` mediumtext CHARACTER SET utf8,
93 `disabled` int(6) NOT NULL DEFAULT '0',
94 `last_offline` varchar(25) CHARACTER SET latin1 COLLATE latin1_general_ci NOT NULL,
95 `spam` int(6) NOT NULL DEFAULT '0',
96 `jetons` int(6) NOT NULL DEFAULT '0',
97 `fonction` varchar(100) NOT NULL DEFAULT 'Utilisateur normal',
98 PRIMARY KEY (`id`),
99 UNIQUE KEY `id` (`id`) USING HASH,
100 UNIQUE KEY `username` (`username`) USING BTREE,
101 KEY `rank` (`rank`),
102 KEY `ip_last` (`ip_last`),
103 KEY `ip_reg` (`ip_reg`),
104 KEY `credits` (`credits`),
105 KEY `activity_points` (`activity_points`),
106 KEY `online` (`online`),
107 KEY `mail` (`mail`),
108 KEY `machine_id` (`machine_id`),
109 KEY `auth_ticket` (`auth_ticket`),
110 KEY `last_online` (`last_online`),
111 KEY `home_room` (`home_room`),
112 KEY `messenger` (`id`,`username`,`look`,`motto`,`last_online`) USING BTREE
113) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=636 ;
114
115--
116-- Contenu de la table `users`
117--
118
119INSERT INTO `users` (`id`, `username`, `password`, `mail`, `auth_ticket`, `rank`, `rank_vip`, `credits`, `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`, `disabled`, `last_offline`, `spam`, `jetons`, `fonction`) VALUES
120(1, 'Khamsa', '7bc3c892a1781f389db3b6d496b43645c7798870', 'Ramsa@tabbo.fr', '7d9e560f-635d-e95c-b279-188563872dfa', 10, 0, 111993, 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, '03-10-2016 02:50:14', 0, 10, 'Grand roi de Tabbo'),
121(619, 'Barksdale', '18b22b7988a79ae3b2abf9a67db90ec332b41959', 'djdddjr@live.fr', '3c9cd438-ce31-8707-6bf3-9eb2ed0e08f9', 9, 0, 68045, 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, '02-10-2016 18:33:39', 0, 0, 'Administrateur général'),
122(634, 'yankee', 'bf313879b36906d834a999f87a6fbd9eff5f8b46', 'sdefrgth@gmail.com', '', 1, 0, 100000, 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, '02-10-2016 00:29:07', 0, 0, 'Utilisateur normal'),
123(635, 'Traxmix', 'e67ab1c94c9a322f906ee72af151a70bd76b5ac3', 'dfasfasf@gmail.com', '205429d6-e1fc-5c97-916a-6929b6f93f6f', 8, 0, 100000, 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, '02-10-2016 17:37:01', 0, 0, 'Hôtel Manager');
124
125/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
126/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
127/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;