`network_short_name` VARCHAR(50) NOT NULL DEFAULT '',
`network_title` VARCHAR(255) NOT NULL DEFAULT '',
`network_reflink` VARCHAR(255) NOT NULL DEFAULT '',
-`network_data_seperator` CHAR(4) NOT NULL DEFAULT '|',
-`network_row_seperator` CHAR(4) NOT NULL DEFAULT '|',
+`network_data_separator` CHAR(4) NOT NULL DEFAULT '|',
+`network_row_separator` CHAR(4) NOT NULL DEFAULT '|',
`network_request_type` ENUM('GET','POST') NOT NULL DEFAULT 'GET',
`network_charset` VARCHAR(20) NOT NULL DEFAULT 'UTF-8',
`network_require_id_card` ENUM('Y','N') NOT NULL DEFAULT 'N',
+`network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
PRIMARY KEY (`network_id`),
UNIQUE (`network_short_name`)",
'Network data');
`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(20) NOT NULL DEFAULT 'invalid',
-`request_param_value` VARCHAR(20) NOT NULL DEFAULT 'invalid',
-`request_param_default` VARCHAR(255) NULL DEFAULT NULL,
+`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`),
-UNIQUE INDEX `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
-UNIQUE INDEX `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`)",
+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');
// Error status codes
INDEX (`network_type_id`)",
'Error codes for all types');
- // Code types (internal table)
- addDropTableSql('network_error_types');
- addCreateTableSql('network_error_types', "
-`network_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`network_code` VARCHAR(100) NOT NULL DEFAULT 'INVALID_CODE',
-PRIMARY KEY (`network_code_id`),
-UNIQUE (`network_code`)",
- 'Error types, generic data, DO NOT ALTER!');
-
// Valid translation keys (we hate hard-coded arrays, you see?)
addDropTableSql('network_translations');
addCreateTableSql('network_translations', "
addDropTableSql('network_api_config');
addCreateTableSql('network_api_config', "
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_api_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_api_password` VARCHAR(255) NOT NULL DEFAULT '',
-`network_site_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_api_site_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_api_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
+`network_api_referral_link` VARCHAR(255) NULL DEFAULT NULL,
+`network_api_referral_button` VARCHAR(255) NULL DEFAULT NULL,
PRIMARY KEY (`network_id`),
-UNIQUE INDEX `network_affiliate` (`network_id`,`network_affiliate_id`),
-UNIQUE INDEX `affiliate_site` (`network_affiliate_id`,`network_site_id`)",
+UNIQUE INDEX `network_affiliate` (`network_id`,`network_api_affiliate_id`),
+UNIQUE INDEX `affiliate_site` (`network_api_affiliate_id`,`network_api_site_id`)",
'API configuration data');
// Configuration data for e.g. reload-time
`network_data_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`max_reload_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`min_waiting_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`min_remain_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
-`allow_erotic` VARCHAR(10) NOT NULL DEFAULT '',
+`network_max_reload_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_min_waiting_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_min_remain_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`network_min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
+`network_allow_erotic` VARCHAR(10) NOT NULL DEFAULT '',
PRIMARY KEY (`network_data_id`),
UNIQUE INDEX `provider_type` (`network_id`,`network_type_id`)",
'Configuration data for every type (e.g. reload-time)');
('media_url'),
('allowed_countries')");
- // Insert error code types
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES
-('AFF_ID_PASS_WRONG'),
-('SITE_ID_NOT_ASSIGNED'),
-('SITE_ID_LOCKED'),
-('INTERFACE_DATA_ERROR'),
-('REQUESTS_DEPLETED'),
-('NO_CAMPAIGNS_FOUND'),
-('NO_CAMPAIGNS_FOUND_INTERFACE'),
-('SITE_ID_NOT_ALLOWED_TYPE'),
-('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`,`network_require_id_card`) VALUES
-('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252','Y'),
-('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1','N'),
-('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('adpaid', 'AdPaid', 'http://www.adpaid.de?ref=1464', '|', '|', 'GET', 'ISO-8859-1','N'),
-('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('affiliblatt', 'Affiliblatt', 'http://www.Affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8','N'),
-('allads4you', 'AllAds4You', 'http://www.allads4you.de?ref=1146', '|', '|', 'GET', 'ISO-8859-1','N'),
-('alster', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16','N'),
-('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'ISO-8859-1','N'),
-('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('hpsponsor', 'HPSponsor', 'http://hpsponsor.at?ref=29', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1','N'),
-('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('weltpromotion', 'Welt-Promotion', 'http://www.weltpromotion.de?ref=3', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('cityads', 'City-Ads', 'http://www.city-ads.de?ref=221', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('goldsponsor', 'Gold-Sponsor', 'http://www.gold-sponsor.de?ref=42', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1','Y'),
-('vipads', 'VIPads.de', 'http://vipads.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1','N'),
-('homeads', 'homeADS', 'http://www.homeads.de/?ref=1540', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('fucoexsponsor', 'FuCoExSponsor.net', 'http://fucoexsponsor.net/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1','N'),
-('adconvention', 'AdConvention', 'http://www.adconvention.de?ref=233', '|', '|', 'GET', 'WINDOWS-1252','N'),
-('ad-hit', 'Ad-Hit.de', 'http://www.ad-hit.de?ref=41', '|', '|', 'GET', 'WINDOWS-1252', 'N')");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_data` (`network_short_name`,`network_title`,`network_reflink`,`network_data_separator`,`network_row_separator`,`network_request_type`,`network_charset`,`network_require_id_card`,`network_query_amount`) VALUES
+('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252', 'N', 100),
+('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252', 'Y', 0),
+('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('adpaid', 'AdPaid', 'http://www.adpaid.de?ref=1464', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('affiliblatt', 'Affiliblatt', 'http://www.affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8', 'N', 0),
+('allads4you', 'AllAds4You', 'http://www.allads4you.de?ref=1146', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('alstermarketing', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16', 'N', 0),
+('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('hpsponsor', 'HPSponsor', 'http://hpsponsor.at?ref=29', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('weltpromotion', 'Welt-Promotion', 'http://www.weltpromotion.de?ref=3', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('cityads', 'City-Ads', 'http://www.city-ads.de?ref=221', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('goldsponsor', 'Gold-Sponsor', 'http://www.gold-sponsor.de?ref=42', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1','Y', 0),
+('vipads', 'VIPads.de', 'http://vipads.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1', 'N', 0),
+('homeads', 'homeADS', 'http://www.homeads.de/?ref=1540', '|', '|', 'GET', 'WINDOWS-1252', 'N', 0),
+('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)");
// Network type handlers - A3H
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`,`network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES
// 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`) 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%'),
+(313, 32, 'forcedtextlink', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(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%'),
+(315, 32, 'banner_click', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(316, 32, 'skybanner_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(317, 32, 'button_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.adcity.eu/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(318, 32, 'textlink_view', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(319, 32, 'traffic', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(320, 32, 'popup', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
+(321, 32, 'textmail', 'http://www.adcity.eu/interface/', 'http://www.adcity.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+
// Network type handlers - AdCocktail
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`,`network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES
(13, 4, 'forcedbanner', 'http://www.adcocktail.com/sc/kas/kas_fk.php', 'http://fk.adcocktail.com/fk_k.php?uid=%UID%&wid=%CID%&wsid=%SID%', 'http://fk.adcocktail.com/fk_v.php?uid=%UID%&wid=%CID%&wsid=%SID%'),
(166, 23, 'lead', 'http://www.yoomedia.de/interface_2.0/out_lead.php', 'http://www.yoomedia.de/code/lead.php?id=%CID%&sid=%SID%', NULL)");
// Request parameters per type handler - A3H
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(1, 1, 'id', 'id', NULL),
(1, 1, 'minimum_stay', 'ma', NULL),
(1, 1, 'password', 'pw', NULL),
(1, 11, 'type', 'typ', 'html')");
// Request parameters per type handler - AbisZED-Netz
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(2, 187, 'id', 'id', NULL),
(2, 187, 'password', 'pw', NULL),
(2, 187, 'reload', 'reload', NULL),
(2, 201, 'sid', 'sid', NULL)");
// Request parameters per type handler - Ad-Hit
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(31, 302, 'extra', 'typ', 'forcedbanner'),
(31, 302, 'id', 'id', NULL),
(31, 302, 'password', 'pw', NULL),
(31, 302, 'reload', 'reload', NULL),
(31, 302, 'reward', 'verguetung', NULL),
(31, 302, 'sid', 'siteid', NULL),
+(31, 302, 'minimum_stay', 'ma', NULL),
(31, 303, 'extra', 'typ', 'forcedtextlink'),
(31, 303, 'id', 'id', NULL),
(31, 303, 'password', 'pw', NULL),
(31, 303, 'reload', 'reload', NULL),
(31, 303, 'reward', 'verguetung', NULL),
(31, 303, 'sid', 'siteid', NULL),
+(31, 303, 'minimum_stay', 'ma', NULL),
(31, 304, 'extra', 'typ', 'bannerview'),
(31, 304, 'id', 'id', NULL),
(31, 304, 'password', 'pw', NULL),
(31, 304, 'reload', 'reload', NULL),
(31, 304, 'reward', 'verguetung', NULL),
(31, 304, 'sid', 'siteid', NULL),
+(31, 304, 'minimum_stay', 'ma', NULL),
(31, 305, 'extra', 'typ', 'bannerklick'),
(31, 305, 'id', 'id', NULL),
(31, 305, 'password', 'pw', NULL),
(31, 305, 'reload', 'reload', NULL),
(31, 305, 'reward', 'verguetung', NULL),
(31, 305, 'sid', 'siteid', NULL),
+(31, 305, 'minimum_stay', 'ma', NULL),
(31, 306, 'extra', 'typ', 'skybannerview'),
(31, 306, 'id', 'id', NULL),
(31, 306, 'password', 'pw', NULL),
(31, 306, 'reload', 'reload', NULL),
(31, 306, 'reward', 'verguetung', NULL),
(31, 306, 'sid', 'siteid', NULL),
+(31, 306, 'minimum_stay', 'ma', NULL),
(31, 307, 'extra', 'typ', 'buttonview'),
(31, 307, 'id', 'id', NULL),
(31, 307, 'password', 'pw', NULL),
(31, 307, 'reload', 'reload', NULL),
(31, 307, 'reward', 'verguetung', NULL),
(31, 307, 'sid', 'siteid', NULL),
+(31, 307, 'minimum_stay', 'ma', NULL),
(31, 308, 'extra', 'typ', 'textview'),
(31, 308, 'id', 'id', NULL),
(31, 308, 'password', 'pw', NULL),
(31, 308, 'reload', 'reload', NULL),
(31, 308, 'reward', 'verguetung', NULL),
(31, 308, 'sid', 'siteid', NULL),
+(31, 308, 'minimum_stay', 'ma', NULL),
(31, 309, 'extra', 'typ', 'traffic'),
(31, 309, 'id', 'id', NULL),
(31, 309, 'password', 'pw', NULL),
(31, 309, 'reload', 'reload', NULL),
(31, 309, 'reward', 'verguetung', NULL),
(31, 309, 'sid', 'siteid', NULL),
+(31, 309, 'minimum_stay', 'ma', NULL),
(31, 310, 'extra', 'typ', 'popup'),
(31, 310, 'id', 'id', NULL),
(31, 310, 'password', 'pw', NULL),
(31, 310, 'reload', 'reload', NULL),
(31, 310, 'reward', 'verguetung', NULL),
(31, 310, 'sid', 'siteid', NULL),
+(31, 310, 'minimum_stay', 'ma', NULL),
(31, 311, 'extra', 'typ', 'paidmail'),
(31, 311, 'id', 'id', NULL),
(31, 311, 'password', 'pw', NULL),
(31, 311, 'remain', 'uebrig', NULL),
(31, 311, 'reload', 'reload', NULL),
(31, 311, 'reward', 'verguetung', NULL),
-(31, 311, 'sid', 'siteid', NULL)");
+(31, 311, 'sid', 'siteid', NULL),
+(31, 311, 'minimum_stay', 'ma', NULL)");
// 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
+(32, 312, 'extra', 'typ', 'forcedbanner'),
+(32, 312, 'id', 'id', NULL),
+(32, 312, 'password', 'pw', NULL),
+(32, 312, 'remain', 'uebrig', NULL),
+(32, 312, 'reload', 'reload', NULL),
+(32, 312, 'reward', 'verguetung', NULL),
+(32, 312, 'minimum_stay', 'ma', NULL),
+(32, 313, 'extra', 'typ', 'forcedtextlink'),
+(32, 313, 'id', 'id', NULL),
+(32, 313, 'password', 'pw', NULL),
+(32, 313, 'remain', 'uebrig', NULL),
+(32, 313, 'reload', 'reload', NULL),
+(32, 313, 'reward', 'verguetung', NULL),
+(32, 313, 'minimum_stay', 'ma', NULL),
+(32, 314, 'extra', 'typ', 'bannerview'),
+(32, 314, 'id', 'id', NULL),
+(32, 314, 'password', 'pw', NULL),
+(32, 314, 'remain', 'uebrig', NULL),
+(32, 314, 'reload', 'reload', NULL),
+(32, 314, 'reward', 'verguetung', NULL),
+(32, 314, 'minimum_stay', 'ma', NULL),
+(32, 315, 'extra', 'typ', 'bannerklick'),
+(32, 315, 'id', 'id', NULL),
+(32, 315, 'password', 'pw', NULL),
+(32, 315, 'remain', 'uebrig', NULL),
+(32, 315, 'reload', 'reload', NULL),
+(32, 315, 'reward', 'verguetung', NULL),
+(32, 315, 'minimum_stay', 'ma', NULL),
+(32, 316, 'extra', 'typ', 'skyview'),
+(32, 316, 'id', 'id', NULL),
+(32, 316, 'password', 'pw', NULL),
+(32, 316, 'remain', 'uebrig', NULL),
+(32, 316, 'reload', 'reload', NULL),
+(32, 316, 'reward', 'verguetung', NULL),
+(32, 316, 'minimum_stay', 'ma', NULL),
+(32, 317, 'extra', 'typ', 'buttonview'),
+(32, 317, 'id', 'id', NULL),
+(32, 317, 'password', 'pw', NULL),
+(32, 317, 'remain', 'uebrig', NULL),
+(32, 317, 'reload', 'reload', NULL),
+(32, 317, 'reward', 'verguetung', NULL),
+(32, 317, 'minimum_stay', 'ma', NULL),
+(32, 318, 'extra', 'typ', 'textview'),
+(32, 318, 'id', 'id', NULL),
+(32, 318, 'password', 'pw', NULL),
+(32, 318, 'remain', 'uebrig', NULL),
+(32, 318, 'reload', 'reload', NULL),
+(32, 318, 'reward', 'verguetung', NULL),
+(32, 318, 'minimum_stay', 'ma', NULL),
+(32, 319, 'extra', 'typ', 'taffic'),
+(32, 319, 'id', 'id', NULL),
+(32, 319, 'password', 'pw', NULL),
+(32, 319, 'remain', 'uebrig', NULL),
+(32, 319, 'reload', 'reload', NULL),
+(32, 319, 'reward', 'verguetung', NULL),
+(32, 319, 'minimum_stay', 'ma', NULL),
+(32, 320, 'extra', 'typ', 'popup'),
+(32, 320, 'id', 'id', NULL),
+(32, 320, 'password', 'pw', NULL),
+(32, 320, 'remain', 'uebrig', NULL),
+(32, 320, 'reload', 'reload', NULL),
+(32, 320, 'reward', 'verguetung', NULL),
+(32, 320, 'minimum_stay', 'ma', NULL),
+(32, 321, 'extra', 'typ', 'paidmail'),
+(32, 321, 'id', 'id', NULL),
+(32, 321, 'password', 'pw', NULL),
+(32, 321, 'remain', 'uebrig', NULL),
+(32, 321, 'reload', 'reload', NULL),
+(32, 321, 'reward', 'verguetung', NULL),
+(32, 321, 'minimum_stay', 'ma', NULL)");
+
// Request parameters per type handler - AdCocktail
// Request parameters per type handler - AdConvention
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(30, 292, 'extra', 'typ', 'forcedbanner'),
(30, 292, 'id', 'id', NULL),
(30, 292, 'minimum_stay', 'ma', NULL),
(30, 301, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - AdPaid
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(5, 177, 'id', 'id', NULL),
(5, 177, 'password', 'pw', NULL),
(5, 177, 'reload', 'reload', NULL),
(5, 186, 'sid', 'sid', NULL)");
// Request parameters per type handler - Ads4
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(6, 14, 'currency', 'waehrung', NULL),
(6, 14, 'extra', 'mediatype', 'forced_banner'),
(6, 14, 'id', 'id', NULL),
(6, 119, 'reward', 'verg', NULL)");
// Request parameters per type handler - Ads4Webbis
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(7, 17, 'extra', 'typ', 'forcedbanner'),
(7, 17, 'id', 'id', NULL),
(7, 17, 'password', 'pw', NULL),
(7, 120, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - Ads4World
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(8, 26, 'extra', 'typ', 'forcedbanner'),
(8, 26, 'id', 'id', NULL),
(8, 26, 'password', 'pw', NULL),
// Request parameters per type handler - Affiliblatt
// Request parameters per type handler - AllAds4You
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(10, 167, 'extra', 'typ', 'forcedbanner'),
(10, 167, 'id', 'id', NULL),
(10, 167, 'password', 'pw', NULL),
(10, 176, 'sid', 'sid', NULL)");
// Request parameters per type handler - Alster-Marketing
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(11, 35, 'id', 'id', NULL),
(11, 35, 'password', 'pw', NULL),
(11, 35, 'reload', 'reload', NULL),
(11, 49, 'type', 'typ', 'view')");
// Request parameters per type handler - BonusSponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(12, 50, 'id', 'id', NULL),
(12, 50, 'password', 'pw', NULL),
(12, 50, 'reload', 'reload', NULL),
(12, 62, 'sid', 'sid', NULL)");
// Request parameters per type handler - City-Ads
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(24, 212, 'extra', 'typ', 'forcedbanner'),
(24, 212, 'id', 'id', NULL),
(24, 212, 'password', 'pw', NULL),
(24, 221, 'minimum_stay', 'ma', NULL)");
// Request parameters per type handler - doubleads
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(26, 232, 'id', 'id', NULL),
(26, 232, 'password', 'pw', NULL),
(26, 232, 'reload', 'reload', NULL),
(26, 246, 'sid', 'sid', NULL)");
// Request parameters per type handler - FuCoExSponsor.net
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(29, 273, 'extra', 'art', 'bannerklick'),
(29, 273, 'id', 'uid', NULL),
(29, 273, 'password', 'pw', NULL),
(29, 289, 'sid', 'sid', NULL)");
// Request parameters per type handler - Fusion-Ads
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(13, 290, 'extra', 'art', 'Forcedbanner'),
(13, 290, 'id', 'uid', NULL),
(13, 290, 'password', 'pw', NULL),
(13, 291, 'sid', 'sid', NULL)");
// Request parameters per type handler - GigapPromo
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(14, 102, 'id', 'id', NULL),
(14, 102, 'password', 'pw', NULL),
(14, 102, 'reload', 'reload', NULL),
(14, 108, 'sid', 'aid', NULL)");
// Request parameters per type handler - Gold-Sponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(25, 222, 'extra', 'typ', 'forcedbanner'),
(25, 222, 'id', 'id', NULL),
(25, 222, 'minimum_stay', 'ma', NULL),
(25, 231, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - homeADS
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(28, 260, 'id', 'id', NULL),
(28, 260, 'password', 'pw', NULL),
(28, 260, 'reload', 'reload', NULL),
(28, 272, 'sid', 'sid', NULL)");
// Request parameters per type handler - HPSponsor
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(15, 135, 'extra', 'typ', 'forcedbanner'),
(15, 135, 'id', 'id', NULL),
(15, 135, 'password', 'pw', NULL),
(15, 144, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - Make-Euros
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(16, 63, 'id', 'id', NULL),
(16, 63, 'password', 'pw', NULL),
(16, 63, 'reload', 'reload', NULL),
(16, 77, 'sid', 'sid', NULL)");
// Request parameters per type handler - Mega-Ad
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(17, 109, 'extra', 'typ', 'forcedbanner'),
(17, 109, 'id', 'id', NULL),
(17, 109, 'password', 'pw', NULL),
(17, 123, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - Power-Promo
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(18, 78, 'id', 'id', NULL),
(18, 78, 'password', 'pw', NULL),
(18, 78, 'reload', 'reload', NULL),
(18, 92, 'sid', 'sid', NULL)");
// Request parameters per type handler - SeCash
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(19, 93, 'extra', 'typ', 'forcedbanner'),
(19, 93, 'id', 'id', NULL),
(19, 93, 'password', 'pw', NULL),
(19, 124, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - Swizerland
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(20, 202, 'extra', 'typ', 'forcedbanner'),
(20, 202, 'id', 'id', NULL),
(20, 202, 'password', 'pw', NULL),
(20, 211, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - UltraPROMO
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(21, 125, 'extra', 'typ', 'bannerklick'),
(21, 125, 'id', 'id', NULL),
(21, 125, 'password', 'pw', NULL),
(21, 134, 'reward', 'verguetung', NULL)");
// Request parameters per type handler - VIPads.de
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(27, 247, 'extra', 'art', 'bannerklick'),
(27, 247, 'id', 'uid', NULL),
(27, 247, 'password', 'pw', NULL),
(27, 259, 'sid', 'sid', NULL)");
// Request parameters per type handler - Der Werbepartner.cc
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(22, 145, 'extra', 'art', 'Textlinkklick'),
(22, 145, 'id', 'uid', NULL),
(22, 145, 'password', 'pw', NULL),
(22, 155, 'sid', 'sid', NULL)");
// Request parameters per type handler - Yoo!Media
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_request_params` (`network_id`,`network_type_id`,`request_param_key`,`request_param_value`,`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
(23, 156, 'erotic', 'erotik', NULL),
(23, 156, 'id', 'id', NULL),
(23, 156, 'password', 'pw', NULL),
// 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
+(32, 312, 1, 1),
+(32, 312, 2, 2),
+(32, 312, 4, 3),
+(32, 312, 5, 4),
+(32, 312, 6, 5),
+(32, 313, 1, 1),
+(32, 313, 2, 2),
+(32, 313, 4, 3),
+(32, 313, 5, 4),
+(32, 313, 6, 5),
+(32, 314, 1, 1),
+(32, 314, 2, 2),
+(32, 314, 4, 3),
+(32, 314, 5, 4),
+(32, 314, 6, 5),
+(32, 315, 1, 1),
+(32, 315, 2, 2),
+(32, 315, 4, 3),
+(32, 315, 5, 4),
+(32, 315, 6, 5),
+(32, 316, 1, 1),
+(32, 316, 2, 2),
+(32, 316, 4, 3),
+(32, 316, 5, 4),
+(32, 316, 6, 5),
+(32, 317, 1, 1),
+(32, 317, 2, 2),
+(32, 317, 4, 3),
+(32, 317, 5, 4),
+(32, 317, 6, 5),
+(32, 318, 1, 1),
+(32, 318, 2, 2),
+(32, 318, 4, 3),
+(32, 318, 5, 4),
+(32, 318, 6, 5),
+(32, 319, 1, 1),
+(32, 319, 2, 2),
+(32, 319, 4, 3),
+(32, 319, 5, 4),
+(32, 319, 6, 5),
+(32, 320, 1, 1),
+(32, 320, 2, 2),
+(32, 320, 4, 3),
+(32, 320, 5, 4),
+(32, 320, 6, 5),
+(32, 320, 10, 6),
+(32, 321, 1, 1),
+(32, 321, 2, 2),
+(32, 321, 4, 3),
+(32, 321, 5, 4),
+(32, 321, 6, 5),
+(32, 321, 10, 6),
+(32, 321, 9, 7)");
+
// API array elements - ADCocktail
// API array elements - AdConvention
(23, 166, 9, 5)");
// Admin menu entries
- addAdminMenuSql('network',NULL,'Werbenetzwerke','Verwalten Sie hier Werbenetzwerke (API-Anbindung), versenden Sie deren Mails, oder übernehmen Sie deren Textlinks und vieles mehr. <strong>VORSICHT:</strong> Das Einrichten von weiteren Werbenetzwerken ist nicht leicht, dafür aber sehr flexibel! Sollte ein Netzwerk fehlen, so melden Sie dies bitte <a href="http://forum.mxchange.org/topic-462.html" target="_blank" title="Direktlink zum Forum">im Forum</a>!',4);
- addAdminMenuSql('network','config_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 Referal-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','config_network','Einstellungen','Stellen Sie generelle Einstellungen ein, die für alle Werbenetzwerke gelten, wie z.B. Cache-Erneuerungsinterval. Generell sind aber die Einstellungen in Ordnung, da z.B. sonst Ihre freien Abfragen beim Werbenetzwerk sich zu schnell abbauen.',4);
- addAdminMenuSql('network','list_network_reloads','Reload-Sperren','Listen oder löschen Sie hier Reload-Sperren. <strong>Vorsicht:</strong> Die hier gespeicherten Reload-Sperren sind vom jeweiligen Werbenetzwerk übernommen. Eventuell verdienen Sie nichts, wenn Sie z.B. eine Mail innerhalb der Reload-Sperre erneut versenden.',5);
- addAdminMenuSql('network','list_networks','Auflisten/Verwalten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',6);
- addAdminMenuSql('network','list_network_types','Werbearten','<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen zu den Werbearten pro Werbenetzwerken. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',7);
- addAdminMenuSql('network','list_network_params','Abfrageparameter','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Abfrageparameter (wie sie genannt werden müssen, um das API-Script korrekt aufrufen zu können) ein, pro Werbenetzwerk. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',8);
- addAdminMenuSql('network','list_network_api_translation','Antwort-Array','<strong>Experten-Einstellungen!</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>Experten-Einstellungen!</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_network_error_types','Fehlertypen','<strong>Experten-Einstellungen!</strong> Hier stellen Sie die Namen von Fehlercodes ein, die Scripte zurückliefern können. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Stellen Sie an diesen Einstellungen bitte nichts um. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',12);
+ 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', 'config_network', 'Einstellungen', 'Stellen Sie generelle Einstellungen ein, die für alle Werbenetzwerke gelten, wie z.B. Cache-Erneuerungsinterval. Generell sind aber die Einstellungen in Ordnung, da z.B. sonst Ihre freien Abfragen beim Werbenetzwerk sich zu schnell abbauen.',4);
+ addAdminMenuSql('network', 'list_network_reloads', 'Reload-Sperren', 'Listen oder löschen Sie hier Reload-Sperren. <strong>Vorsicht:</strong> Die hier gespeicherten Reload-Sperren sind vom jeweiligen Werbenetzwerk übernommen. Eventuell verdienen Sie nichts, wenn Sie z.B. eine Mail innerhalb der Reload-Sperre erneut versenden.',5);
+ addAdminMenuSql('network', 'list_networks', 'Auflisten/Verwalten', '<strong>Experten-Einstellungen!</strong> Hier ändern Sie die Einstellungen an den Grunddaten (Stammdaten) des jeweiligen Werbenetzwerks ab. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 6);
+ addAdminMenuSql('network', 'list_network_types', 'Werbearten-Handler', '<strong>Experten-Einstellungen!</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>Experten-Einstellungen!</strong> Hier stellen Sie die Abfrageparameter (wie sie genannt werden müssen, um das API-Script korrekt aufrufen zu können) ein, pro Werbenetzwerk. Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.', 8);
+ addAdminMenuSql('network', 'list_network_api_translation', 'Antwort-Array', '<strong>Experten-Einstellungen!</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>Experten-Einstellungen!</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_error_types');
addDropTableSql('network_api_translation');
addDropTableSql('network_api_config');
addDropTableSql('network_types_config');