· 9 years ago · Dec 29, 2016, 06:30 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(11, 'Bronze VIP #4', 5, 'You will receive Bronze VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
77(10, 'Silver VIP #3', 10, 'You will receive Silver VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
78(9, 'Gold VIP #2', 15, 'You will receive Gold VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
79(8, 'Diamond VIP #1', 25, 'You will receive Diamond VIP', '', 3, '0', '0', '', 0, '0', '0', 1, ''),
80(12, '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(13, '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(14, '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(32, '100 Thrones #17', 50, 'You''ll receive 100 Thrones', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
84(31, '100 DJ Decks #16', 15, 'You''ll receive 100 DJ''s', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
85(32, '100 Dragon Eggs #15', 15, 'You''ll receive 100 Dragon Eggs', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
86(31, '100 Petal Patches #14', 5, 'You''ll receive 100 Petals', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
87(30, 'ICM Set #13', 50, 'You''ll receive ICM Set', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
88(29, 'Dragon Set #12', 50, 'You''ll receive Dragon Set', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
89(28, '50 Thrones #11', 25, 'You''ll receive 50 Thrones', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
90(27, '100 Thrones and Dinos #10', 65, 'You''ll receive 100 Thrones and Dinos', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
91(26, '100 Typewriters #9 ', 20, 'You''ll receive 100 Typewriters', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
92(25, '200 DJ Decks #8', 30, 'You''ll receive 200 DJ Decks', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
93(24, '200 Petal Patches #7', 9, 'You''ll receive 200 Petals', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
94(1, 'Unban #1', 20, 'You''ll get one account unbanned', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
95(15, '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 #2', 25, 'You''ll get one inactive username of your choice', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
97(3, 'Trusted Dealer Bronze #3', 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 #4', 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 #5', 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 #6', 4, 'You''ll receive a trusted dealer badge', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
101(23, '200 Dragon Eggs $6', 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(22, '200 Thrones #5', 100, 'You''ll receive 200 Thrones', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
104(18, '300 Typewriters #1', 60, 'You''ll receive 300 Typewriters', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
105(19, '200 Typewriters #2', 40, 'You''ll receive 200 Typewriters', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
106(17, '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(16, '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(20, '100 Club Sofas #3', 15, 'Youll receive 100 Club Sofas', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
109(21, '100 Customs #4', 50, 'Youll receive 100 Customs', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
110(7, '1M Achiv Score #7', 11, 'Youll receive 1M Achiv Score', '', 4, '0', '0', '', 0, '0', '0', 1, ''),
111(21334, 'Moderator #3', 110, 'You will receive Moderator', '', 1, '0', '0', '', 0, '0', '0', 0, ''),
112(33, '50 Customs #33', 25, 'Youll receive 50 Customs', '', 6, '0', '0', '', 0, '0', '0', 1, ''),
113(21333, 'Manager #2', 220, 'You will receive Manager', '', 1, '0', '0', '', 0, '0', '0', 1, ''),
114(1000, 'Owner #1', 500, 'You will receive Owner Rank', '', 1, '0', '0', '', 0, '0', '0', 1, ''),
115(21336, 'Event Staff #5', 60, 'You will receive Event Staff Rank', '', 1, '0', '0', '', 0, '0', '0', 1, ''),
116(21335, 'Trial Mod #4', 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 */;