TCAdminCustomMods/install.sql at master · Alexr03/TCAdminCustomMods · GitHub

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
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (1, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 'UMod Configuration',
        'TCAdminCustomMods.Configurations.UModConfiguration, TCAdminCustomMods', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
  <add key="AR_COMMON:ConfigurationView" value="UModProvider" type="System.String,mscorlib" />
</values>');
INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (2, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 'Curse Configuration',
        'TCAdminCustomMods.Configurations.CurseConfiguration, TCAdminCustomMods', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
  <add key="AR_COMMON:ConfigurationView" value="CurseProvider" type="System.String,mscorlib" />
</values>');

INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (3, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 'Minecraft Modpacks Configuration',
        'TCAdminCustomMods.Configurations.MinecraftModpacksConfiguration, TCAdminCustomMods', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
  <add key="AR_COMMON:ConfigurationView" value="MinecraftModpacksProvider" type="System.String,mscorlib" />
</values>');

# ---------------------------------------------------------------------------------------------------------------------

create table  IF NOT EXISTS tcmodule_custom_mod_providers
(
    id                    int auto_increment
        primary key,
    name                  text        null,
    typeName              text        null,
    configurationModuleId varchar(36) null,
    configurationId       int         null,
    view                  text        null,
    app_data              text        null
);

# ---------------------------------------------------------------------------------------------------------------------

INSERT INTO tcmodule_custom_mod_providers (id, name, typeName, configurationModuleId, configurationId, view,
                                           app_data)
VALUES (1, 'uMod', 'TCAdminCustomMods.Providers.UModProvider, TCAdminCustomMods',
        'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 1, 'UModProvider', '');
INSERT INTO tcmodule_custom_mod_providers (id, name, typeName, configurationModuleId, configurationId, view,
                                           app_data)
VALUES (2, 'Curse', 'TCAdminCustomMods.Providers.CurseProvider, TCAdminCustomMods',
        'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 2, 'CurseProvider', '');

INSERT INTO tcmodule_custom_mod_providers (id, name, typeName, configurationModuleId, configurationId, view,
                                           app_data)
VALUES (3, 'Minecraft Modpacks', 'TCAdminCustomMods.Providers.MinecraftModpacksProvider, TCAdminCustomMods',
        'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 3, 'MinecraftModpacksProvider', '');

# ---------------------------------------------------------------------------------------------------------------------
DELETE FROM tc_page_icons WHERE icon_id=4891 AND module_id='d3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9';
DELETE FROM tc_page_icons WHERE icon_id=4892 AND module_id='d3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9';
DELETE FROM tc_page_icons WHERE icon_id=4893 AND module_id='d3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9';
DELETE FROM tc_page_icons WHERE icon_id=4890 AND module_id='d3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9';

INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
                           description, icon, url, display_sql, user_type, selected_user_type, view_order,
                           enabled, icon_manager, is_postback, postback_class, new_page, category_id)
VALUES (4891, 'd3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9', 23, 1, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0',
        'UMod Mods', 'Manage custom mods for $[Service.ConnectionInfo]', 'MenuIcons/GameHosting/Mods.png',
        '/Service/CustomMods/$[Service.ServiceId]?mod_provider=1', null, 0, null, 350, 1,
        'TCAdminCustomMods.IconManager, TCAdminCustomMods', null, null, null, null);

INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
                           description, icon, url, display_sql, user_type, selected_user_type, view_order,
                           enabled, icon_manager, is_postback, postback_class, new_page, category_id)
VALUES (4892, 'd3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9', 23, 1, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0',
        'Curse Mods', 'Manage custom mods for $[Service.ConnectionInfo]', 'MenuIcons/GameHosting/Mods.png',
        '/Service/CustomMods/$[Service.ServiceId]?mod_provider=2', null, 0, null, 350, 1,
        'TCAdminCustomMods.IconManager, TCAdminCustomMods', null, null, null, null);

INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
                           description, icon, url, display_sql, user_type, selected_user_type, view_order,
                           enabled, icon_manager, is_postback, postback_class, new_page, category_id)
VALUES (4893, 'd3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9', 23, 1, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0',
        'Minecraft Modpacks', 'Manage FTB mods for $[Service.ConnectionInfo]', 'MenuIcons/GameHosting/Mods.png',
        '/Service/CustomMods/$[Service.ServiceId]?mod_provider=3', null, 0, null, 350, 1,
        'TCAdminCustomMods.IconManager, TCAdminCustomMods', null, null, null, null);

INSERT INTO tc_page_icons (icon_id, module_id, page_id, linked_page_id, linked_page_module_id, display_name,
                           description, icon, url, display_sql, user_type, selected_user_type, view_order,
                           enabled, icon_manager, is_postback, postback_class, new_page, category_id)
VALUES (4890, 'd3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9', 3, 2, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 'Custom Mods',
        'Manage the custom mod providers this game supports', 'MenuIcons/GameHosting/Mods.png',
        '/Game/CustomModsAdmin/Index/$[Game.GameId]', null, 0, null, 975, 1, null, null, null, null, null);

# ---------------------------------------------------------------------------------------------------------------------
DELETE FROM tc_module_processes WHERE module_id='b48cfbc9-7acc-4980-89c4-2b6a1f784aa0';
INSERT INTO tc_module_processes (module_id, process_id, process_class, process_command, display_name) VALUES ('b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', '1', 'TCAdminCustomMods.Tasks.MinecraftModpacks.Processes,TCAdminCustomMods', 'InstallModpack', 'Install a modpack');
INSERT INTO tc_module_processes (module_id, process_id, process_class, process_command, display_name) VALUES ('b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', '2', 'TCAdminCustomMods.Tasks.MinecraftModpacks.Processes,TCAdminCustomMods', 'UninstallModpack', 'Uninstall a modpack');
# ---------------------------------------------------------------------------------------------------------------------
INSERT INTO tc_site_map (page_id, module_id, parent_page_id, parent_page_module_id, category_id, url, mvc_url,
                         controller, action, display_name, page_small_icon, panelbar_icon, show_in_sidebar,
                         view_order, required_permissions, menu_required_permissions, page_manager,
                         page_search_provider, cache_name)
VALUES (1, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 23, 'd3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9', 2,
        '/Service/CustomMods/$[Service.ServiceId]', '/Service/CustomMods/$[Service.ServiceId]', 'CustomMods', 'Index',
        'Custom Mods', 'MenuIcons/GameHosting/Mods24x24.png', 'MenuIcons/GameHosting/Mods16x16.png', 0, 1000,
        '({07405876-e8c2-4b24-a774-4ef57f596384,0,0})({d3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9,5,0,1})({d3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9,6,0,2})({07405876-e8c2-4b24-a774-4ef57f596384,-1,64})({07405876-e8c2-4b24-a774-4ef57f596384,-1,2048})',
        '', null, null, '');
INSERT INTO tc_site_map (page_id, module_id, parent_page_id, parent_page_module_id, category_id, url, mvc_url,
                         controller, action, display_name, page_small_icon, panelbar_icon, show_in_sidebar,
                         view_order, required_permissions, menu_required_permissions, page_manager,
                         page_search_provider, cache_name)
VALUES (2, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 3, 'd3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9', null,
        '/Game/CustomModsAdmin/Index/$[Game.GameId]', '/Game/CustomModsAdmin/Index/$[Game.GameId]', 'CustomModsAdmin',
        'Index', 'Custom Mods Administration', 'MenuIcons/GameHosting/Mods24x24.png',
        'MenuIcons/GameHosting/Mods16x16.png', 0, 1000,
        '({07405876-e8c2-4b24-a774-4ef57f596384,0})({d3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9,1})', '', null, null, '');

# ---------------------------------------------------------------------------------------------------------------------

INSERT INTO tc_modules (module_id, display_name, version, enabled, config_page, component_directory,
                        security_class)
VALUES ('b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 'Custom Mods', '2.0', 1, null, null, null);