* @TODO Ad-Magnet: Layer(klick?). Layerviews.Skybannerklick/-view, *
* @TODO Ad-Magnet: Banner-View, Textlink-Klick/-View. Page-Peel *
* @TODO ADCocktail: All request parameters, BIDausKAS, WIDausKAS??? *
+ * @TODO ADCocktail: Zero array element is return code! *
* @TODO Affiliblatt: All except banner, do they really have UTF-8? *
- * @TODO AllAds4You: Traffic from abroad *
+ * @TODO AllAds4You: Traffic from abroad, High-Forced banner *
* @TODO doubleads: Which charset? *
* @TODO Fusion-Ads: Has click/banner URL in API response, really UTF-8 *
* @TODO GolloX: Which charset? *
// Valid translation keys (we hate hard-coded arrays, you see?)
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` (
-`network_translate_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_translation` VARCHAR(100) NOT NULL DEFAULT '',
-UNIQUE `type_trans` (`network_type_id`,`network_translation`),
-PRIMARY KEY (`network_translate_id`)
+`network_translation_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`network_translation_name` VARCHAR(100) NOT NULL DEFAULT '',
+UNIQUE (`network_translation_name`),
+PRIMARY KEY (`network_translation_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Translations for array keys, generic data, DO NOT ALTER!'");
// Array-Element translation tables per type/provider
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_index_translation` VARCHAR(100) NOT NULL DEFAULT '',
+`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
-UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_index_translation`),
+INDEX (`sort`),
PRIMARY KEY (`network_api_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Translation of API responses, generic data, DO NOT ALTER!'");
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
+`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE `provider_type` (`network_id`,`network_type_id`),
PRIMARY KEY (`network_reload_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Reload locks'");
+ // Insert API response array translations, these will be used for calling the right filter function
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_translations` (`network_translation_id`, `network_translation_name`) VALUES
+(1, 'id'),
+(2, 'name'),
+(3, 'alternate_text'),
+(4, 'reload'),
+(5, 'remain'),
+(6, 'reward'),
+(7, 'banner_id'),
+(8, 'size'),
+(9, 'text'),
+(10, 'minimum_stay'),
+(11, 'textlink_id'),
+(12, 'surfbar_id'),
+(13, 'mail_id'),
+(14, 'layer_id'),
+(15, 'popup_id'),
+(16, 'popdown_id'),
+(17, 'lead_id'),
+(18, 'sale_id'),
+(19, 'banner_url1'),
+(20, 'banner_url2'),
+(21, 'banner_url3'),
+(22, 'textlink1'),
+(23, 'textlink2'),
+(24, 'textlink3'),
+(25, 'description'),
+(26, 'traffic_id'),
+(27, 'country_code'),
+(28, 'banner_url4'),
+(29, 'banner_url5'),
+(30, 'banner_url6'),
+(31, 'banner_url7'),
+(32, 'banner_url8'),
+(33, 'banner_url9'),
+(34, 'banner_url10'),
+(35, 'textlink4'),
+(36, 'textlink5'),
+(37, 'subject')");
+
// Insert error code types
// - Affiliate id or interface password wrong
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('AFF_ID_PASS_WRONG')");
- // - Webmaster's site id is not assigned (invalid, different affiliate id)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('SITE_ID_NOT_ASSIGNED')");
- // - Webmaster's site id is locked
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('SITE_ID_LOCKED')");
- // - General error in interface data
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('INTERFACE_DATA_ERROR')");
- // - Request amount depleted
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('REQUESTS_DEPLETED')");
- // - No campaigns found for given criteria (but maybe there are with more widen criteria)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND')");
- // - No campaigns found with allowed interface output (but there are maybe non-interface campaigns)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND_INTERFACE')");
- // - Webmaster's site id is not unlocked for choosen type
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('SITE_ID_NOT_ALLOWED_TYPE')");
- // - Request parameters incomplete
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('REQUEST_PARAMETER_INCOMPLETE')");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code_id`, `network_code`) VALUES
+(1, 'AFF_ID_PASS_WRONG'),
+(2, 'SITE_ID_NOT_ASSIGNED'),
+(3, 'SITE_ID_LOCKED'),
+(4, 'INTERFACE_DATA_ERROR'),
+(5, 'REQUESTS_DEPLETED'),
+(6, 'NO_CAMPAIGNS_FOUND'),
+(7, 'NO_CAMPAIGNS_FOUND_INTERFACE'),
+(8, 'SITE_ID_NOT_ALLOWED_TYPE'),
+(9, 'REQUEST_PARAMETER_INCOMPLETE')");
// Sponsor networks
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`) VALUES
('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252'),
('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'UTF-8'),
('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252'),
-('hpsonsor', 'HPSponsor', 'http://hpsponsor.de?ref=29', '|', '|', 'GET', 'WINDOWS-1252'),
+('hpsonsor', 'HPSponsor', 'http://hpsponsor.at?ref=29', '|', '|', 'GET', 'WINDOWS-1252'),
('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1'),
('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252'),
('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252'),
// Network type handlers - Ads4Webbis
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(20, 7, 'banner_click', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(19, 7, 'banner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(24, 7, 'popup', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+(20, 7, 'banner_click', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(19, 7, 'banner_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(24, 7, 'popup', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/api_2.php', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL)");
// Network type handlers - Ads4World
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
// Network type handlers - HPSponsor
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(135, 15, 'banner_click', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(136, 15, 'banner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(137, 15, 'button_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(138, 15, 'forcedbanner', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(139, 15, 'forcedtextlink', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(140, 15, 'popup', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(141, 15, 'skybanner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(142, 15, 'textlink_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(143, 15, 'textmail', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(144, 15, 'traffic', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%CID%', NULL)");
+(135, 15, 'banner_click', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(136, 15, 'banner_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.at/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(137, 15, 'button_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(138, 15, 'forcedbanner', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(139, 15, 'forcedtextlink', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(140, 15, 'popup', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(141, 15, 'skybanner_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(142, 15, 'textlink_view', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(143, 15, 'textmail', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(144, 15, 'traffic', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/traffic.php?id=%UID%&bid=%CID%&aid=%CID%&trackid=%TID%', NULL)");
// Network type handlers - Make-Euros
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
// Network type handlers - Swizerland
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(205, 20, 'banner_click', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(204, 20, 'banner_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(207, 20, 'button_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(202, 20, 'forcedbanner', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(203, 20, 'forcedtextlink', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(210, 20, 'popup', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(206, 20, 'skybanner_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(208, 20, 'textlink_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(211, 20, 'textmail', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(209, 20, 'traffic', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+(205, 20, 'banner_click', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.the-switzerland-ad-network.ch/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(204, 20, 'banner_view', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(207, 20, 'button_view', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.the-switzerland-ad-network.ch/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(202, 20, 'forcedbanner', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(203, 20, 'forcedtextlink', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(210, 20, 'popup', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(206, 20, 'skybanner_view', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://www.the-switzerland-ad-network.ch/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(208, 20, 'textlink_view', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(211, 20, 'textmail', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL),
+(209, 20, 'traffic', 'http://www.the-switzerland-ad-network.ch/interface/api_2.php', 'http://www.the-switzerland-ad-network.ch/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL)");
// Network type handlers - UltraPROMO
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
(1110, 23, 166, 'reward', 'verguetung', NULL),
(1111, 23, 166, 'erotic', 'erotik', NULL)");
- // Fix empty defaults to NULL
- addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_types` SET `network_type_banner_url`=NULL WHERE `network_type_banner_url`=''");
- addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_request_params` SET `request_param_default`=NULL WHERE `request_param_default`=''");
+ // API array elements - A3H
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(1, 1, 7, 1),
+(1, 1, 2, 2),
+(1, 1, 3, 3),
+(1, 1, 4, 4),
+(1, 1, 5, 5),
+(1, 1, 6, 6),
+(1, 1, 8, 7),
+(1, 1, 10, 8),
+(1, 2, 11, 1),
+(1, 2, 2, 2),
+(1, 2, 9, 3),
+(1, 2, 4, 4),
+(1, 2, 5, 5),
+(1, 2, 6, 6),
+(1, 3, 12, 1),
+(1, 3, 2, 2),
+(1, 3, 3, 3),
+(1, 3, 4, 4),
+(1, 3, 5, 5),
+(1, 3, 6, 6),
+(1, 3, 8, 7),
+(1, 4, 7, 1),
+(1, 4, 2, 2),
+(1, 4, 3, 3),
+(1, 4, 4, 4),
+(1, 4, 5, 5),
+(1, 4, 6, 6),
+(1, 4, 10, 7),
+(1, 4, 8, 8),
+(1, 5, 13, 1),
+(1, 5, 2, 2),
+(1, 5, 4, 3),
+(1, 5, 5, 4),
+(1, 5, 6, 5),
+(1, 5, 10, 6),
+(1, 5, 9, 7),
+(1, 6, 14, 1),
+(1, 6, 2, 2),
+(1, 6, 4, 3),
+(1, 6, 5, 4),
+(1, 6, 6, 5),
+(1, 7, 15, 1),
+(1, 7, 2, 2),
+(1, 7, 4, 3),
+(1, 7, 5, 4),
+(1, 7, 6, 5),
+(1, 7, 10, 6),
+(1, 8, 16, 1),
+(1, 8, 2, 2),
+(1, 8, 4, 3),
+(1, 8, 5, 4),
+(1, 8, 6, 5),
+(1, 8, 10, 6),
+(1, 9, 17, 1),
+(1, 9, 2, 2),
+(1, 9, 6, 3),
+(1, 9, 19, 4),
+(1, 9, 20, 5),
+(1, 9, 21, 6),
+(1, 9, 22, 7),
+(1, 9, 23, 8),
+(1, 9, 9, 9),
+(1, 9, 25, 10),
+(1, 9, 5, 11),
+(1, 10, 18, 1),
+(1, 10, 2, 2),
+(1, 10, 6, 3),
+(1, 10, 19, 4),
+(1, 10, 20, 5),
+(1, 10, 21, 6),
+(1, 10, 22, 7),
+(1, 10, 23, 8),
+(1, 10, 9, 9),
+(1, 10, 25, 10)");
+
+ // API array elements - AbisZED-Netz
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(2, 187, 7, 1),
+(2, 187, 2, 2),
+(2, 187, 3, 3),
+(2, 187, 4, 4),
+(2, 187, 5, 5),
+(2, 187, 6, 6),
+(2, 187, 8, 7),
+(2, 187, 10, 8),
+(2, 188, 7, 1),
+(2, 188, 2, 2),
+(2, 188, 3, 3),
+(2, 188, 4, 4),
+(2, 188, 5, 5),
+(2, 188, 6, 6),
+(2, 188, 8, 7),
+(2, 188, 10, 8),
+(2, 189, 11, 1),
+(2, 189, 2, 2),
+(2, 189, 9, 3),
+(2, 189, 4, 4),
+(2, 189, 5, 5),
+(2, 189, 6, 6),
+(2, 190, 11, 1),
+(2, 190, 2, 2),
+(2, 190, 9, 3),
+(2, 190, 4, 4),
+(2, 190, 5, 5),
+(2, 190, 6, 6),
+(2, 191, 12, 1),
+(2, 191, 2, 2),
+(2, 191, 3, 3),
+(2, 191, 4, 4),
+(2, 191, 5, 5),
+(2, 191, 6, 6),
+(2, 191, 8, 7),
+(2, 192, 12, 1),
+(2, 192, 10, 2),
+(2, 192, 3, 3),
+(2, 192, 4, 4),
+(2, 192, 5, 5),
+(2, 192, 6, 6),
+(2, 192, 8, 7),
+(2, 193, 7, 1),
+(2, 193, 2, 2),
+(2, 193, 3, 3),
+(2, 193, 4, 4),
+(2, 193, 5, 5),
+(2, 193, 6, 6),
+(2, 193, 10, 7),
+(2, 193, 8, 8),
+(2, 194, 13, 1),
+(2, 194, 2, 2),
+(2, 194, 4, 3),
+(2, 194, 5, 4),
+(2, 194, 6, 5),
+(2, 194, 10, 6),
+(2, 194, 9, 7),
+(2, 195, 13, 1),
+(2, 195, 2, 2),
+(2, 195, 4, 3),
+(2, 195, 5, 4),
+(2, 195, 6, 5),
+(2, 195, 10, 6),
+(2, 195, 9, 7),
+(2, 196, 14, 1),
+(2, 196, 2, 2),
+(2, 196, 4, 3),
+(2, 196, 5, 4),
+(2, 196, 6, 5),
+(2, 197, 14, 1),
+(2, 197, 2, 2),
+(2, 197, 4, 3),
+(2, 197, 5, 4),
+(2, 197, 6, 5),
+(2, 198, 15, 1),
+(2, 198, 2, 2),
+(2, 198, 4, 3),
+(2, 198, 5, 4),
+(2, 198, 6, 5),
+(2, 198, 10, 6),
+(2, 199, 16, 1),
+(2, 199, 2, 2),
+(2, 199, 4, 3),
+(2, 199, 5, 4),
+(2, 199, 6, 5),
+(2, 199, 10, 6),
+(2, 200, 17, 1),
+(2, 200, 2, 2),
+(2, 200, 6, 3),
+(2, 200, 19, 4),
+(2, 200, 20, 5),
+(2, 200, 21, 6),
+(2, 200, 22, 7),
+(2, 200, 23, 8),
+(2, 200, 9, 9),
+(2, 200, 25, 10),
+(2, 200, 5, 11),
+(2, 201, 18, 1),
+(2, 201, 2, 2),
+(2, 201, 6, 3),
+(2, 201, 19, 4),
+(2, 201, 20, 5),
+(2, 201, 21, 6),
+(2, 201, 22, 7),
+(2, 201, 23, 8),
+(2, 201, 9, 9),
+(2, 201, 25, 10)");
+
+ // API array elements - AD-Magnet
+
+ // API array elements - ADCocktail
+
+ // API array elements - AdPaid
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(5, 177, 7, 1),
+(5, 177, 2, 2),
+(5, 177, 3, 3),
+(5, 177, 4, 4),
+(5, 177, 5, 5),
+(5, 177, 6, 6),
+(5, 177, 8, 7),
+(5, 177, 10, 8),
+(5, 178, 11, 1),
+(5, 178, 2, 2),
+(5, 178, 9, 3),
+(5, 178, 4, 4),
+(5, 178, 5, 5),
+(5, 178, 6, 6),
+(5, 179, 12, 1),
+(5, 179, 2, 2),
+(5, 179, 3, 3),
+(5, 179, 4, 4),
+(5, 179, 5, 5),
+(5, 179, 6, 6),
+(5, 179, 8, 7),
+(5, 180, 7, 1),
+(5, 180, 2, 2),
+(5, 180, 3, 3),
+(5, 180, 4, 4),
+(5, 180, 5, 5),
+(5, 180, 6, 6),
+(5, 180, 10, 7),
+(5, 180, 8, 8),
+(5, 181, 13, 1),
+(5, 181, 2, 2),
+(5, 181, 4, 3),
+(5, 181, 5, 4),
+(5, 181, 6, 5),
+(5, 181, 10, 6),
+(5, 181, 9, 7),
+(5, 182, 14, 1),
+(5, 182, 2, 2),
+(5, 182, 4, 3),
+(5, 182, 5, 4),
+(5, 182, 6, 5),
+(5, 183, 15, 1),
+(5, 183, 2, 2),
+(5, 183, 4, 3),
+(5, 183, 5, 4),
+(5, 183, 6, 5),
+(5, 183, 10, 6),
+(5, 185, 17, 1),
+(5, 185, 2, 2),
+(5, 185, 6, 3),
+(5, 185, 19, 4),
+(5, 185, 20, 5),
+(5, 185, 21, 6),
+(5, 185, 22, 7),
+(5, 185, 23, 8),
+(5, 185, 9, 9)");
+
+ // API array elements - Ads4.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(6, 14, 7, 1),
+(6, 14, 2, 2),
+(6, 14, 6, 3),
+(6, 14, 4, 4),
+(6, 14, 5, 5),
+(6, 14, 10, 6),
+(6, 15, 13, 1),
+(6, 15, 2, 2),
+(6, 15, 6, 3),
+(6, 15, 4, 4),
+(6, 15, 5, 5),
+(6, 15, 10, 6),
+(6, 16, 13, 1),
+(6, 16, 2, 2),
+(6, 16, 6, 3),
+(6, 16, 4, 4),
+(6, 16, 5, 5),
+(6, 16, 10, 6),
+(6, 119, 26, 1),
+(6, 119, 2, 2),
+(6, 119, 6, 3),
+(6, 119, 4, 4),
+(6, 119, 5, 5),
+(6, 119, 10, 6)");
+
+ // API array elements - Ads4Webbis
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(7, 17, 1, 1),
+(7, 17, 2, 2),
+(7, 17, 4, 3),
+(7, 17, 5, 4),
+(7, 17, 6, 5),
+(7, 17, 10, 6),
+(7, 17, 9, 7),
+(7, 17, 27, 8),
+(7, 18, 1, 1),
+(7, 18, 2, 2),
+(7, 18, 4, 3),
+(7, 18, 5, 4),
+(7, 18, 6, 5),
+(7, 18, 10, 6),
+(7, 18, 9, 7),
+(7, 18, 27, 8),
+(7, 19, 1, 1),
+(7, 19, 2, 2),
+(7, 19, 4, 3),
+(7, 19, 5, 4),
+(7, 19, 6, 5),
+(7, 19, 10, 6),
+(7, 19, 9, 7),
+(7, 19, 27, 8),
+(7, 20, 1, 1),
+(7, 20, 2, 2),
+(7, 20, 4, 3),
+(7, 20, 5, 4),
+(7, 20, 6, 5),
+(7, 20, 10, 6),
+(7, 20, 9, 7),
+(7, 20, 27, 8),
+(7, 21, 1, 1),
+(7, 21, 2, 2),
+(7, 21, 4, 3),
+(7, 21, 5, 4),
+(7, 21, 6, 5),
+(7, 21, 10, 6),
+(7, 21, 9, 7),
+(7, 21, 27, 8),
+(7, 22, 1, 1),
+(7, 22, 2, 2),
+(7, 22, 4, 3),
+(7, 22, 5, 4),
+(7, 22, 6, 5),
+(7, 22, 10, 6),
+(7, 22, 9, 7),
+(7, 22, 27, 8),
+(7, 23, 1, 1),
+(7, 23, 2, 2),
+(7, 23, 4, 3),
+(7, 23, 5, 4),
+(7, 23, 6, 5),
+(7, 23, 10, 6),
+(7, 23, 9, 7),
+(7, 23, 27, 8),
+(7, 24, 1, 1),
+(7, 24, 2, 2),
+(7, 24, 4, 3),
+(7, 24, 5, 4),
+(7, 24, 6, 5),
+(7, 24, 10, 6),
+(7, 24, 9, 7),
+(7, 24, 27, 8),
+(7, 25, 1, 1),
+(7, 25, 2, 2),
+(7, 25, 4, 3),
+(7, 25, 5, 4),
+(7, 25, 6, 5),
+(7, 25, 10, 6),
+(7, 25, 9, 7),
+(7, 25, 27, 8),
+(7, 120, 1, 1),
+(7, 120, 2, 2),
+(7, 120, 4, 3),
+(7, 120, 5, 4),
+(7, 120, 6, 5),
+(7, 120, 10, 6),
+(7, 120, 9, 7),
+(7, 120, 27, 8)");
+
+ // API array elements - Ads4World
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(8, 26, 1, 1),
+(8, 26, 2, 2),
+(8, 26, 4, 3),
+(8, 26, 5, 4),
+(8, 26, 6, 5),
+(8, 27, 1, 1),
+(8, 27, 2, 2),
+(8, 27, 4, 3),
+(8, 27, 5, 4),
+(8, 27, 6, 5),
+(8, 28, 1, 1),
+(8, 28, 2, 2),
+(8, 28, 4, 3),
+(8, 28, 5, 4),
+(8, 28, 6, 5),
+(8, 29, 1, 1),
+(8, 29, 2, 2),
+(8, 29, 4, 3),
+(8, 29, 5, 4),
+(8, 29, 6, 5),
+(8, 30, 1, 1),
+(8, 30, 2, 2),
+(8, 30, 4, 3),
+(8, 30, 5, 4),
+(8, 30, 6, 5),
+(8, 31, 1, 1),
+(8, 31, 2, 2),
+(8, 31, 4, 3),
+(8, 31, 5, 4),
+(8, 31, 6, 5),
+(8, 32, 1, 1),
+(8, 32, 2, 2),
+(8, 32, 4, 3),
+(8, 32, 5, 4),
+(8, 32, 6, 5),
+(8, 33, 1, 1),
+(8, 33, 2, 2),
+(8, 33, 4, 3),
+(8, 33, 5, 4),
+(8, 33, 6, 5),
+(8, 33, 10, 6),
+(8, 34, 1, 1),
+(8, 34, 2, 2),
+(8, 34, 4, 3),
+(8, 34, 5, 4),
+(8, 34, 6, 5),
+(8, 34, 10, 6),
+(8, 34, 9, 7),
+(8, 121, 1, 1),
+(8, 121, 2, 2),
+(8, 121, 4, 3),
+(8, 121, 5, 4),
+(8, 121, 6, 5)");
+
+ // API array elements - Affiliblatt
+
+ // API array elements - AllAds4You
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(10, 167, 1, 1),
+(10, 167, 2, 2),
+(10, 167, 4, 3),
+(10, 167, 5, 4),
+(10, 167, 6, 5),
+(10, 168, 1, 1),
+(10, 168, 2, 2),
+(10, 168, 4, 3),
+(10, 168, 5, 4),
+(10, 168, 6, 5),
+(10, 169, 1, 1),
+(10, 169, 2, 2),
+(10, 169, 4, 3),
+(10, 169, 5, 4),
+(10, 169, 6, 5),
+(10, 170, 1, 1),
+(10, 170, 2, 2),
+(10, 170, 4, 3),
+(10, 170, 5, 4),
+(10, 170, 6, 5),
+(10, 171, 1, 1),
+(10, 171, 2, 2),
+(10, 171, 4, 3),
+(10, 171, 5, 4),
+(10, 171, 6, 5),
+(10, 172, 1, 1),
+(10, 172, 2, 2),
+(10, 172, 4, 3),
+(10, 172, 5, 4),
+(10, 172, 6, 5),
+(10, 173, 1, 1),
+(10, 173, 2, 2),
+(10, 173, 4, 3),
+(10, 173, 5, 4),
+(10, 173, 6, 5),
+(10, 174, 1, 1),
+(10, 174, 2, 2),
+(10, 174, 4, 3),
+(10, 174, 5, 4),
+(10, 174, 6, 5),
+(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, 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)");
+
+ // API array elements - Alster-Marketing
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(11, 35, 7, 1),
+(11, 35, 2, 2),
+(11, 35, 3, 3),
+(11, 35, 4, 4),
+(11, 35, 5, 5),
+(11, 35, 6, 6),
+(11, 35, 8, 7),
+(11, 35, 10, 8),
+(11, 36, 11, 1),
+(11, 36, 2, 2),
+(11, 36, 9, 3),
+(11, 36, 4, 4),
+(11, 36, 5, 5),
+(11, 36, 6, 6),
+(11, 37, 12, 1),
+(11, 37, 2, 2),
+(11, 37, 3, 3),
+(11, 37, 4, 4),
+(11, 37, 5, 5),
+(11, 37, 6, 6),
+(11, 37, 8, 7),
+(11, 38, 7, 1),
+(11, 38, 2, 2),
+(11, 38, 3, 3),
+(11, 38, 4, 4),
+(11, 38, 5, 5),
+(11, 38, 6, 6),
+(11, 38, 10, 7),
+(11, 38, 8, 8),
+(11, 39, 13, 1),
+(11, 39, 2, 2),
+(11, 39, 4, 3),
+(11, 39, 5, 4),
+(11, 39, 6, 5),
+(11, 39, 10, 6),
+(11, 39, 9, 7),
+(11, 40, 14, 1),
+(11, 40, 2, 2),
+(11, 40, 4, 3),
+(11, 40, 5, 4),
+(11, 40, 6, 5),
+(11, 41, 15, 1),
+(11, 41, 2, 2),
+(11, 41, 4, 3),
+(11, 41, 5, 4),
+(11, 41, 6, 5),
+(11, 41, 10, 6),
+(11, 42, 16, 1),
+(11, 42, 2, 2),
+(11, 42, 4, 3),
+(11, 42, 5, 4),
+(11, 42, 6, 5),
+(11, 42, 10, 6),
+(11, 43, 17, 1),
+(11, 43, 2, 2),
+(11, 43, 6, 3),
+(11, 43, 19, 4),
+(11, 43, 20, 5),
+(11, 43, 21, 6),
+(11, 43, 22, 7),
+(11, 43, 23, 8),
+(11, 43, 9, 9),
+(11, 43, 25, 10),
+(11, 43, 5, 11),
+(11, 44, 18, 1),
+(11, 44, 2, 2),
+(11, 44, 6, 3),
+(11, 44, 19, 4),
+(11, 44, 20, 5),
+(11, 44, 21, 6),
+(11, 44, 22, 7),
+(11, 44, 23, 8),
+(11, 44, 9, 9),
+(11, 44, 25, 10),
+(11, 45, 7, 1),
+(11, 45, 2, 2),
+(11, 45, 3, 3),
+(11, 45, 4, 4),
+(11, 45, 5, 5),
+(11, 45, 6, 6),
+(11, 45, 8, 7),
+(11, 45, 10, 8),
+(11, 46, 11, 1),
+(11, 46, 2, 2),
+(11, 46, 9, 3),
+(11, 46, 4, 4),
+(11, 46, 5, 5),
+(11, 46, 6, 6),
+(11, 47, 12, 1),
+(11, 47, 2, 2),
+(11, 47, 3, 3),
+(11, 47, 4, 4),
+(11, 47, 5, 5),
+(11, 47, 6, 6),
+(11, 47, 8, 7),
+(11, 48, 13, 1),
+(11, 48, 2, 2),
+(11, 48, 4, 3),
+(11, 48, 5, 4),
+(11, 48, 6, 5),
+(11, 48, 10, 6),
+(11, 48, 9, 7),
+(11, 49, 14, 1),
+(11, 49, 2, 2),
+(11, 49, 4, 3),
+(11, 49, 5, 4),
+(11, 49, 6, 5)");
+
+ // API array elements - BonusSponsor
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(12, 50, 7, 1),
+(12, 50, 2, 2),
+(12, 50, 3, 3),
+(12, 50, 4, 4),
+(12, 50, 5, 5),
+(12, 50, 6, 6),
+(12, 50, 8, 7),
+(12, 50, 10, 8),
+(12, 52, 11, 1),
+(12, 52, 2, 2),
+(12, 52, 9, 3),
+(12, 52, 4, 4),
+(12, 52, 5, 5),
+(12, 52, 6, 6),
+(12, 54, 7, 1),
+(12, 54, 2, 2),
+(12, 54, 3, 3),
+(12, 54, 4, 4),
+(12, 54, 5, 5),
+(12, 54, 6, 6),
+(12, 54, 10, 7),
+(12, 54, 8, 8),
+(12, 55, 13, 1),
+(12, 55, 2, 2),
+(12, 55, 4, 3),
+(12, 55, 5, 4),
+(12, 55, 6, 5),
+(12, 55, 10, 6),
+(12, 55, 9, 7),
+(12, 56, 13, 1),
+(12, 56, 2, 2),
+(12, 56, 4, 3),
+(12, 56, 5, 4),
+(12, 56, 6, 5),
+(12, 56, 10, 6),
+(12, 56, 9, 7),
+(12, 62, 18, 1),
+(12, 62, 2, 2),
+(12, 62, 6, 3),
+(12, 62, 19, 4),
+(12, 62, 20, 5),
+(12, 62, 21, 6),
+(12, 62, 28, 7),
+(12, 62, 29, 8),
+(12, 62, 30, 9),
+(12, 62, 31, 10),
+(12, 62, 32, 11),
+(12, 62, 33, 12),
+(12, 62, 34, 13),
+(12, 62, 22, 14),
+(12, 62, 23, 15),
+(12, 62, 24, 16),
+(12, 62, 35, 17),
+(12, 62, 36, 18),
+(12, 62, 9, 19)");
+
+ // API array elements - Fusion-Ads
+
+ // API array elements - GigaPromo
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(14, 102, 7, 1),
+(14, 102, 2, 2),
+(14, 102, 4, 3),
+(14, 102, 5, 4),
+(14, 102, 6, 5),
+(14, 103, 14, 1),
+(14, 103, 2, 2),
+(14, 103, 4, 3),
+(14, 103, 5, 4),
+(14, 103, 6, 5),
+(14, 104, 7, 1),
+(14, 104, 2, 2),
+(14, 104, 4, 3),
+(14, 104, 5, 4),
+(14, 104, 6, 5),
+(14, 104, 10, 6),
+(14, 105, 11, 1),
+(14, 105, 2, 2),
+(14, 105, 4, 3),
+(14, 105, 5, 4),
+(14, 105, 6, 5),
+(14, 105, 10, 6),
+(14, 105, 9, 7),
+(14, 106, 13, 1),
+(14, 106, 2, 2),
+(14, 106, 5, 3),
+(14, 106, 6, 4),
+(14, 106, 10, 5),
+(14, 106, 37, 6),
+(14, 106, 9, 7),
+(14, 107, 15, 1),
+(14, 107, 2, 2),
+(14, 107, 4, 3),
+(14, 107, 5, 4),
+(14, 107, 6, 5),
+(14, 107, 10, 6),
+(14, 108, 16, 1),
+(14, 108, 2, 2),
+(14, 108, 4, 3),
+(14, 108, 5, 4),
+(14, 108, 6, 5),
+(14, 108, 10, 6),
+(14, 122, 26, 1),
+(14, 122, 2, 2),
+(14, 122, 4, 3),
+(14, 122, 5, 4),
+(14, 122, 6, 5)");
+
+ // API array elements - HPSponsor
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(15, 135, 1, 1),
+(15, 135, 2, 2),
+(15, 135, 4, 3),
+(15, 135, 5, 4),
+(15, 135, 6, 5),
+(15, 135, 10, 6),
+(15, 135, 9, 7),
+(15, 135, 27, 8),
+(15, 136, 1, 1),
+(15, 136, 2, 2),
+(15, 136, 4, 3),
+(15, 136, 5, 4),
+(15, 136, 6, 5),
+(15, 136, 10, 6),
+(15, 136, 9, 7),
+(15, 136, 27, 8),
+(15, 137, 1, 1),
+(15, 137, 2, 2),
+(15, 137, 4, 3),
+(15, 137, 5, 4),
+(15, 137, 6, 5),
+(15, 137, 10, 6),
+(15, 137, 9, 7),
+(15, 137, 27, 8),
+(15, 138, 1, 1),
+(15, 138, 2, 2),
+(15, 138, 4, 3),
+(15, 138, 5, 4),
+(15, 138, 6, 5),
+(15, 138, 10, 6),
+(15, 138, 9, 7),
+(15, 138, 27, 8),
+(15, 139, 1, 1),
+(15, 139, 2, 2),
+(15, 139, 4, 3),
+(15, 139, 5, 4),
+(15, 139, 6, 5),
+(15, 139, 10, 6),
+(15, 139, 9, 7),
+(15, 139, 27, 8),
+(15, 140, 1, 1),
+(15, 140, 2, 2),
+(15, 140, 4, 3),
+(15, 140, 5, 4),
+(15, 140, 6, 5),
+(15, 140, 10, 6),
+(15, 140, 9, 7),
+(15, 140, 27, 8),
+(15, 141, 1, 1),
+(15, 141, 2, 2),
+(15, 141, 4, 3),
+(15, 141, 5, 4),
+(15, 141, 6, 5),
+(15, 141, 10, 6),
+(15, 141, 9, 7),
+(15, 141, 27, 8),
+(15, 142, 1, 1),
+(15, 142, 2, 2),
+(15, 142, 4, 3),
+(15, 142, 5, 4),
+(15, 142, 6, 5),
+(15, 142, 10, 6),
+(15, 142, 9, 7),
+(15, 142, 27, 8),
+(15, 143, 1, 1),
+(15, 143, 2, 2),
+(15, 143, 4, 3),
+(15, 143, 5, 4),
+(15, 143, 6, 5),
+(15, 143, 10, 6),
+(15, 143, 9, 7),
+(15, 143, 27, 8),
+(15, 144, 1, 1),
+(15, 144, 2, 2),
+(15, 144, 4, 3),
+(15, 144, 5, 4),
+(15, 144, 6, 5),
+(15, 144, 10, 6),
+(15, 144, 9, 7),
+(15, 144, 27, 8)");
+
+ // API array elements - Make-Euros.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(16, 63, 7, 1),
+(16, 63, 2, 2),
+(16, 63, 3, 3),
+(16, 63, 4, 4),
+(16, 63, 5, 5),
+(16, 63, 6, 6),
+(16, 63, 8, 7),
+(16, 63, 10, 8),
+(16, 64, 7, 1),
+(16, 64, 2, 2),
+(16, 64, 3, 3),
+(16, 64, 4, 4),
+(16, 64, 5, 5),
+(16, 64, 6, 6),
+(16, 64, 8, 7),
+(16, 64, 10, 8),
+(16, 65, 11, 1),
+(16, 65, 2, 2),
+(16, 65, 9, 3),
+(16, 65, 4, 4),
+(16, 65, 5, 5),
+(16, 65, 6, 6),
+(16, 66, 11, 1),
+(16, 66, 2, 2),
+(16, 66, 9, 3),
+(16, 66, 4, 4),
+(16, 66, 5, 5),
+(16, 66, 6, 6),
+(16, 67, 12, 1),
+(16, 67, 2, 2),
+(16, 67, 3, 3),
+(16, 67, 4, 4),
+(16, 67, 5, 5),
+(16, 67, 6, 6),
+(16, 67, 8, 7),
+(16, 68, 7, 1),
+(16, 68, 2, 2),
+(16, 68, 3, 3),
+(16, 68, 4, 4),
+(16, 68, 5, 5),
+(16, 68, 6, 6),
+(16, 68, 10, 7),
+(16, 68, 8, 8),
+(16, 69, 12, 1),
+(16, 69, 2, 2),
+(16, 69, 3, 3),
+(16, 69, 4, 4),
+(16, 69, 5, 5),
+(16, 69, 6, 6),
+(16, 69, 8, 7),
+(16, 70, 13, 1),
+(16, 70, 2, 2),
+(16, 70, 4, 3),
+(16, 70, 5, 4),
+(16, 70, 6, 5),
+(16, 70, 10, 6),
+(16, 70, 9, 7),
+(16, 71, 13, 1),
+(16, 71, 2, 2),
+(16, 71, 4, 3),
+(16, 71, 5, 4),
+(16, 71, 6, 5),
+(16, 71, 10, 6),
+(16, 71, 9, 7),
+(16, 72, 14, 1),
+(16, 72, 2, 2),
+(16, 72, 4, 3),
+(16, 72, 5, 4),
+(16, 72, 6, 5),
+(16, 73, 14, 1),
+(16, 73, 2, 2),
+(16, 73, 4, 3),
+(16, 73, 5, 4),
+(16, 73, 6, 5),
+(16, 74, 15, 1),
+(16, 74, 2, 2),
+(16, 74, 4, 3),
+(16, 74, 5, 4),
+(16, 74, 6, 5),
+(16, 74, 10, 6),
+(16, 75, 16, 1),
+(16, 75, 2, 2),
+(16, 75, 4, 3),
+(16, 75, 5, 4),
+(16, 75, 6, 5),
+(16, 75, 10, 6),
+(16, 76, 17, 1),
+(16, 76, 2, 2),
+(16, 76, 6, 3),
+(16, 76, 19, 4),
+(16, 76, 20, 5),
+(16, 76, 21, 6),
+(16, 76, 22, 7),
+(16, 76, 23, 8),
+(16, 76, 9, 9)");
+
+ // API array elements - Mega-Ad
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(17, 109, 1, 1),
+(17, 109, 2, 2),
+(17, 109, 4, 3),
+(17, 109, 5, 4),
+(17, 109, 6, 5),
+(17, 110, 1, 1),
+(17, 110, 2, 2),
+(17, 110, 4, 3),
+(17, 110, 5, 4),
+(17, 110, 6, 5),
+(17, 111, 1, 1),
+(17, 111, 2, 2),
+(17, 111, 4, 3),
+(17, 111, 5, 4),
+(17, 111, 6, 5),
+(17, 112, 1, 1),
+(17, 112, 2, 2),
+(17, 112, 4, 3),
+(17, 112, 5, 4),
+(17, 112, 6, 5),
+(17, 113, 1, 1),
+(17, 113, 2, 2),
+(17, 113, 4, 3),
+(17, 113, 5, 4),
+(17, 113, 6, 5),
+(17, 114, 1, 1),
+(17, 114, 2, 2),
+(17, 114, 4, 3),
+(17, 114, 5, 4),
+(17, 114, 6, 5),
+(17, 115, 1, 1),
+(17, 115, 2, 2),
+(17, 115, 4, 3),
+(17, 115, 5, 4),
+(17, 115, 6, 5),
+(17, 116, 1, 1),
+(17, 116, 2, 2),
+(17, 116, 4, 3),
+(17, 116, 5, 4),
+(17, 116, 6, 5),
+(17, 116, 10, 6),
+(17, 117, 1, 1),
+(17, 117, 2, 2),
+(17, 117, 4, 3),
+(17, 117, 5, 4),
+(17, 117, 6, 5),
+(17, 117, 10, 6),
+(17, 117, 9, 7),
+(17, 123, 1, 1),
+(17, 123, 2, 2),
+(17, 123, 4, 3),
+(17, 123, 5, 4),
+(17, 123, 6, 5)");
+
+ // API array elements - Power-Promo
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(18, 78, 7, 1),
+(18, 78, 2, 2),
+(18, 78, 3, 3),
+(18, 78, 4, 4),
+(18, 78, 5, 5),
+(18, 78, 6, 6),
+(18, 78, 8, 7),
+(18, 78, 10, 8),
+(18, 79, 7, 1),
+(18, 79, 2, 2),
+(18, 79, 3, 3),
+(18, 79, 4, 4),
+(18, 79, 5, 5),
+(18, 79, 6, 6),
+(18, 79, 8, 7),
+(18, 79, 10, 8),
+(18, 80, 11, 1),
+(18, 80, 2, 2),
+(18, 80, 9, 3),
+(18, 80, 4, 4),
+(18, 80, 5, 5),
+(18, 80, 6, 6),
+(18, 81, 11, 1),
+(18, 81, 2, 2),
+(18, 81, 9, 3),
+(18, 81, 4, 4),
+(18, 81, 5, 5),
+(18, 81, 6, 6),
+(18, 82, 12, 1),
+(18, 82, 2, 2),
+(18, 82, 3, 3),
+(18, 82, 4, 4),
+(18, 82, 5, 5),
+(18, 82, 6, 6),
+(18, 82, 8, 7),
+(18, 83, 12, 1),
+(18, 83, 2, 2),
+(18, 83, 3, 3),
+(18, 83, 4, 4),
+(18, 83, 5, 5),
+(18, 83, 6, 6),
+(18, 83, 8, 7),
+(18, 84, 7, 1),
+(18, 84, 2, 2),
+(18, 84, 3, 3),
+(18, 84, 4, 4),
+(18, 84, 5, 5),
+(18, 84, 6, 6),
+(18, 84, 10, 7),
+(18, 84, 8, 8),
+(18, 85, 13, 1),
+(18, 85, 2, 2),
+(18, 85, 4, 3),
+(18, 85, 5, 4),
+(18, 85, 6, 5),
+(18, 85, 10, 6),
+(18, 85, 9, 7),
+(18, 86, 13, 1),
+(18, 86, 2, 2),
+(18, 86, 4, 3),
+(18, 86, 5, 4),
+(18, 86, 6, 5),
+(18, 86, 10, 6),
+(18, 86, 9, 7),
+(18, 87, 14, 1),
+(18, 87, 2, 2),
+(18, 87, 4, 3),
+(18, 87, 5, 4),
+(18, 87, 6, 5),
+(18, 88, 14, 1),
+(18, 88, 2, 2),
+(18, 88, 4, 3),
+(18, 88, 5, 4),
+(18, 88, 6, 5),
+(18, 89, 15, 1),
+(18, 89, 2, 2),
+(18, 89, 4, 3),
+(18, 89, 5, 4),
+(18, 89, 6, 5),
+(18, 89, 10, 6),
+(18, 90, 16, 1),
+(18, 90, 2, 2),
+(18, 90, 4, 3),
+(18, 90, 5, 4),
+(18, 90, 6, 5),
+(18, 90, 10, 6),
+(18, 91, 17, 1),
+(18, 91, 2, 2),
+(18, 91, 6, 3),
+(18, 91, 19, 4),
+(18, 91, 20, 5),
+(18, 91, 21, 6),
+(18, 91, 22, 7),
+(18, 91, 23, 8),
+(18, 91, 9, 9),
+(18, 91, 25, 10),
+(18, 91, 5, 11),
+(18, 92, 18, 1),
+(18, 92, 2, 2),
+(18, 92, 6, 3),
+(18, 92, 19, 4),
+(18, 92, 20, 5),
+(18, 92, 21, 6),
+(18, 92, 22, 7),
+(18, 92, 23, 8),
+(18, 92, 9, 9),
+(18, 92, 25, 10)");
+
+ // API array elements - SeCash
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(19, 93, 1, 1),
+(19, 93, 2, 2),
+(19, 93, 4, 3),
+(19, 93, 5, 4),
+(19, 93, 6, 5),
+(19, 94, 1, 1),
+(19, 94, 2, 2),
+(19, 94, 4, 3),
+(19, 94, 5, 4),
+(19, 94, 6, 5),
+(19, 95, 1, 1),
+(19, 95, 2, 2),
+(19, 95, 4, 3),
+(19, 95, 5, 4),
+(19, 95, 6, 5),
+(19, 96, 1, 1),
+(19, 96, 2, 2),
+(19, 96, 4, 3),
+(19, 96, 5, 4),
+(19, 96, 6, 5),
+(19, 97, 1, 1),
+(19, 97, 2, 2),
+(19, 97, 4, 3),
+(19, 97, 5, 4),
+(19, 97, 6, 5),
+(19, 98, 1, 1),
+(19, 98, 2, 2),
+(19, 98, 4, 3),
+(19, 98, 5, 4),
+(19, 98, 6, 5),
+(19, 99, 1, 1),
+(19, 99, 2, 2),
+(19, 99, 4, 3),
+(19, 99, 5, 4),
+(19, 99, 6, 5),
+(19, 100, 1, 1),
+(19, 100, 2, 2),
+(19, 100, 4, 3),
+(19, 100, 5, 4),
+(19, 100, 6, 5),
+(19, 100, 10, 6),
+(19, 101, 1, 1),
+(19, 101, 2, 2),
+(19, 101, 4, 3),
+(19, 101, 5, 4),
+(19, 101, 6, 5),
+(19, 101, 10, 6),
+(19, 101, 9, 7),
+(19, 124, 1, 1),
+(19, 124, 2, 2),
+(19, 124, 4, 3),
+(19, 124, 5, 4),
+(19, 124, 6, 5)");
+
+ // API array elements - The Swizerland Ad Network
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(20, 200, 6, 5),
+(20, 202, 1, 1),
+(20, 202, 2, 2),
+(20, 202, 4, 3),
+(20, 202, 5, 4),
+(20, 202, 6, 5),
+(20, 202, 10, 6),
+(20, 202, 9, 7),
+(20, 202, 27, 8),
+(20, 203, 1, 1),
+(20, 203, 2, 2),
+(20, 203, 4, 3),
+(20, 203, 5, 4),
+(20, 203, 6, 5),
+(20, 203, 10, 6),
+(20, 203, 9, 7),
+(20, 203, 27, 8),
+(20, 204, 1, 1),
+(20, 204, 2, 2),
+(20, 204, 4, 3),
+(20, 204, 5, 4),
+(20, 204, 6, 5),
+(20, 204, 10, 6),
+(20, 204, 9, 7),
+(20, 204, 27, 8),
+(20, 205, 1, 1),
+(20, 205, 2, 2),
+(20, 205, 4, 3),
+(20, 205, 5, 4),
+(20, 205, 6, 5),
+(20, 205, 10, 6),
+(20, 205, 9, 7),
+(20, 205, 27, 8),
+(20, 206, 1, 1),
+(20, 206, 2, 2),
+(20, 206, 4, 3),
+(20, 206, 5, 4),
+(20, 206, 10, 6),
+(20, 206, 9, 7),
+(20, 206, 27, 8),
+(20, 207, 1, 1),
+(20, 207, 2, 2),
+(20, 207, 4, 3),
+(20, 207, 5, 4),
+(20, 207, 6, 5),
+(20, 207, 10, 6),
+(20, 207, 9, 7),
+(20, 207, 27, 8),
+(20, 208, 1, 1),
+(20, 208, 2, 2),
+(20, 208, 4, 3),
+(20, 208, 5, 4),
+(20, 208, 6, 5),
+(20, 208, 10, 6),
+(20, 208, 9, 7),
+(20, 208, 27, 8),
+(20, 209, 1, 1),
+(20, 209, 2, 2),
+(20, 209, 4, 3),
+(20, 209, 5, 4),
+(20, 209, 6, 5),
+(20, 209, 10, 6),
+(20, 209, 9, 7),
+(20, 209, 27, 8),
+(20, 210, 1, 1),
+(20, 210, 2, 2),
+(20, 210, 4, 3),
+(20, 210, 5, 4),
+(20, 210, 6, 5),
+(20, 210, 10, 6),
+(20, 210, 9, 7),
+(20, 210, 27, 8),
+(20, 211, 1, 1),
+(20, 211, 2, 2),
+(20, 211, 4, 3),
+(20, 211, 5, 4),
+(20, 211, 6, 5),
+(20, 211, 10, 6),
+(20, 211, 9, 7),
+(20, 211, 27, 8)");
+
+ // API array elements - UltraPOMO
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(21, 125, 1, 1),
+(21, 125, 2, 2),
+(21, 125, 4, 3),
+(21, 125, 5, 4),
+(21, 125, 6, 5),
+(21, 126, 1, 1),
+(21, 126, 2, 2),
+(21, 126, 4, 3),
+(21, 126, 5, 4),
+(21, 126, 6, 5),
+(21, 127, 1, 1),
+(21, 127, 2, 2),
+(21, 127, 4, 3),
+(21, 127, 5, 4),
+(21, 127, 6, 5),
+(21, 128, 1, 1),
+(21, 128, 2, 2),
+(21, 128, 4, 3),
+(21, 128, 5, 4),
+(21, 128, 6, 5),
+(21, 129, 1, 1),
+(21, 129, 2, 2),
+(21, 129, 4, 3),
+(21, 129, 5, 4),
+(21, 129, 6, 5),
+(21, 130, 1, 1),
+(21, 130, 2, 2),
+(21, 130, 4, 3),
+(21, 130, 5, 4),
+(21, 130, 6, 5),
+(21, 130, 10, 6),
+(21, 131, 1, 1),
+(21, 131, 2, 2),
+(21, 131, 4, 3),
+(21, 131, 5, 4),
+(21, 131, 6, 5),
+(21, 132, 1, 1),
+(21, 132, 2, 2),
+(21, 132, 4, 3),
+(21, 132, 5, 4),
+(21, 132, 6, 5),
+(21, 133, 1, 1),
+(21, 133, 2, 2),
+(21, 133, 4, 3),
+(21, 133, 5, 4),
+(21, 133, 6, 5),
+(21, 133, 10, 6),
+(21, 133, 9, 7),
+(21, 134, 1, 1),
+(21, 134, 2, 2),
+(21, 134, 4, 3),
+(21, 134, 5, 4),
+(21, 134, 6, 5)");
+
+ // API array elements - Der Werbepartner.cc
+
+ // API array elements - Yoo!Media
// Admin menu entries
addAdminMenuSql('network',NULL,'Werbenetzwerke','Verwalten Sie hier Werbenetzwerke (API-Anbindung), versenden Sie deren Mails, oder übernehmen Sie deren Textlinks und vieles mehr. <strong>VORSICHT:</strong> Das Einrichten von weiteren Werbenetzwerken ist nicht leicht, dafür aber sehr flexibel! Sollte ein Netzwerk fehlen, so melden Sie dies bitte <a href="http://forum.mxchange.org/topic-462.html" target="_blank" title="Direktlink zum Forum">im Forum</a>!',4);
addAdminMenuSql('network','list_networks','Auflisten/Verwalten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',6);
addAdminMenuSql('network','list_network_types','Werbearten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',7);
addAdminMenuSql('network','list_network_params','Abfrageparameter','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Abfrageparameter (wie sie genannt werden müssen, um das API-Script korrekt aufrufen zu können) ein, pro Werbenetzwerk. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',8);
- addAdminMenuSql('network','list_network_translations','Array-Übersetzungen','<strong>Experten-Einstellungen!</strong> Hier richten Sie Array-Index-Übersetzungen für nicht-fehler API-Antworten ein. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',9);
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);
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_codes`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_types`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_api_translation`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`');
projects / mailer.git / blobdiff