* @TODO Ad-Magnet: Layer(klick?). Layerviews.Skybannerklick/-view, *
* @TODO Ad-Magnet: Banner-View, Textlink-Klick/-View. Page-Peel *
* @TODO ADCocktail: All request parameters, BIDausKAS, WIDausKAS??? *
+ * @TODO ADCocktail: Zero array element is return code! *
* @TODO Affiliblatt: All except banner, do they really have UTF-8? *
- * @TODO AllAds4You: Traffic from abroad *
+ * @TODO AllAds4You: Traffic from abroad, High-Forced banner *
* @TODO doubleads: Which charset? *
* @TODO Fusion-Ads: Has click/banner URL in API response, really UTF-8 *
* @TODO GolloX: Which charset? *
`network_param_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`request_param_key` VARCHAR(10) NOT NULL DEFAULT 'invalid',
-`request_param_value` VARCHAR(10) NOT NULL DEFAULT 'invalid',
+`request_param_key` VARCHAR(20) NOT NULL DEFAULT 'invalid',
+`request_param_value` VARCHAR(20) NOT NULL DEFAULT 'invalid',
`request_param_default` VARCHAR(255) NULL DEFAULT NULL,
UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
UNIQUE `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`),
) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request'");
// Error status codes
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_type_codes`');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_type_codes` (
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_codes`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_codes` (
`network_type_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_code_value` VARCHAR(50) NOT NULL DEFAULT '',
) TYPE={?_TABLE_TYPE?} COMMENT='Error codes for all types'");
// Code types (internal table)
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_codes`');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_codes` (
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_types`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_types` (
`network_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_code` VARCHAR(100) NOT NULL DEFAULT 'INVALID_CODE',
UNIQUE (`network_code`),
// Valid translation keys (we hate hard-coded arrays, you see?)
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` (
-`network_translate_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_translation` VARCHAR(100) NOT NULL DEFAULT '',
-UNIQUE `type_trans` (`network_type_id`,`network_translation`),
-PRIMARY KEY (`network_translate_id`)
+`network_translation_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`network_translation_name` VARCHAR(100) NOT NULL DEFAULT '',
+UNIQUE (`network_translation_name`),
+PRIMARY KEY (`network_translation_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Translations for array keys, generic data, DO NOT ALTER!'");
// Array-Element translation tables per type/provider
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_return_types`');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_return_types` (
-`network_return_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_api_translation`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_api_translation` (
+`network_api_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_return_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_index_translation` VARCHAR(100) NOT NULL DEFAULT '',
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_return_index`),
-UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_index_translation`),
-PRIMARY KEY (`network_return_id`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Return types'");
+`network_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
+`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
+INDEX (`sort`),
+PRIMARY KEY (`network_api_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Translation of API responses, generic data, DO NOT ALTER!'");
// Data from the webmaster (you!)
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
+`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE `provider_type` (`network_id`,`network_type_id`),
PRIMARY KEY (`network_reload_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Reload locks'");
+ // Insert API response array translations, these will be used for calling the right filter function
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_translations` (`network_translation_id`, `network_translation_name`) VALUES
+(1, 'id'),
+(2, 'name'),
+(3, 'alternate_text'),
+(4, 'reload'),
+(5, 'remain'),
+(6, 'reward'),
+(7, 'banner_id'),
+(8, 'size'),
+(9, 'text'),
+(10, 'minimum_stay'),
+(11, 'textlink_id'),
+(12, 'surfbar_id'),
+(13, 'mail_id'),
+(14, 'layer_id'),
+(15, 'popup_id'),
+(16, 'popdown_id'),
+(17, 'lead_id'),
+(18, 'sale_id'),
+(19, 'banner_url1'),
+(20, 'banner_url2'),
+(21, 'banner_url3'),
+(22, 'textlink1'),
+(23, 'textlink2'),
+(24, 'textlink3'),
+(25, 'description'),
+(26, 'traffic_id'),
+(27, 'country_code'),
+(28, 'banner_url4'),
+(29, 'banner_url5'),
+(30, 'banner_url6'),
+(31, 'banner_url7'),
+(32, 'banner_url8'),
+(33, 'banner_url9'),
+(34, 'banner_url10'),
+(35, 'textlink4'),
+(36, 'textlink5'),
+(37, 'subject')");
+
// Insert error code types
// - Affiliate id or interface password wrong
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('AFF_ID_PASS_WRONG')");
- // - Webmaster's site id is not assigned (invalid, different affiliate id)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_NOT_ASSIGNED')");
- // - Webmaster's site id is locked
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_LOCKED')");
- // - General error in interface data
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('INTERFACE_DATA_ERROR')");
- // - Request amount depleted
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('REQUESTS_DEPLETED')");
- // - No campaigns found for given criteria (but maybe there are with more widen criteria)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND')");
- // - No campaigns found with allowed interface output (but there are maybe non-interface campaigns)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND_INTERFACE')");
- // - Webmaster's site id is not unlocked for choosen type
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_NOT_ALLOWED_TYPE')");
- // - Request parameters incomplete
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('REQUEST_PARAMS_INCOMPLETE')");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code_id`, `network_code`) VALUES
+(1, 'AFF_ID_PASS_WRONG'),
+(2, 'SITE_ID_NOT_ASSIGNED'),
+(3, 'SITE_ID_LOCKED'),
+(4, 'INTERFACE_DATA_ERROR'),
+(5, 'REQUESTS_DEPLETED'),
+(6, 'NO_CAMPAIGNS_FOUND'),
+(7, 'NO_CAMPAIGNS_FOUND_INTERFACE'),
+(8, 'SITE_ID_NOT_ALLOWED_TYPE'),
+(9, '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`) VALUES
('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252'),
('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'UTF-8'),
('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252'),
-('hpsonsor', 'HPSponsor', 'http://hpsponsor.de?ref=29', '|', '|', 'GET', 'WINDOWS-1252'),
+('hpsonsor', 'HPSponsor', 'http://hpsponsor.at?ref=29', '|', '|', 'GET', 'WINDOWS-1252'),
('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1'),
('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252'),
('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252'),
('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252'),
+('swizerland', 'The-Swizerland-Ad-Network', 'http://www.the-switzerland-ad-network.ch?ref=3', '|', '|', 'GET', 'WINDOWS-1252'),
('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252'),
('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252'),
('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252')");
(11, 1, 'htmlmail', 'http://www.a3h.de/interface/out_paidmail.php', 'http://www.a3h.de/emailf.php?id=%CID%', NULL)");
// Network type handlers - AbisZED-Netz
+ 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
+(187, 2, 'banner_click', 'http://www.abiszed-netz.de/interface/out_banner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'),
+(188, 2, 'banner_view', 'http://www.abiszed-netz.de/interface/out_banner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'),
+(189, 2, 'textlink_click', 'http://www.abiszed-netz.de/interface/out_textlink.php', 'http://www.abiszed-netz.de/textlinkklick.php?id=%CID%', NULL),
+(190, 2, 'textlink_view', 'http://www.abiszed-netz.de/interface/out_textlink.php', 'http://www.abiszed-netz.de/textlinkklick.php?id=%CID%', NULL),
+(191, 2, 'surfbar_click', 'http://www.abiszed-netz.de/interface/out_sbanner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'),
+(192, 2, 'surfbar_view', 'http://www.abiszed-netz.de/interface/out_sbanner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'),
+(193, 2, 'forcedbanner', 'http://www.abiszed-netz.de/interface/out_fbanner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'),
+(194, 2, 'textmail', 'http://www.abiszed-netz.de/interface/out_paidmail.php', 'http://www.abiszed-netz.de/emailf.php?id=%CID%', NULL),
+(195, 2, 'htmlmail', 'http://www.abiszed-netz.de/interface/out_paidmail.php', 'http://www.abiszed-netz.de/emailf.php?id=%CID%', NULL),
+(196, 2, 'layer_click', 'http://www.abiszed-netz.de/interface/out_layer.php', 'http://www.abiszed-netz.de/layer.php?id=%CID%', NULL),
+(197, 2, 'layer_view', 'http://www.abiszed-netz.de/interface/out_layer.php', 'http://www.abiszed-netz.de/layer.php?id=%CID%', NULL),
+(198, 2, 'popup', 'http://www.abiszed-netz.de/interface/out_popup.php', 'http://www.abiszed-netz.de/popup.php?id=%CID%', NULL),
+(199, 2, 'popdown', 'http://www.abiszed-netz.de/interface/out_popdown.php', 'http://www.abiszed-netz.de/popdown.php?id=%CID%', NULL),
+(200, 2, 'lead', 'http://www.abiszed-netz.de/interface/out_lead.php', 'http://www.abiszed-netz.de/lead.php?id=%CID%', NULL),
+(201, 2, 'sale', 'http://www.abiszed-netz.de/interface/out_sale.php', 'http://www.abiszed-netz.de/sale.php?id=%CID%', NULL)");
// Network type handlers - Ad-Magnet
// Network type handlers - Ads4Webbis
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
-(20, 7, 'banner_click', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(19, 7, 'banner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(24, 7, 'popup', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+(20, 7, 'banner_click', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(19, 7, 'banner_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(24, 7, 'popup', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL)");
// Network type handlers - Ads4World
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
// Network type handlers - HPSponsor
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
-(135, 15, 'banner_click', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(136, 15, 'banner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(137, 15, 'button_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(138, 15, 'forcedbanner', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(139, 15, 'forcedtextlink', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(140, 15, 'popup', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(141, 15, 'skybanner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(142, 15, 'textlink_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(143, 15, 'textmail', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(144, 15, 'traffic', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%CID%', NULL)");
+(135, 15, 'banner_click', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(136, 15, 'banner_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.at/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(137, 15, 'button_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(138, 15, 'forcedbanner', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(139, 15, 'forcedtextlink', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(140, 15, 'popup', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(141, 15, 'skybanner_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(142, 15, 'textlink_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(143, 15, 'textmail', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(144, 15, 'traffic', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/traffic.php?id=%UID%&bid=%CID%&aid=%CID%&trackid=%TID%', NULL)");
// Network type handlers - Make-Euros
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
(101, 19, 'textmail', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
(124, 19, 'traffic', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+ // Network type handlers - Swizerland
+ 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
+(205, 20, 'banner_click', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(204, 20, 'banner_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(207, 20, 'button_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(202, 20, 'forcedbanner', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(203, 20, 'forcedtextlink', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(210, 20, 'popup', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(206, 20, 'skybanner_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(208, 20, 'textlink_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(211, 20, 'textmail', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(209, 20, 'traffic', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+
// Network type handlers - UltraPROMO
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
-(125, 20, 'banner_click', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(126, 20, 'banner_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(127, 20, 'button_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(128, 20, 'forcedbanner', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(129, 20, 'forcedtextlink', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(130, 20, 'popup', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(131, 20, 'skybanner_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(132, 20, 'textlink_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(133, 20, 'textmail', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(134, 20, 'traffic', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+(125, 21, 'banner_click', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(126, 21, 'banner_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(127, 21, 'button_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(128, 21, 'forcedbanner', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(129, 21, 'forcedtextlink', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(130, 21, 'popup', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(131, 21, 'skybanner_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(132, 21, 'textlink_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(133, 21, 'textmail', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(134, 21, 'traffic', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
// Network type handlers - Der Werbepartner.cc
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
-(145, 21, 'textlink_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL),
-(146, 21, 'forcedbanner', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php'),
-(147, 21, 'textmail', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL),
-(148, 21, 'layer', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
-(149, 21, 'skybanner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'),
-(150, 21, 'surfbar_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
-(151, 21, 'banner_view', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'),
-(152, 21, 'popup', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
-(153, 21, 'banner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'),
-(154, 21, 'forcedtextlink', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
-(155, 21, 'traffic', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL)");
+(145, 22, 'textlink_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL),
+(146, 22, 'forcedbanner', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php'),
+(147, 22, 'textmail', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL),
+(148, 22, 'layer', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
+(149, 22, 'skybanner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'),
+(150, 22, 'surfbar_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
+(151, 22, 'banner_view', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'),
+(152, 22, 'popup', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
+(153, 22, 'banner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'),
+(154, 22, 'forcedtextlink', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
+(155, 22, 'traffic', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL)");
// Network type handlers - Yoo!Media
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
-(156, 22, 'banner_click', 'http://www.yoomedia.de/interface_2.0/out_banner.php', 'http://www.yoomedia.de/code/z-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/z-banner.php?id=%UID%&sid=%SID%&bid=%BID%'),
-(157, 22, 'textlink_click', 'http://www.yoomedia.de/interface_2.0/out_textlink.php', 'http://www.yoomedia.de/code/t-textlink.php?id=%UID%&sid=%SID%', NULL),
-(158, 22, 'surfbar_click', 'http://www.yoomedia.de/interface_2.0/out_sbanner.php', 'http://www.yoomedia.de/code/s-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/s-banner.php?id=%UID%&sid=%SID%&bid=%BID%'),
-(159, 22, 'forcedbanner', 'http://www.yoomedia.de/interface_2.0/out_fbanner.php', 'http://www.yoomedia.de/code/f-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/f-banner.php?id=%UID%&sid=%SID%&bid=%BID%'),
-(160, 22, 'pagepeel', 'http://www.yoomedia.de/interface_2.0/out_pagepeel.php', 'http://www.yoomedia.de/code/p-peel.php?id=%UID%&sid=%SID%', NULL),
-(161, 22, 'textmail', 'http://www.yoomedia.de/interface_2.0/out_textmail.php', 'http://www.yoomedia.de/code/t-mail.php?id=%UID%&sid=%SID%', NULL),
-(162, 22, 'htmlmail', 'http://www.yoomedia.de/interface_2.0/out_htmlmail.php', 'http://www.yoomedia.de/code/h-mail.php?id=%UID%&sid=%SID%', NULL),
-(163, 22, 'layer_click', 'http://www.yoomedia.de/interface_2.0/out_layer.php', 'http://www.yoomedia.de/code/l-layer.php?id=%UID%&sid=%SID%', NULL),
-(164, 22, 'popup', 'http://www.yoomedia.de/interface_2.0/out_popup.php', 'http://www.yoomedia.de/code/p-popup.php?id=%UID%&sid=%SID%', NULL),
-(165, 22, 'popdown', 'http://www.yoomedia.de/interface_2.0/out_popdown.php', 'http://www.yoomedia.de/code/p-popdown.php?id=%UID%&sid=%SID%', NULL),
-(166, 22, 'lead', 'http://www.yoomedia.de/interface_2.0/out_lead.php', 'http://www.yoomedia.de/code/lead.php?id=%UID%&sid=%SID%', NULL)");
+(156, 23, 'banner_click', 'http://www.yoomedia.de/interface_2.0/out_banner.php', 'http://www.yoomedia.de/code/z-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/z-banner.php?id=%UID%&sid=%SID%&bid=%BID%'),
+(157, 23, 'textlink_click', 'http://www.yoomedia.de/interface_2.0/out_textlink.php', 'http://www.yoomedia.de/code/t-textlink.php?id=%UID%&sid=%SID%', NULL),
+(158, 23, 'surfbar_click', 'http://www.yoomedia.de/interface_2.0/out_sbanner.php', 'http://www.yoomedia.de/code/s-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/s-banner.php?id=%UID%&sid=%SID%&bid=%BID%'),
+(159, 23, 'forcedbanner', 'http://www.yoomedia.de/interface_2.0/out_fbanner.php', 'http://www.yoomedia.de/code/f-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/f-banner.php?id=%UID%&sid=%SID%&bid=%BID%'),
+(160, 23, 'pagepeel', 'http://www.yoomedia.de/interface_2.0/out_pagepeel.php', 'http://www.yoomedia.de/code/p-peel.php?id=%UID%&sid=%SID%', NULL),
+(161, 23, 'textmail', 'http://www.yoomedia.de/interface_2.0/out_textmail.php', 'http://www.yoomedia.de/code/t-mail.php?id=%UID%&sid=%SID%', NULL),
+(162, 23, 'htmlmail', 'http://www.yoomedia.de/interface_2.0/out_htmlmail.php', 'http://www.yoomedia.de/code/h-mail.php?id=%UID%&sid=%SID%', NULL),
+(163, 23, 'layer_click', 'http://www.yoomedia.de/interface_2.0/out_layer.php', 'http://www.yoomedia.de/code/l-layer.php?id=%UID%&sid=%SID%', NULL),
+(164, 23, 'popup', 'http://www.yoomedia.de/interface_2.0/out_popup.php', 'http://www.yoomedia.de/code/p-popup.php?id=%UID%&sid=%SID%', NULL),
+(165, 23, 'popdown', 'http://www.yoomedia.de/interface_2.0/out_popdown.php', 'http://www.yoomedia.de/code/p-popdown.php?id=%UID%&sid=%SID%', NULL),
+(166, 23, 'lead', 'http://www.yoomedia.de/interface_2.0/out_lead.php', 'http://www.yoomedia.de/code/lead.php?id=%UID%&sid=%SID%', NULL)");
// Request parameters per type handler - A3H
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
(3, 1, 1, 'password', 'pw', NULL),
(4, 1, 1, 'reload', 'reload', NULL),
(5, 1, 1, 'reward', 'verguetung', NULL),
-(6, 1, 1, 'min_stay', 'ma', NULL),
+(6, 1, 1, 'minimum_stay', 'ma', NULL),
(7, 1, 1, 'type', 'typ', NULL),
(8, 1, 1, 'remain', 'uebrig', NULL),
(9, 1, 1, 'size', 'size', NULL),
(26, 1, 4, 'password', 'pw', NULL),
(27, 1, 4, 'reload', 'reload', NULL),
(28, 1, 4, 'reward', 'verguetung', NULL),
-(29, 1, 4, 'min_stay', 'ma', NULL),
+(29, 1, 4, 'minimum_stay', 'ma', NULL),
(30, 1, 4, 'remain', 'uebrig', NULL),
(31, 1, 4, 'size', 'size', NULL),
(32, 1, 5, 'id', 'id', NULL),
(34, 1, 5, 'password', 'pw', NULL),
(35, 1, 5, 'reload', 'reload', NULL),
(36, 1, 5, 'reward', 'verguetung', NULL),
-(37, 1, 5, 'min_stay', 'ma', NULL),
+(37, 1, 5, 'minimum_stay', 'ma', NULL),
(38, 1, 5, 'type', 'typ', 'text'),
(39, 1, 5, 'remain', 'uebrig', NULL),
(40, 1, 11, 'id', 'id', NULL),
(42, 1, 11, 'password', 'pw', NULL),
(43, 1, 11, 'reload', 'reload', NULL),
(44, 1, 11, 'reward', 'verguetung', NULL),
-(45, 1, 11, 'min_stay', 'ma', NULL),
+(45, 1, 11, 'minimum_stay', 'ma', NULL),
(46, 1, 11, 'type', 'typ', 'html'),
(47, 1, 11, 'remain', 'uebrig', NULL),
(48, 1, 6, 'id', 'id', NULL),
(57, 1, 7, 'password', 'pw', NULL),
(58, 1, 7, 'reload', 'reload', NULL),
(59, 1, 7, 'reward', 'verguetung', NULL),
-(60, 1, 7, 'min_stay', 'ma', NULL),
+(60, 1, 7, 'minimum_stay', 'ma', NULL),
(61, 1, 7, 'remain', 'uebrig', NULL),
(62, 1, 8, 'id', 'id', NULL),
(63, 1, 8, 'sid', 'sid', NULL),
(64, 1, 8, 'password', 'pw', NULL),
(65, 1, 8, 'reload', 'reload', NULL),
(66, 1, 8, 'reward', 'verguetung', NULL),
-(67, 1, 8, 'min_stay', 'ma', NULL),
+(67, 1, 8, 'minimum_stay', 'ma', NULL),
(68, 1, 8, 'remain', 'uebrig', NULL),
(69, 1, 9, 'id', 'id', NULL),
(70, 1, 9, 'sid', 'sid', NULL),
(78, 1, 10, 'remain', 'uebrig', NULL)");
// Request parameters per type handler - AbisZED-Netz
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
+(1337, 2, 187, 'id', 'id', NULL),
+(1338, 2, 187, 'sid', 'sid', NULL),
+(1339, 2, 187, 'password', 'pw', NULL),
+(1340, 2, 187, 'reward', 'verguetung', NULL),
+(1341, 2, 187, 'reload', 'reload', NULL),
+(1342, 2, 187, 'remain', 'uebrig', NULL),
+(1343, 2, 187, 'type', 'typ', 'klick'),
+(1344, 2, 187, 'size', 'size', NULL),
+(1345, 2, 188, 'id', 'id', NULL),
+(1346, 2, 188, 'sid', 'sid', NULL),
+(1347, 2, 188, 'password', 'pw', NULL),
+(1349, 2, 188, 'reward', 'verguetung', NULL),
+(1350, 2, 188, 'reload', 'reload', NULL),
+(1351, 2, 188, 'remain', 'uebrig', NULL),
+(1352, 2, 188, 'type', 'typ', 'view'),
+(1353, 2, 188, 'size', 'size', NULL),
+(1354, 2, 189, 'id', 'id', NULL),
+(1355, 2, 189, 'sid', 'sid', NULL),
+(1356, 2, 189, 'password', 'pw', NULL),
+(1357, 2, 189, 'reward', 'verguetung', NULL),
+(1358, 2, 189, 'reload', 'reload', NULL),
+(1359, 2, 189, 'remain', 'uebrig', NULL),
+(1360, 2, 189, 'type', 'typ', 'klick'),
+(1361, 2, 190, 'id', 'id', NULL),
+(1362, 2, 190, 'sid', 'sid', NULL),
+(1363, 2, 190, 'password', 'pw', NULL),
+(1364, 2, 190, 'reward', 'verguetung', NULL),
+(1365, 2, 190, 'reload', 'reload', NULL),
+(1366, 2, 190, 'remain', 'uebrig', NULL),
+(1367, 2, 190, 'type', 'typ', 'view'),
+(1368, 2, 191, 'id', 'id', NULL),
+(1369, 2, 191, 'sid', 'sid', NULL),
+(1370, 2, 191, 'password', 'pw', NULL),
+(1371, 2, 191, 'reward', 'verguetung', NULL),
+(1372, 2, 191, 'reload', 'reload', NULL),
+(1373, 2, 191, 'remain', 'uebrig', NULL),
+(1374, 2, 191, 'type', 'typ', 'klick'),
+(1375, 2, 191, 'size', 'size', NULL),
+(1376, 2, 192, 'id', 'id', NULL),
+(1377, 2, 192, 'sid', 'sid', NULL),
+(1378, 2, 192, 'password', 'pw', NULL),
+(1379, 2, 192, 'reward', 'verguetung', NULL),
+(1380, 2, 192, 'reload', 'reload', NULL),
+(1381, 2, 192, 'remain', 'uebrig', NULL),
+(1382, 2, 192, 'type', 'typ', 'view'),
+(1383, 2, 192, 'size', 'size', NULL),
+(1384, 2, 193, 'id', 'id', NULL),
+(1385, 2, 193, 'sid', 'sid', NULL),
+(1386, 2, 193, 'password', 'pw', NULL),
+(1387, 2, 193, 'reward', 'verguetung', NULL),
+(1388, 2, 193, 'reload', 'reload', NULL),
+(1389, 2, 193, 'remain', 'uebrig', NULL),
+(1390, 2, 193, 'size', 'size', NULL),
+(1391, 2, 193, 'minimum_stay', 'ma', NULL),
+(1392, 2, 194, 'id', 'id', NULL),
+(1393, 2, 194, 'sid', 'sid', NULL),
+(1394, 2, 194, 'password', 'pw', NULL),
+(1395, 2, 194, 'reward', 'verguetung', NULL),
+(1396, 2, 194, 'reload', 'reload', NULL),
+(1397, 2, 194, 'remain', 'uebrig', NULL),
+(1398, 2, 194, 'minimum_stay', 'ma', NULL),
+(1399, 2, 194, 'type', 'typ', 'text'),
+(1400, 2, 195, 'id', 'id', NULL),
+(1401, 2, 195, 'sid', 'sid', NULL),
+(1402, 2, 195, 'password', 'pw', NULL),
+(1403, 2, 195, 'reward', 'verguetung', NULL),
+(1404, 2, 195, 'reload', 'reload', NULL),
+(1405, 2, 195, 'remain', 'uebrig', NULL),
+(1406, 2, 195, 'minimum_stay', 'ma', NULL),
+(1407, 2, 195, 'type', 'typ', 'html'),
+(1408, 2, 196, 'id', 'id', NULL),
+(1409, 2, 196, 'sid', 'sid', NULL),
+(1410, 2, 196, 'password', 'pw', NULL),
+(1411, 2, 196, 'reward', 'verguetung', NULL),
+(1412, 2, 196, 'reload', 'reload', NULL),
+(1413, 2, 196, 'remain', 'uebrig', NULL),
+(1414, 2, 196, 'type', 'typ', 'klick'),
+(1415, 2, 197, 'id', 'id', NULL),
+(1416, 2, 197, 'sid', 'sid', NULL),
+(1417, 2, 197, 'password', 'pw', NULL),
+(1418, 2, 197, 'reward', 'verguetung', NULL),
+(1419, 2, 197, 'reload', 'reload', NULL),
+(1420, 2, 197, 'remain', 'uebrig', NULL),
+(1421, 2, 197, 'type', 'typ', 'view'),
+(1422, 2, 198, 'id', 'id', NULL),
+(1423, 2, 198, 'sid', 'sid', NULL),
+(1424, 2, 198, 'password', 'pw', NULL),
+(1425, 2, 198, 'reward', 'verguetung', NULL),
+(1426, 2, 198, 'reload', 'reload', NULL),
+(1427, 2, 198, 'remain', 'uebrig', NULL),
+(1428, 2, 198, 'minimum_stay', 'ma', NULL),
+(1429, 2, 199, 'id', 'id', NULL),
+(1430, 2, 199, 'sid', 'sid', NULL),
+(1431, 2, 199, 'password', 'pw', NULL),
+(1432, 2, 199, 'reward', 'verguetung', NULL),
+(1433, 2, 199, 'reload', 'reload', NULL),
+(1434, 2, 199, 'remain', 'uebrig', NULL),
+(1435, 2, 199, 'max_stay', 'ma', NULL),
+(1436, 2, 200, 'id', 'id', NULL),
+(1437, 2, 200, 'sid', 'sid', NULL),
+(1438, 2, 200, 'password', 'pw', NULL),
+(1439, 2, 200, 'reward', 'verguetung', NULL),
+(1440, 2, 200, 'remain', 'uebrig', NULL),
+(1441, 2, 201, 'id', 'id', NULL),
+(1442, 2, 201, 'sid', 'sid', NULL),
+(1443, 2, 201, 'password', 'pw', NULL),
+(1444, 2, 201, 'reward', 'verguetung', NULL),
+(1445, 2, 201, 'remain', 'uebrig', NULL)");
// Request parameters per type handler - Ad-Magnet
(1286, 5, 180, 'reload', 'reload', NULL),
(1287, 5, 180, 'remain', 'uebrig', NULL),
(1288, 5, 180, 'size', 'size', '468x60'),
-(1289, 5, 180, 'min_stay', 'ma', NULL),
+(1289, 5, 180, 'minimum_stay', 'ma', NULL),
(1290, 5, 181, 'id', 'id', NULL),
(1291, 5, 181, 'sid', 'sid', NULL),
(1292, 5, 181, 'password', 'pw', NULL),
(1293, 5, 181, 'reload', 'reload', NULL),
(1294, 5, 181, 'reward', 'verguetung', NULL),
(1295, 5, 181, 'remain', 'uebrig', NULL),
-(1296, 5, 181, 'min_stay', 'ma', NULL),
+(1296, 5, 181, 'minimum_stay', 'ma', NULL),
(1297, 5, 181, 'type', 'typ', 'text'),
(1306, 5, 182, 'id', 'id', NULL),
(1307, 5, 182, 'sid', 'sid', NULL),
(1316, 5, 183, 'reload', 'reload', NULL),
(1317, 5, 183, 'reward', 'verguetung', NULL),
(1318, 5, 183, 'remain', 'uebrig', NULL),
-(1319, 5, 183, 'min_stay', 'ma', NULL),
+(1319, 5, 183, 'minimum_stay', 'ma', NULL),
(1320, 5, 184, 'id', 'id', NULL),
(1321, 5, 184, 'sid', 'sid', NULL),
(1322, 5, 184, 'password', 'pw', NULL),
(1323, 5, 184, 'reload', 'reload', NULL),
(1324, 5, 184, 'reward', 'verguetung', NULL),
(1325, 5, 184, 'remain', 'uebrig', NULL),
-(1326, 5, 184, 'min_stay', 'ma', NULL),
+(1326, 5, 184, 'minimum_stay', 'ma', NULL),
(1327, 5, 185, 'id', 'id', NULL),
(1328, 5, 185, 'sid', 'sid', NULL),
(1329, 5, 185, 'password', 'pw', NULL),
(1301, 5, 187, 'reload', 'reload', NULL),
(1302, 5, 187, 'reward', 'verguetung', NULL),
(1303, 5, 187, 'remain', 'uebrig', NULL),
-(1304, 5, 187, 'min_stay', 'ma', NULL),
+(1304, 5, 187, 'minimum_stay', 'ma', NULL),
(1305, 5, 187, 'type', 'typ', 'html')");
// Request parameters per type handler - Ads4
(83, 6, 14, 'reward', 'verg', NULL),
(84, 6, 14, 'reload', 'reload', NULL),
(85, 6, 14, 'remain', 'uebrig', NULL),
-(86, 6, 14, 'min_stay', 'ma', NULL),
+(86, 6, 14, 'minimum_stay', 'ma', NULL),
(87, 6, 15, 'id', 'id', NULL),
(88, 6, 15, 'password', 'pwd', NULL),
(89, 6, 15, 'currency', 'waehrung', NULL),
(91, 6, 15, 'reward', 'verg', NULL),
(92, 6, 15, 'reload', 'reload', NULL),
(93, 6, 15, 'remain', 'uebrig', NULL),
-(94, 6, 15, 'min_stay', 'ma', NULL),
+(94, 6, 15, 'minimum_stay', 'ma', NULL),
(95, 6, 16, 'id', 'id', NULL),
(96, 6, 16, 'password', 'pw', NULL),
(97, 6, 16, 'currency', 'waehrung', NULL),
(99, 6, 16, 'reward', 'verg', NULL),
(100, 6, 16, 'reload', 'reload', NULL),
(101, 6, 16, 'remain', 'uebrig', NULL),
-(102, 6, 16, 'min_stay', 'ma', NULL),
+(102, 6, 16, 'minimum_stay', 'ma', NULL),
(789, 6, 119, 'id', 'id', NULL),
(790, 6, 119, 'password', 'pwd', NULL),
(791, 6, 119, 'currency', 'waehrung', NULL),
(793, 6, 119, 'reward', 'verg', NULL),
(794, 6, 119, 'reload', 'reload', NULL),
(795, 6, 119, 'remain', 'uebrig', NULL),
-(796, 6, 119, 'min_stay', 'ma', NULL)");
+(796, 6, 119, 'minimum_stay', 'ma', NULL)");
// Request parameters per type handler - Ads4Webbis
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
(148, 7, 24, 'remain', 'uebrig', NULL),
(149, 7, 24, 'reload', 'reload', NULL),
(150, 7, 24, 'reward', 'verguetung', NULL),
-(151, 7, 24, 'min_stay', 'ma', NULL),
+(151, 7, 24, 'minimum_stay', 'ma', NULL),
(152, 7, 25, 'extra', 'typ', 'paidmail'),
(153, 7, 25, 'id', 'id', NULL),
(154, 7, 25, 'password', 'pw', NULL),
(155, 7, 25, 'remain', 'uebrig', NULL),
(156, 7, 25, 'reload', 'reload', NULL),
(157, 7, 25, 'reward', 'verguetung', NULL),
-(158, 7, 25, 'min_stay', 'ma', NULL),
+(158, 7, 25, 'minimum_stay', 'ma', NULL),
(797, 7, 120, 'extra', 'typ', 'traffic'),
(798, 7, 120, 'id', 'id', NULL),
(799, 7, 120, 'password', 'pw', NULL),
(192, 8, 33, 'remain', 'uebrig', NULL),
(193, 8, 33, 'reload', 'reload', NULL),
(194, 8, 33, 'reward', 'verguetung', NULL),
-(195, 8, 33, 'min_stay', 'ma', NULL),
+(195, 8, 33, 'minimum_stay', 'ma', NULL),
(196, 8, 30, 'extra', 'typ', 'skybannerview'),
(197, 8, 30, 'id', 'id', NULL),
(198, 8, 30, 'password', 'pw', NULL),
(211, 8, 34, 'remain', 'uebrig', NULL),
(212, 8, 34, 'reload', 'reload', NULL),
(213, 8, 34, 'reward', 'verguetung', NULL),
-(214, 8, 34, 'min_stay', 'ma', NULL),
+(214, 8, 34, 'minimum_stay', 'ma', NULL),
(803, 8, 121, 'extra', 'typ', 'traffic'),
(804, 8, 121, 'id', 'id', NULL),
(805, 8, 121, 'password', 'pw', NULL),
(265, 11, 38, 'reload', 'reload', NULL),
(266, 11, 38, 'remain', 'uebrig', NULL),
(267, 11, 38, 'size', 'size', NULL),
-(268, 11, 38, 'min_stay', 'ma', NULL),
+(268, 11, 38, 'minimum_stay', 'ma', NULL),
(269, 11, 39, 'id', 'id', NULL),
(270, 11, 39, 'sid', 'sid', NULL),
(271, 11, 39, 'password', 'pw', NULL),
(272, 11, 39, 'reward', 'verguetung', NULL),
(273, 11, 39, 'reload', 'reload', NULL),
(274, 11, 39, 'remain', 'uebrig', NULL),
-(275, 11, 39, 'min_stay', 'ma', NULL),
+(275, 11, 39, 'minimum_stay', 'ma', NULL),
(276, 11, 39, 'type', 'typ', 'text'),
(277, 11, 48, 'id', 'id', NULL),
(278, 11, 48, 'sid', 'sid', NULL),
(280, 11, 48, 'reward', 'verguetung', NULL),
(281, 11, 48, 'reload', 'reload', NULL),
(282, 11, 48, 'remain', 'uebrig', NULL),
-(283, 11, 48, 'min_stay', 'ma', NULL),
+(283, 11, 48, 'minimum_stay', 'ma', NULL),
(284, 11, 48, 'type', 'typ', 'html'),
(285, 11, 40, 'id', 'id', NULL),
(286, 11, 40, 'sid', 'sid', NULL),
(302, 11, 41, 'reward', 'verguetung', NULL),
(303, 11, 41, 'reload', 'reload', NULL),
(304, 11, 41, 'remain', 'uebrig', NULL),
-(305, 11, 41, 'min_stay', 'ma', NULL),
+(305, 11, 41, 'minimum_stay', 'ma', NULL),
(306, 11, 42, 'id', 'id', NULL),
(307, 11, 42, 'sid', 'sid', NULL),
(308, 11, 42, 'password', 'pw', NULL),
(309, 11, 42, 'reward', 'verguetung', NULL),
(310, 11, 42, 'reload', 'reload', NULL),
(311, 11, 42, 'remain', 'uebrig', NULL),
-(312, 11, 42, 'min_stay', 'ma', NULL),
+(312, 11, 42, 'minimum_stay', 'ma', NULL),
(313, 11, 43, 'id', 'id', NULL),
(314, 11, 43, 'sid', 'sid', NULL),
(315, 11, 43, 'password', 'pw', NULL),
(357, 12, 54, 'reload', 'reload', NULL),
(358, 12, 54, 'remain', 'uebrig', NULL),
(359, 12, 54, 'size', 'size', NULL),
-(360, 12, 54, 'min_stay', 'ma', NULL),
+(360, 12, 54, 'minimum_stay', 'ma', NULL),
(361, 12, 55, 'id', 'id', NULL),
(362, 12, 55, 'sid', 'sid', NULL),
(363, 12, 55, 'password', 'pw', NULL),
(364, 12, 55, 'reward', 'verguetung', NULL),
(365, 12, 55, 'reload', 'reload', NULL),
(366, 12, 55, 'remain', 'uebrig', NULL),
-(367, 12, 55, 'min_stay', 'ma', NULL),
+(367, 12, 55, 'minimum_stay', 'ma', NULL),
(368, 12, 55, 'type', 'typ', 'text'),
(369, 12, 56, 'id', 'id', NULL),
(370, 12, 56, 'sid', 'sid', NULL),
(372, 12, 56, 'reward', 'verguetung', NULL),
(373, 12, 56, 'reload', 'reload', NULL),
(374, 12, 56, 'remain', 'uebrig', NULL),
-(375, 12, 56, 'min_stay', 'ma', NULL),
+(375, 12, 56, 'minimum_stay', 'ma', NULL),
(376, 12, 56, 'type', 'typ', 'html'),
(377, 12, 57, 'id', 'id', NULL),
(378, 12, 57, 'sid', 'sid', NULL),
(394, 12, 59, 'reward', 'verguetung', NULL),
(395, 12, 59, 'reload', 'reload', NULL),
(396, 12, 59, 'remain', 'uebrig', NULL),
-(397, 12, 59, 'min_stay', 'ma', NULL),
+(397, 12, 59, 'minimum_stay', 'ma', NULL),
(398, 12, 60, 'id', 'id', NULL),
(399, 12, 60, 'sid', 'sid', NULL),
(400, 12, 60, 'password', 'pw', NULL),
(401, 12, 60, 'reward', 'verguetung', NULL),
(402, 12, 60, 'reload', 'reload', NULL),
(403, 12, 60, 'remain', 'uebrig', NULL),
-(404, 12, 60, 'min_stay', 'ma', NULL),
+(404, 12, 60, 'minimum_stay', 'ma', NULL),
(405, 12, 61, 'id', 'id', NULL),
(406, 12, 61, 'sid', 'sid', NULL),
(407, 12, 61, 'password', 'pw', NULL),
(940, 15, 143, 'remain', 'uebrig', NULL),
(941, 15, 143, 'reload', 'reload', NULL),
(942, 15, 143, 'reward', 'verguetung', NULL),
-(943, 15, 143, 'min_stay', 'ma', NULL),
+(943, 15, 143, 'minimum_stay', 'ma', NULL),
(944, 15, 144, 'extra', 'typ', 'paidmail'),
(945, 15, 144, 'id', 'id', NULL),
(946, 15, 144, 'password', 'pw', NULL),
(947, 15, 144, 'remain', 'uebrig', NULL),
(948, 15, 144, 'reload', 'reload', NULL),
(949, 15, 144, 'reward', 'verguetung', NULL),
-(950, 15, 144, 'min_stay', 'ma', NULL)");
+(950, 15, 144, 'minimum_stay', 'ma', NULL)");
// Request parameters per type handler - Make-Euros
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
(465, 16, 68, 'reload', 'reload', NULL),
(466, 16, 68, 'remain', 'uebrig', NULL),
(467, 16, 68, 'size', 'size', NULL),
-(468, 16, 68, 'min_stay', 'ma', NULL),
+(468, 16, 68, 'minimum_stay', 'ma', NULL),
(469, 16, 70, 'id', 'id', NULL),
(470, 16, 70, 'sid', 'sid', NULL),
(471, 16, 70, 'password', 'pw', NULL),
(472, 16, 70, 'reward', 'verguetung', NULL),
(473, 16, 70, 'reload', 'reload', NULL),
(474, 16, 70, 'remain', 'uebrig', NULL),
-(475, 16, 70, 'min_stay', 'ma', NULL),
+(475, 16, 70, 'minimum_stay', 'ma', NULL),
(476, 16, 70, 'type', 'typ', 'text'),
(477, 16, 71, 'id', 'id', NULL),
(478, 16, 71, 'sid', 'sid', NULL),
(480, 16, 71, 'reward', 'verguetung', NULL),
(481, 16, 71, 'reload', 'reload', NULL),
(482, 16, 71, 'remain', 'uebrig', NULL),
-(483, 16, 71, 'min_stay', 'ma', NULL),
+(483, 16, 71, 'minimum_stay', 'ma', NULL),
(484, 16, 71, 'type', 'typ', 'html'),
(485, 16, 72, 'id', 'id', NULL),
(486, 16, 72, 'sid', 'sid', NULL),
(502, 16, 74, 'reward', 'verguetung', NULL),
(503, 16, 74, 'reload', 'reload', NULL),
(504, 16, 74, 'remain', 'uebrig', NULL),
-(505, 16, 74, 'min_stay', 'ma', NULL),
+(505, 16, 74, 'minimum_stay', 'ma', NULL),
(506, 16, 75, 'id', 'id', NULL),
(507, 16, 75, 'sid', 'sid', NULL),
(508, 16, 75, 'password', 'pw', NULL),
(509, 16, 75, 'reward', 'verguetung', NULL),
(510, 16, 75, 'reload', 'reload', NULL),
(511, 16, 75, 'remain', 'uebrig', NULL),
-(512, 16, 75, 'min_stay', 'ma', NULL),
+(512, 16, 75, 'minimum_stay', 'ma', NULL),
(513, 16, 76, 'id', 'id', NULL),
(514, 16, 76, 'sid', 'sid', NULL),
(515, 16, 76, 'password', 'pw', NULL),
(573, 18, 84, 'reload', 'reload', NULL),
(574, 18, 84, 'remain', 'uebrig', NULL),
(575, 18, 84, 'size', 'size', NULL),
-(576, 18, 84, 'min_stay', 'ma', NULL),
+(576, 18, 84, 'minimum_stay', 'ma', NULL),
(577, 18, 85, 'id', 'id', NULL),
(578, 18, 85, 'sid', 'sid', NULL),
(579, 18, 85, 'password', 'pw', NULL),
(580, 18, 85, 'reward', 'verguetung', NULL),
(581, 18, 85, 'reload', 'reload', NULL),
(582, 18, 85, 'remain', 'uebrig', NULL),
-(583, 18, 85, 'min_stay', 'ma', NULL),
+(583, 18, 85, 'minimum_stay', 'ma', NULL),
(584, 18, 85, 'type', 'typ', 'text'),
(585, 18, 86, 'id', 'id', NULL),
(586, 18, 86, 'sid', 'sid', NULL),
(588, 18, 86, 'reward', 'verguetung', NULL),
(589, 18, 86, 'reload', 'reload', NULL),
(590, 18, 86, 'remain', 'uebrig', NULL),
-(591, 18, 86, 'min_stay', 'ma', NULL),
+(591, 18, 86, 'minimum_stay', 'ma', NULL),
(592, 18, 86, 'type', 'typ', 'html'),
(593, 18, 87, 'id', 'id', NULL),
(594, 18, 87, 'sid', 'sid', NULL),
(610, 18, 89, 'reward', 'verguetung', NULL),
(611, 18, 89, 'reload', 'reload', NULL),
(612, 18, 89, 'remain', 'uebrig', NULL),
-(613, 18, 89, 'min_stay', 'ma', NULL),
+(613, 18, 89, 'minimum_stay', 'ma', NULL),
(614, 18, 90, 'id', 'id', NULL),
(615, 18, 90, 'sid', 'sid', NULL),
(616, 18, 90, 'password', 'pw', NULL),
(617, 18, 90, 'reward', 'verguetung', NULL),
(618, 18, 90, 'reload', 'reload', NULL),
(619, 18, 90, 'remain', 'uebrig', NULL),
-(620, 18, 90, 'min_stay', 'ma', NULL),
+(620, 18, 90, 'minimum_stay', 'ma', NULL),
(621, 18, 91, 'id', 'id', NULL),
(622, 18, 91, 'sid', 'sid', NULL),
(623, 18, 91, 'password', 'pw', NULL),
(676, 19, 100, 'reward', 'verguetung', NULL),
(677, 19, 100, 'reload', 'reload', NULL),
(678, 19, 100, 'remain', 'uebrig', NULL),
-(679, 19, 100, 'min_stay', 'ma', NULL),
+(679, 19, 100, 'minimum_stay', 'ma', NULL),
(680, 19, 101, 'extra', 'typ', 'paidmail'),
(681, 19, 101, 'id', 'id', NULL),
(682, 19, 101, 'password', 'pw', NULL),
(683, 19, 101, 'reward', 'verguetung', NULL),
(684, 19, 101, 'reload', 'reload', NULL),
(685, 19, 101, 'remain', 'uebrig', NULL),
-(686, 19, 101, 'min_stay', 'ma', NULL),
+(686, 19, 101, 'minimum_stay', 'ma', NULL),
(821, 19, 124, 'extra', 'typ', 'traffic'),
(822, 19, 124, 'id', 'id', NULL),
(823, 19, 124, 'password', 'pw', NULL),
(825, 19, 124, 'reload', 'reload', NULL),
(826, 19, 124, 'reward', 'verguetung', NULL)");
+ // Request parameters per type handler - Swizerland
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
+(1446, 20, 202, 'extra', 'typ', 'forcedbanner'),
+(1447, 20, 202, 'id', 'id', NULL),
+(1448, 20, 202, 'password', 'pw', NULL),
+(1449, 20, 202, 'remain', 'uebrig', NULL),
+(1450, 20, 202, 'reload', 'reload', NULL),
+(1451, 20, 202, 'reward', 'verguetung', NULL),
+(1452, 20, 203, 'extra', 'typ', 'forcedtextlink'),
+(1453, 20, 203, 'id', 'id', NULL),
+(1454, 20, 203, 'password', 'pw', NULL),
+(1455, 20, 203, 'remain', 'uebrig', NULL),
+(1456, 20, 203, 'reload', 'reload', NULL),
+(1457, 20, 203, 'reward', 'verguetung', NULL),
+(1458, 20, 204, 'extra', 'typ', 'bannerview'),
+(1459, 20, 204, 'id', 'id', NULL),
+(1460, 20, 204, 'password', 'pw', NULL),
+(1461, 20, 204, 'remain', 'uebrig', NULL),
+(1462, 20, 204, 'reload', 'reload', NULL),
+(1463, 20, 204, 'reward', 'verguetung', NULL),
+(1464, 20, 205, 'extra', 'typ', 'bannerklick'),
+(1465, 20, 205, 'id', 'id', NULL),
+(1466, 20, 205, 'password', 'pw', NULL),
+(1467, 20, 205, 'remain', 'uebrig', NULL),
+(1468, 20, 205, 'reload', 'reload', NULL),
+(1469, 20, 205, 'reward', 'verguetung', NULL),
+(1470, 20, 206, 'extra', 'typ', 'skybannerview'),
+(1471, 20, 206, 'id', 'id', NULL),
+(1472, 20, 206, 'password', 'pw', NULL),
+(1473, 20, 206, 'remain', 'uebrig', NULL),
+(1474, 20, 206, 'reload', 'reload', NULL),
+(1475, 20, 206, 'reward', 'verguetung', NULL),
+(1476, 20, 207, 'extra', 'typ', 'buttonview'),
+(1477, 20, 207, 'id', 'id', NULL),
+(1478, 20, 207, 'password', 'pw', NULL),
+(1479, 20, 207, 'remain', 'uebrig', NULL),
+(1480, 20, 207, 'reload', 'reload', NULL),
+(1481, 20, 207, 'reward', 'verguetung', NULL),
+(1482, 20, 208, 'extra', 'typ', 'textview'),
+(1483, 20, 208, 'id', 'id', NULL),
+(1484, 20, 208, 'password', 'pw', NULL),
+(1485, 20, 208, 'remain', 'uebrig', NULL),
+(1486, 20, 208, 'reload', 'reload', NULL),
+(1487, 20, 208, 'reward', 'verguetung', NULL),
+(1488, 20, 209, 'extra', 'typ', 'traffic'),
+(1489, 20, 209, 'id', 'id', NULL),
+(1490, 20, 209, 'password', 'pw', NULL),
+(1491, 20, 209, 'remain', 'uebrig', NULL),
+(1492, 20, 209, 'reload', 'reload', NULL),
+(1493, 20, 209, 'reward', 'verguetung', NULL),
+(1494, 20, 210, 'extra', 'typ', 'popup'),
+(1495, 20, 210, 'id', 'id', NULL),
+(1496, 20, 210, 'password', 'pw', NULL),
+(1497, 20, 210, 'remain', 'uebrig', NULL),
+(1498, 20, 210, 'reload', 'reload', NULL),
+(1499, 20, 210, 'reward', 'verguetung', NULL),
+(1500, 20, 210, 'minimum_stay', 'ma', NULL),
+(1501, 20, 211, 'extra', 'typ', 'paidmail'),
+(1502, 20, 211, 'id', 'id', NULL),
+(1503, 20, 211, 'password', 'pw', NULL),
+(1504, 20, 211, 'remain', 'uebrig', NULL),
+(1505, 20, 211, 'reload', 'reload', NULL),
+(1506, 20, 211, 'reward', 'verguetung', NULL),
+(1507, 20, 211, 'minimum_stay', 'ma', NULL)");
+
// Request parameters per type handler - UltraPROMO
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(827, 20, 128, 'extra', 'typ', 'forcedbanner'),
-(828, 20, 128, 'id', 'id', NULL),
-(829, 20, 128, 'password', 'pw', NULL),
-(830, 20, 128, 'remain', 'uebrig', NULL),
-(831, 20, 128, 'reload', 'reload', NULL),
-(832, 20, 128, 'reward', 'verguetung', NULL),
-(833, 20, 129, 'extra', 'typ', 'forcedtextlink'),
-(834, 20, 129, 'id', 'id', NULL),
-(835, 20, 129, 'password', 'pw', NULL),
-(836, 20, 129, 'remain', 'uebrig', NULL),
-(837, 20, 129, 'reload', 'reload', NULL),
-(838, 20, 129, 'reward', 'verguetung', NULL),
-(839, 20, 126, 'extra', 'typ', 'bannerview'),
-(840, 20, 126, 'id', 'id', NULL),
-(841, 20, 126, 'password', 'pw', NULL),
-(842, 20, 126, 'remain', 'uebrig', NULL),
-(843, 20, 126, 'reload', 'reload', NULL),
-(844, 20, 126, 'reward', 'verguetung', NULL),
-(845, 20, 125, 'extra', 'typ', 'bannerklick'),
-(846, 20, 125, 'id', 'id', NULL),
-(847, 20, 125, 'password', 'pw', NULL),
-(848, 20, 125, 'remain', 'uebrig', NULL),
-(849, 20, 125, 'reload', 'reload', NULL),
-(850, 20, 125, 'reward', 'verguetung', NULL),
-(851, 20, 131, 'extra', 'typ', 'skybannerview'),
-(852, 20, 131, 'id', 'id', NULL),
-(853, 20, 131, 'password', 'pw', NULL),
-(854, 20, 131, 'remain', 'uebrig', NULL),
-(855, 20, 131, 'reload', 'reload', NULL),
-(856, 20, 131, 'reward', 'verguetung', NULL),
-(857, 20, 127, 'extra', 'typ', 'buttonview'),
-(858, 20, 127, 'id', 'id', NULL),
-(859, 20, 127, 'password', 'pw', NULL),
-(860, 20, 127, 'remain', 'uebrig', NULL),
-(861, 20, 127, 'reload', 'reload', NULL),
-(862, 20, 127, 'reward', 'verguetung', NULL),
-(863, 20, 132, 'extra', 'typ', 'textview'),
-(864, 20, 132, 'id', 'id', NULL),
-(865, 20, 132, 'password', 'pw', NULL),
-(866, 20, 132, 'remain', 'uebrig', NULL),
-(867, 20, 132, 'reload', 'reload', NULL),
-(868, 20, 132, 'reward', 'verguetung', NULL),
-(869, 20, 134, 'extra', 'typ', 'traffic'),
-(870, 20, 134, 'id', 'id', NULL),
-(871, 20, 134, 'password', 'pw', NULL),
-(872, 20, 134, 'remain', 'uebrig', NULL),
-(873, 20, 134, 'reload', 'reload', NULL),
-(874, 20, 134, 'reward', 'verguetung', NULL),
-(875, 20, 130, 'extra', 'typ', 'popup'),
-(876, 20, 130, 'id', 'id', NULL),
-(877, 20, 130, 'password', 'pw', NULL),
-(878, 20, 130, 'remain', 'uebrig', NULL),
-(879, 20, 130, 'reload', 'reload', NULL),
-(880, 20, 130, 'reward', 'verguetung', NULL),
-(881, 20, 130, 'min_stay', 'ma', NULL),
-(882, 20, 133, 'extra', 'typ', 'paidmail'),
-(883, 20, 133, 'id', 'id', NULL),
-(884, 20, 133, 'password', 'pw', NULL),
-(885, 20, 133, 'remain', 'uebrig', NULL),
-(886, 20, 133, 'reload', 'reload', NULL),
-(887, 20, 133, 'reward', 'verguetung', NULL),
-(888, 20, 133, 'min_stay', 'ma', NULL)");
+(827, 21, 128, 'extra', 'typ', 'forcedbanner'),
+(828, 21, 128, 'id', 'id', NULL),
+(829, 21, 128, 'password', 'pw', NULL),
+(830, 21, 128, 'remain', 'uebrig', NULL),
+(831, 21, 128, 'reload', 'reload', NULL),
+(832, 21, 128, 'reward', 'verguetung', NULL),
+(833, 21, 129, 'extra', 'typ', 'forcedtextlink'),
+(834, 21, 129, 'id', 'id', NULL),
+(835, 21, 129, 'password', 'pw', NULL),
+(836, 21, 129, 'remain', 'uebrig', NULL),
+(837, 21, 129, 'reload', 'reload', NULL),
+(838, 21, 129, 'reward', 'verguetung', NULL),
+(839, 21, 126, 'extra', 'typ', 'bannerview'),
+(840, 21, 126, 'id', 'id', NULL),
+(841, 21, 126, 'password', 'pw', NULL),
+(842, 21, 126, 'remain', 'uebrig', NULL),
+(843, 21, 126, 'reload', 'reload', NULL),
+(844, 21, 126, 'reward', 'verguetung', NULL),
+(845, 21, 125, 'extra', 'typ', 'bannerklick'),
+(846, 21, 125, 'id', 'id', NULL),
+(847, 21, 125, 'password', 'pw', NULL),
+(848, 21, 125, 'remain', 'uebrig', NULL),
+(849, 21, 125, 'reload', 'reload', NULL),
+(850, 21, 125, 'reward', 'verguetung', NULL),
+(851, 21, 131, 'extra', 'typ', 'skybannerview'),
+(852, 21, 131, 'id', 'id', NULL),
+(853, 21, 131, 'password', 'pw', NULL),
+(854, 21, 131, 'remain', 'uebrig', NULL),
+(855, 21, 131, 'reload', 'reload', NULL),
+(856, 21, 131, 'reward', 'verguetung', NULL),
+(857, 21, 127, 'extra', 'typ', 'buttonview'),
+(858, 21, 127, 'id', 'id', NULL),
+(859, 21, 127, 'password', 'pw', NULL),
+(860, 21, 127, 'remain', 'uebrig', NULL),
+(861, 21, 127, 'reload', 'reload', NULL),
+(862, 21, 127, 'reward', 'verguetung', NULL),
+(863, 21, 132, 'extra', 'typ', 'textview'),
+(864, 21, 132, 'id', 'id', NULL),
+(865, 21, 132, 'password', 'pw', NULL),
+(866, 21, 132, 'remain', 'uebrig', NULL),
+(867, 21, 132, 'reload', 'reload', NULL),
+(868, 21, 132, 'reward', 'verguetung', NULL),
+(869, 21, 134, 'extra', 'typ', 'traffic'),
+(870, 21, 134, 'id', 'id', NULL),
+(871, 21, 134, 'password', 'pw', NULL),
+(872, 21, 134, 'remain', 'uebrig', NULL),
+(873, 21, 134, 'reload', 'reload', NULL),
+(874, 21, 134, 'reward', 'verguetung', NULL),
+(875, 21, 130, 'extra', 'typ', 'popup'),
+(876, 21, 130, 'id', 'id', NULL),
+(877, 21, 130, 'password', 'pw', NULL),
+(878, 21, 130, 'remain', 'uebrig', NULL),
+(879, 21, 130, 'reload', 'reload', NULL),
+(880, 21, 130, 'reward', 'verguetung', NULL),
+(881, 21, 130, 'minimum_stay', 'ma', NULL),
+(882, 21, 133, 'extra', 'typ', 'paidmail'),
+(883, 21, 133, 'id', 'id', NULL),
+(884, 21, 133, 'password', 'pw', NULL),
+(885, 21, 133, 'remain', 'uebrig', NULL),
+(886, 21, 133, 'reload', 'reload', NULL),
+(887, 21, 133, 'reward', 'verguetung', NULL),
+(888, 21, 133, 'minimum_stay', 'ma', NULL)");
// Request parameters per type handler - Der Werbepartner.cc
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(951, 21, 145, 'extra', 'art', 'Textlinkklick'),
-(952, 21, 145, 'reload', 'reload', NULL),
-(953, 21, 145, 'reward', 'verg', NULL),
-(954, 21, 145, 'remain', 'offen', NULL),
-(955, 21, 145, 'sid', 'sid', NULL),
-(956, 21, 145, 'id', 'uid', NULL),
-(957, 21, 145, 'password', 'pw', NULL),
-(958, 21, 146, 'extra', 'art', 'Forcedbanner'),
-(959, 21, 146, 'reload', 'reload', NULL),
-(960, 21, 146, 'reward', 'verg', NULL),
-(961, 21, 146, 'remain', 'offen', NULL),
-(962, 21, 146, 'sid', 'sid', NULL),
-(963, 21, 146, 'id', 'uid', NULL),
-(964, 21, 146, 'password', 'pw', NULL),
-(965, 21, 147, 'extra', 'art', 'Paidmail'),
-(966, 21, 147, 'reload', 'reload', NULL),
-(967, 21, 147, 'reward', 'verg', NULL),
-(968, 21, 147, 'remain', 'offen', NULL),
-(969, 21, 147, 'sid', 'sid', NULL),
-(970, 21, 147, 'id', 'uid', NULL),
-(971, 21, 147, 'password', 'pw', NULL),
-(972, 21, 148, 'extra', 'art', 'Layer'),
-(973, 21, 148, 'reload', 'reload', NULL),
-(974, 21, 148, 'reward', 'verg', NULL),
-(975, 21, 148, 'remain', 'offen', NULL),
-(976, 21, 148, 'sid', 'sid', NULL),
-(977, 21, 148, 'id', 'uid', NULL),
-(978, 21, 148, 'password', 'pw', NULL),
-(979, 21, 149, 'extra', 'art', 'Skybannerklick'),
-(980, 21, 149, 'reload', 'reload', NULL),
-(981, 21, 149, 'reward', 'verg', NULL),
-(982, 21, 149, 'remain', 'offen', NULL),
-(983, 21, 149, 'sid', 'sid', NULL),
-(984, 21, 149, 'id', 'uid', NULL),
-(985, 21, 149, 'password', 'pw', NULL),
-(986, 21, 150, 'extra', 'art', 'Surfbarklick'),
-(987, 21, 150, 'reload', 'reload', NULL),
-(988, 21, 150, 'reward', 'verg', NULL),
-(989, 21, 150, 'remain', 'offen', NULL),
-(990, 21, 150, 'sid', 'sid', NULL),
-(991, 21, 150, 'id', 'uid', NULL),
-(992, 21, 150, 'password', 'pw', NULL),
-(993, 21, 151, 'extra', 'art', 'Bannerview'),
-(994, 21, 151, 'reload', 'reload', NULL),
-(995, 21, 151, 'reward', 'verg', NULL),
-(996, 21, 151, 'remain', 'offen', NULL),
-(997, 21, 151, 'sid', 'sid', NULL),
-(998, 21, 151, 'id', 'uid', NULL),
-(999, 21, 151, 'password', 'pw', NULL),
-(1000, 21, 152, 'extra', 'art', 'PopUp'),
-(1001, 21, 152, 'reload', 'reload', NULL),
-(1002, 21, 152, 'reward', 'verg', NULL),
-(1003, 21, 152, 'remain', 'offen', NULL),
-(1004, 21, 152, 'sid', 'sid', NULL),
-(1005, 21, 152, 'id', 'uid', NULL),
-(1006, 21, 152, 'password', 'pw', NULL),
-(1007, 21, 153, 'extra', 'art', 'Bannerklick'),
-(1008, 21, 153, 'reload', 'reload', NULL),
-(1009, 21, 153, 'reward', 'verg', NULL),
-(1010, 21, 153, 'type', 'offen', NULL),
-(1011, 21, 153, 'sid', 'sid', NULL),
-(1012, 21, 153, 'id', 'uid', NULL),
-(1013, 21, 153, 'password', 'pw', NULL),
-(1014, 21, 154, 'extra', 'art', 'Forcedtextlink'),
-(1015, 21, 154, 'reload', 'reload', NULL),
-(1016, 21, 154, 'reward', 'verg', NULL),
-(1017, 21, 154, 'remain', 'offen', NULL),
-(1018, 21, 154, 'sid', 'sid', NULL),
-(1019, 21, 154, 'id', 'uid', NULL),
-(1020, 21, 154, 'password', 'pw', NULL),
-(1021, 21, 155, 'extra', 'art', 'Traffic'),
-(1022, 21, 155, 'reload', 'reload', NULL),
-(1023, 21, 155, 'reward', 'verg', NULL),
-(1024, 21, 155, 'remain', 'offen', NULL),
-(1025, 21, 155, 'sid', 'sid', NULL),
-(1026, 21, 155, 'id', 'id', NULL),
-(1027, 21, 155, 'password', 'pw', NULL)");
+(951, 22, 145, 'extra', 'art', 'Textlinkklick'),
+(952, 22, 145, 'reload', 'reload', NULL),
+(953, 22, 145, 'reward', 'verg', NULL),
+(954, 22, 145, 'remain', 'offen', NULL),
+(955, 22, 145, 'sid', 'sid', NULL),
+(956, 22, 145, 'id', 'uid', NULL),
+(957, 22, 145, 'password', 'pw', NULL),
+(958, 22, 146, 'extra', 'art', 'Forcedbanner'),
+(959, 22, 146, 'reload', 'reload', NULL),
+(960, 22, 146, 'reward', 'verg', NULL),
+(961, 22, 146, 'remain', 'offen', NULL),
+(962, 22, 146, 'sid', 'sid', NULL),
+(963, 22, 146, 'id', 'uid', NULL),
+(964, 22, 146, 'password', 'pw', NULL),
+(965, 22, 147, 'extra', 'art', 'Paidmail'),
+(966, 22, 147, 'reload', 'reload', NULL),
+(967, 22, 147, 'reward', 'verg', NULL),
+(968, 22, 147, 'remain', 'offen', NULL),
+(969, 22, 147, 'sid', 'sid', NULL),
+(970, 22, 147, 'id', 'uid', NULL),
+(971, 22, 147, 'password', 'pw', NULL),
+(972, 22, 148, 'extra', 'art', 'Layer'),
+(973, 22, 148, 'reload', 'reload', NULL),
+(974, 22, 148, 'reward', 'verg', NULL),
+(975, 22, 148, 'remain', 'offen', NULL),
+(976, 22, 148, 'sid', 'sid', NULL),
+(977, 22, 148, 'id', 'uid', NULL),
+(978, 22, 148, 'password', 'pw', NULL),
+(979, 22, 149, 'extra', 'art', 'Skybannerklick'),
+(980, 22, 149, 'reload', 'reload', NULL),
+(981, 22, 149, 'reward', 'verg', NULL),
+(982, 22, 149, 'remain', 'offen', NULL),
+(983, 22, 149, 'sid', 'sid', NULL),
+(984, 22, 149, 'id', 'uid', NULL),
+(985, 22, 149, 'password', 'pw', NULL),
+(986, 22, 150, 'extra', 'art', 'Surfbarklick'),
+(987, 22, 150, 'reload', 'reload', NULL),
+(988, 22, 150, 'reward', 'verg', NULL),
+(989, 22, 150, 'remain', 'offen', NULL),
+(990, 22, 150, 'sid', 'sid', NULL),
+(991, 22, 150, 'id', 'uid', NULL),
+(992, 22, 150, 'password', 'pw', NULL),
+(993, 22, 151, 'extra', 'art', 'Bannerview'),
+(994, 22, 151, 'reload', 'reload', NULL),
+(995, 22, 151, 'reward', 'verg', NULL),
+(996, 22, 151, 'remain', 'offen', NULL),
+(997, 22, 151, 'sid', 'sid', NULL),
+(998, 22, 151, 'id', 'uid', NULL),
+(999, 22, 151, 'password', 'pw', NULL),
+(1000, 22, 152, 'extra', 'art', 'PopUp'),
+(1001, 22, 152, 'reload', 'reload', NULL),
+(1002, 22, 152, 'reward', 'verg', NULL),
+(1003, 22, 152, 'remain', 'offen', NULL),
+(1004, 22, 152, 'sid', 'sid', NULL),
+(1005, 22, 152, 'id', 'uid', NULL),
+(1006, 22, 152, 'password', 'pw', NULL),
+(1007, 22, 153, 'extra', 'art', 'Bannerklick'),
+(1008, 22, 153, 'reload', 'reload', NULL),
+(1009, 22, 153, 'reward', 'verg', NULL),
+(1010, 22, 153, 'type', 'offen', NULL),
+(1011, 22, 153, 'sid', 'sid', NULL),
+(1012, 22, 153, 'id', 'uid', NULL),
+(1013, 22, 153, 'password', 'pw', NULL),
+(1014, 22, 154, 'extra', 'art', 'Forcedtextlink'),
+(1015, 22, 154, 'reload', 'reload', NULL),
+(1016, 22, 154, 'reward', 'verg', NULL),
+(1017, 22, 154, 'remain', 'offen', NULL),
+(1018, 22, 154, 'sid', 'sid', NULL),
+(1019, 22, 154, 'id', 'uid', NULL),
+(1020, 22, 154, 'password', 'pw', NULL),
+(1021, 22, 155, 'extra', 'art', 'Traffic'),
+(1022, 22, 155, 'reload', 'reload', NULL),
+(1023, 22, 155, 'reward', 'verg', NULL),
+(1024, 22, 155, 'remain', 'offen', NULL),
+(1025, 22, 155, 'sid', 'sid', NULL),
+(1026, 22, 155, 'id', 'id', NULL),
+(1027, 22, 155, 'password', 'pw', NULL)");
// Request parameters per type handler - Yoo!Media
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(1028, 22, 156, 'id', 'id', NULL),
-(1029, 22, 156, 'sid', 'sid', NULL),
-(1030, 22, 156, 'password', 'pw', NULL),
-(1031, 22, 156, 'reload', 'reload', NULL),
-(1032, 22, 156, 'remain', 'uebrig', NULL),
-(1033, 22, 156, 'reward', 'verguetung', NULL),
-(1034, 22, 156, 'size', 'size', '468x60'),
-(1035, 22, 156, 'erotic', 'erotik', NULL),
-(1036, 22, 157, 'id', 'id', NULL),
-(1037, 22, 157, 'sid', 'sid', NULL),
-(1038, 22, 157, 'password', 'pw', NULL),
-(1039, 22, 157, 'reload', 'reload', NULL),
-(1040, 22, 157, 'reward', 'verguetung', NULL),
-(1041, 22, 157, 'erotic', 'erotik', NULL),
-(1042, 22, 157, 'remain', 'uebrig', NULL),
-(1043, 22, 158, 'id', 'id', NULL),
-(1044, 22, 158, 'sid', 'sid', NULL),
-(1045, 22, 158, 'password', 'pw', NULL),
-(1046, 22, 158, 'reload', 'reload', NULL),
-(1047, 22, 158, 'reward', 'verguetung', NULL),
-(1048, 22, 158, 'remain', 'uebrig', NULL),
-(1049, 22, 158, 'size', 'size', '468x60'),
-(1050, 22, 158, 'erotic', 'erotik', NULL),
-(1051, 22, 159, 'id', 'id', NULL),
-(1052, 22, 159, 'sid', 'sid', NULL),
-(1053, 22, 159, 'password', 'pw', NULL),
-(1054, 22, 159, 'reload', 'reload', NULL),
-(1055, 22, 159, 'min_stay', 'ma', NULL),
-(1056, 22, 159, 'remain', 'uebrig', NULL),
-(1057, 22, 159, 'reward', 'verguetung', NULL),
-(1058, 22, 159, 'size', 'size', '468x60'),
-(1059, 22, 159, 'erotic', 'erotik', NULL),
-(1060, 22, 160, 'id', 'id', NULL),
-(1061, 22, 160, 'sid', 'sid', NULL),
-(1062, 22, 160, 'password', 'pw', NULL),
-(1063, 22, 160, 'reload', 'reload', NULL),
-(1064, 22, 160, 'remain', 'uebrig', NULL),
-(1065, 22, 160, 'reward', 'verguetung', NULL),
-(1066, 22, 160, 'erotic', 'erotik', NULL),
-(1067, 22, 161, 'id', 'id', NULL),
-(1068, 22, 161, 'sid', 'sid', NULL),
-(1069, 22, 161, 'password', 'pw', NULL),
-(1070, 22, 161, 'reload', 'reload', NULL),
-(1071, 22, 161, 'min_stay', 'ma', NULL),
-(1072, 22, 161, 'remain', 'uebrig', NULL),
-(1073, 22, 161, 'reward', 'verguetung', NULL),
-(1074, 22, 161, 'erotic', 'erotik', NULL),
-(1075, 22, 162, 'id', 'id', NULL),
-(1076, 22, 162, 'sid', 'sid', NULL),
-(1077, 22, 162, 'password', 'pw', NULL),
-(1078, 22, 162, 'reload', 'reload', NULL),
-(1079, 22, 162, 'min_stay', 'ma', NULL),
-(1080, 22, 162, 'remain', 'uebrig', NULL),
-(1081, 22, 162, 'reward', 'verguetung', NULL),
-(1082, 22, 162, 'erotic', 'erotik', NULL),
-(1083, 22, 163, 'id', 'id', NULL),
-(1084, 22, 163, 'sid', 'sid', NULL),
-(1085, 22, 163, 'password', 'pw', NULL),
-(1086, 22, 163, 'reload', 'reload', NULL),
-(1087, 22, 163, 'remain', 'uebrig', NULL),
-(1088, 22, 163, 'reward', 'verguetung', NULL),
-(1089, 22, 163, 'erotic', 'erotik', NULL),
-(1090, 22, 164, 'id', 'id', NULL),
-(1091, 22, 164, 'sid', 'sid', NULL),
-(1092, 22, 164, 'password', 'pw', NULL),
-(1093, 22, 164, 'reload', 'reload', NULL),
-(1094, 22, 164, 'min_stay', 'ma', NULL),
-(1095, 22, 164, 'remain', 'uebrig', NULL),
-(1096, 22, 164, 'reward', 'verguetung', NULL),
-(1097, 22, 164, 'erotic', 'erotik', NULL),
-(1098, 22, 165, 'id', 'id', NULL),
-(1099, 22, 165, 'sid', 'sid', NULL),
-(1100, 22, 165, 'password', 'pw', NULL),
-(1101, 22, 165, 'reload', 'reload', NULL),
-(1102, 22, 165, 'min_stay', 'ma', NULL),
-(1103, 22, 165, 'reward', 'verguetung', NULL),
-(1104, 22, 165, 'remain', 'uebrig', NULL),
-(1105, 22, 165, 'erotic', 'erotik', NULL),
-(1106, 22, 166, 'id', 'id', NULL),
-(1107, 22, 166, 'sid', 'sid', NULL),
-(1108, 22, 166, 'password', 'pw', NULL),
-(1109, 22, 166, 'remain', 'uebrig', NULL),
-(1110, 22, 166, 'reward', 'verguetung', NULL),
-(1111, 22, 166, 'erotic', 'erotik', NULL)");
-
- // Fix empty defaults to NULL
- addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_types` SET `network_type_banner_url`=NULL WHERE `network_type_banner_url`=''");
- addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_request_params` SET `request_param_default`=NULL WHERE `request_param_default`=''");
+(1028, 23, 156, 'id', 'id', NULL),
+(1029, 23, 156, 'sid', 'sid', NULL),
+(1030, 23, 156, 'password', 'pw', NULL),
+(1031, 23, 156, 'reload', 'reload', NULL),
+(1032, 23, 156, 'remain', 'uebrig', NULL),
+(1033, 23, 156, 'reward', 'verguetung', NULL),
+(1034, 23, 156, 'size', 'size', '468x60'),
+(1035, 23, 156, 'erotic', 'erotik', NULL),
+(1036, 23, 157, 'id', 'id', NULL),
+(1037, 23, 157, 'sid', 'sid', NULL),
+(1038, 23, 157, 'password', 'pw', NULL),
+(1039, 23, 157, 'reload', 'reload', NULL),
+(1040, 23, 157, 'reward', 'verguetung', NULL),
+(1041, 23, 157, 'erotic', 'erotik', NULL),
+(1042, 23, 157, 'remain', 'uebrig', NULL),
+(1043, 23, 158, 'id', 'id', NULL),
+(1044, 23, 158, 'sid', 'sid', NULL),
+(1045, 23, 158, 'password', 'pw', NULL),
+(1046, 23, 158, 'reload', 'reload', NULL),
+(1047, 23, 158, 'reward', 'verguetung', NULL),
+(1048, 23, 158, 'remain', 'uebrig', NULL),
+(1049, 23, 158, 'size', 'size', '468x60'),
+(1050, 23, 158, 'erotic', 'erotik', NULL),
+(1051, 23, 159, 'id', 'id', NULL),
+(1052, 23, 159, 'sid', 'sid', NULL),
+(1053, 23, 159, 'password', 'pw', NULL),
+(1054, 23, 159, 'reload', 'reload', NULL),
+(1055, 23, 159, 'minimum_stay', 'ma', NULL),
+(1056, 23, 159, 'remain', 'uebrig', NULL),
+(1057, 23, 159, 'reward', 'verguetung', NULL),
+(1058, 23, 159, 'size', 'size', '468x60'),
+(1059, 23, 159, 'erotic', 'erotik', NULL),
+(1060, 23, 160, 'id', 'id', NULL),
+(1061, 23, 160, 'sid', 'sid', NULL),
+(1062, 23, 160, 'password', 'pw', NULL),
+(1063, 23, 160, 'reload', 'reload', NULL),
+(1064, 23, 160, 'remain', 'uebrig', NULL),
+(1065, 23, 160, 'reward', 'verguetung', NULL),
+(1066, 23, 160, 'erotic', 'erotik', NULL),
+(1067, 23, 161, 'id', 'id', NULL),
+(1068, 23, 161, 'sid', 'sid', NULL),
+(1069, 23, 161, 'password', 'pw', NULL),
+(1070, 23, 161, 'reload', 'reload', NULL),
+(1071, 23, 161, 'minimum_stay', 'ma', NULL),
+(1072, 23, 161, 'remain', 'uebrig', NULL),
+(1073, 23, 161, 'reward', 'verguetung', NULL),
+(1074, 23, 161, 'erotic', 'erotik', NULL),
+(1075, 23, 162, 'id', 'id', NULL),
+(1076, 23, 162, 'sid', 'sid', NULL),
+(1077, 23, 162, 'password', 'pw', NULL),
+(1078, 23, 162, 'reload', 'reload', NULL),
+(1079, 23, 162, 'minimum_stay', 'ma', NULL),
+(1080, 23, 162, 'remain', 'uebrig', NULL),
+(1081, 23, 162, 'reward', 'verguetung', NULL),
+(1082, 23, 162, 'erotic', 'erotik', NULL),
+(1083, 23, 163, 'id', 'id', NULL),
+(1084, 23, 163, 'sid', 'sid', NULL),
+(1085, 23, 163, 'password', 'pw', NULL),
+(1086, 23, 163, 'reload', 'reload', NULL),
+(1087, 23, 163, 'remain', 'uebrig', NULL),
+(1088, 23, 163, 'reward', 'verguetung', NULL),
+(1089, 23, 163, 'erotic', 'erotik', NULL),
+(1090, 23, 164, 'id', 'id', NULL),
+(1091, 23, 164, 'sid', 'sid', NULL),
+(1092, 23, 164, 'password', 'pw', NULL),
+(1093, 23, 164, 'reload', 'reload', NULL),
+(1094, 23, 164, 'minimum_stay', 'ma', NULL),
+(1095, 23, 164, 'remain', 'uebrig', NULL),
+(1096, 23, 164, 'reward', 'verguetung', NULL),
+(1097, 23, 164, 'erotic', 'erotik', NULL),
+(1098, 23, 165, 'id', 'id', NULL),
+(1099, 23, 165, 'sid', 'sid', NULL),
+(1100, 23, 165, 'password', 'pw', NULL),
+(1101, 23, 165, 'reload', 'reload', NULL),
+(1102, 23, 165, 'minimum_stay', 'ma', NULL),
+(1103, 23, 165, 'reward', 'verguetung', NULL),
+(1104, 23, 165, 'remain', 'uebrig', NULL),
+(1105, 23, 165, 'erotic', 'erotik', NULL),
+(1106, 23, 166, 'id', 'id', NULL),
+(1107, 23, 166, 'sid', 'sid', NULL),
+(1108, 23, 166, 'password', 'pw', NULL),
+(1109, 23, 166, 'remain', 'uebrig', NULL),
+(1110, 23, 166, 'reward', 'verguetung', NULL),
+(1111, 23, 166, 'erotic', 'erotik', NULL)");
+
+ // API array elements - A3H
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(1, 1, 1, 7, 1),
+(2, 1, 1, 2, 2),
+(3, 1, 1, 3, 3),
+(4, 1, 1, 4, 4),
+(5, 1, 1, 5, 5),
+(6, 1, 1, 6, 6),
+(7, 1, 1, 8, 7),
+(8, 1, 1, 10, 8),
+(9, 1, 2, 11, 1),
+(10, 1, 2, 2, 2),
+(11, 1, 2, 9, 3),
+(12, 1, 2, 4, 4),
+(13, 1, 2, 5, 5),
+(14, 1, 2, 6, 6),
+(15, 1, 3, 12, 1),
+(16, 1, 3, 2, 2),
+(17, 1, 3, 3, 3),
+(18, 1, 3, 4, 4),
+(19, 1, 3, 5, 5),
+(20, 1, 3, 6, 6),
+(21, 1, 3, 8, 7),
+(22, 1, 4, 7, 1),
+(23, 1, 4, 2, 2),
+(24, 1, 4, 3, 3),
+(25, 1, 4, 4, 4),
+(26, 1, 4, 5, 5),
+(27, 1, 4, 6, 6),
+(28, 1, 4, 10, 7),
+(29, 1, 4, 8, 8),
+(30, 1, 5, 13, 1),
+(31, 1, 5, 2, 2),
+(32, 1, 5, 4, 3),
+(33, 1, 5, 5, 4),
+(34, 1, 5, 6, 5),
+(35, 1, 5, 10, 6),
+(36, 1, 5, 9, 7),
+(37, 1, 6, 14, 1),
+(38, 1, 6, 2, 2),
+(39, 1, 6, 4, 3),
+(40, 1, 6, 5, 4),
+(41, 1, 6, 6, 5),
+(42, 1, 7, 15, 1),
+(43, 1, 7, 2, 2),
+(44, 1, 7, 4, 3),
+(45, 1, 7, 5, 4),
+(46, 1, 7, 6, 5),
+(47, 1, 7, 10, 6),
+(48, 1, 8, 16, 1),
+(49, 1, 8, 2, 2),
+(50, 1, 8, 4, 3),
+(51, 1, 8, 5, 4),
+(52, 1, 8, 6, 5),
+(53, 1, 8, 10, 6),
+(54, 1, 9, 17, 1),
+(55, 1, 9, 2, 2),
+(56, 1, 9, 6, 3),
+(57, 1, 9, 19, 4),
+(58, 1, 9, 20, 5),
+(59, 1, 9, 21, 6),
+(60, 1, 9, 22, 7),
+(61, 1, 9, 23, 8),
+(62, 1, 9, 9, 9),
+(63, 1, 9, 25, 10),
+(64, 1, 9, 5, 11),
+(65, 1, 10, 18, 1),
+(66, 1, 10, 2, 2),
+(67, 1, 10, 6, 3),
+(68, 1, 10, 19, 4),
+(69, 1, 10, 20, 5),
+(70, 1, 10, 21, 6),
+(71, 1, 10, 22, 7),
+(72, 1, 10, 23, 8),
+(73, 1, 10, 9, 9),
+(74, 1, 10, 25, 10)");
+
+ // API array elements - AbisZED-Netz
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(75, 2, 187, 7, 1),
+(76, 2, 187, 2, 2),
+(77, 2, 187, 3, 3),
+(78, 2, 187, 4, 4),
+(79, 2, 187, 5, 5),
+(80, 2, 187, 6, 6),
+(81, 2, 187, 8, 7),
+(82, 2, 187, 10, 8),
+(83, 2, 188, 7, 1),
+(84, 2, 188, 2, 2),
+(85, 2, 188, 3, 3),
+(86, 2, 188, 4, 4),
+(87, 2, 188, 5, 5),
+(88, 2, 188, 6, 6),
+(89, 2, 188, 8, 7),
+(90, 2, 188, 10, 8),
+(91, 2, 189, 11, 1),
+(92, 2, 189, 2, 2),
+(93, 2, 189, 9, 3),
+(94, 2, 189, 4, 4),
+(95, 2, 189, 5, 5),
+(96, 2, 189, 6, 6),
+(97, 2, 190, 11, 1),
+(98, 2, 190, 2, 2),
+(99, 2, 190, 9, 3),
+(100, 2, 190, 4, 4),
+(101, 2, 190, 5, 5),
+(102, 2, 190, 6, 6),
+(103, 2, 191, 12, 1),
+(104, 2, 191, 2, 2),
+(105, 2, 191, 3, 3),
+(106, 2, 191, 4, 4),
+(107, 2, 191, 5, 5),
+(108, 2, 191, 6, 6),
+(109, 2, 191, 8, 7),
+(110, 2, 192, 12, 1),
+(111, 2, 192, 10, 2),
+(112, 2, 192, 3, 3),
+(113, 2, 192, 4, 4),
+(114, 2, 192, 5, 5),
+(115, 2, 192, 6, 6),
+(116, 2, 192, 8, 7),
+(117, 2, 193, 7, 1),
+(118, 2, 193, 2, 2),
+(119, 2, 193, 3, 3),
+(120, 2, 193, 4, 4),
+(121, 2, 193, 5, 5),
+(122, 2, 193, 6, 6),
+(123, 2, 193, 10, 7),
+(124, 2, 193, 8, 8),
+(125, 2, 194, 13, 1),
+(126, 2, 194, 2, 2),
+(127, 2, 194, 4, 3),
+(128, 2, 194, 5, 4),
+(129, 2, 194, 6, 5),
+(130, 2, 194, 10, 6),
+(131, 2, 194, 9, 7),
+(132, 2, 195, 13, 1),
+(133, 2, 195, 2, 2),
+(134, 2, 195, 4, 3),
+(135, 2, 195, 5, 4),
+(136, 2, 195, 6, 5),
+(137, 2, 195, 10, 6),
+(138, 2, 195, 9, 7),
+(139, 2, 196, 14, 1),
+(140, 2, 196, 2, 2),
+(141, 2, 196, 4, 3),
+(142, 2, 196, 5, 4),
+(143, 2, 196, 6, 5),
+(144, 2, 197, 14, 1),
+(145, 2, 197, 2, 2),
+(146, 2, 197, 4, 3),
+(147, 2, 197, 5, 4),
+(148, 2, 197, 6, 5),
+(149, 2, 198, 15, 1),
+(150, 2, 198, 2, 2),
+(151, 2, 198, 4, 3),
+(152, 2, 198, 5, 4),
+(153, 2, 198, 6, 5),
+(154, 2, 198, 10, 6),
+(155, 2, 199, 16, 1),
+(156, 2, 199, 2, 2),
+(157, 2, 199, 4, 3),
+(158, 2, 199, 5, 4),
+(159, 2, 199, 6, 5),
+(160, 2, 199, 10, 6),
+(161, 2, 200, 17, 1),
+(162, 2, 200, 2, 2),
+(163, 2, 200, 6, 3),
+(164, 2, 200, 19, 4),
+(165, 2, 200, 20, 5),
+(166, 2, 200, 21, 6),
+(167, 2, 200, 22, 7),
+(168, 2, 200, 23, 8),
+(169, 2, 200, 9, 9),
+(170, 2, 200, 25, 10),
+(171, 2, 200, 5, 11),
+(172, 2, 201, 18, 1),
+(173, 2, 201, 2, 2),
+(174, 2, 201, 6, 3),
+(175, 2, 201, 19, 4),
+(176, 2, 201, 20, 5),
+(177, 2, 201, 21, 6),
+(178, 2, 201, 22, 7),
+(179, 2, 201, 23, 8),
+(180, 2, 201, 9, 9),
+(181, 2, 201, 25, 10)");
+
+ // API array elements - AD-Magnet
+
+ // API array elements - ADCocktail
+
+ // API array elements - AdPaid
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(182, 5, 177, 7, 1),
+(183, 5, 177, 2, 2),
+(184, 5, 177, 3, 3),
+(185, 5, 177, 4, 4),
+(186, 5, 177, 5, 5),
+(187, 5, 177, 6, 6),
+(188, 5, 177, 8, 7),
+(189, 5, 177, 10, 8),
+(190, 5, 178, 11, 1),
+(191, 5, 178, 2, 2),
+(192, 5, 178, 9, 3),
+(193, 5, 178, 4, 4),
+(194, 5, 178, 5, 5),
+(195, 5, 178, 6, 6),
+(196, 5, 179, 12, 1),
+(197, 5, 179, 2, 2),
+(198, 5, 179, 3, 3),
+(199, 5, 179, 4, 4),
+(200, 5, 179, 5, 5),
+(201, 5, 179, 6, 6),
+(202, 5, 179, 8, 7),
+(203, 5, 180, 7, 1),
+(204, 5, 180, 2, 2),
+(205, 5, 180, 3, 3),
+(206, 5, 180, 4, 4),
+(207, 5, 180, 5, 5),
+(208, 5, 180, 6, 6),
+(209, 5, 180, 10, 7),
+(210, 5, 180, 8, 8),
+(211, 5, 181, 13, 1),
+(212, 5, 181, 2, 2),
+(213, 5, 181, 4, 3),
+(214, 5, 181, 5, 4),
+(215, 5, 181, 6, 5),
+(216, 5, 181, 10, 6),
+(217, 5, 181, 9, 7),
+(218, 5, 182, 14, 1),
+(219, 5, 182, 2, 2),
+(220, 5, 182, 4, 3),
+(221, 5, 182, 5, 4),
+(222, 5, 182, 6, 5),
+(223, 5, 183, 15, 1),
+(224, 5, 183, 2, 2),
+(225, 5, 183, 4, 3),
+(226, 5, 183, 5, 4),
+(227, 5, 183, 6, 5),
+(228, 5, 183, 10, 6),
+(229, 5, 185, 17, 1),
+(230, 5, 185, 2, 2),
+(231, 5, 185, 6, 3),
+(232, 5, 185, 19, 4),
+(233, 5, 185, 20, 5),
+(234, 5, 185, 21, 6),
+(235, 5, 185, 22, 7),
+(236, 5, 185, 23, 8),
+(237, 5, 185, 9, 9)");
+
+ // API array elements - Ads4.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(239, 6, 14, 7, 1),
+(240, 6, 14, 2, 2),
+(241, 6, 14, 6, 3),
+(242, 6, 14, 4, 4),
+(243, 6, 14, 5, 5),
+(244, 6, 14, 10, 6),
+(245, 6, 15, 13, 1),
+(246, 6, 15, 2, 2),
+(247, 6, 15, 6, 3),
+(248, 6, 15, 4, 4),
+(249, 6, 15, 5, 5),
+(250, 6, 15, 10, 6),
+(251, 6, 16, 13, 1),
+(252, 6, 16, 2, 2),
+(253, 6, 16, 6, 3),
+(254, 6, 16, 4, 4),
+(255, 6, 16, 5, 5),
+(256, 6, 16, 10, 6),
+(257, 6, 119, 26, 1),
+(258, 6, 119, 2, 2),
+(259, 6, 119, 6, 3),
+(260, 6, 119, 4, 4),
+(261, 6, 119, 5, 5),
+(262, 6, 119, 10, 6)");
+
+ // API array elements - Ads4Webbis
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(263, 7, 20, 1, 1),
+(264, 7, 20, 2, 2),
+(265, 7, 20, 4, 3),
+(266, 7, 20, 5, 4),
+(267, 7, 20, 6, 5),
+(268, 7, 20, 10, 6),
+(269, 7, 20, 9, 7),
+(270, 7, 20, 27, 8),
+(271, 7, 19, 1, 1),
+(272, 7, 19, 2, 2),
+(273, 7, 19, 4, 3),
+(274, 7, 19, 5, 4),
+(275, 7, 19, 6, 5),
+(276, 7, 19, 10, 6),
+(277, 7, 19, 9, 7),
+(278, 7, 19, 27, 8),
+(279, 7, 22, 1, 1),
+(280, 7, 22, 2, 2),
+(281, 7, 22, 4, 3),
+(282, 7, 22, 5, 4),
+(283, 7, 22, 6, 5),
+(284, 7, 22, 10, 6),
+(285, 7, 22, 9, 7),
+(286, 7, 22, 27, 8),
+(287, 7, 17, 1, 1),
+(288, 7, 17, 2, 2),
+(289, 7, 17, 4, 3),
+(290, 7, 17, 5, 4),
+(291, 7, 17, 6, 5),
+(292, 7, 17, 10, 6),
+(293, 7, 17, 9, 7),
+(294, 7, 17, 27, 8),
+(295, 7, 18, 1, 1),
+(296, 7, 18, 2, 2),
+(297, 7, 18, 4, 3),
+(298, 7, 18, 5, 4),
+(299, 7, 18, 6, 5),
+(300, 7, 18, 10, 6),
+(301, 7, 18, 9, 7),
+(302, 7, 18, 27, 8),
+(303, 7, 24, 1, 1),
+(304, 7, 24, 2, 2),
+(305, 7, 24, 4, 3),
+(306, 7, 24, 5, 4),
+(307, 7, 24, 6, 5),
+(308, 7, 24, 10, 6),
+(309, 7, 24, 9, 7),
+(310, 7, 24, 27, 8),
+(311, 7, 21, 1, 1),
+(312, 7, 21, 2, 2),
+(313, 7, 21, 4, 3),
+(314, 7, 21, 5, 4),
+(315, 7, 21, 6, 5),
+(316, 7, 21, 10, 6),
+(317, 7, 21, 9, 7),
+(318, 7, 21, 27, 8),
+(319, 7, 23, 1, 1),
+(320, 7, 23, 2, 2),
+(321, 7, 23, 4, 3),
+(322, 7, 23, 5, 4),
+(323, 7, 23, 6, 5),
+(324, 7, 23, 10, 6),
+(325, 7, 23, 9, 7),
+(326, 7, 23, 27, 8),
+(327, 7, 25, 1, 1),
+(328, 7, 25, 2, 2),
+(329, 7, 25, 4, 3),
+(330, 7, 25, 5, 4),
+(331, 7, 25, 6, 5),
+(332, 7, 25, 10, 6),
+(333, 7, 25, 9, 7),
+(334, 7, 25, 27, 8),
+(365, 7, 120, 1, 1),
+(336, 7, 120, 2, 2),
+(337, 7, 120, 4, 3),
+(338, 7, 120, 5, 4),
+(339, 7, 120, 6, 5),
+(340, 7, 120, 10, 6),
+(341, 7, 120, 9, 7),
+(342, 7, 120, 27, 8)");
+
+ // API array elements - Ads4World
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(366, 8, 26, 1, 1),
+(367, 8, 26, 2, 2),
+(368, 8, 26, 4, 3),
+(369, 8, 26, 5, 4),
+(370, 8, 26, 6, 5),
+(371, 8, 27, 1, 1),
+(372, 8, 27, 2, 2),
+(373, 8, 27, 4, 3),
+(374, 8, 27, 5, 4),
+(375, 8, 27, 6, 5),
+(376, 8, 28, 1, 1),
+(377, 8, 28, 2, 2),
+(378, 8, 28, 4, 3),
+(379, 8, 28, 5, 4),
+(380, 8, 28, 6, 5),
+(381, 8, 29, 1, 1),
+(382, 8, 29, 2, 2),
+(383, 8, 29, 4, 3),
+(384, 8, 29, 5, 4),
+(385, 8, 29, 6, 5),
+(386, 8, 30, 1, 1),
+(387, 8, 30, 2, 2),
+(388, 8, 30, 4, 3),
+(389, 8, 30, 5, 4),
+(390, 8, 30, 6, 5),
+(391, 8, 31, 1, 1),
+(392, 8, 31, 2, 2),
+(393, 8, 31, 4, 3),
+(394, 8, 31, 5, 4),
+(395, 8, 31, 6, 5),
+(396, 8, 32, 1, 1),
+(397, 8, 32, 2, 2),
+(398, 8, 32, 4, 3),
+(399, 8, 32, 5, 4),
+(400, 8, 32, 6, 5),
+(406, 8, 33, 1, 1),
+(407, 8, 33, 2, 2),
+(408, 8, 33, 4, 3),
+(409, 8, 33, 5, 4),
+(410, 8, 33, 6, 5),
+(411, 8, 33, 10, 6),
+(412, 8, 34, 1, 1),
+(413, 8, 34, 2, 2),
+(414, 8, 34, 4, 3),
+(415, 8, 34, 5, 4),
+(416, 8, 34, 6, 5),
+(417, 8, 34, 10, 6),
+(418, 8, 34, 9, 7),
+(401, 8, 121, 1, 1),
+(402, 8, 121, 2, 2),
+(403, 8, 121, 4, 3),
+(404, 8, 121, 5, 4),
+(405, 8, 121, 6, 5)");
+
+ // API array elements - Affiliblatt
+
+ // API array elements - AllAds4You
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(419, 10, 167, 1, 1),
+(420, 10, 167, 2, 2),
+(421, 10, 167, 4, 3),
+(422, 10, 167, 5, 4),
+(423, 10, 167, 6, 5),
+(424, 10, 168, 1, 1),
+(425, 10, 168, 2, 2),
+(426, 10, 168, 4, 3),
+(427, 10, 168, 5, 4),
+(428, 10, 168, 6, 5),
+(429, 10, 169, 1, 1),
+(430, 10, 169, 2, 2),
+(431, 10, 169, 4, 3),
+(432, 10, 169, 5, 4),
+(433, 10, 169, 6, 5),
+(434, 10, 170, 1, 1),
+(435, 10, 170, 2, 2),
+(436, 10, 170, 4, 3),
+(437, 10, 170, 5, 4),
+(438, 10, 170, 6, 5),
+(439, 10, 171, 1, 1),
+(440, 10, 171, 2, 2),
+(441, 10, 171, 4, 3),
+(442, 10, 171, 5, 4),
+(443, 10, 171, 6, 5),
+(444, 10, 172, 1, 1),
+(445, 10, 172, 2, 2),
+(446, 10, 172, 4, 3),
+(447, 10, 172, 5, 4),
+(448, 10, 172, 6, 5),
+(449, 10, 173, 1, 1),
+(450, 10, 173, 2, 2),
+(451, 10, 173, 4, 3),
+(452, 10, 173, 5, 4),
+(453, 10, 173, 6, 5),
+(454, 10, 174, 1, 1),
+(455, 10, 174, 2, 2),
+(456, 10, 174, 4, 3),
+(457, 10, 174, 5, 4),
+(458, 10, 174, 6, 5),
+(459, 10, 175, 1, 1),
+(460, 10, 175, 2, 2),
+(461, 10, 175, 4, 3),
+(462, 10, 175, 5, 4),
+(463, 10, 175, 6, 5),
+(464, 10, 175, 10, 6),
+(465, 10, 176, 1, 1),
+(466, 10, 176, 2, 2),
+(467, 10, 176, 4, 3),
+(468, 10, 176, 5, 4),
+(469, 10, 176, 6, 5),
+(470, 10, 176, 10, 6),
+(471, 10, 176, 9, 7)");
+
+ // API array elements - Alster-Marketing
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(472, 11, 35, 7, 1),
+(473, 11, 35, 2, 2),
+(474, 11, 35, 3, 3),
+(475, 11, 35, 4, 4),
+(476, 11, 35, 5, 5),
+(477, 11, 35, 6, 6),
+(478, 11, 35, 8, 7),
+(479, 11, 35, 10, 8),
+(488, 11, 36, 11, 1),
+(489, 11, 36, 2, 2),
+(490, 11, 36, 9, 3),
+(491, 11, 36, 4, 4),
+(492, 11, 36, 5, 5),
+(493, 11, 36, 6, 6),
+(500, 11, 37, 12, 1),
+(501, 11, 37, 2, 2),
+(502, 11, 37, 3, 3),
+(503, 11, 37, 4, 4),
+(504, 11, 37, 5, 5),
+(505, 11, 37, 6, 6),
+(506, 11, 37, 8, 7),
+(514, 11, 38, 7, 1),
+(515, 11, 38, 2, 2),
+(516, 11, 38, 3, 3),
+(517, 11, 38, 4, 4),
+(518, 11, 38, 5, 5),
+(519, 11, 38, 6, 6),
+(520, 11, 38, 10, 7),
+(521, 11, 38, 8, 8),
+(522, 11, 39, 13, 1),
+(523, 11, 39, 2, 2),
+(524, 11, 39, 4, 3),
+(525, 11, 39, 5, 4),
+(526, 11, 39, 6, 5),
+(527, 11, 39, 10, 6),
+(528, 11, 39, 9, 7),
+(536, 11, 40, 14, 1),
+(537, 11, 40, 2, 2),
+(538, 11, 40, 4, 3),
+(539, 11, 40, 5, 4),
+(540, 11, 40, 6, 5),
+(546, 11, 41, 15, 1),
+(547, 11, 41, 2, 2),
+(548, 11, 41, 4, 3),
+(549, 11, 41, 5, 4),
+(550, 11, 41, 6, 5),
+(551, 11, 41, 10, 6),
+(552, 11, 42, 16, 1),
+(553, 11, 42, 2, 2),
+(554, 11, 42, 4, 3),
+(555, 11, 42, 5, 4),
+(556, 11, 42, 6, 5),
+(557, 11, 42, 10, 6),
+(558, 11, 43, 17, 1),
+(559, 11, 43, 2, 2),
+(560, 11, 43, 6, 3),
+(561, 11, 43, 19, 4),
+(562, 11, 43, 20, 5),
+(563, 11, 43, 21, 6),
+(564, 11, 43, 22, 7),
+(565, 11, 43, 23, 8),
+(566, 11, 43, 9, 9),
+(567, 11, 43, 25, 10),
+(568, 11, 43, 5, 11),
+(569, 11, 44, 18, 1),
+(570, 11, 44, 2, 2),
+(571, 11, 44, 6, 3),
+(572, 11, 44, 19, 4),
+(573, 11, 44, 20, 5),
+(574, 11, 44, 21, 6),
+(575, 11, 44, 22, 7),
+(576, 11, 44, 23, 8),
+(577, 11, 44, 9, 9),
+(578, 11, 44, 25, 10),
+(480, 11, 45, 7, 1),
+(481, 11, 45, 2, 2),
+(482, 11, 45, 3, 3),
+(483, 11, 45, 4, 4),
+(484, 11, 45, 5, 5),
+(485, 11, 45, 6, 6),
+(486, 11, 45, 8, 7),
+(487, 11, 45, 10, 8),
+(494, 11, 46, 11, 1),
+(495, 11, 46, 2, 2),
+(496, 11, 46, 9, 3),
+(497, 11, 46, 4, 4),
+(498, 11, 46, 5, 5),
+(499, 11, 46, 6, 6),
+(507, 11, 47, 12, 1),
+(508, 11, 47, 2, 2),
+(509, 11, 47, 3, 3),
+(510, 11, 47, 4, 4),
+(511, 11, 47, 5, 5),
+(512, 11, 47, 6, 6),
+(513, 11, 47, 8, 7),
+(529, 11, 48, 13, 1),
+(530, 11, 48, 2, 2),
+(531, 11, 48, 4, 3),
+(532, 11, 48, 5, 4),
+(533, 11, 48, 6, 5),
+(534, 11, 48, 10, 6),
+(535, 11, 48, 9, 7),
+(541, 11, 49, 14, 1),
+(542, 11, 49, 2, 2),
+(543, 11, 49, 4, 3),
+(544, 11, 49, 5, 4),
+(545, 11, 49, 6, 5)");
+
+ // API array elements - BonusSponsor
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(579, 12, 50, 7, 1),
+(580, 12, 50, 2, 2),
+(581, 12, 50, 3, 3),
+(582, 12, 50, 4, 4),
+(583, 12, 50, 5, 5),
+(584, 12, 50, 6, 6),
+(585, 12, 50, 8, 7),
+(586, 12, 50, 10, 8),
+(587, 12, 52, 11, 1),
+(588, 12, 52, 2, 2),
+(589, 12, 52, 9, 3),
+(590, 12, 52, 4, 4),
+(591, 12, 52, 5, 5),
+(592, 12, 52, 6, 6),
+(593, 12, 54, 7, 1),
+(594, 12, 54, 2, 2),
+(595, 12, 54, 3, 3),
+(596, 12, 54, 4, 4),
+(597, 12, 54, 5, 5),
+(598, 12, 54, 6, 6),
+(599, 12, 54, 10, 7),
+(600, 12, 54, 8, 8),
+(601, 12, 55, 13, 1),
+(602, 12, 55, 2, 2),
+(603, 12, 55, 4, 3),
+(604, 12, 55, 5, 4),
+(605, 12, 55, 6, 5),
+(606, 12, 55, 10, 6),
+(607, 12, 55, 9, 7),
+(608, 12, 56, 13, 1),
+(609, 12, 56, 2, 2),
+(610, 12, 56, 4, 3),
+(611, 12, 56, 5, 4),
+(612, 12, 56, 6, 5),
+(613, 12, 56, 10, 6),
+(614, 12, 56, 9, 7),
+(615, 12, 62, 18, 1),
+(616, 12, 62, 2, 2),
+(617, 12, 62, 6, 3),
+(618, 12, 62, 19, 4),
+(619, 12, 62, 20, 5),
+(620, 12, 62, 21, 6),
+(621, 12, 62, 28, 7),
+(622, 12, 62, 29, 8),
+(623, 12, 62, 30, 9),
+(624, 12, 62, 31, 10),
+(625, 12, 62, 32, 11),
+(626, 12, 62, 33, 12),
+(627, 12, 62, 34, 13),
+(628, 12, 62, 22, 14),
+(629, 12, 62, 23, 15),
+(630, 12, 62, 24, 16),
+(631, 12, 62, 35, 17),
+(632, 12, 62, 36, 18),
+(633, 12, 62, 9, 19)");
+
+ // API array elements - Fusion-Ads
+
+ // API array elements - GigaPromo
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(634, 14, 102, 7, 1),
+(635, 14, 102, 2, 2),
+(636, 14, 102, 4, 3),
+(637, 14, 102, 5, 4),
+(638, 14, 102, 6, 5),
+(639, 14, 103, 14, 1),
+(640, 14, 103, 2, 2),
+(641, 14, 103, 4, 3),
+(642, 14, 103, 5, 4),
+(643, 14, 103, 6, 5),
+(644, 14, 104, 7, 1),
+(645, 14, 104, 2, 2),
+(646, 14, 104, 4, 3),
+(647, 14, 104, 5, 4),
+(648, 14, 104, 6, 5),
+(649, 14, 104, 10, 6),
+(650, 14, 105, 11, 1),
+(651, 14, 105, 2, 2),
+(652, 14, 105, 4, 3),
+(653, 14, 105, 5, 4),
+(654, 14, 105, 6, 5),
+(655, 14, 105, 10, 6),
+(656, 14, 105, 9, 7),
+(657, 14, 106, 13, 1),
+(658, 14, 106, 2, 2),
+(659, 14, 106, 5, 3),
+(660, 14, 106, 6, 4),
+(661, 14, 106, 10, 5),
+(662, 14, 106, 37, 6),
+(663, 14, 106, 9, 7),
+(669, 14, 107, 15, 1),
+(670, 14, 107, 2, 2),
+(671, 14, 107, 4, 3),
+(672, 14, 107, 5, 4),
+(673, 14, 107, 6, 5),
+(674, 14, 107, 10, 6),
+(675, 14, 108, 16, 1),
+(676, 14, 108, 2, 2),
+(677, 14, 108, 4, 3),
+(678, 14, 108, 5, 4),
+(679, 14, 108, 6, 5),
+(680, 14, 108, 10, 6),
+(664, 14, 122, 26, 1),
+(665, 14, 122, 2, 2),
+(666, 14, 122, 4, 3),
+(667, 14, 122, 5, 4),
+(668, 14, 122, 6, 5)");
+
+ // API array elements - HPSponsor
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(681, 15, 135, 1, 1),
+(682, 15, 135, 2, 2),
+(683, 15, 135, 4, 3),
+(684, 15, 135, 5, 4),
+(685, 15, 135, 6, 5),
+(686, 15, 135, 10, 6),
+(687, 15, 135, 9, 7),
+(688, 15, 135, 27, 8),
+(689, 15, 136, 1, 1),
+(690, 15, 136, 2, 2),
+(691, 15, 136, 4, 3),
+(692, 15, 136, 5, 4),
+(693, 15, 136, 6, 5),
+(694, 15, 136, 10, 6),
+(695, 15, 136, 9, 7),
+(696, 15, 136, 27, 8),
+(697, 15, 137, 1, 1),
+(698, 15, 137, 2, 2),
+(699, 15, 137, 4, 3),
+(700, 15, 137, 5, 4),
+(701, 15, 137, 6, 5),
+(702, 15, 137, 10, 6),
+(703, 15, 137, 9, 7),
+(704, 15, 137, 27, 8),
+(705, 15, 138, 1, 1),
+(706, 15, 138, 2, 2),
+(707, 15, 138, 4, 3),
+(708, 15, 138, 5, 4),
+(709, 15, 138, 6, 5),
+(710, 15, 138, 10, 6),
+(711, 15, 138, 9, 7),
+(712, 15, 138, 27, 8),
+(713, 15, 139, 1, 1),
+(714, 15, 139, 2, 2),
+(715, 15, 139, 4, 3),
+(716, 15, 139, 5, 4),
+(717, 15, 139, 6, 5),
+(718, 15, 139, 10, 6),
+(719, 15, 139, 9, 7),
+(720, 15, 139, 27, 8),
+(721, 15, 140, 1, 1),
+(722, 15, 140, 2, 2),
+(723, 15, 140, 4, 3),
+(724, 15, 140, 5, 4),
+(725, 15, 140, 6, 5),
+(726, 15, 140, 10, 6),
+(727, 15, 140, 9, 7),
+(728, 15, 140, 27, 8),
+(729, 15, 141, 1, 1),
+(730, 15, 141, 2, 2),
+(731, 15, 141, 4, 3),
+(732, 15, 141, 5, 4),
+(733, 15, 141, 6, 5),
+(734, 15, 141, 10, 6),
+(735, 15, 141, 9, 7),
+(736, 15, 141, 27, 8),
+(737, 15, 142, 1, 1),
+(738, 15, 142, 2, 2),
+(739, 15, 142, 4, 3),
+(740, 15, 142, 5, 4),
+(741, 15, 142, 6, 5),
+(742, 15, 142, 10, 6),
+(743, 15, 142, 9, 7),
+(744, 15, 142, 27, 8),
+(745, 15, 143, 1, 1),
+(746, 15, 143, 2, 2),
+(747, 15, 143, 4, 3),
+(748, 15, 143, 5, 4),
+(749, 15, 143, 6, 5),
+(750, 15, 143, 10, 6),
+(751, 15, 143, 9, 7),
+(752, 15, 143, 27, 8),
+(753, 15, 144, 1, 1),
+(754, 15, 144, 2, 2),
+(755, 15, 144, 4, 3),
+(756, 15, 144, 5, 4),
+(757, 15, 144, 6, 5),
+(758, 15, 144, 10, 6),
+(759, 15, 144, 9, 7),
+(760, 15, 144, 27, 8)");
+
+ // API array elements - Make-Euros.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(761, 16, 63, 7, 1),
+(762, 16, 63, 2, 2),
+(763, 16, 63, 3, 3),
+(764, 16, 63, 4, 4),
+(765, 16, 63, 5, 5),
+(766, 16, 63, 6, 6),
+(767, 16, 63, 8, 7),
+(768, 16, 63, 10, 8),
+(769, 16, 64, 7, 1),
+(770, 16, 64, 2, 2),
+(771, 16, 64, 3, 3),
+(772, 16, 64, 4, 4),
+(773, 16, 64, 5, 5),
+(774, 16, 64, 6, 6),
+(775, 16, 64, 8, 7),
+(776, 16, 64, 10, 8),
+(777, 16, 65, 11, 1),
+(778, 16, 65, 2, 2),
+(779, 16, 65, 9, 3),
+(780, 16, 65, 4, 4),
+(781, 16, 65, 5, 5),
+(782, 16, 65, 6, 6),
+(783, 16, 66, 11, 1),
+(784, 16, 66, 2, 2),
+(785, 16, 66, 9, 3),
+(786, 16, 66, 4, 4),
+(787, 16, 66, 5, 5),
+(788, 16, 66, 6, 6),
+(789, 16, 67, 12, 1),
+(790, 16, 67, 2, 2),
+(791, 16, 67, 3, 3),
+(792, 16, 67, 4, 4),
+(793, 16, 67, 5, 5),
+(794, 16, 67, 6, 6),
+(795, 16, 67, 8, 7),
+(803, 16, 68, 7, 1),
+(804, 16, 68, 2, 2),
+(805, 16, 68, 3, 3),
+(806, 16, 68, 4, 4),
+(807, 16, 68, 5, 5),
+(808, 16, 68, 6, 6),
+(809, 16, 68, 10, 7),
+(810, 16, 68, 8, 8),
+(796, 16, 69, 12, 1),
+(797, 16, 69, 2, 2),
+(798, 16, 69, 3, 3),
+(799, 16, 69, 4, 4),
+(800, 16, 69, 5, 5),
+(801, 16, 69, 6, 6),
+(802, 16, 69, 8, 7),
+(811, 16, 70, 13, 1),
+(812, 16, 70, 2, 2),
+(813, 16, 70, 4, 3),
+(814, 16, 70, 5, 4),
+(815, 16, 70, 6, 5),
+(816, 16, 70, 10, 6),
+(817, 16, 70, 9, 7),
+(818, 16, 71, 13, 1),
+(819, 16, 71, 2, 2),
+(820, 16, 71, 4, 3),
+(821, 16, 71, 5, 4),
+(822, 16, 71, 6, 5),
+(823, 16, 71, 10, 6),
+(824, 16, 71, 9, 7),
+(825, 16, 72, 14, 1),
+(826, 16, 72, 2, 2),
+(827, 16, 72, 4, 3),
+(828, 16, 72, 5, 4),
+(829, 16, 72, 6, 5),
+(830, 16, 73, 14, 1),
+(831, 16, 73, 2, 2),
+(832, 16, 73, 4, 3),
+(833, 16, 73, 5, 4),
+(834, 16, 73, 6, 5),
+(835, 16, 74, 15, 1),
+(836, 16, 74, 2, 2),
+(837, 16, 74, 4, 3),
+(838, 16, 74, 5, 4),
+(839, 16, 74, 6, 5),
+(840, 16, 74, 10, 6),
+(841, 16, 75, 16, 1),
+(842, 16, 75, 2, 2),
+(843, 16, 75, 4, 3),
+(844, 16, 75, 5, 4),
+(845, 16, 75, 6, 5),
+(846, 16, 75, 10, 6),
+(847, 16, 76, 17, 1),
+(848, 16, 76, 2, 2),
+(849, 16, 76, 6, 3),
+(850, 16, 76, 19, 4),
+(851, 16, 76, 20, 5),
+(852, 16, 76, 21, 6),
+(853, 16, 76, 22, 7),
+(854, 16, 76, 23, 8),
+(855, 16, 76, 9, 9)");
+
+ // API array elements - Mega-Ad
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(868, 17, 109, 1, 1),
+(869, 17, 109, 2, 2),
+(870, 17, 109, 4, 3),
+(871, 17, 109, 5, 4),
+(872, 17, 109, 6, 5),
+(873, 17, 110, 1, 1),
+(874, 17, 110, 2, 2),
+(875, 17, 110, 4, 3),
+(876, 17, 110, 5, 4),
+(877, 17, 110, 6, 5),
+(878, 17, 111, 1, 1),
+(879, 17, 111, 2, 2),
+(880, 17, 111, 4, 3),
+(881, 17, 111, 5, 4),
+(882, 17, 111, 6, 5),
+(883, 17, 112, 1, 1),
+(884, 17, 112, 2, 2),
+(885, 17, 112, 4, 3),
+(886, 17, 112, 5, 4),
+(887, 17, 112, 6, 5),
+(888, 17, 113, 1, 1),
+(889, 17, 113, 2, 2),
+(890, 17, 113, 4, 3),
+(891, 17, 113, 5, 4),
+(892, 17, 113, 6, 5),
+(893, 17, 114, 1, 1),
+(894, 17, 114, 2, 2),
+(895, 17, 114, 4, 3),
+(896, 17, 114, 5, 4),
+(897, 17, 114, 6, 5),
+(898, 17, 115, 1, 1),
+(899, 17, 115, 2, 2),
+(900, 17, 115, 4, 3),
+(901, 17, 115, 5, 4),
+(902, 17, 115, 6, 5),
+(915, 17, 116, 1, 1),
+(916, 17, 116, 2, 2),
+(917, 17, 116, 4, 3),
+(918, 17, 116, 5, 4),
+(919, 17, 116, 6, 5),
+(920, 17, 116, 10, 6),
+(908, 17, 117, 1, 1),
+(909, 17, 117, 2, 2),
+(910, 17, 117, 4, 3),
+(911, 17, 117, 5, 4),
+(912, 17, 117, 6, 5),
+(913, 17, 117, 10, 6),
+(914, 17, 117, 9, 7),
+(903, 17, 123, 1, 1),
+(904, 17, 123, 2, 2),
+(905, 17, 123, 4, 3),
+(906, 17, 123, 5, 4),
+(907, 17, 123, 6, 5)");
+
+ // API array elements - Power-Promo
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(921, 18, 78, 7, 1),
+(922, 18, 78, 2, 2),
+(923, 18, 78, 3, 3),
+(924, 18, 78, 4, 4),
+(925, 18, 78, 5, 5),
+(926, 18, 78, 6, 6),
+(927, 18, 78, 8, 7),
+(928, 18, 78, 10, 8),
+(929, 18, 79, 7, 1),
+(930, 18, 79, 2, 2),
+(931, 18, 79, 3, 3),
+(932, 18, 79, 4, 4),
+(933, 18, 79, 5, 5),
+(934, 18, 79, 6, 6),
+(935, 18, 79, 8, 7),
+(936, 18, 79, 10, 8),
+(937, 18, 80, 11, 1),
+(938, 18, 80, 2, 2),
+(939, 18, 80, 9, 3),
+(940, 18, 80, 4, 4),
+(941, 18, 80, 5, 5),
+(942, 18, 80, 6, 6),
+(943, 18, 81, 11, 1),
+(944, 18, 81, 2, 2),
+(945, 18, 81, 9, 3),
+(946, 18, 81, 4, 4),
+(947, 18, 81, 5, 5),
+(948, 18, 81, 6, 6),
+(949, 18, 82, 12, 1),
+(950, 18, 82, 2, 2),
+(951, 18, 82, 3, 3),
+(952, 18, 82, 4, 4),
+(953, 18, 82, 5, 5),
+(954, 18, 82, 6, 6),
+(955, 18, 82, 8, 7),
+(956, 18, 83, 12, 1),
+(957, 18, 83, 2, 2),
+(958, 18, 83, 3, 3),
+(959, 18, 83, 4, 4),
+(960, 18, 83, 5, 5),
+(961, 18, 83, 6, 6),
+(962, 18, 83, 8, 7),
+(963, 18, 84, 7, 1),
+(964, 18, 84, 2, 2),
+(965, 18, 84, 3, 3),
+(966, 18, 84, 4, 4),
+(967, 18, 84, 5, 5),
+(968, 18, 84, 6, 6),
+(969, 18, 84, 10, 7),
+(970, 18, 84, 8, 8),
+(971, 18, 85, 13, 1),
+(972, 18, 85, 2, 2),
+(973, 18, 85, 4, 3),
+(974, 18, 85, 5, 4),
+(975, 18, 85, 6, 5),
+(976, 18, 85, 10, 6),
+(977, 18, 85, 9, 7),
+(978, 18, 86, 13, 1),
+(979, 18, 86, 2, 2),
+(980, 18, 86, 4, 3),
+(981, 18, 86, 5, 4),
+(982, 18, 86, 6, 5),
+(983, 18, 86, 10, 6),
+(984, 18, 86, 9, 7),
+(985, 18, 87, 14, 1),
+(986, 18, 87, 2, 2),
+(987, 18, 87, 4, 3),
+(988, 18, 87, 5, 4),
+(989, 18, 87, 6, 5),
+(990, 18, 88, 14, 1),
+(991, 18, 88, 2, 2),
+(992, 18, 88, 4, 3),
+(993, 18, 88, 5, 4),
+(994, 18, 88, 6, 5),
+(995, 18, 89, 15, 1),
+(996, 18, 89, 2, 2),
+(997, 18, 89, 4, 3),
+(998, 18, 89, 5, 4),
+(999, 18, 89, 6, 5),
+(1000, 18, 89, 10, 6),
+(1001, 18, 90, 16, 1),
+(1002, 18, 90, 2, 2),
+(1003, 18, 90, 4, 3),
+(1004, 18, 90, 5, 4),
+(1005, 18, 90, 6, 5),
+(1006, 18, 90, 10, 6),
+(1007, 18, 91, 17, 1),
+(1008, 18, 91, 2, 2),
+(1009, 18, 91, 6, 3),
+(1010, 18, 91, 19, 4),
+(1011, 18, 91, 20, 5),
+(1012, 18, 91, 21, 6),
+(1013, 18, 91, 22, 7),
+(1014, 18, 91, 23, 8),
+(1015, 18, 91, 9, 9),
+(1016, 18, 91, 25, 10),
+(1017, 18, 91, 5, 11),
+(1018, 18, 92, 18, 1),
+(1019, 18, 92, 2, 2),
+(1020, 18, 92, 6, 3),
+(1021, 18, 92, 19, 4),
+(1022, 18, 92, 20, 5),
+(1023, 18, 92, 21, 6),
+(1024, 18, 92, 22, 7),
+(1025, 18, 92, 23, 8),
+(1026, 18, 92, 9, 9),
+(1027, 18, 92, 25, 10)");
+
+ // API array elements - SeCash
+
+ // API array elements - The Swizerland Ad Network
+
+ // API array elements - UltraPOMO
+
+ // API array elements - Der Werbepartner.cc
+
+ // API array elements - Yoo!Media
// Admin menu entries
addAdminMenuSql('network',NULL,'Werbenetzwerke','Verwalten Sie hier Werbenetzwerke (API-Anbindung), versenden Sie deren Mails, oder übernehmen Sie deren Textlinks und vieles mehr. <strong>VORSICHT:</strong> Das Einrichten von weiteren Werbenetzwerken ist nicht leicht, dafür aber sehr flexibel! Sollte ein Netzwerk fehlen, so melden Sie dies bitte <a href="http://forum.mxchange.org/topic-462.html" target="_blank" title="Direktlink zum Forum">im Forum</a>!',4);
addAdminMenuSql('network','list_networks','Auflisten/Verwalten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',6);
addAdminMenuSql('network','list_network_types','Werbearten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',7);
addAdminMenuSql('network','list_network_params','Abfrageparameter','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Abfrageparameter (wie sie genannt werden müssen, um das API-Script korrekt aufrufen zu können) ein, pro Werbenetzwerk. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',8);
- addAdminMenuSql('network','list_network_code_types','Rückgabewerte','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Rückgabewerte ein, die im Falle eines Fehlers pro API-Script kommen können. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',9);
- addAdminMenuSql('network','list_network_codes','Fehlercodes','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',10);
+ addAdminMenuSql('network','list_network_api_translation','Antwort-Array','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',10);
+ addAdminMenuSql('network','list_network_error_codes','Fehlercodes','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Fehlercodes ein, die im Falle eines Fehlers pro API-Script kommen können. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',11);
+ addAdminMenuSql('network','list_network_error_types','Fehlertypen','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',12);
// Configuration entries
addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `network_cache_refresh` BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (60 * 15) . '');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_data`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_type_codes`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_codes`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_return_types`');
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_codes`');
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_types`');
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_api_translation`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_cache`');
projects / mailer.git / blobdiff