X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-network.php;h=dadd2ba4a14cc2321326ecc4b34ebca88c462ac4;hb=cf21adc519ee7bcbaf50bffa18b5fabcf857ce41;hp=109c4aa421fd286d092f98061f0ad213051fd063;hpb=6bb119cb426a2ab3998a5c3dfe250d748f786a1c;p=mailer.git diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php index 109c4aa421..dadd2ba4a1 100644 --- a/inc/extensions/ext-network.php +++ b/inc/extensions/ext-network.php @@ -21,8 +21,9 @@ * @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? * @@ -140,11 +141,10 @@ PRIMARY KEY (`network_code_id`) // 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 @@ -154,9 +154,9 @@ PRIMARY KEY (`network_translate_id`) `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!'"); @@ -210,30 +210,63 @@ PRIMARY KEY (`network_cache_id`) `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 @@ -251,7 +284,7 @@ PRIMARY KEY (`network_reload_id`) ('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'), @@ -322,16 +355,16 @@ PRIMARY KEY (`network_reload_id`) // 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 @@ -410,16 +443,16 @@ PRIMARY KEY (`network_reload_id`) // 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 @@ -485,16 +518,16 @@ PRIMARY KEY (`network_reload_id`) // 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 @@ -2025,9 +2058,1245 @@ PRIMARY KEY (`network_reload_id`) (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. VORSICHT: Das Einrichten von weiteren Werbenetzwerken ist nicht leicht, dafür aber sehr flexibel! Sollte ein Netzwerk fehlen, so melden Sie dies bitte im Forum!',4); @@ -2039,7 +3308,6 @@ PRIMARY KEY (`network_reload_id`) addAdminMenuSql('network','list_networks','Auflisten/Verwalten','Experten-Einstellungen! Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',6); addAdminMenuSql('network','list_network_types','Werbearten','Experten-Einstellungen! Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',7); addAdminMenuSql('network','list_network_params','Abfrageparameter','Experten-Einstellungen! 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 im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',8); - addAdminMenuSql('network','list_network_translations','Array-Übersetzungen','Experten-Einstellungen! Hier richten Sie Array-Index-Übersetzungen für nicht-fehler API-Antworten ein. Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',9); addAdminMenuSql('network','list_network_api_translation','Antwort-Array','Experten-Einstellungen! Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',10); addAdminMenuSql('network','list_network_error_codes','Fehlercodes','Experten-Einstellungen! Hier stellen Sie die Fehlercodes ein, die im Falle eines Fehlers pro API-Script kommen können. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',11); addAdminMenuSql('network','list_network_error_types','Fehlertypen','Experten-Einstellungen! Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden. Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',12); @@ -2055,7 +3323,6 @@ PRIMARY KEY (`network_reload_id`) 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`');