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