X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-network.php;h=98be8b9603c3e7ba337df6581c6f2ed356c3d2be;hb=5261b522112c11417fc87bb0b14ca078bfa398e3;hp=e91a4d81801bbaf1a21e95d310a8429235c32417;hpb=6fb430742ddee565da608c2eb152fcd6ae160c45;p=mailer.git diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php index e91a4d8180..98be8b9603 100644 --- a/inc/extensions/ext-network.php +++ b/inc/extensions/ext-network.php @@ -14,8 +14,6 @@ * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * * $Author:: $ * - * Needs to be in all Files and every File needs "svn propset * - * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * @TODO AbisZED: Which charset? * * @TODO Ad-Magnet: Layer(klick?). Layerviews.Skybannerklick/-view, * @@ -24,11 +22,13 @@ * @TODO ADCocktail: Zero array element is return code! * * @TODO Affiliblatt: All except banner, do they really have UTF-8? * * @TODO AllAds4You: Traffic from abroad, High-Forced banner * - * @TODO Fusion-Ads: Has click/banner URL in API response, really UTF-8 * + * @TODO FuCoExSponsor: No High-Forced banner, HTML is BASE64 encoded * + * @TODO FuCoExSponsor: Textlink-View is JavaScript! * + * @TODO Fusion-Ads: Has click/banner URL in API response * + * @TODO GeldSponsor.de Requires ID card copy/business reg. * * @TODO GolloX: Which charset? * - * @TODO homeADS: Which charset? * * @TODO paid4ad: Which URLs for click and banner? * - * @TODO VIPads: Which charset? * + * @TODO VIPads: HTML text is send encoded with BASE64 * * @TODO Der Werbepartner.cc: Banner click/view is JavaScript! * * @TODO Der Werbepartner.cc: Forced textlink not correct * * @TODO Der Werbepartner.cc: Layer not correct * @@ -38,7 +38,7 @@ * @TODO Yoo!Media: What is LayerAd compared to Layer click? * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -74,7 +74,7 @@ enableExtensionProductive(false); switch (getExtensionMode()) { case 'register': // Do stuff when installation is running (modules.php?module=admin is called) // Main table which hold - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_data`'); + addDropTableSql('network_data'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_data` ( `network_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_short_name` VARCHAR(50) NOT NULL DEFAULT '', @@ -84,13 +84,14 @@ switch (getExtensionMode()) { `network_row_seperator` CHAR(4) NOT NULL DEFAULT '|', `network_request_type` ENUM('GET','POST') NOT NULL DEFAULT 'GET', `network_charset` VARCHAR(20) NOT NULL DEFAULT 'UTF-8', +`network_require_id_card` ENUM('Y','N') NOT NULL DEFAULT 'N', UNIQUE (`network_short_name`), PRIMARY KEY (`network_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Network data'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Network data'"); // Types the network provider is supporting (e.g. Forced-Banner and so on) // @TODO network_type_handle is an internal name and needs documentation - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types`'); + addDropTableSql('network_types'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types` ( `network_type_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -100,10 +101,10 @@ PRIMARY KEY (`network_id`) `network_type_banner_url` VARCHAR(255) NULL DEFAULT NULL, UNIQUE `provider_type` (`network_id`,`network_type_handle`), PRIMARY KEY (`network_type_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Types provideable by networks'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Types provideable by networks'"); // HTTP parameters (names) for URLs - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`'); + addDropTableSql('network_request_params'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_request_params` ( `network_param_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -114,10 +115,10 @@ PRIMARY KEY (`network_type_id`) UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`), UNIQUE `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`), PRIMARY KEY (`network_param_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Request parameters for GET/POST request'"); // Error status codes - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_codes`'); + addDropTableSql('network_error_codes'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_codes` ( `network_type_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -126,28 +127,28 @@ PRIMARY KEY (`network_param_id`) UNIQUE `code_type` (`network_type_code_value`,`network_type_id`), INDEX (`network_type_id`), PRIMARY KEY (`network_type_code_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Error codes for all types'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Error codes for all types'"); // Code types (internal table) - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_types`'); + addDropTableSql('network_error_types'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_types` ( `network_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_code` VARCHAR(100) NOT NULL DEFAULT 'INVALID_CODE', UNIQUE (`network_code`), PRIMARY KEY (`network_code_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Error types, generic data, DO NOT ALTER!'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Error types, generic data, DO NOT ALTER!'"); // Valid translation keys (we hate hard-coded arrays, you see?) - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`'); + addDropTableSql('network_translations'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` ( `network_translation_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_translation_name` VARCHAR(100) NOT NULL DEFAULT '', UNIQUE (`network_translation_name`), PRIMARY KEY (`network_translation_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Translations for array keys, generic data, DO NOT ALTER!'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Translations for array keys, generic data, DO NOT ALTER!'"); // Array-Element translation tables per type/provider - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_api_translation`'); + addDropTableSql('network_api_translation'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_api_translation` ( `network_api_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -157,10 +158,10 @@ PRIMARY KEY (`network_translation_id`) UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`), INDEX (`sort`), PRIMARY KEY (`network_api_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Translation of API responses, generic data, DO NOT ALTER!'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Translation of API responses, generic data, DO NOT ALTER!'"); // Data from the webmaster (you!) - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`'); + addDropTableSql('network_config'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_config` ( `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -171,10 +172,10 @@ PRIMARY KEY (`network_api_id`) UNIQUE `network_affiliate` (`network_id`,`network_affiliate_id`), UNIQUE `affiliate_site` (`network_affiliate_id`,`network_site_id`), PRIMARY KEY (`network_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Configuration data from the webmaster (you!)'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Configuration data from the webmaster (you!)'"); // Configuration data for e.g. reload-time - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`'); + addDropTableSql('network_types_config'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types_config` ( `network_data_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -186,24 +187,24 @@ PRIMARY KEY (`network_id`) `allow_erotic` VARCHAR(10) NOT NULL DEFAULT '', UNIQUE `provider_type` (`network_id`,`network_type_id`), PRIMARY KEY (`network_data_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Configuration data for every type (e.g. reload-time)'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Configuration data for every type (e.g. reload-time)'"); // Cache for queried APIs. Re-check depends on config // `network_cache_refresh` in seconds or if set to zero, full day // divided by query amount. - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_cache`'); + addDropTableSql('network_cache'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_cache` ( `network_cache_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_cache_data` MEDIUMBLOB, -`network_cache_timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00', +`network_cache_timestamp` TIMESTAMP NULL DEFAULT NULL, UNIQUE `provider_type` (`network_id`,`network_type_id`), PRIMARY KEY (`network_cache_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Cache for all queried APIs'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci COMMENT = 'Cache for all queried APIs'"); // Reload locks for several types - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_reloads`'); + addDropTableSql('network_reloads'); addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_reloads` ( `network_reload_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -212,91 +213,94 @@ PRIMARY KEY (`network_cache_id`) `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'"); +) ENGINE = {?_TABLE_TYPE?} CHARACTER SET utf8 COLLATE utf8_general_ci 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'), -(38, 'click_url'), -(39, 'media_url')"); + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_translations` (`network_translation_name`) VALUES +('id'), +('name'), +('alternate_text'), +('reload'), +('remain'), +('reward'), +('banner_id'), +('size'), +('text'), +('minimum_stay'), +('textlink_id'), +('surfbar_id'), +('mail_id'), +('layer_id'), +('popup_id'), +('popdown_id'), +('lead_id'), +('sale_id'), +('banner_url1'), +('banner_url2'), +('banner_url3'), +('textlink1'), +('textlink2'), +('textlink3'), +('description'), +('traffic_id'), +('country_code'), +('banner_url4'), +('banner_url5'), +('banner_url6'), +('banner_url7'), +('banner_url8'), +('banner_url9'), +('banner_url10'), +('textlink4'), +('textlink5'), +('subject'), +('click_url'), +('media_url')"); // Insert error code types - // - Affiliate id or interface password wrong - addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code_id`, `network_code`) VALUES -(1, 'AFF_ID_PASS_WRONG'), -(2, 'SITE_ID_NOT_ASSIGNED'), -(3, 'SITE_ID_LOCKED'), -(4, 'INTERFACE_DATA_ERROR'), -(5, 'REQUESTS_DEPLETED'), -(6, 'NO_CAMPAIGNS_FOUND'), -(7, 'NO_CAMPAIGNS_FOUND_INTERFACE'), -(8, 'SITE_ID_NOT_ALLOWED_TYPE'), -(9, 'REQUEST_PARAMETER_INCOMPLETE')"); + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES +('AFF_ID_PASS_WRONG'), +('SITE_ID_NOT_ASSIGNED'), +('SITE_ID_LOCKED'), +('INTERFACE_DATA_ERROR'), +('REQUESTS_DEPLETED'), +('NO_CAMPAIGNS_FOUND'), +('NO_CAMPAIGNS_FOUND_INTERFACE'), +('SITE_ID_NOT_ALLOWED_TYPE'), +('REQUEST_PARAMETER_INCOMPLETE')"); // Sponsor networks - addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`) VALUES -('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252'), -('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252'), -('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1'), -('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252'), -('adpaid', 'AdPaid', 'http://www.adpaid.de?ref=1464', '|', '|', 'GET', 'ISO-8859-1'), -('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252'), -('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252'), -('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252'), -('affiliblatt', 'Affiliblatt', 'http://www.Affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8'), -('allads4you', 'AllAds4You', 'http://www.allads4you.de?ref=1146', '|', '|', 'GET', 'ISO-8859-1'), -('alster', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16'), -('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252'), -('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'UTF-8'), -('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252'), -('hpsonsor', 'HPSponsor', 'http://hpsponsor.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'), -('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252'), -('swizerland', 'The-Swizerland-Ad-Network', 'http://www.the-switzerland-ad-network.ch?ref=3', '|', '|', 'GET', 'WINDOWS-1252'), -('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252'), -('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252'), -('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252'), -('cityads', 'City-Ads', 'http://www.city-ads.de?ref=221', '|', '|', 'GET', 'WINDOWS-1252'), -('goldsponsor', 'Gold-Sponsor', 'http://www.gold-sponsor.de?ref=42', '|', '|', 'GET', 'WINDOWS-1252'), -('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1')"); + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`,`network_require_id_card`) VALUES +('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252','N'), +('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252','Y'), +('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1','N'), +('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252','N'), +('adpaid', 'AdPaid', 'http://www.adpaid.de?ref=1464', '|', '|', 'GET', 'ISO-8859-1','N'), +('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252','N'), +('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252','N'), +('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252','N'), +('affiliblatt', 'Affiliblatt', 'http://www.Affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8','N'), +('allads4you', 'AllAds4You', 'http://www.allads4you.de?ref=1146', '|', '|', 'GET', 'ISO-8859-1','N'), +('alster', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16','N'), +('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252','N'), +('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'ISO-8859-1','N'), +('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252','N'), +('hpsonsor', 'HPSponsor', 'http://hpsponsor.at?ref=29', '|', '|', 'GET', 'WINDOWS-1252','N'), +('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1','N'), +('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252','N'), +('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252','N'), +('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252','N'), +('swizerland', 'The-Swizerland-Ad-Network', 'http://www.the-switzerland-ad-network.ch?ref=3', '|', '|', 'GET', 'WINDOWS-1252','N'), +('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252','N'), +('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252','N'), +('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252','N'), +('cityads', 'City-Ads', 'http://www.city-ads.de?ref=221', '|', '|', 'GET', 'WINDOWS-1252','N'), +('goldsponsor', 'Gold-Sponsor', 'http://www.gold-sponsor.de?ref=42', '|', '|', 'GET', 'WINDOWS-1252','N'), +('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1','Y'), +('vipads', 'VIPads.de', 'http://vipads.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1','N'), +('homeads', 'homeADS', 'http://www.homeads.de/?ref=1540', '|', '|', 'GET', 'WINDOWS-1252','N'), +('fucoexsponsor', 'FuCoExSponsor.net', 'http://fucoexsponsor.net/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1','N'), +('adconvention', 'AdConvention', 'http://www.adconvention.de?ref=233', '|', '|', 'GET', 'WINDOWS-1252','N')"); // Network type handlers - A3H addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES @@ -337,6 +341,19 @@ PRIMARY KEY (`network_reload_id`) (13, 4, 'forcedbanner', 'http://www.adcocktail.com/sc/kas/kas_fk.php', 'http://fk.adcocktail.com/fk_k.php?uid=%UID%&wid=%CID%&wsid=%SID%', 'http://fk.adcocktail.com/fk_v.php?uid=%UID%&wid=%CID%&wsid=%SID%'), (12, 4, 'textmail', 'http://www.adcocktail.com/sc/kas/kas_pm.php', 'http://pm.adcocktail.com/pm.php?uid=%UID%&wid=%CID%&wsid=%SID%', NULL)"); + // Network type handlers - AdConvention + 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 +(295, 30, 'banner_click', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adconvention.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'), +(294, 30, 'banner_view', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%CID%', 'http://www.adconvention.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(297, 30, 'button_view', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adconvention.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(292, 30, 'forcedbanner', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adconvention.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(293, 30, 'forcedtextlink', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SI%', NULL), +(300, 30, 'popup', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(296, 30, 'skybanner_view', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adconvention.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(298, 30, 'textlink_view', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(301, 30, 'textmail', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(299, 30, 'traffic', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)"); + // Network type handlers - AdPaid addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES (177, 5, 'banner', 'http://www.adpaid.de/interface/out_banner.php', 'http://www.adpaid.de/bannerklf.php?id=%CID%', 'http://www.adpaid.de/banner.php?id=%CID%'), @@ -446,8 +463,47 @@ PRIMARY KEY (`network_reload_id`) (219, 24, 'traffic', 'http://www.city-ads.de/interface/api_2.php', 'http://www.city-ads.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', NULL)"); // Network type handlers - doubleads + 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 +(232, 26, 'banner_click', 'http://www.doubleads.de/interface/out_banner.php', 'http://www.doubleads.de/bannerklf.php?id=%CID%', 'http://www.doubleads.de/banner.php?id=%CID%'), +(233, 26, 'banner_view', 'http://www.doubleads.de/interface/out_banner.php', 'http://www.doubleads.de/bannerklf.php?id=%CID%', 'http://www.doubleads.de/banner.php?id=%CID%'), +(234, 26, 'textlink_click', 'http://www.doubleads.de/interface/out_textlink.php', 'http://www.doubleads.de/textlinkklick.php?id=%CID%', NULL), +(235, 26, 'textlink_view', 'http://www.doubleads.de/interface/out_textlink.php', 'http://www.doubleads.de/textlinkklick.php?id=%CID%', NULL), +(236, 26, 'surfbar_click', 'http://www.doubleads.de/interface/out_sbanner.php', 'http://www.doubleads.de/bannerklf.php?id=%CID%', 'http://www.doubleads.de/banner.php?id=%CID%'), +(237, 26, 'surfbar_view', 'http://www.doubleads.de/interface/out_sbanner.php', 'http://www.doubleads.de/bannerklf.php?id=%CID%', 'http://www.doubleads.de/banner.php?id=%CID%'), +(238, 26, 'forcedbanner', 'http://www.doubleads.de/interface/out_fbanner.php', 'http://www.doubleads.de/bannerklf.php?id=%CID%', 'http://www.doubleads.de/banner.php?id=%CID%'), +(239, 26, 'textmail', 'http://www.doubleads.de/interface/out_paidmail.php', 'http://www.doubleads.de/emailf.php?id=%CID%', NULL), +(240, 26, 'htmlmail', 'http://www.doubleads.de/interface/out_paidmail.php', 'http://www.doubleads.de/emailf.php?id=%CID%', NULL), +(241, 26, 'layer_click', 'http://www.doubleads.de/interface/out_layer.php', 'http://www.doubleads.de/layer.php?id=%CID%', NULL), +(242, 26, 'layer_view', 'http://www.doubleads.de/interface/out_layer.php', 'http://www.doubleads.de/layer.php?id=%CID%', NULL), +(243, 26, 'popup', 'http://www.doubleads.de/interface/out_popup.php', 'http://www.doubleads.de/popup.php?id=%CID%', NULL), +(244, 26, 'popdown', 'http://www.doubleads.de/interface/out_popdown.php', 'http://www.doubleads.de/popdown.php?id=%CID%', NULL), +(245, 26, 'lead', 'http://www.doubleads.de/interface/out_lead.php', 'http://www.doubleads.de/lead.php?id=%CID%', NULL), +(246, 26, 'sale', 'http://www.doubleads.de/interface/out_sale.php', 'http://www.doubleads.de/sale.php?id=%CID%', NULL)"); + + // Network type handlers - FuCoExSponsor.net + 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 +(273, 29, 'banner_click', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(274, 29, 'banner_view', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(275, 29, 'button_click', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(276, 29, 'button_view', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(277, 29, 'forcedbanner', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(278, 29, 'forcedtextlink', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(279, 29, 'htmlmail', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(280, 29, 'layer', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/sc_layer.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(282, 29, 'popup', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/sc_popup.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(283, 29, 'skybanner_click', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(284, 29, 'skybanner_view', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(285, 29, 'surfbar_click', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(286, 29, 'surfbar_view', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://fucoexsponsor.net/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(287, 29, 'textlink_click', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(288, 29, 'textlink_view', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/sc_textview.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(281, 29, 'textmail', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(289, 29, 'traffic', 'http://fucoexsponsor.net/int/get.php', 'http://fucoexsponsor.net/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL)"); // Network type handlers - Fusion-Ads + 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 +(290, 13, 'forcedbanner', 'http://www.fusion-ads.de/data/get.php', 'http://www.fusion-ads.de/data/werbung.php?uid=%UID%&kid=%CID%&sid=%SID%&art=32&step=1', 'http://www.fusion-ads.de/data/werbung.php?uid=%UID%&kid=%CID%&sid=%SID%&art=32'), +(291, 13, 'textmail', 'http://www.fusion-ads.de/data/get.php', 'ttp://www.fusion-ads.de/data/werbung.php?uid=%UID%&kid=%CID%&sid=%SID%&art=33', NULL)"); // Network type handlers - GigaPromo addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES @@ -473,6 +529,22 @@ PRIMARY KEY (`network_reload_id`) (231, 25, 'textmail', 'http://www.gold-sponsor.de/interface/', 'http://www.gold-sponsor.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), (229, 25, 'traffic', 'http://www.gold-sponsor.de/interface/', 'http://www.gold-sponsor.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)"); + // Network type handlers - homeADS + 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 +(260, 28, 'banner_click', 'http://www.homeads.de/interface/out_banner.php', 'http://www.homeads.de/bannerklf.php?id=%CID%', 'http://www.homeads.de/banner.php?id=%CID%'), +(261, 28, 'banner_view', 'http://www.homeads.de/interface/out_banner.php', 'http://www.homeads.de/bannerklf.php?id=%CID%', 'http://www.homeads.de/banner.php?id=%CID%'), +(264, 28, 'forcedbanner', 'http://www.homeads.de/interface/out_fbanner.php', 'http://www.homeads.de/bannerklf.php?id=%CID%', 'http://www.homeads.de/banner.php?id=%CID%'), +(266, 28, 'htmlmail', 'http://www.homeads.de/interface/out_paidmail.php', 'http://www.homeads.de/emailf.php?id=%CID%', NULL), +(267, 28, 'layer_click', 'http://www.homeads.de/interface/out_layer.php', 'http://www.homeads.de/layer.php?id=%CID%', NULL), +(268, 28, 'layer_view', 'http://www.homeads.de/interface/out_layer.php', 'http://www.homeads.de/layer.php?id=%CID%', NULL), +(271, 28, 'lead', 'http://www.homeads.de/interface/out_lead.php', 'http://www.homeads.de/lead.php?id=%CID%', NULL), +(270, 28, 'popdown', 'http://www.homeads.de/interface/out_popdown.php', 'http://www.homeads.de/popdown.php?id=%CID%', NULL), +(269, 28, 'popup', 'http://www.homeads.de/interface/out_popup.php', 'http://www.homeads.de/popup.php?id=%CID%', NULL), +(272, 28, 'sale', 'http://www.homeads.de/interface/out_sale.php', 'http://www.homeads.de/sale.php?id=%CID%', NULL), +(262, 28, 'textlink_click', 'http://www.homeads.de/interface/out_textlink.php', 'http://www.homeads.de/textlinkklick.php?id=%CID%', NULL), +(263, 28, 'textlink_view', 'http://www.homeads.de/interface/out_textlink.php', 'http://www.homeads.de/textlinkklick.php?id=%CID%', NULL), +(265, 28, 'textmail', 'http://www.homeads.de/interface/out_paidmail.php', 'http://www.homeads.de/emailf.php?id=%CID%', NULL)"); + // Network type handlers - HPSponsor addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES (135, 15, 'banner_click', 'http://hpsponsor.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%'), @@ -537,16 +609,16 @@ PRIMARY KEY (`network_reload_id`) // Network type handlers - SeCash addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES -(93, 19, 'forcedbanner', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), -(94, 19, 'forcedtextlink', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(95, 19, 'banner_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), -(96, 19, 'banner_click', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'), -(97, 19, 'skybanner_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), -(98, 19, 'button_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'), -(99, 19, 'textlink_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(100, 19, 'popup', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(101, 19, 'textmail', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(124, 19, 'traffic', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)"); +(93, 19, 'forcedbanner', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(94, 19, 'forcedtextlink', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL), +(95, 19, 'banner_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(96, 19, 'banner_click', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'), +(97, 19, 'skybanner_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(98, 19, 'button_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.secash.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(99, 19, 'textlink_view', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL), +(100, 19, 'popup', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL), +(101, 19, 'textmail', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL), +(124, 19, 'traffic', 'http://www.secash.de/interface/api_2.php', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL)"); // 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 @@ -574,6 +646,22 @@ PRIMARY KEY (`network_reload_id`) (133, 21, 'textmail', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), (134, 21, 'traffic', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)"); + // Network type handlers - VIPads.de + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES +(247, 27, 'banner_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(248, 27, 'banner_view', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(249, 27, 'button_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(250, 27, 'button_view', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(251, 27, 'forcedbanner', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(252, 27, 'htmlmail', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(253, 27, 'layer', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/sc_layer.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(255, 27, 'popup', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/sc_popup.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(256, 27, 'skybanner_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(257, 27, 'skybanner_view', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'), +(258, 27, 'textlink_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(254, 27, 'textmail', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL), +(259, 27, 'traffic', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL)"); + // Network type handlers - Der Werbepartner.cc addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES (145, 22, 'textlink_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL), @@ -798,6 +886,79 @@ PRIMARY KEY (`network_reload_id`) // Request parameters per type handler - AdCocktail + // Request parameters per type handler - AdConvention + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES +(30, 292, 'extra', 'typ', 'forcedbanner'), +(30, 292, 'id', 'id', NULL), +(30, 292, 'minimum_stay', 'ma', NULL), +(30, 292, 'password', 'pw', NULL), +(30, 292, 'reload', 'reload', NULL), +(30, 292, 'remain', 'uebrig', NULL), +(30, 292, 'reward', 'verguetung', NULL), +(30, 293, 'extra', 'typ', 'forcedtextlink'), +(30, 293, 'id', 'id', NULL), +(30, 293, 'minimum_stay', 'ma', NULL), +(30, 293, 'password', 'pw', NULL), +(30, 293, 'reload', 'reload', NULL), +(30, 293, 'remain', 'uebrig', NULL), +(30, 293, 'reward', 'verguetung', NULL), +(30, 294, 'extra', 'typ', 'bannerview'), +(30, 294, 'id', 'id', NULL), +(30, 294, 'minimum_stay', 'ma', NULL), +(30, 294, 'password', 'pw', NULL), +(30, 294, 'reload', 'reload', NULL), +(30, 294, 'remain', 'uebrig', NULL), +(30, 294, 'reward', 'verguetung', NULL), +(30, 295, 'extra', 'typ', 'bannerklick'), +(30, 295, 'id', 'id', NULL), +(30, 295, 'minimum_stay', 'ma', NULL), +(30, 295, 'password', 'pw', NULL), +(30, 295, 'reload', 'reload', NULL), +(30, 295, 'remain', 'uebrig', NULL), +(30, 295, 'reward', 'verguetung', NULL), +(30, 296, 'extra', 'typ', 'skybannerview'), +(30, 296, 'id', 'id', NULL), +(30, 296, 'minimum_stay', 'ma', NULL), +(30, 296, 'password', 'pw', NULL), +(30, 296, 'reload', 'reload', NULL), +(30, 296, 'remain', 'uebrig', NULL), +(30, 296, 'reward', 'verguetung', NULL), +(30, 297, 'extra', 'typ', 'buttonview'), +(30, 297, 'id', 'id', NULL), +(30, 297, 'minimum_stay', 'ma', NULL), +(30, 297, 'password', 'pw', NULL), +(30, 297, 'reload', 'reload', NULL), +(30, 297, 'remain', 'uebrig', NULL), +(30, 297, 'reward', 'verguetung', NULL), +(30, 298, 'extra', 'typ', 'textview'), +(30, 298, 'id', 'id', NULL), +(30, 298, 'minimum_stay', 'ma', NULL), +(30, 298, 'password', 'pw', NULL), +(30, 298, 'reload', 'reload', NULL), +(30, 298, 'remain', 'uebrig', NULL), +(30, 298, 'reward', 'verguetung', NULL), +(30, 299, 'extra', 'typ', 'traffic'), +(30, 299, 'id', 'id', NULL), +(30, 299, 'minimum_stay', 'ma', NULL), +(30, 299, 'password', 'pw', NULL), +(30, 299, 'reload', 'reload', NULL), +(30, 299, 'remain', 'uebrig', NULL), +(30, 299, 'reward', 'verguetung', NULL), +(30, 300, 'extra', 'typ', 'popup'), +(30, 300, 'id', 'id', NULL), +(30, 300, 'minimum_stay', 'ma', NULL), +(30, 300, 'password', 'pw', NULL), +(30, 300, 'reload', 'reload', NULL), +(30, 300, 'remain', 'uebrig', NULL), +(30, 300, 'reward', 'verguetung', NULL), +(30, 301, 'extra', 'typ', 'paidmail'), +(30, 301, 'id', 'id', NULL), +(30, 301, 'minimum_stay', 'ma', NULL), +(30, 301, 'password', 'pw', NULL), +(30, 301, 'reload', 'reload', NULL), +(30, 301, 'remain', 'uebrig', NULL), +(30, 301, 'reward', 'verguetung', NULL)"); + // Request parameters per type handler - AdPaid addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES (5, 177, 'id', 'id', NULL), @@ -1390,7 +1551,261 @@ PRIMARY KEY (`network_reload_id`) (24, 221, 'reward', 'verguetung', NULL), (24, 221, 'minimum_stay', 'ma', NULL)"); + // Request parameters per type handler - doubleads + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES +(26, 232, 'id', 'id', NULL), +(26, 232, 'password', 'pw', NULL), +(26, 232, 'reload', 'reload', NULL), +(26, 232, 'remain', 'uebrig', NULL), +(26, 232, 'reward', 'verguetung', NULL), +(26, 232, 'sid', 'sid', NULL), +(26, 232, 'size', 'size', NULL), +(26, 232, 'type', 'typ', 'klick'), +(26, 233, 'id', 'id', NULL), +(26, 233, 'password', 'pw', NULL), +(26, 233, 'reload', 'reload', NULL), +(26, 233, 'remain', 'uebrig', NULL), +(26, 233, 'reward', 'verguetung', NULL), +(26, 233, 'sid', 'sid', NULL), +(26, 233, 'size', 'size', NULL), +(26, 233, 'type', 'typ', 'view'), +(26, 234, 'id', 'id', NULL), +(26, 234, 'password', 'pw', NULL), +(26, 234, 'reload', 'reload', NULL), +(26, 234, 'remain', 'uebrig', NULL), +(26, 234, 'reward', 'verguetung', NULL), +(26, 234, 'sid', 'sid', NULL), +(26, 234, 'type', 'typ', 'klick'), +(26, 235, 'id', 'id', NULL), +(26, 235, 'password', 'pw', NULL), +(26, 235, 'reload', 'reload', NULL), +(26, 235, 'remain', 'uebrig', NULL), +(26, 235, 'reward', 'verguetung', NULL), +(26, 235, 'sid', 'sid', NULL), +(26, 235, 'type', 'typ', 'view'), +(26, 236, 'id', 'id', NULL), +(26, 236, 'password', 'pw', NULL), +(26, 236, 'reload', 'reload', NULL), +(26, 236, 'remain', 'uebrig', NULL), +(26, 236, 'reward', 'verguetung', NULL), +(26, 236, 'sid', 'sid', NULL), +(26, 236, 'size', 'size', NULL), +(26, 236, 'type', 'typ', 'klick'), +(26, 237, 'id', 'id', NULL), +(26, 237, 'password', 'pw', NULL), +(26, 237, 'reload', 'reload', NULL), +(26, 237, 'remain', 'uebrig', NULL), +(26, 237, 'reward', 'verguetung', NULL), +(26, 237, 'sid', 'sid', NULL), +(26, 237, 'size', 'size', NULL), +(26, 237, 'type', 'typ', 'view'), +(26, 238, 'id', 'id', NULL), +(26, 238, 'minimum_stay', 'ma', NULL), +(26, 238, 'password', 'pw', NULL), +(26, 238, 'reload', 'reload', NULL), +(26, 238, 'remain', 'uebrig', NULL), +(26, 238, 'reward', 'verguetung', NULL), +(26, 238, 'sid', 'sid', NULL), +(26, 238, 'size', 'size', NULL), +(26, 239, 'id', 'id', NULL), +(26, 239, 'minimum_stay', 'ma', NULL), +(26, 239, 'password', 'pw', NULL), +(26, 239, 'reload', 'reload', NULL), +(26, 239, 'remain', 'uebrig', NULL), +(26, 239, 'reward', 'verguetung', NULL), +(26, 239, 'sid', 'sid', NULL), +(26, 239, 'type', 'typ', 'text'), +(26, 240, 'id', 'id', NULL), +(26, 240, 'minimum_stay', 'ma', NULL), +(26, 240, 'password', 'pw', NULL), +(26, 240, 'reload', 'reload', NULL), +(26, 240, 'remain', 'uebrig', NULL), +(26, 240, 'reward', 'verguetung', NULL), +(26, 240, 'sid', 'sid', NULL), +(26, 240, 'type', 'typ', 'html'), +(26, 241, 'id', 'id', NULL), +(26, 241, 'password', 'pw', NULL), +(26, 241, 'reload', 'reload', NULL), +(26, 241, 'remain', 'uebrig', NULL), +(26, 241, 'reward', 'verguetung', NULL), +(26, 241, 'sid', 'sid', NULL), +(26, 241, 'type', 'typ', 'klick'), +(26, 242, 'id', 'id', NULL), +(26, 242, 'password', 'pw', NULL), +(26, 242, 'reload', 'reload', NULL), +(26, 242, 'remain', 'uebrig', NULL), +(26, 242, 'reward', 'verguetung', NULL), +(26, 242, 'sid', 'sid', NULL), +(26, 242, 'type', 'typ', 'view'), +(26, 243, 'id', 'id', NULL), +(26, 243, 'minimum_stay', 'ma', NULL), +(26, 243, 'password', 'pw', NULL), +(26, 243, 'reload', 'reload', NULL), +(26, 243, 'remain', 'uebrig', NULL), +(26, 243, 'reward', 'verguetung', NULL), +(26, 243, 'sid', 'sid', NULL), +(26, 244, 'id', 'id', NULL), +(26, 244, 'minimum_stay', 'ma', NULL), +(26, 244, 'password', 'pw', NULL), +(26, 244, 'reload', 'reload', NULL), +(26, 244, 'remain', 'uebrig', NULL), +(26, 244, 'reward', 'verguetung', NULL), +(26, 244, 'sid', 'sid', NULL), +(26, 245, 'id', 'id', NULL), +(26, 245, 'password', 'pw', NULL), +(26, 245, 'remain', 'uebrig', NULL), +(26, 245, 'reward', 'verguetung', NULL), +(26, 245, 'sid', 'sid', NULL), +(26, 246, 'id', 'id', NULL), +(26, 246, 'password', 'pw', NULL), +(26, 246, 'remain', 'uebrig', NULL), +(26, 246, 'reward', 'verguetung', NULL), +(26, 246, 'sid', 'sid', NULL)"); + + // Request parameters per type handler - FuCoExSponsor.net + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES +(29, 273, 'extra', 'art', 'bannerklick'), +(29, 273, 'id', 'uid', NULL), +(29, 273, 'password', 'pw', NULL), +(29, 273, 'reload', 'reload', NULL), +(29, 273, 'remain', 'uebrig', NULL), +(29, 273, 'reward', 'verguetung', NULL), +(29, 273, 'sid', 'sid', NULL), +(29, 274, 'extra', 'art', 'bannerview'), +(29, 274, 'id', 'uid', NULL), +(29, 274, 'password', 'pw', NULL), +(29, 274, 'reload', 'reload', NULL), +(29, 274, 'remain', 'uebrig', NULL), +(29, 274, 'reward', 'verguetung', NULL), +(29, 274, 'sid', 'sid', NULL), +(29, 275, 'extra', 'art', 'buttonklick'), +(29, 275, 'id', 'uid', NULL), +(29, 275, 'password', 'pw', NULL), +(29, 275, 'reload', 'reload', NULL), +(29, 275, 'remain', 'uebrig', NULL), +(29, 275, 'reward', 'verguetung', NULL), +(29, 275, 'sid', 'sid', NULL), +(29, 276, 'extra', 'art', 'buttonview'), +(29, 276, 'id', 'uid', NULL), +(29, 276, 'password', 'pw', NULL), +(29, 276, 'reload', 'reload', NULL), +(29, 276, 'remain', 'uebrig', NULL), +(29, 276, 'reward', 'verguetung', NULL), +(29, 276, 'sid', 'sid', NULL), +(29, 277, 'extra', 'art', 'forcedbanner'), +(29, 277, 'id', 'uid', NULL), +(29, 277, 'minimum_stay', 'ma', NULL), +(29, 277, 'password', 'pw', NULL), +(29, 277, 'reload', 'reload', NULL), +(29, 277, 'remain', 'uebrig', NULL), +(29, 277, 'reward', 'verguetung', NULL), +(29, 277, 'sid', 'sid', NULL), +(29, 278, 'extra', 'art', 'forcedtextlink'), +(29, 278, 'id', 'uid', NULL), +(29, 278, 'minimum_stay', 'ma', NULL), +(29, 278, 'password', 'pw', NULL), +(29, 278, 'reload', 'reload', NULL), +(29, 278, 'remain', 'uebrig', NULL), +(29, 278, 'reward', 'verguetung', NULL), +(29, 278, 'sid', 'sid', NULL), +(29, 279, 'extra', 'art', 'htmlmail'), +(29, 279, 'id', 'uid', NULL), +(29, 279, 'minimum_stay', 'ma', NULL), +(29, 279, 'password', 'pw', NULL), +(29, 279, 'reload', 'reload', NULL), +(29, 279, 'remain', 'uebrig', NULL), +(29, 279, 'reward', 'verguetung', NULL), +(29, 279, 'sid', 'sid', NULL), +(29, 280, 'extra', 'art', 'layer'), +(29, 280, 'id', 'uid', NULL), +(29, 280, 'password', 'pw', NULL), +(29, 280, 'reload', 'reload', NULL), +(29, 280, 'remain', 'uebrig', NULL), +(29, 280, 'reward', 'verguetung', NULL), +(29, 280, 'sid', 'sid', NULL), +(29, 281, 'extra', 'art', 'paidmail'), +(29, 281, 'id', 'uid', NULL), +(29, 281, 'minimum_stay', 'ma', NULL), +(29, 281, 'password', 'pw', NULL), +(29, 281, 'reload', 'reload', NULL), +(29, 281, 'remain', 'uebrig', NULL), +(29, 281, 'reward', 'verguetung', NULL), +(29, 281, 'sid', 'sid', NULL), +(29, 282, 'extra', 'art', 'popup'), +(29, 282, 'id', 'uid', NULL), +(29, 282, 'minimum_stay', 'ma', NULL), +(29, 282, 'password', 'pw', NULL), +(29, 282, 'reload', 'reload', NULL), +(29, 282, 'remain', 'uebrig', NULL), +(29, 282, 'reward', 'verguetung', NULL), +(29, 282, 'sid', 'sid', NULL), +(29, 283, 'extra', 'art', 'skybannerklick'), +(29, 283, 'id', 'uid', NULL), +(29, 283, 'password', 'pw', NULL), +(29, 283, 'reload', 'reload', NULL), +(29, 283, 'remain', 'uebrig', NULL), +(29, 283, 'reward', 'verguetung', NULL), +(29, 283, 'sid', 'sid', NULL), +(29, 284, 'extra', 'art', 'skybannerview'), +(29, 284, 'id', 'uid', NULL), +(29, 284, 'password', 'pw', NULL), +(29, 284, 'reload', 'reload', NULL), +(29, 284, 'remain', 'uebrig', NULL), +(29, 284, 'reward', 'verguetung', NULL), +(29, 284, 'sid', 'sid', NULL), +(29, 285, 'extra', 'art', 'surfbarklick'), +(29, 285, 'hash', 'pw', NULL), +(29, 285, 'id', 'uid', NULL), +(29, 285, 'reload', 'reload', NULL), +(29, 285, 'remain', 'uebrig', NULL), +(29, 285, 'reward', 'verguetung', NULL), +(29, 285, 'sid', 'sid', NULL), +(29, 286, 'extra', 'art', 'surfbarview'), +(29, 286, 'id', 'uid', NULL), +(29, 286, 'password', 'pw', NULL), +(29, 286, 'reload', 'reload', NULL), +(29, 286, 'remain', 'uebrig', NULL), +(29, 286, 'reward', 'verguetung', NULL), +(29, 286, 'sid', 'sid', NULL), +(29, 287, 'extra', 'art', 'textlinkklick'), +(29, 287, 'id', 'uid', NULL), +(29, 287, 'password', 'pw', NULL), +(29, 287, 'reload', 'reload', NULL), +(29, 287, 'remain', 'uebrig', NULL), +(29, 287, 'reward', 'verguetung', NULL), +(29, 287, 'sid', 'sid', NULL), +(29, 288, 'extra', 'art', 'textlinkview'), +(29, 288, 'id', 'uid', NULL), +(29, 288, 'password', 'pw', NULL), +(29, 288, 'reload', 'reload', NULL), +(29, 288, 'remain', 'uebrig', NULL), +(29, 288, 'reward', 'verguetung', NULL), +(29, 288, 'sid', 'sid', NULL), +(29, 289, 'extra', 'art', 'traffic'), +(29, 289, 'id', 'uid', NULL), +(29, 289, 'minimum_stay', 'ma', NULL), +(29, 289, 'password', 'pw', NULL), +(29, 289, 'reload', 'reload', NULL), +(29, 289, 'remain', 'uebrig', NULL), +(29, 289, 'reward', 'verguetung', NULL), +(29, 289, 'sid', 'sid', NULL)"); + // Request parameters per type handler - Fusion-Ads + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES +(13, 290, 'extra', 'art', 'Forcedbanner'), +(13, 290, 'id', 'uid', NULL), +(13, 290, 'password', 'pw', NULL), +(13, 290, 'reload', 'reload', NULL), +(13, 290, 'remain', 'offen', NULL), +(13, 290, 'reward', 'verguetung', NULL), +(13, 290, 'sid', 'sid', NULL), +(13, 291, 'extra', 'art', 'Paidmail'), +(13, 291, 'id', 'uid', NULL), +(13, 291, 'password', 'pw', NULL), +(13, 291, 'reload', 'reload', NULL), +(13, 291, 'remain', 'offen', NULL), +(13, 291, 'reward', 'verguetung', NULL), +(13, 291, 'sid', 'sid', NULL)"); // Request parameters per type handler - GigapPromo addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES @@ -1516,6 +1931,101 @@ PRIMARY KEY (`network_reload_id`) (25, 231, 'remain', 'uebrig', NULL), (25, 231, 'reward', 'verguetung', NULL)"); + // Request parameters per type handler - homeADS + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES +(28, 260, 'id', 'id', NULL), +(28, 260, 'password', 'pw', NULL), +(28, 260, 'reload', 'reload', NULL), +(28, 260, 'remain', 'uebrig', NULL), +(28, 260, 'reward', 'verguetung', NULL), +(28, 260, 'sid', 'sid', NULL), +(28, 260, 'size', 'size', NULL), +(28, 260, 'type', 'typ', 'klick'), +(28, 261, 'id', 'id', NULL), +(28, 261, 'password', 'pw', NULL), +(28, 261, 'reload', 'reload', NULL), +(28, 261, 'remain', 'uebrig', NULL), +(28, 261, 'reward', 'verguetung', NULL), +(28, 261, 'sid', 'sid', NULL), +(28, 261, 'size', 'size', NULL), +(28, 261, 'type', 'typ', 'view'), +(28, 262, 'id', 'id', NULL), +(28, 262, 'password', 'pw', NULL), +(28, 262, 'reload', 'reload', NULL), +(28, 262, 'remain', 'uebrig', NULL), +(28, 262, 'reward', 'verguetung', NULL), +(28, 262, 'sid', 'sid', NULL), +(28, 262, 'type', 'typ', 'klick'), +(28, 263, 'id', 'id', NULL), +(28, 263, 'password', 'pw', NULL), +(28, 263, 'reload', 'reload', NULL), +(28, 263, 'remain', 'uebrig', NULL), +(28, 263, 'reward', 'verguetung', NULL), +(28, 263, 'sid', 'sid', NULL), +(28, 263, 'type', 'typ', 'view'), +(28, 264, 'id', 'id', NULL), +(28, 264, 'minimum_stay', 'ma', NULL), +(28, 264, 'password', 'pw', NULL), +(28, 264, 'reload', 'reload', NULL), +(28, 264, 'remain', 'uebrig', NULL), +(28, 264, 'reward', 'verguetung', NULL), +(28, 264, 'sid', 'sid', NULL), +(28, 264, 'size', 'size', NULL), +(28, 265, 'id', 'id', NULL), +(28, 265, 'minimum_stay', 'ma', NULL), +(28, 265, 'password', 'pw', NULL), +(28, 265, 'reload', 'reload', NULL), +(28, 265, 'remain', 'uebrig', NULL), +(28, 265, 'reward', 'verguetung', NULL), +(28, 265, 'sid', 'sid', NULL), +(28, 265, 'type', 'typ', 'text'), +(28, 266, 'id', 'id', NULL), +(28, 266, 'minimum_stay', 'ma', NULL), +(28, 266, 'password', 'pw', NULL), +(28, 266, 'reload', 'reload', NULL), +(28, 266, 'remain', 'uebrig', NULL), +(28, 266, 'reward', 'verguetung', NULL), +(28, 266, 'sid', 'sid', NULL), +(28, 266, 'type', 'typ', 'html'), +(28, 267, 'id', 'id', NULL), +(28, 267, 'password', 'pw', NULL), +(28, 267, 'reload', 'reload', NULL), +(28, 267, 'remain', 'uebrig', NULL), +(28, 267, 'reward', 'verguetung', NULL), +(28, 267, 'sid', 'sid', NULL), +(28, 267, 'type', 'typ', 'klick'), +(28, 268, 'id', 'id', NULL), +(28, 268, 'password', 'pw', NULL), +(28, 268, 'reload', 'reload', NULL), +(28, 268, 'remain', 'uebrig', NULL), +(28, 268, 'reward', 'verguetung', NULL), +(28, 268, 'sid', 'sid', NULL), +(28, 268, 'type', 'typ', 'view'), +(28, 269, 'id', 'id', NULL), +(28, 269, 'minimum_stay', 'ma', NULL), +(28, 269, 'password', 'pw', NULL), +(28, 269, 'reload', 'reload', NULL), +(28, 269, 'remain', 'uebrig', NULL), +(28, 269, 'reward', 'verguetung', NULL), +(28, 269, 'sid', 'sid', NULL), +(28, 270, 'id', 'id', NULL), +(28, 270, 'minimum_stay', 'ma', NULL), +(28, 270, 'password', 'pw', NULL), +(28, 270, 'reload', 'reload', NULL), +(28, 270, 'remain', 'uebrig', NULL), +(28, 270, 'reward', 'verguetung', NULL), +(28, 270, 'sid', 'sid', NULL), +(28, 271, 'id', 'id', NULL), +(28, 271, 'password', 'pw', NULL), +(28, 271, 'remain', 'uebrig', NULL), +(28, 271, 'reward', 'verguetung', NULL), +(28, 271, 'sid', 'sid', NULL), +(28, 272, 'id', 'id', NULL), +(28, 272, 'password', 'pw', NULL), +(28, 272, 'remain', 'uebrig', NULL), +(28, 272, 'reward', 'verguetung', NULL), +(28, 272, 'sid', 'sid', NULL)"); + // Request parameters per type handler - HPSponsor addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES (15, 135, 'extra', 'typ', 'forcedbanner'), @@ -2061,6 +2571,105 @@ PRIMARY KEY (`network_reload_id`) (21, 134, 'remain', 'uebrig', NULL), (21, 134, 'reward', 'verguetung', NULL)"); + // Request parameters per type handler - VIPads.de + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES +(27, 247, 'extra', 'art', 'bannerklick'), +(27, 247, 'id', 'uid', NULL), +(27, 247, 'password', 'pw', NULL), +(27, 247, 'reload', 'reload', NULL), +(27, 247, 'remain', 'uebrig', NULL), +(27, 247, 'reward', 'verguetung', NULL), +(27, 247, 'sid', 'sid', NULL), +(27, 248, 'extra', 'art', 'bannerview'), +(27, 248, 'id', 'uid', NULL), +(27, 248, 'password', 'pw', NULL), +(27, 248, 'reload', 'reload', NULL), +(27, 248, 'remain', 'uebrig', NULL), +(27, 248, 'reward', 'verguetung', NULL), +(27, 248, 'sid', 'sid', NULL), +(27, 249, 'extra', 'art', 'buttonklick'), +(27, 249, 'id', 'uid', NULL), +(27, 249, 'password', 'pw', NULL), +(27, 249, 'reload', 'reload', NULL), +(27, 249, 'remain', 'uebrig', NULL), +(27, 249, 'reward', 'verguetung', NULL), +(27, 249, 'sid', 'sid', NULL), +(27, 250, 'extra', 'art', 'buttonview'), +(27, 250, 'id', 'uid', NULL), +(27, 250, 'password', 'pw', NULL), +(27, 250, 'reload', 'reload', NULL), +(27, 250, 'remain', 'uebrig', NULL), +(27, 250, 'reward', 'verguetung', NULL), +(27, 250, 'sid', 'sid', NULL), +(27, 251, 'extra', 'art', 'forcedbanner'), +(27, 251, 'id', 'uid', NULL), +(27, 251, 'minimum_stay', 'ma', NULL), +(27, 251, 'password', 'pw', NULL), +(27, 251, 'reload', 'reload', NULL), +(27, 251, 'remain', 'uebrig', NULL), +(27, 251, 'reward', 'verguetung', NULL), +(27, 251, 'sid', 'sid', NULL), +(27, 252, 'extra', 'art', 'htmlmail'), +(27, 252, 'id', 'id', NULL), +(27, 252, 'minimum_stay', 'ma', NULL), +(27, 252, 'password', 'pw', NULL), +(27, 252, 'reload', 'reload', NULL), +(27, 252, 'remain', 'uebrig', NULL), +(27, 252, 'reward', 'verguetung', NULL), +(27, 252, 'sid', 'sid', NULL), +(27, 253, 'extra', 'art', 'layer'), +(27, 253, 'id', 'uid', NULL), +(27, 253, 'password', 'pw', NULL), +(27, 253, 'reload', 'reload', NULL), +(27, 253, 'remain', 'uebrig', NULL), +(27, 253, 'reward', 'verguetung', NULL), +(27, 253, 'sid', 'sid', NULL), +(27, 254, 'extra', 'art', 'paidmail'), +(27, 254, 'id', 'uid', NULL), +(27, 254, 'minimum_stay', 'ma', NULL), +(27, 254, 'password', 'pw', NULL), +(27, 254, 'reload', 'reload', NULL), +(27, 254, 'remain', 'uebrig', NULL), +(27, 254, 'reward', 'verguetung', NULL), +(27, 254, 'sid', 'sid', NULL), +(27, 255, 'extra', 'art', 'popup'), +(27, 255, 'id', 'uid', NULL), +(27, 255, 'minimum_stay', 'ma', NULL), +(27, 255, 'password', 'pw', NULL), +(27, 255, 'reload', 'reload', NULL), +(27, 255, 'remain', 'uebrig', NULL), +(27, 255, 'reward', 'verguetung', NULL), +(27, 255, 'sid', 'sid', NULL), +(27, 256, 'extra', 'art', 'skybannerklick'), +(27, 256, 'id', 'uid', NULL), +(27, 256, 'password', 'pw', NULL), +(27, 256, 'reload', 'reload', NULL), +(27, 256, 'remain', 'uebrig', NULL), +(27, 256, 'reward', 'verguetung', NULL), +(27, 256, 'sid', 'sid', NULL), +(27, 257, 'extra', 'art', 'skybannerview'), +(27, 257, 'id', 'uid', NULL), +(27, 257, 'password', 'pw', NULL), +(27, 257, 'reload', 'reload', NULL), +(27, 257, 'remain', 'uebrig', NULL), +(27, 257, 'reward', 'verguetung', NULL), +(27, 257, 'sid', 'sid', NULL), +(27, 258, 'extra', 'art', 'textlinkklick'), +(27, 258, 'id', 'uid', NULL), +(27, 258, 'password', 'pw', NULL), +(27, 258, 'reload', 'reload', NULL), +(27, 258, 'remain', 'uebrig', NULL), +(27, 258, 'reward', 'verguetung', NULL), +(27, 258, 'sid', 'sid', NULL), +(27, 259, 'extra', 'art', 'traffic'), +(27, 259, 'id', 'uid', NULL), +(27, 259, 'minimum_stay', 'ma', NULL), +(27, 259, 'password', 'pw', NULL), +(27, 259, 'reload', 'reload', NULL), +(27, 259, 'remain', 'uebrig', NULL), +(27, 259, 'reward', 'verguetung', NULL), +(27, 259, 'sid', 'sid', NULL)"); + // Request parameters per type handler - Der Werbepartner.cc addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES (22, 145, 'extra', 'art', 'Textlinkklick'), @@ -2419,6 +3028,65 @@ PRIMARY KEY (`network_reload_id`) // API array elements - ADCocktail + // API array elements - AdConvention + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES +(30, 292, 1, 1), +(30, 292, 2, 2), +(30, 292, 4, 3), +(30, 292, 5, 4), +(30, 292, 6, 5), +(30, 292, 10, 6), +(30, 293, 1, 1), +(30, 293, 2, 2), +(30, 293, 4, 3), +(30, 293, 5, 4), +(30, 293, 6, 5), +(30, 293, 10, 6), +(30, 294, 1, 1), +(30, 294, 2, 2), +(30, 294, 4, 3), +(30, 294, 5, 4), +(30, 294, 6, 5), +(30, 295, 1, 1), +(30, 295, 2, 2), +(30, 295, 4, 3), +(30, 295, 5, 4), +(30, 295, 6, 5), +(30, 296, 1, 1), +(30, 296, 2, 2), +(30, 296, 4, 3), +(30, 296, 5, 4), +(30, 296, 6, 5), +(30, 297, 1, 1), +(30, 297, 2, 2), +(30, 297, 4, 3), +(30, 297, 5, 4), +(30, 297, 6, 5), +(30, 298, 1, 1), +(30, 298, 2, 2), +(30, 298, 4, 3), +(30, 298, 5, 4), +(30, 298, 6, 5), +(30, 299, 1, 1), +(30, 299, 2, 2), +(30, 299, 4, 3), +(30, 299, 5, 4), +(30, 299, 6, 5), +(30, 299, 10, 6), +(30, 300, 1, 1), +(30, 300, 2, 2), +(30, 300, 4, 3), +(30, 300, 5, 4), +(30, 300, 6, 5), +(30, 300, 10, 6), +(30, 301, 1, 1), +(30, 301, 2, 2), +(30, 301, 4, 3), +(30, 301, 5, 4), +(30, 301, 6, 5), +(30, 301, 10, 6), +(30, 301, 9, 7)"); + // 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), @@ -2953,7 +3621,235 @@ PRIMARY KEY (`network_reload_id`) (24, 221, 9, 7), (24, 221, 27, 8)"); + // API array elements - doubleads + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES +(26, 232, 1, 1), +(26, 232, 2, 2), +(26, 232, 3, 3), +(26, 232, 4, 4), +(26, 232, 5, 5), +(26, 232, 6, 6), +(26, 232, 8, 7), +(26, 232, 10, 8), +(26, 233, 1, 1), +(26, 233, 2, 2), +(26, 233, 3, 3), +(26, 233, 4, 4), +(26, 233, 5, 5), +(26, 233, 6, 6), +(26, 233, 8, 7), +(26, 233, 10, 8), +(26, 234, 1, 1), +(26, 234, 2, 2), +(26, 234, 9, 3), +(26, 234, 4, 4), +(26, 234, 5, 5), +(26, 234, 6, 6), +(26, 235, 1, 1), +(26, 235, 2, 2), +(26, 235, 9, 3), +(26, 235, 4, 4), +(26, 235, 5, 5), +(26, 235, 6, 6), +(26, 236, 1, 1), +(26, 236, 2, 2), +(26, 236, 3, 3), +(26, 236, 4, 4), +(26, 236, 5, 5), +(26, 236, 6, 6), +(26, 236, 8, 7), +(26, 237, 1, 1), +(26, 237, 2, 2), +(26, 237, 3, 3), +(26, 237, 4, 4), +(26, 237, 5, 5), +(26, 237, 6, 6), +(26, 237, 8, 7), +(26, 238, 1, 1), +(26, 238, 2, 2), +(26, 238, 3, 3), +(26, 238, 4, 4), +(26, 238, 5, 5), +(26, 238, 6, 6), +(26, 238, 10, 7), +(26, 238, 8, 8), +(26, 239, 1, 1), +(26, 239, 2, 2), +(26, 239, 4, 3), +(26, 239, 5, 4), +(26, 239, 6, 5), +(26, 239, 10, 6), +(26, 239, 9, 7), +(26, 240, 1, 1), +(26, 240, 2, 2), +(26, 240, 4, 3), +(26, 240, 5, 4), +(26, 240, 6, 5), +(26, 240, 10, 6), +(26, 240, 9, 7), +(26, 241, 1, 1), +(26, 241, 2, 2), +(26, 241, 4, 3), +(26, 241, 5, 4), +(26, 241, 6, 5), +(26, 242, 1, 1), +(26, 242, 2, 2), +(26, 242, 4, 3), +(26, 242, 5, 4), +(26, 242, 6, 5), +(26, 243, 1, 1), +(26, 243, 2, 2), +(26, 243, 4, 3), +(26, 243, 5, 4), +(26, 243, 6, 5), +(26, 243, 10, 6), +(26, 244, 1, 1), +(26, 244, 2, 2), +(26, 244, 4, 3), +(26, 244, 5, 4), +(26, 244, 6, 5), +(26, 244, 10, 6), +(26, 245, 1, 1), +(26, 245, 2, 2), +(26, 245, 6, 3), +(26, 245, 19, 4), +(26, 245, 20, 5), +(26, 245, 21, 6), +(26, 245, 22, 7), +(26, 245, 23, 8), +(26, 245, 9, 9), +(26, 245, 25, 10), +(26, 245, 5, 11), +(26, 246, 1, 1), +(26, 246, 2, 2), +(26, 246, 6, 3), +(26, 246, 19, 4), +(26, 246, 20, 5), +(26, 246, 21, 6), +(26, 246, 22, 7), +(26, 246, 23, 8), +(26, 246, 9, 9), +(26, 246, 25, 10)"); + + // API array elements - FuCoExSponsor.net + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES +(29, 273, 7, 1), +(29, 273, 2, 2), +(29, 273, 5, 3), +(29, 273, 4, 4), +(29, 273, 6, 5), +(29, 274, 7, 1), +(29, 274, 2, 2), +(29, 274, 5, 3), +(29, 274, 4, 4), +(29, 274, 6, 5), +(29, 275, 7, 1), +(29, 275, 2, 2), +(29, 275, 5, 3), +(29, 275, 4, 4), +(29, 275, 6, 5), +(29, 276, 7, 1), +(29, 276, 2, 2), +(29, 276, 5, 3), +(29, 276, 4, 4), +(29, 276, 6, 5), +(29, 277, 7, 1), +(29, 277, 2, 2), +(29, 277, 5, 3), +(29, 277, 4, 4), +(29, 277, 6, 5), +(29, 277, 10, 6), +(29, 278, 11, 1), +(29, 278, 2, 2), +(29, 278, 5, 3), +(29, 278, 4, 4), +(29, 278, 6, 5), +(29, 278, 10, 6), +(29, 278, 9, 7), +(29, 279, 13, 1), +(29, 279, 2, 2), +(29, 279, 5, 3), +(29, 279, 4, 4), +(29, 279, 6, 5), +(29, 279, 10, 6), +(29, 279, 37, 7), +(29, 279, 9, 8), +(29, 280, 14, 1), +(29, 280, 2, 2), +(29, 280, 5, 3), +(29, 280, 4, 4), +(29, 280, 6, 5), +(29, 281, 13, 1), +(29, 281, 2, 2), +(29, 281, 5, 3), +(29, 281, 4, 4), +(29, 281, 6, 5), +(29, 281, 10, 6), +(29, 281, 37, 7), +(29, 281, 9, 8), +(29, 282, 15, 1), +(29, 282, 2, 2), +(29, 282, 5, 3), +(29, 282, 4, 4), +(29, 282, 6, 5), +(29, 282, 10, 6), +(29, 283, 7, 1), +(29, 283, 2, 2), +(29, 283, 5, 3), +(29, 283, 4, 4), +(29, 283, 6, 5), +(29, 284, 7, 1), +(29, 284, 2, 2), +(29, 284, 5, 3), +(29, 284, 4, 4), +(29, 284, 6, 5), +(29, 285, 12, 1), +(29, 285, 2, 2), +(29, 285, 5, 3), +(29, 285, 4, 4), +(29, 285, 6, 5), +(29, 286, 12, 1), +(29, 286, 2, 2), +(29, 286, 5, 3), +(29, 286, 4, 4), +(29, 286, 6, 5), +(29, 287, 11, 1), +(29, 287, 2, 2), +(29, 287, 5, 3), +(29, 287, 4, 4), +(29, 287, 6, 5), +(29, 287, 9, 6), +(29, 288, 11, 1), +(29, 288, 2, 2), +(29, 288, 5, 3), +(29, 288, 4, 4), +(29, 288, 6, 5), +(29, 288, 9, 6), +(29, 289, 26, 1), +(29, 289, 2, 2), +(29, 289, 5, 3), +(29, 289, 4, 4), +(29, 289, 6, 5), +(29, 289, 10, 6)"); + // API array elements - Fusion-Ads + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES +(13, 290, 1, 1), +(13, 290, 2, 2), +(13, 290, 6, 3), +(13, 290, 4, 4), +(13, 290, 5, 5), +(13, 290, 39, 6), +(13, 290, 38, 7), +(13, 290, 10, 8), +(13, 291, 1, 1), +(13, 291, 2, 2), +(13, 291, 6, 3), +(13, 291, 4, 4), +(13, 291, 5, 5), +(13, 291, 38, 6), +(13, 291, 9, 7), +(13, 291, 10, 8)"); // API array elements - GigaPromo addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES @@ -3061,6 +3957,102 @@ PRIMARY KEY (`network_reload_id`) (25, 231, 10, 6), (25, 231, 9, 7)"); + // API array elements - homeADS + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES +(28, 260, 1, 1), +(28, 260, 2, 2), +(28, 260, 3, 3), +(28, 260, 4, 4), +(28, 260, 5, 5), +(28, 260, 6, 6), +(28, 260, 8, 7), +(28, 260, 10, 8), +(28, 261, 1, 1), +(28, 261, 2, 2), +(28, 261, 3, 3), +(28, 261, 4, 4), +(28, 261, 5, 5), +(28, 261, 6, 6), +(28, 261, 8, 7), +(28, 261, 10, 8), +(28, 262, 1, 1), +(28, 262, 2, 2), +(28, 262, 9, 3), +(28, 262, 4, 4), +(28, 262, 5, 5), +(28, 262, 6, 6), +(28, 263, 1, 1), +(28, 263, 2, 2), +(28, 263, 9, 3), +(28, 263, 4, 4), +(28, 263, 5, 5), +(28, 263, 6, 6), +(28, 264, 1, 1), +(28, 264, 2, 2), +(28, 264, 3, 3), +(28, 264, 4, 4), +(28, 264, 5, 5), +(28, 264, 6, 6), +(28, 264, 10, 7), +(28, 264, 8, 8), +(28, 265, 1, 1), +(28, 265, 2, 2), +(28, 265, 4, 3), +(28, 265, 5, 4), +(28, 265, 6, 5), +(28, 265, 10, 6), +(28, 265, 9, 7), +(28, 266, 1, 1), +(28, 266, 2, 2), +(28, 266, 4, 3), +(28, 266, 5, 4), +(28, 266, 6, 5), +(28, 266, 10, 6), +(28, 266, 9, 7), +(28, 267, 1, 1), +(28, 267, 2, 2), +(28, 267, 4, 3), +(28, 267, 5, 4), +(28, 267, 6, 5), +(28, 268, 1, 1), +(28, 268, 2, 2), +(28, 268, 4, 3), +(28, 268, 5, 4), +(28, 268, 6, 5), +(28, 269, 1, 1), +(28, 269, 2, 2), +(28, 269, 4, 3), +(28, 269, 5, 4), +(28, 269, 6, 5), +(28, 269, 10, 6), +(28, 270, 1, 1), +(28, 270, 2, 2), +(28, 270, 4, 3), +(28, 270, 5, 4), +(28, 270, 6, 5), +(28, 270, 10, 6), +(28, 271, 1, 1), +(28, 271, 2, 2), +(28, 271, 6, 3), +(28, 271, 19, 4), +(28, 271, 20, 5), +(28, 271, 21, 6), +(28, 271, 22, 7), +(28, 271, 23, 8), +(28, 271, 9, 9), +(28, 271, 25, 10), +(28, 271, 5, 11), +(28, 272, 1, 1), +(28, 272, 2, 2), +(28, 272, 19, 3), +(28, 272, 20, 4), +(28, 272, 21, 5), +(28, 272, 22, 6), +(28, 272, 23, 7), +(28, 272, 9, 8), +(28, 272, 25, 9), +(28, 272, 5, 10)"); + // 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), @@ -3603,6 +4595,84 @@ PRIMARY KEY (`network_reload_id`) (21, 134, 5, 4), (21, 134, 6, 5)"); + // API array elements - VIPads + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES +(27, 247, 7, 1), +(27, 247, 2, 2), +(27, 247, 5, 3), +(27, 247, 4, 4), +(27, 247, 6, 5), +(27, 248, 7, 1), +(27, 248, 2, 2), +(27, 248, 5, 3), +(27, 248, 4, 4), +(27, 248, 6, 5), +(27, 249, 7, 1), +(27, 249, 2, 2), +(27, 249, 5, 3), +(27, 249, 4, 4), +(27, 249, 6, 5), +(27, 250, 7, 1), +(27, 250, 2, 2), +(27, 250, 5, 3), +(27, 250, 4, 4), +(27, 250, 6, 5), +(27, 251, 7, 1), +(27, 251, 2, 2), +(27, 251, 5, 3), +(27, 251, 4, 4), +(27, 251, 6, 5), +(27, 251, 10, 6), +(27, 252, 13, 1), +(27, 252, 2, 2), +(27, 252, 5, 3), +(27, 252, 4, 4), +(27, 252, 6, 5), +(27, 252, 10, 6), +(27, 252, 37, 7), +(27, 252, 9, 8), +(27, 253, 14, 1), +(27, 253, 2, 2), +(27, 253, 5, 3), +(27, 253, 4, 4), +(27, 253, 6, 5), +(27, 254, 13, 1), +(27, 254, 2, 2), +(27, 254, 5, 3), +(27, 254, 4, 4), +(27, 254, 6, 5), +(27, 254, 10, 6), +(27, 254, 37, 7), +(27, 254, 9, 8), +(27, 255, 15, 1), +(27, 255, 2, 2), +(27, 255, 5, 3), +(27, 255, 4, 4), +(27, 255, 6, 5), +(27, 255, 10, 6), +(27, 256, 7, 1), +(27, 256, 2, 2), +(27, 256, 5, 3), +(27, 256, 4, 4), +(27, 256, 6, 5), +(27, 257, 7, 1), +(27, 257, 2, 2), +(27, 257, 5, 3), +(27, 257, 4, 4), +(27, 257, 6, 5), +(27, 258, 11, 1), +(27, 258, 2, 2), +(27, 258, 5, 3), +(27, 258, 4, 4), +(27, 258, 6, 5), +(27, 258, 9, 6), +(27, 259, 26, 1), +(27, 259, 2, 2), +(27, 259, 5, 3), +(27, 259, 4, 4), +(27, 259, 6, 5), +(27, 259, 10, 6)"); + // API array elements - Der Werbepartner.cc addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES (22, 145, 1, 1), @@ -3761,7 +4831,7 @@ PRIMARY KEY (`network_reload_id`) // 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); addAdminMenuSql('network','config_networks','API-Daten','Stellen Sie Ihre Affiliate- Webseiten-Id und API-Passwort ein. Diese erhalten Sie zu über 99% aus dem jeweiligen Zugangsbereich des Anbieters. Sollten Sie bei einem Netzwerk noch nicht angemeldet sein, verwenden Sie bitte meinen Referal-Link.',1); - addAdminMenuSql('network','config_network_types','Werbearten','Stellen Sie hier Reload-Zeiten, Mindestauffenthalt und so weiter pro Werbeart und Werbenetzwerk ein. Es werden sonst Standart-Werte (Mimimumwerte: 0, Maximumwerte: sehr gross, Erotik: aus) angenommen, die Sie meistens nicht wollen.',2); + addAdminMenuSql('network','config_network_types','Werbearten','Stellen Sie hier Reload-Zeiten, Mindestauffenthalt und so weiter pro Werbeart und Werbenetzwerk ein. Es werden sonst Standard-Werte (Mimimumwerte: 0, Maximumwerte: sehr gross, Erotik: aus) angenommen, die Sie meistens nicht wollen.',2); addAdminMenuSql('network','query_networks','APIs abfragen','Fragt alle eingestellten APIs ab. Die Ergebnisse werden dann für einen einstellbaren Zeitraum gecacht und nicht erneut angefordert.',3); addAdminMenuSql('network','config_network','Einstellungen','Stellen Sie generelle Einstellungen ein, die für alle Werbenetzwerke gelten, wie z.B. Cache-Erneuerungsinterval. Generell sind aber die Einstellungen in Ordnung, da z.B. sonst Ihre freien Abfragen beim Werbenetzwerk sich zu schnell abbauen.',4); addAdminMenuSql('network','list_network_reloads','Reload-Sperren','Listen oder löschen Sie hier Reload-Sperren. Vorsicht: Die hier gespeicherten Reload-Sperren sind vom jeweiligen Werbenetzwerk übernommen. Eventuell verdienen Sie nichts, wenn Sie z.B. eine Mail innerhalb der Reload-Sperre erneut versenden.',5); @@ -3778,16 +4848,16 @@ PRIMARY KEY (`network_reload_id`) case 'remove': // Do stuff when removing extension // SQL commands to run - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_data`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types`'); - 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_api_translation`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_cache`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_reloads`'); + addDropTableSql('network_data'); + addDropTableSql('network_types'); + addDropTableSql('network_request_params'); + addDropTableSql('network_error_codes'); + addDropTableSql('network_error_types'); + addDropTableSql('network_api_translation'); + addDropTableSql('network_config'); + addDropTableSql('network_types_config'); + addDropTableSql('network_cache'); + addDropTableSql('network_reloads'); // Admin menu addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='network'"); @@ -3815,7 +4885,7 @@ PRIMARY KEY (`network_reload_id`) case 'modify': // When the extension got modified break; - case 'test': // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305. + case 'test': // For testing purposes break; case 'init': // Do stuff when extension is initialized