TCAdminCustomMods/install.sql at master · alvarengasv/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
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
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>');

INSERT INTO ar_common_configurations (id, moduleId, name, typeName, contents, app_data)
VALUES (4, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 'Steam Workshop Configuration',
        'TCAdminCustomMods.Configurations.SteamWorkshopConfiguration, TCAdminCustomMods', '{}', '<?xml version="1.0" encoding="utf-16" standalone="yes"?>
<values>
  <add key="AR_COMMON:ConfigurationView" value="SteamWorkshopProvider" 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', '');

INSERT INTO tcmodule_custom_mod_providers (id, name, typeName, configurationModuleId, configurationId, view,
                                           app_data)
VALUES (4, 'Steam Workshop', 'TCAdminCustomMods.Providers.SteamWorkshopProvider, TCAdminCustomMods',
        'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0', 4, 'SteamWorkshopProvider', '');

# ---------------------------------------------------------------------------------------------------------------------
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);

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 (4894, 'd3b2aa93-7e2b-4e0d-8080-67d14b2fa8a9', 23, 1, 'b48cfbc9-7acc-4980-89c4-2b6a1f784aa0',
        'Steam Workshop', 'Manage Steam Workshop mods for $[Service.ConnectionInfo]', 'MenuIcons/GameHosting/Mods.png',
        '/Service/CustomMods/$[Service.ServiceId]?mod_provider=4', null, 0, null, 350, 1,
        'TCAdminCustomMods.IconManager, TCAdminCustomMods', 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);