* 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 *
* *
`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`');
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. <strong>VORSICHT:</strong> Das Einrichten von weiteren Werbenetzwerken ist nicht leicht, dafür aber sehr flexibel! Sollte ein Netzwerk fehlen, so melden Sie dies bitte <a href="http://forum.mxchange.org/topic-462.html" target="_blank" title="Direktlink zum Forum">im Forum</a>!',4);
addAdminMenuSql('network','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);
projects / mailer.git / blobdiff