· 9 years ago · Dec 29, 2016, 06:04 AM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10.14
3-- http://www.phpmyadmin.net
4--
5-- Host: localhost:3306
6-- Generation Time: Dec 29, 2016 at 12:35 AM
7-- Server version: 10.0.25-MariaDB
8-- PHP Version: 5.6.20
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET 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 utf8 */;
18
19--
20-- Database: `freshhot_store`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `cms_store_categories`
27--
28
29CREATE TABLE IF NOT EXISTS `cms_store_categories` (
30 `id` int(11) NOT NULL AUTO_INCREMENT,
31 `caption` varchar(255) DEFAULT NULL,
32 PRIMARY KEY (`id`)
33) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
34
35--
36-- Dumping data for table `cms_store_categories`
37--
38
39INSERT INTO `cms_store_categories` (`id`, `caption`) VALUES
40(1, 'Rank Upgrades'),
41(2, 'Rare Packages'),
42(3, 'Vip Upgrades'),
43(4, 'Account Upgrades'),
44(5, 'Currency Addons'),
45(6, 'Rare Topups');
46
47-- --------------------------------------------------------
48
49--
50-- Table structure for table `cms_store_items`
51--
52
53CREATE TABLE IF NOT EXISTS `cms_store_items` (
54 `id` int(11) NOT NULL AUTO_INCREMENT,
55 `item_name` varchar(255) CHARACTER SET latin1 NOT NULL,
56 `item_price` int(11) NOT NULL,
57 `item_desc` text COLLATE latin1_danish_ci NOT NULL,
58 `image_url` varchar(255) CHARACTER SET latin1 NOT NULL,
59 `category` int(255) NOT NULL,
60 `is_package` enum('0','1') COLLATE latin1_danish_ci NOT NULL DEFAULT '0',
61 `is_rank` enum('0','1') COLLATE latin1_danish_ci NOT NULL DEFAULT '0',
62 `extra_data` varchar(255) COLLATE latin1_danish_ci NOT NULL,
63 `set_quantity` int(255) NOT NULL,
64 `is_credits` enum('0','1') COLLATE latin1_danish_ci NOT NULL DEFAULT '0',
65 `is_diamonds` enum('0','1') COLLATE latin1_danish_ci NOT NULL DEFAULT '0',
66 `min_quantity` int(255) NOT NULL DEFAULT '1',
67 `quantity_step` varchar(255) COLLATE latin1_danish_ci NOT NULL,
68 PRIMARY KEY (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_danish_ci AUTO_INCREMENT=21337 ;
70
71--
72-- Dumping data for table `cms_store_items`
73--
74
75INSERT INTO `cms_store_items` (`id`, `item_name`, `item_price`, `item_desc`, `image_url`, `category`, `is_package`, `is_rank`, `extra_data`, `set_quantity`, `is_credits`, `is_diamonds`, `min_quantity`, `quantity_step`) VALUES
76(48, 'Bronze VIP', 5, 'You will receive Bronze VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
77(49, 'Silver VIP', 10, 'You will receive Silver VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
78(50, 'Gold VIP', 15, 'You will receive Gold VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
79(51, 'Diamond VIP', 25, 'You will receive Diamond VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
80(55, 'Rare Package #1', 10, 'If you purchase this package, you will receive the following items:<hr>\r\n» <b>10 THRONES</b>\r\n<br> » <b>10 DJ DECKS</b>\r\n<br> » <b>10 TYPEWRITERS</b>\r\n<br> » <b>10 PETALS</b>\r\n<br> » <b>10 DRAGON EGGS</b>', '', 2, '0', '0', '', 0, '0', '0', 1, ''),
81(56, 'Rare Package #2', 20, 'If you purchase this package, you will receive the following items:\r\n<hr>\r\n» <b>20 THRONES</b>\r\n<br> » <b>20 DJ DECKS</b>\r\n<br> » <b>20 TYPEWRITERS</b>\r\n<br> » <b>20 PETALS</b>\r\n<br> » <b>20 DRAGON EGGS</b>', '', 2, '0', '0', '', 0, '0', '0', 1, ''),
82(57, 'Rare Package #3', 30, 'If you purchase this package, you will receive the following items:\r\n<hr>\r\n» <b>30 THRONES</b>\r\n<br> » <b>30 DJ DECKS</b>\r\n<br> » <b>30 TYPEWRITERS</b>\r\n<br> » <b>30 PETALS</b>\r\n<br> » <b>30 DRAGON EGGS</b>', '', 2, '0', '0', '', 0, '0', '0', 1, ''),
83(59, '100 Thrones', 50, 'You''ll receive 100 Thrones', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
84(60, '100 DJ Decks', 15, 'You''ll receive 100 DJ''s', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
85(61, '100 Dragon Eggs', 15, 'You''ll receive 100 Dragon Eggs', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
86(62, '100 Petal Patches', 5, 'You''ll receive 100 Petals', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
87(63, 'ICM Set', 50, 'You''ll receive ICM Set', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
88(64, 'Dragon Set', 50, 'You''ll receive Dragon Set', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
89(65, '50 Thrones', 25, 'You''ll receive 50 Thrones', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
90(67, '100 Thrones and Dinos', 65, 'You''ll receive 100 Thrones and Dinos', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
91(68, '100 Typewriters', 20, 'You''ll receive 100 Typewriters', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
92(69, '200 DJ Decks', 30, 'You''ll receive 200 DJ Decks', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
93(70, '200 Petal Patches', 9, 'You''ll receive 200 Petals', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
94(1, 'Unban', 20, 'You''ll get one account unbanned', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
95(72, '500M Coins and Pixels', 20, 'Your account will have the balance updated with +500M Coins and Pixels', '', 5, '0', '0', '', 0, '0', '0', 1, ''),
96(2, 'Inactive Account', 25, 'You''ll get one inactive username of your choice', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
97(3, 'Trusted Dealer Bronze', 5, 'You''ll be listed on bronze trusted dealer on https://fresh-hotel.org/trusted', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
98(4, 'Trusted Dealer Silver', 8, 'You''ll be listed on Silver trusted dealer on https://fresh-hotel.org/trusted', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
99(5, 'Trusted Dealer Gold', 11, 'You''ll be listed on Gold trusted dealer on https://fresh-hotel.org/trusted', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
100(6, 'Trusted Dealer Badge', 4, 'You''ll receive a trusted dealer badge', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
101(80, '200 Dragon Eggs', 30, 'You''ll receive 200 dragon eggs', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
102(84, 'Rare Package #4', 40, 'If you purchase this package, you will receive the following items:\r\n<hr>\r\n» <b>40 THRONES</b>\r\n<br> » <b>40 DJ DECKS</b>\r\n<br> » <b>40 TYPEWRITERS</b>\r\n<br> » <b>40 PETALS</b>\r\n<br> » <b>40 DRAGON EGGS</b>', '', 2, '0', '0', '', 0, '0', '0', 1, ''),
103(85, '200 Thrones', 100, 'You''ll receive 200 Thrones', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
104(86, '300 Typewriters', 60, 'You''ll receive 300 Typewriters', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
105(87, '200 Typewriters', 40, 'You''ll receive 200 Typewriters', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
106(88, '1B Coins and Pixels', 40, 'Your account will have the balance updated with +1B Coins and 1B Pixels', '', 5, '0', '0', '', 0, '0', '0', 1, ''),
107(89, '2B Coins and Pixels', 60, 'Your account will have the balance updated with +2B Coins and 2B Pixels', '', 5, '0', '0', '', 0, '0', '0', 1, ''),
108(92, '100 Club Sofas', 15, 'Youll receive 100 Club Sofas', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
109(93, '100 Customs', 50, 'Youll receive 100 Customs', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
110(7, '1M Achiv Score', 11, 'Youll receive 1M Achiv Score', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
111(21334, 'Moderator', 110, 'You will receive Moderator', '', 1, '0', '0', '', 0, '0', '0', 0, ''),
112(9999, '50 Customs', 25, 'Youll receive 50 Customs', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
113(21333, 'Manager', 220, 'You will receive Manager', '', 1, '0', '0', '', 0, '0', '0', 1, ''),
114(1000, 'Owner', 500, 'You will receive Owner Rank', '', 1, '0', '0', '', 0, '0', '0', 1, ''),
115(21336, 'Event Staff', 60, 'You will receive Event Staff Rank', '', 1, '0', '0', '', 0, '0', '0', 1, ''),
116(21335, 'Trial Mod', 65, 'You will receive Trial Mod Rank', '', 1, '0', '0', '', 0, '0', '0', 1, '');
117
118/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
119/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
120/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;