`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_data_separator` CHAR(4) NOT NULL DEFAULT '|',
+`network_row_separator` CHAR(4) NOT NULL DEFAULT '|',
`network_request_type` ENUM('GET','POST') NOT NULL DEFAULT 'GET',
`network_charset` VARCHAR(20) NOT NULL DEFAULT 'UTF-8',
`network_require_id_card` ENUM('Y','N') NOT NULL DEFAULT 'N',
+`network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`network_id`),
UNIQUE (`network_short_name`)",
'Network data');
`network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '',
`network_type_banner_url` VARCHAR(255) NULL DEFAULT NULL,
PRIMARY KEY (`network_type_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_handle`)",
+UNIQUE INDEX `provider_type` (`network_id`,`network_type_handle`)",
'Types provideable by networks');
// HTTP parameters (names) for URLs
`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 `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
-UNIQUE `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
`network_type_code_value` VARCHAR(50) NOT NULL DEFAULT '',
`network_type_code_type` VARCHAR(100) NOT NULL DEFAULT 'INVALID_TYPE',
PRIMARY KEY (`network_type_code_id`),
-UNIQUE `code_type` (`network_type_code_value`,`network_type_id`),
+UNIQUE INDEX `code_type` (`network_type_code_value`,`network_type_id`),
INDEX (`network_type_id`)",
'Error codes for all types');
`network_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`network_api_id`),
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
+UNIQUE INDEX `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
INDEX (`sort`)",
'Translation of API responses, generic data, DO NOT ALTER!');
// Data from the webmaster (you!)
- addDropTableSql('network_config');
- addCreateTableSql('network_config', "
+ 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_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
+`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 `network_affiliate` (`network_id`,`network_affiliate_id`),
-UNIQUE `affiliate_site` (`network_affiliate_id`,`network_site_id`)",
- 'Configuration data from the webmaster (you!)');
+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
addDropTableSql('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 '',
+`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 `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
'Configuration data for every type (e.g. reload-time)');
// Cache for queried APIs. Re-check depends on config
`network_cache_data` MEDIUMBLOB,
`network_cache_timestamp` TIMESTAMP NULL DEFAULT NULL,
PRIMARY KEY (`network_cache_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
'Cache for all queried APIs');
// Reload locks for several types
`network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`network_reload_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
'Reload locks');
// Insert API response array translations, these will be used for calling the right filter function
('textlink5'),
('subject'),
('click_url'),
-('media_url')");
+('media_url'),
+('allowed_countries')");
// Insert error code types
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES
('REQUEST_PARAMETER_INCOMPLETE')");
// Sponsor networks
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`,`network_title`,`network_reflink`,`network_data_seperator`,`network_row_seperator`,`network_request_type`,`network_charset`,`network_require_id_card`) VALUES
-('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252','Y'),
-('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1','N'),
-('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('adpaid', 'AdPaid', 'http://www.adpaid.de?ref=1464', '|', '|', 'GET', 'ISO-8859-1','N'),
-('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('affiliblatt', 'Affiliblatt', 'http://www.Affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8','N'),
-('allads4you', 'AllAds4You', 'http://www.allads4you.de?ref=1146', '|', '|', 'GET', 'ISO-8859-1','N'),
-('alster', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16','N'),
-('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'ISO-8859-1','N'),
-('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('hpsonsor', 'HPSponsor', 'http://hpsponsor.at?ref=29', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1','N'),
-('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('weltpromotion', 'Welt-Promotion', 'http://www.weltpromotion.de?ref=3', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('cityads', 'City-Ads', 'http://www.city-ads.de?ref=221', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('goldsponsor', 'Gold-Sponsor', 'http://www.gold-sponsor.de?ref=42', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1','Y'),
-('vipads', 'VIPads.de', 'http://vipads.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1','N'),
-('homeads', 'homeADS', 'http://www.homeads.de/?ref=1540', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('fucoexsponsor', 'FuCoExSponsor.net', 'http://fucoexsponsor.net/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1','N'),
-('adconvention', 'AdConvention', 'http://www.adconvention.de?ref=233', '|', '|', 'GET', 'WINDOWS-1252','N')");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`,`network_title`,`network_reflink`,`network_data_separator`,`network_row_separator`,`network_request_type`,`network_charset`,`network_require_id_card`,`network_query_amount`) VALUES
+('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252', 'N', 100),
+('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252', 'Y', 0),
+('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('adpaid', 'AdPaid', 'http://www.adpaid.de?ref=1464', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('affiliblatt', 'Affiliblatt', 'http://www.affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8', 'N', 0),
+('allads4you', 'AllAds4You', 'http://www.allads4you.de?ref=1146', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('alstermarketing', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16', 'N', 0),
+('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('hpsponsor', 'HPSponsor', 'http://hpsponsor.at?ref=29', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('weltpromotion', 'Welt-Promotion', 'http://www.weltpromotion.de?ref=3', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('cityads', 'City-Ads', 'http://www.city-ads.de?ref=221', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('goldsponsor', 'Gold-Sponsor', 'http://www.gold-sponsor.de?ref=42', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1','Y', 0),
+('vipads', 'VIPads.de', 'http://vipads.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('homeads', 'homeADS', 'http://www.homeads.de/?ref=1540', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('fucoexsponsor', 'FuCoExSponsor.net', 'http://fucoexsponsor.net/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('adconvention', 'AdConvention', 'http://www.adconvention.de?ref=233', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('ad-hit', 'Ad-Hit.de', 'http://www.ad-hit.de?ref=41', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('adcity', 'AdCity.eu', 'http://www.adcity.eu?ref=38', '|', '|', 'GET', 'WINDOWS-1252', 'N', 200)");
// 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
(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-Hit.de
+ 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
+(302, 31, 'forcedbanner', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ad-hit.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(303, 31, 'forcedtextlink', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(304, 31, 'banner_view', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ad-hit.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(305, 31, 'banner_click', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ad-hit.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(306, 31, 'skybanner_view', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ad-hit.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(307, 31, 'button_view', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ad-hit.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(308, 31, 'textlink_view', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(309, 31, 'traffic', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(310, 31, 'popup', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(311, 31, 'textmail', 'http://www.ad-hit.de/interface/api_2.php', 'http://www.ad-hit.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL)");
+
// Network type handlers - Ad-Magnet
+ // Network type handlers - AdCity.eu
+ 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
+(312, 32, 'forcedbanner', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(313, 32, 'forcedtextlink', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(314, 32, 'banner_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(315, 32, 'banner_click', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(316, 32, 'skybanner_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(317, 32, 'button_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(318, 32, 'textlink_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(319, 32, 'traffic', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(320, 32, 'popup', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(321, 32, 'textmail', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+
// 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%'),
// 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/api_2.php', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(20, 7, 'banner_click', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
(19, 7, 'banner_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
-(24, 7, 'popup', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
-(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
-(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
-(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL)");
+(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(24, 7, 'popup', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL)");
// Network type handlers - Ads4World
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`,`network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES
// Network type handlers - 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)");
+(167, 10, 'forcedbanner', 'http://www.allads4you.de/interface/get_v3.php', '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/get_v3.php', 'http://www.allads4you.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(169, 10, 'banner_view', 'http://www.allads4you.de/interface/get_v3.php', '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/get_v3.php', '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/get_v3.php', '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/get_v3.php', '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/get_v3.php', 'http://www.allads4you.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(174, 10, 'traffic', 'http://www.allads4you.de/interface/get_v3.php', 'http://www.allads4you.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(175, 10, 'popup', 'http://www.allads4you.de/interface/get_v3.php', 'http://www.allads4you.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(176, 10, 'textmail', 'http://www.allads4you.de/interface/get_v3.php', '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
// 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/api_2.php', 'http://www.secash.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(94, 19, 'forcedtextlink', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(93, 19, 'forcedbanner', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.secash.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(94, 19, 'forcedtextlink', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
(95, 19, 'banner_view', 'http://www.secash.de/interface/api_2.php', '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/api_2.php', 'http://www.secash.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(97, 19, 'skybanner_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(98, 19, 'button_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(99, 19, 'textlink_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
-(100, 19, 'popup', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
-(101, 19, 'textmail', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
-(124, 19, 'traffic', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL)");
+(96, 19, 'banner_click', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.secash.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(97, 19, 'skybanner_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.secash.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(98, 19, 'button_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.secash.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(99, 19, 'textlink_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(100, 19, 'popup', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(101, 19, 'textmail', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(124, 19, 'traffic', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 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
(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),
(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),
(2, 201, 'reward', 'verguetung', NULL),
(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`,`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),
+(31, 302, 'remain', 'uebrig', NULL),
+(31, 302, 'reload', 'reload', NULL),
+(31, 302, 'reward', 'verguetung', NULL),
+(31, 302, 'sid', 'siteid', NULL),
+(31, 302, 'minimum_stay', 'ma', NULL),
+(31, 303, 'extra', 'typ', 'forcedtextlink'),
+(31, 303, 'id', 'id', NULL),
+(31, 303, 'password', 'pw', NULL),
+(31, 303, 'remain', 'uebrig', NULL),
+(31, 303, 'reload', 'reload', NULL),
+(31, 303, 'reward', 'verguetung', NULL),
+(31, 303, 'sid', 'siteid', NULL),
+(31, 303, 'minimum_stay', 'ma', NULL),
+(31, 304, 'extra', 'typ', 'bannerview'),
+(31, 304, 'id', 'id', NULL),
+(31, 304, 'password', 'pw', NULL),
+(31, 304, 'remain', 'uebrig', NULL),
+(31, 304, 'reload', 'reload', NULL),
+(31, 304, 'reward', 'verguetung', NULL),
+(31, 304, 'sid', 'siteid', NULL),
+(31, 304, 'minimum_stay', 'ma', NULL),
+(31, 305, 'extra', 'typ', 'bannerklick'),
+(31, 305, 'id', 'id', NULL),
+(31, 305, 'password', 'pw', NULL),
+(31, 305, 'remain', 'uebrig', NULL),
+(31, 305, 'reload', 'reload', NULL),
+(31, 305, 'reward', 'verguetung', NULL),
+(31, 305, 'sid', 'siteid', NULL),
+(31, 305, 'minimum_stay', 'ma', NULL),
+(31, 306, 'extra', 'typ', 'skybannerview'),
+(31, 306, 'id', 'id', NULL),
+(31, 306, 'password', 'pw', NULL),
+(31, 306, 'remain', 'uebrig', NULL),
+(31, 306, 'reload', 'reload', NULL),
+(31, 306, 'reward', 'verguetung', NULL),
+(31, 306, 'sid', 'siteid', NULL),
+(31, 306, 'minimum_stay', 'ma', NULL),
+(31, 307, 'extra', 'typ', 'buttonview'),
+(31, 307, 'id', 'id', NULL),
+(31, 307, 'password', 'pw', NULL),
+(31, 307, 'remain', 'uebrig', NULL),
+(31, 307, 'reload', 'reload', NULL),
+(31, 307, 'reward', 'verguetung', NULL),
+(31, 307, 'sid', 'siteid', NULL),
+(31, 307, 'minimum_stay', 'ma', NULL),
+(31, 308, 'extra', 'typ', 'textview'),
+(31, 308, 'id', 'id', NULL),
+(31, 308, 'password', 'pw', NULL),
+(31, 308, 'remain', 'uebrig', NULL),
+(31, 308, 'reload', 'reload', NULL),
+(31, 308, 'reward', 'verguetung', NULL),
+(31, 308, 'sid', 'siteid', NULL),
+(31, 308, 'minimum_stay', 'ma', NULL),
+(31, 309, 'extra', 'typ', 'traffic'),
+(31, 309, 'id', 'id', NULL),
+(31, 309, 'password', 'pw', NULL),
+(31, 309, 'remain', 'uebrig', NULL),
+(31, 309, 'reload', 'reload', NULL),
+(31, 309, 'reward', 'verguetung', NULL),
+(31, 309, 'sid', 'siteid', NULL),
+(31, 309, 'minimum_stay', 'ma', NULL),
+(31, 310, 'extra', 'typ', 'popup'),
+(31, 310, 'id', 'id', NULL),
+(31, 310, 'password', 'pw', NULL),
+(31, 310, 'remain', 'uebrig', NULL),
+(31, 310, 'reload', 'reload', NULL),
+(31, 310, 'reward', 'verguetung', NULL),
+(31, 310, 'sid', 'siteid', NULL),
+(31, 310, 'minimum_stay', 'ma', NULL),
+(31, 311, 'extra', 'typ', 'paidmail'),
+(31, 311, 'id', 'id', NULL),
+(31, 311, 'password', 'pw', NULL),
+(31, 311, 'remain', 'uebrig', NULL),
+(31, 311, 'reload', 'reload', NULL),
+(31, 311, 'reward', 'verguetung', NULL),
+(31, 311, 'sid', 'siteid', NULL),
+(31, 311, 'minimum_stay', 'ma', NULL)");
+
// 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`, `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),
+(32, 312, 'remain', 'uebrig', NULL),
+(32, 312, 'reload', 'reload', NULL),
+(32, 312, 'reward', 'verguetung', NULL),
+(32, 312, 'minimum_stay', 'ma', NULL),
+(32, 313, 'extra', 'typ', 'forcedtextlink'),
+(32, 313, 'id', 'id', NULL),
+(32, 313, 'password', 'pw', NULL),
+(32, 313, 'remain', 'uebrig', NULL),
+(32, 313, 'reload', 'reload', NULL),
+(32, 313, 'reward', 'verguetung', NULL),
+(32, 313, 'minimum_stay', 'ma', NULL),
+(32, 314, 'extra', 'typ', 'bannerview'),
+(32, 314, 'id', 'id', NULL),
+(32, 314, 'password', 'pw', NULL),
+(32, 314, 'remain', 'uebrig', NULL),
+(32, 314, 'reload', 'reload', NULL),
+(32, 314, 'reward', 'verguetung', NULL),
+(32, 314, 'minimum_stay', 'ma', NULL),
+(32, 315, 'extra', 'typ', 'bannerklick'),
+(32, 315, 'id', 'id', NULL),
+(32, 315, 'password', 'pw', NULL),
+(32, 315, 'remain', 'uebrig', NULL),
+(32, 315, 'reload', 'reload', NULL),
+(32, 315, 'reward', 'verguetung', NULL),
+(32, 315, 'minimum_stay', 'ma', NULL),
+(32, 316, 'extra', 'typ', 'skyview'),
+(32, 316, 'id', 'id', NULL),
+(32, 316, 'password', 'pw', NULL),
+(32, 316, 'remain', 'uebrig', NULL),
+(32, 316, 'reload', 'reload', NULL),
+(32, 316, 'reward', 'verguetung', NULL),
+(32, 316, 'minimum_stay', 'ma', NULL),
+(32, 317, 'extra', 'typ', 'buttonview'),
+(32, 317, 'id', 'id', NULL),
+(32, 317, 'password', 'pw', NULL),
+(32, 317, 'remain', 'uebrig', NULL),
+(32, 317, 'reload', 'reload', NULL),
+(32, 317, 'reward', 'verguetung', NULL),
+(32, 317, 'minimum_stay', 'ma', NULL),
+(32, 318, 'extra', 'typ', 'textview'),
+(32, 318, 'id', 'id', NULL),
+(32, 318, 'password', 'pw', NULL),
+(32, 318, 'remain', 'uebrig', NULL),
+(32, 318, 'reload', 'reload', NULL),
+(32, 318, 'reward', 'verguetung', NULL),
+(32, 318, 'minimum_stay', 'ma', NULL),
+(32, 319, 'extra', 'typ', 'taffic'),
+(32, 319, 'id', 'id', NULL),
+(32, 319, 'password', 'pw', NULL),
+(32, 319, 'remain', 'uebrig', NULL),
+(32, 319, 'reload', 'reload', NULL),
+(32, 319, 'reward', 'verguetung', NULL),
+(32, 319, 'minimum_stay', 'ma', NULL),
+(32, 320, 'extra', 'typ', 'popup'),
+(32, 320, 'id', 'id', NULL),
+(32, 320, 'password', 'pw', NULL),
+(32, 320, 'remain', 'uebrig', NULL),
+(32, 320, 'reload', 'reload', NULL),
+(32, 320, 'reward', 'verguetung', NULL),
+(32, 320, 'minimum_stay', 'ma', NULL),
+(32, 321, 'extra', 'typ', 'paidmail'),
+(32, 321, 'id', 'id', NULL),
+(32, 321, 'password', 'pw', NULL),
+(32, 321, 'remain', 'uebrig', NULL),
+(32, 321, 'reload', 'reload', NULL),
+(32, 321, 'reward', 'verguetung', NULL),
+(32, 321, 'minimum_stay', 'ma', NULL)");
+
// 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),
(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),
(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),
(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),
(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),
// 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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(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),
(2, 201, 9, 9),
(2, 201, 25, 10)");
+ // API array elements - Ad-Hit.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+(31, 302, 1, 1),
+(31, 302, 2, 2),
+(31, 302, 4, 3),
+(31, 302, 5, 4),
+(31, 302, 6, 5),
+(31, 302, 10, 6),
+(31, 302, 9, 7),
+(31, 302, 40, 8),
+(31, 303, 1, 1),
+(31, 303, 2, 2),
+(31, 303, 4, 3),
+(31, 303, 5, 4),
+(31, 303, 6, 5),
+(31, 303, 10, 6),
+(31, 303, 9, 7),
+(31, 303, 40, 8),
+(31, 304, 1, 1),
+(31, 304, 2, 2),
+(31, 304, 4, 3),
+(31, 304, 5, 4),
+(31, 304, 6, 5),
+(31, 304, 10, 6),
+(31, 304, 9, 7),
+(31, 304, 40, 8),
+(31, 305, 1, 1),
+(31, 305, 2, 2),
+(31, 305, 4, 3),
+(31, 305, 5, 4),
+(31, 305, 6, 5),
+(31, 305, 10, 6),
+(31, 305, 9, 7),
+(31, 305, 40, 8),
+(31, 306, 1, 1),
+(31, 306, 2, 2),
+(31, 306, 4, 3),
+(31, 306, 5, 4),
+(31, 306, 6, 5),
+(31, 306, 10, 6),
+(31, 306, 9, 7),
+(31, 306, 40, 8),
+(31, 307, 1, 1),
+(31, 307, 2, 2),
+(31, 307, 4, 3),
+(31, 307, 5, 4),
+(31, 307, 6, 5),
+(31, 307, 10, 6),
+(31, 307, 9, 7),
+(31, 307, 40, 8),
+(31, 308, 1, 1),
+(31, 308, 2, 2),
+(31, 308, 4, 3),
+(31, 308, 5, 4),
+(31, 308, 6, 5),
+(31, 308, 10, 6),
+(31, 308, 9, 7),
+(31, 308, 40, 8),
+(31, 309, 1, 1),
+(31, 309, 2, 2),
+(31, 309, 4, 3),
+(31, 309, 5, 4),
+(31, 309, 6, 5),
+(31, 309, 10, 6),
+(31, 309, 9, 7),
+(31, 309, 40, 8),
+(31, 310, 1, 1),
+(31, 310, 2, 2),
+(31, 310, 4, 3),
+(31, 310, 5, 4),
+(31, 310, 6, 5),
+(31, 310, 10, 6),
+(31, 310, 9, 7),
+(31, 310, 40, 8),
+(31, 311, 1, 1),
+(31, 311, 2, 2),
+(31, 311, 4, 3),
+(31, 311, 5, 4),
+(31, 311, 6, 5),
+(31, 311, 10, 6),
+(31, 311, 9, 7),
+(31, 311, 40, 8)");
+
// API array elements - AD-Magnet
+ // API array elements - ADCity.eu
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(32, 312, 1, 1),
+(32, 312, 2, 2),
+(32, 312, 4, 3),
+(32, 312, 5, 4),
+(32, 312, 6, 5),
+(32, 313, 1, 1),
+(32, 313, 2, 2),
+(32, 313, 4, 3),
+(32, 313, 5, 4),
+(32, 313, 6, 5),
+(32, 314, 1, 1),
+(32, 314, 2, 2),
+(32, 314, 4, 3),
+(32, 314, 5, 4),
+(32, 314, 6, 5),
+(32, 315, 1, 1),
+(32, 315, 2, 2),
+(32, 315, 4, 3),
+(32, 315, 5, 4),
+(32, 315, 6, 5),
+(32, 316, 1, 1),
+(32, 316, 2, 2),
+(32, 316, 4, 3),
+(32, 316, 5, 4),
+(32, 316, 6, 5),
+(32, 317, 1, 1),
+(32, 317, 2, 2),
+(32, 317, 4, 3),
+(32, 317, 5, 4),
+(32, 317, 6, 5),
+(32, 318, 1, 1),
+(32, 318, 2, 2),
+(32, 318, 4, 3),
+(32, 318, 5, 4),
+(32, 318, 6, 5),
+(32, 319, 1, 1),
+(32, 319, 2, 2),
+(32, 319, 4, 3),
+(32, 319, 5, 4),
+(32, 319, 6, 5),
+(32, 320, 1, 1),
+(32, 320, 2, 2),
+(32, 320, 4, 3),
+(32, 320, 5, 4),
+(32, 320, 6, 5),
+(32, 320, 10, 6),
+(32, 321, 1, 1),
+(32, 321, 2, 2),
+(32, 321, 4, 3),
+(32, 321, 5, 4),
+(32, 321, 6, 5),
+(32, 321, 10, 6),
+(32, 321, 9, 7)");
+
// API array elements - ADCocktail
// API array elements - AdConvention
(10, 167, 4, 3),
(10, 167, 5, 4),
(10, 167, 6, 5),
+(10, 167, 10, 6),
+(10, 167, 40, 7),
(10, 168, 1, 1),
(10, 168, 2, 2),
(10, 168, 4, 3),
(10, 168, 5, 4),
(10, 168, 6, 5),
+(10, 168, 10, 6),
+(10, 168, 40, 7),
(10, 169, 1, 1),
(10, 169, 2, 2),
(10, 169, 4, 3),
(10, 169, 5, 4),
(10, 169, 6, 5),
+(10, 169, 10, 6),
+(10, 169, 40, 7),
(10, 170, 1, 1),
(10, 170, 2, 2),
(10, 170, 4, 3),
(10, 170, 5, 4),
(10, 170, 6, 5),
+(10, 170, 10, 6),
+(10, 170, 40, 7),
(10, 171, 1, 1),
(10, 171, 2, 2),
(10, 171, 4, 3),
(10, 171, 5, 4),
(10, 171, 6, 5),
+(10, 171, 10, 6),
+(10, 171, 40, 7),
(10, 172, 1, 1),
(10, 172, 2, 2),
(10, 172, 4, 3),
(10, 172, 5, 4),
(10, 172, 6, 5),
+(10, 172, 10, 6),
+(10, 172, 40, 7),
(10, 173, 1, 1),
(10, 173, 2, 2),
(10, 173, 4, 3),
(10, 173, 5, 4),
(10, 173, 6, 5),
+(10, 173, 10, 6),
+(10, 173, 40, 7),
(10, 174, 1, 1),
(10, 174, 2, 2),
(10, 174, 4, 3),
(10, 174, 5, 4),
(10, 174, 6, 5),
+(10, 174, 10, 6),
+(10, 174, 40, 7),
(10, 175, 1, 1),
(10, 175, 2, 2),
(10, 175, 4, 3),
(10, 175, 5, 4),
(10, 175, 6, 5),
(10, 175, 10, 6),
+(10, 175, 40, 7),
(10, 176, 1, 1),
(10, 176, 2, 2),
(10, 176, 4, 3),
(10, 176, 5, 4),
(10, 176, 6, 5),
(10, 176, 10, 6),
-(10, 176, 9, 7)");
+(10, 176, 9, 7),
+(10, 176, 40, 8)");
// API array elements - Alster-Marketing
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
(23, 166, 9, 5)");
// Admin menu entries
- addAdminMenuSql('network',NULL,'Werbenetzwerke','Verwalten Sie hier Werbenetzwerke (API-Anbindung), versenden Sie deren Mails, oder übernehmen Sie deren Textlinks und vieles mehr. <strong>VORSICHT:</strong> Das Einrichten von weiteren Werbenetzwerken ist nicht leicht, dafür aber sehr flexibel! Sollte ein Netzwerk fehlen, so melden Sie dies bitte <a href="http://forum.mxchange.org/topic-462.html" target="_blank" title="Direktlink zum Forum">im Forum</a>!',4);
- addAdminMenuSql('network','config_networks','API-Daten','Stellen Sie Ihre Affiliate- Webseiten-Id und API-Passwort ein. Diese erhalten Sie zu über 99% aus dem jeweiligen Zugangsbereich des Anbieters. Sollten Sie bei einem Netzwerk noch nicht angemeldet sein, verwenden Sie bitte meinen Referal-Link.',1);
- addAdminMenuSql('network','config_network_types','Werbearten','Stellen Sie hier Reload-Zeiten, Mindestauffenthalt und so weiter pro Werbeart und Werbenetzwerk ein. Es werden sonst Ausgangswerte (Mimimumwerte: 0, Maximumwerte: sehr gross, Erotik: aus) angenommen, die Sie meistens nicht wollen.',2);
- addAdminMenuSql('network','query_networks','APIs abfragen','Fragt alle eingestellten APIs ab. Die Ergebnisse werden dann für einen einstellbaren Zeitraum gecacht und nicht erneut angefordert.',3);
- addAdminMenuSql('network','config_network','Einstellungen','Stellen Sie generelle Einstellungen ein, die für alle Werbenetzwerke gelten, wie z.B. Cache-Erneuerungsinterval. Generell sind aber die Einstellungen in Ordnung, da z.B. sonst Ihre freien Abfragen beim Werbenetzwerk sich zu schnell abbauen.',4);
- addAdminMenuSql('network','list_network_reloads','Reload-Sperren','Listen oder löschen Sie hier Reload-Sperren. <strong>Vorsicht:</strong> Die hier gespeicherten Reload-Sperren sind vom jeweiligen Werbenetzwerk übernommen. Eventuell verdienen Sie nichts, wenn Sie z.B. eine Mail innerhalb der Reload-Sperre erneut versenden.',5);
- addAdminMenuSql('network','list_networks','Auflisten/Verwalten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',6);
- addAdminMenuSql('network','list_network_types','Werbearten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',7);
- addAdminMenuSql('network','list_network_params','Abfrageparameter','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Abfrageparameter (wie sie genannt werden müssen, um das API-Script korrekt aufrufen zu können) ein, pro Werbenetzwerk. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',8);
- addAdminMenuSql('network','list_network_api_translation','Antwort-Array','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',10);
- addAdminMenuSql('network','list_network_error_codes','Fehlercodes','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Fehlercodes ein, die im Falle eines Fehlers pro API-Script kommen können. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',11);
- addAdminMenuSql('network','list_network_error_types','Fehlertypen','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',12);
+ addAdminMenuSql('network', NULL, 'Werbenetzwerke', 'Verwalten Sie hier Werbenetzwerke (API-Anbindung), versenden Sie deren Mails, oder übernehmen Sie deren Textlinks und vieles mehr. <strong>VORSICHT:</strong> Das Einrichten von weiteren Werbenetzwerken ist nicht leicht, dafür aber sehr flexibel! Sollte ein Netzwerk fehlen, so melden Sie dies bitte <a href="http://forum.mxchange.org/topic-462.html" target="_blank" title="Direktlink zum Forum">im Forum</a>!',4);
+ addAdminMenuSql('network', 'config_network_api', 'API-Zugangsdaten', 'Stellen Sie Ihre Affiliate- Webseiten-Id und API-Passwort ein. Diese erhalten Sie aus dem Affiliate-Bereich des jeweiligen Werbenetzwerkes. Sollten Sie bei einem Werbenetzwerk noch nicht angemeldet sein, verwenden Sie bitte meinen Referral-Link dazu.',1);
+ addAdminMenuSql('network', 'config_network_types', 'Werbearten', 'Stellen Sie hier Reload-Zeiten, Mindestauffenthalt und so weiter pro Werbeart und Werbenetzwerk ein. Es werden sonst Ausgangswerte (Mimimumwerte: 0, Maximumwerte: sehr gross, Erotik: aus) angenommen, die Sie meistens nicht wollen.',2);
+ addAdminMenuSql('network', 'query_networks', 'APIs abfragen', 'Fragt alle eingestellten APIs ab. Die Ergebnisse werden dann für einen einstellbaren Zeitraum gecacht und nicht erneut angefordert.',3);
+ addAdminMenuSql('network', 'config_network', 'Einstellungen', 'Stellen Sie generelle Einstellungen ein, die für alle Werbenetzwerke gelten, wie z.B. Cache-Erneuerungsinterval. Generell sind aber die Einstellungen in Ordnung, da z.B. sonst Ihre freien Abfragen beim Werbenetzwerk sich zu schnell abbauen.',4);
+ addAdminMenuSql('network', 'list_network_reloads', 'Reload-Sperren', 'Listen oder löschen Sie hier Reload-Sperren. <strong>Vorsicht:</strong> Die hier gespeicherten Reload-Sperren sind vom jeweiligen Werbenetzwerk übernommen. Eventuell verdienen Sie nichts, wenn Sie z.B. eine Mail innerhalb der Reload-Sperre erneut versenden.',5);
+ addAdminMenuSql('network', 'list_networks', 'Auflisten/Verwalten', '<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 6);
+ addAdminMenuSql('network', 'list_network_types', 'Werbearten', '<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 7);
+ addAdminMenuSql('network', 'list_network_params', 'Abfrageparameter', '<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Abfrageparameter (wie sie genannt werden müssen, um das API-Script korrekt aufrufen zu können) ein, pro Werbenetzwerk. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 8);
+ addAdminMenuSql('network', 'list_network_api_translation', 'Antwort-Array', '<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 10);
+ addAdminMenuSql('network', 'list_network_error_codes', 'Fehlercodes', '<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Fehlercodes ein, die im Falle eines Fehlers pro API-Script kommen können. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 11);
+ addAdminMenuSql('network', 'list_network_error_types', 'Fehlertypen', '<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 12);
// Configuration entries
addConfigAddSql('network_cache_refresh', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (60 * 15));
addDropTableSql('network_error_codes');
addDropTableSql('network_error_types');
addDropTableSql('network_api_translation');
- addDropTableSql('network_config');
+ addDropTableSql('network_api_config');
addDropTableSql('network_types_config');
addDropTableSql('network_cache');
addDropTableSql('network_reloads');