X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-network.php;h=02150fc03bb12d628644784bf0832e02eee99db7;hp=17bfe59b415f05b513ead5f617652fc6aa0dc9cc;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=4fe1098d15a73ae39130c68df63ca25d289231e7 diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php index 17bfe59b41..02150fc03b 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, * @@ -26,7 +24,8 @@ * @TODO AllAds4You: Traffic from abroad, High-Forced banner * * @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, really UTF-8 * + * @TODO Fusion-Ads: Has click/banner URL in API response * + * @TODO GeldSponsor.de Requires ID card copy/business reg. * * @TODO GolloX: Which charset? * * @TODO paid4ad: Which URLs for click and banner? * * @TODO VIPads: HTML text is send encoded with BASE64 * @@ -39,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 * @@ -75,8 +74,8 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_data` ( + addDropTableSql('network_data'); + addCreateTableSql('network_data', "( `network_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_short_name` VARCHAR(50) NOT NULL DEFAULT '', `network_title` VARCHAR(255) NOT NULL DEFAULT '', @@ -85,14 +84,15 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types` ( + addDropTableSql('network_types'); + addCreateTableSql('network_types', "( `network_type_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_type_handle` VARCHAR(255) NOT NULL DEFAULT '', @@ -101,11 +101,11 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_request_params` ( + addDropTableSql('network_request_params'); + addCreateTableSql('network_request_params', "( `network_param_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -115,11 +115,11 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_codes` ( + addDropTableSql('network_error_codes'); + addCreateTableSql('network_error_codes', "( `network_type_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_type_code_value` VARCHAR(50) NOT NULL DEFAULT '', @@ -127,29 +127,29 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_error_types` ( + addDropTableSql('network_error_types'); + addCreateTableSql('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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` ( + addDropTableSql('network_translations'); + addCreateTableSql('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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_api_translation` ( + addDropTableSql('network_api_translation'); + addCreateTableSql('network_api_translation', "( `network_api_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, @@ -158,11 +158,11 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_config` ( + addDropTableSql('network_config'); + addCreateTableSql('network_config', "( `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_api_password` VARCHAR(255) NOT NULL DEFAULT '', @@ -172,11 +172,11 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types_config` ( + addDropTableSql('network_types_config'); + addCreateTableSql('network_types_config', "( `network_data_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, @@ -187,25 +187,25 @@ 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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_cache` ( + addDropTableSql('network_cache'); + addCreateTableSql('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`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_reloads` ( + addDropTableSql('network_reloads'); + addCreateTableSql('network_reloads', "( `network_reload_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, @@ -213,93 +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 - 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'), -('vipads', 'VIPads.de', 'http://vipads.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1'), -('homeads', 'homeADS', 'http://www.homeads.de/?ref=1540', '|', '|', 'GET', 'WINDOWS-1252'), -('fucoexsponsor', 'FuCoExSponsor.net', 'http://fucoexsponsor.net/index.php?seite=anmeldung&ref=Quix0r', '|', '|', '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 @@ -340,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%'), @@ -487,6 +501,9 @@ PRIMARY KEY (`network_reload_id`) (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 @@ -592,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 @@ -869,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), @@ -1573,9 +1663,149 @@ PRIMARY KEY (`network_reload_id`) (26, 246, 'sid', 'sid', NULL)"); // Request parameters per type handler - FuCoExSponsor.net - addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}"); + 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 @@ -2798,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), @@ -3443,8 +3732,124 @@ PRIMARY KEY (`network_reload_id`) (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 @@ -4426,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); @@ -4443,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'"); @@ -4480,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