X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-network.php;h=82af41e464d91af9e751597894dd6203ed83dd8f;hb=675778ff98b75b6c5071e2709c2d6b0af86cf79d;hp=ef2cd29ecbe806076f0d9bd86a90401d251ae484;hpb=3d152f10b976cd162d6587ade5b483afa169fef4;p=mailer.git diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php index ef2cd29ecb..82af41e464 100644 --- a/inc/extensions/ext-network.php +++ b/inc/extensions/ext-network.php @@ -108,8 +108,8 @@ PRIMARY KEY (`network_type_id`) `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_key` VARCHAR(20) NOT NULL DEFAULT 'invalid', +`request_param_value` VARCHAR(20) 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`), @@ -148,17 +148,17 @@ 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_return_types`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_return_types` ( -`network_return_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, + addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_array_translation`'); + addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_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_return_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, +`network_array_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0, `network_index_translation` VARCHAR(100) NOT NULL DEFAULT '', -UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_return_index`), +UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_array_index`), UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_index_translation`), -PRIMARY KEY (`network_return_id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Return types'"); +PRIMARY KEY (`network_array_id`) +) TYPE={?_TABLE_TYPE?} COMMENT='Translation of API responses'"); // Data from the webmaster (you!) addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`'); @@ -233,7 +233,7 @@ PRIMARY KEY (`network_reload_id`) // - Webmaster's site id is not unlocked for choosen type addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('SITE_ID_NOT_ALLOWED_TYPE')"); // - Request parameters incomplete - addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('REQUEST_PARAMS_INCOMPLETE')"); + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('REQUEST_PARAMETER_INCOMPLETE')"); // Sponsor networks addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`) VALUES @@ -256,6 +256,7 @@ PRIMARY KEY (`network_reload_id`) ('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252'), ('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252'), ('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252'), +('swizerland', 'The-Swizerland-Ad-Network', 'http://www.the-switzerland-ad-network.ch?ref=3', '|', '|', 'GET', 'WINDOWS-1252'), ('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252'), ('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252'), ('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252')"); @@ -275,6 +276,22 @@ PRIMARY KEY (`network_reload_id`) (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 + 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 +(187, 2, 'banner_click', 'http://www.abiszed-netz.de/interface/out_banner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'), +(188, 2, 'banner_view', 'http://www.abiszed-netz.de/interface/out_banner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'), +(189, 2, 'textlink_click', 'http://www.abiszed-netz.de/interface/out_textlink.php', 'http://www.abiszed-netz.de/textlinkklick.php?id=%CID%', NULL), +(190, 2, 'textlink_view', 'http://www.abiszed-netz.de/interface/out_textlink.php', 'http://www.abiszed-netz.de/textlinkklick.php?id=%CID%', NULL), +(191, 2, 'surfbar_click', 'http://www.abiszed-netz.de/interface/out_sbanner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'), +(192, 2, 'surfbar_view', 'http://www.abiszed-netz.de/interface/out_sbanner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'), +(193, 2, 'forcedbanner', 'http://www.abiszed-netz.de/interface/out_fbanner.php', 'http://www.abiszed-netz.de/bannerklf.php?id=%CID%', 'http://www.abiszed-netz.de/banner.php?id=%CID%'), +(194, 2, 'textmail', 'http://www.abiszed-netz.de/interface/out_paidmail.php', 'http://www.abiszed-netz.de/emailf.php?id=%CID%', NULL), +(195, 2, 'htmlmail', 'http://www.abiszed-netz.de/interface/out_paidmail.php', 'http://www.abiszed-netz.de/emailf.php?id=%CID%', NULL), +(196, 2, 'layer_click', 'http://www.abiszed-netz.de/interface/out_layer.php', 'http://www.abiszed-netz.de/layer.php?id=%CID%', NULL), +(197, 2, 'layer_view', 'http://www.abiszed-netz.de/interface/out_layer.php', 'http://www.abiszed-netz.de/layer.php?id=%CID%', NULL), +(198, 2, 'popup', 'http://www.abiszed-netz.de/interface/out_popup.php', 'http://www.abiszed-netz.de/popup.php?id=%CID%', NULL), +(199, 2, 'popdown', 'http://www.abiszed-netz.de/interface/out_popdown.php', 'http://www.abiszed-netz.de/popdown.php?id=%CID%', NULL), +(200, 2, 'lead', 'http://www.abiszed-netz.de/interface/out_lead.php', 'http://www.abiszed-netz.de/lead.php?id=%CID%', NULL), +(201, 2, 'sale', 'http://www.abiszed-netz.de/interface/out_sale.php', 'http://www.abiszed-netz.de/sale.php?id=%CID%', NULL)"); // Network type handlers - Ad-Magnet @@ -466,46 +483,59 @@ PRIMARY KEY (`network_reload_id`) (101, 19, 'textmail', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), (124, 19, 'traffic', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)"); + // Network type handlers - Swizerland + addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES +(205, 20, 'banner_click', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'), +(204, 20, 'banner_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(207, 20, 'button_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(202, 20, 'forcedbanner', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(203, 20, 'forcedtextlink', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(210, 20, 'popup', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(206, 20, 'skybanner_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.the-switzerland-ad-network.ch/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'), +(208, 20, 'textlink_view', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(211, 20, 'textmail', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(209, 20, 'traffic', 'http://www.the-switzerland-ad-network.ch/interface/', 'http://www.the-switzerland-ad-network.ch/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, 20, '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, 20, '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, 20, '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, 20, '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, 20, 'forcedtextlink', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(130, 20, 'popup', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(131, 20, '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, 20, 'textlink_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(133, 20, 'textmail', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), -(134, 20, 'traffic', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)"); +(125, 21, '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, 21, '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, 21, '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, 21, '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, 21, 'forcedtextlink', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(130, 21, 'popup', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(131, 21, '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, 21, 'textlink_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(133, 21, 'textmail', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL), +(134, 21, '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 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 -(145, 21, 'textlink_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL), -(146, 21, 'forcedbanner', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php'), -(147, 21, 'textmail', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL), -(148, 21, 'layer', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), -(149, 21, 'skybanner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'), -(150, 21, 'surfbar_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), -(151, 21, 'banner_view', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'), -(152, 21, 'popup', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), -(153, 21, 'banner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'), -(154, 21, 'forcedtextlink', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), -(155, 21, 'traffic', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL)"); +(145, 22, 'textlink_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL), +(146, 22, 'forcedbanner', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php'), +(147, 22, 'textmail', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL), +(148, 22, 'layer', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), +(149, 22, 'skybanner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'), +(150, 22, 'surfbar_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), +(151, 22, 'banner_view', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'), +(152, 22, 'popup', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), +(153, 22, 'banner_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php'), +(154, 22, 'forcedtextlink', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL), +(155, 22, 'traffic', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL)"); // Network type handlers - Yoo!Media 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 -(156, 22, 'banner_click', 'http://www.yoomedia.de/interface_2.0/out_banner.php', 'http://www.yoomedia.de/code/z-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/z-banner.php?id=%UID%&sid=%SID%&bid=%BID%'), -(157, 22, 'textlink_click', 'http://www.yoomedia.de/interface_2.0/out_textlink.php', 'http://www.yoomedia.de/code/t-textlink.php?id=%UID%&sid=%SID%', NULL), -(158, 22, 'surfbar_click', 'http://www.yoomedia.de/interface_2.0/out_sbanner.php', 'http://www.yoomedia.de/code/s-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/s-banner.php?id=%UID%&sid=%SID%&bid=%BID%'), -(159, 22, 'forcedbanner', 'http://www.yoomedia.de/interface_2.0/out_fbanner.php', 'http://www.yoomedia.de/code/f-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/f-banner.php?id=%UID%&sid=%SID%&bid=%BID%'), -(160, 22, 'pagepeel', 'http://www.yoomedia.de/interface_2.0/out_pagepeel.php', 'http://www.yoomedia.de/code/p-peel.php?id=%UID%&sid=%SID%', NULL), -(161, 22, 'textmail', 'http://www.yoomedia.de/interface_2.0/out_textmail.php', 'http://www.yoomedia.de/code/t-mail.php?id=%UID%&sid=%SID%', NULL), -(162, 22, 'htmlmail', 'http://www.yoomedia.de/interface_2.0/out_htmlmail.php', 'http://www.yoomedia.de/code/h-mail.php?id=%UID%&sid=%SID%', NULL), -(163, 22, 'layer_click', 'http://www.yoomedia.de/interface_2.0/out_layer.php', 'http://www.yoomedia.de/code/l-layer.php?id=%UID%&sid=%SID%', NULL), -(164, 22, 'popup', 'http://www.yoomedia.de/interface_2.0/out_popup.php', 'http://www.yoomedia.de/code/p-popup.php?id=%UID%&sid=%SID%', NULL), -(165, 22, 'popdown', 'http://www.yoomedia.de/interface_2.0/out_popdown.php', 'http://www.yoomedia.de/code/p-popdown.php?id=%UID%&sid=%SID%', NULL), -(166, 22, 'lead', 'http://www.yoomedia.de/interface_2.0/out_lead.php', 'http://www.yoomedia.de/code/lead.php?id=%UID%&sid=%SID%', NULL)"); +(156, 23, 'banner_click', 'http://www.yoomedia.de/interface_2.0/out_banner.php', 'http://www.yoomedia.de/code/z-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/z-banner.php?id=%UID%&sid=%SID%&bid=%BID%'), +(157, 23, 'textlink_click', 'http://www.yoomedia.de/interface_2.0/out_textlink.php', 'http://www.yoomedia.de/code/t-textlink.php?id=%UID%&sid=%SID%', NULL), +(158, 23, 'surfbar_click', 'http://www.yoomedia.de/interface_2.0/out_sbanner.php', 'http://www.yoomedia.de/code/s-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/s-banner.php?id=%UID%&sid=%SID%&bid=%BID%'), +(159, 23, 'forcedbanner', 'http://www.yoomedia.de/interface_2.0/out_fbanner.php', 'http://www.yoomedia.de/code/f-bannerklf.php?id=%UID%&sid=%SID%', 'http://www.yoomedia.de/code/f-banner.php?id=%UID%&sid=%SID%&bid=%BID%'), +(160, 23, 'pagepeel', 'http://www.yoomedia.de/interface_2.0/out_pagepeel.php', 'http://www.yoomedia.de/code/p-peel.php?id=%UID%&sid=%SID%', NULL), +(161, 23, 'textmail', 'http://www.yoomedia.de/interface_2.0/out_textmail.php', 'http://www.yoomedia.de/code/t-mail.php?id=%UID%&sid=%SID%', NULL), +(162, 23, 'htmlmail', 'http://www.yoomedia.de/interface_2.0/out_htmlmail.php', 'http://www.yoomedia.de/code/h-mail.php?id=%UID%&sid=%SID%', NULL), +(163, 23, 'layer_click', 'http://www.yoomedia.de/interface_2.0/out_layer.php', 'http://www.yoomedia.de/code/l-layer.php?id=%UID%&sid=%SID%', NULL), +(164, 23, 'popup', 'http://www.yoomedia.de/interface_2.0/out_popup.php', 'http://www.yoomedia.de/code/p-popup.php?id=%UID%&sid=%SID%', NULL), +(165, 23, 'popdown', 'http://www.yoomedia.de/interface_2.0/out_popdown.php', 'http://www.yoomedia.de/code/p-popdown.php?id=%UID%&sid=%SID%', NULL), +(166, 23, 'lead', 'http://www.yoomedia.de/interface_2.0/out_lead.php', 'http://www.yoomedia.de/code/lead.php?id=%UID%&sid=%SID%', NULL)"); // 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 @@ -514,7 +544,7 @@ PRIMARY KEY (`network_reload_id`) (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), +(6, 1, 1, 'minimum_stay', 'ma', NULL), (7, 1, 1, 'type', 'typ', NULL), (8, 1, 1, 'remain', 'uebrig', NULL), (9, 1, 1, 'size', 'size', NULL), @@ -537,7 +567,7 @@ PRIMARY KEY (`network_reload_id`) (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), +(29, 1, 4, 'minimum_stay', 'ma', NULL), (30, 1, 4, 'remain', 'uebrig', NULL), (31, 1, 4, 'size', 'size', NULL), (32, 1, 5, 'id', 'id', NULL), @@ -545,7 +575,7 @@ PRIMARY KEY (`network_reload_id`) (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), +(37, 1, 5, 'minimum_stay', 'ma', NULL), (38, 1, 5, 'type', 'typ', 'text'), (39, 1, 5, 'remain', 'uebrig', NULL), (40, 1, 11, 'id', 'id', NULL), @@ -553,7 +583,7 @@ PRIMARY KEY (`network_reload_id`) (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), +(45, 1, 11, 'minimum_stay', 'ma', NULL), (46, 1, 11, 'type', 'typ', 'html'), (47, 1, 11, 'remain', 'uebrig', NULL), (48, 1, 6, 'id', 'id', NULL), @@ -568,14 +598,14 @@ PRIMARY KEY (`network_reload_id`) (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), +(60, 1, 7, 'minimum_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), +(67, 1, 8, 'minimum_stay', 'ma', NULL), (68, 1, 8, 'remain', 'uebrig', NULL), (69, 1, 9, 'id', 'id', NULL), (70, 1, 9, 'sid', 'sid', NULL), @@ -589,6 +619,115 @@ PRIMARY KEY (`network_reload_id`) (78, 1, 10, 'remain', 'uebrig', NULL)"); // Request parameters per type handler - AbisZED-Netz + 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 +(1337, 2, 187, 'id', 'id', NULL), +(1338, 2, 187, 'sid', 'sid', NULL), +(1339, 2, 187, 'password', 'pw', NULL), +(1340, 2, 187, 'reward', 'verguetung', NULL), +(1341, 2, 187, 'reload', 'reload', NULL), +(1342, 2, 187, 'remain', 'uebrig', NULL), +(1343, 2, 187, 'type', 'typ', 'klick'), +(1344, 2, 187, 'size', 'size', NULL), +(1345, 2, 188, 'id', 'id', NULL), +(1346, 2, 188, 'sid', 'sid', NULL), +(1347, 2, 188, 'password', 'pw', NULL), +(1349, 2, 188, 'reward', 'verguetung', NULL), +(1350, 2, 188, 'reload', 'reload', NULL), +(1351, 2, 188, 'remain', 'uebrig', NULL), +(1352, 2, 188, 'type', 'typ', 'view'), +(1353, 2, 188, 'size', 'size', NULL), +(1354, 2, 189, 'id', 'id', NULL), +(1355, 2, 189, 'sid', 'sid', NULL), +(1356, 2, 189, 'password', 'pw', NULL), +(1357, 2, 189, 'reward', 'verguetung', NULL), +(1358, 2, 189, 'reload', 'reload', NULL), +(1359, 2, 189, 'remain', 'uebrig', NULL), +(1360, 2, 189, 'type', 'typ', 'klick'), +(1361, 2, 190, 'id', 'id', NULL), +(1362, 2, 190, 'sid', 'sid', NULL), +(1363, 2, 190, 'password', 'pw', NULL), +(1364, 2, 190, 'reward', 'verguetung', NULL), +(1365, 2, 190, 'reload', 'reload', NULL), +(1366, 2, 190, 'remain', 'uebrig', NULL), +(1367, 2, 190, 'type', 'typ', 'view'), +(1368, 2, 191, 'id', 'id', NULL), +(1369, 2, 191, 'sid', 'sid', NULL), +(1370, 2, 191, 'password', 'pw', NULL), +(1371, 2, 191, 'reward', 'verguetung', NULL), +(1372, 2, 191, 'reload', 'reload', NULL), +(1373, 2, 191, 'remain', 'uebrig', NULL), +(1374, 2, 191, 'type', 'typ', 'klick'), +(1375, 2, 191, 'size', 'size', NULL), +(1376, 2, 192, 'id', 'id', NULL), +(1377, 2, 192, 'sid', 'sid', NULL), +(1378, 2, 192, 'password', 'pw', NULL), +(1379, 2, 192, 'reward', 'verguetung', NULL), +(1380, 2, 192, 'reload', 'reload', NULL), +(1381, 2, 192, 'remain', 'uebrig', NULL), +(1382, 2, 192, 'type', 'typ', 'view'), +(1383, 2, 192, 'size', 'size', NULL), +(1384, 2, 193, 'id', 'id', NULL), +(1385, 2, 193, 'sid', 'sid', NULL), +(1386, 2, 193, 'password', 'pw', NULL), +(1387, 2, 193, 'reward', 'verguetung', NULL), +(1388, 2, 193, 'reload', 'reload', NULL), +(1389, 2, 193, 'remain', 'uebrig', NULL), +(1390, 2, 193, 'size', 'size', NULL), +(1391, 2, 193, 'minimum_stay', 'ma', NULL), +(1392, 2, 194, 'id', 'id', NULL), +(1393, 2, 194, 'sid', 'sid', NULL), +(1394, 2, 194, 'password', 'pw', NULL), +(1395, 2, 194, 'reward', 'verguetung', NULL), +(1396, 2, 194, 'reload', 'reload', NULL), +(1397, 2, 194, 'remain', 'uebrig', NULL), +(1398, 2, 194, 'minimum_stay', 'ma', NULL), +(1399, 2, 194, 'type', 'typ', 'text'), +(1400, 2, 195, 'id', 'id', NULL), +(1401, 2, 195, 'sid', 'sid', NULL), +(1402, 2, 195, 'password', 'pw', NULL), +(1403, 2, 195, 'reward', 'verguetung', NULL), +(1404, 2, 195, 'reload', 'reload', NULL), +(1405, 2, 195, 'remain', 'uebrig', NULL), +(1406, 2, 195, 'minimum_stay', 'ma', NULL), +(1407, 2, 195, 'type', 'typ', 'html'), +(1408, 2, 196, 'id', 'id', NULL), +(1409, 2, 196, 'sid', 'sid', NULL), +(1410, 2, 196, 'password', 'pw', NULL), +(1411, 2, 196, 'reward', 'verguetung', NULL), +(1412, 2, 196, 'reload', 'reload', NULL), +(1413, 2, 196, 'remain', 'uebrig', NULL), +(1414, 2, 196, 'type', 'typ', 'klick'), +(1415, 2, 197, 'id', 'id', NULL), +(1416, 2, 197, 'sid', 'sid', NULL), +(1417, 2, 197, 'password', 'pw', NULL), +(1418, 2, 197, 'reward', 'verguetung', NULL), +(1419, 2, 197, 'reload', 'reload', NULL), +(1420, 2, 197, 'remain', 'uebrig', NULL), +(1421, 2, 197, 'type', 'typ', 'view'), +(1422, 2, 198, 'id', 'id', NULL), +(1423, 2, 198, 'sid', 'sid', NULL), +(1424, 2, 198, 'password', 'pw', NULL), +(1425, 2, 198, 'reward', 'verguetung', NULL), +(1426, 2, 198, 'reload', 'reload', NULL), +(1427, 2, 198, 'remain', 'uebrig', NULL), +(1428, 2, 198, 'minimum_stay', 'ma', NULL), +(1429, 2, 199, 'id', 'id', NULL), +(1430, 2, 199, 'sid', 'sid', NULL), +(1431, 2, 199, 'password', 'pw', NULL), +(1432, 2, 199, 'reward', 'verguetung', NULL), +(1433, 2, 199, 'reload', 'reload', NULL), +(1434, 2, 199, 'remain', 'uebrig', NULL), +(1435, 2, 199, 'max_stay', 'ma', NULL), +(1436, 2, 200, 'id', 'id', NULL), +(1437, 2, 200, 'sid', 'sid', NULL), +(1438, 2, 200, 'password', 'pw', NULL), +(1439, 2, 200, 'reward', 'verguetung', NULL), +(1440, 2, 200, 'remain', 'uebrig', NULL), +(1441, 2, 201, 'id', 'id', NULL), +(1442, 2, 201, 'sid', 'sid', NULL), +(1443, 2, 201, 'password', 'pw', NULL), +(1444, 2, 201, 'reward', 'verguetung', NULL), +(1445, 2, 201, 'remain', 'uebrig', NULL)"); // Request parameters per type handler - Ad-Magnet @@ -626,14 +765,14 @@ PRIMARY KEY (`network_reload_id`) (1286, 5, 180, 'reload', 'reload', NULL), (1287, 5, 180, 'remain', 'uebrig', NULL), (1288, 5, 180, 'size', 'size', '468x60'), -(1289, 5, 180, 'min_stay', 'ma', NULL), +(1289, 5, 180, 'minimum_stay', 'ma', NULL), (1290, 5, 181, 'id', 'id', NULL), (1291, 5, 181, 'sid', 'sid', NULL), (1292, 5, 181, 'password', 'pw', NULL), (1293, 5, 181, 'reload', 'reload', NULL), (1294, 5, 181, 'reward', 'verguetung', NULL), (1295, 5, 181, 'remain', 'uebrig', NULL), -(1296, 5, 181, 'min_stay', 'ma', NULL), +(1296, 5, 181, 'minimum_stay', 'ma', NULL), (1297, 5, 181, 'type', 'typ', 'text'), (1306, 5, 182, 'id', 'id', NULL), (1307, 5, 182, 'sid', 'sid', NULL), @@ -648,14 +787,14 @@ PRIMARY KEY (`network_reload_id`) (1316, 5, 183, 'reload', 'reload', NULL), (1317, 5, 183, 'reward', 'verguetung', NULL), (1318, 5, 183, 'remain', 'uebrig', NULL), -(1319, 5, 183, 'min_stay', 'ma', NULL), +(1319, 5, 183, 'minimum_stay', 'ma', NULL), (1320, 5, 184, 'id', 'id', NULL), (1321, 5, 184, 'sid', 'sid', NULL), (1322, 5, 184, 'password', 'pw', NULL), (1323, 5, 184, 'reload', 'reload', NULL), (1324, 5, 184, 'reward', 'verguetung', NULL), (1325, 5, 184, 'remain', 'uebrig', NULL), -(1326, 5, 184, 'min_stay', 'ma', NULL), +(1326, 5, 184, 'minimum_stay', 'ma', NULL), (1327, 5, 185, 'id', 'id', NULL), (1328, 5, 185, 'sid', 'sid', NULL), (1329, 5, 185, 'password', 'pw', NULL), @@ -672,7 +811,7 @@ PRIMARY KEY (`network_reload_id`) (1301, 5, 187, 'reload', 'reload', NULL), (1302, 5, 187, 'reward', 'verguetung', NULL), (1303, 5, 187, 'remain', 'uebrig', NULL), -(1304, 5, 187, 'min_stay', 'ma', NULL), +(1304, 5, 187, 'minimum_stay', 'ma', NULL), (1305, 5, 187, 'type', 'typ', 'html')"); // Request parameters per type handler - Ads4 @@ -684,7 +823,7 @@ PRIMARY KEY (`network_reload_id`) (83, 6, 14, 'reward', 'verg', NULL), (84, 6, 14, 'reload', 'reload', NULL), (85, 6, 14, 'remain', 'uebrig', NULL), -(86, 6, 14, 'min_stay', 'ma', NULL), +(86, 6, 14, 'minimum_stay', 'ma', NULL), (87, 6, 15, 'id', 'id', NULL), (88, 6, 15, 'password', 'pwd', NULL), (89, 6, 15, 'currency', 'waehrung', NULL), @@ -692,7 +831,7 @@ PRIMARY KEY (`network_reload_id`) (91, 6, 15, 'reward', 'verg', NULL), (92, 6, 15, 'reload', 'reload', NULL), (93, 6, 15, 'remain', 'uebrig', NULL), -(94, 6, 15, 'min_stay', 'ma', NULL), +(94, 6, 15, 'minimum_stay', 'ma', NULL), (95, 6, 16, 'id', 'id', NULL), (96, 6, 16, 'password', 'pw', NULL), (97, 6, 16, 'currency', 'waehrung', NULL), @@ -700,7 +839,7 @@ PRIMARY KEY (`network_reload_id`) (99, 6, 16, 'reward', 'verg', NULL), (100, 6, 16, 'reload', 'reload', NULL), (101, 6, 16, 'remain', 'uebrig', NULL), -(102, 6, 16, 'min_stay', 'ma', NULL), +(102, 6, 16, 'minimum_stay', 'ma', NULL), (789, 6, 119, 'id', 'id', NULL), (790, 6, 119, 'password', 'pwd', NULL), (791, 6, 119, 'currency', 'waehrung', NULL), @@ -708,7 +847,7 @@ PRIMARY KEY (`network_reload_id`) (793, 6, 119, 'reward', 'verg', NULL), (794, 6, 119, 'reload', 'reload', NULL), (795, 6, 119, 'remain', 'uebrig', NULL), -(796, 6, 119, 'min_stay', 'ma', NULL)"); +(796, 6, 119, 'minimum_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 @@ -760,14 +899,14 @@ PRIMARY KEY (`network_reload_id`) (148, 7, 24, 'remain', 'uebrig', NULL), (149, 7, 24, 'reload', 'reload', NULL), (150, 7, 24, 'reward', 'verguetung', NULL), -(151, 7, 24, 'min_stay', 'ma', NULL), +(151, 7, 24, 'minimum_stay', 'ma', NULL), (152, 7, 25, 'extra', 'typ', 'paidmail'), (153, 7, 25, 'id', 'id', NULL), (154, 7, 25, 'password', 'pw', NULL), (155, 7, 25, 'remain', 'uebrig', NULL), (156, 7, 25, 'reload', 'reload', NULL), (157, 7, 25, 'reward', 'verguetung', NULL), -(158, 7, 25, 'min_stay', 'ma', NULL), +(158, 7, 25, 'minimum_stay', 'ma', NULL), (797, 7, 120, 'extra', 'typ', 'traffic'), (798, 7, 120, 'id', 'id', NULL), (799, 7, 120, 'password', 'pw', NULL), @@ -813,7 +952,7 @@ PRIMARY KEY (`network_reload_id`) (192, 8, 33, 'remain', 'uebrig', NULL), (193, 8, 33, 'reload', 'reload', NULL), (194, 8, 33, 'reward', 'verguetung', NULL), -(195, 8, 33, 'min_stay', 'ma', NULL), +(195, 8, 33, 'minimum_stay', 'ma', NULL), (196, 8, 30, 'extra', 'typ', 'skybannerview'), (197, 8, 30, 'id', 'id', NULL), (198, 8, 30, 'password', 'pw', NULL), @@ -832,7 +971,7 @@ PRIMARY KEY (`network_reload_id`) (211, 8, 34, 'remain', 'uebrig', NULL), (212, 8, 34, 'reload', 'reload', NULL), (213, 8, 34, 'reward', 'verguetung', NULL), -(214, 8, 34, 'min_stay', 'ma', NULL), +(214, 8, 34, 'minimum_stay', 'ma', NULL), (803, 8, 121, 'extra', 'typ', 'traffic'), (804, 8, 121, 'id', 'id', NULL), (805, 8, 121, 'password', 'pw', NULL), @@ -970,14 +1109,14 @@ PRIMARY KEY (`network_reload_id`) (265, 11, 38, 'reload', 'reload', NULL), (266, 11, 38, 'remain', 'uebrig', NULL), (267, 11, 38, 'size', 'size', NULL), -(268, 11, 38, 'min_stay', 'ma', NULL), +(268, 11, 38, 'minimum_stay', 'ma', NULL), (269, 11, 39, 'id', 'id', NULL), (270, 11, 39, 'sid', 'sid', NULL), (271, 11, 39, 'password', 'pw', NULL), (272, 11, 39, 'reward', 'verguetung', NULL), (273, 11, 39, 'reload', 'reload', NULL), (274, 11, 39, 'remain', 'uebrig', NULL), -(275, 11, 39, 'min_stay', 'ma', NULL), +(275, 11, 39, 'minimum_stay', 'ma', NULL), (276, 11, 39, 'type', 'typ', 'text'), (277, 11, 48, 'id', 'id', NULL), (278, 11, 48, 'sid', 'sid', NULL), @@ -985,7 +1124,7 @@ PRIMARY KEY (`network_reload_id`) (280, 11, 48, 'reward', 'verguetung', NULL), (281, 11, 48, 'reload', 'reload', NULL), (282, 11, 48, 'remain', 'uebrig', NULL), -(283, 11, 48, 'min_stay', 'ma', NULL), +(283, 11, 48, 'minimum_stay', 'ma', NULL), (284, 11, 48, 'type', 'typ', 'html'), (285, 11, 40, 'id', 'id', NULL), (286, 11, 40, 'sid', 'sid', NULL), @@ -1007,14 +1146,14 @@ PRIMARY KEY (`network_reload_id`) (302, 11, 41, 'reward', 'verguetung', NULL), (303, 11, 41, 'reload', 'reload', NULL), (304, 11, 41, 'remain', 'uebrig', NULL), -(305, 11, 41, 'min_stay', 'ma', NULL), +(305, 11, 41, 'minimum_stay', 'ma', NULL), (306, 11, 42, 'id', 'id', NULL), (307, 11, 42, 'sid', 'sid', NULL), (308, 11, 42, 'password', 'pw', NULL), (309, 11, 42, 'reward', 'verguetung', NULL), (310, 11, 42, 'reload', 'reload', NULL), (311, 11, 42, 'remain', 'uebrig', NULL), -(312, 11, 42, 'min_stay', 'ma', NULL), +(312, 11, 42, 'minimum_stay', 'ma', NULL), (313, 11, 43, 'id', 'id', NULL), (314, 11, 43, 'sid', 'sid', NULL), (315, 11, 43, 'password', 'pw', NULL), @@ -1065,14 +1204,14 @@ PRIMARY KEY (`network_reload_id`) (357, 12, 54, 'reload', 'reload', NULL), (358, 12, 54, 'remain', 'uebrig', NULL), (359, 12, 54, 'size', 'size', NULL), -(360, 12, 54, 'min_stay', 'ma', NULL), +(360, 12, 54, 'minimum_stay', 'ma', NULL), (361, 12, 55, 'id', 'id', NULL), (362, 12, 55, 'sid', 'sid', NULL), (363, 12, 55, 'password', 'pw', NULL), (364, 12, 55, 'reward', 'verguetung', NULL), (365, 12, 55, 'reload', 'reload', NULL), (366, 12, 55, 'remain', 'uebrig', NULL), -(367, 12, 55, 'min_stay', 'ma', NULL), +(367, 12, 55, 'minimum_stay', 'ma', NULL), (368, 12, 55, 'type', 'typ', 'text'), (369, 12, 56, 'id', 'id', NULL), (370, 12, 56, 'sid', 'sid', NULL), @@ -1080,7 +1219,7 @@ PRIMARY KEY (`network_reload_id`) (372, 12, 56, 'reward', 'verguetung', NULL), (373, 12, 56, 'reload', 'reload', NULL), (374, 12, 56, 'remain', 'uebrig', NULL), -(375, 12, 56, 'min_stay', 'ma', NULL), +(375, 12, 56, 'minimum_stay', 'ma', NULL), (376, 12, 56, 'type', 'typ', 'html'), (377, 12, 57, 'id', 'id', NULL), (378, 12, 57, 'sid', 'sid', NULL), @@ -1102,14 +1241,14 @@ PRIMARY KEY (`network_reload_id`) (394, 12, 59, 'reward', 'verguetung', NULL), (395, 12, 59, 'reload', 'reload', NULL), (396, 12, 59, 'remain', 'uebrig', NULL), -(397, 12, 59, 'min_stay', 'ma', NULL), +(397, 12, 59, 'minimum_stay', 'ma', NULL), (398, 12, 60, 'id', 'id', NULL), (399, 12, 60, 'sid', 'sid', NULL), (400, 12, 60, 'password', 'pw', NULL), (401, 12, 60, 'reward', 'verguetung', NULL), (402, 12, 60, 'reload', 'reload', NULL), (403, 12, 60, 'remain', 'uebrig', NULL), -(404, 12, 60, 'min_stay', 'ma', NULL), +(404, 12, 60, 'minimum_stay', 'ma', NULL), (405, 12, 61, 'id', 'id', NULL), (406, 12, 61, 'sid', 'sid', NULL), (407, 12, 61, 'password', 'pw', NULL), @@ -1230,14 +1369,14 @@ PRIMARY KEY (`network_reload_id`) (940, 15, 143, 'remain', 'uebrig', NULL), (941, 15, 143, 'reload', 'reload', NULL), (942, 15, 143, 'reward', 'verguetung', NULL), -(943, 15, 143, 'min_stay', 'ma', NULL), +(943, 15, 143, 'minimum_stay', 'ma', NULL), (944, 15, 144, 'extra', 'typ', 'paidmail'), (945, 15, 144, 'id', 'id', NULL), (946, 15, 144, 'password', 'pw', NULL), (947, 15, 144, 'remain', 'uebrig', NULL), (948, 15, 144, 'reload', 'reload', NULL), (949, 15, 144, 'reward', 'verguetung', NULL), -(950, 15, 144, 'min_stay', 'ma', NULL)"); +(950, 15, 144, 'minimum_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 @@ -1294,14 +1433,14 @@ PRIMARY KEY (`network_reload_id`) (465, 16, 68, 'reload', 'reload', NULL), (466, 16, 68, 'remain', 'uebrig', NULL), (467, 16, 68, 'size', 'size', NULL), -(468, 16, 68, 'min_stay', 'ma', NULL), +(468, 16, 68, 'minimum_stay', 'ma', NULL), (469, 16, 70, 'id', 'id', NULL), (470, 16, 70, 'sid', 'sid', NULL), (471, 16, 70, 'password', 'pw', NULL), (472, 16, 70, 'reward', 'verguetung', NULL), (473, 16, 70, 'reload', 'reload', NULL), (474, 16, 70, 'remain', 'uebrig', NULL), -(475, 16, 70, 'min_stay', 'ma', NULL), +(475, 16, 70, 'minimum_stay', 'ma', NULL), (476, 16, 70, 'type', 'typ', 'text'), (477, 16, 71, 'id', 'id', NULL), (478, 16, 71, 'sid', 'sid', NULL), @@ -1309,7 +1448,7 @@ PRIMARY KEY (`network_reload_id`) (480, 16, 71, 'reward', 'verguetung', NULL), (481, 16, 71, 'reload', 'reload', NULL), (482, 16, 71, 'remain', 'uebrig', NULL), -(483, 16, 71, 'min_stay', 'ma', NULL), +(483, 16, 71, 'minimum_stay', 'ma', NULL), (484, 16, 71, 'type', 'typ', 'html'), (485, 16, 72, 'id', 'id', NULL), (486, 16, 72, 'sid', 'sid', NULL), @@ -1331,14 +1470,14 @@ PRIMARY KEY (`network_reload_id`) (502, 16, 74, 'reward', 'verguetung', NULL), (503, 16, 74, 'reload', 'reload', NULL), (504, 16, 74, 'remain', 'uebrig', NULL), -(505, 16, 74, 'min_stay', 'ma', NULL), +(505, 16, 74, 'minimum_stay', 'ma', NULL), (506, 16, 75, 'id', 'id', NULL), (507, 16, 75, 'sid', 'sid', NULL), (508, 16, 75, 'password', 'pw', NULL), (509, 16, 75, 'reward', 'verguetung', NULL), (510, 16, 75, 'reload', 'reload', NULL), (511, 16, 75, 'remain', 'uebrig', NULL), -(512, 16, 75, 'min_stay', 'ma', NULL), +(512, 16, 75, 'minimum_stay', 'ma', NULL), (513, 16, 76, 'id', 'id', NULL), (514, 16, 76, 'sid', 'sid', NULL), (515, 16, 76, 'password', 'pw', NULL), @@ -1468,14 +1607,14 @@ PRIMARY KEY (`network_reload_id`) (573, 18, 84, 'reload', 'reload', NULL), (574, 18, 84, 'remain', 'uebrig', NULL), (575, 18, 84, 'size', 'size', NULL), -(576, 18, 84, 'min_stay', 'ma', NULL), +(576, 18, 84, 'minimum_stay', 'ma', NULL), (577, 18, 85, 'id', 'id', NULL), (578, 18, 85, 'sid', 'sid', NULL), (579, 18, 85, 'password', 'pw', NULL), (580, 18, 85, 'reward', 'verguetung', NULL), (581, 18, 85, 'reload', 'reload', NULL), (582, 18, 85, 'remain', 'uebrig', NULL), -(583, 18, 85, 'min_stay', 'ma', NULL), +(583, 18, 85, 'minimum_stay', 'ma', NULL), (584, 18, 85, 'type', 'typ', 'text'), (585, 18, 86, 'id', 'id', NULL), (586, 18, 86, 'sid', 'sid', NULL), @@ -1483,7 +1622,7 @@ PRIMARY KEY (`network_reload_id`) (588, 18, 86, 'reward', 'verguetung', NULL), (589, 18, 86, 'reload', 'reload', NULL), (590, 18, 86, 'remain', 'uebrig', NULL), -(591, 18, 86, 'min_stay', 'ma', NULL), +(591, 18, 86, 'minimum_stay', 'ma', NULL), (592, 18, 86, 'type', 'typ', 'html'), (593, 18, 87, 'id', 'id', NULL), (594, 18, 87, 'sid', 'sid', NULL), @@ -1505,14 +1644,14 @@ PRIMARY KEY (`network_reload_id`) (610, 18, 89, 'reward', 'verguetung', NULL), (611, 18, 89, 'reload', 'reload', NULL), (612, 18, 89, 'remain', 'uebrig', NULL), -(613, 18, 89, 'min_stay', 'ma', NULL), +(613, 18, 89, 'minimum_stay', 'ma', NULL), (614, 18, 90, 'id', 'id', NULL), (615, 18, 90, 'sid', 'sid', NULL), (616, 18, 90, 'password', 'pw', NULL), (617, 18, 90, 'reward', 'verguetung', NULL), (618, 18, 90, 'reload', 'reload', NULL), (619, 18, 90, 'remain', 'uebrig', NULL), -(620, 18, 90, 'min_stay', 'ma', NULL), +(620, 18, 90, 'minimum_stay', 'ma', NULL), (621, 18, 91, 'id', 'id', NULL), (622, 18, 91, 'sid', 'sid', NULL), (623, 18, 91, 'password', 'pw', NULL), @@ -1574,14 +1713,14 @@ PRIMARY KEY (`network_reload_id`) (676, 19, 100, 'reward', 'verguetung', NULL), (677, 19, 100, 'reload', 'reload', NULL), (678, 19, 100, 'remain', 'uebrig', NULL), -(679, 19, 100, 'min_stay', 'ma', NULL), +(679, 19, 100, 'minimum_stay', 'ma', NULL), (680, 19, 101, 'extra', 'typ', 'paidmail'), (681, 19, 101, 'id', 'id', NULL), (682, 19, 101, 'password', 'pw', NULL), (683, 19, 101, 'reward', 'verguetung', NULL), (684, 19, 101, 'reload', 'reload', NULL), (685, 19, 101, 'remain', 'uebrig', NULL), -(686, 19, 101, 'min_stay', 'ma', NULL), +(686, 19, 101, 'minimum_stay', 'ma', NULL), (821, 19, 124, 'extra', 'typ', 'traffic'), (822, 19, 124, 'id', 'id', NULL), (823, 19, 124, 'password', 'pw', NULL), @@ -1589,237 +1728,302 @@ PRIMARY KEY (`network_reload_id`) (825, 19, 124, 'reload', 'reload', NULL), (826, 19, 124, 'reward', 'verguetung', NULL)"); + // Request parameters per type handler - Swizerland + 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 +(1446, 20, 202, 'extra', 'typ', 'forcedbanner'), +(1447, 20, 202, 'id', 'id', NULL), +(1448, 20, 202, 'password', 'pw', NULL), +(1449, 20, 202, 'remain', 'uebrig', NULL), +(1450, 20, 202, 'reload', 'reload', NULL), +(1451, 20, 202, 'reward', 'verguetung', NULL), +(1452, 20, 203, 'extra', 'typ', 'forcedtextlink'), +(1453, 20, 203, 'id', 'id', NULL), +(1454, 20, 203, 'password', 'pw', NULL), +(1455, 20, 203, 'remain', 'uebrig', NULL), +(1456, 20, 203, 'reload', 'reload', NULL), +(1457, 20, 203, 'reward', 'verguetung', NULL), +(1458, 20, 204, 'extra', 'typ', 'bannerview'), +(1459, 20, 204, 'id', 'id', NULL), +(1460, 20, 204, 'password', 'pw', NULL), +(1461, 20, 204, 'remain', 'uebrig', NULL), +(1462, 20, 204, 'reload', 'reload', NULL), +(1463, 20, 204, 'reward', 'verguetung', NULL), +(1464, 20, 205, 'extra', 'typ', 'bannerklick'), +(1465, 20, 205, 'id', 'id', NULL), +(1466, 20, 205, 'password', 'pw', NULL), +(1467, 20, 205, 'remain', 'uebrig', NULL), +(1468, 20, 205, 'reload', 'reload', NULL), +(1469, 20, 205, 'reward', 'verguetung', NULL), +(1470, 20, 206, 'extra', 'typ', 'skybannerview'), +(1471, 20, 206, 'id', 'id', NULL), +(1472, 20, 206, 'password', 'pw', NULL), +(1473, 20, 206, 'remain', 'uebrig', NULL), +(1474, 20, 206, 'reload', 'reload', NULL), +(1475, 20, 206, 'reward', 'verguetung', NULL), +(1476, 20, 207, 'extra', 'typ', 'buttonview'), +(1477, 20, 207, 'id', 'id', NULL), +(1478, 20, 207, 'password', 'pw', NULL), +(1479, 20, 207, 'remain', 'uebrig', NULL), +(1480, 20, 207, 'reload', 'reload', NULL), +(1481, 20, 207, 'reward', 'verguetung', NULL), +(1482, 20, 208, 'extra', 'typ', 'textview'), +(1483, 20, 208, 'id', 'id', NULL), +(1484, 20, 208, 'password', 'pw', NULL), +(1485, 20, 208, 'remain', 'uebrig', NULL), +(1486, 20, 208, 'reload', 'reload', NULL), +(1487, 20, 208, 'reward', 'verguetung', NULL), +(1488, 20, 209, 'extra', 'typ', 'traffic'), +(1489, 20, 209, 'id', 'id', NULL), +(1490, 20, 209, 'password', 'pw', NULL), +(1491, 20, 209, 'remain', 'uebrig', NULL), +(1492, 20, 209, 'reload', 'reload', NULL), +(1493, 20, 209, 'reward', 'verguetung', NULL), +(1494, 20, 210, 'extra', 'typ', 'popup'), +(1495, 20, 210, 'id', 'id', NULL), +(1496, 20, 210, 'password', 'pw', NULL), +(1497, 20, 210, 'remain', 'uebrig', NULL), +(1498, 20, 210, 'reload', 'reload', NULL), +(1499, 20, 210, 'reward', 'verguetung', NULL), +(1500, 20, 210, 'minimum_stay', 'ma', NULL), +(1501, 20, 211, 'extra', 'typ', 'paidmail'), +(1502, 20, 211, 'id', 'id', NULL), +(1503, 20, 211, 'password', 'pw', NULL), +(1504, 20, 211, 'remain', 'uebrig', NULL), +(1505, 20, 211, 'reload', 'reload', NULL), +(1506, 20, 211, 'reward', 'verguetung', NULL), +(1507, 20, 211, 'minimum_stay', 'ma', 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, 20, 128, 'extra', 'typ', 'forcedbanner'), -(828, 20, 128, 'id', 'id', NULL), -(829, 20, 128, 'password', 'pw', NULL), -(830, 20, 128, 'remain', 'uebrig', NULL), -(831, 20, 128, 'reload', 'reload', NULL), -(832, 20, 128, 'reward', 'verguetung', NULL), -(833, 20, 129, 'extra', 'typ', 'forcedtextlink'), -(834, 20, 129, 'id', 'id', NULL), -(835, 20, 129, 'password', 'pw', NULL), -(836, 20, 129, 'remain', 'uebrig', NULL), -(837, 20, 129, 'reload', 'reload', NULL), -(838, 20, 129, 'reward', 'verguetung', NULL), -(839, 20, 126, 'extra', 'typ', 'bannerview'), -(840, 20, 126, 'id', 'id', NULL), -(841, 20, 126, 'password', 'pw', NULL), -(842, 20, 126, 'remain', 'uebrig', NULL), -(843, 20, 126, 'reload', 'reload', NULL), -(844, 20, 126, 'reward', 'verguetung', NULL), -(845, 20, 125, 'extra', 'typ', 'bannerklick'), -(846, 20, 125, 'id', 'id', NULL), -(847, 20, 125, 'password', 'pw', NULL), -(848, 20, 125, 'remain', 'uebrig', NULL), -(849, 20, 125, 'reload', 'reload', NULL), -(850, 20, 125, 'reward', 'verguetung', NULL), -(851, 20, 131, 'extra', 'typ', 'skybannerview'), -(852, 20, 131, 'id', 'id', NULL), -(853, 20, 131, 'password', 'pw', NULL), -(854, 20, 131, 'remain', 'uebrig', NULL), -(855, 20, 131, 'reload', 'reload', NULL), -(856, 20, 131, 'reward', 'verguetung', NULL), -(857, 20, 127, 'extra', 'typ', 'buttonview'), -(858, 20, 127, 'id', 'id', NULL), -(859, 20, 127, 'password', 'pw', NULL), -(860, 20, 127, 'remain', 'uebrig', NULL), -(861, 20, 127, 'reload', 'reload', NULL), -(862, 20, 127, 'reward', 'verguetung', NULL), -(863, 20, 132, 'extra', 'typ', 'textview'), -(864, 20, 132, 'id', 'id', NULL), -(865, 20, 132, 'password', 'pw', NULL), -(866, 20, 132, 'remain', 'uebrig', NULL), -(867, 20, 132, 'reload', 'reload', NULL), -(868, 20, 132, 'reward', 'verguetung', NULL), -(869, 20, 134, 'extra', 'typ', 'traffic'), -(870, 20, 134, 'id', 'id', NULL), -(871, 20, 134, 'password', 'pw', NULL), -(872, 20, 134, 'remain', 'uebrig', NULL), -(873, 20, 134, 'reload', 'reload', NULL), -(874, 20, 134, 'reward', 'verguetung', NULL), -(875, 20, 130, 'extra', 'typ', 'popup'), -(876, 20, 130, 'id', 'id', NULL), -(877, 20, 130, 'password', 'pw', NULL), -(878, 20, 130, 'remain', 'uebrig', NULL), -(879, 20, 130, 'reload', 'reload', NULL), -(880, 20, 130, 'reward', 'verguetung', NULL), -(881, 20, 130, 'min_stay', 'ma', NULL), -(882, 20, 133, 'extra', 'typ', 'paidmail'), -(883, 20, 133, 'id', 'id', NULL), -(884, 20, 133, 'password', 'pw', NULL), -(885, 20, 133, 'remain', 'uebrig', NULL), -(886, 20, 133, 'reload', 'reload', NULL), -(887, 20, 133, 'reward', 'verguetung', NULL), -(888, 20, 133, 'min_stay', 'ma', NULL)"); +(827, 21, 128, 'extra', 'typ', 'forcedbanner'), +(828, 21, 128, 'id', 'id', NULL), +(829, 21, 128, 'password', 'pw', NULL), +(830, 21, 128, 'remain', 'uebrig', NULL), +(831, 21, 128, 'reload', 'reload', NULL), +(832, 21, 128, 'reward', 'verguetung', NULL), +(833, 21, 129, 'extra', 'typ', 'forcedtextlink'), +(834, 21, 129, 'id', 'id', NULL), +(835, 21, 129, 'password', 'pw', NULL), +(836, 21, 129, 'remain', 'uebrig', NULL), +(837, 21, 129, 'reload', 'reload', NULL), +(838, 21, 129, 'reward', 'verguetung', NULL), +(839, 21, 126, 'extra', 'typ', 'bannerview'), +(840, 21, 126, 'id', 'id', NULL), +(841, 21, 126, 'password', 'pw', NULL), +(842, 21, 126, 'remain', 'uebrig', NULL), +(843, 21, 126, 'reload', 'reload', NULL), +(844, 21, 126, 'reward', 'verguetung', NULL), +(845, 21, 125, 'extra', 'typ', 'bannerklick'), +(846, 21, 125, 'id', 'id', NULL), +(847, 21, 125, 'password', 'pw', NULL), +(848, 21, 125, 'remain', 'uebrig', NULL), +(849, 21, 125, 'reload', 'reload', NULL), +(850, 21, 125, 'reward', 'verguetung', NULL), +(851, 21, 131, 'extra', 'typ', 'skybannerview'), +(852, 21, 131, 'id', 'id', NULL), +(853, 21, 131, 'password', 'pw', NULL), +(854, 21, 131, 'remain', 'uebrig', NULL), +(855, 21, 131, 'reload', 'reload', NULL), +(856, 21, 131, 'reward', 'verguetung', NULL), +(857, 21, 127, 'extra', 'typ', 'buttonview'), +(858, 21, 127, 'id', 'id', NULL), +(859, 21, 127, 'password', 'pw', NULL), +(860, 21, 127, 'remain', 'uebrig', NULL), +(861, 21, 127, 'reload', 'reload', NULL), +(862, 21, 127, 'reward', 'verguetung', NULL), +(863, 21, 132, 'extra', 'typ', 'textview'), +(864, 21, 132, 'id', 'id', NULL), +(865, 21, 132, 'password', 'pw', NULL), +(866, 21, 132, 'remain', 'uebrig', NULL), +(867, 21, 132, 'reload', 'reload', NULL), +(868, 21, 132, 'reward', 'verguetung', NULL), +(869, 21, 134, 'extra', 'typ', 'traffic'), +(870, 21, 134, 'id', 'id', NULL), +(871, 21, 134, 'password', 'pw', NULL), +(872, 21, 134, 'remain', 'uebrig', NULL), +(873, 21, 134, 'reload', 'reload', NULL), +(874, 21, 134, 'reward', 'verguetung', NULL), +(875, 21, 130, 'extra', 'typ', 'popup'), +(876, 21, 130, 'id', 'id', NULL), +(877, 21, 130, 'password', 'pw', NULL), +(878, 21, 130, 'remain', 'uebrig', NULL), +(879, 21, 130, 'reload', 'reload', NULL), +(880, 21, 130, 'reward', 'verguetung', NULL), +(881, 21, 130, 'minimum_stay', 'ma', NULL), +(882, 21, 133, 'extra', 'typ', 'paidmail'), +(883, 21, 133, 'id', 'id', NULL), +(884, 21, 133, 'password', 'pw', NULL), +(885, 21, 133, 'remain', 'uebrig', NULL), +(886, 21, 133, 'reload', 'reload', NULL), +(887, 21, 133, 'reward', 'verguetung', NULL), +(888, 21, 133, 'minimum_stay', 'ma', NULL)"); // Request parameters per type handler - Der Werbepartner.cc 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 -(951, 21, 145, 'extra', 'art', 'Textlinkklick'), -(952, 21, 145, 'reload', 'reload', NULL), -(953, 21, 145, 'reward', 'verg', NULL), -(954, 21, 145, 'remain', 'offen', NULL), -(955, 21, 145, 'sid', 'sid', NULL), -(956, 21, 145, 'id', 'uid', NULL), -(957, 21, 145, 'password', 'pw', NULL), -(958, 21, 146, 'extra', 'art', 'Forcedbanner'), -(959, 21, 146, 'reload', 'reload', NULL), -(960, 21, 146, 'reward', 'verg', NULL), -(961, 21, 146, 'remain', 'offen', NULL), -(962, 21, 146, 'sid', 'sid', NULL), -(963, 21, 146, 'id', 'uid', NULL), -(964, 21, 146, 'password', 'pw', NULL), -(965, 21, 147, 'extra', 'art', 'Paidmail'), -(966, 21, 147, 'reload', 'reload', NULL), -(967, 21, 147, 'reward', 'verg', NULL), -(968, 21, 147, 'remain', 'offen', NULL), -(969, 21, 147, 'sid', 'sid', NULL), -(970, 21, 147, 'id', 'uid', NULL), -(971, 21, 147, 'password', 'pw', NULL), -(972, 21, 148, 'extra', 'art', 'Layer'), -(973, 21, 148, 'reload', 'reload', NULL), -(974, 21, 148, 'reward', 'verg', NULL), -(975, 21, 148, 'remain', 'offen', NULL), -(976, 21, 148, 'sid', 'sid', NULL), -(977, 21, 148, 'id', 'uid', NULL), -(978, 21, 148, 'password', 'pw', NULL), -(979, 21, 149, 'extra', 'art', 'Skybannerklick'), -(980, 21, 149, 'reload', 'reload', NULL), -(981, 21, 149, 'reward', 'verg', NULL), -(982, 21, 149, 'remain', 'offen', NULL), -(983, 21, 149, 'sid', 'sid', NULL), -(984, 21, 149, 'id', 'uid', NULL), -(985, 21, 149, 'password', 'pw', NULL), -(986, 21, 150, 'extra', 'art', 'Surfbarklick'), -(987, 21, 150, 'reload', 'reload', NULL), -(988, 21, 150, 'reward', 'verg', NULL), -(989, 21, 150, 'remain', 'offen', NULL), -(990, 21, 150, 'sid', 'sid', NULL), -(991, 21, 150, 'id', 'uid', NULL), -(992, 21, 150, 'password', 'pw', NULL), -(993, 21, 151, 'extra', 'art', 'Bannerview'), -(994, 21, 151, 'reload', 'reload', NULL), -(995, 21, 151, 'reward', 'verg', NULL), -(996, 21, 151, 'remain', 'offen', NULL), -(997, 21, 151, 'sid', 'sid', NULL), -(998, 21, 151, 'id', 'uid', NULL), -(999, 21, 151, 'password', 'pw', NULL), -(1000, 21, 152, 'extra', 'art', 'PopUp'), -(1001, 21, 152, 'reload', 'reload', NULL), -(1002, 21, 152, 'reward', 'verg', NULL), -(1003, 21, 152, 'remain', 'offen', NULL), -(1004, 21, 152, 'sid', 'sid', NULL), -(1005, 21, 152, 'id', 'uid', NULL), -(1006, 21, 152, 'password', 'pw', NULL), -(1007, 21, 153, 'extra', 'art', 'Bannerklick'), -(1008, 21, 153, 'reload', 'reload', NULL), -(1009, 21, 153, 'reward', 'verg', NULL), -(1010, 21, 153, 'type', 'offen', NULL), -(1011, 21, 153, 'sid', 'sid', NULL), -(1012, 21, 153, 'id', 'uid', NULL), -(1013, 21, 153, 'password', 'pw', NULL), -(1014, 21, 154, 'extra', 'art', 'Forcedtextlink'), -(1015, 21, 154, 'reload', 'reload', NULL), -(1016, 21, 154, 'reward', 'verg', NULL), -(1017, 21, 154, 'remain', 'offen', NULL), -(1018, 21, 154, 'sid', 'sid', NULL), -(1019, 21, 154, 'id', 'uid', NULL), -(1020, 21, 154, 'password', 'pw', NULL), -(1021, 21, 155, 'extra', 'art', 'Traffic'), -(1022, 21, 155, 'reload', 'reload', NULL), -(1023, 21, 155, 'reward', 'verg', NULL), -(1024, 21, 155, 'remain', 'offen', NULL), -(1025, 21, 155, 'sid', 'sid', NULL), -(1026, 21, 155, 'id', 'id', NULL), -(1027, 21, 155, 'password', 'pw', NULL)"); +(951, 22, 145, 'extra', 'art', 'Textlinkklick'), +(952, 22, 145, 'reload', 'reload', NULL), +(953, 22, 145, 'reward', 'verg', NULL), +(954, 22, 145, 'remain', 'offen', NULL), +(955, 22, 145, 'sid', 'sid', NULL), +(956, 22, 145, 'id', 'uid', NULL), +(957, 22, 145, 'password', 'pw', NULL), +(958, 22, 146, 'extra', 'art', 'Forcedbanner'), +(959, 22, 146, 'reload', 'reload', NULL), +(960, 22, 146, 'reward', 'verg', NULL), +(961, 22, 146, 'remain', 'offen', NULL), +(962, 22, 146, 'sid', 'sid', NULL), +(963, 22, 146, 'id', 'uid', NULL), +(964, 22, 146, 'password', 'pw', NULL), +(965, 22, 147, 'extra', 'art', 'Paidmail'), +(966, 22, 147, 'reload', 'reload', NULL), +(967, 22, 147, 'reward', 'verg', NULL), +(968, 22, 147, 'remain', 'offen', NULL), +(969, 22, 147, 'sid', 'sid', NULL), +(970, 22, 147, 'id', 'uid', NULL), +(971, 22, 147, 'password', 'pw', NULL), +(972, 22, 148, 'extra', 'art', 'Layer'), +(973, 22, 148, 'reload', 'reload', NULL), +(974, 22, 148, 'reward', 'verg', NULL), +(975, 22, 148, 'remain', 'offen', NULL), +(976, 22, 148, 'sid', 'sid', NULL), +(977, 22, 148, 'id', 'uid', NULL), +(978, 22, 148, 'password', 'pw', NULL), +(979, 22, 149, 'extra', 'art', 'Skybannerklick'), +(980, 22, 149, 'reload', 'reload', NULL), +(981, 22, 149, 'reward', 'verg', NULL), +(982, 22, 149, 'remain', 'offen', NULL), +(983, 22, 149, 'sid', 'sid', NULL), +(984, 22, 149, 'id', 'uid', NULL), +(985, 22, 149, 'password', 'pw', NULL), +(986, 22, 150, 'extra', 'art', 'Surfbarklick'), +(987, 22, 150, 'reload', 'reload', NULL), +(988, 22, 150, 'reward', 'verg', NULL), +(989, 22, 150, 'remain', 'offen', NULL), +(990, 22, 150, 'sid', 'sid', NULL), +(991, 22, 150, 'id', 'uid', NULL), +(992, 22, 150, 'password', 'pw', NULL), +(993, 22, 151, 'extra', 'art', 'Bannerview'), +(994, 22, 151, 'reload', 'reload', NULL), +(995, 22, 151, 'reward', 'verg', NULL), +(996, 22, 151, 'remain', 'offen', NULL), +(997, 22, 151, 'sid', 'sid', NULL), +(998, 22, 151, 'id', 'uid', NULL), +(999, 22, 151, 'password', 'pw', NULL), +(1000, 22, 152, 'extra', 'art', 'PopUp'), +(1001, 22, 152, 'reload', 'reload', NULL), +(1002, 22, 152, 'reward', 'verg', NULL), +(1003, 22, 152, 'remain', 'offen', NULL), +(1004, 22, 152, 'sid', 'sid', NULL), +(1005, 22, 152, 'id', 'uid', NULL), +(1006, 22, 152, 'password', 'pw', NULL), +(1007, 22, 153, 'extra', 'art', 'Bannerklick'), +(1008, 22, 153, 'reload', 'reload', NULL), +(1009, 22, 153, 'reward', 'verg', NULL), +(1010, 22, 153, 'type', 'offen', NULL), +(1011, 22, 153, 'sid', 'sid', NULL), +(1012, 22, 153, 'id', 'uid', NULL), +(1013, 22, 153, 'password', 'pw', NULL), +(1014, 22, 154, 'extra', 'art', 'Forcedtextlink'), +(1015, 22, 154, 'reload', 'reload', NULL), +(1016, 22, 154, 'reward', 'verg', NULL), +(1017, 22, 154, 'remain', 'offen', NULL), +(1018, 22, 154, 'sid', 'sid', NULL), +(1019, 22, 154, 'id', 'uid', NULL), +(1020, 22, 154, 'password', 'pw', NULL), +(1021, 22, 155, 'extra', 'art', 'Traffic'), +(1022, 22, 155, 'reload', 'reload', NULL), +(1023, 22, 155, 'reward', 'verg', NULL), +(1024, 22, 155, 'remain', 'offen', NULL), +(1025, 22, 155, 'sid', 'sid', NULL), +(1026, 22, 155, 'id', 'id', NULL), +(1027, 22, 155, 'password', 'pw', NULL)"); // Request parameters per type handler - Yoo!Media 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 -(1028, 22, 156, 'id', 'id', NULL), -(1029, 22, 156, 'sid', 'sid', NULL), -(1030, 22, 156, 'password', 'pw', NULL), -(1031, 22, 156, 'reload', 'reload', NULL), -(1032, 22, 156, 'remain', 'uebrig', NULL), -(1033, 22, 156, 'reward', 'verguetung', NULL), -(1034, 22, 156, 'size', 'size', '468x60'), -(1035, 22, 156, 'erotic', 'erotik', NULL), -(1036, 22, 157, 'id', 'id', NULL), -(1037, 22, 157, 'sid', 'sid', NULL), -(1038, 22, 157, 'password', 'pw', NULL), -(1039, 22, 157, 'reload', 'reload', NULL), -(1040, 22, 157, 'reward', 'verguetung', NULL), -(1041, 22, 157, 'erotic', 'erotik', NULL), -(1042, 22, 157, 'remain', 'uebrig', NULL), -(1043, 22, 158, 'id', 'id', NULL), -(1044, 22, 158, 'sid', 'sid', NULL), -(1045, 22, 158, 'password', 'pw', NULL), -(1046, 22, 158, 'reload', 'reload', NULL), -(1047, 22, 158, 'reward', 'verguetung', NULL), -(1048, 22, 158, 'remain', 'uebrig', NULL), -(1049, 22, 158, 'size', 'size', '468x60'), -(1050, 22, 158, 'erotic', 'erotik', NULL), -(1051, 22, 159, 'id', 'id', NULL), -(1052, 22, 159, 'sid', 'sid', NULL), -(1053, 22, 159, 'password', 'pw', NULL), -(1054, 22, 159, 'reload', 'reload', NULL), -(1055, 22, 159, 'min_stay', 'ma', NULL), -(1056, 22, 159, 'remain', 'uebrig', NULL), -(1057, 22, 159, 'reward', 'verguetung', NULL), -(1058, 22, 159, 'size', 'size', '468x60'), -(1059, 22, 159, 'erotic', 'erotik', NULL), -(1060, 22, 160, 'id', 'id', NULL), -(1061, 22, 160, 'sid', 'sid', NULL), -(1062, 22, 160, 'password', 'pw', NULL), -(1063, 22, 160, 'reload', 'reload', NULL), -(1064, 22, 160, 'remain', 'uebrig', NULL), -(1065, 22, 160, 'reward', 'verguetung', NULL), -(1066, 22, 160, 'erotic', 'erotik', NULL), -(1067, 22, 161, 'id', 'id', NULL), -(1068, 22, 161, 'sid', 'sid', NULL), -(1069, 22, 161, 'password', 'pw', NULL), -(1070, 22, 161, 'reload', 'reload', NULL), -(1071, 22, 161, 'min_stay', 'ma', NULL), -(1072, 22, 161, 'remain', 'uebrig', NULL), -(1073, 22, 161, 'reward', 'verguetung', NULL), -(1074, 22, 161, 'erotic', 'erotik', NULL), -(1075, 22, 162, 'id', 'id', NULL), -(1076, 22, 162, 'sid', 'sid', NULL), -(1077, 22, 162, 'password', 'pw', NULL), -(1078, 22, 162, 'reload', 'reload', NULL), -(1079, 22, 162, 'min_stay', 'ma', NULL), -(1080, 22, 162, 'remain', 'uebrig', NULL), -(1081, 22, 162, 'reward', 'verguetung', NULL), -(1082, 22, 162, 'erotic', 'erotik', NULL), -(1083, 22, 163, 'id', 'id', NULL), -(1084, 22, 163, 'sid', 'sid', NULL), -(1085, 22, 163, 'password', 'pw', NULL), -(1086, 22, 163, 'reload', 'reload', NULL), -(1087, 22, 163, 'remain', 'uebrig', NULL), -(1088, 22, 163, 'reward', 'verguetung', NULL), -(1089, 22, 163, 'erotic', 'erotik', NULL), -(1090, 22, 164, 'id', 'id', NULL), -(1091, 22, 164, 'sid', 'sid', NULL), -(1092, 22, 164, 'password', 'pw', NULL), -(1093, 22, 164, 'reload', 'reload', NULL), -(1094, 22, 164, 'min_stay', 'ma', NULL), -(1095, 22, 164, 'remain', 'uebrig', NULL), -(1096, 22, 164, 'reward', 'verguetung', NULL), -(1097, 22, 164, 'erotic', 'erotik', NULL), -(1098, 22, 165, 'id', 'id', NULL), -(1099, 22, 165, 'sid', 'sid', NULL), -(1100, 22, 165, 'password', 'pw', NULL), -(1101, 22, 165, 'reload', 'reload', NULL), -(1102, 22, 165, 'min_stay', 'ma', NULL), -(1103, 22, 165, 'reward', 'verguetung', NULL), -(1104, 22, 165, 'remain', 'uebrig', NULL), -(1105, 22, 165, 'erotic', 'erotik', NULL), -(1106, 22, 166, 'id', 'id', NULL), -(1107, 22, 166, 'sid', 'sid', NULL), -(1108, 22, 166, 'password', 'pw', NULL), -(1109, 22, 166, 'remain', 'uebrig', NULL), -(1110, 22, 166, 'reward', 'verguetung', NULL), -(1111, 22, 166, 'erotic', 'erotik', NULL)"); +(1028, 23, 156, 'id', 'id', NULL), +(1029, 23, 156, 'sid', 'sid', NULL), +(1030, 23, 156, 'password', 'pw', NULL), +(1031, 23, 156, 'reload', 'reload', NULL), +(1032, 23, 156, 'remain', 'uebrig', NULL), +(1033, 23, 156, 'reward', 'verguetung', NULL), +(1034, 23, 156, 'size', 'size', '468x60'), +(1035, 23, 156, 'erotic', 'erotik', NULL), +(1036, 23, 157, 'id', 'id', NULL), +(1037, 23, 157, 'sid', 'sid', NULL), +(1038, 23, 157, 'password', 'pw', NULL), +(1039, 23, 157, 'reload', 'reload', NULL), +(1040, 23, 157, 'reward', 'verguetung', NULL), +(1041, 23, 157, 'erotic', 'erotik', NULL), +(1042, 23, 157, 'remain', 'uebrig', NULL), +(1043, 23, 158, 'id', 'id', NULL), +(1044, 23, 158, 'sid', 'sid', NULL), +(1045, 23, 158, 'password', 'pw', NULL), +(1046, 23, 158, 'reload', 'reload', NULL), +(1047, 23, 158, 'reward', 'verguetung', NULL), +(1048, 23, 158, 'remain', 'uebrig', NULL), +(1049, 23, 158, 'size', 'size', '468x60'), +(1050, 23, 158, 'erotic', 'erotik', NULL), +(1051, 23, 159, 'id', 'id', NULL), +(1052, 23, 159, 'sid', 'sid', NULL), +(1053, 23, 159, 'password', 'pw', NULL), +(1054, 23, 159, 'reload', 'reload', NULL), +(1055, 23, 159, 'minimum_stay', 'ma', NULL), +(1056, 23, 159, 'remain', 'uebrig', NULL), +(1057, 23, 159, 'reward', 'verguetung', NULL), +(1058, 23, 159, 'size', 'size', '468x60'), +(1059, 23, 159, 'erotic', 'erotik', NULL), +(1060, 23, 160, 'id', 'id', NULL), +(1061, 23, 160, 'sid', 'sid', NULL), +(1062, 23, 160, 'password', 'pw', NULL), +(1063, 23, 160, 'reload', 'reload', NULL), +(1064, 23, 160, 'remain', 'uebrig', NULL), +(1065, 23, 160, 'reward', 'verguetung', NULL), +(1066, 23, 160, 'erotic', 'erotik', NULL), +(1067, 23, 161, 'id', 'id', NULL), +(1068, 23, 161, 'sid', 'sid', NULL), +(1069, 23, 161, 'password', 'pw', NULL), +(1070, 23, 161, 'reload', 'reload', NULL), +(1071, 23, 161, 'minimum_stay', 'ma', NULL), +(1072, 23, 161, 'remain', 'uebrig', NULL), +(1073, 23, 161, 'reward', 'verguetung', NULL), +(1074, 23, 161, 'erotic', 'erotik', NULL), +(1075, 23, 162, 'id', 'id', NULL), +(1076, 23, 162, 'sid', 'sid', NULL), +(1077, 23, 162, 'password', 'pw', NULL), +(1078, 23, 162, 'reload', 'reload', NULL), +(1079, 23, 162, 'minimum_stay', 'ma', NULL), +(1080, 23, 162, 'remain', 'uebrig', NULL), +(1081, 23, 162, 'reward', 'verguetung', NULL), +(1082, 23, 162, 'erotic', 'erotik', NULL), +(1083, 23, 163, 'id', 'id', NULL), +(1084, 23, 163, 'sid', 'sid', NULL), +(1085, 23, 163, 'password', 'pw', NULL), +(1086, 23, 163, 'reload', 'reload', NULL), +(1087, 23, 163, 'remain', 'uebrig', NULL), +(1088, 23, 163, 'reward', 'verguetung', NULL), +(1089, 23, 163, 'erotic', 'erotik', NULL), +(1090, 23, 164, 'id', 'id', NULL), +(1091, 23, 164, 'sid', 'sid', NULL), +(1092, 23, 164, 'password', 'pw', NULL), +(1093, 23, 164, 'reload', 'reload', NULL), +(1094, 23, 164, 'minimum_stay', 'ma', NULL), +(1095, 23, 164, 'remain', 'uebrig', NULL), +(1096, 23, 164, 'reward', 'verguetung', NULL), +(1097, 23, 164, 'erotic', 'erotik', NULL), +(1098, 23, 165, 'id', 'id', NULL), +(1099, 23, 165, 'sid', 'sid', NULL), +(1100, 23, 165, 'password', 'pw', NULL), +(1101, 23, 165, 'reload', 'reload', NULL), +(1102, 23, 165, 'minimum_stay', 'ma', NULL), +(1103, 23, 165, 'reward', 'verguetung', NULL), +(1104, 23, 165, 'remain', 'uebrig', NULL), +(1105, 23, 165, 'erotic', 'erotik', NULL), +(1106, 23, 166, 'id', 'id', NULL), +(1107, 23, 166, 'sid', 'sid', NULL), +(1108, 23, 166, 'password', 'pw', NULL), +(1109, 23, 166, 'remain', 'uebrig', NULL), +(1110, 23, 166, 'reward', 'verguetung', NULL), +(1111, 23, 166, 'erotic', 'erotik', NULL)"); // Fix empty defaults to NULL addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_types` SET `network_type_banner_url`=NULL WHERE `network_type_banner_url`=''"); @@ -1835,9 +2039,10 @@ PRIMARY KEY (`network_reload_id`) addAdminMenuSql('network','list_networks','Auflisten/Verwalten','Experten-Einstellungen! Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',6); addAdminMenuSql('network','list_network_types','Werbearten','Experten-Einstellungen! Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',7); addAdminMenuSql('network','list_network_params','Abfrageparameter','Experten-Einstellungen! 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 im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',8); - addAdminMenuSql('network','list_network_return_codes','Rückgabewerte','Experten-Einstellungen! Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',9); - addAdminMenuSql('network','list_network_error_codes','Fehlercodes','Experten-Einstellungen! 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 im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',10); - addAdminMenuSql('network','list_network_error_types','Fehlertypen','Experten-Einstellungen! Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden. Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',11); + addAdminMenuSql('network','list_network_array_translation','Antwort-Array','Experten-Einstellungen! Hier stellen Sie die Zuweisungen der aus der analysierten API-Antwort Array-Elementen zu den Datenspalten ein. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',9); + addAdminMenuSql('network','list_network_error_codes','Fehlercodes','Experten-Einstellungen! Hier stellen Sie die Fehlercodes ein, die im Falle eines Fehlers pro API-Script kommen können. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',10); + addAdminMenuSql('network','list_network_translations','Array-Übersetzungen','Experten-Einstellungen! Hier richten Sie Array-Index-Übersetzungen für nicht-fehler API-Antworten ein. Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',11); + addAdminMenuSql('network','list_network_error_types','Fehlertypen','Experten-Einstellungen! Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden. Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und im Forum um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',12); // Configuration entries addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `network_cache_refresh` BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (60 * 15) . ''); @@ -1851,7 +2056,7 @@ PRIMARY KEY (`network_reload_id`) addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_codes`'); addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_error_types`'); addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`'); - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_return_types`'); + 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`');