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