* @TODO Ad-Magnet: Layer(klick?). Layerviews.Skybannerklick/-view, *
* @TODO Ad-Magnet: Banner-View, Textlink-Klick/-View. Page-Peel *
* @TODO ADCocktail: All request parameters, BIDausKAS, WIDausKAS??? *
+ * @TODO ADCocktail: Zero array element is return code! *
* @TODO Affiliblatt: All except banner, do they really have UTF-8? *
* @TODO AllAds4You: Traffic from abroad *
* @TODO doubleads: Which charset? *
// Valid translation keys (we hate hard-coded arrays, you see?)
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` (
-`network_translate_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
-`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
-`network_translation` VARCHAR(100) NOT NULL DEFAULT '',
-UNIQUE `type_trans` (`network_type_id`,`network_translation`),
-PRIMARY KEY (`network_translate_id`)
+`network_translation_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`network_translation_name` VARCHAR(100) NOT NULL DEFAULT '',
+UNIQUE (`network_translation_name`),
+PRIMARY KEY (`network_translation_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Translations for array keys, generic data, DO NOT ALTER!'");
// Array-Element translation tables per type/provider
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_index_translation` VARCHAR(100) NOT NULL DEFAULT '',
+`sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
-UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_index_translation`),
+INDEX (`sort`),
PRIMARY KEY (`network_api_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Translation of API responses, generic data, DO NOT ALTER!'");
`network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
`network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
-`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
+`network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE `provider_type` (`network_id`,`network_type_id`),
PRIMARY KEY (`network_reload_id`)
) TYPE={?_TABLE_TYPE?} COMMENT='Reload locks'");
+ // Insert API response array translations, these will be used for calling the right filter function
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_translations` (`network_translation_id`, `network_translation_name`) VALUES
+(1, 'id'),
+(2, 'name'),
+(3, 'alternate_text'),
+(4, 'reload'),
+(5, 'remain'),
+(6, 'reward'),
+(7, 'banner_id'),
+(8, 'size'),
+(9, 'text'),
+(10, 'minimum_stay'),
+(11, 'textlink_id'),
+(12, 'surfbar_id'),
+(13, 'mail_id'),
+(14, 'layer_id'),
+(15, 'popup_id'),
+(16, 'popdown_id'),
+(17, 'lead_id'),
+(18, 'sale_id'),
+(19, 'banner_url1'),
+(20, 'banner_url2'),
+(21, 'banner_url3'),
+(22, 'textlink1'),
+(23, 'textlink2'),
+(24, 'textlink3'),
+(25, 'description'),
+(26, 'traffic_id'),
+(27, 'country_code')");
+
// Insert error code types
// - Affiliate id or interface password wrong
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('AFF_ID_PASS_WRONG')");
- // - Webmaster's site id is not assigned (invalid, different affiliate id)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('SITE_ID_NOT_ASSIGNED')");
- // - Webmaster's site id is locked
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('SITE_ID_LOCKED')");
- // - General error in interface data
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('INTERFACE_DATA_ERROR')");
- // - Request amount depleted
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('REQUESTS_DEPLETED')");
- // - No campaigns found for given criteria (but maybe there are with more widen criteria)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND')");
- // - No campaigns found with allowed interface output (but there are maybe non-interface campaigns)
- addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND_INTERFACE')");
- // - 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_PARAMETER_INCOMPLETE')");
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code_id`, `network_code`) VALUES
+(1, 'AFF_ID_PASS_WRONG'),
+(2, 'SITE_ID_NOT_ASSIGNED'),
+(3, 'SITE_ID_LOCKED'),
+(4, 'INTERFACE_DATA_ERROR'),
+(5, 'REQUESTS_DEPLETED'),
+(6, 'NO_CAMPAIGNS_FOUND'),
+(7, 'NO_CAMPAIGNS_FOUND_INTERFACE'),
+(8, 'SITE_ID_NOT_ALLOWED_TYPE'),
+(9, '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
// Network type handlers - Ads4Webbis
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
-(20, 7, 'banner_click', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(20, 7, 'banner_click', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
(19, 7, 'banner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(24, 7, 'popup', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
-(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
-(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+(22, 7, 'button_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(17, 7, 'forcedbanner', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(18, 7, 'forcedtextlink', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(24, 7, 'popup', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(21, 7, 'skybanner_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', 'http://www.ads4webbis.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
+(23, 7, 'textlink_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(25, 7, 'textmail', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL),
+(120, 7, 'traffic', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%tid%', NULL)");
// Network type handlers - Ads4World
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
(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`=''");
- addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_request_params` SET `request_param_default`=NULL WHERE `request_param_default`=''");
+ // API array elements - A3H
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(1, 1, 1, 7, 1),
+(2, 1, 1, 2, 2),
+(3, 1, 1, 3, 3),
+(4, 1, 1, 4, 4),
+(5, 1, 1, 5, 5),
+(6, 1, 1, 6, 6),
+(7, 1, 1, 8, 7),
+(8, 1, 1, 10, 8),
+(9, 1, 2, 11, 1),
+(10, 1, 2, 2, 2),
+(11, 1, 2, 9, 3),
+(12, 1, 2, 4, 4),
+(13, 1, 2, 5, 5),
+(14, 1, 2, 6, 6),
+(15, 1, 3, 12, 1),
+(16, 1, 3, 2, 2),
+(17, 1, 3, 3, 3),
+(18, 1, 3, 4, 4),
+(19, 1, 3, 5, 5),
+(20, 1, 3, 6, 6),
+(21, 1, 3, 8, 7),
+(22, 1, 4, 7, 1),
+(23, 1, 4, 2, 2),
+(24, 1, 4, 3, 3),
+(25, 1, 4, 4, 4),
+(26, 1, 4, 5, 5),
+(27, 1, 4, 6, 6),
+(28, 1, 4, 10, 7),
+(29, 1, 4, 8, 8),
+(30, 1, 5, 13, 1),
+(31, 1, 5, 2, 2),
+(32, 1, 5, 4, 3),
+(33, 1, 5, 5, 4),
+(34, 1, 5, 6, 5),
+(35, 1, 5, 10, 6),
+(36, 1, 5, 9, 7),
+(37, 1, 6, 14, 1),
+(38, 1, 6, 2, 2),
+(39, 1, 6, 4, 3),
+(40, 1, 6, 5, 4),
+(41, 1, 6, 6, 5),
+(42, 1, 7, 15, 1),
+(43, 1, 7, 2, 2),
+(44, 1, 7, 4, 3),
+(45, 1, 7, 5, 4),
+(46, 1, 7, 6, 5),
+(47, 1, 7, 10, 6),
+(48, 1, 8, 16, 1),
+(49, 1, 8, 2, 2),
+(50, 1, 8, 4, 3),
+(51, 1, 8, 5, 4),
+(52, 1, 8, 6, 5),
+(53, 1, 8, 10, 6),
+(54, 1, 9, 17, 1),
+(55, 1, 9, 2, 2),
+(56, 1, 9, 6, 3),
+(57, 1, 9, 19, 4),
+(58, 1, 9, 20, 5),
+(59, 1, 9, 21, 6),
+(60, 1, 9, 22, 7),
+(61, 1, 9, 23, 8),
+(62, 1, 9, 9, 9),
+(63, 1, 9, 25, 10),
+(64, 1, 9, 5, 11),
+(65, 1, 10, 18, 1),
+(66, 1, 10, 2, 2),
+(67, 1, 10, 6, 3),
+(68, 1, 10, 19, 4),
+(69, 1, 10, 20, 5),
+(70, 1, 10, 21, 6),
+(71, 1, 10, 22, 7),
+(72, 1, 10, 23, 8),
+(73, 1, 10, 9, 9),
+(74, 1, 10, 25, 10)");
+
+ // API array elements - AbisZED-Netz
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(75, 2, 187, 7, 1),
+(76, 2, 187, 2, 2),
+(77, 2, 187, 3, 3),
+(78, 2, 187, 4, 4),
+(79, 2, 187, 5, 5),
+(80, 2, 187, 6, 6),
+(81, 2, 187, 8, 7),
+(82, 2, 187, 10, 8),
+(83, 2, 188, 7, 1),
+(84, 2, 188, 2, 2),
+(85, 2, 188, 3, 3),
+(86, 2, 188, 4, 4),
+(87, 2, 188, 5, 5),
+(88, 2, 188, 6, 6),
+(89, 2, 188, 8, 7),
+(90, 2, 188, 10, 8),
+(91, 2, 189, 11, 1),
+(92, 2, 189, 2, 2),
+(93, 2, 189, 9, 3),
+(94, 2, 189, 4, 4),
+(95, 2, 189, 5, 5),
+(96, 2, 189, 6, 6),
+(97, 2, 190, 11, 1),
+(98, 2, 190, 2, 2),
+(99, 2, 190, 9, 3),
+(100, 2, 190, 4, 4),
+(101, 2, 190, 5, 5),
+(102, 2, 190, 6, 6),
+(103, 2, 191, 12, 1),
+(104, 2, 191, 2, 2),
+(105, 2, 191, 3, 3),
+(106, 2, 191, 4, 4),
+(107, 2, 191, 5, 5),
+(108, 2, 191, 6, 6),
+(109, 2, 191, 8, 7),
+(110, 2, 192, 12, 1),
+(111, 2, 192, 10, 2),
+(112, 2, 192, 3, 3),
+(113, 2, 192, 4, 4),
+(114, 2, 192, 5, 5),
+(115, 2, 192, 6, 6),
+(116, 2, 192, 8, 7),
+(117, 2, 193, 7, 1),
+(118, 2, 193, 2, 2),
+(119, 2, 193, 3, 3),
+(120, 2, 193, 4, 4),
+(121, 2, 193, 5, 5),
+(122, 2, 193, 6, 6),
+(123, 2, 193, 10, 7),
+(124, 2, 193, 8, 8),
+(125, 2, 194, 13, 1),
+(126, 2, 194, 2, 2),
+(127, 2, 194, 4, 3),
+(128, 2, 194, 5, 4),
+(129, 2, 194, 6, 5),
+(130, 2, 194, 10, 6),
+(131, 2, 194, 9, 7),
+(132, 2, 195, 13, 1),
+(133, 2, 195, 2, 2),
+(134, 2, 195, 4, 3),
+(135, 2, 195, 5, 4),
+(136, 2, 195, 6, 5),
+(137, 2, 195, 10, 6),
+(138, 2, 195, 9, 7),
+(139, 2, 196, 14, 1),
+(140, 2, 196, 2, 2),
+(141, 2, 196, 4, 3),
+(142, 2, 196, 5, 4),
+(143, 2, 196, 6, 5),
+(144, 2, 197, 14, 1),
+(145, 2, 197, 2, 2),
+(146, 2, 197, 4, 3),
+(147, 2, 197, 5, 4),
+(148, 2, 197, 6, 5),
+(149, 2, 198, 15, 1),
+(150, 2, 198, 2, 2),
+(151, 2, 198, 4, 3),
+(152, 2, 198, 5, 4),
+(153, 2, 198, 6, 5),
+(154, 2, 198, 10, 6),
+(155, 2, 199, 16, 1),
+(156, 2, 199, 2, 2),
+(157, 2, 199, 4, 3),
+(158, 2, 199, 5, 4),
+(159, 2, 199, 6, 5),
+(160, 2, 199, 10, 6),
+(161, 2, 200, 17, 1),
+(162, 2, 200, 2, 2),
+(163, 2, 200, 6, 3),
+(164, 2, 200, 19, 4),
+(165, 2, 200, 20, 5),
+(166, 2, 200, 21, 6),
+(167, 2, 200, 22, 7),
+(168, 2, 200, 23, 8),
+(169, 2, 200, 9, 9),
+(170, 2, 200, 25, 10),
+(171, 2, 200, 5, 11),
+(172, 2, 201, 18, 1),
+(173, 2, 201, 2, 2),
+(174, 2, 201, 6, 3),
+(175, 2, 201, 19, 4),
+(176, 2, 201, 20, 5),
+(177, 2, 201, 21, 6),
+(178, 2, 201, 22, 7),
+(179, 2, 201, 23, 8),
+(180, 2, 201, 9, 9),
+(181, 2, 201, 25, 10)");
+
+ // API array elements - AD-Magnet
+
+ // API array elements - ADCocktail
+
+ // API array elements - AdPaid
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(182, 5, 177, 7, 1),
+(183, 5, 177, 2, 2),
+(184, 5, 177, 3, 3),
+(185, 5, 177, 4, 4),
+(186, 5, 177, 5, 5),
+(187, 5, 177, 6, 6),
+(188, 5, 177, 8, 7),
+(189, 5, 177, 10, 8),
+(190, 5, 178, 11, 1),
+(191, 5, 178, 2, 2),
+(192, 5, 178, 9, 3),
+(193, 5, 178, 4, 4),
+(194, 5, 178, 5, 5),
+(195, 5, 178, 6, 6),
+(196, 5, 179, 12, 1),
+(197, 5, 179, 2, 2),
+(198, 5, 179, 3, 3),
+(199, 5, 179, 4, 4),
+(200, 5, 179, 5, 5),
+(201, 5, 179, 6, 6),
+(202, 5, 179, 8, 7),
+(203, 5, 180, 7, 1),
+(204, 5, 180, 2, 2),
+(205, 5, 180, 3, 3),
+(206, 5, 180, 4, 4),
+(207, 5, 180, 5, 5),
+(208, 5, 180, 6, 6),
+(209, 5, 180, 10, 7),
+(210, 5, 180, 8, 8),
+(211, 5, 181, 13, 1),
+(212, 5, 181, 2, 2),
+(213, 5, 181, 4, 3),
+(214, 5, 181, 5, 4),
+(215, 5, 181, 6, 5),
+(216, 5, 181, 10, 6),
+(217, 5, 181, 9, 7),
+(218, 5, 182, 14, 1),
+(219, 5, 182, 2, 2),
+(220, 5, 182, 4, 3),
+(221, 5, 182, 5, 4),
+(222, 5, 182, 6, 5),
+(223, 5, 183, 15, 1),
+(224, 5, 183, 2, 2),
+(225, 5, 183, 4, 3),
+(226, 5, 183, 5, 4),
+(227, 5, 183, 6, 5),
+(228, 5, 183, 10, 6),
+(229, 5, 185, 17, 1),
+(230, 5, 185, 2, 2),
+(231, 5, 185, 6, 3),
+(232, 5, 185, 19, 4),
+(233, 5, 185, 20, 5),
+(234, 5, 185, 21, 6),
+(235, 5, 185, 22, 7),
+(236, 5, 185, 23, 8),
+(237, 5, 185, 9, 9)");
+
+ // API array elements - Ads4.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(239, 6, 14, 7, 1),
+(240, 6, 14, 2, 2),
+(241, 6, 14, 6, 3),
+(242, 6, 14, 4, 4),
+(243, 6, 14, 5, 5),
+(244, 6, 14, 10, 6),
+(245, 6, 15, 13, 1),
+(246, 6, 15, 2, 2),
+(247, 6, 15, 6, 3),
+(248, 6, 15, 4, 4),
+(249, 6, 15, 5, 5),
+(250, 6, 15, 10, 6),
+(251, 6, 16, 13, 1),
+(252, 6, 16, 2, 2),
+(253, 6, 16, 6, 3),
+(254, 6, 16, 4, 4),
+(255, 6, 16, 5, 5),
+(256, 6, 16, 10, 6),
+(257, 6, 119, 26, 1),
+(258, 6, 119, 2, 2),
+(259, 6, 119, 6, 3),
+(260, 6, 119, 4, 4),
+(261, 6, 119, 5, 5),
+(262, 6, 119, 10, 6)");
+
+ // API array elements - Ads4Webbis
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_api_id`, `network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(263, 7, 20, 1, 1),
+(264, 7, 20, 2, 2),
+(265, 7, 20, 4, 3),
+(266, 7, 20, 5, 4),
+(267, 7, 20, 6, 5),
+(268, 7, 20, 10, 6),
+(269, 7, 20, 9, 7),
+(270, 7, 20, 27, 8),
+(271, 7, 19, 1, 1),
+(272, 7, 19, 2, 2),
+(273, 7, 19, 4, 3),
+(274, 7, 19, 5, 4),
+(275, 7, 19, 6, 5),
+(276, 7, 19, 10, 6),
+(277, 7, 19, 9, 7),
+(278, 7, 19, 27, 8),
+(279, 7, 22, 1, 1),
+(280, 7, 22, 2, 2),
+(281, 7, 22, 4, 3),
+(282, 7, 22, 5, 4),
+(283, 7, 22, 6, 5),
+(284, 7, 22, 10, 6),
+(285, 7, 22, 9, 7),
+(286, 7, 22, 27, 8),
+(287, 7, 17, 1, 1),
+(288, 7, 17, 2, 2),
+(289, 7, 17, 4, 3),
+(290, 7, 17, 5, 4),
+(291, 7, 17, 6, 5),
+(292, 7, 17, 10, 6),
+(293, 7, 17, 9, 7),
+(294, 7, 17, 27, 8),
+(295, 7, 18, 1, 1),
+(296, 7, 18, 2, 2),
+(297, 7, 18, 4, 3),
+(298, 7, 18, 5, 4),
+(299, 7, 18, 6, 5),
+(300, 7, 18, 10, 6),
+(301, 7, 18, 9, 7),
+(302, 7, 18, 27, 8),
+(303, 7, 24, 1, 1),
+(304, 7, 24, 2, 2),
+(305, 7, 24, 4, 3),
+(306, 7, 24, 5, 4),
+(307, 7, 24, 6, 5),
+(308, 7, 24, 10, 6),
+(309, 7, 24, 9, 7),
+(310, 7, 24, 27, 8),
+(311, 7, 21, 1, 1),
+(312, 7, 21, 2, 2),
+(313, 7, 21, 4, 3),
+(314, 7, 21, 5, 4),
+(315, 7, 21, 6, 5),
+(316, 7, 21, 10, 6),
+(317, 7, 21, 9, 7),
+(318, 7, 21, 27, 8),
+(319, 7, 23, 1, 1),
+(320, 7, 23, 2, 2),
+(321, 7, 23, 4, 3),
+(322, 7, 23, 5, 4),
+(323, 7, 23, 6, 5),
+(324, 7, 23, 10, 6),
+(325, 7, 23, 9, 7),
+(326, 7, 23, 27, 8),
+(327, 7, 25, 1, 1),
+(328, 7, 25, 2, 2),
+(329, 7, 25, 4, 3),
+(330, 7, 25, 5, 4),
+(331, 7, 25, 6, 5),
+(332, 7, 25, 10, 6),
+(333, 7, 25, 9, 7),
+(334, 7, 25, 27, 8),
+(365, 7, 120, 1, 1),
+(336, 7, 120, 2, 2),
+(337, 7, 120, 4, 3),
+(338, 7, 120, 5, 4),
+(339, 7, 120, 6, 5),
+(340, 7, 120, 10, 6),
+(341, 7, 120, 9, 7),
+(342, 7, 120, 27, 8)");
+
+ // API array elements - Ads4World
+
+ // API array elements - Affiliblatt
+
+ // API array elements - AllAds4You
+
+ // API array elements - Alster-Marketing
+
+ // API array elements - BonusSponsor
+
+ // API array elements - Fusion-Ads
+
+ // API array elements - GigaPromo
+
+ // API array elements - HPSponsor
+
+ // API array elements - Make-Euros.de
+
+ // API array elements - Mega-Ad
+
+ // API array elements - Power-Promo
+
+ // API array elements - SeCash
+
+ // API array elements - The Swizerland Ad Network
+
+ // API array elements - UltraPOMO
+
+ // API array elements - Der Werbepartner.cc
+
+ // API array elements - Yoo!Media
// 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','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_translations','Array-Übersetzungen','<strong>Experten-Einstellungen!</strong> Hier richten Sie Array-Index-Übersetzungen für nicht-fehler API-Antworten ein. <strong>Dies sind INTERNE Daten und sollten nur vom Entwicklerteam angepasst werden.</strong> Sie sollten hier generell nichts einstellen und <a href="http://forum.mxchange.org/forum-43.html" target="_blank" title="Direktlink zum Forum">im Forum</a> um Hilfe fragen, wenn Sie selber ein Werbenetzwerk einrichten möchten.',9);
addAdminMenuSql('network','list_network_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);
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`');
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_api_translation`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`');
projects / mailer.git / blobdiff