· 7 years ago · Feb 21, 2019, 06:06 PM
1-- 2019-02-22
2REPLACE INTO `sz_event` (`id`, `name`, `start_date`, `end_date`, `rate`, `type`) VALUES (335, 'Quà Mua Giới Hạn', '2019-02-22 00:00:00', '2019-02-28 23:59:59', 100, 1);
3REPLACE INTO `sz_event` (`id`, `name`, `start_date`, `end_date`, `rate`, `type`) VALUES (334, 'Vòng Quay Thần Tà i', '2019-02-22 00:00:00', '2019-02-28 23:59:59', 100, 1);
4REPLACE INTO `sz_event` (`id`, `name`, `start_date`, `end_date`, `rate`, `type`) VALUES (333, 'Nạp TÃch LÅ©y không reset', '2019-02-22 00:00:00', '2019-02-28 23:59:59', 100, 1);
5
6REPLACE INTO `sz_halo` (`id`, `name`, `blood`, `damage`, `mana`, `resist`, `replace_type`, `replace_value`, `pet_id`, `note`) VALUES (5, 'Vòng Sáng Thiên Long', 10000, 70, 0, 70, 'gold', 100000, 0, '(1m)');
7
8-- warclub
9CREATE TABLE IF NOT EXISTS `sz_news` (
10 `id` int(11) NOT NULL AUTO_INCREMENT,
11 `title` varchar(128) NOT NULL,
12 `link` varchar(512) NOT NULL,
13 `content` varchar(512) DEFAULT NULL,
14 `status` tinyint(4) NOT NULL DEFAULT '1',
15 `date` date NOT NULL,
16 `created_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
17 `servers` varchar(1024) NOT NULL DEFAULT 'all',
18 PRIMARY KEY (`id`),
19 KEY `status` (`status`)
20) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;
21
22INSERT INTO `sz_news` (`id`, `title`, `link`, `content`, `status`, `date`, `created_date`, `servers`) VALUES
23 (1, '[Sự Kiện] Triệu Hồi Tsubasa Chiến Boss Cuồng Nộ', 'https://www.facebook.com/pokiwar2/photos/a.433439866860999/951754465029534/?type=3&theater', NULL, 1, '2019-02-21', '2019-02-20 15:17:59', 'all');