`network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '',
`network_type_banner_url` VARCHAR(255) NULL DEFAULT NULL,
PRIMARY KEY (`network_type_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_handle`)",
+UNIQUE `provider_type` (`network_id`, `network_type_handle`)",
'Types provideable by networks');
// HTTP parameters (names) for URLs
`request_param_value` VARCHAR(20) NOT NULL DEFAULT 'invalid',
`request_param_default` VARCHAR(255) NULL DEFAULT NULL,
PRIMARY KEY (`network_param_id`),
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
-UNIQUE `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`),",
+UNIQUE `provider_type_key` (`network_id`, `network_type_id`, `request_param_key`),
+UNIQUE `provider_type_value` (`network_id`, `network_type_id`, `request_param_value`),",
'Request parameters for GET/POST request');
// Error status codes
`network_type_code_value` VARCHAR(50) NOT NULL DEFAULT '',
`network_type_code_type` VARCHAR(100) NOT NULL DEFAULT 'INVALID_TYPE',
PRIMARY KEY (`network_type_code_id`),
-UNIQUE `code_type` (`network_type_code_value`,`network_type_id`),
+UNIQUE `code_type` (`network_type_code_value`, `network_type_id`),
INDEX (`network_type_id`)",
'Error codes for all types');
`network_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`network_api_id`),
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
+UNIQUE `provider_type_key` (`network_id`, `network_type_id`, `network_api_index`),
INDEX (`sort`)",
'Translation of API responses, generic data, DO NOT ALTER!');
`network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
PRIMARY KEY (`network_id`),
-UNIQUE `network_affiliate` (`network_id`,`network_affiliate_id`),
-UNIQUE `affiliate_site` (`network_affiliate_id`,`network_site_id`)",
+UNIQUE `network_affiliate` (`network_id`, `network_affiliate_id`),
+UNIQUE `affiliate_site` (`network_affiliate_id`, `network_site_id`)",
'Configuration data from the webmaster (you!)');
// Configuration data for e.g. reload-time
`min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
`allow_erotic` VARCHAR(10) NOT NULL DEFAULT '',
PRIMARY KEY (`network_data_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE `provider_type` (`network_id`, `network_type_id`)",
'Configuration data for every type (e.g. reload-time)');
// Cache for queried APIs. Re-check depends on config
`network_cache_data` MEDIUMBLOB,
`network_cache_timestamp` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`network_cache_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE `provider_type` (`network_id`, `network_type_id`)",
'Cache for all queried APIs');
// Reload locks for several types
`network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`network_reload_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE `provider_type` (`network_id`, `network_type_id`)",
'Reload locks');
// Insert API response array translations, these will be used for calling the right filter function
('REQUEST_PARAMETER_INCOMPLETE')");
// Sponsor networks
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`,`network_require_id_card`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`, `network_require_id_card`) VALUES
('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252','N'),
('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252','Y'),
('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1','N'),
('adconvention', 'AdConvention', 'http://www.adconvention.de?ref=233', '|', '|', 'GET', 'WINDOWS-1252','N')");
// Network type handlers - A3H
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
(1, 1, 'banner', 'http://www.a3h.de/interface/out_banner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
(2, 1, 'textlink', 'http://www.a3h.de/interface/out_textlink.php', 'http://www.a3h.de/textlinkklick.php?id=%CID%', NULL),
(3, 1, 'surfbar', 'http://www.a3h.de/interface/out_sbanner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),