Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- /*
- VileHCF XF_User Table released 10/15/16
- Hacked by: @Jihadi4prez
- Reason: 13 year olds shouldn't try running xenforo/msql.
- */
- -- phpMyAdmin SQL Dump
- -- version 4.0.10.14
- -- http://www.phpmyadmin.net
- --
- -- Host: localhost:3306
- -- Generation Time: Oct 15, 2016 at 09:06 PM
- -- Server version: 5.6.33
- -- PHP Version: 5.6.20
- SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
- SET time_zone = "+00:00";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `vilehcfc_xenforo`
- --
- -- --------------------------------------------------------
- --
- -- Table structure for table `xf_user`
- --
- CREATE TABLE IF NOT EXISTS `xf_user` (
- `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `username` varchar(50) NOT NULL,
- `email` varchar(120) NOT NULL,
- `gender` enum('','male','female') NOT NULL DEFAULT '' COMMENT 'Leave empty for ''unspecified''',
- `custom_title` varchar(50) NOT NULL DEFAULT '',
- `language_id` int(10) unsigned NOT NULL,
- `style_id` int(10) unsigned NOT NULL COMMENT '0 = use system default',
- `timezone` varchar(50) NOT NULL COMMENT 'Example: ''Europe/London''',
- `visible` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT 'Show browsing activity to others',
- `activity_visible` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `user_group_id` int(10) unsigned NOT NULL,
- `secondary_group_ids` varbinary(255) NOT NULL,
- `display_style_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User group ID that provides user styling',
- `permission_combination_id` int(10) unsigned NOT NULL,
- `message_count` int(10) unsigned NOT NULL DEFAULT '0',
- `conversations_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
- `register_date` int(10) unsigned NOT NULL DEFAULT '0',
- `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
- `trophy_points` int(10) unsigned NOT NULL DEFAULT '0',
- `alerts_unread` smallint(5) unsigned NOT NULL DEFAULT '0',
- `avatar_date` int(10) unsigned NOT NULL DEFAULT '0',
- `avatar_width` smallint(5) unsigned NOT NULL DEFAULT '0',
- `avatar_height` smallint(5) unsigned NOT NULL DEFAULT '0',
- `gravatar` varchar(120) NOT NULL DEFAULT '' COMMENT 'If specified, this is an email address corresponding to the user''s ''Gravatar''',
- `user_state` enum('valid','email_confirm','email_confirm_edit','moderated','email_bounce') NOT NULL DEFAULT 'valid',
- `is_moderator` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `is_admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `is_banned` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `like_count` int(10) unsigned NOT NULL DEFAULT '0',
- `warning_points` int(10) unsigned NOT NULL DEFAULT '0',
- `is_staff` tinyint(3) unsigned NOT NULL DEFAULT '0',
- PRIMARY KEY (`user_id`),
- UNIQUE KEY `username` (`username`),
- KEY `email` (`email`),
- KEY `user_state` (`user_state`),
- KEY `last_activity` (`last_activity`),
- KEY `message_count` (`message_count`),
- KEY `trophy_points` (`trophy_points`),
- KEY `like_count` (`like_count`),
- KEY `register_date` (`register_date`),
- KEY `staff_username` (`is_staff`,`username`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=60 ;
- --
- -- Dumping data for table `xf_user`
- --
- INSERT INTO `xf_user` (`user_id`, `username`, `email`, `gender`, `custom_title`, `language_id`, `style_id`, `timezone`, `visible`, `activity_visible`, `user_group_id`, `secondary_group_ids`, `display_style_group_id`, `permission_combination_id`, `message_count`, `conversations_unread`, `register_date`, `last_activity`, `trophy_points`, `alerts_unread`, `avatar_date`, `avatar_width`, `avatar_height`, `gravatar`, `user_state`, `is_moderator`, `is_admin`, `is_banned`, `like_count`, `warning_points`, `is_staff`) VALUES
- (1, 'Vehqzi', 'vehqzihd@yahoo.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '3,4,5', 3, 12, 35, 0, 1475945634, 1476572897, 8, 0, 1476226504, 192, 192, '', 'valid', 1, 1, 0, 20, 0, 1),
- (2, 'Tracer', 'itsjoelrutherford@gmail.com', '', 'ovrwtch fgt', 1, 0, 'Europe/London', 1, 1, 2, '3,8', 3, 15, 1, 0, 1475952437, 1476558502, 3, 0, 1476407584, 215, 192, '', 'valid', 0, 1, 0, 2, 0, 1),
- (3, 'XenForo', 'jakeissweg61@gmail.com', 'male', 'Manager', 1, 0, 'America/Los_Angeles', 1, 1, 2, '4,6', 6, 14, 40, 1, 1475952784, 1476572200, 8, 0, 1476242002, 336, 192, '', 'valid', 0, 0, 0, 5, 0, 1),
- (4, 'Most', 'white.jadeyn@gmail.com', 'male', 'Manager', 1, 0, 'America/New_York', 1, 1, 2, '6', 6, 10, 6, 0, 1475952870, 1476576014, 3, 0, 1475962647, 192, 227, '', 'valid', 0, 0, 0, 5, 0, 1),
- (5, 'Aden', 'karenshevey@yahoo.com', 'male', '', 1, 0, 'America/Los_Angeles', 1, 1, 2, '', 2, 2, 2, 0, 1475978163, 1476488789, 1, 0, 1475978204, 192, 192, '', 'valid', 0, 0, 0, 0, 1, 0),
- (6, 'Luke020', 'bigduke019@gmail.com', 'male', 'Admin', 1, 0, 'America/Chicago', 1, 1, 2, '10', 10, 17, 5, 0, 1475984042, 1476510464, 1, 0, 1476319644, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 1),
- (7, 'DoublePotting', 'supwitaids1@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 9, 2, 1475989336, 1476559418, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 1, 0, 0),
- (8, 'i22', 'necjester21@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 34, 0, 1476042560, 1476572649, 8, 0, 1476192371, 256, 192, '', 'valid', 0, 0, 0, 6, 0, 0),
- (9, 'Noot', '73shadesofcod@gmail.com', 'male', 'Trial-Mod', 1, 3, 'America/Los_Angeles', 0, 0, 2, '13', 13, 18, 36, 0, 1476064137, 1476571489, 8, 0, 1476068730, 192, 192, '', 'valid', 0, 0, 0, 10, 0, 1),
- (10, 'Actuality', 'rccraftin@gmail.com', '', '', 1, 0, 'America/Chicago', 0, 1, 2, '', 2, 2, 9, 0, 1476066693, 1476538372, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 1, 0, 0),
- (11, 'Flexxin / FlexinBruh', 'apexstreams@gmail.com', 'male', '', 1, 3, 'America/New_York', 1, 1, 2, '', 2, 2, 4, 0, 1476068047, 1476543716, 3, 0, 1476148283, 192, 248, '', 'valid', 0, 0, 0, 4, 0, 0),
- (12, 'SorryHomie', 'ImmersfulFlame@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476072521, 1476249917, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (13, 'Mantice', 'ManticeBn@gmail.com', 'male', 'Trial-Mod', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '13', 13, 18, 5, 1, 1476122613, 1476552905, 1, 0, 1476164014, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 1),
- (14, 'moonball', 'zylemhc@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476123366, 1476123388, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (15, 'iSipDirtySprite', 'lewigginsjr@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476130310, 1476234345, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (16, 'Touchs', 'max.lanning99@hotmail.com', 'male', 'Trial-Mod', 1, 0, 'Europe/London', 1, 1, 2, '13', 13, 18, 30, 0, 1476131351, 1476563686, 8, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 3, 0, 1),
- (17, 'ActivatinqIzBae', 'mineplex9jason@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 25, 0, 1476136958, 1476555323, 3, 0, 1476228102, 192, 209, '', 'valid', 0, 0, 0, 3, 0, 0),
- (18, 'SOTWHype305', 'tibebujason@gmail.com', 'female', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 5, 1, 1476147185, 1476223890, 3, 5, 1476147255, 192, 192, '', 'valid', 0, 0, 0, 2, 3, 0),
- (19, 'Saltinq', 'michaelkhandani200@gmail.com', 'male', '', 1, 0, 'America/Phoenix', 1, 1, 2, '', 2, 2, 2, 0, 1476223076, 1476333546, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 1, 0, 0),
- (20, 'Cbass', 'sebasdiazl@hotmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 4, 0, 1476223212, 1476229458, 1, 2, 1476225920, 192, 217, '', 'valid', 0, 0, 0, 0, 0, 0),
- (21, 'Case', 'awesomedood56@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 1, 0, 1476226762, 1476457085, 1, 1, 1476226948, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
- (22, 'czxm', 'etern1tyjinx24@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476232427, 1476312055, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (23, 'M65', 'irepulsivehackedacc@Hotmail.com', 'male', 'Trial-Mod', 1, 0, 'America/New_York', 1, 1, 2, '13', 13, 18, 16, 0, 1476241810, 1476562479, 1, 0, 1476477073, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 1),
- (24, 'Kezeurex', 'ojc2003vsgaming@gmail.com', 'male', '', 1, 0, 'Asia/Bangkok', 1, 1, 2, '', 2, 2, 18, 1, 1476242735, 1476547790, 1, 1, 1476420613, 278, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
- (25, 'InmortalPvPz', 'wvo28@hotmail.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 1, 0, 1476275096, 1476277746, 1, 4, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (26, 'GlawkInMyRawry', 'electralpvp@icloud.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476279289, 1476279326, 1, 3, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (27, 'Hausik', 'hausikhskah@gmail.com', 'male', '', 1, 0, 'Africa/Algiers', 1, 1, 2, '', 2, 2, 2, 0, 1476285235, 1476452178, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (28, 'Kvnye', 'ndndnd@hotmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476289972, 1476290033, 1, 3, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (29, 'KravePvP', 'canny99@hotmail.co.uk', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 0, 0, 1476290049, 1476536833, 0, 1, 1476299421, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
- (30, 'AirJitter1', 'airjitter@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476290081, 1476290111, 1, 2, 0, 0, 0, '', 'valid', 0, 1, 0, 0, 0, 0),
- (31, 'Justin', 'jberube8881@aol.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 8, 0, 1476297045, 1476569809, 1, 0, 1476307487, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
- (32, 'Petteqh', 'scoobypetter@gmail.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 3, 0, 1476297217, 1476386920, 3, 3, 1476297281, 256, 192, '', 'valid', 0, 0, 0, 1, 0, 0),
- (33, 'FIlleJr', 'minefille@hotmail.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 9, 0, 1476297413, 1476510695, 3, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 1, 0, 0),
- (34, 'SlizzArn', 'OliverPrivate@outlook.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1476297746, 1476371734, 0, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (35, 'Arad', 'arad_niaki@yahoo.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 2, 0, 1476305439, 1476554965, 3, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 2, 0, 0),
- (36, 'STRATEX', 'stratexofficial@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476315627, 1476315709, 0, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (37, 'boogieboards', 'beckleyashley541@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476414713, 1476414891, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (38, 'EzBann', 'djcrunchbizness@gmail.com', 'male', '', 1, 0, 'America/Los_Angeles', 1, 1, 2, '', 2, 2, 4, 0, 1476422217, 1476499894, 3, 2, 1476423241, 256, 192, '', 'valid', 0, 0, 0, 1, 0, 0),
- (39, 'ProxiiBlade', 'Deluxe-MC@outlook.com', 'male', '', 1, 0, 'Europe/Amsterdam', 1, 1, 2, '', 2, 2, 0, 0, 1476464011, 1476547812, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (41, 'StayBaked', 'samblake01@gmail.com', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 1, 0, 1476476601, 1476476652, 1, 1, 1476476617, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
- (42, 'LGE', 'only300fps@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476477642, 1476477686, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (43, 'YaBoiJItters', 'viralzova@yahoo.com', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 4, 0, 1476486288, 1476564566, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (44, 'Pottinqq', 'nathan007111@gmail.com', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 1, 0, 1476487685, 1476544171, 1, 0, 1476488169, 100, 100, '', 'valid', 0, 0, 0, 0, 0, 0),
- (45, '_Demote', 'demotemc@outlook.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 8, 0, 1476493901, 1476561991, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (46, 'Ballinhh', 'altingxx@gmail.com', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 0, 0, 1476526411, 1476526602, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (47, 'ImClienting', 'bheekharryfaiz@yahoo.com', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 4, 0, 1476526948, 1476570144, 1, 2, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (48, 'comboofly', 'mahmoudbahgat89@yahoo.com', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 1, 0, 1476535232, 1476536536, 1, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (49, 'LivenLikeLarry', 'nick4hokiesyt@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 4, 0, 1476538704, 1476570784, 3, 0, 1476538769, 256, 192, '', 'valid', 0, 0, 0, 1, 0, 0),
- (50, 'Jacob', 'h2774189@mvrht.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476538894, 1476539271, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (51, 'DietBleach', 'jacobt333@icloud.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476542604, 1476542676, 1, 2, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (52, 'Obivius', 'juanjtorres619@hotmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476552871, 1476552881, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (53, 'Alchemist', 'joshuahardcastle11@gmail.com', 'male', '', 1, 0, 'America/Los_Angeles', 1, 1, 2, '', 2, 2, 2, 0, 1476562015, 1476570080, 1, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (54, 'Frozqn', 'burleighisaiah@gmail.com', 'male', '', 1, 0, 'America/Chicago', 1, 1, 2, '', 2, 2, 0, 0, 1476562194, 1476562753, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (55, 'SSKid', 'acrewsgator15@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476564559, 1476564746, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (56, 'iPotionPvPz', 'tutlepvpz@gmail.com', 'male', '', 1, 0, 'America/Los_Angeles', 1, 1, 2, '', 2, 2, 2, 0, 1476564940, 1476570225, 1, 0, 1476566027, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
- (57, 'Leaving', 'sonic74419@gmail.com', 'male', '', 1, 0, 'Europe/London', 1, 1, 2, '', 2, 2, 2, 0, 1476569842, 1476572723, 1, 2, 1476571903, 192, 192, '', 'valid', 0, 0, 0, 0, 0, 0),
- (58, 'AntiPoke', 'drfrosty1@gmail.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 1, 0, 1476569869, 1476572094, 1, 1, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0),
- (59, 'Jihadi', 'h2816911@mvrht.com', 'male', '', 1, 0, 'America/New_York', 1, 1, 2, '', 2, 2, 0, 0, 1476572049, 1476575531, 0, 0, 0, 0, 0, '', 'valid', 0, 0, 0, 0, 0, 0);
- /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
- /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
- /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement