X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-network.php;h=9298c7a42ce8594cdd42f36e8aaab942429c2a0a;hp=c03a1ce049e6ef5dbe175c2e4e9d662c5b516d9d;hb=ccf34a2a92d80d01debd84b4b6e1f294d8f90cce;hpb=b8c071f12a601619c4c02b9441b3e0e012db6ced diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php index c03a1ce049..9298c7a42c 100644 --- a/inc/extensions/ext-network.php +++ b/inc/extensions/ext-network.php @@ -17,6 +17,21 @@ * Needs to be in all Files and every File needs "svn propset * * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * + * @TODO Ad-Magnet: Layer(klick?). Layerviews.Skybannerklick/-view, * + * @TODO Ad-Magnet: Banner-View, Textlink-Klick/-View. Page-Peel * + * @TODO ADCocktail: Traffic, BIDausKAS??? * + * @TODO Ads4.de: Traffic * + * @TODO Ads4Webbis: Traffic * + * @TODO Ads4World: Traffic * + * @TODO Affiliblatt: All except banner * + * @TODO doubleads: Which charset? * + * @TODO Fusion-Ads: Has click/banner URL in API response * + * @TODO GolloX: Which charset? * + * @TODO homeADS: Which charset? * + * @TODO paid4ad: Waiting for approval * + * @TODO secash: Traffic * + * @TODO ultraPROMO: Traffic * + * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * @@ -74,24 +89,26 @@ PRIMARY KEY (`network_id`) `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 '', -`network_type_request_url` VARCHAR(255) NOT NULL DEFAULT '', +`network_type_api_url` VARCHAR(255) NOT NULL DEFAULT '', `network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '', `network_type_banner_url` VARCHAR(255) NOT NULL DEFAULT '', UNIQUE `provider_type` (`network_id`,`network_type_handle`), PRIMARY KEY (`network_type_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Types provideable by networks. ONLY FILL OUT WITH PROPER idEA!'"); +) TYPE={?_TABLE_TYPE?} 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` ( +`network_param_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, +`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, -`request_param_max_reload_time` VARCHAR(10) NOT NULL DEFAULT 'reload', -`request_param_min_waiting_time` VARCHAR(10) NOT NULL DEFAULT 'ma', -`request_param_min_remain_clicks` VARCHAR(10) NOT NULL DEFAULT 'uebrig', -`request_param_min_payment` VARCHAR(10) NOT NULL DEFAULT 'verguetung', -`request_param_allow_erotic` VARCHAR(10) NOT NULL DEFAULT 'erotik', -PRIMARY KEY (`network_type_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request ONLY FILL OUT WITH PROPER idEA!'"); +`request_param_key` VARCHAR(10) NOT NULL DEFAULT 'invalid', +`request_param_value` VARCHAR(10) NOT NULL DEFAULT 'invalid', +`request_param_default` VARCHAR(10) NULL DEFAULT NULL, +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'"); // Error status codes addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_type_codes`'); @@ -212,8 +229,76 @@ PRIMARY KEY (`network_reload_id`) addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('REQUEST_PARAMS_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 ('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252')"); - + 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 +('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252'), +('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252'), +('ad-magnet', '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'), +('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252'), +('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'UTF-8'), +('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'UTF-8'), +('affiliblatt', 'Affiliblatt', 'http://www.Affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8'), +('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'), +('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252'), +('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1')"); + + // Network type handlers - Yoo!Media + + // Network type handlers - A3H + + // Network type handlers - Ad-Magnet + + // Network type handlers - AdCocktail + + // Network type handlers - Ads4 + + // Network type handlers - Ads4Webbis + + // Network type handlers - Ads4World + + // Network type handlers - Affiliblatt + + // Network type handlers - Alster-Marketing + + // Network type handlers - BonusSponsor + + // Network type handlers - Fusion-Ads + + // Network type handlers - Power-Promo + + // Network type handlers - Make-Euros + + // Request parameters per type handler - Yoo!Media + + // Request parameters per type handler - A3H + + // Request parameters per type handler - Ad-Magnet + + // Request parameters per type handler - AdCocktail + + // Request parameters per type handler - Ads4 + + // Request parameters per type handler - Ads4Webbis + + // Request parameters per type handler - Ads4World + + // Request parameters per type handler - Affiliblatt + + // Request parameters per type handler - Alster-Marketing + + // Request parameters per type handler - BonusSponsor + + // Request parameters per type handler - Fusion-Ads + + // Request parameters per type handler - Power-Promo + + // Request parameters per type handler - Make-Euros + + // Fix empty defaults to NULL + addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_request_params` SET `request_param_default`=NULL WHERE `request_param_default`=''"); + // 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);