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