* @TODO Ad-Magnet: Banner-View, Textlink-Klick/-View. Page-Peel *
* @TODO ADCocktail: All request parameters, BIDausKAS, WIDausKAS??? *
* @TODO ADCocktail: Zero array element is return code! *
+ * @TODO adgain.de: HTML mails are encoded with BASE64 *
+ * @TODO adgain.de: Textlink-View is a JavaScript URL *
+ * @TODO ADkracher: HTML mails are encoded with BASE64 *
+ * @TODO ADkracher: Textlink-View is a JavaScript URL *
* @TODO Affiliblatt: All except banner, do they really have UTF-8? *
* @TODO AllAds4You: Traffic from abroad, High-Forced banner *
* @TODO FuCoExSponsor: No High-Forced banner, HTML is BASE64 encoded *
// HTTP parameters (names) for URLs
addDropTableSql('network_request_params');
addCreateTableSql('network_request_params', "
-`network_param_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`network_request_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,
`network_request_param_key` VARCHAR(20) NOT NULL DEFAULT 'invalid',
`network_request_param_value` VARCHAR(20) NOT NULL DEFAULT 'invalid',
`network_request_param_default` VARCHAR(255) NULL DEFAULT NULL,
-PRIMARY KEY (`network_param_id`),
+PRIMARY KEY (`network_request_param_id`),
UNIQUE INDEX `provider_type_key` (`network_id`,`network_type_id`,`network_request_param_key`),
UNIQUE INDEX `provider_type_value` (`network_id`,`network_type_id`,`network_request_param_value`)",
'Request parameters for GET/POST request');
'Translations for array keys, generic data, DO NOT ALTER!');
// Array-Element translation tables per type/provider
- addDropTableSql('network_api_translation');
- addCreateTableSql('network_api_translation', "
-`network_api_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+ addDropTableSql('network_array_translation');
+ addCreateTableSql('network_array_translation', "
+`network_array_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_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
+`network_array_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-PRIMARY KEY (`network_api_id`),
-UNIQUE INDEX `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
+PRIMARY KEY (`network_array_id`),
+UNIQUE INDEX `provider_type_key` (`network_id`,`network_type_id`,`network_array_index`),
INDEX (`sort`)",
'Translation of API responses, generic data, DO NOT ALTER!');
('fucoexsponsor', 'FuCoExSponsor.net', 'http://fucoexsponsor.net/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
('adconvention', 'AdConvention', 'http://www.adconvention.de?ref=233', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
('ad-hit', 'Ad-Hit.de', 'http://www.ad-hit.de?ref=41', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
-('adcity', 'AdCity.eu', 'http://www.adcity.eu?ref=38', '|', '|', 'GET', 'WINDOWS-1252', 'N', 200)");
+('adcity', 'AdCity.eu', 'http://www.adcity.eu?ref=38', '|', '|', 'GET', 'WINDOWS-1252', 'N', 200),
+('adgain', 'adgain.de', 'http://www.adgain.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1', 'N', 150),
+('adkracher', 'ADkracher', 'http://www.adkracher.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1', 'N', 350),
+('adminlose', 'Adminlose.de', 'http://www.adminlose.de/index.php?ref=2148', '|', '|', 'GET', 'WINDOWS-1252', 'N', 200)");
// 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`,`network_type_reload_time_unit`) VALUES
// Network type handlers - Ad-Magnet
// Network type handlers - AdCity.eu
- 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`,`network_type_reload_time_unit`) VALUES
+ 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`,`network_type_reload_time_unit`) VALUES
(312, 32, 'forcedbanner', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%', 'h'),
(313, 32, 'forcedtextlink', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h'),
(314, 32, 'banner_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%', 'h'),
(301, 30, 'textmail', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h'),
(299, 30, 'traffic', 'http://www.adconvention.de/interface/', 'http://www.adconvention.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h')");
+ // Network type handlers - AdGain
+ 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`,`network_type_reload_time_unit`) VALUES
+(322, 33, 'banner_click', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adgain.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(323, 33, 'banner_view', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adgain.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(324, 33, 'forcedbanner', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adgain.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(325, 33, 'forcedtextlink', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(326, 33, 'htmlmail', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(327, 33, 'layer', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/sc_layer.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(328, 33, 'textmail', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(329, 33, 'popup', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/sc_popup.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(330, 33, 'skybanner_click', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adgain.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(331, 33, 'skybanner_view', 'http://www.dgain.de/int/get.phap', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adgain.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(332, 33, 'surfbar_click', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adgain.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(333, 33, 'surfbar_view', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adgain.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(334, 33, 'textlink_click', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(335, 33, 'textlink_view', 'http://www.adgain.de/int/get.php', 'http://www.adgain.de/kamp/sc_textview.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h')");
+
+ // Network type handlers - ADkracher
+ 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`,`network_type_reload_time_unit`) VALUES
+(336, 34, 'banner_click', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adkracher.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(337, 34, 'banner_view', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adkracher.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(338, 34, 'forcedbanner', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adkracher.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(339, 34, 'forcedtextlink', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(340, 34, 'htmlmail', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(341, 34, 'layer', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/sc_layer.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(342, 34, 'textmail', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(343, 34, 'popup', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/sc_popup.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(344, 34, 'skybanner_click', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adkracher.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(345, 34, 'skybanner_view', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', 'http://www.adkracher.de/kamp/b_view.php?uid=%UID%&bid=%CID%&sid=%SID%', 'h'),
+(346, 34, 'textlink_click', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(347, 34, 'textlink_view', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/sc_textview.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h'),
+(348, 34, 'traffic', 'http://www.adkracher.de/int/get.php', 'http://www.adkracher.de/kamp/ziel.php?uid=%UID%&bid=%CID%&sid=%SID%', NULL, 'h')");
+
+ // Network type handlers - Adminlose.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`,`network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`,`network_type_reload_time_unit`) VALUES
+(349, 35, 'banner_view', 'http://www.adminlose.de/interface/output_bannerviews.php', 'http://www.adminlose.de/lose/clickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adminlose.de/lose/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'h'),
+(350, 35, 'textlink_view', 'http://www.adminlose.de/interface/output_textlinkviews.php', 'http://www.adminlose.de/lose/viewtextlink.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h'),
+(351, 35, 'forcedbanner', 'http://www.adminlose.de/interface/output_forcedbanner.php', 'http://www.adminlose.de/lose/forcedclickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adminlose.de/lose/forcedviewbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'h'),
+(352, 35, 'forcedtextlink', 'http://www.adminlose.de/interface/output_forcedtextlink.php', 'http://www.adminlose.de/lose/forcedclicktextlink.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h'),
+(353, 35, 'textmail', 'http://www.adminlose.de/interface/output_paidmails.php', 'http://www.adminlose.de/lose/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h'),
+(354, 35, 'traffic', 'http://www.adminlose.de/interface/output_traffic.php', 'http://www.adminlose.de/lose/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h'),
+(355, 35, 'popup', 'http://www.adminlose.de/interface/output_popup.php', 'http://www.adminlose.de/lose/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h'),
+(356, 35, 'popdown', 'http://www.adminlose.de/interface/output_popup.php', 'http://www.adminlose.de/lose/popdown.php?id=%UID%&bid=%CID%&aid=%SID%', NULL, 'h')");
+
// Network type handlers - AdPaid
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`,`network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`,`network_type_reload_time_unit`) VALUES
(177, 5, 'banner', 'http://www.adpaid.de/interface/out_banner.php', 'http://www.adpaid.de/bannerklf.php?id=%CID%', 'http://www.adpaid.de/banner.php?id=%CID%', 'h'),
// Request parameters per type handler - Ad-Magnet
// Request parameters per type handler - AdCity.eu
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`, `network_type_id`, `network_request_param_key`, `network_request_param_value`, `network_request_param_default`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
(32, 312, 'extra', 'typ', 'forcedbanner'),
(32, 312, 'id', 'id', NULL),
(32, 312, 'password', 'pw', NULL),
(30, 301, 'remain', 'uebrig', NULL),
(30, 301, 'reward', 'verguetung', NULL)");
+ // Request parameters per type handler - adgain.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
+(33, 322, 'extra', 'art', 'bannerklick'),
+(33, 322, 'id', 'uid', NULL),
+(33, 322, 'password', 'pw', NULL),
+(33, 322, 'sid', 'sid', NULL),
+(33, 322, 'reward', 'verguetung', NULL),
+(33, 322, 'reload', 'reload', NULL),
+(33, 322, 'remain', 'uebrig', NULL),
+(33, 323, 'extra', 'art', 'bannerview'),
+(33, 323, 'id', 'uid', NULL),
+(33, 323, 'password', 'pw', NULL),
+(33, 323, 'sid', 'sid', NULL),
+(33, 323, 'reward', 'verguetung', NULL),
+(33, 323, 'reload', 'reload', NULL),
+(33, 323, 'remain', 'uebrig', NULL),
+(33, 324, 'extra', 'art', 'forcedbanner'),
+(33, 324, 'id', 'uid', NULL),
+(33, 324, 'password', 'pw', NULL),
+(33, 324, 'sid', 'sid', NULL),
+(33, 324, 'reward', 'verguetung', NULL),
+(33, 324, 'reload', 'reload', NULL),
+(33, 324, 'remain', 'uebrig', NULL),
+(33, 324, 'minimum_stay', 'ma', NULL),
+(33, 325, 'extra', 'art', 'forcedtextlink'),
+(33, 325, 'id', 'uid', NULL),
+(33, 325, 'password', 'pw', NULL),
+(33, 325, 'sid', 'sid', NULL),
+(33, 325, 'reward', 'verguetung', NULL),
+(33, 325, 'reload', 'reload', NULL),
+(33, 325, 'remain', 'uebrig', NULL),
+(33, 325, 'minimum_stay', 'ma', NULL),
+(33, 326, 'extra', 'art', 'htmlmail'),
+(33, 326, 'id', 'uid', NULL),
+(33, 326, 'password', 'pw', NULL),
+(33, 326, 'sid', 'sid', NULL),
+(33, 326, 'reward', 'verguetung', NULL),
+(33, 326, 'reload', 'reload', NULL),
+(33, 326, 'remain', 'uebrig', NULL),
+(33, 326, 'minimum_stay', 'ma', NULL),
+(33, 327, 'extra', 'art', 'layer'),
+(33, 327, 'id', 'uid', NULL),
+(33, 327, 'password', 'pw', NULL),
+(33, 327, 'sid', 'sid', NULL),
+(33, 327, 'reward', 'verguetung', NULL),
+(33, 327, 'reload', 'reload', NULL),
+(33, 327, 'remain', 'uebrig', NULL),
+(33, 328, 'extra', 'art', 'paidmail'),
+(33, 328, 'id', 'uid', NULL),
+(33, 328, 'password', 'pw', NULL),
+(33, 328, 'sid', 'sid', NULL),
+(33, 328, 'reward', 'verguetung', NULL),
+(33, 328, 'reload', 'reload', NULL),
+(33, 328, 'type', 'uebrig', NULL),
+(33, 328, 'minimum_stay', 'ma', NULL),
+(33, 329, 'extra', 'art', 'popup'),
+(33, 329, 'id', 'uid', NULL),
+(33, 329, 'password', 'pw', NULL),
+(33, 329, 'sid', 'sid', NULL),
+(33, 329, 'reward', 'verguetung', NULL),
+(33, 329, 'reload', 'reload', NULL),
+(33, 329, 'remain', 'uebrig', NULL),
+(33, 329, 'minimum_stay', 'ma', NULL),
+(33, 330, 'extra', 'art', 'skybannerklick'),
+(33, 330, 'id', 'uid', NULL),
+(33, 330, 'password', 'pw', NULL),
+(33, 330, 'sid', 'sid', NULL),
+(33, 330, 'reward', 'verguetung', NULL),
+(33, 330, 'reload', 'reload', NULL),
+(33, 330, 'remain', 'uebrig', NULL),
+(33, 331, 'extra', 'art', 'skybannerview'),
+(33, 331, 'id', 'uid', NULL),
+(33, 331, 'password', 'pw', NULL),
+(33, 331, 'sid', 'sid', NULL),
+(33, 331, 'reward', 'verguetung', NULL),
+(33, 331, 'reload', 'reload', NULL),
+(33, 331, 'remain', 'uebrig', NULL),
+(33, 332, 'extra', 'art', 'surfbarklick'),
+(33, 332, 'id', 'uid', NULL),
+(33, 332, 'password', 'pw', NULL),
+(33, 332, 'sid', 'sid', NULL),
+(33, 332, 'reward', 'verguetung', NULL),
+(33, 332, 'reload', 'reload', NULL),
+(33, 332, 'remain', 'uebrig', NULL),
+(33, 333, 'extra', 'art', 'surfbarview'),
+(33, 333, 'id', 'uid', NULL),
+(33, 333, 'password', 'pw', NULL),
+(33, 333, 'sid', 'sid', NULL),
+(33, 333, 'reward', 'verguetung', NULL),
+(33, 333, 'reload', 'reload', NULL),
+(33, 333, 'remain', 'uebrig', NULL),
+(33, 334, 'extra', 'art', 'textlinkklick'),
+(33, 334, 'id', 'uid', NULL),
+(33, 334, 'password', 'pw', NULL),
+(33, 334, 'sid', 'sid', NULL),
+(33, 334, 'reward', 'verguetung', NULL),
+(33, 334, 'reload', 'reload', NULL),
+(33, 334, 'remain', 'uebrig', NULL),
+(33, 335, 'extra', 'art', 'textlinkview'),
+(33, 335, 'id', 'uid', NULL),
+(33, 335, 'password', 'pw', NULL),
+(33, 335, 'sid', 'sid', NULL),
+(33, 335, 'reward', 'verguetung', NULL),
+(33, 335, 'reload', 'reload', NULL),
+(33, 335, 'remain', 'uebrig', NULL)");
+
+ // Request parameters per type handler - ADkracher
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
+(34, 336, 'extra', 'art', 'bannerklick'),
+(34, 336, 'id', 'uid', NULL),
+(34, 336, 'password', 'pw', NULL),
+(34, 336, 'reload', 'reload', NULL),
+(34, 336, 'remain', 'uebrig', NULL),
+(34, 336, 'reward', 'verguetung', NULL),
+(34, 336, 'sid', 'sid', NULL),
+(34, 337, 'extra', 'art', 'bannerview'),
+(34, 337, 'id', 'uid', NULL),
+(34, 337, 'password', 'pw', NULL),
+(34, 337, 'reload', 'reload', NULL),
+(34, 337, 'remain', 'uebrig', NULL),
+(34, 337, 'reward', 'verguetung', NULL),
+(34, 337, 'sid', 'sid', NULL),
+(34, 338, 'extra', 'art', 'forcedbanner'),
+(34, 338, 'id', 'uid', NULL),
+(34, 338, 'minimum_stay', 'ma', NULL),
+(34, 338, 'password', 'pw', NULL),
+(34, 338, 'reload', 'reload', NULL),
+(34, 338, 'remain', 'uebrig', NULL),
+(34, 338, 'reward', 'verguetung', NULL),
+(34, 338, 'sid', 'sid', NULL),
+(34, 339, 'extra', 'art', 'forcedtextlink'),
+(34, 339, 'id', 'uid', NULL),
+(34, 339, 'minimum_stay', 'ma', NULL),
+(34, 339, 'password', 'pw', NULL),
+(34, 339, 'reload', 'reload', NULL),
+(34, 339, 'remain', 'uebrig', NULL),
+(34, 339, 'reward', 'verguetung', NULL),
+(34, 339, 'sid', 'sid', NULL),
+(34, 340, 'extra', 'art', 'htmlmail'),
+(34, 340, 'id', 'uid', NULL),
+(34, 340, 'minimum_stay', 'ma', NULL),
+(34, 340, 'password', 'pw', NULL),
+(34, 340, 'reload', 'reload', NULL),
+(34, 340, 'remain', 'uebrig', NULL),
+(34, 340, 'reward', 'verguetung', NULL),
+(34, 340, 'sid', 'sid', NULL),
+(34, 341, 'extra', 'art', 'layer'),
+(34, 341, 'id', 'uid', NULL),
+(34, 341, 'password', 'pw', NULL),
+(34, 341, 'reload', 'reload', NULL),
+(34, 341, 'remain', 'uebrig', NULL),
+(34, 341, 'reward', 'verguetung', NULL),
+(34, 341, 'sid', 'sid', NULL),
+(34, 342, 'extra', 'art', 'paidmail'),
+(34, 342, 'id', 'uid', NULL),
+(34, 342, 'maximum_stay', 'ma', NULL),
+(34, 342, 'password', 'pw', NULL),
+(34, 342, 'reload', 'reload', NULL),
+(34, 342, 'remain', 'uebrig', NULL),
+(34, 342, 'reward', 'verguetung', NULL),
+(34, 342, 'sid', 'sid', NULL),
+(34, 343, 'extra', 'art', 'popup'),
+(34, 343, 'id', 'uid', NULL),
+(34, 343, 'maximum_stay', 'ma', NULL),
+(34, 343, 'password', 'pw', NULL),
+(34, 343, 'reload', 'reload', NULL),
+(34, 343, 'remain', 'uebrig', NULL),
+(34, 343, 'reward', 'verguetung', NULL),
+(34, 343, 'sid', 'sid', NULL),
+(34, 344, 'extra', 'art', 'skybannerklick'),
+(34, 344, 'id', 'uid', NULL),
+(34, 344, 'password', 'pw', NULL),
+(34, 344, 'reload', 'reload', NULL),
+(34, 344, 'remain', 'uebrig', NULL),
+(34, 344, 'reward', 'verguetung', NULL),
+(34, 344, 'sid', 'sid', NULL),
+(34, 345, 'extra', 'art', 'skybannerview'),
+(34, 345, 'id', 'uid', NULL),
+(34, 345, 'password', 'pw', NULL),
+(34, 345, 'reload', 'reload', NULL),
+(34, 345, 'remain', 'uebrig', NULL),
+(34, 345, 'reward', 'verguetung', NULL),
+(34, 345, 'sid', 'sid', NULL),
+(34, 346, 'extra', 'art', 'textlinkklick'),
+(34, 346, 'id', 'uid', NULL),
+(34, 346, 'password', 'pw', NULL),
+(34, 346, 'reload', 'reload', NULL),
+(34, 346, 'remain', 'uebrig', NULL),
+(34, 346, 'reward', 'verguetung', NULL),
+(34, 346, 'sid', 'sid', NULL),
+(34, 347, 'extra', 'art', 'textlinkview'),
+(34, 347, 'id', 'uid', NULL),
+(34, 347, 'password', 'pw', NULL),
+(34, 347, 'reload', 'reload', NULL),
+(34, 347, 'reward', 'verguetung', NULL),
+(34, 347, 'sid', 'sid', NULL),
+(34, 348, 'extra', 'art', 'traffic'),
+(34, 348, 'id', 'uid', NULL),
+(34, 348, 'minimum_stay', 'ma', NULL),
+(34, 348, 'password', 'pw', NULL),
+(34, 348, 'reload', 'reload', NULL),
+(34, 348, 'remain', 'uebrig', NULL),
+(34, 348, 'reward', 'verguetung', NULL),
+(34, 348, 'sid', 'sid', NULL)");
+
+ // Request parameters per type handler - Adminlose.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
+(35, 349, 'id', 'id', 'NULL),
+(35, 349, 'password', 'pw', 'NULL),
+(35, 349, 'reload', 'reload', 'NULL),
+(35, 349, 'reward', 'verguetung', 'NULL),
+(35, 349, 'remain', 'uebrig', 'NULL),
+(35, 349, 'type', 'typ', 'view'),
+(35, 350, 'id', 'id', 'NULL),
+(35, 350, 'password', 'pw', 'NULL),
+(35, 350, 'reload', 'reload', 'NULL),
+(35, 350, 'reward', 'verguetung', 'NULL),
+(35, 350, 'remain', 'uebrig', 'NULL),
+(35, 350, 'type', 'typ', 'view'),
+(35, 351, 'id', 'id', 'NULL),
+(35, 351, 'password', 'pw', 'NULL),
+(35, 351, 'reload', 'reload', 'NULL),
+(35, 351, 'reward', 'verguetung', 'NULL),
+(35, 351, 'remain', 'uebrig', 'NULL),
+(35, 352, 'id', 'id', 'NULL),
+(35, 352, 'password', 'pw', 'NULL),
+(35, 352, 'reload', 'reload', 'NULL),
+(35, 352, 'reward', 'verguetung', 'NULL),
+(35, 352, 'type', 'uebrig', 'NULL),
+(35, 353, 'id', 'id', 'NULL),
+(35, 353, 'password', 'pw', 'NULL),
+(35, 353, 'reward', 'verguetung', 'NULL),
+(35, 353, 'remain', 'uebrig', 'NULL),
+(35, 353, 'minimum_stay', 'ma', 'NULL),
+(35, 354, 'id', 'id', 'NULL),
+(35, 354, 'password', 'pw', 'NULL),
+(35, 354, 'reload', 'reload', 'NULL),
+(35, 354, 'reward', 'verguetung', 'NULL),
+(35, 354, 'remain', 'uebrig', 'NULL),
+(35, 355, 'id', 'id', 'NULL),
+(35, 355, 'password', 'pw', 'NULL),
+(35, 355, 'reload', 'reload', 'NULL),
+(35, 355, 'reward', 'verguetung', 'NULL),
+(35, 355, 'remain', 'uebrig', 'NULL),
+(35, 355, 'minimum_stay', 'ma', 'NULL),
+(35, 355, 'type', 'typ', 'popup'),
+(35, 356, 'id', 'id', 'NULL),
+(35, 356, 'password', 'pw', 'NULL),
+(35, 356, 'reload', 'reload', 'NULL),
+(35, 356, 'reward', 'verguetung', 'NULL),
+(35, 356, 'remain', 'uebrig', 'NULL),
+(35, 356, 'minimum_stay', 'ma', 'NULL),
+(35, 356, 'type', 'typ', 'popdown')");
+
// Request parameters per type handler - AdPaid
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`network_request_param_key`,`network_request_param_value`,`network_request_param_default`) VALUES
(5, 177, 'id', 'id', NULL),
(23, 166, 'sid', 'sid', NULL)");
// API array elements - A3H
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(1, 1, 7, 1),
(1, 1, 2, 2),
(1, 1, 3, 3),
(1, 10, 25, 10)");
// API array elements - AbisZED-Netz
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(2, 187, 7, 1),
(2, 187, 2, 2),
(2, 187, 3, 3),
(2, 201, 25, 10)");
// API array elements - Ad-Hit.de
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(31, 302, 1, 1),
(31, 302, 2, 2),
(31, 302, 4, 3),
// API array elements - AD-Magnet
// API array elements - ADCity.eu
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(32, 312, 1, 1),
(32, 312, 2, 2),
(32, 312, 4, 3),
// API array elements - ADCocktail
// API array elements - AdConvention
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(30, 292, 1, 1),
(30, 292, 2, 2),
(30, 292, 4, 3),
(30, 301, 10, 6),
(30, 301, 9, 7)");
+ // API array elements - adgain.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
+(33, 322, 1, 1),
+(33, 322, 2, 2),
+(33, 322, 5, 3),
+(33, 322, 4, 4),
+(33, 322, 6, 5),
+(33, 323, 1, 1),
+(33, 323, 2, 2),
+(33, 323, 5, 3),
+(33, 323, 4, 4),
+(33, 323, 6, 5),
+(33, 324, 1, 1),
+(33, 324, 2, 2),
+(33, 324, 5, 3),
+(33, 324, 4, 4),
+(33, 324, 6, 5),
+(33, 324, 10, 6),
+(33, 325, 1, 1),
+(33, 325, 2, 2),
+(33, 325, 5, 3),
+(33, 325, 4, 4),
+(33, 325, 6, 5),
+(33, 325, 10, 6),
+(33, 325, 9, 7),
+(33, 326, 1, 1),
+(33, 326, 2, 2),
+(33, 326, 5, 3),
+(33, 326, 4, 4),
+(33, 326, 6, 5),
+(33, 326, 10, 6),
+(33, 326, 37, 7),
+(33, 326, 9, 8),
+(33, 327, 1, 1),
+(33, 327, 2, 2),
+(33, 327, 5, 3),
+(33, 327, 4, 4),
+(33, 327, 6, 5),
+(33, 328, 1, 1),
+(33, 328, 2, 2),
+(33, 328, 5, 3),
+(33, 328, 4, 4),
+(33, 328, 6, 5),
+(33, 328, 10, 6),
+(33, 328, 37, 7),
+(33, 328, 9, 8),
+(33, 329, 1, 1),
+(33, 329, 2, 2),
+(33, 329, 5, 3),
+(33, 329, 4, 4),
+(33, 329, 6, 5),
+(33, 329, 10, 6),
+(33, 330, 1, 1),
+(33, 330, 2, 2),
+(33, 330, 5, 3),
+(33, 330, 4, 4),
+(33, 330, 6, 5),
+(33, 331, 1, 1),
+(33, 331, 2, 2),
+(33, 331, 5, 3),
+(33, 331, 4, 4),
+(33, 331, 6, 5),
+(33, 332, 1, 1),
+(33, 332, 2, 2),
+(33, 332, 5, 3),
+(33, 332, 4, 4),
+(33, 332, 6, 5),
+(33, 333, 1, 1),
+(33, 333, 2, 2),
+(33, 333, 5, 3),
+(33, 333, 4, 4),
+(33, 333, 6, 5),
+(33, 334, 1, 1),
+(33, 334, 2, 2),
+(33, 334, 5, 3),
+(33, 334, 4, 4),
+(33, 334, 6, 5),
+(33, 334, 9, 6),
+(33, 335, 1, 1),
+(33, 335, 2, 2),
+(33, 335, 5, 3),
+(33, 335, 4, 4),
+(33, 335, 6, 5),
+(33, 335, 9, 6)");
+
+ // API array elements - adgain.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
+(34, 336, 1, 1),
+(34, 336, 2, 2),
+(34, 336, 5, 3),
+(34, 336, 4, 4),
+(34, 336, 6, 5),
+(34, 337, 1, 1),
+(34, 337, 2, 2),
+(34, 337, 5, 3),
+(34, 337, 4, 4),
+(34, 337, 6, 5),
+(34, 338, 1, 1),
+(34, 338, 2, 2),
+(34, 338, 5, 3),
+(34, 338, 4, 4),
+(34, 338, 6, 5),
+(34, 338, 10, 6),
+(34, 339, 1, 1),
+(34, 339, 2, 2),
+(34, 339, 5, 3),
+(34, 339, 4, 4),
+(34, 339, 6, 5),
+(34, 339, 10, 6),
+(34, 339, 9, 7),
+(34, 340, 1, 1),
+(34, 340, 2, 2),
+(34, 340, 5, 3),
+(34, 340, 4, 4),
+(34, 340, 6, 5),
+(34, 340, 10, 6),
+(34, 340, 37, 7),
+(34, 340, 9, 8),
+(34, 341, 1, 1),
+(34, 341, 2, 2),
+(34, 341, 5, 3),
+(34, 341, 4, 4),
+(34, 341, 6, 5),
+(34, 342, 1, 1),
+(34, 342, 2, 2),
+(34, 342, 5, 3),
+(34, 342, 4, 4),
+(34, 342, 6, 5),
+(34, 342, 10, 6),
+(34, 342, 37, 7),
+(34, 342, 9, 8),
+(34, 343, 1, 1),
+(34, 343, 2, 2),
+(34, 343, 5, 3),
+(34, 343, 4, 4),
+(34, 343, 6, 5),
+(34, 343, 10, 6),
+(34, 344, 1, 1),
+(34, 344, 2, 2),
+(34, 344, 5, 3),
+(34, 344, 4, 4),
+(34, 344, 6, 5),
+(34, 345, 1, 1),
+(34, 345, 2, 2),
+(34, 345, 5, 3),
+(34, 345, 4, 4),
+(34, 345, 6, 5),
+(34, 346, 1, 1),
+(34, 346, 2, 2),
+(34, 346, 5, 3),
+(34, 346, 4, 4),
+(34, 346, 6, 5),
+(34, 346, 9, 6),
+(34, 347, 1, 1),
+(34, 347, 2, 2),
+(34, 347, 5, 3),
+(34, 347, 4, 4),
+(34, 347, 6, 5),
+(34, 348, 1, 1),
+(34, 348, 2, 2),
+(34, 348, 5, 3),
+(34, 348, 4, 4),
+(34, 348, 6, 5),
+(34, 348, 10, 6)");
+
+ // API array elements - Adminlose.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
+(35, 349, 1, 1),
+(35, 349, 2, 2),
+(35, 349, 4, 3),
+(35, 349, 5, 4),
+(35, 349, 6, 5),
+(35, 349, 10, 6),
+(35, 350, 1, 1),
+(35, 350, 2, 2),
+(35, 350, 4, 3),
+(35, 350, 5, 4),
+(35, 350, 6, 5),
+(35, 350, 9, 6),
+(35, 351, 1, 1),
+(35, 351, 2, 2),
+(35, 351, 4, 3),
+(35, 351, 5, 4),
+(35, 351, 6, 5),
+(35, 352, 1, 1),
+(35, 352, 2, 2),
+(35, 352, 4, 3),
+(35, 352, 5, 4),
+(35, 352, 6, 5),
+(35, 352, 9, 6),
+(35, 353, 1, 1),
+(35, 353, 2, 2),
+(35, 353, 5, 3),
+(35, 353, 6, 4),
+(35, 353, 10, 5),
+(35, 353, 37, 6),
+(35, 353, 9, 7),
+(35, 354, 1, 1),
+(35, 354, 2, 2),
+(35, 354, 4, 3),
+(35, 354, 5, 4),
+(35, 354, 6, 5),
+(35, 355, 1, 1),
+(35, 355, 2, 2),
+(35, 355, 4, 3),
+(35, 355, 5, 4),
+(35, 355, 6, 5),
+(35, 355, 10, 6),
+(35, 356, 1, 1),
+(35, 356, 2, 2),
+(35, 356, 4, 3),
+(35, 356, 5, 4),
+(35, 356, 6, 5),
+(35, 356, 10, 6)");
+
// API array elements - AdPaid
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(5, 177, 7, 1),
(5, 177, 2, 2),
(5, 177, 3, 3),
(5, 185, 9, 9)");
// API array elements - Ads4.de
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(6, 14, 7, 1),
(6, 14, 2, 2),
(6, 14, 6, 3),
(6, 119, 10, 6)");
// API array elements - Ads4Webbis
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(7, 17, 1, 1),
(7, 17, 2, 2),
(7, 17, 4, 3),
(7, 120, 27, 8)");
// API array elements - Ads4World
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(8, 26, 1, 1),
(8, 26, 2, 2),
(8, 26, 4, 3),
// API array elements - Affiliblatt
// API array elements - AllAds4You
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(10, 167, 1, 1),
(10, 167, 2, 2),
(10, 167, 4, 3),
(10, 176, 40, 8)");
// API array elements - Alster-Marketing
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(11, 35, 7, 1),
(11, 35, 2, 2),
(11, 35, 3, 3),
(11, 49, 6, 5)");
// API array elements - BonusSponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(12, 50, 7, 1),
(12, 50, 2, 2),
(12, 50, 3, 3),
(12, 62, 9, 19)");
// API array elements - City-Ads
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(24, 212, 1, 1),
(24, 212, 2, 2),
(24, 212, 4, 3),
(24, 221, 27, 8)");
// API array elements - doubleads
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(26, 232, 1, 1),
(26, 232, 2, 2),
(26, 232, 3, 3),
(26, 246, 25, 10)");
// API array elements - FuCoExSponsor.net
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(29, 273, 7, 1),
(29, 273, 2, 2),
(29, 273, 5, 3),
(29, 289, 10, 6)");
// API array elements - Fusion-Ads
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(13, 290, 1, 1),
(13, 290, 2, 2),
(13, 290, 6, 3),
(13, 291, 10, 8)");
// API array elements - GigaPromo
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(14, 102, 7, 1),
(14, 102, 2, 2),
(14, 102, 4, 3),
(14, 122, 6, 5)");
// API array elements - Gold-Sponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(25, 222, 1, 1),
(25, 222, 2, 2),
(25, 222, 4, 3),
(25, 231, 9, 7)");
// API array elements - homeADS
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(28, 260, 1, 1),
(28, 260, 2, 2),
(28, 260, 3, 3),
(28, 272, 5, 10)");
// API array elements - HPSponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(15, 135, 1, 1),
(15, 135, 2, 2),
(15, 135, 4, 3),
(15, 144, 27, 8)");
// API array elements - Make-Euros.de
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(16, 63, 7, 1),
(16, 63, 2, 2),
(16, 63, 3, 3),
(16, 76, 9, 9)");
// API array elements - Mega-Ad
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(17, 109, 1, 1),
(17, 109, 2, 2),
(17, 109, 4, 3),
(17, 123, 6, 5)");
// API array elements - Power-Promo
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(18, 78, 7, 1),
(18, 78, 2, 2),
(18, 78, 3, 3),
(18, 92, 25, 10)");
// API array elements - SeCash
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(19, 93, 1, 1),
(19, 93, 2, 2),
(19, 93, 4, 3),
(19, 124, 6, 5)");
// API array elements - The Swizerland Ad Network
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(20, 200, 6, 5),
(20, 202, 1, 1),
(20, 202, 2, 2),
(20, 211, 27, 8)");
// API array elements - UltraPOMO
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(21, 125, 1, 1),
(21, 125, 2, 2),
(21, 125, 4, 3),
(21, 134, 6, 5)");
// API array elements - VIPads
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(27, 247, 7, 1),
(27, 247, 2, 2),
(27, 247, 5, 3),
(27, 259, 10, 6)");
// API array elements - Der Werbepartner.cc
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(22, 145, 1, 1),
(22, 145, 2, 2),
(22, 145, 6, 3),
(22, 155, 10, 7)");
// API array elements - Yoo!Media
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`,`network_type_id`,`network_api_index`,`sort`) VALUES
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_array_translation` (`network_id`,`network_type_id`,`network_array_index`,`sort`) VALUES
(23, 156, 1, 1),
(23, 156, 2, 2),
(23, 156, 3, 3),
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_network_api', 'API-Zugangsdaten', 'Stellen Sie Ihre Affiliate- Webseiten-Id und API-Passwort ein. Diese erhalten Sie aus dem Affiliate-Bereich des jeweiligen Werbenetzwerkes. Sollten Sie bei einem Werbenetzwerk noch nicht angemeldet sein, verwenden Sie bitte meinen Referral-Link dazu.',1);
addAdminMenuSql('network', 'config_network_types', 'Werbearten', 'Stellen Sie hier Reload-Zeiten, Mindestauffenthalt und so weiter pro Werbeart und Werbenetzwerk ein. Es werden sonst Ausgangswerte (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', 'query_network_apis', '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>Entwicklereinstellungen!</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-Handler', '<strong>Entwicklereinstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten-Handler 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>Entwicklereinstellungen!</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_a
pi_translation', 'Antwort-Array', '<strong>Entwicklereinstellungen!</strong> Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. 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);
- addAdminMenuSql('network', 'list_network_error_codes', 'Fehlercodes', '<strong>Entwicklereinstellungen!</strong> Hier stellen Sie die Fehlercodes 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.', 11);
+ addAdminMenuSql('network', 'list_networks', '
Dev-Grunddaten', '<strong>Entwicklereinstellungen!</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', '
Dev-Werbearten-Handler', '<strong>Entwicklereinstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten-Handler 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', '
Dev-Abfrageparameter', '<strong>Entwicklereinstellungen!</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_a
rray_translation', 'Dev-Antwort-Array', '<strong>Entwicklereinstellungen!</strong> Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. 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);
+ addAdminMenuSql('network', 'list_network_error_codes', '
Dev-Fehlercodes', '<strong>Entwicklereinstellungen!</strong> Hier stellen Sie die Fehlercodes 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.', 11);
// Configuration entries
addConfigAddSql('network_cache_refresh', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (60 * 15));
addDropTableSql('network_types');
addDropTableSql('network_request_params');
addDropTableSql('network_error_codes');
- addDropTableSql('network_api_translation');
+ addDropTableSql('network_array_translation');
addDropTableSql('network_api_config');
addDropTableSql('network_types_config');
addDropTableSql('network_cache');
projects / mailer.git / blobdiff