Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ____ ____ __ _________ __ __ __________________ ________ __________ __ __________
- / __ \/ __ ) / / / ____/ | / //_/ / ____/ ____/_ __/ / ____/ / / / ____/ //_// ____/ __ \
- / / / / __ | / / / __/ / /| | / ,< / / __/ __/ / / / /_ / / / / / / ,< / __/ / / / /
- / /_/ / /_/ / / /___/ /___/ ___ |/ /| | / /_/ / /___ / / / __/ / /_/ / /___/ /| |/ /___/ /_/ /
- /_____/_____/ /_____/_____/_/ |_/_/ |_| \____/_____/ /_/ /_/ \____/\____/_/ |_/_____/_____/
- -- Adminer 3.3.3 MySQL dump
- SET NAMES utf8;
- SET foreign_key_checks = 0;
- SET time_zone = 'SYSTEM';
- SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';
- DROP TABLE IF EXISTS `banned_ips`;
- CREATE TABLE `banned_ips` (
- `ID` int(11) NOT NULL,
- `ips_banned` varchar(255) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `bans`;
- CREATE TABLE `bans` (
- `ID` int(11) NOT NULL AUTO_INCREMENT,
- `Moderator` char(12) NOT NULL,
- `Player` int(11) unsigned NOT NULL,
- `Comment` text NOT NULL,
- `Expiration` int(8) NOT NULL,
- `Time` int(8) NOT NULL,
- `Type` smallint(3) unsigned NOT NULL,
- PRIMARY KEY (`ID`),
- UNIQUE KEY `Time` (`Time`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `friends`;
- CREATE TABLE `friends` (
- `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `Accepted` text NOT NULL,
- `Requests` text NOT NULL,
- `Besties` text NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `igloos`;
- CREATE TABLE `igloos` (
- `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `Owner` int(10) unsigned NOT NULL,
- `Type` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `Floor` tinyint(3) unsigned NOT NULL DEFAULT '0',
- `Music` smallint(6) NOT NULL DEFAULT '0',
- `Furniture` longtext NOT NULL,
- `Locked` tinyint(1) NOT NULL DEFAULT '1',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `igloos` (`ID`, `Owner`, `Type`, `Floor`, `Music`, `Furniture`, `Locked`) VALUES
- (415, 394, 1, 0, 0, '', 1),
- (416, 395, 1, 0, 0, '', 1),
- (417, 396, 1, 0, 0, '', 1),
- (418, 397, 1, 0, 120, '116|403|239|1|1', 1),
- (419, 398, 1, 0, 0, '', 1),
- (420, 399, 1, 0, 0, '', 1),
- (421, 400, 1, 0, 0, '', 1),
- (422, 401, 1, 0, 0, '', 1),
- (423, 402, 1, 0, 0, '', 1),
- (424, 403, 1, 0, 0, '', 1),
- (425, 404, 1, 0, 0, '', 1),
- (426, 405, 1, 0, 0, '', 1),
- (427, 406, 1, 0, 0, '', 1),
- (428, 407, 1, 0, 0, '', 1),
- (429, 408, 1, 0, 0, '', 1),
- (430, 409, 1, 0, 0, '', 1),
- (431, 410, 1, 0, 0, '', 1),
- (432, 411, 1, 0, 0, '', 1),
- (433, 412, 1, 0, 0, '', 1),
- (434, 413, 1, 0, 0, '', 1),
- (435, 414, 38, 0, 235, '810|370|356|1|2,117|381|368|1|2,640|380|175|2|2,452|556|324|1|1,452|204|324|1|1,418|378|214|2|2,14|381|441|1|7,596|655|77|3|4,596|100|79|1|4,596|653|122|3|4,596|101|122|1|4,596|376|175|2|5', 1),
- (436, 415, 1, 0, 0, '', 1),
- (437, 416, 1, 0, 0, '', 1),
- (438, 417, 1, 0, 0, '', 1),
- (439, 418, 1, 0, 0, '', 1),
- (440, 419, 1, 0, 0, '', 1),
- (441, 420, 1, 0, 0, '', 1),
- (442, 421, 1, 0, 0, '', 1),
- (443, 422, 1, 0, 0, '', 1),
- (444, 423, 1, 0, 0, '', 1),
- (445, 424, 1, 0, 0, '', 1);
- DROP TABLE IF EXISTS `penguins`;
- CREATE TABLE `penguins` (
- `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `Username` char(16) NOT NULL,
- `Nickname` char(16) NOT NULL,
- `Password` varchar(255) NOT NULL,
- `Avatar` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT 'Don''t think ID will go beyond 255',
- `AvatarAttributes` char(98) NOT NULL DEFAULT '{"spriteScale":100,"spriteSpeed":100,"ignoresBlockLayer":false,"invisible":false,"floating":false}',
- `Email` char(254) NOT NULL,
- `RegistrationDate` int(8) NOT NULL,
- `Moderator` tinyint(1) NOT NULL DEFAULT '0',
- `Inventory` longtext NOT NULL,
- `CareInventory` text NOT NULL,
- `Coins` mediumint(7) unsigned NOT NULL DEFAULT '5000',
- `Igloo` int(10) unsigned NOT NULL DEFAULT '1' COMMENT 'Current active igloo',
- `Igloos` longtext NOT NULL COMMENT 'Owned igloo types',
- `Floors` longtext NOT NULL COMMENT 'Owned floorings',
- `Locations` longtext NOT NULL COMMENT 'Owned locations',
- `Furniture` longtext NOT NULL COMMENT 'Furniture inventory',
- `Color` tinyint(3) unsigned NOT NULL DEFAULT '1',
- `Head` mediumint(5) unsigned NOT NULL DEFAULT '0',
- `Face` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Neck` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Body` varchar(255) NOT NULL DEFAULT '0',
- `Hand` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Feet` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Photo` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Flag` mediumint(5) unsigned NOT NULL DEFAULT '0',
- `Walking` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Puffle ID',
- `Banned` varchar(20) NOT NULL DEFAULT '0' COMMENT 'Timestamp of ban',
- `Stamps` text NOT NULL,
- `StampBook` varchar(150) NOT NULL DEFAULT '1%1%1%1',
- `EPF` varchar(9) NOT NULL DEFAULT '0,0,0',
- `Buddies` text NOT NULL,
- `Ignores` text NOT NULL,
- `MinutesPlayed` int(11) NOT NULL DEFAULT '0',
- `LastPaycheck` int(11) NOT NULL DEFAULT '0',
- `Active` int(1) NOT NULL DEFAULT '1',
- `IP` varchar(5) NOT NULL DEFAULT '0',
- `Redeemed` varchar(255) NOT NULL,
- `NinjaBelt` int(11) NOT NULL DEFAULT '0',
- `NinjaPercentage` int(11) NOT NULL DEFAULT '0',
- `PuffleQuest` varchar(25) NOT NULL DEFAULT '0,1,|0;0;1403959119;',
- `Rank` int(1) NOT NULL DEFAULT '1',
- `halloweenmsg` varchar(255) NOT NULL DEFAULT '0,0,0,0,0',
- `halloweenquest` varchar(255) NOT NULL DEFAULT '0,0,0,0,0,0,0,0',
- `halloweenvisited` varchar(255) NOT NULL DEFAULT '0',
- `transformation` text NOT NULL,
- `Tracks` text NOT NULL,
- `invalidLogins` text NOT NULL,
- `LoginKey` char(32) NOT NULL,
- `ConfirmationHash` char(32) NOT NULL,
- `hackedItem` text NOT NULL,
- `nameglow` varchar(8) NOT NULL,
- `nameglowstrength` varchar(10) NOT NULL,
- `bubblecolor` varchar(8) NOT NULL,
- `bubbletext` varchar(8) NOT NULL,
- `ringcolor` varchar(8) NOT NULL,
- `speed` tinyint(3) NOT NULL,
- `walls` tinyint(1) NOT NULL,
- `snowball` varchar(8) NOT NULL,
- `sizex` tinyint(2) NOT NULL,
- `sizey` tinyint(2) NOT NULL,
- `transparency` varchar(8) NOT NULL,
- `rotation` varchar(8) NOT NULL,
- `glitter` varchar(8) NOT NULL,
- `fog` varchar(8) NOT NULL,
- `playercard` varchar(8) NOT NULL,
- `mood` varchar(8) NOT NULL,
- `moodcolor` varchar(8) NOT NULL,
- `headhue` varchar(8) NOT NULL,
- `facehue` varchar(8) NOT NULL,
- `neckhue` varchar(8) NOT NULL,
- `handhue` varchar(8) NOT NULL,
- `bodyhue` varchar(8) NOT NULL,
- `feethue` varchar(8) NOT NULL,
- `iconhue` varchar(8) NOT NULL,
- `eyecolor` varchar(8) NOT NULL,
- `beak` varchar(8) NOT NULL,
- `ringtype` varchar(8) NOT NULL,
- PRIMARY KEY (`ID`),
- UNIQUE KEY `Username` (`Username`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `penguins` (`ID`, `Username`, `Nickname`, `Password`, `Avatar`, `AvatarAttributes`, `Email`, `RegistrationDate`, `Moderator`, `Inventory`, `CareInventory`, `Coins`, `Igloo`, `Igloos`, `Floors`, `Locations`, `Furniture`, `Color`, `Head`, `Face`, `Neck`, `Body`, `Hand`, `Feet`, `Photo`, `Flag`, `Walking`, `Banned`, `Stamps`, `StampBook`, `EPF`, `Buddies`, `Ignores`, `MinutesPlayed`, `LastPaycheck`, `Active`, `IP`, `Redeemed`, `NinjaBelt`, `NinjaPercentage`, `PuffleQuest`, `Rank`, `halloweenmsg`, `halloweenquest`, `halloweenvisited`, `transformation`, `Tracks`, `invalidLogins`, `LoginKey`, `ConfirmationHash`, `hackedItem`, `nameglow`, `nameglowstrength`, `bubblecolor`, `bubbletext`, `ringcolor`, `speed`, `walls`, `snowball`, `sizex`, `sizey`, `transparency`, `rotation`, `glitter`, `fog`, `playercard`, `mood`, `moodcolor`, `headhue`, `facehue`, `neckhue`, `handhue`, `bodyhue`, `feethue`, `iconhue`, `eyecolor`, `beak`, `ringtype`) VALUES
- (394, 'mazzy', 'mazzy', '$2y$12$3Y1V9eSC.mqt.MJ7eTts5.iy2toKdzqqRwfY3C9EFjzxT0CMt4F5W', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'deadlyfire1337@gmail.com', 1507945103, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%405%244%503%214%221', '', 4435, 415, '1', '', '', '', 14, 405, 0, 214, '0', 0, 0, 0, 503, 0, '0', '79,10,', '1%1%1%1', '0,0,0', '399|Derps%401|Emotional', '', 45, 0, 1, '97.84', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (395, 'Jack', 'Jack', '$2y$12$ggpQX3as/pE63CqROLmzWe1NgG0h0CdVmZOleRnZGjFBF0864Y1KK', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'Jack@gmail.com', 1507980198, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 416, '1', '', '', '', 4, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '396|Mario10723%399|Derps', '', 51, 0, 1, '82.8.', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (396, 'Mario10723', 'Mario10723', '$2y$12$0CXG2Q33fYKYfLQIfD5YY.dqhWHgWA5QdD8TyGYrrsxH/jQ0rK51W', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'hakim.ouardi15@gmail.com', 1507980687, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%3144%342%1105%4145%4738%4723%3135%2088%5122%789%9044%1444%2072%609%339%7130%1330%1506%366%5186%2096', '', 388, 417, '1', '', '', '', 14, 1105, 2088, 3135, '4738', 5186, 366, 9044, 7130, 0, '0', '7212,216,206,214,208,', '1%1%1%1', '0,0,0', '397|Angelina%399|Derps%400|test%395|Jack%401|Emotional', '', 116, 0, 1, '105.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (397, 'Angelina', 'Angelina', '$2y$12$i06tBg9tnRi0AWOTRDs4cOlagN8QXmDtJXMcevGhsCBKI/EPKRtDm', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cppsangelina@gmail.com', 1507981043, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%412%221%244%101918171693823%%609%7130%111%112%113%114%110%107%108%103%101%104%106%102%109%105%401%405%403%201%202%203%204%205%206%174%175%13017%5114%353%322%410%265%217%218%7229%%481%120', '', 2378, 418, '1', '', '', '643|1,116|1,115|1', 4, 410, 106, 13017, '265', 5114, 353, 0, 7229, 0, '0', '710,', '1%1%1%1', '0,0,0', '396|Mario10723%402|Greg%403|ReidTJ%401|Emotional%409|Zore%404|Might%410|Andriy%398|Reece%399|Derps%408|Cody%411|Allie%412|Carson%414|Antagonist%415|Andre%416|Waddle%422|Snipe%413|Toxic', '', 805, 0, 1, '86.13', '', 0, 0, '0,1,|0;0;1403959119;', 6, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '0x010101', '3', '0x010101', '0xEE82EE', '0xDA70D6', -1, 1, '', 0, 0, '', '0', 'r', '', '', 'Reece 14', 'r', '75', '', '50', '165', '45', '325', '175', '0xFF34B3', '', ''),
- (398, 'Reece', 'Reece', '$2y$12$IdTXFR.zERd2ZKTxvocBXOPKJkx8BWP3lUEGOcQASMCGlkzH.Qr6u', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cppsreece@gmail.com', 1507981057, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%102%403%401%4468%5021%321%4760%1511%7016%1444%1448%609%412%5046%5047%3140%4751%1502%4749%175%174%13017%5114%', '', 938, 419, '1', '', '', '', 14, 1448, 102, 174, '4468', 5114, 0, 0, 0, 0, '0', '710,9,', '1%1%1%1', '0,0,0', '397|Angelina%399|Derps%408|Cody%411|Allie%414|Antagonist%422|Snipe', '', 279, 0, 1, '92.26', '', 0, 0, '0,1,|0;0;1403959119;', 3, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '0xFF69B4', '4', '0xFF69B4', '0x010101', '0x800080', 10, 1, '', 100, 100, '60', '0', '', 'r', '', '', 'r', '335', '', '320', '155', '50', '', '185', '0x800080', '', '4'),
- (399, 'Derps', 'Derps', '$2y$12$RzRrljXC3.ROc/YDmiZmMu1aHEBIod9HU/iJDRQGx2t4BS7QmaRlm', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'catzplaysyt@gmail.com', 1507984368, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%9008%9081%923%9037%1041%256%353%1105%4145%342%5083%1060%6054%789%403', '', 1604, 420, '1', '', '', '', 12, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7216,206,222,208,212,214,218,228,220,224,226,210,', '4%10%2%2', '0,0,0', '396|Mario10723%395|Jack%401|Emotional%394|mazzy%397|Angelina%398|Reece%408|Cody%411|Allie', '', 104, 0, 1, '71.56', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (401, 'Emotional', 'Emotional', '$2y$12$YU2Wr7Em1Ybf3vMpxY2cTOHC3Nn7QTKE6Zb457DlYHasCE8jQ6dUG', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'itzetchasketch@gmail.com', 1507988038, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%221%102%512%301%106%103%401%404%201%403%405%131%220%408%212%481%244%412%252%219%214%101%503%501%9120', '', 890, 422, '1', '', '', '', 9, 401, 103, 301, '212', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '399|Derps%396|Mario10723%394|mazzy%397|Angelina%409|Zore', '', 51, 0, 1, '107.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (402, 'Greg', 'Greg', '$2y$12$bGHp4LVV65S5lXixbsSRHelEO8weTQcNC7h6j1YRMgTFwXJqZPwdi', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'astonautu@gmail.com', 1507993140, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%408%405%201%219%103%481%212%131%220%4468%2043%4467%4466%489%5031%9120%5131%1106%119%3038%4146', '', 0, 423, '1', '', '', '', 14, 0, 0, 0, '4468', 0, 0, 9120, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 21, 0, 1, '185.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (403, 'ReidTJ', 'ReidTJ', '$2y$12$42ZWUe2r9z4ruitddYPiQuEuIYFdxN103eIqO/pMJmAVs5tkPrB7u', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'reidtj@zoho.com', 1507993313, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%221%401%201%481%301%101%214%403', '', 3650, 424, '1', '', '', '', 14, 403, 101, 214, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 23, 0, 1, '45.26', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (404, 'Might', 'Might', '$2y$12$KTqSKGrRFf69GmTGz/CzIuGtap0uTGgZMRU.tA0JfKGTL9ed9DlDy', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'salih_tu@hotmail.com', 1507993461, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%405%103%301%221%101%102%219%214%106%244%220%131%212%481%201%404%401%403%339%609%5046%5021%701%278%3002%5031', '', 215, 425, '1', '', '', '', 4, 405, 103, 3002, '221', 339, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina%409|Zore', '', 43, 0, 1, '213.3', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (405, 'Camden', 'Camden', '$2y$12$LoWsn.04t77Kx.RdnGWgv.ofJQW.r/onrrtBzHJvquP..aZWQ7i/i', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'nope@nothappening.com', 1507994125, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 426, '1', '', '', '', 3, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 0, 0, 1, '108.1', '', 0, 0, '0,1,|0;0;1403959119;', 5, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (406, 'Jonas', 'Jonas', '$2y$12$RMj9ooMAvE06EL7gDYzbX.cpQXlEEkojnWnzVIu/vMK.rcPcUp/ym', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cptoivo132@gmail.com', 1507994152, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 427, '1', '', '', '', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 2, 0, 1, '45.33', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (407, 'TheLBall', 'TheLBall', '$2y$12$GoZ4b8y7hP9Dd5gq98xxl.9Ps7ws10G2IjOmH4XGCUJTIkZiS.pBa', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'outofmario1000@gmail.com', 1507994197, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%609', '', 5150, 428, '1', '', '', '', 12, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7214,102,93,', '1%1%1%1', '0,0,0', '', '', 10, 0, 1, '74.13', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (408, 'Cody', 'Cody', '$2y$12$RZvbcuzie5aZpm2GzlWST.mX9dVDsa0ODErG7Iej7T8R.IAjX6Beq', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'cody.mindfreak.ryan0@gmail.com', 1507997090, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%4760%1511%4759%1510%6013%103%221%404%7130', '', 2400, 429, '1', '', '', '', 4, 404, 103, 0, '221', 0, 6013, 0, 0, 0, '0', '79,10,', '1%1%1%1', '0,0,0', '397|Angelina%398|Reece%399|Derps%411|Allie', '', 72, 0, 1, '115.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (409, 'Zore', 'Zore', '$2y$12$AH5joNW3T69Q9Xfttk49lugJb8UcwqeWTzcPLxRd120hvjyL6Tbey', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'test@me.com', 1508000625, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%221%131%244%403', '', 3610, 430, '1', '', '', '', 4, 0, 103, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina%401|Emotional%404|Might', '', 55, 0, 1, '174.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (410, 'Andriy', 'Andriy', '$2y$12$/zhiuOTkclNpvF0klINYCOY8yBGVNqmAfwHDtAQx4cfKlCCeQXRxe', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'andriykobondar@gmail.com', 1508015936, 1, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%403%201%404%452%405%401%103%220%131%408%212%481%244%412%252%301%106%219%221%101%214%5021%1444%609', '', 627, 431, '1', '', '', '', 7, 452, 101, 301, '244', 5021, 0, 0, 0, 0, '0', '7214,206,208,68,', '1%1%1%1', '0,0,0', '397|Angelina', '', 54, 0, 1, '75.87', '', 0, 0, '0,1,|0;0;1403959119;', 4, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (412, 'Carson', 'Carson', '$2y$12$nqoetUAjXc8iJPmgcmpkROgRvmx/4fikzoPyKJipu521KQa9cUNrK', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'carsonb714@mailinator.com', 1508031730, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%102%221', '', 4690, 433, '1', '', '', '', 14, 0, 102, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 10, 0, 1, '99.13', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (413, 'Toxic', 'Toxic', '$2y$12$.Y7rHwbV5XGYCddfViyTieU1Ud1dk2CvC7mlTGrUo0BPrQc2/elUC', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'baidjdjaj@gmail.com', 1508055171, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 434, '1', '', '', '', 5, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '422|Snipe', '', 42, 0, 1, '71.72', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (414, 'Antagonist', 'Antagonist', '$2y$12$CTLCtBhNC2QBjRrNqwbozuVzUPsSuu/N.msN8MqEPz3bKRv3BAzLu', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'dylanwyatt003@gmail.com', 1508091516, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%301%405%9120%7130%5074%1444%2072%609%5039%403%408%481%220%106%221%219%214%131%404%711%101%1106%3038%5114%%7016%4749%412%244%102%212%119', '', 0, 435, '1,38', '', '', '810|1,907|1,909|1,43|1,117|1,880|1,415|1,418|1,640|1,155|2,150|1,452|2,14|2,596|5', 1, 404, 106, 301, '212', 220, 0, 0, 7130, 0, '0', '79,10,75,77,82,81,88,84,86,63,64,68,66,65,67,51,', '1%1%1%1', '0,0,0', '397|Angelina%398|Reece', '', 366, 0, 1, '73.23', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (415, 'Andre', 'Andre', '$2y$12$04dzS6shVdsj0RkLNR1BhOQCZSUr.xYdR2QGTtzMTbMy2nSVx7Xve', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', '132revenge132@gmail.com', 1508100292, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%103%221%106%301', '', 4350, 436, '1', '', '', '', 14, 0, 106, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 108, 0, 1, '124.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '0xFFFFFF', '0x0000FF', '', 10, 1, '', 0, 0, '', '', '0x010101', '', '', 'Child Su', '0x0000FF', '', '0', '', '', '25', '', '85', '0xFFFFFF', '', ''),
- (416, 'Waddle', 'Waddle', '$2y$12$gu83cJ34Te7YYqxGb50QI.VrjS1KuU/M4icNyugUZmgteuU6K8ove', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'vicklaborie@gmail.com', 1508257806, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%403%201%401%404%405%103%301%106%214%4760%220%6013%244%101%219%221%9120%489%2043%4467%5131%119%7130', '', 50, 437, '1', '', '', '', 5, 0, 0, 0, '201', 220, 0, 9120, 7130, 0, '0', '7', '1%1%1%1', '0,0,0', '397|Angelina', '', 11, 0, 1, '78.11', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (417, 'Zerm', 'Zerm', '$2y$12$eZ1Z33wqRm77HT.JVWdlPur3X8JmXGLzJ89FGP48UHJ18CPTg6cKW', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'otherbergteam@gmail.com', 1508283044, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%405%404%103%131%221%101%214%102%244%106%401%212', '', 3140, 438, '1', '', '', '', 4, 404, 131, 214, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 33, 0, 1, '68.10', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (418, 'Walter', 'Walter', '$2y$12$ApJSvPMZ5JClobiEHnFxe.7LqkwNw2ptgWp8gO/B5utGtdJfjb.oG', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'fakeemailol@fake.com', 1508289322, 5, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%101918171693823\r\n%101%402%292%221', '', 4500, 439, '1', '', '', '', 14, 0, 101, 0, '221', 0, 0, 0, 16777215, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 126, 0, 1, '173.2', '', 0, 0, '0,1,|0;0;1403959119;', 5, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '0x010101', '0xFFFFFF', '', 0, 1, '', 0, 0, '', '', '', '0x010101', '', '', '', '', '25', '', '', '25', '', '25', '', '', ''),
- (419, 'Vallorz', 'Vallorz', '$2y$12$LzEAKYHDtuBKsnQ5ddn7juWUHuBYKI/rCK/r/O3Hug5nGyNwmVI66', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'benlewis388@gmail.com', 1508488587, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 440, '1', '', '', '', 4, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 11, 0, 1, '5.151', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (420, 'Nadia2', 'Nadia2', '$2y$12$TM.lkq/ygkTSsRmvJdiUS.GTHcIgG06OLG4FKdEjdjLsKmoae2qhq', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'officialcake@gmail.com', 1508497266, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 441, '1', '', '', '', 12, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 0, 0, 1, '108.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (421, 'Vasy', 'Vasy', '$2y$12$34N1g8hYdJT.yL0hFBkEteC4desyvydETXnugHASwW8W6g.SCL90y', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'vasympd12@yahoo.com', 1508534573, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%201%405%403%404%481%103%131%220%212%301%106%244%221%219%101%214', '', 1970, 442, '1', '', '', '', 13, 405, 106, 0, '221', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 3, 0, 1, '188.2', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (422, 'Snipe', 'Snipe', '$2y$12$3Vdxr/RYXj2HsG0YaE5RKeY6.UwIg7ImhwH3eV0TPHcY3ajIWBqa.', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'snipe@gmail.com', 1508627828, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15%107%221%334%106%1007%4045%3035%435%436', '', 3438, 443, '1', '', '', '224|1', 9, 436, 106, 3035, '221', 0, 0, 0, 0, 0, '0', '710,51,212,216,214,', '1%1%1%1', '0,0,0', '397|Angelina%413|Toxic%398|Reece', '', 178, 0, 1, '82.8.', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '0x0000FF', '', '0xFF0000', '', '', 10, 0, '', 0, 0, '', '', 'r', '', '', 'Hello', '', '0', '0', '0', '', '0', '', '10', '', '', ''),
- (423, 'SnipeTest', 'SnipeTest', '$2y$12$XcwUgYP6j3.T5PrbeE.u7u94T2HSMItV.5wMq3LId2opKpBvgOFA.', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'snipe@test.com', 1508628527, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5010, 444, '1', '', '', '', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 2, 0, 1, '82.8.', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
- (424, 'Lukey', 'Lukey', '$2y$12$6/RJ2/HbIIeexFziEebC1e6e6Pf0rJzjDgI3rfRXWpcr1Vu8PP/k6', 0, '{\"spriteScale\":100,\"spriteSpeed\":100,\"ignoresBlockLayer\":false,\"invisible\":false,\"floating\":false}', 'evansgloriaj@gmail.com', 1508710444, 0, '%14%1%2%3%4%5%6%7%8%9%10%11%12%13%15', '', 5000, 445, '1', '', '', '', 1, 0, 0, 0, '0', 0, 0, 0, 0, 0, '0', '7', '1%1%1%1', '0,0,0', '', '', 0, 0, 1, '108.1', '', 0, 0, '0,1,|0;0;1403959119;', 1, '0,0,0,0,0', '0,0,0,0,0,0,0,0', '0', '', '', '', '', '', '', '', '', '', '', '', 0, 0, '', 0, 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');
- DROP TABLE IF EXISTS `postcards`;
- CREATE TABLE `postcards` (
- `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `Recipient` int(10) unsigned NOT NULL,
- `SenderName` char(12) NOT NULL,
- `SenderID` int(10) unsigned NOT NULL,
- `Details` varchar(12) NOT NULL,
- `Date` int(8) NOT NULL,
- `Type` smallint(5) unsigned NOT NULL,
- `HasRead` tinyint(1) NOT NULL DEFAULT '0',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `postcards` (`ID`, `Recipient`, `SenderName`, `SenderID`, `Details`, `Date`, `Type`, `HasRead`) VALUES
- (87, 399, 'test', 400, '', 1507985967, 9, 1),
- (88, 399, 'test', 400, '', 1507985998, 18, 1),
- (89, 399, 'test', 400, '', 1507985999, 18, 1),
- (90, 399, 'test', 400, '', 1507986000, 18, 1),
- (91, 399, 'test', 400, '', 1507986001, 18, 1),
- (92, 399, 'test', 400, '', 1507986004, 18, 1),
- (93, 399, 'test', 400, '', 1507986004, 18, 1),
- (94, 399, 'test', 400, '', 1507986005, 18, 1),
- (95, 399, 'test', 400, '', 1507986005, 18, 1),
- (96, 399, 'test', 400, '', 1507986005, 18, 1),
- (97, 399, 'test', 400, '', 1507986005, 18, 1),
- (98, 399, 'test', 400, '', 1507986005, 18, 1),
- (99, 399, 'test', 400, '', 1507986005, 18, 1),
- (100, 399, 'test', 400, '', 1507986005, 18, 1),
- (101, 399, 'test', 400, '', 1507986005, 18, 1),
- (102, 399, 'test', 400, '', 1507986005, 18, 1),
- (103, 399, 'test', 400, '', 1507986006, 18, 1),
- (104, 399, 'test', 400, '', 1507986006, 18, 1),
- (105, 399, 'test', 400, '', 1507986006, 18, 1),
- (106, 399, 'test', 400, '', 1507986006, 18, 1),
- (107, 399, 'test', 400, '', 1507986006, 18, 1),
- (108, 395, 'test', 400, '', 1507986383, 9, 1),
- (109, 395, 'test', 400, '', 1507986400, 18, 1),
- (110, 395, 'test', 400, '', 1507986400, 18, 1),
- (111, 395, 'test', 400, '', 1507986400, 18, 1),
- (112, 395, 'test', 400, '', 1507986400, 18, 1),
- (113, 395, 'test', 400, '', 1507986400, 18, 1),
- (114, 395, 'test', 400, '', 1507986401, 18, 1),
- (115, 395, 'test', 400, '', 1507986401, 18, 1),
- (116, 395, 'test', 400, '', 1507986401, 18, 1),
- (117, 395, 'test', 400, '', 1507986401, 18, 1),
- (118, 395, 'test', 400, '', 1507986401, 18, 1),
- (119, 395, 'test', 400, '', 1507986401, 18, 1),
- (120, 395, 'test', 400, '', 1507986401, 18, 1),
- (121, 395, 'test', 400, '', 1507986401, 18, 1),
- (122, 395, 'test', 400, '', 1507986401, 18, 1),
- (123, 395, 'test', 400, '', 1507986402, 18, 1),
- (124, 395, 'test', 400, '', 1507986402, 18, 1),
- (125, 395, 'test', 400, '', 1507986402, 18, 1),
- (126, 396, 'test', 400, '', 1507986903, 9, 1),
- (127, 396, 'test', 400, '', 1507986918, 18, 1),
- (128, 396, 'test', 400, '', 1507986918, 18, 1),
- (129, 396, 'test', 400, '', 1507986918, 18, 1),
- (130, 396, 'test', 400, '', 1507986918, 18, 1),
- (131, 396, 'test', 400, '', 1507986918, 18, 1),
- (132, 396, 'test', 400, '', 1507986919, 18, 1),
- (133, 396, 'test', 400, '', 1507986919, 18, 1),
- (134, 396, 'test', 400, '', 1507986919, 18, 1),
- (135, 396, 'test', 400, '', 1507986919, 18, 1),
- (136, 396, 'test', 400, '', 1507986919, 18, 1),
- (137, 396, 'test', 400, '', 1507986919, 18, 1),
- (138, 396, 'test', 400, '', 1507986919, 18, 1),
- (139, 396, 'test', 400, '', 1507986919, 18, 1),
- (140, 396, 'test', 400, '', 1507986919, 18, 1),
- (141, 396, 'test', 400, '', 1507986920, 18, 1),
- (142, 396, 'test', 400, '', 1507986920, 18, 1),
- (143, 396, 'test', 400, '', 1507986920, 18, 1),
- (144, 400, 'Mario10723', 396, '', 1507987231, 9, 1),
- (145, 400, 'Mario10723', 396, '', 1507987236, 9, 1),
- (146, 400, 'Mario10723', 396, '', 1507987240, 9, 0),
- (147, 400, 'Mario10723', 396, '', 1507987244, 9, 0),
- (148, 409, 'sys', 0, 'test', 1508001645, 111, 1),
- (149, 398, 'sys', 0, 'Amy', 1508016754, 111, 1),
- (151, 398, 'Angelina', 397, '', 1508032558, 206, 1),
- (154, 422, 'Angelina', 397, '', 1508800851, 5, 1);
- DROP TABLE IF EXISTS `puffles`;
- CREATE TABLE `puffles` (
- `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `Owner` int(10) unsigned NOT NULL,
- `Name` char(12) NOT NULL,
- `AdoptionDate` int(8) NOT NULL,
- `Type` tinyint(3) unsigned NOT NULL,
- `Subtype` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Hat` smallint(5) unsigned NOT NULL DEFAULT '0',
- `Food` tinyint(3) unsigned NOT NULL DEFAULT '100',
- `Play` tinyint(3) unsigned NOT NULL DEFAULT '100',
- `Rest` tinyint(3) unsigned NOT NULL DEFAULT '100',
- `Clean` tinyint(3) unsigned NOT NULL DEFAULT '100',
- `Backyard` tinyint(1) NOT NULL DEFAULT '0',
- `Walking` int(11) NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `puffles` (`ID`, `Owner`, `Name`, `AdoptionDate`, `Type`, `Subtype`, `Hat`, `Food`, `Play`, `Rest`, `Clean`, `Backyard`, `Walking`) VALUES
- (36, 409, 'test', 1508001645, 6, 0, 0, 100, 100, 100, 100, 0, 0),
- (37, 398, 'Amy', 1508016754, 4, 0, 0, 100, 100, 100, 100, 0, 0);
- DROP TABLE IF EXISTS `redemption`;
- CREATE TABLE `redemption` (
- `ID` int(10) unsigned NOT NULL,
- `Type` varchar(255) NOT NULL DEFAULT 'BLANKET',
- `Code` char(16) NOT NULL,
- `Items` text NOT NULL,
- `Coins` int(11) NOT NULL DEFAULT '0',
- `Expires` int(11) NOT NULL DEFAULT '0',
- `Uses` int(11) NOT NULL DEFAULT '-1',
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- DROP TABLE IF EXISTS `servers`;
- CREATE TABLE `servers` (
- `ID` int(5) NOT NULL,
- `Name` varchar(255) NOT NULL,
- `address` varchar(255) NOT NULL,
- `port` int(10) NOT NULL,
- `capacity` int(11) NOT NULL,
- `Language` varchar(255) NOT NULL
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- INSERT INTO `servers` (`ID`, `Name`, `address`, `port`, `capacity`, `Language`) VALUES
- (102, 'Avalanche', '', 0, 0, 'pt'),
- (100, 'Blizzard', '', 0, 0, 'en'),
- (101, 'Glaciar', '', 0, 0, 'es'),
- (103, 'Yeti', '', 0, 0, 'fr');
- DROP TABLE IF EXISTS `tracks`;
- CREATE TABLE `tracks` (
- `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `Name` varchar(12) COLLATE utf8mb4_unicode_ci NOT NULL,
- `Owner` int(10) unsigned NOT NULL,
- `Hash` char(32) COLLATE utf8mb4_unicode_ci NOT NULL,
- `Sharing` tinyint(1) NOT NULL DEFAULT '0',
- `Pattern` mediumtext COLLATE utf8mb4_unicode_ci NOT NULL,
- `Likes` smallint(5) unsigned NOT NULL DEFAULT '0',
- `LikeStatistics` text COLLATE utf8mb4_unicode_ci NOT NULL,
- PRIMARY KEY (`ID`)
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
- -- 2017-10-24 00:40:57
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement