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
|
#########################################################
# OpenDb 1.0dev4 moby.com (mobygames) Site Plugin
#########################################################
#
# Site Plugin.
#
INSERT INTO s_site_plugin ( site_type, classname, order_no, title, image, description, external_url, items_per_page, more_info_url )VALUES ( 'mobygames', 'mobygames', 8, 'moby.com', 'moby.gif', 'Information and reviews of lots of computer games.', 'http://www.mobygames.com', 25, 'http://www.mobygames.com/game/{mgpltfrmid}/{mobygameid}' );
#
# Site Plugin Input Fields
#
INSERT INTO s_site_plugin_input_field ( site_type, field, order_no, description, prompt, field_type, default_value, refresh_mask ) VALUES ( 'mobygames', 'title', 1, '', '<i>Title</i> Search', 'text', '', '{ifdef(alt_title, \'{alt_title} / \')}{title}' );
INSERT INTO s_site_plugin_input_field ( site_type, field, order_no, description, prompt, field_type, default_value, refresh_mask ) VALUES ( 'mobygames', 'mobygameid', 2, '', 'MobyGame ID', 'text', '', '{mobygameid}' );
INSERT INTO s_site_plugin_input_field ( site_type, field, order_no, description, prompt, field_type, default_value, refresh_mask ) VALUES ( 'mobygames', 'mgpltfrmid', 2, '', 'MobyGame Platform ID', 'text', '', '{mgpltfrmid}' );
#
# Site Plugin Links
#
INSERT INTO s_site_plugin_link ( site_type, s_item_type_group, s_item_type, order_no, description, url, title_url ) VALUES ( 'mobygames', '*', 'GAME', 1, 'More Info', 'http://www.mobygames.com/game/{mgpltfrmid}/{mobygameid}', '' );
#
# Site Plugin System Attribute Type Map
#
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'alt_title', 'ALT_TITLE' );
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'description', 'GAME_PLOT' );
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'genre', 'GAMEGENRE' );
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'mgpltfrmid', 'GAMESYSTEM' );
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'perspective', 'COMMENTS' );
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'publisher', 'GAMEPBLSHR' );
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'release_date', 'GAMEPBDATE' );
INSERT INTO s_site_plugin_s_attribute_type_map ( site_type, s_item_type_group, s_item_type, variable, s_attribute_type ) VALUES ( 'mobygames', 'GAME', '*', 'title', 'S_TITLE' );
#
# Site Plugin System Attribute Type Lookup Map
#
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMERATING', '89', 'EC' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMERATING', '90', 'E' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMERATING', '91', 'K-A' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMERATING', '92', 'T' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMERATING', '93', 'M' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMERATING', '94', 'AO' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMERATING', '95', 'RP' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'dreamcast', 'DREAMCAST' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'gameboy', 'GAMEBOY' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'gameboy-advance', 'GAMEBOYADVANCE' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'gamecube', 'GAMECUBE' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'n64', 'N64' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'playstation', 'PS1' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'ps2', 'PS2' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'windows', 'PCCDROM' );
INSERT INTO s_site_plugin_s_attribute_type_lookup_map ( site_type, s_attribute_type, value, lookup_attribute_val ) VALUES ( 'mobygames', 'GAMESYSTEM', 'xbox', 'XBOX' );
####################################################################################################
# Item Type / Attribute Type relationships
####################################################################################################
#
# Site Plugin Attribute Type(s)
#
INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, display_type, s_field_type, site_type ) VALUES ( 'MOBYGAMEID', 'MobyGames game ID', 'MobyGames ID', 'hidden', 'hidden', '', 'mobygames' );
INSERT INTO s_attribute_type ( s_attribute_type, description, prompt, input_type, display_type, s_field_type, site_type ) VALUES ( 'MGPLTFRMID', 'MobyGames Platform ID', 'MobyGames Platform ID', 'hidden', 'hidden', '', 'mobygames' );
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'GAME', 'MOBYGAMEID', '0', NULL, NULL);
INSERT INTO s_item_attribute_type (s_item_type, s_attribute_type, order_no, prompt, compulsory_ind) VALUES ( 'GAME', 'MGPLTFRMID', '0', NULL, NULL);
|
