Referal system refactured (and some parts fixed), wrapper function introduced:

[mailer.git] / inc / extensions / ext-network.php

diff --git a/inc/extensions/ext-network.php b/inc/extensions/ext-network.php
index 2284ecbfe5f4dda371d15fb449d1bc338675bfe0..d65ad5faf1df3989c877b37ef8238a5d13b52ee2 100644 (file)
--- a/inc/extensions/ext-network.php
+++ b/inc/extensions/ext-network.php
@@ -100,7 +100,7 @@ UNIQUE (`network_short_name`)",
 `network_type_click_url` VARCHAR(255) NOT NULL DEFAULT '',
 `network_type_banner_url` VARCHAR(255) NULL DEFAULT NULL,
 PRIMARY KEY (`network_type_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_handle`)",
+UNIQUE `provider_type` (`network_id`, `network_type_handle`)",
                        'Types provideable by networks');
 
                // HTTP parameters (names) for URLs
@@ -113,8 +113,8 @@ UNIQUE `provider_type` (`network_id`,`network_type_handle`)",
 `request_param_value` VARCHAR(20) NOT NULL DEFAULT 'invalid',
 `request_param_default` VARCHAR(255) NULL DEFAULT NULL,
 PRIMARY KEY (`network_param_id`),
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`request_param_key`),
-UNIQUE `provider_type_value` (`network_id`,`network_type_id`,`request_param_value`),",
+UNIQUE `provider_type_key` (`network_id`, `network_type_id`, `request_param_key`),
+UNIQUE `provider_type_value` (`network_id`, `network_type_id`, `request_param_value`),",
                        'Request parameters for GET/POST request');
 
                // Error status codes
@@ -125,7 +125,7 @@ UNIQUE `provider_type_value` (`network_id`,`network_type_id`,`request_param_valu
 `network_type_code_value` VARCHAR(50) NOT NULL DEFAULT '',
 `network_type_code_type` VARCHAR(100) NOT NULL DEFAULT 'INVALID_TYPE',
 PRIMARY KEY (`network_type_code_id`),
-UNIQUE `code_type` (`network_type_code_value`,`network_type_id`),
+UNIQUE `code_type` (`network_type_code_value`, `network_type_id`),
 INDEX (`network_type_id`)",
                        'Error codes for all types');
 
@@ -156,7 +156,7 @@ UNIQUE (`network_translation_name`)",
 `network_api_index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
 `sort` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 PRIMARY KEY (`network_api_id`),
-UNIQUE `provider_type_key` (`network_id`,`network_type_id`,`network_api_index`),
+UNIQUE `provider_type_key` (`network_id`, `network_type_id`, `network_api_index`),
 INDEX (`sort`)",
                        'Translation of API responses, generic data, DO NOT ALTER!');
 
@@ -170,8 +170,8 @@ INDEX (`sort`)",
 `network_query_amount` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `network_active` ENUM('Y','N') NOT NULL DEFAULT 'Y',
 PRIMARY KEY (`network_id`),
-UNIQUE `network_affiliate` (`network_id`,`network_affiliate_id`),
-UNIQUE `affiliate_site` (`network_affiliate_id`,`network_site_id`)",
+UNIQUE `network_affiliate` (`network_id`, `network_affiliate_id`),
+UNIQUE `affiliate_site` (`network_affiliate_id`, `network_site_id`)",
                        'Configuration data from the webmaster (you!)');
 
                // Configuration data for e.g. reload-time
@@ -186,7 +186,7 @@ UNIQUE `affiliate_site` (`network_affiliate_id`,`network_site_id`)",
 `min_payment` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 `allow_erotic` VARCHAR(10) NOT NULL DEFAULT '',
 PRIMARY KEY (`network_data_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE `provider_type` (`network_id`, `network_type_id`)",
                        'Configuration data for every type (e.g. reload-time)');
 
                // Cache for queried APIs. Re-check depends on config
@@ -200,7 +200,7 @@ UNIQUE `provider_type` (`network_id`,`network_type_id`)",
 `network_cache_data` MEDIUMBLOB,
 `network_cache_timestamp` TIMESTAMP NULL DEFAULT NULL,
 PRIMARY KEY (`network_cache_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE `provider_type` (`network_id`, `network_type_id`)",
                        'Cache for all queried APIs');
 
                // Reload locks for several types
@@ -212,7 +212,7 @@ UNIQUE `provider_type` (`network_id`,`network_type_id`)",
 `network_reload_lock` SMALLINT(5) UNSIGNED NOT NULL DEFAULT 0,
 `network_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
 PRIMARY KEY (`network_reload_id`),
-UNIQUE `provider_type` (`network_id`,`network_type_id`)",
+UNIQUE `provider_type` (`network_id`, `network_type_id`)",
                        'Reload locks');
 
                // Insert API response array translations, these will be used for calling the right filter function
@@ -270,7 +270,7 @@ UNIQUE `provider_type` (`network_id`,`network_type_id`)",
 ('REQUEST_PARAMETER_INCOMPLETE')");
 
                // Sponsor networks
-               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`,`network_require_id_card`) VALUES
+               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`, `network_require_id_card`) VALUES
 ('a3h', 'A3H', 'http://www.a3h.de?ref=1447', '|', '|', 'GET', 'WINDOWS-1252','N'),
 ('abiszed','AbisZED-Netz','http://abiszed-netz.de/index.php?ref=557', '|', '|', 'GET', 'WINDOWS-1252','Y'),
 ('admagnet', 'AD-Magnet', 'http://www.ad-magnet.de/index.php?ref=495', '|', '|', 'GET', 'ISO-8859-1','N'),
@@ -303,7 +303,7 @@ UNIQUE `provider_type` (`network_id`,`network_type_id`)",
 ('adconvention', 'AdConvention', 'http://www.adconvention.de?ref=233', '|', '|', 'GET', 'WINDOWS-1252','N')");
 
                // Network type handlers - A3H
-               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
+               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
 (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%'),
 (2, 1, 'textlink', 'http://www.a3h.de/interface/out_textlink.php', 'http://www.a3h.de/textlinkklick.php?id=%CID%', NULL),
 (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%'),