* @TODO AllAds4You: Traffic from abroad, High-Forced banner *
* @TODO Fusion-Ads: Has click/banner URL in API response, really UTF-8 *
* @TODO GolloX: Which charset? *
- * @TODO homeADS: Which charset? *
* @TODO paid4ad: Which URLs for click and banner? *
- * @TODO VIPads: Which charset? *
+ * @TODO VIPads: HTML text is send encoded with BASE64 *
* @TODO Der Werbepartner.cc: Banner click/view is JavaScript! *
* @TODO Der Werbepartner.cc: Forced textlink not correct *
* @TODO Der Werbepartner.cc: Layer not correct *
(39, 'media_url')");
// Insert error code types
- // - Affiliate id or interface password wrong
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_error_types` (`network_code_id`, `network_code`) VALUES
(1, 'AFF_ID_PASS_WRONG'),
(2, 'SITE_ID_NOT_ASSIGNED'),
('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252'),
('cityads', 'City-Ads', 'http://www.city-ads.de?ref=221', '|', '|', 'GET', 'WINDOWS-1252'),
('goldsponsor', 'Gold-Sponsor', 'http://www.gold-sponsor.de?ref=42', '|', '|', 'GET', 'WINDOWS-1252'),
-('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1')");
+('doubleads', 'doubleads.de', 'http://www.doubleads.de?ref=1063', '|', '|', 'GET', 'ISO-8859-1'),
+('vipads', 'VIPads.de', 'http://vipads.de/index.php?seite=anmeldung&ref=Quix0r', '|', '|', 'GET', 'ISO-8859-1'),
+('homeads', 'homeADS', 'http://www.homeads.de/?ref=1540', '|', '|', 'GET', 'WINDOWS-1252')");
// Network type handlers - A3H
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`,`network_type_handle`,`network_type_api_url`,`network_type_click_url`,`network_type_banner_url`) VALUES
(231, 25, 'textmail', 'http://www.gold-sponsor.de/interface/', 'http://www.gold-sponsor.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
(229, 25, 'traffic', 'http://www.gold-sponsor.de/interface/', 'http://www.gold-sponsor.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
+ // Network type handlers - homeADS
+ 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
+(260, 28, 'banner_click', 'http://www.homeads.de/interface/out_banner.php', 'http://www.homeads.de/bannerklf.php?id=%CID%', 'http://www.homeads.de/banner.php?id=%CID%'),
+(261, 28, 'banner_view', 'http://www.homeads.de/interface/out_banner.php', 'http://www.homeads.de/bannerklf.php?id=%CID%', 'http://www.homeads.de/banner.php?id=%CID%'),
+(264, 28, 'forcedbanner', 'http://www.homeads.de/interface/out_fbanner.php', 'http://www.homeads.de/bannerklf.php?id=%CID%', 'http://www.homeads.de/banner.php?id=%CID%'),
+(266, 28, 'htmlmail', 'http://www.homeads.de/interface/out_paidmail.php', 'http://www.homeads.de/emailf.php?id=%CID%', NULL),
+(267, 28, 'layer_click', 'http://www.homeads.de/interface/out_layer.php', 'http://www.homeads.de/layer.php?id=%CID%', NULL),
+(268, 28, 'layer_view', 'http://www.homeads.de/interface/out_layer.php', 'http://www.homeads.de/layer.php?id=%CID%', NULL),
+(271, 28, 'lead', 'http://www.homeads.de/interface/out_lead.php', 'http://www.homeads.de/lead.php?id=%CID%', NULL),
+(270, 28, 'popdown', 'http://www.homeads.de/interface/out_popdown.php', 'http://www.homeads.de/popdown.php?id=%CID%', NULL),
+(269, 28, 'popup', 'http://www.homeads.de/interface/out_popup.php', 'http://www.homeads.de/popup.php?id=%CID%', NULL),
+(272, 28, 'sale', 'http://www.homeads.de/interface/out_sale.php', 'http://www.homeads.de/sale.php?id=%CID%', NULL),
+(262, 28, 'textlink_click', 'http://www.homeads.de/interface/out_textlink.php', 'http://www.homeads.de/textlinkklick.php?id=%CID%', NULL),
+(263, 28, 'textlink_view', 'http://www.homeads.de/interface/out_textlink.php', 'http://www.homeads.de/textlinkklick.php?id=%CID%', NULL),
+(265, 28, 'textmail', 'http://www.homeads.de/interface/out_paidmail.php', 'http://www.homeads.de/emailf.php?id=%CID%', NULL)");
+
// Network type handlers - HPSponsor
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
(135, 15, 'banner_click', 'http://hpsponsor.at/interface/api_2.php', 'http://hpsponsor.at/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%&trackid=%TID%', 'http://hpsponsor.at/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
(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 - VIPads.de
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_types` (`network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`) VALUES
+(247, 27, 'banner_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'),
+(248, 27, 'banner_view', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'),
+(249, 27, 'button_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'),
+(250, 27, 'button_view', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'),
+(251, 27, 'forcedbanner', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'),
+(252, 27, 'htmlmail', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL),
+(253, 27, 'layer', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/sc_layer.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL),
+(255, 27, 'popup', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/sc_popup.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL),
+(256, 27, 'skybanner_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'),
+(257, 27, 'skybanner_view', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', 'http://vipads.de/kamp/b_view.php?uid=%UID%&bid=%BID%&sid=%SID%'),
+(258, 27, 'textlink_click', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL),
+(254, 27, 'textmail', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%SID%', NULL),
+(259, 27, 'traffic', 'http://vipads.de/int/get.php', 'http://vipads.de/kamp/ziel.php?uid=%UID%&bid=%BID%&sid=%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, 22, 'textlink_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL),
(25, 231, 'remain', 'uebrig', 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
+(28, 260, 'id', 'id', NULL),
+(28, 260, 'password', 'pw', NULL),
+(28, 260, 'reload', 'reload', NULL),
+(28, 260, 'remain', 'uebrig', NULL),
+(28, 260, 'reward', 'verguetung', NULL),
+(28, 260, 'sid', 'sid', NULL),
+(28, 260, 'size', 'size', NULL),
+(28, 260, 'type', 'typ', 'klick'),
+(28, 261, 'id', 'id', NULL),
+(28, 261, 'password', 'pw', NULL),
+(28, 261, 'reload', 'reload', NULL),
+(28, 261, 'remain', 'uebrig', NULL),
+(28, 261, 'reward', 'verguetung', NULL),
+(28, 261, 'sid', 'sid', NULL),
+(28, 261, 'size', 'size', NULL),
+(28, 261, 'type', 'typ', 'view'),
+(28, 262, 'id', 'id', NULL),
+(28, 262, 'password', 'pw', NULL),
+(28, 262, 'reload', 'reload', NULL),
+(28, 262, 'remain', 'uebrig', NULL),
+(28, 262, 'reward', 'verguetung', NULL),
+(28, 262, 'sid', 'sid', NULL),
+(28, 262, 'type', 'typ', 'klick'),
+(28, 263, 'id', 'id', NULL),
+(28, 263, 'password', 'pw', NULL),
+(28, 263, 'reload', 'reload', NULL),
+(28, 263, 'remain', 'uebrig', NULL),
+(28, 263, 'reward', 'verguetung', NULL),
+(28, 263, 'sid', 'sid', NULL),
+(28, 263, 'type', 'typ', 'view'),
+(28, 264, 'id', 'id', NULL),
+(28, 264, 'minimum_stay', 'ma', NULL),
+(28, 264, 'password', 'pw', NULL),
+(28, 264, 'reload', 'reload', NULL),
+(28, 264, 'remain', 'uebrig', NULL),
+(28, 264, 'reward', 'verguetung', NULL),
+(28, 264, 'sid', 'sid', NULL),
+(28, 264, 'size', 'size', NULL),
+(28, 265, 'id', 'id', NULL),
+(28, 265, 'minimum_stay', 'ma', NULL),
+(28, 265, 'password', 'pw', NULL),
+(28, 265, 'reload', 'reload', NULL),
+(28, 265, 'remain', 'uebrig', NULL),
+(28, 265, 'reward', 'verguetung', NULL),
+(28, 265, 'sid', 'sid', NULL),
+(28, 265, 'type', 'typ', 'text'),
+(28, 266, 'id', 'id', NULL),
+(28, 266, 'minimum_stay', 'ma', NULL),
+(28, 266, 'password', 'pw', NULL),
+(28, 266, 'reload', 'reload', NULL),
+(28, 266, 'remain', 'uebrig', NULL),
+(28, 266, 'reward', 'verguetung', NULL),
+(28, 266, 'sid', 'sid', NULL),
+(28, 266, 'type', 'typ', 'html'),
+(28, 267, 'id', 'id', NULL),
+(28, 267, 'password', 'pw', NULL),
+(28, 267, 'reload', 'reload', NULL),
+(28, 267, 'remain', 'uebrig', NULL),
+(28, 267, 'reward', 'verguetung', NULL),
+(28, 267, 'sid', 'sid', NULL),
+(28, 267, 'type', 'typ', 'klick'),
+(28, 268, 'id', 'id', NULL),
+(28, 268, 'password', 'pw', NULL),
+(28, 268, 'reload', 'reload', NULL),
+(28, 268, 'remain', 'uebrig', NULL),
+(28, 268, 'reward', 'verguetung', NULL),
+(28, 268, 'sid', 'sid', NULL),
+(28, 268, 'type', 'typ', 'view'),
+(28, 269, 'id', 'id', NULL),
+(28, 269, 'minimum_stay', 'ma', NULL),
+(28, 269, 'password', 'pw', NULL),
+(28, 269, 'reload', 'reload', NULL),
+(28, 269, 'remain', 'uebrig', NULL),
+(28, 269, 'reward', 'verguetung', NULL),
+(28, 269, 'sid', 'sid', NULL),
+(28, 270, 'id', 'id', NULL),
+(28, 270, 'minimum_stay', 'ma', NULL),
+(28, 270, 'password', 'pw', NULL),
+(28, 270, 'reload', 'reload', NULL),
+(28, 270, 'remain', 'uebrig', NULL),
+(28, 270, 'reward', 'verguetung', NULL),
+(28, 270, 'sid', 'sid', NULL),
+(28, 271, 'id', 'id', NULL),
+(28, 271, 'password', 'pw', NULL),
+(28, 271, 'remain', 'uebrig', NULL),
+(28, 271, 'reward', 'verguetung', NULL),
+(28, 271, 'sid', 'sid', NULL),
+(28, 272, 'id', 'id', NULL),
+(28, 272, 'password', 'pw', NULL),
+(28, 272, 'remain', 'uebrig', NULL),
+(28, 272, 'reward', 'verguetung', 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
(15, 135, 'extra', 'typ', 'forcedbanner'),
(21, 134, 'remain', 'uebrig', 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
+(27, 247, 'extra', 'art', 'bannerklick'),
+(27, 247, 'id', 'uid', NULL),
+(27, 247, 'password', 'pw', NULL),
+(27, 247, 'reload', 'reload', NULL),
+(27, 247, 'remain', 'uebrig', NULL),
+(27, 247, 'reward', 'verguetung', NULL),
+(27, 247, 'sid', 'sid', NULL),
+(27, 248, 'extra', 'art', 'bannerview'),
+(27, 248, 'id', 'uid', NULL),
+(27, 248, 'password', 'pw', NULL),
+(27, 248, 'reload', 'reload', NULL),
+(27, 248, 'remain', 'uebrig', NULL),
+(27, 248, 'reward', 'verguetung', NULL),
+(27, 248, 'sid', 'sid', NULL),
+(27, 249, 'extra', 'art', 'buttonklick'),
+(27, 249, 'id', 'uid', NULL),
+(27, 249, 'password', 'pw', NULL),
+(27, 249, 'reload', 'reload', NULL),
+(27, 249, 'remain', 'uebrig', NULL),
+(27, 249, 'reward', 'verguetung', NULL),
+(27, 249, 'sid', 'sid', NULL),
+(27, 250, 'extra', 'art', 'buttonview'),
+(27, 250, 'id', 'uid', NULL),
+(27, 250, 'password', 'pw', NULL),
+(27, 250, 'reload', 'reload', NULL),
+(27, 250, 'remain', 'uebrig', NULL),
+(27, 250, 'reward', 'verguetung', NULL),
+(27, 250, 'sid', 'sid', NULL),
+(27, 251, 'extra', 'art', 'forcedbanner'),
+(27, 251, 'id', 'uid', NULL),
+(27, 251, 'minimum_stay', 'ma', NULL),
+(27, 251, 'password', 'pw', NULL),
+(27, 251, 'reload', 'reload', NULL),
+(27, 251, 'remain', 'uebrig', NULL),
+(27, 251, 'reward', 'verguetung', NULL),
+(27, 251, 'sid', 'sid', NULL),
+(27, 252, 'extra', 'art', 'htmlmail'),
+(27, 252, 'id', 'id', NULL),
+(27, 252, 'minimum_stay', 'ma', NULL),
+(27, 252, 'password', 'pw', NULL),
+(27, 252, 'reload', 'reload', NULL),
+(27, 252, 'remain', 'uebrig', NULL),
+(27, 252, 'reward', 'verguetung', NULL),
+(27, 252, 'sid', 'sid', NULL),
+(27, 253, 'extra', 'art', 'layer'),
+(27, 253, 'id', 'uid', NULL),
+(27, 253, 'password', 'pw', NULL),
+(27, 253, 'reload', 'reload', NULL),
+(27, 253, 'remain', 'uebrig', NULL),
+(27, 253, 'reward', 'verguetung', NULL),
+(27, 253, 'sid', 'sid', NULL),
+(27, 254, 'extra', 'art', 'paidmail'),
+(27, 254, 'id', 'uid', NULL),
+(27, 254, 'minimum_stay', 'ma', NULL),
+(27, 254, 'password', 'pw', NULL),
+(27, 254, 'reload', 'reload', NULL),
+(27, 254, 'remain', 'uebrig', NULL),
+(27, 254, 'reward', 'verguetung', NULL),
+(27, 254, 'sid', 'sid', NULL),
+(27, 255, 'extra', 'art', 'popup'),
+(27, 255, 'id', 'uid', NULL),
+(27, 255, 'minimum_stay', 'ma', NULL),
+(27, 255, 'password', 'pw', NULL),
+(27, 255, 'reload', 'reload', NULL),
+(27, 255, 'remain', 'uebrig', NULL),
+(27, 255, 'reward', 'verguetung', NULL),
+(27, 255, 'sid', 'sid', NULL),
+(27, 256, 'extra', 'art', 'skybannerklick'),
+(27, 256, 'id', 'uid', NULL),
+(27, 256, 'password', 'pw', NULL),
+(27, 256, 'reload', 'reload', NULL),
+(27, 256, 'remain', 'uebrig', NULL),
+(27, 256, 'reward', 'verguetung', NULL),
+(27, 256, 'sid', 'sid', NULL),
+(27, 257, 'extra', 'art', 'skybannerview'),
+(27, 257, 'id', 'uid', NULL),
+(27, 257, 'password', 'pw', NULL),
+(27, 257, 'reload', 'reload', NULL),
+(27, 257, 'remain', 'uebrig', NULL),
+(27, 257, 'reward', 'verguetung', NULL),
+(27, 257, 'sid', 'sid', NULL),
+(27, 258, 'extra', 'art', 'textlinkklick'),
+(27, 258, 'id', 'uid', NULL),
+(27, 258, 'password', 'pw', NULL),
+(27, 258, 'reload', 'reload', NULL),
+(27, 258, 'remain', 'uebrig', NULL),
+(27, 258, 'reward', 'verguetung', NULL),
+(27, 258, 'sid', 'sid', NULL),
+(27, 259, 'extra', 'art', 'traffic'),
+(27, 259, 'id', 'uid', NULL),
+(27, 259, 'minimum_stay', 'ma', NULL),
+(27, 259, 'password', 'pw', NULL),
+(27, 259, 'reload', 'reload', NULL),
+(27, 259, 'remain', 'uebrig', NULL),
+(27, 259, 'reward', 'verguetung', 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
(22, 145, 'extra', 'art', 'Textlinkklick'),
(25, 231, 10, 6),
(25, 231, 9, 7)");
+ // API array elements - homeADS
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(28, 260, 1, 1),
+(28, 260, 2, 2),
+(28, 260, 3, 3),
+(28, 260, 4, 4),
+(28, 260, 5, 5),
+(28, 260, 6, 6),
+(28, 260, 8, 7),
+(28, 260, 10, 8),
+(28, 261, 1, 1),
+(28, 261, 2, 2),
+(28, 261, 3, 3),
+(28, 261, 4, 4),
+(28, 261, 5, 5),
+(28, 261, 6, 6),
+(28, 261, 8, 7),
+(28, 261, 10, 8),
+(28, 262, 1, 1),
+(28, 262, 2, 2),
+(28, 262, 9, 3),
+(28, 262, 4, 4),
+(28, 262, 5, 5),
+(28, 262, 6, 6),
+(28, 263, 1, 1),
+(28, 263, 2, 2),
+(28, 263, 9, 3),
+(28, 263, 4, 4),
+(28, 263, 5, 5),
+(28, 263, 6, 6),
+(28, 264, 1, 1),
+(28, 264, 2, 2),
+(28, 264, 3, 3),
+(28, 264, 4, 4),
+(28, 264, 5, 5),
+(28, 264, 6, 6),
+(28, 264, 10, 7),
+(28, 264, 8, 8),
+(28, 265, 1, 1),
+(28, 265, 2, 2),
+(28, 265, 4, 3),
+(28, 265, 5, 4),
+(28, 265, 6, 5),
+(28, 265, 10, 6),
+(28, 265, 9, 7),
+(28, 266, 1, 1),
+(28, 266, 2, 2),
+(28, 266, 4, 3),
+(28, 266, 5, 4),
+(28, 266, 6, 5),
+(28, 266, 10, 6),
+(28, 266, 9, 7),
+(28, 267, 1, 1),
+(28, 267, 2, 2),
+(28, 267, 4, 3),
+(28, 267, 5, 4),
+(28, 267, 6, 5),
+(28, 268, 1, 1),
+(28, 268, 2, 2),
+(28, 268, 4, 3),
+(28, 268, 5, 4),
+(28, 268, 6, 5),
+(28, 269, 1, 1),
+(28, 269, 2, 2),
+(28, 269, 4, 3),
+(28, 269, 5, 4),
+(28, 269, 6, 5),
+(28, 269, 10, 6),
+(28, 270, 1, 1),
+(28, 270, 2, 2),
+(28, 270, 4, 3),
+(28, 270, 5, 4),
+(28, 270, 6, 5),
+(28, 270, 10, 6),
+(28, 271, 1, 1),
+(28, 271, 2, 2),
+(28, 271, 6, 3),
+(28, 271, 19, 4),
+(28, 271, 20, 5),
+(28, 271, 21, 6),
+(28, 271, 22, 7),
+(28, 271, 23, 8),
+(28, 271, 9, 9),
+(28, 271, 25, 10),
+(28, 271, 5, 11),
+(28, 272, 1, 1),
+(28, 272, 2, 2),
+(28, 272, 19, 3),
+(28, 272, 20, 4),
+(28, 272, 21, 5),
+(28, 272, 22, 6),
+(28, 272, 23, 7),
+(28, 272, 9, 8),
+(28, 272, 25, 9),
+(28, 272, 5, 10)");
+
// API array elements - HPSponsor
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
(15, 135, 1, 1),
(21, 134, 5, 4),
(21, 134, 6, 5)");
+ // API array elements - VIPads
+ addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
+(27, 247, 7, 1),
+(27, 247, 2, 2),
+(27, 247, 5, 3),
+(27, 247, 4, 4),
+(27, 247, 6, 5),
+(27, 248, 7, 1),
+(27, 248, 2, 2),
+(27, 248, 5, 3),
+(27, 248, 4, 4),
+(27, 248, 6, 5),
+(27, 249, 7, 1),
+(27, 249, 2, 2),
+(27, 249, 5, 3),
+(27, 249, 4, 4),
+(27, 249, 6, 5),
+(27, 250, 7, 1),
+(27, 250, 2, 2),
+(27, 250, 5, 3),
+(27, 250, 4, 4),
+(27, 250, 6, 5),
+(27, 251, 7, 1),
+(27, 251, 2, 2),
+(27, 251, 5, 3),
+(27, 251, 4, 4),
+(27, 251, 6, 5),
+(27, 251, 10, 6),
+(27, 252, 13, 1),
+(27, 252, 2, 2),
+(27, 252, 5, 3),
+(27, 252, 4, 4),
+(27, 252, 6, 5),
+(27, 252, 10, 6),
+(27, 252, 37, 7),
+(27, 252, 9, 8),
+(27, 253, 14, 1),
+(27, 253, 2, 2),
+(27, 253, 5, 3),
+(27, 253, 4, 4),
+(27, 253, 6, 5),
+(27, 254, 13, 1),
+(27, 254, 2, 2),
+(27, 254, 5, 3),
+(27, 254, 4, 4),
+(27, 254, 6, 5),
+(27, 254, 10, 6),
+(27, 254, 37, 7),
+(27, 254, 9, 8),
+(27, 255, 15, 1),
+(27, 255, 2, 2),
+(27, 255, 5, 3),
+(27, 255, 4, 4),
+(27, 255, 6, 5),
+(27, 255, 10, 6),
+(27, 256, 7, 1),
+(27, 256, 2, 2),
+(27, 256, 5, 3),
+(27, 256, 4, 4),
+(27, 256, 6, 5),
+(27, 257, 7, 1),
+(27, 257, 2, 2),
+(27, 257, 5, 3),
+(27, 257, 4, 4),
+(27, 257, 6, 5),
+(27, 258, 11, 1),
+(27, 258, 2, 2),
+(27, 258, 5, 3),
+(27, 258, 4, 4),
+(27, 258, 6, 5),
+(27, 258, 9, 6),
+(27, 259, 26, 1),
+(27, 259, 2, 2),
+(27, 259, 5, 3),
+(27, 259, 4, 4),
+(27, 259, 6, 5),
+(27, 259, 10, 6)");
+
// API array elements - Der Werbepartner.cc
addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_api_translation` (`network_id`, `network_type_id`, `network_api_index`, `sort`) VALUES
(22, 145, 1, 1),