+setThisExtensionVersion('0.0');
+
+// Version history array (add more with , '0.1.0' and so on)
+setExtensionVersionHistory(array('0.0'));
+
+// This extension is in development (non-productive)
+enableExtensionProductive(false);
+
+switch (getExtensionMode()) {
+ case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
+ // Main table which hold
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_data`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_data` (
+`network_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`network_short_name` VARCHAR(50) NOT NULL DEFAULT '',
+`network_title` VARCHAR(255) NOT NULL DEFAULT '',
+`network_reflink` VARCHAR(255) NOT NULL DEFAULT '',
+`network_data_seperator` CHAR(4) NOT NULL DEFAULT '|',
+`network_row_seperator` CHAR(4) NOT NULL DEFAULT '|',
+`network_request_type` ENUM('GET','POST') NOT NULL DEFAULT 'GET',
+`network_charset` VARCHAR(20) NOT NULL DEFAULT 'UTF-8',
+UNIQUE (`network_short_name`),
+PRIMARY KEY (`network_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Network data'");
+
+ // Types the network provider is supporting (e.g. Forced-Banner and so on)
+ // @TODO network_type_handle is an internal name and needs documentation
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types` (
+`network_type_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_type_handle` VARCHAR(255) NOT NULL DEFAULT '',
+`network_type_api_url` VARCHAR(255) NOT NULL DEFAULT '',
+`network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '',
+`network_type_banner_url` VARCHAR(255) NULL DEFAULT NULL,
+UNIQUE `provider_type` (`network_id`,`network_type_handle`),
+PRIMARY KEY (`network_type_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Types provideable by networks'");
+
+ // HTTP parameters (names) for URLs
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_request_params` (
+`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(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`),
+PRIMARY KEY (`network_param_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request'");
+
+ // Error status 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 '',
+`network_type_code_type` VARCHAR(100) NOT NULL DEFAULT 'INVALID_TYPE',
+UNIQUE `code_type` (`network_type_code_value`,`network_type_id`),
+INDEX (`network_type_id`),
+PRIMARY KEY (`network_type_code_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Error codes for all types'");
+
+ // Code types (internal table)
+ 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`),
+PRIMARY KEY (`network_code_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Error types, generic data, DO NOT ALTER!'");
+
+ // 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_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_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_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`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_config` (
+`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_api_password` VARCHAR(255) NOT NULL DEFAULT '',
+`network_site_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
+UNIQUE `network_affiliate` (`network_id`,`network_affiliate_id`),
+UNIQUE `affiliate_site` (`network_affiliate_id`,`network_site_id`),
+PRIMARY KEY (`network_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Configuration data from the webmaster (you!)'");
+
+ // Configuration data for e.g. reload-time
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types_config` (
+`network_data_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,
+`max_reload_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`min_waiting_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`min_remain_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+`allow_erotic` VARCHAR(10) NOT NULL DEFAULT '',
+UNIQUE `provider_type` (`network_id`,`network_type_id`),
+PRIMARY KEY (`network_data_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Configuration data for every type (e.g. reload-time)'");
+
+ // Cache for queried APIs. Re-check depends on config
+ // `network_cache_refresh` in seconds or if set to zero, full day
+ // divided by query amount.
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_cache`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_cache` (
+`network_cache_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_cache_data` MEDIUMBLOB,
+`network_cache_timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00',
+UNIQUE `provider_type` (`network_id`,`network_type_id`),
+PRIMARY KEY (`network_cache_id`)
+) TYPE={?_TABLE_TYPE?} COMMENT='Cache for all queried APIs'");
+
+ // Reload locks for several types
+ addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_reloads`');
+ addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_reloads` (
+`network_reload_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_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
+`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')");
+
+ // Insert error code types
+ // - Affiliate id or interface password wrong
+ 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
+('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252'),
+('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252'),
+('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1'),
+('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252'),
+('adpaid', 'AdPaid', 'http://www.adpaid.de?ref=1464', '|', '|', 'GET', 'ISO-8859-1'),
+('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252'),
+('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252'),
+('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252'),
+('affiliblatt', 'Affiliblatt', 'http://www.Affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8'),
+('allads4you', 'AllAds4You', 'http://www.allads4you.de?ref=1146', '|', '|', 'GET', 'ISO-8859-1'),
+('alster', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16'),
+('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'),
+('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')");
+
+ // Network type handlers - A3H
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES
+(1, 1, 'banner', 'http://www.a3h.de/interface/out_banner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
+(2, 1, 'textlink', 'http://www.a3h.de/interface/out_textlink.php', 'http://www.a3h.de/textlinkklick.php?id=%CID%', NULL),
+(3, 1, 'surfbar', 'http://www.a3h.de/interface/out_sbanner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
+(4, 1, 'forcedbanner', 'http://www.a3h.de/interface/out_fbanner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
+(5, 1, 'textmail', 'http://www.a3h.de/interface/out_paidmail.php', 'http://www.a3h.de/emailf.php?id=%CID%', NULL),
+(6, 1, 'layer', 'http://www.a3h.de/interface/out_layer.php', 'http://www.a3h.de/layer.php?id=%CID%', NULL),
+(7, 1, 'popup', 'http://www.a3h.de/interface/out_popup.php', 'http://www.a3h.de/popup.php?id=%CID%', NULL),
+(8, 1, 'popdown', 'http://www.a3h.de/interface/out_popdown.php', 'http://www.a3h.de/popdown.php?id=%CID%', NULL),
+(9, 1, 'lead', 'http://www.a3h.de/interface/out_lead.php', 'http://www.a3h.de/lead.php?id=%CID%', NULL),
+(10, 1, 'sale', 'http://www.a3h.de/interface/out_sale.php', 'http://www.a3h.de/sale.php?id=%CID%', NULL),
+(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 - AdCocktail
+ 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
+(13, 4, 'forcedbanner', 'http://www.adcocktail.com/sc/kas/kas_fk.php', 'http://fk.adcocktail.com/fk_k.php?uid=%UID%&wid=%CID%&wsid=%SID%', 'http://fk.adcocktail.com/fk_v.php?uid=%UID%&wid=%CID%&wsid=%SID%'),
+(12, 4, 'textmail', 'http://www.adcocktail.com/sc/kas/kas_pm.php', 'http://pm.adcocktail.com/pm.php?uid=%UID%&wid=%CID%&wsid=%SID%', NULL)");
+
+ // Network type handlers - AdPaid
+ 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
+(177, 5, 'banner', 'http://www.adpaid.de/interface/out_banner.php', 'http://www.adpaid.de/bannerklf.php?id=%CID%', 'http://www.adpaid.de/banner.php?id=%CID%'),
+(178, 5, 'textlink', 'http://www.adpaid.de/interface/out_textlink.php', 'http://www.adpaid.de/textlinkklick.php?id=%CID%', NULL),
+(179, 5, 'surfbar', 'http://www.adpaid.de/interface/out_sbanner.php', 'http://www.adpaid.de/bannerklf.php?id=%CID%', 'http://www.adpaid.de/banner.php?id=%CID%'),
+(180, 5, 'forcedbanner', 'http://www.adpaid.de/interface/out_fbanner.php', 'http://www.adpaid.de/bannerklf.php?id=%CID%', 'http://www.adpaid.de/banner.php?id=%CID%'),
+(181, 5, 'textmail', 'http://www.adpaid.de/interface/out_paidmail.php', 'http://www.adpaid.de/emailf.php?id=%CID%', NULL),
+(182, 5, 'layer', 'http://www.adpaid.de/interface/out_layer.php', 'http://www.adpaid.de/layer.php?id=%CID%', NULL),
+(183, 5, 'popup', 'http://www.adpaid.de/interface/out_popup.php', 'http://www.adpaid.de/popup.php?id=%CID%', NULL),
+(184, 5, 'popdown', 'http://www.adpaid.de/interface/out_popdown.php', 'http://www.adpaid.de/popdown.php?id=%CID%', NULL),
+(185, 5, 'lead', 'http://www.adpaid.de/interface/out_lead.php', 'http://www.adpaid.de/lead.php?id=%CID%', NULL),
+(186, 5, 'sale', 'http://www.adpaid.de/interface/out_sale.php', 'http://www.adpaid.de/sale.php?id=%CID%', NULL)");
+
+ // Network type handlers - Ads4
+ 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
+(14, 6, 'forcedbanner', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/forced_click.php?fb_id=%CID%&sid=%SID%', 'http://www.ads4.de/forced_view.php?fb_id=%CID%&sid=%SID%'),
+(16, 6, 'htmlmail', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/paidmail_click.php?pm=%CID%&%sid=%SID%', NULL),
+(15, 6, 'textmail', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/paidmail_click.php?pm=%CID%&%sid=%SID%', NULL),
+(119, 6, 'traffic', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/traffic_click.php?tr_id=%CID%&sid=%SID%', '')");
+
+ // 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%&trackid=%tid%', '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%&trackid=%tid%', '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%&trackid=%tid%', '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%&trackid=%tid%', NULL),
+(24, 7, 'popup', 'http://www.ads4webbis.de/interface/', '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/', '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/', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/', '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
+(29, 8, 'banner_click', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(28, 8, 'banner_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(31, 8, 'button_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(26, 8, 'forcedbanner', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(27, 8, 'forcedtextlink', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(33, 8, 'popup', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(30, 8, 'skybanner_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(32, 8, 'textlink_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(34, 8, 'textmail', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(121, 8, 'traffic', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+
+ // Network type handlers - Affiliblatt
+
+ // Network type handlers - AllAds4You
+ 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
+(167, 10, 'forcedbanner', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.allads4you.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(168, 10, 'forcedtextlink', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(169, 10, 'banner_view', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.allads4you.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(170, 10, 'banner_click', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.allads4you.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(171, 10, 'skybanner_view', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.allads4you.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(172, 10, 'button_view', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.allads4you.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(173, 10, 'textlink_view', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(174, 10, 'traffic', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(175, 10, 'popup', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(176, 10, 'textmail', 'http://www.allads4you.de/interface/', 'http://www.allads4you.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+
+ // Network type handlers - Alster-Marketing
+ 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
+(35, 11, 'banner_click', 'http://if.alstermarketing.de/interface/out_banner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
+(45, 11, 'banner_view', 'http://if.alstermarketing.de/interface/out_banner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
+(38, 11, 'forcedbanner', 'http://if.alstermarketing.de/interface/out_fbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
+(48, 11, 'htmlmail', 'http://if.alstermarketing.de/interface/out_paidmail.php', 'http://www.alstermarketing.de/emailf.php?id=%CID%', NULL),
+(40, 11, 'layer_click', 'http://if.alstermarketing.de/interface/out_layer.php', 'http://www.alstermarketing.de/layer.php?id=%CID%', NULL),
+(49, 11, 'layer_view', 'http://if.alstermarketing.de/interface/out_layer.php', 'http://www.alstermarketing.de/layer.php?id=%CID%', NULL),
+(43, 11, 'lead', 'http://if.alstermarketing.de/interface/out_lead.php', 'http://www.alstermarketing.de/lead.php?id=%CID%', NULL),
+(42, 11, 'popdown', 'http://if.alstermarketing.de/interface/out_popdown.php', 'http://www.alstermarketing.de/popdown.php?id=%CID%', NULL),
+(41, 11, 'popup', 'http://if.alstermarketing.de/interface/out_popup.php', 'http://www.alstermarketing.de/popup.php?id=%CID%', NULL),
+(44, 11, 'sale', 'http://if.alstermarketing.de/interface/out_sale.php', 'http://www.alstermarketing.de/sale.php?id=%CID%', NULL),
+(37, 11, 'surfbar_click', 'http://if.alstermarketing.de/interface/out_sbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
+(47, 11, 'surfbar_view', 'http://if.alstermarketing.de/interface/out_sbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
+(36, 11, 'textlink_click', 'http://if.alstermarketing.de/interface/out_textlink.php', 'http://www.alstermarketing.de/textlinkklick.php?id=%CID%', NULL),
+(46, 11, 'textlink_view', 'http://if.alstermarketing.de/interface/out_textlink.php', 'http://www.alstermarketing.de/textlinkklick.php?id=%CID%', NULL),
+(39, 11, 'textmail', 'http://if.alstermarketing.de/interface/out_paidmail.php', 'http://www.alstermarketing.de/emailf.php?id=%CID%', NULL)");
+
+ // Network type handlers - BonusSponsor
+ 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
+(50, 12, 'banner_click', 'http://www.bonussponsor.de/interface/out_banner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
+(51, 12, 'banner_view', 'http://www.bonussponsor.de/interface/out_banner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
+(54, 12, 'forcedbanner', 'http://www.bonussponsor.de/interface/out_fbanner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
+(56, 12, 'htmlmail', 'http://www.bonussponsor.de/interface/out_paidmail.php', 'http://www.bonussponsor.de/emailf.php?id=%CID%', NULL),
+(57, 12, 'layer_click', 'http://www.bonussponsor.de/interface/out_layer.php', 'http://www.bonussponsor.de/layer.php?id=%CID%', NULL),
+(58, 12, 'layer_view', 'http://www.bonussponsor.de/interface/out_layer.php', 'http://www.bonussponsor.de/layer.php?id=%CID%', NULL),
+(61, 12, 'lead', 'http://www.bonussponsor.de/interface/out_lead.php', 'http://www.bonussponsor.de/lead.php?id=%CID%', NULL),
+(60, 12, 'popdown', 'http://www.bonussponsor.de/interface/out_popdown.php', 'http://www.bonussponsor.de/popdown.php?id=%CID%', NULL),
+(59, 12, 'popup', 'http://www.bonussponsor.de/interface/out_popup.php', 'http://www.bonussponsor.de/popup.php?id=%CID%', NULL),
+(62, 12, 'sale', 'http://www.bonussponsor.de/interface/out_sale.php', 'http://www.bonussponsor.de/sale.php?id=%CID%', NULL),
+(52, 12, 'textlink_click', 'http://www.bonussponsor.de/interface/out_textlink.php', 'http://www.bonussponsor.de/textlinkklick.php?id=%CID%', NULL),
+(53, 12, 'textlink_view', 'http://www.bonussponsor.de/interface/out_textlink.php', 'http://www.bonussponsor.de/textlinkklick.php?id=%CID%', NULL),
+(55, 12, 'textmail', 'http://www.bonussponsor.de/interface/out_paidmail.php', 'http://www.bonussponsor.de/emailf.php?id=%CID%', NULL)");
+
+ // Network type handlers - Fusion-Ads
+
+ // Network type handlers - GigaPromo
+ 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
+(102, 14, 'banner_view', 'http://www.gigapromo.de/interface/output_viewbanner.php', 'http://www.gigapromo.de/view/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.gigapromo.de/view/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(104, 14, 'forcedbanner', 'http://www.gigapromo.de/interface/output_forcedbanner.php', 'http://www.gigapromo.de/view/forcedclickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.gigapromo.de/view/forcedviewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(105, 14, 'forcedtextlink', 'http://www.gigapromo.de/interface/output_forcedtextlink.php', 'http://www.gigapromo.de/view/forcedclicktextlink.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(103, 14, 'layer_view', 'http://www.gigapromo.de/interface/output_layerviews.php', 'http://www.gigapromo.de/view/layer.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(108, 14, 'popdown', 'http://www.gigapromo.de/interface/output_popdown.php', 'http://www.gigapromo.de/view/popdown.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(107, 14, 'popup', 'http://www.gigapromo.de/interface/output_popup.php', 'http://www.gigapromo.de/view/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(106, 14, 'textmail', 'http://www.gigapromo.de/interface/output_paidmails.php', 'http://www.gigapromo.de/view/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(122, 14, 'traffic', 'http://www.gigapromo.de/interface/output_traffic.php', 'http://www.gigapromo.de/view/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+
+ // 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)");
+
+ // 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
+(63, 16, 'banner_click', 'http://www.make-euros.de/interface/out_banner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
+(64, 16, 'banner_view', 'http://www.make-euros.de/interface/out_banner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
+(68, 16, 'forcedbanner', 'http://www.make-euros.de/interface/out_fbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
+(71, 16, 'htmlmail', 'http://www.make-euros.de/interface/out_paidmail.php', 'http://www.make-euros.de/emailf.php?id=%CID%', NULL),
+(72, 16, 'layer_click', 'http://www.make-euros.de/interface/out_layer.php', 'http://www.make-euros.de/layer.php?id=%CID%', NULL),
+(73, 16, 'layer_view', 'http://www.make-euros.de/interface/out_layer.php', 'http://www.make-euros.de/layer.php?id=%CID%', NULL),
+(76, 16, 'lead', 'http://www.make-euros.de/interface/out_lead.php', 'http://www.make-euros.de/lead.php?id=%CID%', NULL),
+(75, 16, 'popdown', 'http://www.make-euros.de/interface/out_popdown.php', 'http://www.make-euros.de/popdown.php?id=%CID%', NULL),
+(74, 16, 'popup', 'http://www.make-euros.de/interface/out_popup.php', 'http://www.make-euros.de/popup.php?id=%CID%', NULL),
+(77, 16, 'sale', 'http://www.make-euros.de/interface/out_sale.php', 'http://www.make-euros.de/sale.php?id=%CID%', NULL),
+(67, 16, 'surfbar_click', 'http://www.make-euros.de/interface/out_sbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
+(69, 16, 'surfbar_view', 'http://www.make-euros.de/interface/out_sbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
+(65, 16, 'textlink_click', 'http://www.make-euros.de/interface/out_textlink.php', 'http://www.make-euros.de/textlinkklick.php?id=%CID%', NULL),
+(66, 16, 'textlink_view', 'http://www.make-euros.de/interface/out_textlink.php', 'http://www.make-euros.de/textlinkklick.php?id=%CID%', NULL),
+(70, 16, 'textmail', 'http://www.make-euros.de/interface/out_paidmail.php', 'http://www.make-euros.de/emailf.php?id=%CID%', NULL)");
+
+ // Network type handlers - Mega-Ad
+ 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
+(112, 17, 'banner_click', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/view.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(111, 17, 'banner_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(114, 17, 'button_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(109, 17, 'forcedbanner', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(110, 17, 'forcedtextlink', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(116, 17, 'popup', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(113, 17, 'skybanner_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(115, 17, 'textlink_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(117, 17, 'textmail', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(123, 17, 'traffic', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+
+ // Network type handlers - Power-Promo
+ 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
+(78, 18, 'banner_click', 'http://www.power-promo.de/interface/out_banner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
+(79, 18, 'banner_view', 'http://www.power-promo.de/interface/out_banner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
+(84, 18, 'forcedbanner', 'http://www.power-promo.de/interface/out_fbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
+(86, 18, 'htmlmail', 'http://www.power-promo.de/interface/out_paidmail.php', 'http://www.power-promo.de/emailf.php?id=%CID%', NULL),
+(87, 18, 'layer_click', 'http://www.power-promo.de/interface/out_layer.php', 'http://www.power-promo.de/layer.php?id=%CID%', NULL),
+(88, 18, 'layer_view', 'http://www.power-promo.de/interface/out_layer.php', 'http://www.power-promo.de/layer.php?id=%CID%', NULL),
+(91, 18, 'lead', 'http://www.power-promo.de/interface/out_lead.php', 'http://www.power-promo.de/lead.php?id=%CID%', NULL),
+(90, 18, 'popdown', 'http://www.power-promo.de/interface/out_popdown.php', 'http://www.power-promo.de/popdown.php?id=%CID%', NULL),
+(89, 18, 'popup', 'http://www.power-promo.de/interface/out_popup.php', 'http://www.power-promo.de/popup.php?id=%CID%', NULL),
+(92, 18, 'sale', 'http://www.power-promo.de/interface/out_sale.php', 'http://www.power-promo.de/sale.php?id=%CID%', NULL),
+(82, 18, 'surfbar_click', 'http://www.power-promo.de/interface/out_sbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
+(83, 18, 'surfbar_view', 'http://www.power-promo.de/interface/out_sbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
+(80, 18, 'textlink_click', 'http://www.power-promo.de/interface/out_textlink.php', 'http://www.power-promo.de/textlinkklick.php?id=%CID%', NULL),
+(81, 18, 'textlink_view', 'http://www.power-promo.de/interface/out_textlink.php', 'http://www.power-promo.de/textlinkklick.php?id=%CID%', NULL),
+(85, 18, 'textmail', 'http://www.power-promo.de/interface/out_paidmail.php', 'http://www.power-promo.de/emailf.php?id=%CID%', NULL)");
+
+ // Network type handlers - SeCash
+ 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
+(93, 19, 'forcedbanner', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(94, 19, 'forcedtextlink', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(95, 19, 'banner_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(96, 19, 'banner_click', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(97, 19, 'skybanner_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(98, 19, 'button_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(99, 19, 'textlink_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(100, 19, 'popup', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(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, 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, 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, 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
+(1, 1, 1, 'id', 'id', NULL),
+(2, 1, 1, 'sid', 'sid', NULL),
+(3, 1, 1, 'password', 'pw', NULL),
+(4, 1, 1, 'reload', 'reload', NULL),
+(5, 1, 1, 'reward', 'verguetung', 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),
+(10, 1, 2, 'id', 'id', NULL),
+(11, 1, 2, 'sid', 'sid', NULL),
+(12, 1, 2, 'password', 'pw', NULL),
+(13, 1, 2, 'reload', 'reload', NULL),
+(14, 1, 2, 'reward', 'verguetung', NULL),
+(15, 1, 2, 'remain', 'uebrig', NULL),
+(16, 1, 3, 'id', 'id', NULL),
+(17, 1, 3, 'sid', 'sid', NULL),
+(18, 1, 3, 'password', 'pw', NULL),
+(19, 1, 3, 'reload', 'reload', NULL),
+(20, 1, 3, 'reward', 'verguetung', NULL),
+(21, 1, 3, 'type', 'typ', NULL),
+(22, 1, 3, 'remain', 'uebrig', NULL),
+(23, 1, 3, 'size', 'size', NULL),
+(24, 1, 4, 'id', 'id', NULL),
+(25, 1, 4, 'sid', 'sid', NULL),
+(26, 1, 4, 'password', 'pw', NULL),
+(27, 1, 4, 'reload', 'reload', NULL),
+(28, 1, 4, 'reward', 'verguetung', 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),
+(33, 1, 5, 'sid', 'sid', NULL),
+(34, 1, 5, 'password', 'pw', NULL),
+(35, 1, 5, 'reload', 'reload', NULL),
+(36, 1, 5, 'reward', 'verguetung', 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),
+(41, 1, 11, 'sid', 'sid', NULL),
+(42, 1, 11, 'password', 'pw', NULL),
+(43, 1, 11, 'reload', 'reload', NULL),
+(44, 1, 11, 'reward', 'verguetung', 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),
+(49, 1, 6, 'sid', 'sid', NULL),
+(50, 1, 6, 'password', 'pw', NULL),
+(51, 1, 6, 'reload', 'reload', NULL),
+(52, 1, 6, 'reward', 'verguetung', NULL),
+(53, 1, 6, 'type', 'typ', NULL),
+(54, 1, 6, 'remain', 'uebrig', NULL),
+(55, 1, 7, 'id', 'id', NULL),
+(56, 1, 7, 'sid', 'sid', NULL),
+(57, 1, 7, 'password', 'pw', NULL),
+(58, 1, 7, 'reload', 'reload', NULL),
+(59, 1, 7, 'reward', 'verguetung', 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, 'minimum_stay', 'ma', NULL),
+(68, 1, 8, 'remain', 'uebrig', NULL),
+(69, 1, 9, 'id', 'id', NULL),
+(70, 1, 9, 'sid', 'sid', NULL),
+(71, 1, 9, 'password', 'pw', NULL),
+(72, 1, 9, 'reward', 'verguetung', NULL),
+(73, 1, 9, 'remain', 'uebrig', NULL),
+(74, 1, 10, 'id', 'id', NULL),
+(75, 1, 10, 'sid', 'sid', NULL),
+(76, 1, 10, 'password', 'pw', NULL),
+(77, 1, 10, 'reward', 'verguetung', 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
+
+ // Request parameters per type handler - AdCocktail
+
+ // Request parameters per type handler - AdPaid
+ 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
+(1259, 5, 177, 'id', 'id', NULL),
+(1260, 5, 177, 'sid', 'sid', NULL),
+(1261, 5, 177, 'password', 'pw', NULL),
+(1262, 5, 177, 'reward', 'verguetung', NULL),
+(1263, 5, 177, 'reload', 'reload', NULL),
+(1264, 5, 177, 'remain', 'uebrig', NULL),
+(1265, 5, 177, 'type', 'typ', NULL),
+(1266, 5, 177, 'size', 'size', '468x60'),
+(1267, 5, 178, 'id', 'id', NULL),
+(1268, 5, 178, 'sid', 'sid', NULL),
+(1269, 5, 178, 'password', 'pw', NULL),
+(1270, 5, 178, 'reward', 'verguetung', NULL),
+(1271, 5, 178, 'reload', 'reload', NULL),
+(1272, 5, 178, 'remain', 'uebrig', NULL),
+(1273, 5, 178, 'type', 'typ', NULL),
+(1274, 5, 179, 'id', 'id', NULL),
+(1275, 5, 179, 'sid', 'sid', NULL),
+(1276, 5, 179, 'password', 'pw', NULL),
+(1277, 5, 179, 'reward', 'verguetung', NULL),
+(1278, 5, 179, 'reload', 'reload', NULL),
+(1279, 5, 179, 'remain', 'uebrig', NULL),
+(1280, 5, 179, 'type', 'typ', NULL),
+(1281, 5, 179, 'size', 'size', NULL),
+(1282, 5, 180, 'id', 'id', NULL),
+(1283, 5, 180, 'sid', 'sid', NULL),
+(1284, 5, 180, 'password', 'pw', NULL),
+(1285, 5, 180, 'reward', 'verguetung', NULL),
+(1286, 5, 180, 'reload', 'reload', NULL),
+(1287, 5, 180, 'remain', 'uebrig', NULL),
+(1288, 5, 180, 'size', 'size', '468x60'),
+(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, 'minimum_stay', 'ma', NULL),
+(1297, 5, 181, 'type', 'typ', 'text'),
+(1306, 5, 182, 'id', 'id', NULL),
+(1307, 5, 182, 'sid', 'sid', NULL),
+(1308, 5, 182, 'password', 'pw', NULL),
+(1309, 5, 182, 'reload', 'reload', NULL),
+(1310, 5, 182, 'reward', 'verguetung', NULL),
+(1311, 5, 182, 'remain', 'uebrig', NULL),
+(1312, 5, 182, 'type', 'typ', NULL),
+(1313, 5, 183, 'id', 'id', NULL),
+(1314, 5, 183, 'sid', 'sid', NULL),
+(1315, 5, 183, 'password', 'pw', NULL),
+(1316, 5, 183, 'reload', 'reload', NULL),
+(1317, 5, 183, 'reward', 'verguetung', NULL),
+(1318, 5, 183, 'remain', 'uebrig', 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, 'minimum_stay', 'ma', NULL),
+(1327, 5, 185, 'id', 'id', NULL),
+(1328, 5, 185, 'sid', 'sid', NULL),
+(1329, 5, 185, 'password', 'pw', NULL),
+(1330, 5, 185, 'reward', 'verguetung', NULL),
+(1331, 5, 185, 'remain', 'uebrig', NULL),
+(1332, 5, 186, 'id', 'id', NULL),
+(1333, 5, 186, 'sid', 'sid', NULL),
+(1334, 5, 186, 'password', 'pw', NULL),
+(1335, 5, 186, 'reward', 'verguetung', NULL),
+(1336, 5, 186, 'remain', 'uebrig', NULL),
+(1298, 5, 187, 'id', 'id', NULL),
+(1299, 5, 187, 'sid', 'sid', NULL),
+(1300, 5, 187, 'password', 'pw', NULL),
+(1301, 5, 187, 'reload', 'reload', NULL),
+(1302, 5, 187, 'reward', 'verguetung', NULL),
+(1303, 5, 187, 'remain', 'uebrig', NULL),
+(1304, 5, 187, 'minimum_stay', 'ma', NULL),
+(1305, 5, 187, 'type', 'typ', 'html')");
+
+ // Request parameters per type handler - Ads4
+ 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
+(79, 6, 14, 'id', 'id', NULL),
+(80, 6, 14, 'password', 'pwd', NULL),
+(81, 6, 14, 'currency', 'waehrung', NULL),
+(82, 6, 14, 'extra', 'mediatype', 'forced_banner'),
+(83, 6, 14, 'reward', 'verg', NULL),
+(84, 6, 14, 'reload', 'reload', NULL),
+(85, 6, 14, 'remain', 'uebrig', 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),
+(90, 6, 15, 'extra', 'mediatype', 'textmails'),
+(91, 6, 15, 'reward', 'verg', NULL),
+(92, 6, 15, 'reload', 'reload', NULL),
+(93, 6, 15, 'remain', 'uebrig', 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),
+(98, 6, 16, 'extra', 'mediatype', 'htmlmails'),
+(99, 6, 16, 'reward', 'verg', NULL),
+(100, 6, 16, 'reload', 'reload', NULL),
+(101, 6, 16, 'remain', 'uebrig', 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),
+(792, 6, 119, 'extra', 'mediatype', 'traffic'),
+(793, 6, 119, 'reward', 'verg', NULL),
+(794, 6, 119, 'reload', 'reload', NULL),
+(795, 6, 119, 'remain', 'uebrig', 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
+(103, 7, 20, 'extra', 'typ', 'bannerklick'),
+(104, 7, 20, 'id', 'id', NULL),
+(105, 7, 20, 'password', 'pw', NULL),
+(106, 7, 20, 'remain', 'uebrig', NULL),
+(107, 7, 20, 'reload', 'reload', NULL),
+(108, 7, 20, 'reward', 'verguetung', NULL),
+(109, 7, 17, 'extra', 'typ', 'forcedbanner'),
+(110, 7, 17, 'id', 'id', NULL),
+(111, 7, 17, 'password', 'pw', NULL),
+(112, 7, 17, 'remain', 'uebrig', NULL),
+(113, 7, 17, 'reload', 'reload', NULL),
+(114, 7, 17, 'reward', 'verguetung', NULL),
+(115, 7, 18, 'extra', 'typ', 'forcedtextlink'),
+(116, 7, 18, 'id', 'id', NULL),
+(117, 7, 18, 'password', 'pw', NULL),
+(118, 7, 18, 'remain', 'uebrig', NULL),
+(119, 7, 18, 'reload', 'reload', NULL),
+(120, 7, 18, 'reward', 'verguetung', NULL),
+(121, 7, 19, 'extra', 'typ', 'bannerview'),
+(122, 7, 19, 'id', 'id', NULL),
+(123, 7, 19, 'password', 'pw', NULL),
+(124, 7, 19, 'remain', 'uebrig', NULL),
+(125, 7, 19, 'reload', 'reload', NULL),
+(126, 7, 19, 'reward', 'verguetung', NULL),
+(127, 7, 21, 'extra', 'typ', 'skybannerview'),
+(128, 7, 21, 'id', 'id', NULL),
+(129, 7, 21, 'password', 'pw', NULL),
+(130, 7, 21, 'remain', 'uebrig', NULL),
+(131, 7, 21, 'reload', 'reload', NULL),
+(132, 7, 21, 'reward', 'verguetung', NULL),
+(133, 7, 22, 'extra', 'typ', 'buttonview'),
+(134, 7, 22, 'id', 'id', NULL),
+(135, 7, 22, 'password', 'pw', NULL),
+(136, 7, 22, 'remain', 'uebrig', NULL),
+(137, 7, 22, 'reload', 'reload', NULL),
+(138, 7, 22, 'reward', 'verguetung', NULL),
+(139, 7, 23, 'extra', 'typ', 'textview'),
+(140, 7, 23, 'id', 'id', NULL),
+(141, 7, 23, 'password', 'pw', NULL),
+(142, 7, 23, 'remain', 'uebrig', NULL),
+(143, 7, 23, 'reload', 'reload', NULL),
+(144, 7, 23, 'reward', 'verguetung', NULL),
+(145, 7, 24, 'extra', 'typ', 'popup'),
+(146, 7, 24, 'id', 'id', NULL),
+(147, 7, 24, 'password', 'pw', NULL),
+(148, 7, 24, 'remain', 'uebrig', NULL),
+(149, 7, 24, 'reload', 'reload', NULL),
+(150, 7, 24, 'reward', 'verguetung', 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, 'minimum_stay', 'ma', NULL),
+(797, 7, 120, 'extra', 'typ', 'traffic'),
+(798, 7, 120, 'id', 'id', NULL),
+(799, 7, 120, 'password', 'pw', NULL),
+(800, 7, 120, 'remain', 'uebrig', NULL),
+(801, 7, 120, 'reload', 'reload', NULL),
+(802, 7, 120, 'reward', 'verguetung', NULL)");
+
+ // Request parameters per type handler - Ads4World
+ 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
+(159, 8, 29, 'extra', 'typ', 'bannerklick'),
+(160, 8, 29, 'id', 'id', NULL),
+(161, 8, 29, 'password', 'pw', NULL),
+(162, 8, 29, 'remain', 'uebrig', NULL),
+(163, 8, 29, 'reload', 'reload', NULL),
+(164, 8, 29, 'reward', 'verguetung', NULL),
+(165, 8, 28, 'extra', 'typ', 'bannerview'),
+(166, 8, 28, 'id', 'id', NULL),
+(167, 8, 28, 'password', 'pw', NULL),
+(168, 8, 28, 'remain', 'uebrig', NULL),
+(169, 8, 28, 'reload', 'reload', NULL),
+(170, 8, 28, 'reward', 'verguetung', NULL),
+(171, 8, 31, 'extra', 'typ', 'buttonview'),
+(172, 8, 31, 'id', 'id', NULL),
+(173, 8, 31, 'password', 'pw', NULL),
+(174, 8, 31, 'remain', 'uebrig', NULL),
+(175, 8, 31, 'reload', 'reload', NULL),
+(176, 8, 31, 'reward', 'verguetung', NULL),
+(177, 8, 26, 'extra', 'typ', 'forcedbanner'),
+(178, 8, 26, 'id', 'id', NULL),
+(179, 8, 26, 'password', 'pw', NULL),
+(180, 8, 26, 'remain', 'uebrig', NULL),
+(181, 8, 26, 'reload', 'reload', NULL),
+(182, 8, 26, 'reward', 'verguetung', NULL),
+(183, 8, 27, 'extra', 'typ', 'forcedtextlink'),
+(184, 8, 27, 'id', 'id', NULL),
+(185, 8, 27, 'password', 'pw', NULL),
+(186, 8, 27, 'remain', 'uebrig', NULL),
+(187, 8, 27, 'reload', 'reload', NULL),
+(188, 8, 27, 'reward', 'verguetung', NULL),
+(189, 8, 33, 'extra', 'typ', 'popup'),
+(190, 8, 33, 'id', 'id', NULL),
+(191, 8, 33, 'password', 'pw', NULL),
+(192, 8, 33, 'remain', 'uebrig', NULL),
+(193, 8, 33, 'reload', 'reload', NULL),
+(194, 8, 33, 'reward', 'verguetung', 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),
+(199, 8, 30, 'remain', 'uebrig', NULL),
+(200, 8, 30, 'reload', 'reload', NULL),
+(201, 8, 30, 'reward', 'verguetung', NULL),
+(202, 8, 32, 'extra', 'typ', 'textview'),
+(203, 8, 32, 'id', 'id', NULL),
+(204, 8, 32, 'password', 'pw', NULL),
+(205, 8, 32, 'remain', 'uebrig', NULL),
+(206, 8, 32, 'reload', 'reload', NULL),
+(207, 8, 32, 'reward', 'verguetung', NULL),
+(208, 8, 34, 'extra', 'typ', 'textmails'),
+(209, 8, 34, 'id', 'id', NULL),
+(210, 8, 34, 'password', 'pw', NULL),
+(211, 8, 34, 'remain', 'uebrig', NULL),
+(212, 8, 34, 'reload', 'reload', NULL),
+(213, 8, 34, 'reward', 'verguetung', 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),
+(806, 8, 121, 'remain', 'uebrig', NULL),
+(807, 8, 121, 'reload', 'reload', NULL),
+(808, 8, 121, 'reward', 'verguetung', NULL)");