-
Notifications
You must be signed in to change notification settings - Fork 3
/
update_from_0_7_0_to_0_7_3.sql
40 lines (30 loc) · 5.5 KB
/
update_from_0_7_0_to_0_7_3.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
CREATE TABLE `cc1_pages` (
`id` int(12) UNSIGNED NOT NULL,
`getName` varchar(128) NOT NULL,
`title` varchar(255) NOT NULL,
`content` text NOT NULL,
`access` enum('public','member','support','admin') NOT NULL,
`isActive` tinyint(2) UNSIGNED NOT NULL,
`makeTime` int(12) UNSIGNED NOT NULL,
`updateTime` int(12) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `cc1_pages`
ADD PRIMARY KEY (`id`);
ALTER TABLE `cc1_pages`
MODIFY `id` int(12) UNSIGNED NOT NULL AUTO_INCREMENT;
UPDATE `cc1_menu_admin` SET `menu_order` = '3' WHERE `adm_menu_id` = 2;
UPDATE `cc1_menu_admin` SET `menu_order` = '4' WHERE `adm_menu_id` = 3;
UPDATE `cc1_menu_admin` SET `menu_order` = '5' WHERE `adm_menu_id` = 4;
UPDATE `cc1_menu_admin` SET `menu_order` = '6' WHERE `adm_menu_id` = 5;
UPDATE `cc1_menu_admin` SET `menu_order` = '8' WHERE `adm_menu_id` = 6;
UPDATE `cc1_menu_admin` SET `menu_order` = '7' WHERE `adm_menu_id` = 7;
INSERT INTO `cc1_menu_admin` (`adm_menu_id`, `menu_name`, `menu_icon`, `menu_order`) VALUES (NULL, 'Seiten Manager', '[IMG_PATH]icons/news.png', '2');
INSERT INTO `cc1_menu_admin_sub` (`admin_sub_id`, `menu_admin_id`, `admin_sub_name`, `admin_sub_link`, `sub_name_sort`, `modul_admin_id`) VALUES (NULL, '8', 'Seiten', '[LITO_BASE_MODUL_URL]acp_pagemanager/page.php', '0', '47');
INSERT INTO `cc1_menu_admin_sub` (`admin_sub_id`, `menu_admin_id`, `admin_sub_name`, `admin_sub_link`, `sub_name_sort`, `modul_admin_id`) VALUES (NULL, '8', 'Seite erstellen', '[LITO_BASE_MODUL_URL]acp_pagemanager/page.php?action=new', '2', '47');
INSERT INTO `cc1_modul_admin` (`modul_admin_id`, `modul_name`, `modul_description`, `disable_allowed`, `activated`, `startfile`, `current_version`, `acp_modul`, `show_error_msg`, `modul_type`, `new_upd_available`, `perm_lvl`) VALUES (NULL, 'acp_pagemanager', 'ACP Seiten Manager', '1', '1', 'page.php', '0.7.1', '1', '1', '0', '0', '1000');
INSERT INTO `cc1_modul_admin` (`modul_admin_id`, `modul_name`, `modul_description`, `disable_allowed`, `activated`, `startfile`, `current_version`, `acp_modul`, `show_error_msg`, `modul_type`, `new_upd_available`, `perm_lvl`) VALUES (NULL, 'pagemanager', 'CMS-System', '1', '1', 'page.php', '0.7.1', '0', '1', '0', '0', '0');
INSERT INTO `cc1_pages` (`id`, `getName`, `title`, `content`, `access`, `isActive`, `makeTime`, `updateTime`) VALUES
(1, 'screen', 'Screenshorts', '<a href="{$LITO_GLOBAL_IMAGE_URL}standard/pagemanager/main.png" target="_blank"></a> \r\n<table border="0" width="100%">\r\n<tbody>\r\n<tr>\r\n<td>Startseite</td>\r\n<td>Baumen&uuml;</td>\r\n<td>Ausbildungscamp</td>\r\n</tr>\r\n<tr>\r\n<td><a href="{$LITO_GLOBAL_IMAGE_URL}standard/pagemanager/main.png" target="_blank"><img src="{$LITO_GLOBAL_IMAGE_URL}standard/pagemanager/main.png" border="0" alt="" width="200" height="160" /></a></td>\r\n<td><a href="{$LITO_GLOBAL_IMAGE_URL}standard/pagemanager/bauen.png" target="_blank"><img src="{$LITO_GLOBAL_IMAGE_URL}standard/pagemanager/bauen.png" border="0" alt="" width="200" height="160" /></a></td>\r\n<td><a href="{$LITO_GLOBAL_IMAGE_URL}standard/pagemanager/ausbildung.png" target="_blank"><img src="{$LITO_GLOBAL_IMAGE_URL}standard/pagemanager/ausbildung.png" border="0" alt="" width="200" height="160" /></a></td>\r\n</tr>\r\n</tbody>\r\n</table>', 'public', 1, 1502963916, 1502964458),
(2, 'impress', 'Impressum', '{$GAME_NAME}<br />{$GAME_URL}<br /> {$GAME_AUTHOR}<br />{$ADMIN_EMAIL}<br />{$SUPPORT_EMAIL}<br />\r\n<p><strong><br /><span style="\\">Die Litotex OpenSource Browsergame wurde entwickelt vom Litotex Team und fortgesetzt wurde es vom litotex.info Team.</span><br /><br /></strong>F&uuml;r Fragen, Anregungen lohnt sich ein Besuch des <a href="https://litotex.info/">Litotex Forums</a>.</p>\r\n<p>Diese Software ist nicht als fertiges Browsergame gedacht, sondern vielmehr als Vorlage f&uuml;r die eigenen Ideen und W&uuml;nsche.<br /><br /><strong>Besonderen Dank gilt allen Mitwirkenden:</strong></p>\r\n<ul>\r\n<li><strong>gh1234</strong></li>\r\n<li><strong>KiraYamato</strong></li>\r\n<li><strong>ofliii</strong></li>\r\n<li><strong>SnooP</strong></li>\r\n<li><strong>Sonorc</strong></li>\r\n<li><strong>Tungdal</strong></li>\r\n</ul>\r\n<p>Ein gro&szlig;er Dank geht auch an die Foren-Community, welche uns mit Ideen, Fehlerfindung und jede menge guter Laune immer wieder dazu Motivierte noch einen Schritt weiter zu gehen.<strong><br /><br />Und nicht zu vergessen, die Freunde/in, Eltern, oder Familienangeh&ouml;rigen, die viele Stunden auf uns verzichten mussten ;)<br /></strong></p>', 'public', 0, 1502964991, 1502965507);
DELETE FROM `cc1_menu_admin_opt` WHERE `varname` = 'op_impressum';
UPDATE `cc1_menu_game` SET `menu_game_link` = '[LITO_BASE_MODUL_URL]pagemanager/page.php?name=screen' WHERE `menu_game_name` = 'Screenshots';