Extension ext-network continued:

[mailer.git] / inc / extensions / ext-network.php

diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php
index b3dd951dc0ba3f8b3daabe6814d995a0f4e693f3..be072e7d4db074e9f329dad446b2e9b520279a8b 100644 (file)
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -110,12 +110,12 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_handle`)",
 `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,
+`network_request_param_key` VARCHAR(20) NOT NULL DEFAULT 'invalid',
+`network_request_param_value` VARCHAR(20) NOT NULL DEFAULT 'invalid',
+`network_request_param_default` VARCHAR(255) NULL DEFAULT NULL,
 PRIMARY KEY (`network_param_id`),
-UNIQUE INDEX `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
-UNIQUE INDEX `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`)",
+UNIQUE INDEX `provider_type_key` (`network_id`,`network_type_id`,`network_request_param_key`),
+UNIQUE INDEX `provider_type_value` (`network_id`,`network_type_id`,`network_request_param_value`)",
                        'Request parameters for GET/POST request');
 
                // Error status codes
@@ -165,13 +165,15 @@ INDEX (`sort`)",
                addDropTableSql('network_api_config');
                addCreateTableSql('network_api_config', "
 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_api_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_api_site_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `network_api_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
+`network_api_referral_link` VARCHAR(255) NULL DEFAULT NULL,
+`network_api_referral_button` VARCHAR(255) NULL DEFAULT NULL,
 PRIMARY KEY (`network_id`),
-UNIQUE INDEX `network_affiliate` (`network_id`,`network_affiliate_id`),
-UNIQUE INDEX `affiliate_site` (`network_affiliate_id`,`network_site_id`)",
+UNIQUE INDEX `network_affiliate` (`network_id`,`network_api_affiliate_id`),
+UNIQUE INDEX `affiliate_site` (`network_api_affiliate_id`,`network_api_site_id`)",
                        'API configuration data');
 
                // Configuration data for e.g. reload-time
@@ -180,11 +182,11 @@ UNIQUE INDEX `affiliate_site` (`network_affiliate_id`,`network_site_id`)",
 `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 '',
+`network_max_reload_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_min_waiting_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_min_remain_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+`network_allow_erotic` VARCHAR(10) NOT NULL DEFAULT '',
 PRIMARY KEY (`network_data_id`),
 UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
                        'Configuration data for every type (e.g. reload-time)');
@@ -720,7 +722,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (166, 23, 'lead', 'http://www.yoomedia.de/interface_2.0/out_lead.php', 'http://www.yoomedia.de/code/lead.php?id=%CID%&sid=%SID%', NULL)");
 
                // Request parameters per type handler - A3H
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (1, 1, 'id', 'id', NULL),
 (1, 1, 'minimum_stay', 'ma', NULL),
 (1, 1, 'password', 'pw', NULL),
@@ -801,7 +803,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (1, 11, 'type', 'typ', 'html')");
 
                // Request parameters per type handler - AbisZED-Netz
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (2, 187, 'id', 'id', NULL),
 (2, 187, 'password', 'pw', NULL),
 (2, 187, 'reload', 'reload', NULL),
@@ -912,7 +914,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (2, 201, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - Ad-Hit
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (31, 302, 'extra', 'typ', 'forcedbanner'),
 (31, 302, 'id', 'id', NULL),
 (31, 302, 'password', 'pw', NULL),
@@ -997,7 +999,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
                // Request parameters per type handler - Ad-Magnet
 
                // Request parameters per type handler - AdCity.eu
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `network_request_param_key`, `network_request_param_value`, `network_request_param_default`) VALUES
 (32, 312, 'extra', 'typ', 'forcedbanner'),
 (32, 312, 'id', 'id', NULL),
 (32, 312, 'password', 'pw', NULL),
@@ -1072,7 +1074,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
                // Request parameters per type handler - AdCocktail
 
                // Request parameters per type handler - AdConvention
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (30, 292, 'extra', 'typ', 'forcedbanner'),
 (30, 292, 'id', 'id', NULL),
 (30, 292, 'minimum_stay', 'ma', NULL),
@@ -1145,7 +1147,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (30, 301, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - AdPaid
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (5, 177, 'id', 'id', NULL),
 (5, 177, 'password', 'pw', NULL),
 (5, 177, 'reload', 'reload', NULL),
@@ -1218,7 +1220,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (5, 186, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - Ads4
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (6, 14, 'currency', 'waehrung', NULL),
 (6, 14, 'extra', 'mediatype', 'forced_banner'),
 (6, 14, 'id', 'id', NULL),
@@ -1253,7 +1255,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (6, 119, 'reward', 'verg', NULL)");
 
                // Request parameters per type handler - Ads4Webbis
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (7, 17, 'extra', 'typ', 'forcedbanner'),
 (7, 17, 'id', 'id', NULL),
 (7, 17, 'password', 'pw', NULL),
@@ -1318,7 +1320,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (7, 120, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - Ads4World
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (8, 26, 'extra', 'typ', 'forcedbanner'),
 (8, 26, 'id', 'id', NULL),
 (8, 26, 'password', 'pw', NULL),
@@ -1385,7 +1387,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
                // Request parameters per type handler - Affiliblatt
 
                // Request parameters per type handler - AllAds4You
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (10, 167, 'extra', 'typ', 'forcedbanner'),
 (10, 167, 'id', 'id', NULL),
 (10, 167, 'password', 'pw', NULL),
@@ -1458,7 +1460,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (10, 176, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - Alster-Marketing
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (11, 35, 'id', 'id', NULL),
 (11, 35, 'password', 'pw', NULL),
 (11, 35, 'reload', 'reload', NULL),
@@ -1569,7 +1571,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (11, 49, 'type', 'typ', 'view')");
 
                // Request parameters per type handler - BonusSponsor
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (12, 50, 'id', 'id', NULL),
 (12, 50, 'password', 'pw', NULL),
 (12, 50, 'reload', 'reload', NULL),
@@ -1664,7 +1666,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (12, 62, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - City-Ads
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (24, 212, 'extra', 'typ', 'forcedbanner'),
 (24, 212, 'id', 'id', NULL),
 (24, 212, 'password', 'pw', NULL),
@@ -1737,7 +1739,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (24, 221, 'minimum_stay', 'ma', NULL)");
 
                // Request parameters per type handler - doubleads
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (26, 232, 'id', 'id', NULL),
 (26, 232, 'password', 'pw', NULL),
 (26, 232, 'reload', 'reload', NULL),
@@ -1848,7 +1850,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (26, 246, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - FuCoExSponsor.net
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (29, 273, 'extra', 'art', 'bannerklick'),
 (29, 273, 'id', 'uid', NULL),
 (29, 273, 'password', 'pw', NULL),
@@ -1976,7 +1978,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (29, 289, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - Fusion-Ads
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (13, 290, 'extra', 'art', 'Forcedbanner'),
 (13, 290, 'id', 'uid', NULL),
 (13, 290, 'password', 'pw', NULL),
@@ -1993,7 +1995,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (13, 291, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - GigapPromo
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (14, 102, 'id', 'id', NULL),
 (14, 102, 'password', 'pw', NULL),
 (14, 102, 'reload', 'reload', NULL),
@@ -2044,7 +2046,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (14, 108, 'sid', 'aid', NULL)");
 
                // Request parameters per type handler - Gold-Sponsor
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (25, 222, 'extra', 'typ', 'forcedbanner'),
 (25, 222, 'id', 'id', NULL),
 (25, 222, 'minimum_stay', 'ma', NULL),
@@ -2117,7 +2119,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (25, 231, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - homeADS
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (28, 260, 'id', 'id', NULL),
 (28, 260, 'password', 'pw', NULL),
 (28, 260, 'reload', 'reload', NULL),
@@ -2212,7 +2214,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (28, 272, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - HPSponsor
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (15, 135, 'extra', 'typ', 'forcedbanner'),
 (15, 135, 'id', 'id', NULL),
 (15, 135, 'password', 'pw', NULL),
@@ -2277,7 +2279,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (15, 144, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - Make-Euros
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (16, 63, 'id', 'id', NULL),
 (16, 63, 'password', 'pw', NULL),
 (16, 63, 'reload', 'reload', NULL),
@@ -2388,7 +2390,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (16, 77, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - Mega-Ad
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (17, 109, 'extra', 'typ', 'forcedbanner'),
 (17, 109, 'id', 'id', NULL),
 (17, 109, 'password', 'pw', NULL),
@@ -2451,7 +2453,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (17, 123, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - Power-Promo
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (18, 78, 'id', 'id', NULL),
 (18, 78, 'password', 'pw', NULL),
 (18, 78, 'reload', 'reload', NULL),
@@ -2562,7 +2564,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (18, 92, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - SeCash
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (19, 93, 'extra', 'typ', 'forcedbanner'),
 (19, 93, 'id', 'id', NULL),
 (19, 93, 'password', 'pw', NULL),
@@ -2627,7 +2629,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (19, 124, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - Swizerland
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (20, 202, 'extra', 'typ', 'forcedbanner'),
 (20, 202, 'id', 'id', NULL),
 (20, 202, 'password', 'pw', NULL),
@@ -2692,7 +2694,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (20, 211, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - UltraPROMO
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (21, 125, 'extra', 'typ', 'bannerklick'),
 (21, 125, 'id', 'id', NULL),
 (21, 125, 'password', 'pw', NULL),
@@ -2757,7 +2759,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (21, 134, 'reward', 'verguetung', NULL)");
 
                // Request parameters per type handler - VIPads.de
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (27, 247, 'extra', 'art', 'bannerklick'),
 (27, 247, 'id', 'uid', NULL),
 (27, 247, 'password', 'pw', NULL),
@@ -2856,7 +2858,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (27, 259, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - Der Werbepartner.cc
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (22, 145, 'extra', 'art', 'Textlinkklick'),
 (22, 145, 'id', 'uid', NULL),
 (22, 145, 'password', 'pw', NULL),
@@ -2936,7 +2938,7 @@ UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
 (22, 155, 'sid', 'sid', NULL)");
 
                // Request parameters per type handler - Yoo!Media
-               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`request_param_default`) VALUES
+               addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
 (23, 156, 'erotic', 'erotik', NULL),
 (23, 156, 'id', 'id', NULL),
 (23, 156, 'password', 'pw', NULL),