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