2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 12/18/2008 *
4 * =================== Last change: 12/19/2009 *
6 * -------------------------------------------------------------------- *
7 * File : ext-network.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Generic (sponsor) network connection extension *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Allgemeine Werbenetzwerk-Erweiterung *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * Needs to be in all Files and every File needs "svn propset *
18 * svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
19 * -------------------------------------------------------------------- *
20 * @TODO AbisZED: Which charset? *
21 * @TODO Ad-Magnet: Layer(klick?). Layerviews.Skybannerklick/-view, *
22 * @TODO Ad-Magnet: Banner-View, Textlink-Klick/-View. Page-Peel *
23 * @TODO ADCocktail: All request parameters, BIDausKAS, WIDausKAS??? *
24 * @TODO Affiliblatt: All except banner, do they really have UTF-8? *
25 * @TODO doubleads: Which charset? *
26 * @TODO Fusion-Ads: Has click/banner URL in API response, really UTF-8 *
27 * @TODO GolloX: Which charset? *
28 * @TODO homeADS: Which charset? *
29 * @TODO paid4ad: Which URLs for click and banner? *
30 * @TODO Der Werbepartner.cc: Has extra-parameter &step=1 in click URL *
31 * -------------------------------------------------------------------- *
32 * Copyright (c) 2003 - 2009 by Roland Haeder *
33 * Copyright (c) 2009, 2010 by Mailer Developer Team *
34 * For more information visit: http://www.mxchange.org *
36 * This program is free software; you can redistribute it and/or modify *
37 * it under the terms of the GNU General Public License as published by *
38 * the Free Software Foundation; either version 2 of the License, or *
39 * (at your option) any later version. *
41 * This program is distributed in the hope that it will be useful, *
42 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
43 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
44 * GNU General Public License for more details. *
46 * You should have received a copy of the GNU General Public License *
47 * along with this program; if not, write to the Free Software *
48 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
50 ************************************************************************/
52 // Some security stuff...
53 if (!defined('__SECURITY')) {
58 setThisExtensionVersion('0.0');
60 // Version history array (add more with , '0.1.0' and so on)
61 setExtensionVersionHistory(array('0.0'));
63 // This extension is in development (non-productive)
64 enableExtensionProductive(false);
66 switch (getExtensionMode()) {
67 case 'register': // Do stuff when installation is running (modules.php?module=admin is called)
68 // Main table which hold
69 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_data`');
70 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_data` (
71 `network_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
72 `network_short_name` VARCHAR(50) NOT NULL DEFAULT '',
73 `network_title` VARCHAR(255) NOT NULL DEFAULT '',
74 `network_reflink` VARCHAR(255) NOT NULL DEFAULT '',
75 `network_data_seperator` CHAR(4) NOT NULL DEFAULT '|',
76 `network_row_seperator` CHAR(4) NOT NULL DEFAULT '|',
77 `network_request_type` ENUM('GET','POST') NOT NULL DEFAULT 'GET',
78 `network_charset` VARCHAR(20) NOT NULL DEFAULT 'UTF-8',
79 UNIQUE (`network_short_name`),
80 PRIMARY KEY (`network_id`)
81 ) TYPE={?_TABLE_TYPE?} COMMENT='Network data'");
83 // Types the network provider is supporting (e.g. Forced-Banner and so on)
84 // @TODO network_type_handle is an internal name and needs documentation
85 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types`');
86 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types` (
87 `network_type_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
88 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
89 `network_type_handle` VARCHAR(255) NOT NULL DEFAULT '',
90 `network_type_api_url` VARCHAR(255) NOT NULL DEFAULT '',
91 `network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '',
92 `network_type_banner_url` VARCHAR(255) NULL DEFAULT NULL,
93 UNIQUE `provider_type` (`network_id`,`network_type_handle`),
94 PRIMARY KEY (`network_type_id`)
95 ) TYPE={?_TABLE_TYPE?} COMMENT='Types provideable by networks'");
97 // HTTP parameters (names) for URLs
98 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`');
99 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_request_params` (
100 `network_param_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
101 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
102 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
103 `request_param_key` VARCHAR(10) NOT NULL DEFAULT 'invalid',
104 `request_param_value` VARCHAR(10) NOT NULL DEFAULT 'invalid',
105 `request_param_default` VARCHAR(255) NULL DEFAULT NULL,
106 UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
107 UNIQUE `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`),
108 PRIMARY KEY (`network_param_id`)
109 ) TYPE={?_TABLE_TYPE?} COMMENT='Request parameters for GET/POST request'");
111 // Error status codes
112 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_type_codes`');
113 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_type_codes` (
114 `network_type_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
115 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
116 `network_type_code_value` VARCHAR(50) NOT NULL DEFAULT '',
117 `network_type_code_type` VARCHAR(100) NOT NULL DEFAULT 'INVALID_TYPE',
118 UNIQUE `code_type` (`network_type_code_value`,`network_type_id`),
119 INDEX (`network_type_id`),
120 PRIMARY KEY (`network_type_code_id`)
121 ) TYPE={?_TABLE_TYPE?} COMMENT='Error codes for all types'");
123 // Code types (internal table)
124 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_codes`');
125 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_codes` (
126 `network_code_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
127 `network_code` VARCHAR(100) NOT NULL DEFAULT 'INVALID_CODE',
128 UNIQUE (`network_code`),
129 PRIMARY KEY (`network_code_id`)
130 ) TYPE={?_TABLE_TYPE?} COMMENT='Error types, generic data, DO NOT ALTER!'");
132 // Valid translation keys (we hate hard-coded arrays, you see?)
133 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
134 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_translations` (
135 `network_translate_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
136 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
137 `network_translation` VARCHAR(100) NOT NULL DEFAULT '',
138 UNIQUE `type_trans` (`network_type_id`,`network_translation`),
139 PRIMARY KEY (`network_translate_id`)
140 ) TYPE={?_TABLE_TYPE?} COMMENT='Translations for array keys, generic data, DO NOT ALTER!'");
142 // Array-Element translation tables per type/provider
143 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_return_types`');
144 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_return_types` (
145 `network_return_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
146 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
147 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
148 `network_return_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
149 `network_index_translation` VARCHAR(100) NOT NULL DEFAULT '',
150 UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_return_index`),
151 UNIQUE `provider_type_trans` (`network_id`,`network_type_id`,`network_index_translation`),
152 PRIMARY KEY (`network_translate_id`)
153 ) TYPE={?_TABLE_TYPE?} COMMENT='Return types'");
155 // Data from the webmaster (you!)
156 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
157 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_config` (
158 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
159 `network_affiliate_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
160 `network_api_password` VARCHAR(255) NOT NULL DEFAULT '',
161 `network_site_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
162 `network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
163 `network_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
164 UNIQUE `network_affiliate` (`network_id`,`network_affiliate_id`),
165 UNIQUE `affiliate_site` (`network_affiliate_id`,`network_site_id`),
166 PRIMARY KEY (`network_id`)
167 ) TYPE={?_TABLE_TYPE?} COMMENT='Configuration data from the webmaster (you!)'");
169 // Configuration data for e.g. reload-time
170 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`');
171 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_types_config` (
172 `network_data_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
173 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
174 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
175 `max_reload_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
176 `min_waiting_time` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
177 `min_remain_clicks` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
178 `min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
179 `allow_erotic` VARCHAR(10) NOT NULL DEFAULT '',
180 UNIQUE `provider_type` (`network_id`,`network_type_id`),
181 PRIMARY KEY (`network_data_id`)
182 ) TYPE={?_TABLE_TYPE?} COMMENT='Configuration data for every type (e.g. reload-time)'");
184 // Cache for queried APIs. Re-check depends on config
185 // `network_cache_refresh` in seconds or if set to zero, full day
186 // divided by query amount.
187 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_cache`');
188 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_cache` (
189 `network_cache_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
190 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
191 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
192 `network_cache_data` MEDIUMBLOB,
193 `network_cache_timestamp` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00',
194 UNIQUE `provider_type` (`network_id`,`network_type_id`),
195 PRIMARY KEY (`network_cache_id`)
196 ) TYPE={?_TABLE_TYPE?} COMMENT='Cache for all queried APIs'");
198 // Reload locks for several types
199 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_reloads`');
200 addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_network_reloads` (
201 `network_reload_id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
202 `network_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
203 `network_type_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
204 `network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
205 `network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP(),
206 UNIQUE `provider_type` (`network_id`,`network_type_id`),
207 PRIMARY KEY (`network_reload_id`)
208 ) TYPE={?_TABLE_TYPE?} COMMENT='Reload locks'");
210 // Insert error code types
211 // - Affiliate id or interface password wrong
212 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('AFF_ID_PASS_WRONG')");
213 // - Webmaster's site id is not assigned (invalid, different affiliate id)
214 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_NOT_ASSIGNED')");
215 // - Webmaster's site id is locked
216 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_LOCKED')");
217 // - General error in interface data
218 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('INTERFACE_DATA_ERROR')");
219 // - Request amount depleted
220 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('REQUESTS_DEPLETED')");
221 // - No campaigns found for given criteria (but maybe there are with more widen criteria)
222 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND')");
223 // - No campaigns found with allowed interface output (but there are maybe non-interface campaigns)
224 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('NO_CAMPAIGNS_FOUND_INTERFACE')");
225 // - Webmaster's site id is not unlocked for choosen type
226 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('SITE_ID_NOT_ALLOWED_TYPE')");
227 // - Request parameters incomplete
228 addExtensionSql("INSERT INTO `{?_MYSQL_PREFIX?}_network_codes` (`network_code`) VALUES ('REQUEST_PARAMS_INCOMPLETE')");
231 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
232 ('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252'),
233 ('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252'),
234 ('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1'),
235 ('adcocktail', 'ADCocktail', 'http://www.adcocktail.com/?rid=2596', '|', '|', 'GET', 'WINDOWS-1252'),
236 ('ads4', 'Ads4.de', 'http://www.ads4.de/?werber=Quix0r', '|', '|', 'GET', 'WINDOWS-1252'),
237 ('ads4webbis', 'Ads4Webbis', 'http://www.ads4webbis.de?ref=835', '|', '|', 'GET', 'WINDOWS-1252'),
238 ('ads4world', 'Ads4World', 'http://www.ads4world.de?ref=252', '|', '|', 'GET', 'WINDOWS-1252'),
239 ('affiliblatt', 'Affiliblatt', 'http://www.Affiliblatt.de/?sid=MTAzNQ==&site=home', '|', '|', 'GET', 'UTF-8'),
240 ('alster', 'Alster-Marketing', 'http://www.alstermarketing.de?ref=1851', '|', '|', 'GET', 'ISO-8859-16'),
241 ('bonus', 'BonusSponsor', 'http://www.bonussponsor.de?ref=1286', '|', '|', 'GET', 'WINDOWS-1252'),
242 ('fusion', 'Fusion-Ads', 'http://www.fusion-ads.de/?ref=84', '|', '|', 'GET', 'UTF-8'),
243 ('gigapromo', 'GigaPromo', 'http://www.gigapromo.de/index.php?ref=953', '|', '|', 'GET', 'WINDOWS-1252'),
244 ('hpsonsor', 'HPSponsor', 'http://hpsponsor.de?ref=29', '|', '|', 'GET', 'WINDOWS-1252'),
245 ('make-euros', 'Make-Euros.de', 'http://www.make-euros.de?ref=1184', '|', '|', 'GET', 'ISO-8859-1'),
246 ('megad', 'Mega-Ad', 'http://www.mega-ad.de/?ref=303', '|', '|', 'GET', 'WINDOWS-1252'),
247 ('power-promo', 'Power-Promo', 'http://www.power-promo.de?ref=1231', '|', '|', 'GET', 'WINDOWS-1252'),
248 ('secash', 'SeCash', 'http://www.secash.de?ref=758', '|', '|', 'GET', 'WINDOWS-1252'),
249 ('ultrapromo', 'UltraPROMO', 'http://www.ultrapromo.eu?ref=485', '|', '|', 'GET', 'WINDOWS-1252'),
250 ('werbepartnercc', 'Der Werbepartner.cc', 'http://www.werbepartner.cc/sponsor/?ref=696', '|', '|', 'GET', 'WINDOWS-1252'),
251 ('yoomedia', 'Yoo!Media Solutions', 'http://www.yoomedia.de?ref=1715', '|', '|', 'GET', 'WINDOWS-1252')");
253 // Network type handlers - A3H
254 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
255 (1, 1, 'banner', 'http://www.a3h.de/interface/out_banner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
256 (2, 1, 'textlink', 'http://www.a3h.de/interface/out_textlink.php', 'http://www.a3h.de/textlinkklick.php?id=%CID%', NULL),
257 (3, 1, 'surfbar', 'http://www.a3h.de/interface/out_sbanner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
258 (4, 1, 'forcedbanner', 'http://www.a3h.de/interface/out_fbanner.php', 'http://www.a3h.de/bannerklf.php?id=%CID%', 'http://www.a3h.de/banner.php?id=%CID%'),
259 (5, 1, 'textmail', 'http://www.a3h.de/interface/out_paidmail.php', 'http://www.a3h.de/emailf.php?id=%CID%', NULL),
260 (6, 1, 'layer', 'http://www.a3h.de/interface/out_layer.php', 'http://www.a3h.de/layer.php?id=%CID%', NULL),
261 (7, 1, 'popup', 'http://www.a3h.de/interface/out_popup.php', 'http://www.a3h.de/popup.php?id=%CID%', NULL),
262 (8, 1, 'popdown', 'http://www.a3h.de/interface/out_popdown.php', 'http://www.a3h.de/popdown.php?id=%CID%', NULL),
263 (9, 1, 'lead', 'http://www.a3h.de/interface/out_lead.php', 'http://www.a3h.de/lead.php?id=%CID%', NULL),
264 (10, 1, 'sale', 'http://www.a3h.de/interface/out_sale.php', 'http://www.a3h.de/sale.php?id=%CID%', NULL),
265 (11, 1, 'htmlmail', 'http://www.a3h.de/interface/out_paidmail.php', 'http://www.a3h.de/emailf.php?id=%CID%', NULL)");
267 // Network type handlers - AbisZED-Netz
269 // Network type handlers - Ad-Magnet
271 // Network type handlers - AdCocktail
272 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
273 (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%'),
274 (12, 4, 'textmail', 'http://www.adcocktail.com/sc/kas/kas_pm.php', 'http://pm.adcocktail.com/pm.php?uid=%UID%&wid=%CID%&wsid=%SID%', NULL)");
276 // Network type handlers - Ads4
277 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
278 (14, 5, 'forcedbanner', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/forced_click.php?fb_id=%CID%&sid=%SID%', 'http://www.ads4.de/forced_view.php?fb_id=%CID%&sid=%SID%'),
279 (16, 5, 'htmlmail', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/paidmail_click.php?pm=%CID%&%sid=%SID%', NULL),
280 (15, 5, 'textmail', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/paidmail_click.php?pm=%CID%&%sid=%SID%', NULL),
281 (119, 5, 'traffic', 'http://www.ads4.de/interface/interface.php', 'http://www.ads4.de/traffic_click.php?tr_id=%CID%&sid=%SID%', '')");
283 // Network type handlers - Ads4Webbis
284 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
285 (20, 6, '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%'),
286 (19, 6, '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%'),
287 (22, 6, '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%'),
288 (17, 6, '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%'),
289 (18, 6, 'forcedtextlink', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
290 (24, 6, 'popup', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
291 (21, 6, '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%'),
292 (23, 6, 'textlink_view', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
293 (25, 6, 'textmail', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
294 (120, 6, 'traffic', 'http://www.ads4webbis.de/interface/', 'http://www.ads4webbis.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
296 // Network type handlers - Ads4World
297 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
298 (29, 7, 'banner_click', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
299 (28, 7, 'banner_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
300 (31, 7, 'button_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
301 (26, 7, 'forcedbanner', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
302 (27, 7, 'forcedtextlink', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
303 (33, 7, 'popup', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
304 (30, 7, 'skybanner_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.ads4world.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
305 (32, 7, 'textlink_view', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
306 (34, 7, 'textmail', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
307 (121, 7, 'traffic', 'http://www.ads4world.de/interface/', 'http://www.ads4world.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
309 // Network type handlers - Affiliblatt
311 // Network type handlers - Alster-Marketing
312 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
313 (35, 9, 'banner_click', 'http://if.alstermarketing.de/interface/out_banner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
314 (45, 9, 'banner_view', 'http://if.alstermarketing.de/interface/out_banner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
315 (38, 9, 'forcedbanner', 'http://if.alstermarketing.de/interface/out_fbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
316 (48, 9, 'htmlmail', 'http://if.alstermarketing.de/interface/out_paidmail.php', 'http://www.alstermarketing.de/emailf.php?id=%CID%', NULL),
317 (40, 9, 'layer_click', 'http://if.alstermarketing.de/interface/out_layer.php', 'http://www.alstermarketing.de/layer.php?id=%CID%', NULL),
318 (49, 9, 'layer_view', 'http://if.alstermarketing.de/interface/out_layer.php', 'http://www.alstermarketing.de/layer.php?id=%CID%', NULL),
319 (43, 9, 'lead', 'http://if.alstermarketing.de/interface/out_lead.php', 'http://www.alstermarketing.de/lead.php?id=%CID%', NULL),
320 (42, 9, 'popdown', 'http://if.alstermarketing.de/interface/out_popdown.php', 'http://www.alstermarketing.de/popdown.php?id=%CID%', NULL),
321 (41, 9, 'popup', 'http://if.alstermarketing.de/interface/out_popup.php', 'http://www.alstermarketing.de/popup.php?id=%CID%', NULL),
322 (44, 9, 'sale', 'http://if.alstermarketing.de/interface/out_sale.php', 'http://www.alstermarketing.de/sale.php?id=%CID%', NULL),
323 (37, 9, 'surfbar_click', 'http://if.alstermarketing.de/interface/out_sbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
324 (47, 9, 'surfbar_view', 'http://if.alstermarketing.de/interface/out_sbanner.php', 'http://www.alstermarketing.de/bannerklf.php?id=%CID%', 'http://www.alstermarketing.de/banner.php?id=%CID%'),
325 (36, 9, 'textlink_click', 'http://if.alstermarketing.de/interface/out_textlink.php', 'http://www.alstermarketing.de/textlinkklick.php?id=%CID%', NULL),
326 (46, 9, 'textlink_view', 'http://if.alstermarketing.de/interface/out_textlink.php', 'http://www.alstermarketing.de/textlinkklick.php?id=%CID%', NULL),
327 (39, 9, 'textmail', 'http://if.alstermarketing.de/interface/out_paidmail.php', 'http://www.alstermarketing.de/emailf.php?id=%CID%', NULL)");
329 // Network type handlers - BonusSponsor
330 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
331 (50, 10, 'banner_click', 'http://www.bonussponsor.de/interface/out_banner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
332 (51, 10, 'banner_view', 'http://www.bonussponsor.de/interface/out_banner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
333 (54, 10, 'forcedbanner', 'http://www.bonussponsor.de/interface/out_fbanner.php', 'http://www.bonussponsor.de/bannerklf.php?id=%CID%', 'http://www.bonussponsor.de/banner.php?id=%CID%'),
334 (56, 10, 'htmlmail', 'http://www.bonussponsor.de/interface/out_paidmail.php', 'http://www.bonussponsor.de/emailf.php?id=%CID%', NULL),
335 (57, 10, 'layer_click', 'http://www.bonussponsor.de/interface/out_layer.php', 'http://www.bonussponsor.de/layer.php?id=%CID%', NULL),
336 (58, 10, 'layer_view', 'http://www.bonussponsor.de/interface/out_layer.php', 'http://www.bonussponsor.de/layer.php?id=%CID%', NULL),
337 (61, 10, 'lead', 'http://www.bonussponsor.de/interface/out_lead.php', 'http://www.bonussponsor.de/lead.php?id=%CID%', NULL),
338 (60, 10, 'popdown', 'http://www.bonussponsor.de/interface/out_popdown.php', 'http://www.bonussponsor.de/popdown.php?id=%CID%', NULL),
339 (59, 10, 'popup', 'http://www.bonussponsor.de/interface/out_popup.php', 'http://www.bonussponsor.de/popup.php?id=%CID%', NULL),
340 (62, 10, 'sale', 'http://www.bonussponsor.de/interface/out_sale.php', 'http://www.bonussponsor.de/sale.php?id=%CID%', NULL),
341 (52, 10, 'textlink_click', 'http://www.bonussponsor.de/interface/out_textlink.php', 'http://www.bonussponsor.de/textlinkklick.php?id=%CID%', NULL),
342 (53, 10, 'textlink_view', 'http://www.bonussponsor.de/interface/out_textlink.php', 'http://www.bonussponsor.de/textlinkklick.php?id=%CID%', NULL),
343 (55, 10, 'textmail', 'http://www.bonussponsor.de/interface/out_paidmail.php', 'http://www.bonussponsor.de/emailf.php?id=%CID%', NULL)");
345 // Network type handlers - Fusion-Ads
347 // Network type handlers - GigaPromo
348 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
349 (102, 12, 'banner_view', 'http://www.gigapromo.de/interface/output_viewbanner.php', 'http://www.gigapromo.de/view/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.gigapromo.de/view/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
350 (104, 12, 'forcedbanner', 'http://www.gigapromo.de/interface/output_forcedbanner.php', 'http://www.gigapromo.de/view/forcedclickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.gigapromo.de/view/forcedviewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
351 (105, 12, 'forcedtextlink', 'http://www.gigapromo.de/interface/output_forcedtextlink.php', 'http://www.gigapromo.de/view/forcedclicktextlink.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
352 (103, 12, 'layer_view', 'http://www.gigapromo.de/interface/output_layerviews.php', 'http://www.gigapromo.de/view/layer.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
353 (108, 12, 'popdown', 'http://www.gigapromo.de/interface/output_popdown.php', 'http://www.gigapromo.de/view/popdown.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
354 (107, 12, 'popup', 'http://www.gigapromo.de/interface/output_popup.php', 'http://www.gigapromo.de/view/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
355 (106, 12, 'textmail', 'http://www.gigapromo.de/interface/output_paidmails.php', 'http://www.gigapromo.de/view/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
356 (122, 12, 'traffic', 'http://www.gigapromo.de/interface/output_traffic.php', 'http://www.gigapromo.de/view/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
358 // Network type handlers - HPSponsor
359 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
360 (135, 13, 'banner_click', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
361 (136, 13, 'banner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
362 (137, 13, 'button_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
363 (138, 13, 'forcedbanner', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
364 (139, 13, 'forcedtextlink', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
365 (140, 13, 'popup', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
366 (141, 13, 'skybanner_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://hpsponsor.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
367 (142, 13, 'textlink_view', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
368 (143, 13, 'textmail', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
369 (144, 13, 'traffic', 'http://hpsponsor.de/interface/', 'http://hpsponsor.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%CID%', NULL)");
371 // Network type handlers - Make-Euros
372 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
373 (63, 14, 'banner_click', 'http://www.make-euros.de/interface/out_banner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
374 (64, 14, 'banner_view', 'http://www.make-euros.de/interface/out_banner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
375 (68, 14, 'forcedbanner', 'http://www.make-euros.de/interface/out_fbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
376 (71, 14, 'htmlmail', 'http://www.make-euros.de/interface/out_paidmail.php', 'http://www.make-euros.de/emailf.php?id=%CID%', NULL),
377 (72, 14, 'layer_click', 'http://www.make-euros.de/interface/out_layer.php', 'http://www.make-euros.de/layer.php?id=%CID%', NULL),
378 (73, 14, 'layer_view', 'http://www.make-euros.de/interface/out_layer.php', 'http://www.make-euros.de/layer.php?id=%CID%', NULL),
379 (76, 14, 'lead', 'http://www.make-euros.de/interface/out_lead.php', 'http://www.make-euros.de/lead.php?id=%CID%', NULL),
380 (75, 14, 'popdown', 'http://www.make-euros.de/interface/out_popdown.php', 'http://www.make-euros.de/popdown.php?id=%CID%', NULL),
381 (74, 14, 'popup', 'http://www.make-euros.de/interface/out_popup.php', 'http://www.make-euros.de/popup.php?id=%CID%', NULL),
382 (77, 14, 'sale', 'http://www.make-euros.de/interface/out_sale.php', 'http://www.make-euros.de/sale.php?id=%CID%', NULL),
383 (67, 14, 'surfbar_click', 'http://www.make-euros.de/interface/out_sbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
384 (69, 14, 'surfbar_view', 'http://www.make-euros.de/interface/out_sbanner.php', 'http://www.make-euros.de/bannerklf.php?id=%CID%', 'http://www.make-euros.de/banner.php?id=%CID%'),
385 (65, 14, 'textlink_click', 'http://www.make-euros.de/interface/out_textlink.php', 'http://www.make-euros.de/textlinkklick.php?id=%CID%', NULL),
386 (66, 14, 'textlink_view', 'http://www.make-euros.de/interface/out_textlink.php', 'http://www.make-euros.de/textlinkklick.php?id=%CID%', NULL),
387 (70, 14, 'textmail', 'http://www.make-euros.de/interface/out_paidmail.php', 'http://www.make-euros.de/emailf.php?id=%CID%', NULL)");
389 // Network type handlers - Mega-Ad
390 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
391 (112, 15, 'banner_click', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/view.php?id=%UID%&bid=%CID%&aid=%SID%'),
392 (111, 15, 'banner_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
393 (114, 15, 'button_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
394 (109, 15, 'forcedbanner', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
395 (110, 15, 'forcedtextlink', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
396 (116, 15, 'popup', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
397 (113, 15, 'skybanner_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.mega-ad.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
398 (115, 15, 'textlink_view', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
399 (117, 15, 'textmail', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
400 (123, 15, 'traffic', 'http://www.mega-ad.de/interface/', 'http://www.mega-ad.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
402 // Network type handlers - Power-Promo
403 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
404 (78, 16, 'banner_click', 'http://www.power-promo.de/interface/out_banner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
405 (79, 16, 'banner_view', 'http://www.power-promo.de/interface/out_banner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
406 (84, 16, 'forcedbanner', 'http://www.power-promo.de/interface/out_fbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
407 (86, 16, 'htmlmail', 'http://www.power-promo.de/interface/out_paidmail.php', 'http://www.power-promo.de/emailf.php?id=%CID%', NULL),
408 (87, 16, 'layer_click', 'http://www.power-promo.de/interface/out_layer.php', 'http://www.power-promo.de/layer.php?id=%CID%', NULL),
409 (88, 16, 'layer_view', 'http://www.power-promo.de/interface/out_layer.php', 'http://www.power-promo.de/layer.php?id=%CID%', NULL),
410 (91, 16, 'lead', 'http://www.power-promo.de/interface/out_lead.php', 'http://www.power-promo.de/lead.php?id=%CID%', NULL),
411 (90, 16, 'popdown', 'http://www.power-promo.de/interface/out_popdown.php', 'http://www.power-promo.de/popdown.php?id=%CID%', NULL),
412 (89, 16, 'popup', 'http://www.power-promo.de/interface/out_popup.php', 'http://www.power-promo.de/popup.php?id=%CID%', NULL),
413 (92, 16, 'sale', 'http://www.power-promo.de/interface/out_sale.php', 'http://www.power-promo.de/sale.php?id=%CID%', NULL),
414 (82, 16, 'surfbar_click', 'http://www.power-promo.de/interface/out_sbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
415 (83, 16, 'surfbar_view', 'http://www.power-promo.de/interface/out_sbanner.php', 'http://www.power-promo.de/bannerklf.php?id=%CID%', 'http://www.power-promo.de/banner.php?id=%CID%'),
416 (80, 16, 'textlink_click', 'http://www.power-promo.de/interface/out_textlink.php', 'http://www.power-promo.de/textlinkklick.php?id=%CID%', NULL),
417 (81, 16, 'textlink_view', 'http://www.power-promo.de/interface/out_textlink.php', 'http://www.power-promo.de/textlinkklick.php?id=%CID%', NULL),
418 (85, 16, 'textmail', 'http://www.power-promo.de/interface/out_paidmail.php', 'http://www.power-promo.de/emailf.php?id=%CID%', NULL)");
420 // Network type handlers - SeCash
421 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
422 (96, 17, 'banner_click', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/klickbanner.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/viewbanner.php?id=%UID%&bid=%CID%&aid=%SID%'),
423 (95, 17, 'banner_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/bannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/bannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
424 (98, 17, 'button_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/buttonklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/buttonview.php?id=%UID%&bid=%CID%&aid=%SID%'),
425 (93, 17, 'forcedbanner', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/forcedbannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/forcedbannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
426 (94, 17, 'forcedtextlink', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
427 (100, 17, 'popup', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
428 (97, 17, 'skybanner_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/skybannerklick.php?id=%UID%&bid=%CID%&aid=%SID%', 'http://www.secash.de/codes/skybannerview.php?id=%UID%&bid=%CID%&aid=%SID%'),
429 (99, 17, 'textlink_view', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
430 (101, 17, 'textmail', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
431 (124, 17, 'traffic', 'http://www.secash.de/interface/', 'http://www.secash.de/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
433 // Network type handlers - UltraPROMO
434 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
435 (125, 18, '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%'),
436 (126, 18, '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%'),
437 (127, 18, '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%'),
438 (128, 18, '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%'),
439 (129, 18, 'forcedtextlink', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/forcedtextlinkklick.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
440 (130, 18, 'popup', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/popup.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
441 (131, 18, '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%'),
442 (132, 18, 'textlink_view', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/textlinkview.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
443 (133, 18, 'textmail', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/paidmail.php?id=%UID%&bid=%CID%&aid=%SID%', NULL),
444 (134, 18, 'traffic', 'http://www.ultrapromo.eu/interface/', 'http://www.ultrapromo.eu/codes/traffic.php?id=%UID%&bid=%CID%&aid=%SID%', NULL)");
446 // Network type handlers - Der Werbepartner.cc
447 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
448 (145, 19, 'textlink_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL),
449 (146, 19, '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'),
450 (147, 19, 'textmail', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/werbung.php', NULL),
451 (148, 19, 'layer', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
452 (149, 19, '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'),
453 (150, 19, 'surfbar_click', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
454 (151, 19, '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'),
455 (152, 19, 'popup', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
456 (153, 19, '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'),
457 (154, 19, 'forcedtextlink', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL),
458 (155, 19, 'traffic', 'http://www.werbepartner.cc/sponsor/data/get.php', 'http://www.werbepartner.cc/sponsor/data/get.php', NULL)");
460 // Network type handlers - Yoo!Media
462 // Request parameters per type handler - A3H
463 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
464 (1, 1, 1, 'id', 'id', NULL),
465 (2, 1, 1, 'sid', 'sid', NULL),
466 (3, 1, 1, 'password', 'pw', NULL),
467 (4, 1, 1, 'reload', 'reload', NULL),
468 (5, 1, 1, 'reward', 'verguetung', NULL),
469 (6, 1, 1, 'min_stay', 'ma', NULL),
470 (7, 1, 1, 'type', 'typ', NULL),
471 (8, 1, 1, 'remain', 'uebrig', NULL),
472 (9, 1, 1, 'size', 'size', NULL),
473 (10, 1, 2, 'id', 'id', NULL),
474 (11, 1, 2, 'sid', 'sid', NULL),
475 (12, 1, 2, 'password', 'pw', NULL),
476 (13, 1, 2, 'reload', 'reload', NULL),
477 (14, 1, 2, 'reward', 'verguetung', NULL),
478 (15, 1, 2, 'remain', 'uebrig', NULL),
479 (16, 1, 3, 'id', 'id', NULL),
480 (17, 1, 3, 'sid', 'sid', NULL),
481 (18, 1, 3, 'password', 'pw', NULL),
482 (19, 1, 3, 'reload', 'reload', NULL),
483 (20, 1, 3, 'reward', 'verguetung', NULL),
484 (21, 1, 3, 'type', 'typ', NULL),
485 (22, 1, 3, 'remain', 'uebrig', NULL),
486 (23, 1, 3, 'size', 'size', NULL),
487 (24, 1, 4, 'id', 'id', NULL),
488 (25, 1, 4, 'sid', 'sid', NULL),
489 (26, 1, 4, 'password', 'pw', NULL),
490 (27, 1, 4, 'reload', 'reload', NULL),
491 (28, 1, 4, 'reward', 'verguetung', NULL),
492 (29, 1, 4, 'min_stay', 'ma', NULL),
493 (30, 1, 4, 'remain', 'uebrig', NULL),
494 (31, 1, 4, 'size', 'size', NULL),
495 (32, 1, 5, 'id', 'id', NULL),
496 (33, 1, 5, 'sid', 'sid', NULL),
497 (34, 1, 5, 'password', 'pw', NULL),
498 (35, 1, 5, 'reload', 'reload', NULL),
499 (36, 1, 5, 'reward', 'verguetung', NULL),
500 (37, 1, 5, 'min_stay', 'ma', NULL),
501 (38, 1, 5, 'type', 'typ', 'text'),
502 (39, 1, 5, 'remain', 'uebrig', NULL),
503 (40, 1, 11, 'id', 'id', NULL),
504 (41, 1, 11, 'sid', 'sid', NULL),
505 (42, 1, 11, 'password', 'pw', NULL),
506 (43, 1, 11, 'reload', 'reload', NULL),
507 (44, 1, 11, 'reward', 'verguetung', NULL),
508 (45, 1, 11, 'min_stay', 'ma', NULL),
509 (46, 1, 11, 'type', 'typ', 'html'),
510 (47, 1, 11, 'remain', 'uebrig', NULL),
511 (48, 1, 6, 'id', 'id', NULL),
512 (49, 1, 6, 'sid', 'sid', NULL),
513 (50, 1, 6, 'password', 'pw', NULL),
514 (51, 1, 6, 'reload', 'reload', NULL),
515 (52, 1, 6, 'reward', 'verguetung', NULL),
516 (53, 1, 6, 'type', 'typ', NULL),
517 (54, 1, 6, 'remain', 'uebrig', NULL),
518 (55, 1, 7, 'id', 'id', NULL),
519 (56, 1, 7, 'sid', 'sid', NULL),
520 (57, 1, 7, 'password', 'pw', NULL),
521 (58, 1, 7, 'reload', 'reload', NULL),
522 (59, 1, 7, 'reward', 'verguetung', NULL),
523 (60, 1, 7, 'min_stay', 'ma', NULL),
524 (61, 1, 7, 'remain', 'uebrig', NULL),
525 (62, 1, 8, 'id', 'id', NULL),
526 (63, 1, 8, 'sid', 'sid', NULL),
527 (64, 1, 8, 'password', 'pw', NULL),
528 (65, 1, 8, 'reload', 'reload', NULL),
529 (66, 1, 8, 'reward', 'verguetung', NULL),
530 (67, 1, 8, 'min_stay', 'ma', NULL),
531 (68, 1, 8, 'remain', 'uebrig', NULL),
532 (69, 1, 9, 'id', 'id', NULL),
533 (70, 1, 9, 'sid', 'sid', NULL),
534 (71, 1, 9, 'password', 'pw', NULL),
535 (72, 1, 9, 'reward', 'verguetung', NULL),
536 (73, 1, 9, 'remain', 'uebrig', NULL),
537 (74, 1, 10, 'id', 'id', NULL),
538 (75, 1, 10, 'sid', 'sid', NULL),
539 (76, 1, 10, 'password', 'pw', NULL),
540 (77, 1, 10, 'reward', 'verguetung', NULL),
541 (78, 1, 10, 'remain', 'uebrig', NULL)");
543 // Request parameters per type handler - AbisZED-Netz
545 // Request parameters per type handler - Ad-Magnet
547 // Request parameters per type handler - AdCocktail
549 // Request parameters per type handler - Ads4
550 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
551 (79, 5, 14, 'id', 'id', NULL),
552 (80, 5, 14, 'password', 'pwd', NULL),
553 (81, 5, 14, 'currency', 'waehrung', NULL),
554 (82, 5, 14, 'extra', 'mediatype', 'forced_banner'),
555 (83, 5, 14, 'reward', 'verg', NULL),
556 (84, 5, 14, 'reload', 'reload', NULL),
557 (85, 5, 14, 'remain', 'uebrig', NULL),
558 (86, 5, 14, 'min_stay', 'ma', NULL),
559 (87, 5, 15, 'id', 'id', NULL),
560 (88, 5, 15, 'password', 'pwd', NULL),
561 (89, 5, 15, 'currency', 'waehrung', NULL),
562 (90, 5, 15, 'extra', 'mediatype', 'textmails'),
563 (91, 5, 15, 'reward', 'verg', NULL),
564 (92, 5, 15, 'reload', 'reload', NULL),
565 (93, 5, 15, 'remain', 'uebrig', NULL),
566 (94, 5, 15, 'min_stay', 'ma', NULL),
567 (95, 5, 16, 'id', 'id', NULL),
568 (96, 5, 16, 'password', 'pw', NULL),
569 (97, 5, 16, 'currency', 'waehrung', NULL),
570 (98, 5, 16, 'extra', 'mediatype', 'htmlmails'),
571 (99, 5, 16, 'reward', 'verg', NULL),
572 (100, 5, 16, 'reload', 'reload', NULL),
573 (101, 5, 16, 'remain', 'uebrig', NULL),
574 (102, 5, 16, 'min_stay', 'ma', NULL),
575 (789, 5, 119, 'id', 'id', NULL),
576 (790, 5, 119, 'password', 'pwd', NULL),
577 (791, 5, 119, 'currency', 'waehrung', NULL),
578 (792, 5, 119, 'extra', 'mediatype', 'traffic'),
579 (793, 5, 119, 'reward', 'verg', NULL),
580 (794, 5, 119, 'reload', 'reload', NULL),
581 (795, 5, 119, 'remain', 'uebrig', NULL),
582 (796, 5, 119, 'min_stay', 'ma', NULL)");
584 // Request parameters per type handler - Ads4Webbis
585 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
586 (103, 6, 20, 'extra', 'typ', 'bannerklick'),
587 (104, 6, 20, 'id', 'id', NULL),
588 (105, 6, 20, 'password', 'pw', NULL),
589 (106, 6, 20, 'remain', 'uebrig', NULL),
590 (107, 6, 20, 'reload', 'reload', NULL),
591 (108, 6, 20, 'reward', 'verguetung', NULL),
592 (109, 6, 17, 'extra', 'typ', 'forcedbanner'),
593 (110, 6, 17, 'id', 'id', NULL),
594 (111, 6, 17, 'password', 'pw', NULL),
595 (112, 6, 17, 'remain', 'uebrig', NULL),
596 (113, 6, 17, 'reload', 'reload', NULL),
597 (114, 6, 17, 'reward', 'verguetung', NULL),
598 (115, 6, 18, 'extra', 'typ', 'forcedtextlink'),
599 (116, 6, 18, 'id', 'id', NULL),
600 (117, 6, 18, 'password', 'pw', NULL),
601 (118, 6, 18, 'remain', 'uebrig', NULL),
602 (119, 6, 18, 'reload', 'reload', NULL),
603 (120, 6, 18, 'reward', 'verguetung', NULL),
604 (121, 6, 19, 'extra', 'typ', 'bannerview'),
605 (122, 6, 19, 'id', 'id', NULL),
606 (123, 6, 19, 'password', 'pw', NULL),
607 (124, 6, 19, 'remain', 'uebrig', NULL),
608 (125, 6, 19, 'reload', 'reload', NULL),
609 (126, 6, 19, 'reward', 'verguetung', NULL),
610 (127, 6, 21, 'extra', 'typ', 'skybannerview'),
611 (128, 6, 21, 'id', 'id', NULL),
612 (129, 6, 21, 'password', 'pw', NULL),
613 (130, 6, 21, 'remain', 'uebrig', NULL),
614 (131, 6, 21, 'reload', 'reload', NULL),
615 (132, 6, 21, 'reward', 'verguetung', NULL),
616 (133, 6, 22, 'extra', 'typ', 'buttonview'),
617 (134, 6, 22, 'id', 'id', NULL),
618 (135, 6, 22, 'password', 'pw', NULL),
619 (136, 6, 22, 'remain', 'uebrig', NULL),
620 (137, 6, 22, 'reload', 'reload', NULL),
621 (138, 6, 22, 'reward', 'verguetung', NULL),
622 (139, 6, 23, 'extra', 'typ', 'textview'),
623 (140, 6, 23, 'id', 'id', NULL),
624 (141, 6, 23, 'password', 'pw', NULL),
625 (142, 6, 23, 'remain', 'uebrig', NULL),
626 (143, 6, 23, 'reload', 'reload', NULL),
627 (144, 6, 23, 'reward', 'verguetung', NULL),
628 (145, 6, 24, 'extra', 'typ', 'popup'),
629 (146, 6, 24, 'id', 'id', NULL),
630 (147, 6, 24, 'password', 'pw', NULL),
631 (148, 6, 24, 'remain', 'uebrig', NULL),
632 (149, 6, 24, 'reload', 'reload', NULL),
633 (150, 6, 24, 'reward', 'verguetung', NULL),
634 (151, 6, 24, 'min_stay', 'ma', NULL),
635 (152, 6, 25, 'extra', 'typ', 'paidmail'),
636 (153, 6, 25, 'id', 'id', NULL),
637 (154, 6, 25, 'password', 'pw', NULL),
638 (155, 6, 25, 'remain', 'uebrig', NULL),
639 (156, 6, 25, 'reload', 'reload', NULL),
640 (157, 6, 25, 'reward', 'verguetung', NULL),
641 (158, 6, 25, 'min_stay', 'ma', NULL),
642 (797, 6, 120, 'extra', 'typ', 'traffic'),
643 (798, 6, 120, 'id', 'id', NULL),
644 (799, 6, 120, 'password', 'pw', NULL),
645 (800, 6, 120, 'remain', 'uebrig', NULL),
646 (801, 6, 120, 'reload', 'reload', NULL),
647 (802, 6, 120, 'reward', 'verguetung', NULL)");
649 // Request parameters per type handler - Ads4World
650 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
651 (159, 7, 29, 'extra', 'typ', 'bannerklick'),
652 (160, 7, 29, 'id', 'id', NULL),
653 (161, 7, 29, 'password', 'pw', NULL),
654 (162, 7, 29, 'remain', 'uebrig', NULL),
655 (163, 7, 29, 'reload', 'reload', NULL),
656 (164, 7, 29, 'reward', 'verguetung', NULL),
657 (165, 7, 28, 'extra', 'typ', 'bannerview'),
658 (166, 7, 28, 'id', 'id', NULL),
659 (167, 7, 28, 'password', 'pw', NULL),
660 (168, 7, 28, 'remain', 'uebrig', NULL),
661 (169, 7, 28, 'reload', 'reload', NULL),
662 (170, 7, 28, 'reward', 'verguetung', NULL),
663 (171, 7, 31, 'extra', 'typ', 'buttonview'),
664 (172, 7, 31, 'id', 'id', NULL),
665 (173, 7, 31, 'password', 'pw', NULL),
666 (174, 7, 31, 'remain', 'uebrig', NULL),
667 (175, 7, 31, 'reload', 'reload', NULL),
668 (176, 7, 31, 'reward', 'verguetung', NULL),
669 (177, 7, 26, 'extra', 'typ', 'forcedbanner'),
670 (178, 7, 26, 'id', 'id', NULL),
671 (179, 7, 26, 'password', 'pw', NULL),
672 (180, 7, 26, 'remain', 'uebrig', NULL),
673 (181, 7, 26, 'reload', 'reload', NULL),
674 (182, 7, 26, 'reward', 'verguetung', NULL),
675 (183, 7, 27, 'extra', 'typ', 'forcedtextlink'),
676 (184, 7, 27, 'id', 'id', NULL),
677 (185, 7, 27, 'password', 'pw', NULL),
678 (186, 7, 27, 'remain', 'uebrig', NULL),
679 (187, 7, 27, 'reload', 'reload', NULL),
680 (188, 7, 27, 'reward', 'verguetung', NULL),
681 (189, 7, 33, 'extra', 'typ', 'popup'),
682 (190, 7, 33, 'id', 'id', NULL),
683 (191, 7, 33, 'password', 'pw', NULL),
684 (192, 7, 33, 'remain', 'uebrig', NULL),
685 (193, 7, 33, 'reload', 'reload', NULL),
686 (194, 7, 33, 'reward', 'verguetung', NULL),
687 (195, 7, 33, 'min_stay', 'ma', NULL),
688 (196, 7, 30, 'extra', 'typ', 'skybannerview'),
689 (197, 7, 30, 'id', 'id', NULL),
690 (198, 7, 30, 'password', 'pw', NULL),
691 (199, 7, 30, 'remain', 'uebrig', NULL),
692 (200, 7, 30, 'reload', 'reload', NULL),
693 (201, 7, 30, 'reward', 'verguetung', NULL),
694 (202, 7, 32, 'extra', 'typ', 'textview'),
695 (203, 7, 32, 'id', 'id', NULL),
696 (204, 7, 32, 'password', 'pw', NULL),
697 (205, 7, 32, 'remain', 'uebrig', NULL),
698 (206, 7, 32, 'reload', 'reload', NULL),
699 (207, 7, 32, 'reward', 'verguetung', NULL),
700 (208, 7, 34, 'extra', 'typ', 'textmails'),
701 (209, 7, 34, 'id', 'id', NULL),
702 (210, 7, 34, 'password', 'pw', NULL),
703 (211, 7, 34, 'remain', 'uebrig', NULL),
704 (212, 7, 34, 'reload', 'reload', NULL),
705 (213, 7, 34, 'reward', 'verguetung', NULL),
706 (214, 7, 34, 'min_stay', 'ma', NULL),
707 (803, 7, 121, 'extra', 'typ', 'traffic'),
708 (804, 7, 121, 'id', 'id', NULL),
709 (805, 7, 121, 'password', 'pw', NULL),
710 (806, 7, 121, 'remain', 'uebrig', NULL),
711 (807, 7, 121, 'reload', 'reload', NULL),
712 (808, 7, 121, 'reward', 'verguetung', NULL)");
714 // Request parameters per type handler - Affiliblatt
716 // Request parameters per type handler - Alster-Marketing
717 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
718 (215, 9, 35, 'id', 'id', NULL),
719 (216, 9, 35, 'sid', 'sid', NULL),
720 (217, 9, 35, 'password', 'pw', NULL),
721 (218, 9, 35, 'reward', 'verguetung', NULL),
722 (219, 9, 35, 'reload', 'reload', NULL),
723 (220, 9, 35, 'remain', 'uebrig', NULL),
724 (221, 9, 35, 'type', 'typ', 'klick'),
725 (222, 9, 35, 'size', 'size', NULL),
726 (223, 9, 45, 'id', 'id', NULL),
727 (224, 9, 45, 'sid', 'sid', NULL),
728 (225, 9, 45, 'password', 'pw', NULL),
729 (226, 9, 45, 'reward', 'verguetung', NULL),
730 (227, 9, 45, 'reload', 'reload', NULL),
731 (228, 9, 45, 'remain', 'uebrig', NULL),
732 (229, 9, 45, 'type', 'typ', 'view'),
733 (230, 9, 45, 'size', 'size', NULL),
734 (231, 9, 36, 'id', 'id', NULL),
735 (232, 9, 36, 'sid', 'sid', NULL),
736 (233, 9, 36, 'password', 'pw', NULL),
737 (234, 9, 36, 'reward', 'verguetung', NULL),
738 (235, 9, 36, 'reload', 'reload', NULL),
739 (236, 9, 36, 'remain', 'uebrig', NULL),
740 (237, 9, 36, 'type', 'typ', 'klick'),
741 (238, 9, 46, 'id', 'id', NULL),
742 (239, 9, 46, 'sid', 'sid', NULL),
743 (240, 9, 46, 'password', 'pw', NULL),
744 (241, 9, 46, 'reward', 'verguetung', NULL),
745 (242, 9, 46, 'reload', 'reload', NULL),
746 (243, 9, 46, 'remain', 'uebrig', NULL),
747 (244, 9, 46, 'type', 'typ', 'view'),
748 (245, 9, 37, 'id', 'id', NULL),
749 (246, 9, 37, 'sid', 'sid', NULL),
750 (247, 9, 37, 'password', 'pw', NULL),
751 (248, 9, 37, 'reward', 'verguetung', NULL),
752 (249, 9, 37, 'reload', 'reload', NULL),
753 (250, 9, 37, 'remain', 'uebrig', NULL),
754 (251, 9, 37, 'type', 'typ', 'klick'),
755 (252, 9, 37, 'size', 'size', NULL),
756 (253, 9, 47, 'id', 'id', NULL),
757 (254, 9, 47, 'sid', 'sid', NULL),
758 (255, 9, 47, 'password', 'pw', NULL),
759 (256, 9, 47, 'reward', 'verguetung', NULL),
760 (257, 9, 47, 'reload', 'reload', NULL),
761 (258, 9, 47, 'remain', 'uebrig', NULL),
762 (259, 9, 47, 'type', 'typ', 'view'),
763 (260, 9, 47, 'size', 'size', NULL),
764 (261, 9, 38, 'id', 'id', NULL),
765 (262, 9, 38, 'sid', 'sid', NULL),
766 (263, 9, 38, 'password', 'pw', NULL),
767 (264, 9, 38, 'reward', 'verguetung', NULL),
768 (265, 9, 38, 'reload', 'reload', NULL),
769 (266, 9, 38, 'remain', 'uebrig', NULL),
770 (267, 9, 38, 'size', 'size', NULL),
771 (268, 9, 38, 'min_stay', 'ma', NULL),
772 (269, 9, 39, 'id', 'id', NULL),
773 (270, 9, 39, 'sid', 'sid', NULL),
774 (271, 9, 39, 'password', 'pw', NULL),
775 (272, 9, 39, 'reward', 'verguetung', NULL),
776 (273, 9, 39, 'reload', 'reload', NULL),
777 (274, 9, 39, 'remain', 'uebrig', NULL),
778 (275, 9, 39, 'min_stay', 'ma', NULL),
779 (276, 9, 39, 'type', 'typ', 'text'),
780 (277, 9, 48, 'id', 'id', NULL),
781 (278, 9, 48, 'sid', 'sid', NULL),
782 (279, 9, 48, 'password', 'pw', NULL),
783 (280, 9, 48, 'reward', 'verguetung', NULL),
784 (281, 9, 48, 'reload', 'reload', NULL),
785 (282, 9, 48, 'remain', 'uebrig', NULL),
786 (283, 9, 48, 'min_stay', 'ma', NULL),
787 (284, 9, 48, 'type', 'typ', 'html'),
788 (285, 9, 40, 'id', 'id', NULL),
789 (286, 9, 40, 'sid', 'sid', NULL),
790 (287, 9, 40, 'password', 'pw', NULL),
791 (288, 9, 40, 'reward', 'verguetung', NULL),
792 (289, 9, 40, 'reload', 'reload', NULL),
793 (290, 9, 40, 'remain', 'uebrig', NULL),
794 (291, 9, 40, 'type', 'typ', 'klick'),
795 (292, 9, 49, 'id', 'id', NULL),
796 (293, 9, 49, 'sid', 'sid', NULL),
797 (294, 9, 49, 'password', 'pw', NULL),
798 (295, 9, 49, 'reward', 'verguetung', NULL),
799 (296, 9, 49, 'reload', 'reload', NULL),
800 (297, 9, 49, 'remain', 'uebrig', NULL),
801 (298, 9, 49, 'type', 'typ', 'view'),
802 (299, 9, 41, 'id', 'id', NULL),
803 (300, 9, 41, 'sid', 'sid', NULL),
804 (301, 9, 41, 'password', 'pw', NULL),
805 (302, 9, 41, 'reward', 'verguetung', NULL),
806 (303, 9, 41, 'reload', 'reload', NULL),
807 (304, 9, 41, 'remain', 'uebrig', NULL),
808 (305, 9, 41, 'min_stay', 'ma', NULL),
809 (306, 9, 42, 'id', 'id', NULL),
810 (307, 9, 42, 'sid', 'sid', NULL),
811 (308, 9, 42, 'password', 'pw', NULL),
812 (309, 9, 42, 'reward', 'verguetung', NULL),
813 (310, 9, 42, 'reload', 'reload', NULL),
814 (311, 9, 42, 'remain', 'uebrig', NULL),
815 (312, 9, 42, 'min_stay', 'ma', NULL),
816 (313, 9, 43, 'id', 'id', NULL),
817 (314, 9, 43, 'sid', 'sid', NULL),
818 (315, 9, 43, 'password', 'pw', NULL),
819 (316, 9, 43, 'reward', 'verguetung', NULL),
820 (317, 9, 43, 'remain', 'uebrig', NULL),
821 (318, 9, 44, 'id', 'id', NULL),
822 (319, 9, 44, 'sid', 'sid', NULL),
823 (320, 9, 44, 'password', 'pw', NULL),
824 (321, 9, 44, 'reward', 'verguetung', NULL),
825 (322, 9, 44, 'remain', 'uebrig', NULL)");
827 // Request parameters per type handler - BonusSponsor
828 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
829 (323, 10, 50, 'id', 'id', NULL),
830 (324, 10, 50, 'sid', 'sid', NULL),
831 (325, 10, 50, 'password', 'pw', NULL),
832 (326, 10, 50, 'reward', 'verguetung', NULL),
833 (327, 10, 50, 'reload', 'reload', NULL),
834 (328, 10, 50, 'remain', 'uebrig', NULL),
835 (329, 10, 50, 'type', 'typ', 'klick'),
836 (330, 10, 50, 'size', 'size', NULL),
837 (331, 10, 51, 'id', 'id', NULL),
838 (332, 10, 51, 'sid', 'sid', NULL),
839 (333, 10, 51, 'password', 'pw', NULL),
840 (334, 10, 51, 'reward', 'verguetung', NULL),
841 (335, 10, 51, 'reload', 'reload', NULL),
842 (336, 10, 51, 'remain', 'uebrig', NULL),
843 (337, 10, 51, 'type', 'typ', 'view'),
844 (338, 10, 51, 'size', 'size', NULL),
845 (339, 10, 52, 'id', 'id', NULL),
846 (340, 10, 52, 'sid', 'sid', NULL),
847 (341, 10, 52, 'password', 'pw', NULL),
848 (342, 10, 52, 'reward', 'verguetung', NULL),
849 (343, 10, 52, 'reload', 'reload', NULL),
850 (344, 10, 52, 'remain', 'uebrig', NULL),
851 (345, 10, 52, 'type', 'typ', 'klick'),
852 (346, 10, 53, 'id', 'id', NULL),
853 (347, 10, 53, 'sid', 'sid', NULL),
854 (348, 10, 53, 'password', 'pw', NULL),
855 (349, 10, 53, 'reward', 'verguetung', NULL),
856 (350, 10, 53, 'reload', 'reload', NULL),
857 (351, 10, 53, 'remain', 'uebrig', NULL),
858 (352, 10, 53, 'type', 'typ', 'view'),
859 (353, 10, 54, 'id', 'id', NULL),
860 (354, 10, 54, 'sid', 'sid', NULL),
861 (355, 10, 54, 'password', 'pw', NULL),
862 (356, 10, 54, 'reward', 'verguetung', NULL),
863 (357, 10, 54, 'reload', 'reload', NULL),
864 (358, 10, 54, 'remain', 'uebrig', NULL),
865 (359, 10, 54, 'size', 'size', NULL),
866 (360, 10, 54, 'min_stay', 'ma', NULL),
867 (361, 10, 55, 'id', 'id', NULL),
868 (362, 10, 55, 'sid', 'sid', NULL),
869 (363, 10, 55, 'password', 'pw', NULL),
870 (364, 10, 55, 'reward', 'verguetung', NULL),
871 (365, 10, 55, 'reload', 'reload', NULL),
872 (366, 10, 55, 'remain', 'uebrig', NULL),
873 (367, 10, 55, 'min_stay', 'ma', NULL),
874 (368, 10, 55, 'type', 'typ', 'text'),
875 (369, 10, 56, 'id', 'id', NULL),
876 (370, 10, 56, 'sid', 'sid', NULL),
877 (371, 10, 56, 'password', 'pw', NULL),
878 (372, 10, 56, 'reward', 'verguetung', NULL),
879 (373, 10, 56, 'reload', 'reload', NULL),
880 (374, 10, 56, 'remain', 'uebrig', NULL),
881 (375, 10, 56, 'min_stay', 'ma', NULL),
882 (376, 10, 56, 'type', 'typ', 'html'),
883 (377, 10, 57, 'id', 'id', NULL),
884 (378, 10, 57, 'sid', 'sid', NULL),
885 (379, 10, 57, 'password', 'pw', NULL),
886 (380, 10, 57, 'reward', 'verguetung', NULL),
887 (381, 10, 57, 'reload', 'reload', NULL),
888 (382, 10, 57, 'remain', 'uebrig', NULL),
889 (383, 10, 57, 'type', 'typ', 'klick'),
890 (384, 10, 58, 'id', 'id', NULL),
891 (385, 10, 58, 'sid', 'sid', NULL),
892 (386, 10, 58, 'password', 'pw', NULL),
893 (387, 10, 58, 'reward', 'verguetung', NULL),
894 (388, 10, 58, 'reload', 'reload', NULL),
895 (389, 10, 58, 'remain', 'uebrig', NULL),
896 (390, 10, 58, 'type', 'typ', 'view'),
897 (391, 10, 59, 'id', 'id', NULL),
898 (392, 10, 59, 'sid', 'sid', NULL),
899 (393, 10, 59, 'password', 'pw', NULL),
900 (394, 10, 59, 'reward', 'verguetung', NULL),
901 (395, 10, 59, 'reload', 'reload', NULL),
902 (396, 10, 59, 'remain', 'uebrig', NULL),
903 (397, 10, 59, 'min_stay', 'ma', NULL),
904 (398, 10, 60, 'id', 'id', NULL),
905 (399, 10, 60, 'sid', 'sid', NULL),
906 (400, 10, 60, 'password', 'pw', NULL),
907 (401, 10, 60, 'reward', 'verguetung', NULL),
908 (402, 10, 60, 'reload', 'reload', NULL),
909 (403, 10, 60, 'remain', 'uebrig', NULL),
910 (404, 10, 60, 'min_stay', 'ma', NULL),
911 (405, 10, 61, 'id', 'id', NULL),
912 (406, 10, 61, 'sid', 'sid', NULL),
913 (407, 10, 61, 'password', 'pw', NULL),
914 (408, 10, 61, 'reward', 'verguetung', NULL),
915 (409, 10, 61, 'remain', 'uebrig', NULL),
916 (410, 10, 62, 'id', 'id', NULL),
917 (411, 10, 62, 'sid', 'sid', NULL),
918 (412, 10, 62, 'password', 'pw', NULL),
919 (413, 10, 62, 'reward', 'verguetung', NULL),
920 (414, 10, 62, 'remain', 'uebrig', NULL)");
922 // Request parameters per type handler - Fusion-Ads
924 // Request parameters per type handler - GigapPromo
925 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
926 (687, 12, 102, 'id', 'id', NULL),
927 (688, 12, 102, 'sid', 'aid', NULL),
928 (689, 12, 102, 'password', 'pw', NULL),
929 (690, 12, 102, 'reload', 'reload', NULL),
930 (691, 12, 102, 'reward', 'verguetung', NULL),
931 (692, 12, 102, 'remain', 'uebrig', NULL),
932 (693, 12, 102, 'size', 'typ', NULL),
933 (694, 12, 103, 'id', 'id', NULL),
934 (695, 12, 103, 'sid', 'aid', NULL),
935 (696, 12, 103, 'password', 'pw', NULL),
936 (697, 12, 103, 'reload', 'reload', NULL),
937 (698, 12, 103, 'reward', 'verguetung', NULL),
938 (699, 12, 103, 'remain', 'uebrig', NULL),
939 (700, 12, 104, 'id', 'id', NULL),
940 (701, 12, 104, 'sid', 'aid', NULL),
941 (702, 12, 104, 'password', 'pw', NULL),
942 (703, 12, 104, 'reload', 'reload', NULL),
943 (704, 12, 104, 'reward', 'verguetung', NULL),
944 (705, 12, 104, 'remain', 'uebrig', NULL),
945 (706, 12, 104, 'max_stay', 'ma', NULL),
946 (707, 12, 105, 'id', 'id', NULL),
947 (708, 12, 105, 'sid', 'aid', NULL),
948 (709, 12, 105, 'password', 'pw', NULL),
949 (710, 12, 105, 'reload', 'reload', NULL),
950 (711, 12, 105, 'reward', 'verguetung', NULL),
951 (712, 12, 105, 'remain', 'uebrig', NULL),
952 (713, 12, 105, 'max_stay', 'ma', NULL),
953 (714, 12, 106, 'id', 'id', NULL),
954 (715, 12, 106, 'sid', 'aid', NULL),
955 (716, 12, 106, 'password', 'pw', NULL),
956 (717, 12, 106, 'reload', 'reload', NULL),
957 (718, 12, 106, 'reward', 'verguetung', NULL),
958 (719, 12, 106, 'remain', 'uebrig', NULL),
959 (720, 12, 106, 'max_stay', 'ma', NULL),
960 (721, 12, 107, 'id', 'id', NULL),
961 (722, 12, 107, 'sid', 'aid', NULL),
962 (723, 12, 107, 'password', 'pw', NULL),
963 (724, 12, 107, 'reload', 'reload', NULL),
964 (725, 12, 107, 'reward', 'verguetung', NULL),
965 (726, 12, 107, 'remain', 'uebrig', NULL),
966 (727, 12, 107, 'max_stay', 'ma', NULL),
967 (728, 12, 108, 'id', 'id', NULL),
968 (729, 12, 108, 'sid', 'aid', NULL),
969 (730, 12, 108, 'password', 'pw', NULL),
970 (731, 12, 108, 'reload', 'reload', NULL),
971 (732, 12, 108, 'reward', 'verguetung', NULL),
972 (733, 12, 108, 'remain', 'uebrig', NULL),
973 (734, 12, 108, 'max_stay', 'ma', NULL)");
975 // Request parameters per type handler - HPSponsor
976 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
977 (889, 13, 135, 'extra', 'typ', 'forcedbanner'),
978 (890, 13, 135, 'id', 'id', NULL),
979 (891, 13, 135, 'password', 'pw', NULL),
980 (892, 13, 135, 'remain', 'uebrig', NULL),
981 (893, 13, 135, 'reload', 'reload', NULL),
982 (894, 13, 135, 'reward', 'verguetung', NULL),
983 (895, 13, 136, 'extra', 'typ', 'forcedtextlink'),
984 (896, 13, 136, 'id', 'id', NULL),
985 (897, 13, 136, 'password', 'pw', NULL),
986 (898, 13, 136, 'remain', 'uebrig', NULL),
987 (899, 13, 136, 'reload', 'reload', NULL),
988 (900, 13, 136, 'reward', 'verguetung', NULL),
989 (901, 13, 137, 'extra', 'typ', 'bannerview'),
990 (902, 13, 137, 'id', 'id', NULL),
991 (903, 13, 137, 'password', 'pw', NULL),
992 (904, 13, 137, 'remain', 'uebrig', NULL),
993 (905, 13, 137, 'reload', 'reload', NULL),
994 (906, 13, 137, 'reward', 'verguetung', NULL),
995 (907, 13, 138, 'extra', 'typ', 'bannerklick'),
996 (908, 13, 138, 'id', 'id', NULL),
997 (909, 13, 138, 'password', 'pw', NULL),
998 (910, 13, 138, 'remain', 'uebrig', NULL),
999 (911, 13, 138, 'reload', 'reload', NULL),
1000 (912, 13, 138, 'reward', 'verguetung', NULL),
1001 (913, 13, 139, 'extra', 'typ', 'skybannerview'),
1002 (914, 13, 139, 'id', 'id', NULL),
1003 (915, 13, 139, 'password', 'pw', NULL),
1004 (916, 13, 139, 'remain', 'uebrig', NULL),
1005 (917, 13, 139, 'reload', 'reload', NULL),
1006 (918, 13, 139, 'reward', 'verguetung', NULL),
1007 (919, 13, 140, 'extra', 'typ', 'buttonview'),
1008 (920, 13, 140, 'id', 'id', NULL),
1009 (921, 13, 140, 'password', 'pw', NULL),
1010 (922, 13, 140, 'remain', 'uebrig', NULL),
1011 (923, 13, 140, 'reload', 'reload', NULL),
1012 (924, 13, 140, 'reward', 'verguetung', NULL),
1013 (925, 13, 141, 'extra', 'typ', 'textview'),
1014 (926, 13, 141, 'id', 'id', NULL),
1015 (927, 13, 141, 'password', 'pw', NULL),
1016 (928, 13, 141, 'remain', 'uebrig', NULL),
1017 (929, 13, 141, 'reload', 'reload', NULL),
1018 (930, 13, 141, 'reward', 'verguetung', NULL),
1019 (931, 13, 142, 'extra', 'typ', 'traffic'),
1020 (932, 13, 142, 'id', 'id', NULL),
1021 (933, 13, 142, 'password', 'pw', NULL),
1022 (934, 13, 142, 'remain', 'uebrig', NULL),
1023 (935, 13, 142, 'reload', 'reload', NULL),
1024 (936, 13, 142, 'reward', 'verguetung', NULL),
1025 (937, 13, 143, 'extra', 'typ', 'popup'),
1026 (938, 13, 143, 'id', 'id', NULL),
1027 (939, 13, 143, 'password', 'pw', NULL),
1028 (940, 13, 143, 'remain', 'uebrig', NULL),
1029 (941, 13, 143, 'reload', 'reload', NULL),
1030 (942, 13, 143, 'reward', 'verguetung', NULL),
1031 (943, 13, 143, 'min_stay', 'ma', NULL),
1032 (944, 13, 144, 'extra', 'typ', 'paidmail'),
1033 (945, 13, 144, 'id', 'id', NULL),
1034 (946, 13, 144, 'password', 'pw', NULL),
1035 (947, 13, 144, 'remain', 'uebrig', NULL),
1036 (948, 13, 144, 'reload', 'reload', NULL),
1037 (949, 13, 144, 'reward', 'verguetung', NULL),
1038 (950, 13, 144, 'min_stay', 'ma', NULL)");
1040 // Request parameters per type handler - Make-Euros
1041 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
1042 (415, 14, 63, 'id', 'id', NULL),
1043 (416, 14, 63, 'sid', 'sid', NULL),
1044 (417, 14, 63, 'password', 'pw', NULL),
1045 (418, 14, 63, 'reward', 'verguetung', NULL),
1046 (419, 14, 63, 'reload', 'reload', NULL),
1047 (420, 14, 63, 'remain', 'uebrig', NULL),
1048 (421, 14, 63, 'type', 'typ', 'klick'),
1049 (422, 14, 63, 'size', 'size', NULL),
1050 (423, 14, 64, 'id', 'id', NULL),
1051 (424, 14, 64, 'sid', 'sid', NULL),
1052 (425, 14, 64, 'password', 'pw', NULL),
1053 (426, 14, 64, 'reward', 'verguetung', NULL),
1054 (427, 14, 64, 'reload', 'reload', NULL),
1055 (428, 14, 64, 'remain', 'uebrig', NULL),
1056 (429, 14, 64, 'type', 'typ', 'view'),
1057 (430, 14, 64, 'size', 'size', NULL),
1058 (431, 14, 65, 'id', 'id', NULL),
1059 (432, 14, 65, 'sid', 'sid', NULL),
1060 (433, 14, 65, 'password', 'pw', NULL),
1061 (434, 14, 65, 'reward', 'verguetung', NULL),
1062 (435, 14, 65, 'reload', 'reload', NULL),
1063 (436, 14, 65, 'remain', 'uebrig', NULL),
1064 (437, 14, 65, 'type', 'typ', 'klick'),
1065 (438, 14, 66, 'id', 'id', NULL),
1066 (439, 14, 66, 'sid', 'sid', NULL),
1067 (440, 14, 66, 'password', 'pw', NULL),
1068 (441, 14, 66, 'reward', 'verguetung', NULL),
1069 (442, 14, 66, 'reload', 'reload', NULL),
1070 (443, 14, 66, 'remain', 'uebrig', NULL),
1071 (444, 14, 66, 'type', 'typ', 'view'),
1072 (445, 14, 67, 'id', 'id', NULL),
1073 (446, 14, 67, 'sid', 'sid', NULL),
1074 (447, 14, 67, 'password', 'pw', NULL),
1075 (448, 14, 67, 'reward', 'verguetung', NULL),
1076 (449, 14, 67, 'reload', 'reload', NULL),
1077 (450, 14, 67, 'remain', 'uebrig', NULL),
1078 (451, 14, 67, 'typ', 'typ', 'klick'),
1079 (452, 14, 67, 'size', 'size', NULL),
1080 (453, 14, 69, 'id', 'id', NULL),
1081 (454, 14, 69, 'sid', 'sid', NULL),
1082 (455, 14, 69, 'password', 'pw', NULL),
1083 (456, 14, 69, 'reward', 'verguetung', NULL),
1084 (457, 14, 69, 'reload', 'reload', NULL),
1085 (458, 14, 69, 'remain', 'uebrig', NULL),
1086 (459, 14, 69, 'type', 'typ', 'view'),
1087 (460, 14, 69, 'size', 'size', NULL),
1088 (461, 14, 68, 'id', 'id', NULL),
1089 (462, 14, 68, 'sid', 'sid', NULL),
1090 (463, 14, 68, 'password', 'pw', NULL),
1091 (464, 14, 68, 'reward', 'verguetung', NULL),
1092 (465, 14, 68, 'reload', 'reload', NULL),
1093 (466, 14, 68, 'remain', 'uebrig', NULL),
1094 (467, 14, 68, 'size', 'size', NULL),
1095 (468, 14, 68, 'min_stay', 'ma', NULL),
1096 (469, 14, 70, 'id', 'id', NULL),
1097 (470, 14, 70, 'sid', 'sid', NULL),
1098 (471, 14, 70, 'password', 'pw', NULL),
1099 (472, 14, 70, 'reward', 'verguetung', NULL),
1100 (473, 14, 70, 'reload', 'reload', NULL),
1101 (474, 14, 70, 'remain', 'uebrig', NULL),
1102 (475, 14, 70, 'min_stay', 'ma', NULL),
1103 (476, 14, 70, 'type', 'typ', 'text'),
1104 (477, 14, 71, 'id', 'id', NULL),
1105 (478, 14, 71, 'sid', 'sid', NULL),
1106 (479, 14, 71, 'password', 'pw', NULL),
1107 (480, 14, 71, 'reward', 'verguetung', NULL),
1108 (481, 14, 71, 'reload', 'reload', NULL),
1109 (482, 14, 71, 'remain', 'uebrig', NULL),
1110 (483, 14, 71, 'min_stay', 'ma', NULL),
1111 (484, 14, 71, 'type', 'typ', 'html'),
1112 (485, 14, 72, 'id', 'id', NULL),
1113 (486, 14, 72, 'sid', 'sid', NULL),
1114 (487, 14, 72, 'password', 'pw', NULL),
1115 (488, 14, 72, 'reward', 'verguetung', NULL),
1116 (489, 14, 72, 'reload', 'reload', NULL),
1117 (490, 14, 72, 'remain', 'uebrig', NULL),
1118 (491, 14, 72, 'type', 'typ', 'klick'),
1119 (492, 14, 73, 'id', 'id', NULL),
1120 (493, 14, 73, 'sid', 'sid', NULL),
1121 (494, 14, 73, 'password', 'pw', NULL),
1122 (495, 14, 73, 'reward', 'verguetung', NULL),
1123 (496, 14, 73, 'reload', 'reload', NULL),
1124 (497, 14, 73, 'remain', 'uebrig', NULL),
1125 (498, 14, 73, 'type', 'typ', 'view'),
1126 (499, 14, 74, 'id', 'id', NULL),
1127 (500, 14, 74, 'sid', 'sid', NULL),
1128 (501, 14, 74, 'password', 'pw', NULL),
1129 (502, 14, 74, 'reward', 'verguetung', NULL),
1130 (503, 14, 74, 'reload', 'reload', NULL),
1131 (504, 14, 74, 'remain', 'uebrig', NULL),
1132 (505, 14, 74, 'min_stay', 'ma', NULL),
1133 (506, 14, 75, 'id', 'id', NULL),
1134 (507, 14, 75, 'sid', 'sid', NULL),
1135 (508, 14, 75, 'password', 'pw', NULL),
1136 (509, 14, 75, 'reward', 'verguetung', NULL),
1137 (510, 14, 75, 'reload', 'reload', NULL),
1138 (511, 14, 75, 'remain', 'uebrig', NULL),
1139 (512, 14, 75, 'min_stay', 'ma', NULL),
1140 (513, 14, 76, 'id', 'id', NULL),
1141 (514, 14, 76, 'sid', 'sid', NULL),
1142 (515, 14, 76, 'password', 'pw', NULL),
1143 (516, 14, 76, 'reward', 'verguetung', NULL),
1144 (517, 14, 76, 'remain', 'uebrig', NULL),
1145 (518, 14, 77, 'id', 'id', NULL),
1146 (519, 14, 77, 'sid', 'sid', NULL),
1147 (520, 14, 77, 'password', 'pw', NULL),
1148 (521, 14, 77, 'reward', 'verguetung', NULL),
1149 (522, 14, 77, 'remain', 'uebrig', NULL)");
1151 // Request parameters per type handler - Mega-Ad
1152 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
1153 (735, 15, 109, 'extra', 'typ', 'forcedbanner'),
1154 (736, 15, 109, 'id', 'id', NULL),
1155 (737, 15, 109, 'password', 'pw', NULL),
1156 (738, 15, 109, 'remain', 'uebrig', NULL),
1157 (739, 15, 109, 'reload', 'reload', NULL),
1158 (740, 15, 109, 'reward', 'verguetung', NULL),
1159 (741, 15, 110, 'extra', 'typ', 'forcedtextlink'),
1160 (742, 15, 110, 'id', 'id', NULL),
1161 (743, 15, 110, 'password', 'pw', NULL),
1162 (744, 15, 110, 'remain', 'uebrig', NULL),
1163 (745, 15, 110, 'reload', 'reload', NULL),
1164 (746, 15, 110, 'reward', 'verguetung', NULL),
1165 (747, 15, 111, 'extra', 'typ', 'bannerview'),
1166 (748, 15, 111, 'id', 'id', NULL),
1167 (749, 15, 111, 'password', 'pw', NULL),
1168 (750, 15, 111, 'remain', 'uebrig', NULL),
1169 (751, 15, 111, 'reload', 'reload', NULL),
1170 (752, 15, 111, 'reward', 'verguetung', NULL),
1171 (753, 15, 112, 'extra', 'typ', 'bannerklick'),
1172 (754, 15, 112, 'id', 'id', NULL),
1173 (755, 15, 112, 'password', 'pw', NULL),
1174 (756, 15, 112, 'remain', 'uebrig', NULL),
1175 (757, 15, 112, 'reload', 'reload', NULL),
1176 (758, 15, 112, 'reward', 'verguetung', NULL),
1177 (759, 15, 113, 'extra', 'typ', 'skybannerview'),
1178 (760, 15, 113, 'id', 'id', NULL),
1179 (761, 15, 113, 'password', 'pw', NULL),
1180 (762, 15, 113, 'remain', 'uebrig', NULL),
1181 (763, 15, 113, 'reload', 'reload', NULL),
1182 (764, 15, 113, 'reward', 'verguetung', NULL),
1183 (765, 15, 114, 'extra', 'typ', 'buttonview'),
1184 (766, 15, 114, 'id', 'id', NULL),
1185 (767, 15, 114, 'password', 'pw', NULL),
1186 (768, 15, 114, 'remain', 'uebrig', NULL),
1187 (769, 15, 114, 'reload', 'reload', NULL),
1188 (770, 15, 114, 'reward', 'verguetung', NULL),
1189 (771, 15, 115, 'extra', 'typ', 'textview'),
1190 (772, 15, 115, 'id', 'id', NULL),
1191 (773, 15, 115, 'password', 'pw', NULL),
1192 (774, 15, 115, 'remain', 'uebrig', NULL),
1193 (775, 15, 115, 'reload', 'reload', NULL),
1194 (776, 15, 115, 'reward', 'verguetung', NULL),
1195 (777, 15, 116, 'extra', 'typ', 'popup'),
1196 (778, 15, 116, 'id', 'id', NULL),
1197 (779, 15, 116, 'password', 'pw', NULL),
1198 (780, 15, 116, 'reload', 'reload', NULL),
1199 (781, 15, 116, 'remain', 'uebrig', NULL),
1200 (782, 15, 116, 'reward', 'verguetung', NULL),
1201 (783, 15, 117, 'extra', 'typ', 'paidmail'),
1202 (784, 15, 117, 'id', 'id', NULL),
1203 (785, 15, 117, 'password', 'pw', NULL),
1204 (786, 15, 117, 'reload', 'reload', NULL),
1205 (787, 15, 117, 'remain', 'uebrig', NULL),
1206 (788, 15, 117, 'reward', 'verguetung', NULL),
1207 (815, 15, 123, 'extra', 'typ', 'traffic'),
1208 (816, 15, 123, 'id', 'id', NULL),
1209 (817, 15, 123, 'password', 'pw', NULL),
1210 (818, 15, 123, 'remain', 'uebrig', NULL),
1211 (819, 15, 123, 'reload', 'reload', NULL),
1212 (820, 15, 123, 'reward', 'verguetung', NULL)");
1214 // Request parameters per type handler - Power-Promo
1215 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
1216 (523, 16, 78, 'id', 'id', NULL),
1217 (524, 16, 78, 'sid', 'sid', NULL),
1218 (525, 16, 78, 'password', 'pw', NULL),
1219 (526, 16, 78, 'reward', 'verguetung', NULL),
1220 (527, 16, 78, 'reload', 'reload', NULL),
1221 (528, 16, 78, 'remain', 'uebrig', NULL),
1222 (529, 16, 78, 'type', 'typ', 'klick'),
1223 (530, 16, 78, 'size', 'size', NULL),
1224 (531, 16, 79, 'id', 'id', NULL),
1225 (532, 16, 79, 'sid', 'sid', NULL),
1226 (533, 16, 79, 'password', 'pw', NULL),
1227 (534, 16, 79, 'reward', 'verguetung', NULL),
1228 (535, 16, 79, 'reload', 'reload', NULL),
1229 (536, 16, 79, 'remain', 'uebrig', NULL),
1230 (537, 16, 79, 'type', 'typ', 'view'),
1231 (538, 16, 79, 'size', 'size', NULL),
1232 (539, 16, 80, 'id', 'id', NULL),
1233 (540, 16, 80, 'sid', 'sid', NULL),
1234 (541, 16, 80, 'password', 'pw', NULL),
1235 (542, 16, 80, 'reward', 'verguetung', NULL),
1236 (543, 16, 80, 'reload', 'reload', NULL),
1237 (544, 16, 80, 'remain', 'uebrig', NULL),
1238 (545, 16, 80, 'type', 'typ', 'klick'),
1239 (546, 16, 81, 'id', 'id', NULL),
1240 (547, 16, 81, 'sid', 'sid', NULL),
1241 (548, 16, 81, 'password', 'pw', NULL),
1242 (549, 16, 81, 'reward', 'verguetung', NULL),
1243 (550, 16, 81, 'reload', 'reload', NULL),
1244 (551, 16, 81, 'remain', 'uebrig', NULL),
1245 (552, 16, 81, 'type', 'typ', 'view'),
1246 (553, 16, 82, 'id', 'id', NULL),
1247 (554, 16, 82, 'sid', 'sid', NULL),
1248 (555, 16, 82, 'password', 'pw', NULL),
1249 (556, 16, 82, 'reward', 'verguetung', NULL),
1250 (557, 16, 82, 'reload', 'reload', NULL),
1251 (558, 16, 82, 'remain', 'uebrig', NULL),
1252 (559, 16, 82, 'type', 'typ', 'klick'),
1253 (560, 16, 82, 'size', 'size', NULL),
1254 (561, 16, 83, 'id', 'id', NULL),
1255 (562, 16, 83, 'sid', 'sid', NULL),
1256 (563, 16, 83, 'password', 'pw', NULL),
1257 (564, 16, 83, 'reward', 'verguetung', NULL),
1258 (565, 16, 83, 'reload', 'reload', NULL),
1259 (566, 16, 83, 'remain', 'uebrig', NULL),
1260 (567, 16, 83, 'type', 'typ', 'view'),
1261 (568, 16, 83, 'size', 'size', NULL),
1262 (569, 16, 84, 'id', 'id', NULL),
1263 (570, 16, 84, 'sid', 'sid', NULL),
1264 (571, 16, 84, 'password', 'pw', NULL),
1265 (572, 16, 84, 'reward', 'verguetung', NULL),
1266 (573, 16, 84, 'reload', 'reload', NULL),
1267 (574, 16, 84, 'remain', 'uebrig', NULL),
1268 (575, 16, 84, 'size', 'size', NULL),
1269 (576, 16, 84, 'min_stay', 'ma', NULL),
1270 (577, 16, 85, 'id', 'id', NULL),
1271 (578, 16, 85, 'sid', 'sid', NULL),
1272 (579, 16, 85, 'password', 'pw', NULL),
1273 (580, 16, 85, 'reward', 'verguetung', NULL),
1274 (581, 16, 85, 'reload', 'reload', NULL),
1275 (582, 16, 85, 'remain', 'uebrig', NULL),
1276 (583, 16, 85, 'min_stay', 'ma', NULL),
1277 (584, 16, 85, 'type', 'typ', 'text'),
1278 (585, 16, 86, 'id', 'id', NULL),
1279 (586, 16, 86, 'sid', 'sid', NULL),
1280 (587, 16, 86, 'password', 'pw', NULL),
1281 (588, 16, 86, 'reward', 'verguetung', NULL),
1282 (589, 16, 86, 'reload', 'reload', NULL),
1283 (590, 16, 86, 'remain', 'uebrig', NULL),
1284 (591, 16, 86, 'min_stay', 'ma', NULL),
1285 (592, 16, 86, 'type', 'typ', 'html'),
1286 (593, 16, 87, 'id', 'id', NULL),
1287 (594, 16, 87, 'sid', 'sid', NULL),
1288 (595, 16, 87, 'password', 'pw', NULL),
1289 (596, 16, 87, 'reward', 'verguetung', NULL),
1290 (597, 16, 87, 'reload', 'reload', NULL),
1291 (598, 16, 87, 'remain', 'uebrig', NULL),
1292 (599, 16, 87, 'type', 'typ', 'klick'),
1293 (600, 16, 88, 'id', 'id', NULL),
1294 (601, 16, 88, 'sid', 'sid', NULL),
1295 (602, 16, 88, 'password', 'pw', NULL),
1296 (603, 16, 88, 'reward', 'verguetung', NULL),
1297 (604, 16, 88, 'reload', 'reload', NULL),
1298 (605, 16, 88, 'remain', 'uebrig', NULL),
1299 (606, 16, 88, 'type', 'typ', 'view'),
1300 (607, 16, 89, 'id', 'id', NULL),
1301 (608, 16, 89, 'sid', 'sid', NULL),
1302 (609, 16, 89, 'password', 'pw', NULL),
1303 (610, 16, 89, 'reward', 'verguetung', NULL),
1304 (611, 16, 89, 'reload', 'reload', NULL),
1305 (612, 16, 89, 'remain', 'uebrig', NULL),
1306 (613, 16, 89, 'min_stay', 'ma', NULL),
1307 (614, 16, 90, 'id', 'id', NULL),
1308 (615, 16, 90, 'sid', 'sid', NULL),
1309 (616, 16, 90, 'password', 'pw', NULL),
1310 (617, 16, 90, 'reward', 'verguetung', NULL),
1311 (618, 16, 90, 'reload', 'reload', NULL),
1312 (619, 16, 90, 'remain', 'uebrig', NULL),
1313 (620, 16, 90, 'min_stay', 'ma', NULL),
1314 (621, 16, 91, 'id', 'id', NULL),
1315 (622, 16, 91, 'sid', 'sid', NULL),
1316 (623, 16, 91, 'password', 'pw', NULL),
1317 (624, 16, 91, 'reward', 'verguetung', NULL),
1318 (625, 16, 91, 'remain', 'uebrig', NULL),
1319 (626, 16, 92, 'id', 'id', NULL),
1320 (627, 16, 92, 'sid', 'sid', NULL),
1321 (628, 16, 92, 'password', 'pw', NULL),
1322 (629, 16, 92, 'reward', 'verguetung', NULL),
1323 (630, 16, 92, 'remain', 'uebrig', NULL)");
1325 // Request parameters per type handler - SeCash
1326 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
1327 (631, 17, 93, 'extra', 'typ', 'forcedbanner'),
1328 (632, 17, 93, 'id', 'id', NULL),
1329 (633, 17, 93, 'password', 'pw', NULL),
1330 (634, 17, 93, 'reward', 'verguetung', NULL),
1331 (635, 17, 93, 'reload', 'reload', NULL),
1332 (636, 17, 93, 'remain', 'uebrig', NULL),
1333 (637, 17, 94, 'extra', 'typ', 'forcedtextlink'),
1334 (638, 17, 94, 'id', 'id', NULL),
1335 (639, 17, 94, 'password', 'pw', NULL),
1336 (640, 17, 94, 'reward', 'verguetung', NULL),
1337 (641, 17, 94, 'reload', 'reload', NULL),
1338 (642, 17, 94, 'remain', 'uebrig', NULL),
1339 (643, 17, 95, 'extra', 'typ', 'bannerview'),
1340 (644, 17, 95, 'id', 'id', NULL),
1341 (645, 17, 95, 'password', 'pw', NULL),
1342 (646, 17, 95, 'reward', 'verguetung', NULL),
1343 (647, 17, 95, 'reload', 'reload', NULL),
1344 (648, 17, 95, 'remain', 'uebrig', NULL),
1345 (649, 17, 96, 'extra', 'typ', 'bannerklick'),
1346 (650, 17, 96, 'id', 'id', NULL),
1347 (651, 17, 96, 'password', 'pw', NULL),
1348 (652, 17, 96, 'reward', 'verguetung', NULL),
1349 (653, 17, 96, 'reload', 'reload', NULL),
1350 (654, 17, 96, 'remain', 'uebrig', NULL),
1351 (655, 17, 97, 'extra', 'typ', 'skybannerview'),
1352 (656, 17, 97, 'id', 'id', NULL),
1353 (657, 17, 97, 'password', 'pw', NULL),
1354 (658, 17, 97, 'reward', 'verguetung', NULL),
1355 (659, 17, 97, 'reload', 'reload', NULL),
1356 (660, 17, 97, 'remain', 'uebrig', NULL),
1357 (661, 17, 98, 'extra', 'typ', 'buttonview'),
1358 (662, 17, 98, 'id', 'id', NULL),
1359 (663, 17, 98, 'password', 'pw', NULL),
1360 (664, 17, 98, 'reward', 'verguetung', NULL),
1361 (665, 17, 98, 'reload', 'reload', NULL),
1362 (666, 17, 98, 'remain', 'uebrig', NULL),
1363 (667, 17, 99, 'extra', 'typ', 'textview'),
1364 (668, 17, 99, 'id', 'id', NULL),
1365 (669, 17, 99, 'password', 'pw', NULL),
1366 (670, 17, 99, 'reward', 'verguetung', NULL),
1367 (671, 17, 99, 'reload', 'reload', NULL),
1368 (672, 17, 99, 'remain', 'uebrig', NULL),
1369 (673, 17, 100, 'extra', 'typ', 'popup'),
1370 (674, 17, 100, 'id', 'id', NULL),
1371 (675, 17, 100, 'password', 'pw', NULL),
1372 (676, 17, 100, 'reward', 'verguetung', NULL),
1373 (677, 17, 100, 'reload', 'reload', NULL),
1374 (678, 17, 100, 'remain', 'uebrig', NULL),
1375 (679, 17, 100, 'min_stay', 'ma', NULL),
1376 (680, 17, 101, 'extra', 'typ', 'paidmail'),
1377 (681, 17, 101, 'id', 'id', NULL),
1378 (682, 17, 101, 'password', 'pw', NULL),
1379 (683, 17, 101, 'reward', 'verguetung', NULL),
1380 (684, 17, 101, 'reload', 'reload', NULL),
1381 (685, 17, 101, 'remain', 'uebrig', NULL),
1382 (686, 17, 101, 'min_stay', 'ma', NULL),
1383 (821, 17, 124, 'extra', 'typ', 'traffic'),
1384 (822, 17, 124, 'id', 'id', NULL),
1385 (823, 17, 124, 'password', 'pw', NULL),
1386 (824, 17, 124, 'remain', 'uebrig', NULL),
1387 (825, 17, 124, 'reload', 'reload', NULL),
1388 (826, 17, 124, 'reward', 'verguetung', NULL)");
1390 // Request parameters per type handler - UltraPROMO
1391 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
1392 (827, 18, 128, 'extra', 'typ', 'forcedbanner'),
1393 (828, 18, 128, 'id', 'id', NULL),
1394 (829, 18, 128, 'password', 'pw', NULL),
1395 (830, 18, 128, 'remain', 'uebrig', NULL),
1396 (831, 18, 128, 'reload', 'reload', NULL),
1397 (832, 18, 128, 'reward', 'verguetung', NULL),
1398 (833, 18, 129, 'extra', 'typ', 'forcedtextlink'),
1399 (834, 18, 129, 'id', 'id', NULL),
1400 (835, 18, 129, 'password', 'pw', NULL),
1401 (836, 18, 129, 'remain', 'uebrig', NULL),
1402 (837, 18, 129, 'reload', 'reload', NULL),
1403 (838, 18, 129, 'reward', 'verguetung', NULL),
1404 (839, 18, 126, 'extra', 'typ', 'bannerview'),
1405 (840, 18, 126, 'id', 'id', NULL),
1406 (841, 18, 126, 'password', 'pw', NULL),
1407 (842, 18, 126, 'remain', 'uebrig', NULL),
1408 (843, 18, 126, 'reload', 'reload', NULL),
1409 (844, 18, 126, 'reward', 'verguetung', NULL),
1410 (845, 18, 125, 'extra', 'typ', 'bannerklick'),
1411 (846, 18, 125, 'id', 'id', NULL),
1412 (847, 18, 125, 'password', 'pw', NULL),
1413 (848, 18, 125, 'remain', 'uebrig', NULL),
1414 (849, 18, 125, 'reload', 'reload', NULL),
1415 (850, 18, 125, 'reward', 'verguetung', NULL),
1416 (851, 18, 131, 'extra', 'typ', 'skybannerview'),
1417 (852, 18, 131, 'id', 'id', NULL),
1418 (853, 18, 131, 'password', 'pw', NULL),
1419 (854, 18, 131, 'remain', 'uebrig', NULL),
1420 (855, 18, 131, 'reload', 'reload', NULL),
1421 (856, 18, 131, 'reward', 'verguetung', NULL),
1422 (857, 18, 127, 'extra', 'typ', 'buttonview'),
1423 (858, 18, 127, 'id', 'id', NULL),
1424 (859, 18, 127, 'password', 'pw', NULL),
1425 (860, 18, 127, 'remain', 'uebrig', NULL),
1426 (861, 18, 127, 'reload', 'reload', NULL),
1427 (862, 18, 127, 'reward', 'verguetung', NULL),
1428 (863, 18, 132, 'extra', 'typ', 'textview'),
1429 (864, 18, 132, 'id', 'id', NULL),
1430 (865, 18, 132, 'password', 'pw', NULL),
1431 (866, 18, 132, 'remain', 'uebrig', NULL),
1432 (867, 18, 132, 'reload', 'reload', NULL),
1433 (868, 18, 132, 'reward', 'verguetung', NULL),
1434 (869, 18, 134, 'extra', 'typ', 'traffic'),
1435 (870, 18, 134, 'id', 'id', NULL),
1436 (871, 18, 134, 'password', 'pw', NULL),
1437 (872, 18, 134, 'remain', 'uebrig', NULL),
1438 (873, 18, 134, 'reload', 'reload', NULL),
1439 (874, 18, 134, 'reward', 'verguetung', NULL),
1440 (875, 18, 130, 'extra', 'typ', 'popup'),
1441 (876, 18, 130, 'id', 'id', NULL),
1442 (877, 18, 130, 'password', 'pw', NULL),
1443 (878, 18, 130, 'remain', 'uebrig', NULL),
1444 (879, 18, 130, 'reload', 'reload', NULL),
1445 (880, 18, 130, 'reward', 'verguetung', NULL),
1446 (881, 18, 130, 'min_stay', 'ma', NULL),
1447 (882, 18, 133, 'extra', 'typ', 'paidmail'),
1448 (883, 18, 133, 'id', 'id', NULL),
1449 (884, 18, 133, 'password', 'pw', NULL),
1450 (885, 18, 133, 'remain', 'uebrig', NULL),
1451 (886, 18, 133, 'reload', 'reload', NULL),
1452 (887, 18, 133, 'reward', 'verguetung', NULL),
1453 (888, 18, 133, 'min_stay', 'ma', NULL)");
1455 // Request parameters per type handler - Der Werbepartner.cc
1456 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
1457 (951, 19, 145, 'extra', 'art', 'Textlinkklick'),
1458 (952, 19, 145, 'reload', 'reload', NULL),
1459 (953, 19, 145, 'reward', 'verg', NULL),
1460 (954, 19, 145, 'remain', 'offen', NULL),
1461 (955, 19, 145, 'sid', 'sid', NULL),
1462 (956, 19, 145, 'id', 'uid', NULL),
1463 (957, 19, 145, 'password', 'pw', NULL),
1464 (958, 19, 146, 'extra', 'art', 'Forcedbanner'),
1465 (959, 19, 146, 'reload', 'reload', NULL),
1466 (960, 19, 146, 'reward', 'verg', NULL),
1467 (961, 19, 146, 'remain', 'offen', NULL),
1468 (962, 19, 146, 'sid', 'sid', NULL),
1469 (963, 19, 146, 'id', 'uid', NULL),
1470 (964, 19, 146, 'password', 'pw', NULL),
1471 (965, 19, 147, 'extra', 'art', 'Paidmail'),
1472 (966, 19, 147, 'reload', 'reload', NULL),
1473 (967, 19, 147, 'reward', 'verg', NULL),
1474 (968, 19, 147, 'remain', 'offen', NULL),
1475 (969, 19, 147, 'sid', 'sid', NULL),
1476 (970, 19, 147, 'id', 'uid', NULL),
1477 (971, 19, 147, 'password', 'pw', NULL),
1478 (972, 19, 148, 'extra', 'art', 'Layer'),
1479 (973, 19, 148, 'reload', 'reload', NULL),
1480 (974, 19, 148, 'reward', 'verg', NULL),
1481 (975, 19, 148, 'remain', 'offen', NULL),
1482 (976, 19, 148, 'sid', 'sid', NULL),
1483 (977, 19, 148, 'id', 'uid', NULL),
1484 (978, 19, 148, 'password', 'pw', NULL),
1485 (979, 19, 149, 'extra', 'art', 'Skybannerklick'),
1486 (980, 19, 149, 'reload', 'reload', NULL),
1487 (981, 19, 149, 'reward', 'verg', NULL),
1488 (982, 19, 149, 'remain', 'offen', NULL),
1489 (983, 19, 149, 'sid', 'sid', NULL),
1490 (984, 19, 149, 'id', 'uid', NULL),
1491 (985, 19, 149, 'password', 'pw', NULL),
1492 (986, 19, 150, 'extra', 'art', 'Surfbarklick'),
1493 (987, 19, 150, 'reload', 'reload', NULL),
1494 (988, 19, 150, 'reward', 'verg', NULL),
1495 (989, 19, 150, 'remain', 'offen', NULL),
1496 (990, 19, 150, 'sid', 'sid', NULL),
1497 (991, 19, 150, 'id', 'uid', NULL),
1498 (992, 19, 150, 'password', 'pw', NULL),
1499 (993, 19, 151, 'extra', 'art', 'Bannerview'),
1500 (994, 19, 151, 'reload', 'reload', NULL),
1501 (995, 19, 151, 'reward', 'verg', NULL),
1502 (996, 19, 151, 'remain', 'offen', NULL),
1503 (997, 19, 151, 'sid', 'sid', NULL),
1504 (998, 19, 151, 'id', 'uid', NULL),
1505 (999, 19, 151, 'password', 'pw', NULL),
1506 (1000, 19, 152, 'extra', 'art', 'PopUp'),
1507 (1001, 19, 152, 'reload', 'reload', NULL),
1508 (1002, 19, 152, 'reward', 'verg', NULL),
1509 (1003, 19, 152, 'remain', 'offen', NULL),
1510 (1004, 19, 152, 'sid', 'sid', NULL),
1511 (1005, 19, 152, 'id', 'uid', NULL),
1512 (1006, 19, 152, 'password', 'pw', NULL),
1513 (1007, 19, 153, 'extra', 'art', 'Bannerklick'),
1514 (1008, 19, 153, 'reload', 'reload', NULL),
1515 (1009, 19, 153, 'reward', 'verg', NULL),
1516 (1010, 19, 153, 'type', 'offen', NULL),
1517 (1011, 19, 153, 'sid', 'sid', NULL),
1518 (1012, 19, 153, 'id', 'uid', NULL),
1519 (1013, 19, 153, 'password', 'pw', NULL),
1520 (1014, 19, 154, 'extra', 'art', 'Forcedtextlink'),
1521 (1015, 19, 154, 'reload', 'reload', NULL),
1522 (1016, 19, 154, 'reward', 'verg', NULL),
1523 (1017, 19, 154, 'remain', 'offen', NULL),
1524 (1018, 19, 154, 'sid', 'sid', NULL),
1525 (1019, 19, 154, 'id', 'uid', NULL),
1526 (1020, 19, 154, 'password', 'pw', NULL),
1527 (1021, 19, 155, 'extra', 'art', 'Traffic'),
1528 (1022, 19, 155, 'reload', 'reload', NULL),
1529 (1023, 19, 155, 'reward', 'verg', NULL),
1530 (1024, 19, 155, 'remain', 'offen', NULL),
1531 (1025, 19, 155, 'sid', 'sid', NULL),
1532 (1026, 19, 155, 'id', 'id', NULL),
1533 (1027, 19, 155, 'password', 'pw', NULL)");
1535 // Request parameters per type handler - Yoo!Media
1537 // Fix empty defaults to NULL
1538 addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_types` SET `network_type_banner_url`=NULL WHERE `network_type_banner_url`=''");
1539 addExtensionSql("UPDATE `{?_MYSQL_PREFIX?}_network_request_params` SET `request_param_default`=NULL WHERE `request_param_default`=''");
1541 // Admin menu entries
1542 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);
1543 addAdminMenuSql('network','config_networks','API-Daten','Stellen Sie Ihre Affiliate- Webseiten-Id und API-Passwort ein. Diese erhalten Sie zu über 99% aus dem jeweiligen Zugangsbereich des Anbieters. Sollten Sie bei einem Netzwerk noch nicht angemeldet sein, verwenden Sie bitte meinen Referal-Link.',1);
1544 addAdminMenuSql('network','config_network_types','Werbearten','Stellen Sie hier Reload-Zeiten, Mindestauffenthalt und so weiter pro Werbeart und Werbenetzwerk ein. Es werden sonst Standart-Werte (Mimimumwerte: 0, Maximumwerte: sehr gross, Erotik: aus) angenommen, die Sie meistens nicht wollen.',2);
1545 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);
1546 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);
1547 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);
1548 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);
1549 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);
1550 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);
1551 addAdminMenuSql('network','list_network_code_types','Rückgabewerte','<strong>Experten-Einstellungen!</strong> 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 <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);
1552 addAdminMenuSql('network','list_network_codes','Fehlercodes','<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.',10);
1554 // Configuration entries
1555 addExtensionSql('ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `network_cache_refresh` BIGINT(20) UNSIGNED NOT NULL DEFAULT ' . (60 * 15) . '');
1558 case 'remove': // Do stuff when removing extension
1559 // SQL commands to run
1560 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_data`');
1561 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types`');
1562 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_request_params`');
1563 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_type_codes`');
1564 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_codes`');
1565 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_translations`');
1566 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_return_types`');
1567 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_config`');
1568 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_types_config`');
1569 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_cache`');
1570 addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_network_reloads`');
1573 addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='network'");
1576 case 'activate': // Do stuff when admin activates this extension
1577 // SQL commands to run
1580 case 'deactivate': // Do stuff when admin deactivates this extension
1581 // SQL commands to run
1584 case 'update': // Update an extension
1585 switch (getCurrentExtensionVersion()) {
1586 case '0.0.1': // SQL queries for v0.0.1
1587 addExtensionSql('');
1589 // Update notes (these will be set as task text!)
1590 setExtensionUpdateNotes('');
1595 case 'modify': // When the extension got modified
1598 case 'test': // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305.
1601 case 'init': // Do stuff when extension is initialized
1604 default: // Unknown extension mode
1605 logDebugMessage(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName()));