`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='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_array_translation`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_array_translation` (
+`network_array_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_array_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_key` (`network_id`,`network_type_id`,`network_array_index`),
UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_index_translation`),
-PRIMARY KEY (`network_return_id`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Return types'");
+PRIMARY KEY (`network_array_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Translation of API responses'");
// Data from the webmaster (you!)
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
// - Webmaster's site id is not unlocked for choosen type
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('SITE_ID_NOT_ALLOWED_TYPE')");
// - Request parameters incomplete
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('REQUEST_PARAMS_INCOMPLETE')");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('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
('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
(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)");
+(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)");
// Fix empty defaults to NULL
addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_types` SET `network_type_banner_url`=NULL WHERE `network_type_banner_url`=''");
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_return_codes','Rückgabewerte','<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.',9);
- addAdminMenuSql('network','list_network_error_codes','Fehlercodes','<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.',10);
- 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.',11);
+ addAdminMenuSql('network','list_network_array_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.',9);
+ 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.',10);
+ addAdminMenuSql('network','list_network_translations','Array-Übersetzungen','<strong>Experten-Einstellungen!</strong> Hier richten Sie Array-Index-Übersetzungen für nicht-fehler API-Antworten ein. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> 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_error_codes`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_types`');
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_array_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