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