<?php
/************************************************************************
* Mailer v0.2.1-FINAL Start: 12/18/2008 *
- * =================== Last change: 12/19/2009 *
+ * =================== Last change: 03/05/2010 *
* *
* -------------------------------------------------------------------- *
* File : ext-network.php *
* $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, *
- * @TODO Ad-Magnet: Banner-View, Textlink-Klick/-View. Page-Peel *
- * @TODO ADCocktail: All request parameters, BIDausKAS, WIDausKAS??? *
- * @TODO Affiliblatt: All except banner, do they really have UTF-8? *
- * @TODO doubleads: Which charset? *
- * @TODO Fusion-Ads: Has click/banner URL in API response, really UTF-8 *
- * @TODO GolloX: Which charset? *
- * @TODO homeADS: Which charset? *
- * @TODO paid4ad: Which URLs for click and banner? *
- * @TODO Der Werbepartner.cc: Has click/banner URL in API response *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009, 2010 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
} // END - if
// Version number
-setThisExtensionVersion('0.0');
+setThisExtensionVersion('0.0.0');
-// Version history array (add more with , '0.1.0' and so on)
-setExtensionVersionHistory(array('0.0'));
+// Version history array (add more with , '0.0.1' and so on)
+setExtensionVersionHistory(array('0.0.0'));
// This extension is in development (non-productive)
-enableExtensionProductive(false);
+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` (
-`network_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`network_short_name` VARCHAR(50) NOT NULL DEFAULT '',
-`network_title` VARCHAR(255) NOT NULL DEFAULT '',
-`network_reflink` VARCHAR(255) NOT NULL DEFAULT '',
-`network_data_seperator` CHAR(4) NOT NULL DEFAULT '|',
-`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',
-UNIQUE (`network_short_name`),
-PRIMARY KEY (`network_id`)
-) TYPE={?_TABLE_TYPE?} 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` (
-`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_api_url` VARCHAR(255) NOT NULL DEFAULT '',
-`network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '',
-`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'");
-
- // 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_key` VARCHAR(10) NOT NULL DEFAULT 'invalid',
-`request_param_value` VARCHAR(10) NOT NULL DEFAULT 'invalid',
-`request_param_default` VARCHAR(255) 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("CREATE TABLE `{?_MYSQL_PREFIX?}_network_type_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 '',
-`network_type_code_type` VARCHAR(100) NOT NULL DEFAULT 'INVALID_TYPE',
-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'");
-
- // Code types (internal table)
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_codes`');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_codes` (
-`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!'");
-
- // Valid translation keys (we hate hard-coded arrays, you see?)
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` (
-`network_translate_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_translation` VARCHAR(100) NOT NULL DEFAULT '',
-UNIQUE `type_trans` (`network_type_id`,`network_translation`),
-PRIMARY KEY (`network_translate_id`)
-) TYPE={?_TABLE_TYPE?} 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_array_translation`');
- addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_array_translation` (
-`network_translate_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_array_key` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_translation` VARCHAR(100) NOT NULL DEFAULT '',
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_array_key`),
-UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_translation`),
-PRIMARY KEY (`network_translate_id`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Cache for all queried APIs'");
-
- // Data from the webmaster (you!)
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_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,
-`network_api_password` VARCHAR(255) NOT NULL DEFAULT '',
-`network_site_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
-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!)'");
-
- // 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` (
-`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,
-`max_reload_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`min_waiting_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`min_remain_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-`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)'");
-
- // 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` (
-`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',
-UNIQUE `provider_type` (`network_id`,`network_type_id`),
-PRIMARY KEY (`network_cache_id`)
-) TYPE={?_TABLE_TYPE?} 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` (
-`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,
-`network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
-UNIQUE `provider_type` (`network_id`,`network_type_id`),
-PRIMARY KEY (`network_reload_id`)
-) TYPE={?_TABLE_TYPE?} COMMENT='Reload locks'");
-
- // Insert error code types
- // - Affiliate id or interface password wrong
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('AFF_ID_PASS_WRONG')");
- // - Webmaster's site id is not assigned (invalid, different affiliate id)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_NOT_ASSIGNED')");
- // - Webmaster's site id is locked
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_LOCKED')");
- // - General error in interface data
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('INTERFACE_DATA_ERROR')");
- // - Request amount depleted
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('REQUESTS_DEPLETED')");
- // - No campaigns found for given criteria (but maybe there are with more widen criteria)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND')");
- // - No campaigns found with allowed interface output (but there are maybe non-interface campaigns)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND_INTERFACE')");
- // - Webmaster's site id is not unlocked for choosen type
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_NOT_ALLOWED_TYPE')");
- // - Request parameters incomplete
- 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
-('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'),
-('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'),
-('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.de?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'),
-('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')");
-
- // 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
-(1, 1, 'banner', 'http://www.a3h.de/interface/out_banner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
-(2, 1, 'textlink', 'http://www.a3h.de/interface/out_textlink.php', 'http://www.a3h.de/textlinkklick.php?id=%CID%', NULL),
-(3, 1, 'surfbar', 'http://www.a3h.de/interface/out_sbanner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
-(4, 1, 'forcedbanner', 'http://www.a3h.de/interface/out_fbanner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
-(5, 1, 'textmail', 'http://www.a3h.de/interface/out_paidmail.php', 'http://www.a3h.de/emailf.php?id=%CID%', NULL),
-(6, 1, 'layer', 'http://www.a3h.de/interface/out_layer.php', 'http://www.a3h.de/layer.php?id=%CID%', NULL),
-(7, 1, 'popup', 'http://www.a3h.de/interface/out_popup.php', 'http://www.a3h.de/popup.php?id=%CID%', NULL),
-(8, 1, 'popdown', 'http://www.a3h.de/interface/out_popdown.php', 'http://www.a3h.de/popdown.php?id=%CID%', NULL),
-(9, 1, 'lead', 'http://www.a3h.de/interface/out_lead.php', 'http://www.a3h.de/lead.php?id=%CID%', NULL),
-(10, 1, 'sale', 'http://www.a3h.de/interface/out_sale.php', 'http://www.a3h.de/sale.php?id=%CID%', NULL),
-(11, 1, 'htmlmail', 'http://www.a3h.de/interface/out_paidmail.php', 'http://www.a3h.de/emailf.php?id=%CID%', NULL)");
-
- // Network type handlers - AbisZED-Netz
-
- // Network type handlers - Ad-Magnet
-
- // Network type handlers - AdCocktail
- 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
-(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 - Ads4
- 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
-(14, 5, 'forcedbanner', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/forced_click.php?fb_id=%CID%&sid=%SID%', 'http://www.ads4.de/forced_view.php?fb_id=%CID%&sid=%SID%'),
-(16, 5, 'htmlmail', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/paidmail_click.php?pm=%CID%&%sid=%SID%', NULL),
-(15, 5, 'textmail', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/paidmail_click.php?pm=%CID%&%sid=%SID%', NULL),
-(119, 5, 'traffic', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/traffic_click.php?tr_id=%CID%&sid=%SID%', '')");
-
- // Network type handlers - Ads4Webbis
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(20, 6, 'banner_click', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(19, 6, 'banner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(22, 6, 'button_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(17, 6, 'forcedbanner', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(18, 6, 'forcedtextlink', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(24, 6, 'popup', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(21, 6, 'skybanner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(23, 6, 'textlink_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(25, 6, 'textmail', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(120, 6, 'traffic', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
-
- // Network type handlers - Ads4World
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(29, 7, 'banner_click', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(28, 7, 'banner_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(31, 7, 'button_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(26, 7, 'forcedbanner', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(27, 7, 'forcedtextlink', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(33, 7, 'popup', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(30, 7, 'skybanner_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(32, 7, 'textlink_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(34, 7, 'textmail', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(121, 7, 'traffic', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
-
- // Network type handlers - Affiliblatt
-
- // Network type handlers - Alster-Marketing
- 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
-(35, 9, 'banner_click', 'http://if.alstermarketing.de/interface/out_banner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
-(45, 9, 'banner_view', 'http://if.alstermarketing.de/interface/out_banner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
-(38, 9, 'forcedbanner', 'http://if.alstermarketing.de/interface/out_fbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
-(48, 9, 'htmlmail', 'http://if.alstermarketing.de/interface/out_paidmail.php', 'http://www.alstermarketing.de/emailf.php?id=%CID%', NULL),
-(40, 9, 'layer_click', 'http://if.alstermarketing.de/interface/out_layer.php', 'http://www.alstermarketing.de/layer.php?id=%CID%', NULL),
-(49, 9, 'layer_view', 'http://if.alstermarketing.de/interface/out_layer.php', 'http://www.alstermarketing.de/layer.php?id=%CID%', NULL),
-(43, 9, 'lead', 'http://if.alstermarketing.de/interface/out_lead.php', 'http://www.alstermarketing.de/lead.php?id=%CID%', NULL),
-(42, 9, 'popdown', 'http://if.alstermarketing.de/interface/out_popdown.php', 'http://www.alstermarketing.de/popdown.php?id=%CID%', NULL),
-(41, 9, 'popup', 'http://if.alstermarketing.de/interface/out_popup.php', 'http://www.alstermarketing.de/popup.php?id=%CID%', NULL),
-(44, 9, 'sale', 'http://if.alstermarketing.de/interface/out_sale.php', 'http://www.alstermarketing.de/sale.php?id=%CID%', NULL),
-(37, 9, 'surfbar_click', 'http://if.alstermarketing.de/interface/out_sbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
-(47, 9, 'surfbar_view', 'http://if.alstermarketing.de/interface/out_sbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
-(36, 9, 'textlink_click', 'http://if.alstermarketing.de/interface/out_textlink.php', 'http://www.alstermarketing.de/textlinkklick.php?id=%CID%', NULL),
-(46, 9, 'textlink_view', 'http://if.alstermarketing.de/interface/out_textlink.php', 'http://www.alstermarketing.de/textlinkklick.php?id=%CID%', NULL),
-(39, 9, 'textmail', 'http://if.alstermarketing.de/interface/out_paidmail.php', 'http://www.alstermarketing.de/emailf.php?id=%CID%', NULL)");
-
- // Network type handlers - BonusSponsor
- 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
-(50, 10, 'banner_click', 'http://www.bonussponsor.de/interface/out_banner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
-(51, 10, 'banner_view', 'http://www.bonussponsor.de/interface/out_banner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
-(54, 10, 'forcedbanner', 'http://www.bonussponsor.de/interface/out_fbanner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
-(56, 10, 'htmlmail', 'http://www.bonussponsor.de/interface/out_paidmail.php', 'http://www.bonussponsor.de/emailf.php?id=%CID%', NULL),
-(57, 10, 'layer_click', 'http://www.bonussponsor.de/interface/out_layer.php', 'http://www.bonussponsor.de/layer.php?id=%CID%', NULL),
-(58, 10, 'layer_view', 'http://www.bonussponsor.de/interface/out_layer.php', 'http://www.bonussponsor.de/layer.php?id=%CID%', NULL),
-(61, 10, 'lead', 'http://www.bonussponsor.de/interface/out_lead.php', 'http://www.bonussponsor.de/lead.php?id=%CID%', NULL),
-(60, 10, 'popdown', 'http://www.bonussponsor.de/interface/out_popdown.php', 'http://www.bonussponsor.de/popdown.php?id=%CID%', NULL),
-(59, 10, 'popup', 'http://www.bonussponsor.de/interface/out_popup.php', 'http://www.bonussponsor.de/popup.php?id=%CID%', NULL),
-(62, 10, 'sale', 'http://www.bonussponsor.de/interface/out_sale.php', 'http://www.bonussponsor.de/sale.php?id=%CID%', NULL),
-(52, 10, 'textlink_click', 'http://www.bonussponsor.de/interface/out_textlink.php', 'http://www.bonussponsor.de/textlinkklick.php?id=%CID%', NULL),
-(53, 10, 'textlink_view', 'http://www.bonussponsor.de/interface/out_textlink.php', 'http://www.bonussponsor.de/textlinkklick.php?id=%CID%', NULL),
-(55, 10, 'textmail', 'http://www.bonussponsor.de/interface/out_paidmail.php', 'http://www.bonussponsor.de/emailf.php?id=%CID%', NULL)");
-
- // Network type handlers - Fusion-Ads
-
- // 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
-(102, 12, 'banner_view', 'http://www.gigapromo.de/interface/output_viewbanner.php', 'http://www.gigapromo.de/view/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.gigapromo.de/view/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(104, 12, 'forcedbanner', 'http://www.gigapromo.de/interface/output_forcedbanner.php', 'http://www.gigapromo.de/view/forcedclickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.gigapromo.de/view/forcedviewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(105, 12, 'forcedtextlink', 'http://www.gigapromo.de/interface/output_forcedtextlink.php', 'http://www.gigapromo.de/view/forcedclicktextlink.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(103, 12, 'layer_view', 'http://www.gigapromo.de/interface/output_layerviews.php', 'http://www.gigapromo.de/view/layer.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(108, 12, 'popdown', 'http://www.gigapromo.de/interface/output_popdown.php', 'http://www.gigapromo.de/view/popdown.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(107, 12, 'popup', 'http://www.gigapromo.de/interface/output_popup.php', 'http://www.gigapromo.de/view/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(106, 12, 'textmail', 'http://www.gigapromo.de/interface/output_paidmails.php', 'http://www.gigapromo.de/view/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(122, 12, 'traffic', 'http://www.gigapromo.de/interface/output_traffic.php', 'http://www.gigapromo.de/view/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', 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, 13, 'banner_click', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(136, 13, 'banner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(137, 13, 'button_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(138, 13, 'forcedbanner', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(139, 13, 'forcedtextlink', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(140, 13, 'popup', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(141, 13, 'skybanner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(142, 13, 'textlink_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(143, 13, 'textmail', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(144, 13, 'traffic', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%CID%', NULL)");
-
- // Network type handlers - Make-Euros
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(63, 14, 'banner_click', 'http://www.make-euros.de/interface/out_banner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
-(64, 14, 'banner_view', 'http://www.make-euros.de/interface/out_banner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
-(68, 14, 'forcedbanner', 'http://www.make-euros.de/interface/out_fbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
-(71, 14, 'htmlmail', 'http://www.make-euros.de/interface/out_paidmail.php', 'http://www.make-euros.de/emailf.php?id=%CID%', NULL),
-(72, 14, 'layer_click', 'http://www.make-euros.de/interface/out_layer.php', 'http://www.make-euros.de/layer.php?id=%CID%', NULL),
-(73, 14, 'layer_view', 'http://www.make-euros.de/interface/out_layer.php', 'http://www.make-euros.de/layer.php?id=%CID%', NULL),
-(76, 14, 'lead', 'http://www.make-euros.de/interface/out_lead.php', 'http://www.make-euros.de/lead.php?id=%CID%', NULL),
-(75, 14, 'popdown', 'http://www.make-euros.de/interface/out_popdown.php', 'http://www.make-euros.de/popdown.php?id=%CID%', NULL),
-(74, 14, 'popup', 'http://www.make-euros.de/interface/out_popup.php', 'http://www.make-euros.de/popup.php?id=%CID%', NULL),
-(77, 14, 'sale', 'http://www.make-euros.de/interface/out_sale.php', 'http://www.make-euros.de/sale.php?id=%CID%', NULL),
-(67, 14, 'surfbar_click', 'http://www.make-euros.de/interface/out_sbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
-(69, 14, 'surfbar_view', 'http://www.make-euros.de/interface/out_sbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
-(65, 14, 'textlink_click', 'http://www.make-euros.de/interface/out_textlink.php', 'http://www.make-euros.de/textlinkklick.php?id=%CID%', NULL),
-(66, 14, 'textlink_view', 'http://www.make-euros.de/interface/out_textlink.php', 'http://www.make-euros.de/textlinkklick.php?id=%CID%', NULL),
-(70, 14, 'textmail', 'http://www.make-euros.de/interface/out_paidmail.php', 'http://www.make-euros.de/emailf.php?id=%CID%', NULL)");
-
- // Network type handlers - Mega-Ad
- 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
-(112, 15, 'banner_click', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/view.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(111, 15, 'banner_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(114, 15, 'button_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(109, 15, 'forcedbanner', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(110, 15, 'forcedtextlink', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(116, 15, 'popup', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(113, 15, 'skybanner_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(115, 15, 'textlink_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(117, 15, 'textmail', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(123, 15, 'traffic', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
-
- // Network type handlers - Power-Promo
- 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
-(78, 16, 'banner_click', 'http://www.power-promo.de/interface/out_banner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
-(79, 16, 'banner_view', 'http://www.power-promo.de/interface/out_banner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
-(84, 16, 'forcedbanner', 'http://www.power-promo.de/interface/out_fbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
-(86, 16, 'htmlmail', 'http://www.power-promo.de/interface/out_paidmail.php', 'http://www.power-promo.de/emailf.php?id=%CID%', NULL),
-(87, 16, 'layer_click', 'http://www.power-promo.de/interface/out_layer.php', 'http://www.power-promo.de/layer.php?id=%CID%', NULL),
-(88, 16, 'layer_view', 'http://www.power-promo.de/interface/out_layer.php', 'http://www.power-promo.de/layer.php?id=%CID%', NULL),
-(91, 16, 'lead', 'http://www.power-promo.de/interface/out_lead.php', 'http://www.power-promo.de/lead.php?id=%CID%', NULL),
-(90, 16, 'popdown', 'http://www.power-promo.de/interface/out_popdown.php', 'http://www.power-promo.de/popdown.php?id=%CID%', NULL),
-(89, 16, 'popup', 'http://www.power-promo.de/interface/out_popup.php', 'http://www.power-promo.de/popup.php?id=%CID%', NULL),
-(92, 16, 'sale', 'http://www.power-promo.de/interface/out_sale.php', 'http://www.power-promo.de/sale.php?id=%CID%', NULL),
-(82, 16, 'surfbar_click', 'http://www.power-promo.de/interface/out_sbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
-(83, 16, 'surfbar_view', 'http://www.power-promo.de/interface/out_sbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
-(80, 16, 'textlink_click', 'http://www.power-promo.de/interface/out_textlink.php', 'http://www.power-promo.de/textlinkklick.php?id=%CID%', NULL),
-(81, 16, 'textlink_view', 'http://www.power-promo.de/interface/out_textlink.php', 'http://www.power-promo.de/textlinkklick.php?id=%CID%', NULL),
-(85, 16, 'textmail', 'http://www.power-promo.de/interface/out_paidmail.php', 'http://www.power-promo.de/emailf.php?id=%CID%', NULL)");
-
- // 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
-(96, 17, '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%'),
-(95, 17, '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%'),
-(98, 17, '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%'),
-(93, 17, '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, 17, 'forcedtextlink', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(100, 17, 'popup', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(97, 17, '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%'),
-(99, 17, 'textlink_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(101, 17, 'textmail', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(124, 17, 'traffic', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
-
- // Network type handlers - UltraPROMO
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(125, 18, 'banner_click', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(126, 18, 'banner_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(127, 18, 'button_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(128, 18, 'forcedbanner', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(129, 18, 'forcedtextlink', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(130, 18, 'popup', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(131, 18, 'skybanner_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ultrapromo.eu/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(132, 18, 'textlink_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(133, 18, 'textmail', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(134, 18, 'traffic', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
-
- // Network type handlers - Der Werbepartner.cc
-
- // Network type handlers - Yoo!Media
-
- // Request parameters per type handler - A3H
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(1, 1, 1, 'id', 'id', NULL),
-(2, 1, 1, 'sid', 'sid', NULL),
-(3, 1, 1, 'password', 'pw', NULL),
-(4, 1, 1, 'reload', 'reload', NULL),
-(5, 1, 1, 'reward', 'verguetung', NULL),
-(6, 1, 1, 'min_stay', 'ma', NULL),
-(7, 1, 1, 'type', 'typ', NULL),
-(8, 1, 1, 'remain', 'uebrig', NULL),
-(9, 1, 1, 'size', 'size', NULL),
-(10, 1, 2, 'id', 'id', NULL),
-(11, 1, 2, 'sid', 'sid', NULL),
-(12, 1, 2, 'password', 'pw', NULL),
-(13, 1, 2, 'reload', 'reload', NULL),
-(14, 1, 2, 'reward', 'verguetung', NULL),
-(15, 1, 2, 'remain', 'uebrig', NULL),
-(16, 1, 3, 'id', 'id', NULL),
-(17, 1, 3, 'sid', 'sid', NULL),
-(18, 1, 3, 'password', 'pw', NULL),
-(19, 1, 3, 'reload', 'reload', NULL),
-(20, 1, 3, 'reward', 'verguetung', NULL),
-(21, 1, 3, 'type', 'typ', NULL),
-(22, 1, 3, 'remain', 'uebrig', NULL),
-(23, 1, 3, 'size', 'size', NULL),
-(24, 1, 4, 'id', 'id', NULL),
-(25, 1, 4, 'sid', 'sid', NULL),
-(26, 1, 4, 'password', 'pw', NULL),
-(27, 1, 4, 'reload', 'reload', NULL),
-(28, 1, 4, 'reward', 'verguetung', NULL),
-(29, 1, 4, 'min_stay', 'ma', NULL),
-(30, 1, 4, 'remain', 'uebrig', NULL),
-(31, 1, 4, 'size', 'size', NULL),
-(32, 1, 5, 'id', 'id', NULL),
-(33, 1, 5, 'sid', 'sid', NULL),
-(34, 1, 5, 'password', 'pw', NULL),
-(35, 1, 5, 'reload', 'reload', NULL),
-(36, 1, 5, 'reward', 'verguetung', NULL),
-(37, 1, 5, 'min_stay', 'ma', NULL),
-(38, 1, 5, 'type', 'typ', 'text'),
-(39, 1, 5, 'remain', 'uebrig', NULL),
-(40, 1, 11, 'id', 'id', NULL),
-(41, 1, 11, 'sid', 'sid', NULL),
-(42, 1, 11, 'password', 'pw', NULL),
-(43, 1, 11, 'reload', 'reload', NULL),
-(44, 1, 11, 'reward', 'verguetung', NULL),
-(45, 1, 11, 'min_stay', 'ma', NULL),
-(46, 1, 11, 'type', 'typ', 'html'),
-(47, 1, 11, 'remain', 'uebrig', NULL),
-(48, 1, 6, 'id', 'id', NULL),
-(49, 1, 6, 'sid', 'sid', NULL),
-(50, 1, 6, 'password', 'pw', NULL),
-(51, 1, 6, 'reload', 'reload', NULL),
-(52, 1, 6, 'reward', 'verguetung', NULL),
-(53, 1, 6, 'type', 'typ', NULL),
-(54, 1, 6, 'remain', 'uebrig', NULL),
-(55, 1, 7, 'id', 'id', NULL),
-(56, 1, 7, 'sid', 'sid', NULL),
-(57, 1, 7, 'password', 'pw', NULL),
-(58, 1, 7, 'reload', 'reload', NULL),
-(59, 1, 7, 'reward', 'verguetung', NULL),
-(60, 1, 7, 'min_stay', 'ma', NULL),
-(61, 1, 7, 'remain', 'uebrig', NULL),
-(62, 1, 8, 'id', 'id', NULL),
-(63, 1, 8, 'sid', 'sid', NULL),
-(64, 1, 8, 'password', 'pw', NULL),
-(65, 1, 8, 'reload', 'reload', NULL),
-(66, 1, 8, 'reward', 'verguetung', NULL),
-(67, 1, 8, 'min_stay', 'ma', NULL),
-(68, 1, 8, 'remain', 'uebrig', NULL),
-(69, 1, 9, 'id', 'id', NULL),
-(70, 1, 9, 'sid', 'sid', NULL),
-(71, 1, 9, 'password', 'pw', NULL),
-(72, 1, 9, 'reward', 'verguetung', NULL),
-(73, 1, 9, 'remain', 'uebrig', NULL),
-(74, 1, 10, 'id', 'id', NULL),
-(75, 1, 10, 'sid', 'sid', NULL),
-(76, 1, 10, 'password', 'pw', NULL),
-(77, 1, 10, 'reward', 'verguetung', NULL),
-(78, 1, 10, 'remain', 'uebrig', NULL)");
-
- // Request parameters per type handler - AbisZED-Netz
-
- // Request parameters per type handler - Ad-Magnet
-
- // Request parameters per type handler - AdCocktail
-
- // Request parameters per type handler - Ads4
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(79, 5, 14, 'id', 'id', NULL),
-(80, 5, 14, 'password', 'pwd', NULL),
-(81, 5, 14, 'currency', 'waehrung', NULL),
-(82, 5, 14, 'extra', 'mediatype', 'forced_banner'),
-(83, 5, 14, 'reward', 'verg', NULL),
-(84, 5, 14, 'reload', 'reload', NULL),
-(85, 5, 14, 'remain', 'uebrig', NULL),
-(86, 5, 14, 'min_stay', 'ma', NULL),
-(87, 5, 15, 'id', 'id', NULL),
-(88, 5, 15, 'password', 'pwd', NULL),
-(89, 5, 15, 'currency', 'waehrung', NULL),
-(90, 5, 15, 'extra', 'mediatype', 'textmails'),
-(91, 5, 15, 'reward', 'verg', NULL),
-(92, 5, 15, 'reload', 'reload', NULL),
-(93, 5, 15, 'remain', 'uebrig', NULL),
-(94, 5, 15, 'min_stay', 'ma', NULL),
-(95, 5, 16, 'id', 'id', NULL),
-(96, 5, 16, 'password', 'pw', NULL),
-(97, 5, 16, 'currency', 'waehrung', NULL),
-(98, 5, 16, 'extra', 'mediatype', 'htmlmails'),
-(99, 5, 16, 'reward', 'verg', NULL),
-(100, 5, 16, 'reload', 'reload', NULL),
-(101, 5, 16, 'remain', 'uebrig', NULL),
-(102, 5, 16, 'min_stay', 'ma', NULL),
-(789, 5, 119, 'id', 'id', NULL),
-(790, 5, 119, 'password', 'pwd', NULL),
-(791, 5, 119, 'currency', 'waehrung', NULL),
-(792, 5, 119, 'extra', 'mediatype', 'traffic'),
-(793, 5, 119, 'reward', 'verg', NULL),
-(794, 5, 119, 'reload', 'reload', NULL),
-(795, 5, 119, 'remain', 'uebrig', NULL),
-(796, 5, 119, 'min_stay', 'ma', NULL)");
-
- // Request parameters per type handler - Ads4Webbis
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(103, 6, 20, 'extra', 'typ', 'bannerklick'),
-(104, 6, 20, 'id', 'id', NULL),
-(105, 6, 20, 'password', 'pw', NULL),
-(106, 6, 20, 'remain', 'uebrig', NULL),
-(107, 6, 20, 'reload', 'reload', NULL),
-(108, 6, 20, 'reward', 'verguetung', NULL),
-(109, 6, 17, 'extra', 'typ', 'forcedbanner'),
-(110, 6, 17, 'id', 'id', NULL),
-(111, 6, 17, 'password', 'pw', NULL),
-(112, 6, 17, 'remain', 'uebrig', NULL),
-(113, 6, 17, 'reload', 'reload', NULL),
-(114, 6, 17, 'reward', 'verguetung', NULL),
-(115, 6, 18, 'extra', 'typ', 'forcedtextlink'),
-(116, 6, 18, 'id', 'id', NULL),
-(117, 6, 18, 'password', 'pw', NULL),
-(118, 6, 18, 'remain', 'uebrig', NULL),
-(119, 6, 18, 'reload', 'reload', NULL),
-(120, 6, 18, 'reward', 'verguetung', NULL),
-(121, 6, 19, 'extra', 'typ', 'bannerview'),
-(122, 6, 19, 'id', 'id', NULL),
-(123, 6, 19, 'password', 'pw', NULL),
-(124, 6, 19, 'remain', 'uebrig', NULL),
-(125, 6, 19, 'reload', 'reload', NULL),
-(126, 6, 19, 'reward', 'verguetung', NULL),
-(127, 6, 21, 'extra', 'typ', 'skybannerview'),
-(128, 6, 21, 'id', 'id', NULL),
-(129, 6, 21, 'password', 'pw', NULL),
-(130, 6, 21, 'remain', 'uebrig', NULL),
-(131, 6, 21, 'reload', 'reload', NULL),
-(132, 6, 21, 'reward', 'verguetung', NULL),
-(133, 6, 22, 'extra', 'typ', 'buttonview'),
-(134, 6, 22, 'id', 'id', NULL),
-(135, 6, 22, 'password', 'pw', NULL),
-(136, 6, 22, 'remain', 'uebrig', NULL),
-(137, 6, 22, 'reload', 'reload', NULL),
-(138, 6, 22, 'reward', 'verguetung', NULL),
-(139, 6, 23, 'extra', 'typ', 'textview'),
-(140, 6, 23, 'id', 'id', NULL),
-(141, 6, 23, 'password', 'pw', NULL),
-(142, 6, 23, 'remain', 'uebrig', NULL),
-(143, 6, 23, 'reload', 'reload', NULL),
-(144, 6, 23, 'reward', 'verguetung', NULL),
-(145, 6, 24, 'extra', 'typ', 'popup'),
-(146, 6, 24, 'id', 'id', NULL),
-(147, 6, 24, 'password', 'pw', NULL),
-(148, 6, 24, 'remain', 'uebrig', NULL),
-(149, 6, 24, 'reload', 'reload', NULL),
-(150, 6, 24, 'reward', 'verguetung', NULL),
-(151, 6, 24, 'min_stay', 'ma', NULL),
-(152, 6, 25, 'extra', 'typ', 'paidmail'),
-(153, 6, 25, 'id', 'id', NULL),
-(154, 6, 25, 'password', 'pw', NULL),
-(155, 6, 25, 'remain', 'uebrig', NULL),
-(156, 6, 25, 'reload', 'reload', NULL),
-(157, 6, 25, 'reward', 'verguetung', NULL),
-(158, 6, 25, 'min_stay', 'ma', NULL),
-(797, 6, 120, 'extra', 'typ', 'traffic'),
-(798, 6, 120, 'id', 'id', NULL),
-(799, 6, 120, 'password', 'pw', NULL),
-(800, 6, 120, 'remain', 'uebrig', NULL),
-(801, 6, 120, 'reload', 'reload', NULL),
-(802, 6, 120, 'reward', 'verguetung', NULL)");
-
- // Request parameters per type handler - Ads4World
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(159, 7, 29, 'extra', 'typ', 'bannerklick'),
-(160, 7, 29, 'id', 'id', NULL),
-(161, 7, 29, 'password', 'pw', NULL),
-(162, 7, 29, 'remain', 'uebrig', NULL),
-(163, 7, 29, 'reload', 'reload', NULL),
-(164, 7, 29, 'reward', 'verguetung', NULL),
-(165, 7, 28, 'extra', 'typ', 'bannerview'),
-(166, 7, 28, 'id', 'id', NULL),
-(167, 7, 28, 'password', 'pw', NULL),
-(168, 7, 28, 'remain', 'uebrig', NULL),
-(169, 7, 28, 'reload', 'reload', NULL),
-(170, 7, 28, 'reward', 'verguetung', NULL),
-(171, 7, 31, 'extra', 'typ', 'buttonview'),
-(172, 7, 31, 'id', 'id', NULL),
-(173, 7, 31, 'password', 'pw', NULL),
-(174, 7, 31, 'remain', 'uebrig', NULL),
-(175, 7, 31, 'reload', 'reload', NULL),
-(176, 7, 31, 'reward', 'verguetung', NULL),
-(177, 7, 26, 'extra', 'typ', 'forcedbanner'),
-(178, 7, 26, 'id', 'id', NULL),
-(179, 7, 26, 'password', 'pw', NULL),
-(180, 7, 26, 'remain', 'uebrig', NULL),
-(181, 7, 26, 'reload', 'reload', NULL),
-(182, 7, 26, 'reward', 'verguetung', NULL),
-(183, 7, 27, 'extra', 'typ', 'forcedtextlink'),
-(184, 7, 27, 'id', 'id', NULL),
-(185, 7, 27, 'password', 'pw', NULL),
-(186, 7, 27, 'remain', 'uebrig', NULL),
-(187, 7, 27, 'reload', 'reload', NULL),
-(188, 7, 27, 'reward', 'verguetung', NULL),
-(189, 7, 33, 'extra', 'typ', 'popup'),
-(190, 7, 33, 'id', 'id', NULL),
-(191, 7, 33, 'password', 'pw', NULL),
-(192, 7, 33, 'remain', 'uebrig', NULL),
-(193, 7, 33, 'reload', 'reload', NULL),
-(194, 7, 33, 'reward', 'verguetung', NULL),
-(195, 7, 33, 'min_stay', 'ma', NULL),
-(196, 7, 30, 'extra', 'typ', 'skybannerview'),
-(197, 7, 30, 'id', 'id', NULL),
-(198, 7, 30, 'password', 'pw', NULL),
-(199, 7, 30, 'remain', 'uebrig', NULL),
-(200, 7, 30, 'reload', 'reload', NULL),
-(201, 7, 30, 'reward', 'verguetung', NULL),
-(202, 7, 32, 'extra', 'typ', 'textview'),
-(203, 7, 32, 'id', 'id', NULL),
-(204, 7, 32, 'password', 'pw', NULL),
-(205, 7, 32, 'remain', 'uebrig', NULL),
-(206, 7, 32, 'reload', 'reload', NULL),
-(207, 7, 32, 'reward', 'verguetung', NULL),
-(208, 7, 34, 'extra', 'typ', 'textmails'),
-(209, 7, 34, 'id', 'id', NULL),
-(210, 7, 34, 'password', 'pw', NULL),
-(211, 7, 34, 'remain', 'uebrig', NULL),
-(212, 7, 34, 'reload', 'reload', NULL),
-(213, 7, 34, 'reward', 'verguetung', NULL),
-(214, 7, 34, 'min_stay', 'ma', NULL),
-(803, 7, 121, 'extra', 'typ', 'traffic'),
-(804, 7, 121, 'id', 'id', NULL),
-(805, 7, 121, 'password', 'pw', NULL),
-(806, 7, 121, 'remain', 'uebrig', NULL),
-(807, 7, 121, 'reload', 'reload', NULL),
-(808, 7, 121, 'reward', 'verguetung', NULL)");
-
- // Request parameters per type handler - Affiliblatt
-
- // Request parameters per type handler - Alster-Marketing
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(215, 9, 35, 'id', 'id', NULL),
-(216, 9, 35, 'sid', 'sid', NULL),
-(217, 9, 35, 'password', 'pw', NULL),
-(218, 9, 35, 'reward', 'verguetung', NULL),
-(219, 9, 35, 'reload', 'reload', NULL),
-(220, 9, 35, 'remain', 'uebrig', NULL),
-(221, 9, 35, 'type', 'typ', 'klick'),
-(222, 9, 35, 'size', 'size', NULL),
-(223, 9, 45, 'id', 'id', NULL),
-(224, 9, 45, 'sid', 'sid', NULL),
-(225, 9, 45, 'password', 'pw', NULL),
-(226, 9, 45, 'reward', 'verguetung', NULL),
-(227, 9, 45, 'reload', 'reload', NULL),
-(228, 9, 45, 'remain', 'uebrig', NULL),
-(229, 9, 45, 'type', 'typ', 'view'),
-(230, 9, 45, 'size', 'size', NULL),
-(231, 9, 36, 'id', 'id', NULL),
-(232, 9, 36, 'sid', 'sid', NULL),
-(233, 9, 36, 'password', 'pw', NULL),
-(234, 9, 36, 'reward', 'verguetung', NULL),
-(235, 9, 36, 'reload', 'reload', NULL),
-(236, 9, 36, 'remain', 'uebrig', NULL),
-(237, 9, 36, 'type', 'typ', 'klick'),
-(238, 9, 46, 'id', 'id', NULL),
-(239, 9, 46, 'sid', 'sid', NULL),
-(240, 9, 46, 'password', 'pw', NULL),
-(241, 9, 46, 'reward', 'verguetung', NULL),
-(242, 9, 46, 'reload', 'reload', NULL),
-(243, 9, 46, 'remain', 'uebrig', NULL),
-(244, 9, 46, 'type', 'typ', 'view'),
-(245, 9, 37, 'id', 'id', NULL),
-(246, 9, 37, 'sid', 'sid', NULL),
-(247, 9, 37, 'password', 'pw', NULL),
-(248, 9, 37, 'reward', 'verguetung', NULL),
-(249, 9, 37, 'reload', 'reload', NULL),
-(250, 9, 37, 'remain', 'uebrig', NULL),
-(251, 9, 37, 'type', 'typ', 'klick'),
-(252, 9, 37, 'size', 'size', NULL),
-(253, 9, 47, 'id', 'id', NULL),
-(254, 9, 47, 'sid', 'sid', NULL),
-(255, 9, 47, 'password', 'pw', NULL),
-(256, 9, 47, 'reward', 'verguetung', NULL),
-(257, 9, 47, 'reload', 'reload', NULL),
-(258, 9, 47, 'remain', 'uebrig', NULL),
-(259, 9, 47, 'type', 'typ', 'view'),
-(260, 9, 47, 'size', 'size', NULL),
-(261, 9, 38, 'id', 'id', NULL),
-(262, 9, 38, 'sid', 'sid', NULL),
-(263, 9, 38, 'password', 'pw', NULL),
-(264, 9, 38, 'reward', 'verguetung', NULL),
-(265, 9, 38, 'reload', 'reload', NULL),
-(266, 9, 38, 'remain', 'uebrig', NULL),
-(267, 9, 38, 'size', 'size', NULL),
-(268, 9, 38, 'min_stay', 'ma', NULL),
-(269, 9, 39, 'id', 'id', NULL),
-(270, 9, 39, 'sid', 'sid', NULL),
-(271, 9, 39, 'password', 'pw', NULL),
-(272, 9, 39, 'reward', 'verguetung', NULL),
-(273, 9, 39, 'reload', 'reload', NULL),
-(274, 9, 39, 'remain', 'uebrig', NULL),
-(275, 9, 39, 'min_stay', 'ma', NULL),
-(276, 9, 39, 'type', 'typ', 'text'),
-(277, 9, 48, 'id', 'id', NULL),
-(278, 9, 48, 'sid', 'sid', NULL),
-(279, 9, 48, 'password', 'pw', NULL),
-(280, 9, 48, 'reward', 'verguetung', NULL),
-(281, 9, 48, 'reload', 'reload', NULL),
-(282, 9, 48, 'remain', 'uebrig', NULL),
-(283, 9, 48, 'min_stay', 'ma', NULL),
-(284, 9, 48, 'type', 'typ', 'html'),
-(285, 9, 40, 'id', 'id', NULL),
-(286, 9, 40, 'sid', 'sid', NULL),
-(287, 9, 40, 'password', 'pw', NULL),
-(288, 9, 40, 'reward', 'verguetung', NULL),
-(289, 9, 40, 'reload', 'reload', NULL),
-(290, 9, 40, 'remain', 'uebrig', NULL),
-(291, 9, 40, 'type', 'typ', 'klick'),
-(292, 9, 49, 'id', 'id', NULL),
-(293, 9, 49, 'sid', 'sid', NULL),
-(294, 9, 49, 'password', 'pw', NULL),
-(295, 9, 49, 'reward', 'verguetung', NULL),
-(296, 9, 49, 'reload', 'reload', NULL),
-(297, 9, 49, 'remain', 'uebrig', NULL),
-(298, 9, 49, 'type', 'typ', 'view'),
-(299, 9, 41, 'id', 'id', NULL),
-(300, 9, 41, 'sid', 'sid', NULL),
-(301, 9, 41, 'password', 'pw', NULL),
-(302, 9, 41, 'reward', 'verguetung', NULL),
-(303, 9, 41, 'reload', 'reload', NULL),
-(304, 9, 41, 'remain', 'uebrig', NULL),
-(305, 9, 41, 'min_stay', 'ma', NULL),
-(306, 9, 42, 'id', 'id', NULL),
-(307, 9, 42, 'sid', 'sid', NULL),
-(308, 9, 42, 'password', 'pw', NULL),
-(309, 9, 42, 'reward', 'verguetung', NULL),
-(310, 9, 42, 'reload', 'reload', NULL),
-(311, 9, 42, 'remain', 'uebrig', NULL),
-(312, 9, 42, 'min_stay', 'ma', NULL),
-(313, 9, 43, 'id', 'id', NULL),
-(314, 9, 43, 'sid', 'sid', NULL),
-(315, 9, 43, 'password', 'pw', NULL),
-(316, 9, 43, 'reward', 'verguetung', NULL),
-(317, 9, 43, 'remain', 'uebrig', NULL),
-(318, 9, 44, 'id', 'id', NULL),
-(319, 9, 44, 'sid', 'sid', NULL),
-(320, 9, 44, 'password', 'pw', NULL),
-(321, 9, 44, 'reward', 'verguetung', NULL),
-(322, 9, 44, 'remain', 'uebrig', NULL)");
-
- // Request parameters per type handler - BonusSponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(323, 10, 50, 'id', 'id', NULL),
-(324, 10, 50, 'sid', 'sid', NULL),
-(325, 10, 50, 'password', 'pw', NULL),
-(326, 10, 50, 'reward', 'verguetung', NULL),
-(327, 10, 50, 'reload', 'reload', NULL),
-(328, 10, 50, 'remain', 'uebrig', NULL),
-(329, 10, 50, 'type', 'typ', 'klick'),
-(330, 10, 50, 'size', 'size', NULL),
-(331, 10, 51, 'id', 'id', NULL),
-(332, 10, 51, 'sid', 'sid', NULL),
-(333, 10, 51, 'password', 'pw', NULL),
-(334, 10, 51, 'reward', 'verguetung', NULL),
-(335, 10, 51, 'reload', 'reload', NULL),
-(336, 10, 51, 'remain', 'uebrig', NULL),
-(337, 10, 51, 'type', 'typ', 'view'),
-(338, 10, 51, 'size', 'size', NULL),
-(339, 10, 52, 'id', 'id', NULL),
-(340, 10, 52, 'sid', 'sid', NULL),
-(341, 10, 52, 'password', 'pw', NULL),
-(342, 10, 52, 'reward', 'verguetung', NULL),
-(343, 10, 52, 'reload', 'reload', NULL),
-(344, 10, 52, 'remain', 'uebrig', NULL),
-(345, 10, 52, 'type', 'typ', 'klick'),
-(346, 10, 53, 'id', 'id', NULL),
-(347, 10, 53, 'sid', 'sid', NULL),
-(348, 10, 53, 'password', 'pw', NULL),
-(349, 10, 53, 'reward', 'verguetung', NULL),
-(350, 10, 53, 'reload', 'reload', NULL),
-(351, 10, 53, 'remain', 'uebrig', NULL),
-(352, 10, 53, 'type', 'typ', 'view'),
-(353, 10, 54, 'id', 'id', NULL),
-(354, 10, 54, 'sid', 'sid', NULL),
-(355, 10, 54, 'password', 'pw', NULL),
-(356, 10, 54, 'reward', 'verguetung', NULL),
-(357, 10, 54, 'reload', 'reload', NULL),
-(358, 10, 54, 'remain', 'uebrig', NULL),
-(359, 10, 54, 'size', 'size', NULL),
-(360, 10, 54, 'min_stay', 'ma', NULL),
-(361, 10, 55, 'id', 'id', NULL),
-(362, 10, 55, 'sid', 'sid', NULL),
-(363, 10, 55, 'password', 'pw', NULL),
-(364, 10, 55, 'reward', 'verguetung', NULL),
-(365, 10, 55, 'reload', 'reload', NULL),
-(366, 10, 55, 'remain', 'uebrig', NULL),
-(367, 10, 55, 'min_stay', 'ma', NULL),
-(368, 10, 55, 'type', 'typ', 'text'),
-(369, 10, 56, 'id', 'id', NULL),
-(370, 10, 56, 'sid', 'sid', NULL),
-(371, 10, 56, 'password', 'pw', NULL),
-(372, 10, 56, 'reward', 'verguetung', NULL),
-(373, 10, 56, 'reload', 'reload', NULL),
-(374, 10, 56, 'remain', 'uebrig', NULL),
-(375, 10, 56, 'min_stay', 'ma', NULL),
-(376, 10, 56, 'type', 'typ', 'html'),
-(377, 10, 57, 'id', 'id', NULL),
-(378, 10, 57, 'sid', 'sid', NULL),
-(379, 10, 57, 'password', 'pw', NULL),
-(380, 10, 57, 'reward', 'verguetung', NULL),
-(381, 10, 57, 'reload', 'reload', NULL),
-(382, 10, 57, 'remain', 'uebrig', NULL),
-(383, 10, 57, 'type', 'typ', 'klick'),
-(384, 10, 58, 'id', 'id', NULL),
-(385, 10, 58, 'sid', 'sid', NULL),
-(386, 10, 58, 'password', 'pw', NULL),
-(387, 10, 58, 'reward', 'verguetung', NULL),
-(388, 10, 58, 'reload', 'reload', NULL),
-(389, 10, 58, 'remain', 'uebrig', NULL),
-(390, 10, 58, 'type', 'typ', 'view'),
-(391, 10, 59, 'id', 'id', NULL),
-(392, 10, 59, 'sid', 'sid', NULL),
-(393, 10, 59, 'password', 'pw', NULL),
-(394, 10, 59, 'reward', 'verguetung', NULL),
-(395, 10, 59, 'reload', 'reload', NULL),
-(396, 10, 59, 'remain', 'uebrig', NULL),
-(397, 10, 59, 'min_stay', 'ma', NULL),
-(398, 10, 60, 'id', 'id', NULL),
-(399, 10, 60, 'sid', 'sid', NULL),
-(400, 10, 60, 'password', 'pw', NULL),
-(401, 10, 60, 'reward', 'verguetung', NULL),
-(402, 10, 60, 'reload', 'reload', NULL),
-(403, 10, 60, 'remain', 'uebrig', NULL),
-(404, 10, 60, 'min_stay', 'ma', NULL),
-(405, 10, 61, 'id', 'id', NULL),
-(406, 10, 61, 'sid', 'sid', NULL),
-(407, 10, 61, 'password', 'pw', NULL),
-(408, 10, 61, 'reward', 'verguetung', NULL),
-(409, 10, 61, 'remain', 'uebrig', NULL),
-(410, 10, 62, 'id', 'id', NULL),
-(411, 10, 62, 'sid', 'sid', NULL),
-(412, 10, 62, 'password', 'pw', NULL),
-(413, 10, 62, 'reward', 'verguetung', NULL),
-(414, 10, 62, 'remain', 'uebrig', NULL)");
-
- // Request parameters per type handler - Fusion-Ads
-
- // Request parameters per type handler - GigapPromo
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(687, 12, 102, 'id', 'id', NULL),
-(688, 12, 102, 'sid', 'aid', NULL),
-(689, 12, 102, 'password', 'pw', NULL),
-(690, 12, 102, 'reload', 'reload', NULL),
-(691, 12, 102, 'reward', 'verguetung', NULL),
-(692, 12, 102, 'remain', 'uebrig', NULL),
-(693, 12, 102, 'size', 'typ', NULL),
-(694, 12, 103, 'id', 'id', NULL),
-(695, 12, 103, 'sid', 'aid', NULL),
-(696, 12, 103, 'password', 'pw', NULL),
-(697, 12, 103, 'reload', 'reload', NULL),
-(698, 12, 103, 'reward', 'verguetung', NULL),
-(699, 12, 103, 'remain', 'uebrig', NULL),
-(700, 12, 104, 'id', 'id', NULL),
-(701, 12, 104, 'sid', 'aid', NULL),
-(702, 12, 104, 'password', 'pw', NULL),
-(703, 12, 104, 'reload', 'reload', NULL),
-(704, 12, 104, 'reward', 'verguetung', NULL),
-(705, 12, 104, 'remain', 'uebrig', NULL),
-(706, 12, 104, 'max_stay', 'ma', NULL),
-(707, 12, 105, 'id', 'id', NULL),
-(708, 12, 105, 'sid', 'aid', NULL),
-(709, 12, 105, 'password', 'pw', NULL),
-(710, 12, 105, 'reload', 'reload', NULL),
-(711, 12, 105, 'reward', 'verguetung', NULL),
-(712, 12, 105, 'remain', 'uebrig', NULL),
-(713, 12, 105, 'max_stay', 'ma', NULL),
-(714, 12, 106, 'id', 'id', NULL),
-(715, 12, 106, 'sid', 'aid', NULL),
-(716, 12, 106, 'password', 'pw', NULL),
-(717, 12, 106, 'reload', 'reload', NULL),
-(718, 12, 106, 'reward', 'verguetung', NULL),
-(719, 12, 106, 'remain', 'uebrig', NULL),
-(720, 12, 106, 'max_stay', 'ma', NULL),
-(721, 12, 107, 'id', 'id', NULL),
-(722, 12, 107, 'sid', 'aid', NULL),
-(723, 12, 107, 'password', 'pw', NULL),
-(724, 12, 107, 'reload', 'reload', NULL),
-(725, 12, 107, 'reward', 'verguetung', NULL),
-(726, 12, 107, 'remain', 'uebrig', NULL),
-(727, 12, 107, 'max_stay', 'ma', NULL),
-(728, 12, 108, 'id', 'id', NULL),
-(729, 12, 108, 'sid', 'aid', NULL),
-(730, 12, 108, 'password', 'pw', NULL),
-(731, 12, 108, 'reload', 'reload', NULL),
-(732, 12, 108, 'reward', 'verguetung', NULL),
-(733, 12, 108, 'remain', 'uebrig', NULL),
-(734, 12, 108, 'max_stay', 'ma', NULL)");
-
- // Request parameters per type handler - HPSponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(889, 13, 135, 'extra', 'typ', 'forcedbanner'),
-(890, 13, 135, 'id', 'id', NULL),
-(891, 13, 135, 'password', 'pw', NULL),
-(892, 13, 135, 'remain', 'uebrig', NULL),
-(893, 13, 135, 'reload', 'reload', NULL),
-(894, 13, 135, 'reward', 'verguetung', NULL),
-(895, 13, 136, 'extra', 'typ', 'forcedtextlink'),
-(896, 13, 136, 'id', 'id', NULL),
-(897, 13, 136, 'password', 'pw', NULL),
-(898, 13, 136, 'remain', 'uebrig', NULL),
-(899, 13, 136, 'reload', 'reload', NULL),
-(900, 13, 136, 'reward', 'verguetung', NULL),
-(901, 13, 137, 'extra', 'typ', 'bannerview'),
-(902, 13, 137, 'id', 'id', NULL),
-(903, 13, 137, 'password', 'pw', NULL),
-(904, 13, 137, 'remain', 'uebrig', NULL),
-(905, 13, 137, 'reload', 'reload', NULL),
-(906, 13, 137, 'reward', 'verguetung', NULL),
-(907, 13, 138, 'extra', 'typ', 'bannerklick'),
-(908, 13, 138, 'id', 'id', NULL),
-(909, 13, 138, 'password', 'pw', NULL),
-(910, 13, 138, 'remain', 'uebrig', NULL),
-(911, 13, 138, 'reload', 'reload', NULL),
-(912, 13, 138, 'reward', 'verguetung', NULL),
-(913, 13, 139, 'extra', 'typ', 'skybannerview'),
-(914, 13, 139, 'id', 'id', NULL),
-(915, 13, 139, 'password', 'pw', NULL),
-(916, 13, 139, 'remain', 'uebrig', NULL),
-(917, 13, 139, 'reload', 'reload', NULL),
-(918, 13, 139, 'reward', 'verguetung', NULL),
-(919, 13, 140, 'extra', 'typ', 'buttonview'),
-(920, 13, 140, 'id', 'id', NULL),
-(921, 13, 140, 'password', 'pw', NULL),
-(922, 13, 140, 'remain', 'uebrig', NULL),
-(923, 13, 140, 'reload', 'reload', NULL),
-(924, 13, 140, 'reward', 'verguetung', NULL),
-(925, 13, 141, 'extra', 'typ', 'textview'),
-(926, 13, 141, 'id', 'id', NULL),
-(927, 13, 141, 'password', 'pw', NULL),
-(928, 13, 141, 'remain', 'uebrig', NULL),
-(929, 13, 141, 'reload', 'reload', NULL),
-(930, 13, 141, 'reward', 'verguetung', NULL),
-(931, 13, 142, 'extra', 'typ', 'traffic'),
-(932, 13, 142, 'id', 'id', NULL),
-(933, 13, 142, 'password', 'pw', NULL),
-(934, 13, 142, 'remain', 'uebrig', NULL),
-(935, 13, 142, 'reload', 'reload', NULL),
-(936, 13, 142, 'reward', 'verguetung', NULL),
-(937, 13, 143, 'extra', 'typ', 'popup'),
-(938, 13, 143, 'id', 'id', NULL),
-(939, 13, 143, 'password', 'pw', NULL),
-(940, 13, 143, 'remain', 'uebrig', NULL),
-(941, 13, 143, 'reload', 'reload', NULL),
-(942, 13, 143, 'reward', 'verguetung', NULL),
-(943, 13, 143, 'min_stay', 'ma', NULL),
-(944, 13, 144, 'extra', 'typ', 'paidmail'),
-(945, 13, 144, 'id', 'id', NULL),
-(946, 13, 144, 'password', 'pw', NULL),
-(947, 13, 144, 'remain', 'uebrig', NULL),
-(948, 13, 144, 'reload', 'reload', NULL),
-(949, 13, 144, 'reward', 'verguetung', NULL),
-(950, 13, 144, 'min_stay', 'ma', NULL)");
-
- // Request parameters per type handler - Make-Euros
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(415, 14, 63, 'id', 'id', NULL),
-(416, 14, 63, 'sid', 'sid', NULL),
-(417, 14, 63, 'password', 'pw', NULL),
-(418, 14, 63, 'reward', 'verguetung', NULL),
-(419, 14, 63, 'reload', 'reload', NULL),
-(420, 14, 63, 'remain', 'uebrig', NULL),
-(421, 14, 63, 'type', 'typ', 'klick'),
-(422, 14, 63, 'size', 'size', NULL),
-(423, 14, 64, 'id', 'id', NULL),
-(424, 14, 64, 'sid', 'sid', NULL),
-(425, 14, 64, 'password', 'pw', NULL),
-(426, 14, 64, 'reward', 'verguetung', NULL),
-(427, 14, 64, 'reload', 'reload', NULL),
-(428, 14, 64, 'remain', 'uebrig', NULL),
-(429, 14, 64, 'type', 'typ', 'view'),
-(430, 14, 64, 'size', 'size', NULL),
-(431, 14, 65, 'id', 'id', NULL),
-(432, 14, 65, 'sid', 'sid', NULL),
-(433, 14, 65, 'password', 'pw', NULL),
-(434, 14, 65, 'reward', 'verguetung', NULL),
-(435, 14, 65, 'reload', 'reload', NULL),
-(436, 14, 65, 'remain', 'uebrig', NULL),
-(437, 14, 65, 'type', 'typ', 'klick'),
-(438, 14, 66, 'id', 'id', NULL),
-(439, 14, 66, 'sid', 'sid', NULL),
-(440, 14, 66, 'password', 'pw', NULL),
-(441, 14, 66, 'reward', 'verguetung', NULL),
-(442, 14, 66, 'reload', 'reload', NULL),
-(443, 14, 66, 'remain', 'uebrig', NULL),
-(444, 14, 66, 'type', 'typ', 'view'),
-(445, 14, 67, 'id', 'id', NULL),
-(446, 14, 67, 'sid', 'sid', NULL),
-(447, 14, 67, 'password', 'pw', NULL),
-(448, 14, 67, 'reward', 'verguetung', NULL),
-(449, 14, 67, 'reload', 'reload', NULL),
-(450, 14, 67, 'remain', 'uebrig', NULL),
-(451, 14, 67, 'typ', 'typ', 'klick'),
-(452, 14, 67, 'size', 'size', NULL),
-(453, 14, 69, 'id', 'id', NULL),
-(454, 14, 69, 'sid', 'sid', NULL),
-(455, 14, 69, 'password', 'pw', NULL),
-(456, 14, 69, 'reward', 'verguetung', NULL),
-(457, 14, 69, 'reload', 'reload', NULL),
-(458, 14, 69, 'remain', 'uebrig', NULL),
-(459, 14, 69, 'type', 'typ', 'view'),
-(460, 14, 69, 'size', 'size', NULL),
-(461, 14, 68, 'id', 'id', NULL),
-(462, 14, 68, 'sid', 'sid', NULL),
-(463, 14, 68, 'password', 'pw', NULL),
-(464, 14, 68, 'reward', 'verguetung', NULL),
-(465, 14, 68, 'reload', 'reload', NULL),
-(466, 14, 68, 'remain', 'uebrig', NULL),
-(467, 14, 68, 'size', 'size', NULL),
-(468, 14, 68, 'min_stay', 'ma', NULL),
-(469, 14, 70, 'id', 'id', NULL),
-(470, 14, 70, 'sid', 'sid', NULL),
-(471, 14, 70, 'password', 'pw', NULL),
-(472, 14, 70, 'reward', 'verguetung', NULL),
-(473, 14, 70, 'reload', 'reload', NULL),
-(474, 14, 70, 'remain', 'uebrig', NULL),
-(475, 14, 70, 'min_stay', 'ma', NULL),
-(476, 14, 70, 'type', 'typ', 'text'),
-(477, 14, 71, 'id', 'id', NULL),
-(478, 14, 71, 'sid', 'sid', NULL),
-(479, 14, 71, 'password', 'pw', NULL),
-(480, 14, 71, 'reward', 'verguetung', NULL),
-(481, 14, 71, 'reload', 'reload', NULL),
-(482, 14, 71, 'remain', 'uebrig', NULL),
-(483, 14, 71, 'min_stay', 'ma', NULL),
-(484, 14, 71, 'type', 'typ', 'html'),
-(485, 14, 72, 'id', 'id', NULL),
-(486, 14, 72, 'sid', 'sid', NULL),
-(487, 14, 72, 'password', 'pw', NULL),
-(488, 14, 72, 'reward', 'verguetung', NULL),
-(489, 14, 72, 'reload', 'reload', NULL),
-(490, 14, 72, 'remain', 'uebrig', NULL),
-(491, 14, 72, 'type', 'typ', 'klick'),
-(492, 14, 73, 'id', 'id', NULL),
-(493, 14, 73, 'sid', 'sid', NULL),
-(494, 14, 73, 'password', 'pw', NULL),
-(495, 14, 73, 'reward', 'verguetung', NULL),
-(496, 14, 73, 'reload', 'reload', NULL),
-(497, 14, 73, 'remain', 'uebrig', NULL),
-(498, 14, 73, 'type', 'typ', 'view'),
-(499, 14, 74, 'id', 'id', NULL),
-(500, 14, 74, 'sid', 'sid', NULL),
-(501, 14, 74, 'password', 'pw', NULL),
-(502, 14, 74, 'reward', 'verguetung', NULL),
-(503, 14, 74, 'reload', 'reload', NULL),
-(504, 14, 74, 'remain', 'uebrig', NULL),
-(505, 14, 74, 'min_stay', 'ma', NULL),
-(506, 14, 75, 'id', 'id', NULL),
-(507, 14, 75, 'sid', 'sid', NULL),
-(508, 14, 75, 'password', 'pw', NULL),
-(509, 14, 75, 'reward', 'verguetung', NULL),
-(510, 14, 75, 'reload', 'reload', NULL),
-(511, 14, 75, 'remain', 'uebrig', NULL),
-(512, 14, 75, 'min_stay', 'ma', NULL),
-(513, 14, 76, 'id', 'id', NULL),
-(514, 14, 76, 'sid', 'sid', NULL),
-(515, 14, 76, 'password', 'pw', NULL),
-(516, 14, 76, 'reward', 'verguetung', NULL),
-(517, 14, 76, 'remain', 'uebrig', NULL),
-(518, 14, 77, 'id', 'id', NULL),
-(519, 14, 77, 'sid', 'sid', NULL),
-(520, 14, 77, 'password', 'pw', NULL),
-(521, 14, 77, 'reward', 'verguetung', NULL),
-(522, 14, 77, 'remain', 'uebrig', NULL)");
-
- // Request parameters per type handler - Mega-Ad
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(735, 15, 109, 'extra', 'typ', 'forcedbanner'),
-(736, 15, 109, 'id', 'id', NULL),
-(737, 15, 109, 'password', 'pw', NULL),
-(738, 15, 109, 'remain', 'uebrig', NULL),
-(739, 15, 109, 'reload', 'reload', NULL),
-(740, 15, 109, 'reward', 'verguetung', NULL),
-(741, 15, 110, 'extra', 'typ', 'forcedtextlink'),
-(742, 15, 110, 'id', 'id', NULL),
-(743, 15, 110, 'password', 'pw', NULL),
-(744, 15, 110, 'remain', 'uebrig', NULL),
-(745, 15, 110, 'reload', 'reload', NULL),
-(746, 15, 110, 'reward', 'verguetung', NULL),
-(747, 15, 111, 'extra', 'typ', 'bannerview'),
-(748, 15, 111, 'id', 'id', NULL),
-(749, 15, 111, 'password', 'pw', NULL),
-(750, 15, 111, 'remain', 'uebrig', NULL),
-(751, 15, 111, 'reload', 'reload', NULL),
-(752, 15, 111, 'reward', 'verguetung', NULL),
-(753, 15, 112, 'extra', 'typ', 'bannerklick'),
-(754, 15, 112, 'id', 'id', NULL),
-(755, 15, 112, 'password', 'pw', NULL),
-(756, 15, 112, 'remain', 'uebrig', NULL),
-(757, 15, 112, 'reload', 'reload', NULL),
-(758, 15, 112, 'reward', 'verguetung', NULL),
-(759, 15, 113, 'extra', 'typ', 'skybannerview'),
-(760, 15, 113, 'id', 'id', NULL),
-(761, 15, 113, 'password', 'pw', NULL),
-(762, 15, 113, 'remain', 'uebrig', NULL),
-(763, 15, 113, 'reload', 'reload', NULL),
-(764, 15, 113, 'reward', 'verguetung', NULL),
-(765, 15, 114, 'extra', 'typ', 'buttonview'),
-(766, 15, 114, 'id', 'id', NULL),
-(767, 15, 114, 'password', 'pw', NULL),
-(768, 15, 114, 'remain', 'uebrig', NULL),
-(769, 15, 114, 'reload', 'reload', NULL),
-(770, 15, 114, 'reward', 'verguetung', NULL),
-(771, 15, 115, 'extra', 'typ', 'textview'),
-(772, 15, 115, 'id', 'id', NULL),
-(773, 15, 115, 'password', 'pw', NULL),
-(774, 15, 115, 'remain', 'uebrig', NULL),
-(775, 15, 115, 'reload', 'reload', NULL),
-(776, 15, 115, 'reward', 'verguetung', NULL),
-(777, 15, 116, 'extra', 'typ', 'popup'),
-(778, 15, 116, 'id', 'id', NULL),
-(779, 15, 116, 'password', 'pw', NULL),
-(780, 15, 116, 'reload', 'reload', NULL),
-(781, 15, 116, 'remain', 'uebrig', NULL),
-(782, 15, 116, 'reward', 'verguetung', NULL),
-(783, 15, 117, 'extra', 'typ', 'paidmail'),
-(784, 15, 117, 'id', 'id', NULL),
-(785, 15, 117, 'password', 'pw', NULL),
-(786, 15, 117, 'reload', 'reload', NULL),
-(787, 15, 117, 'remain', 'uebrig', NULL),
-(788, 15, 117, 'reward', 'verguetung', NULL),
-(815, 15, 123, 'extra', 'typ', 'traffic'),
-(816, 15, 123, 'id', 'id', NULL),
-(817, 15, 123, 'password', 'pw', NULL),
-(818, 15, 123, 'remain', 'uebrig', NULL),
-(819, 15, 123, 'reload', 'reload', NULL),
-(820, 15, 123, 'reward', 'verguetung', NULL)");
-
- // Request parameters per type handler - Power-Promo
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(523, 16, 78, 'id', 'id', NULL),
-(524, 16, 78, 'sid', 'sid', NULL),
-(525, 16, 78, 'password', 'pw', NULL),
-(526, 16, 78, 'reward', 'verguetung', NULL),
-(527, 16, 78, 'reload', 'reload', NULL),
-(528, 16, 78, 'remain', 'uebrig', NULL),
-(529, 16, 78, 'type', 'typ', 'klick'),
-(530, 16, 78, 'size', 'size', NULL),
-(531, 16, 79, 'id', 'id', NULL),
-(532, 16, 79, 'sid', 'sid', NULL),
-(533, 16, 79, 'password', 'pw', NULL),
-(534, 16, 79, 'reward', 'verguetung', NULL),
-(535, 16, 79, 'reload', 'reload', NULL),
-(536, 16, 79, 'remain', 'uebrig', NULL),
-(537, 16, 79, 'type', 'typ', 'view'),
-(538, 16, 79, 'size', 'size', NULL),
-(539, 16, 80, 'id', 'id', NULL),
-(540, 16, 80, 'sid', 'sid', NULL),
-(541, 16, 80, 'password', 'pw', NULL),
-(542, 16, 80, 'reward', 'verguetung', NULL),
-(543, 16, 80, 'reload', 'reload', NULL),
-(544, 16, 80, 'remain', 'uebrig', NULL),
-(545, 16, 80, 'type', 'typ', 'klick'),
-(546, 16, 81, 'id', 'id', NULL),
-(547, 16, 81, 'sid', 'sid', NULL),
-(548, 16, 81, 'password', 'pw', NULL),
-(549, 16, 81, 'reward', 'verguetung', NULL),
-(550, 16, 81, 'reload', 'reload', NULL),
-(551, 16, 81, 'remain', 'uebrig', NULL),
-(552, 16, 81, 'type', 'typ', 'view'),
-(553, 16, 82, 'id', 'id', NULL),
-(554, 16, 82, 'sid', 'sid', NULL),
-(555, 16, 82, 'password', 'pw', NULL),
-(556, 16, 82, 'reward', 'verguetung', NULL),
-(557, 16, 82, 'reload', 'reload', NULL),
-(558, 16, 82, 'remain', 'uebrig', NULL),
-(559, 16, 82, 'type', 'typ', 'klick'),
-(560, 16, 82, 'size', 'size', NULL),
-(561, 16, 83, 'id', 'id', NULL),
-(562, 16, 83, 'sid', 'sid', NULL),
-(563, 16, 83, 'password', 'pw', NULL),
-(564, 16, 83, 'reward', 'verguetung', NULL),
-(565, 16, 83, 'reload', 'reload', NULL),
-(566, 16, 83, 'remain', 'uebrig', NULL),
-(567, 16, 83, 'type', 'typ', 'view'),
-(568, 16, 83, 'size', 'size', NULL),
-(569, 16, 84, 'id', 'id', NULL),
-(570, 16, 84, 'sid', 'sid', NULL),
-(571, 16, 84, 'password', 'pw', NULL),
-(572, 16, 84, 'reward', 'verguetung', NULL),
-(573, 16, 84, 'reload', 'reload', NULL),
-(574, 16, 84, 'remain', 'uebrig', NULL),
-(575, 16, 84, 'size', 'size', NULL),
-(576, 16, 84, 'min_stay', 'ma', NULL),
-(577, 16, 85, 'id', 'id', NULL),
-(578, 16, 85, 'sid', 'sid', NULL),
-(579, 16, 85, 'password', 'pw', NULL),
-(580, 16, 85, 'reward', 'verguetung', NULL),
-(581, 16, 85, 'reload', 'reload', NULL),
-(582, 16, 85, 'remain', 'uebrig', NULL),
-(583, 16, 85, 'min_stay', 'ma', NULL),
-(584, 16, 85, 'type', 'typ', 'text'),
-(585, 16, 86, 'id', 'id', NULL),
-(586, 16, 86, 'sid', 'sid', NULL),
-(587, 16, 86, 'password', 'pw', NULL),
-(588, 16, 86, 'reward', 'verguetung', NULL),
-(589, 16, 86, 'reload', 'reload', NULL),
-(590, 16, 86, 'remain', 'uebrig', NULL),
-(591, 16, 86, 'min_stay', 'ma', NULL),
-(592, 16, 86, 'type', 'typ', 'html'),
-(593, 16, 87, 'id', 'id', NULL),
-(594, 16, 87, 'sid', 'sid', NULL),
-(595, 16, 87, 'password', 'pw', NULL),
-(596, 16, 87, 'reward', 'verguetung', NULL),
-(597, 16, 87, 'reload', 'reload', NULL),
-(598, 16, 87, 'remain', 'uebrig', NULL),
-(599, 16, 87, 'type', 'typ', 'klick'),
-(600, 16, 88, 'id', 'id', NULL),
-(601, 16, 88, 'sid', 'sid', NULL),
-(602, 16, 88, 'password', 'pw', NULL),
-(603, 16, 88, 'reward', 'verguetung', NULL),
-(604, 16, 88, 'reload', 'reload', NULL),
-(605, 16, 88, 'remain', 'uebrig', NULL),
-(606, 16, 88, 'type', 'typ', 'view'),
-(607, 16, 89, 'id', 'id', NULL),
-(608, 16, 89, 'sid', 'sid', NULL),
-(609, 16, 89, 'password', 'pw', NULL),
-(610, 16, 89, 'reward', 'verguetung', NULL),
-(611, 16, 89, 'reload', 'reload', NULL),
-(612, 16, 89, 'remain', 'uebrig', NULL),
-(613, 16, 89, 'min_stay', 'ma', NULL),
-(614, 16, 90, 'id', 'id', NULL),
-(615, 16, 90, 'sid', 'sid', NULL),
-(616, 16, 90, 'password', 'pw', NULL),
-(617, 16, 90, 'reward', 'verguetung', NULL),
-(618, 16, 90, 'reload', 'reload', NULL),
-(619, 16, 90, 'remain', 'uebrig', NULL),
-(620, 16, 90, 'min_stay', 'ma', NULL),
-(621, 16, 91, 'id', 'id', NULL),
-(622, 16, 91, 'sid', 'sid', NULL),
-(623, 16, 91, 'password', 'pw', NULL),
-(624, 16, 91, 'reward', 'verguetung', NULL),
-(625, 16, 91, 'remain', 'uebrig', NULL),
-(626, 16, 92, 'id', 'id', NULL),
-(627, 16, 92, 'sid', 'sid', NULL),
-(628, 16, 92, 'password', 'pw', NULL),
-(629, 16, 92, 'reward', 'verguetung', NULL),
-(630, 16, 92, 'remain', 'uebrig', NULL)");
-
- // Request parameters per type handler - SeCash
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(631, 17, 93, 'extra', 'typ', 'forcedbanner'),
-(632, 17, 93, 'id', 'id', NULL),
-(633, 17, 93, 'password', 'pw', NULL),
-(634, 17, 93, 'reward', 'verguetung', NULL),
-(635, 17, 93, 'reload', 'reload', NULL),
-(636, 17, 93, 'remain', 'uebrig', NULL),
-(637, 17, 94, 'extra', 'typ', 'forcedtextlink'),
-(638, 17, 94, 'id', 'id', NULL),
-(639, 17, 94, 'password', 'pw', NULL),
-(640, 17, 94, 'reward', 'verguetung', NULL),
-(641, 17, 94, 'reload', 'reload', NULL),
-(642, 17, 94, 'remain', 'uebrig', NULL),
-(643, 17, 95, 'extra', 'typ', 'bannerview'),
-(644, 17, 95, 'id', 'id', NULL),
-(645, 17, 95, 'password', 'pw', NULL),
-(646, 17, 95, 'reward', 'verguetung', NULL),
-(647, 17, 95, 'reload', 'reload', NULL),
-(648, 17, 95, 'remain', 'uebrig', NULL),
-(649, 17, 96, 'extra', 'typ', 'bannerklick'),
-(650, 17, 96, 'id', 'id', NULL),
-(651, 17, 96, 'password', 'pw', NULL),
-(652, 17, 96, 'reward', 'verguetung', NULL),
-(653, 17, 96, 'reload', 'reload', NULL),
-(654, 17, 96, 'remain', 'uebrig', NULL),
-(655, 17, 97, 'extra', 'typ', 'skybannerview'),
-(656, 17, 97, 'id', 'id', NULL),
-(657, 17, 97, 'password', 'pw', NULL),
-(658, 17, 97, 'reward', 'verguetung', NULL),
-(659, 17, 97, 'reload', 'reload', NULL),
-(660, 17, 97, 'remain', 'uebrig', NULL),
-(661, 17, 98, 'extra', 'typ', 'buttonview'),
-(662, 17, 98, 'id', 'id', NULL),
-(663, 17, 98, 'password', 'pw', NULL),
-(664, 17, 98, 'reward', 'verguetung', NULL),
-(665, 17, 98, 'reload', 'reload', NULL),
-(666, 17, 98, 'remain', 'uebrig', NULL),
-(667, 17, 99, 'extra', 'typ', 'textview'),
-(668, 17, 99, 'id', 'id', NULL),
-(669, 17, 99, 'password', 'pw', NULL),
-(670, 17, 99, 'reward', 'verguetung', NULL),
-(671, 17, 99, 'reload', 'reload', NULL),
-(672, 17, 99, 'remain', 'uebrig', NULL),
-(673, 17, 100, 'extra', 'typ', 'popup'),
-(674, 17, 100, 'id', 'id', NULL),
-(675, 17, 100, 'password', 'pw', NULL),
-(676, 17, 100, 'reward', 'verguetung', NULL),
-(677, 17, 100, 'reload', 'reload', NULL),
-(678, 17, 100, 'remain', 'uebrig', NULL),
-(679, 17, 100, 'min_stay', 'ma', NULL),
-(680, 17, 101, 'extra', 'typ', 'paidmail'),
-(681, 17, 101, 'id', 'id', NULL),
-(682, 17, 101, 'password', 'pw', NULL),
-(683, 17, 101, 'reward', 'verguetung', NULL),
-(684, 17, 101, 'reload', 'reload', NULL),
-(685, 17, 101, 'remain', 'uebrig', NULL),
-(686, 17, 101, 'min_stay', 'ma', NULL),
-(821, 17, 124, 'extra', 'typ', 'traffic'),
-(822, 17, 124, 'id', 'id', NULL),
-(823, 17, 124, 'password', 'pw', NULL),
-(824, 17, 124, 'remain', 'uebrig', NULL),
-(825, 17, 124, 'reload', 'reload', NULL),
-(826, 17, 124, 'reward', 'verguetung', NULL)");
-
- // Request parameters per type handler - UltraPROMO
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`) VALUES
-(827, 18, 128, 'extra', 'typ', 'forcedbanner'),
-(828, 18, 128, 'id', 'id', NULL),
-(829, 18, 128, 'password', 'pw', NULL),
-(830, 18, 128, 'remain', 'uebrig', NULL),
-(831, 18, 128, 'reload', 'reload', NULL),
-(832, 18, 128, 'reward', 'verguetung', NULL),
-(833, 18, 129, 'extra', 'typ', 'forcedtextlink'),
-(834, 18, 129, 'id', 'id', NULL),
-(835, 18, 129, 'password', 'pw', NULL),
-(836, 18, 129, 'remain', 'uebrig', NULL),
-(837, 18, 129, 'reload', 'reload', NULL),
-(838, 18, 129, 'reward', 'verguetung', NULL),
-(839, 18, 126, 'extra', 'typ', 'bannerview'),
-(840, 18, 126, 'id', 'id', NULL),
-(841, 18, 126, 'password', 'pw', NULL),
-(842, 18, 126, 'remain', 'uebrig', NULL),
-(843, 18, 126, 'reload', 'reload', NULL),
-(844, 18, 126, 'reward', 'verguetung', NULL),
-(845, 18, 125, 'extra', 'typ', 'bannerklick'),
-(846, 18, 125, 'id', 'id', NULL),
-(847, 18, 125, 'password', 'pw', NULL),
-(848, 18, 125, 'remain', 'uebrig', NULL),
-(849, 18, 125, 'reload', 'reload', NULL),
-(850, 18, 125, 'reward', 'verguetung', NULL),
-(851, 18, 131, 'extra', 'typ', 'skybannerview'),
-(852, 18, 131, 'id', 'id', NULL),
-(853, 18, 131, 'password', 'pw', NULL),
-(854, 18, 131, 'remain', 'uebrig', NULL),
-(855, 18, 131, 'reload', 'reload', NULL),
-(856, 18, 131, 'reward', 'verguetung', NULL),
-(857, 18, 127, 'extra', 'typ', 'buttonview'),
-(858, 18, 127, 'id', 'id', NULL),
-(859, 18, 127, 'password', 'pw', NULL),
-(860, 18, 127, 'remain', 'uebrig', NULL),
-(861, 18, 127, 'reload', 'reload', NULL),
-(862, 18, 127, 'reward', 'verguetung', NULL),
-(863, 18, 132, 'extra', 'typ', 'textview'),
-(864, 18, 132, 'id', 'id', NULL),
-(865, 18, 132, 'password', 'pw', NULL),
-(866, 18, 132, 'remain', 'uebrig', NULL),
-(867, 18, 132, 'reload', 'reload', NULL),
-(868, 18, 132, 'reward', 'verguetung', NULL),
-(869, 18, 134, 'extra', 'typ', 'traffic'),
-(870, 18, 134, 'id', 'id', NULL),
-(871, 18, 134, 'password', 'pw', NULL),
-(872, 18, 134, 'remain', 'uebrig', NULL),
-(873, 18, 134, 'reload', 'reload', NULL),
-(874, 18, 134, 'reward', 'verguetung', NULL),
-(875, 18, 130, 'extra', 'typ', 'popup'),
-(876, 18, 130, 'id', 'id', NULL),
-(877, 18, 130, 'password', 'pw', NULL),
-(878, 18, 130, 'remain', 'uebrig', NULL),
-(879, 18, 130, 'reload', 'reload', NULL),
-(880, 18, 130, 'reward', 'verguetung', NULL),
-(881, 18, 130, 'min_stay', 'ma', NULL),
-(882, 18, 133, 'extra', 'typ', 'paidmail'),
-(883, 18, 133, 'id', 'id', NULL),
-(884, 18, 133, 'password', 'pw', NULL),
-(885, 18, 133, 'remain', 'uebrig', NULL),
-(886, 18, 133, 'reload', 'reload', NULL),
-(887, 18, 133, 'reward', 'verguetung', NULL),
-(888, 18, 133, 'min_stay', 'ma', NULL)");
-
- // Request parameters per type handler - Der Werbepartner.cc
-
- // Request parameters per type handler - Yoo!Media
-
- // Fix empty defaults to NULL
- addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_types` SET `network_type_banner_url`=NULL WHERE `network_type_banner_url`=''");
- addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_request_params` SET `request_param_default`=NULL WHERE `request_param_default`=''");
-
- // 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);
- 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','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. <strong>Vorsicht:</strong> 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);
- addAdminMenuSql('network','list_networks','Auflisten/Verwalten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',6);
- addAdminMenuSql('network','list_network_types','Werbearten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',7);
- addAdminMenuSql('network','list_network_params','Abfrageparameter','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Abfrageparameter (wie sie genannt werden müssen, um das API-Script korrekt aufrufen zu können) ein, pro Werbenetzwerk. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',8);
- addAdminMenuSql('network','list_network_code_types','Rückgabewerte','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Rückgabewerte ein, die im Falle eines Fehlers pro API-Script kommen können. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',9);
- addAdminMenuSql('network','list_network_codes','Fehlercodes','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',10);
-
- // Configuration entries
- addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `network_cache_refresh` BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (60 * 15) . '');
+ case 'setup': // Do stuff when installation is running
+ // This is now moved out to inc/extensions/network/mode-setup.php
break;
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_type_codes`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_codes`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
- addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_array_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_vcheck_errors');
+ addDropTableSql('network_translations');
+ addDropTableSql('network_array_translation');
+ addDropTableSql('network_error_codes');
+ addDropTableSql('network_api_config');
+ addDropTableSql('network_handler_config');
+ addDropTableSql('network_vcheck_config');
+ addDropTableSql('network_cache');
+ addDropTableSql('network_reloads');
+ addDropTableSql('network_header_logging');
// Admin menu
addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='network'");
+
+ // Unregister module
+ addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='network-delurl' LIMIT 1");
+ addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_mod_reg` WHERE `module`='network-vcheck' LIMIT 1");
break;
case 'activate': // Do stuff when admin activates this extension
- // SQL commands to run
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `locked`='N',`hidden`='Y',`admin_only`='N',`mem_only`='N' WHERE `module`='network-delurl' LIMIT 1");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `locked`='N',`hidden`='Y',`admin_only`='N',`mem_only`='N' WHERE `module`='network-vcheck' LIMIT 1");
break;
case 'deactivate': // Do stuff when admin deactivates this extension
- // SQL commands to run
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `locked`='Y',`hidden`='Y',`admin_only`='N',`mem_only`='N' WHERE `module`='network-delurl' LIMIT 1");
+ addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_mod_reg` SET `locked`='Y',`hidden`='Y',`admin_only`='N',`mem_only`='N' WHERE `module`='network-vcheck' LIMIT 1");
break;
case 'update': // Update an extension
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
break;
default: // Unknown extension mode
- logDebugMessage(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName()));
+ reportBug(__FILE__, __LINE__, sprintf('Unknown extension mode %s in extension %s detected.', getExtensionMode(), getCurrentExtensionName()));
break;
} // END - switch
projects / mailer.git / blobdiff