2 /************************************************************************
3 * Mailer v0.2.1-FINAL Start: 11/04/2009 *
4 * =================== Last change: 11/04/2009 *
6 * -------------------------------------------------------------------- *
7 * File : network_functions.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Functions for ext-network *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Funktionen fuer ext-network *
12 * -------------------------------------------------------------------- *
15 * $Tag:: 0.2.1-FINAL $ *
17 * -------------------------------------------------------------------- *
18 * Copyright (c) 2003 - 2009 by Roland Haeder *
19 * Copyright (c) 2009 - 2011 by Mailer Developer Team *
20 * For more information visit: http://www.mxchange.org *
22 * This program is free software; you can redistribute it and/or modify *
23 * it under the terms of the GNU General Public License as published by *
24 * the Free Software Foundation; either version 2 of the License, or *
25 * (at your option) any later version. *
27 * This program is distributed in the hope that it will be useful, *
28 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
29 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
30 * GNU General Public License for more details. *
32 * You should have received a copy of the GNU General Public License *
33 * along with this program; if not, write to the Free Software *
34 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
36 ************************************************************************/
38 // Some security stuff...
39 if (!defined('__SECURITY')) {
43 // Private setter for current network id
44 function setCurrentNetworkId ($id) {
45 $GLOBALS['current_network_id'] = bigintval($id);
48 // Private getter for current network id
49 function getCurrentNetworkId () {
50 return $GLOBALS['current_network_id'];
53 // Handle a (maybe) sent form here
54 function doNetworkHandleForm () {
56 if ((isFormSent()) || (isFormSent('edit')) || (isFormSent('delete')) || (isFormSent('do_edit')) || (isFormSent('do_delete'))) {
58 if (isGetRequestParameterSet('do')) {
59 // Process the request
60 doAdminNetworkProcessForm();
63 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_DO_404--}');
68 // Processes an admin form
69 function doAdminNetworkProcessForm () {
71 if ((!isFormSent()) && (!isFormSent('edit')) && (!isFormSent('delete')) && (!isFormSent('do_edit')) && (!isFormSent('do_delete'))) {
73 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_FORM_NOT_SENT--}');
75 } elseif (!isGetRequestParameterSet('do')) {
77 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_DO_404--}');
81 // Create function name
82 $functionName = sprintf("doAdminNetworkProcess%s", capitalizeUnderscoreString(getRequestParameter('do')));
84 // Is the function valid?
85 if (!function_exists($functionName)) {
86 // Invalid function name
87 debug_report_bug(__FUNCTION__, __LINE__, 'Invalid do ' . getRequestParameter('do') . ', function ' . $functionName .' does not exist.', false);
90 // Call-back the method handling our request
91 call_user_func($functionName);
94 // Checks wether the (short) network name is already used (valid)
95 function isNetworkNameValid ($name) {
97 $result = SQL_QUERY_ESC("SELECT `network_id` FROM `{?_MYSQL_PREFIX?}_network_data` WHERE `network_short_name`='%s' LIMIT 1",
98 array($name), __FUNCTION__, __LINE__);
101 $isValid = (SQL_NUMROWS($result) == 1);
104 SQL_FREERESULT($result);
110 // Checks wether the given network type is already used (valid)
111 function isNetworkTypeHandleValid ($type, $networkId) {
113 $result = SQL_QUERY_ESC("SELECT `network_type_id` FROM `{?_MYSQL_PREFIX?}_network_types` WHERE `network_id`=%s AND `network_type_handle`='%s' LIMIT 1",
114 array($networkId, $type), __FUNCTION__, __LINE__);
117 $isValid = (SQL_NUMROWS($result) == 1);
120 SQL_FREERESULT($result);
126 // Checks wether the given network request parameter is already used (valid)
127 function isNetworkRequestParameterValid ($key, $type, $networkId) {
129 $result = SQL_QUERY_ESC("SELECT `network_param_id` FROM `{?_MYSQL_PREFIX?}_network_request_params` WHERE `network_id`=%s AND `network_type_id`=%s AND `request_param_key`='%s' LIMIT 1",
130 array($networkId, $type, $key), __FUNCTION__, __LINE__);
133 $isValid = (SQL_NUMROWS($result) == 1);
136 SQL_FREERESULT($result);
142 // Checks wether the given network API array translation
143 function isNetworkApiTranslationValid ($key, $type, $networkId) {
145 $result = SQL_QUERY_ESC("SELECT `network_api_id` FROM `{?_MYSQL_PREFIX?}_network_api_translation` WHERE `network_id`=%s AND `network_type_id`=%s AND `network_api_index`='%s' LIMIT 1",
146 array($networkId, $type, $key), __FUNCTION__, __LINE__);
149 $isValid = (SQL_NUMROWS($result) == 1);
152 SQL_FREERESULT($result);
158 // "Getter" for a network's data by provided id number
159 function getNetworkDataById ($id, $column = '') {
160 // Ids lower one are not accepted
162 // Not good, should be fixed
163 debug_report_bug(__FUNCTION__, __LINE__, 'Network id ' . $id . ' is smaller than 1.');
166 // Set current network id
167 setCurrentNetworkId($id);
170 if (!isset($GLOBALS['network_data'][$id])) {
171 // By default we have no data
172 $GLOBALS['network_data'][$id] = array();
174 // Query for the network data
175 $result = SQL_QUERY_ESC("SELECT
176 `network_id`, `network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`
178 `{?_MYSQL_PREFIX?}_network_data`
182 array(bigintval($id)), __FUNCTION__, __LINE__);
184 // Do we have an entry?
185 if (SQL_NUMROWS($result) == 1) {
187 $GLOBALS['network_data'][$id] = SQL_FETCHARRAY($result);
191 SQL_FREERESULT($result);
195 if (empty($column)) {
197 return $GLOBALS['network_data'][$id];
200 return $GLOBALS['network_data'][$id][$column];
204 // "Getter" for a network's data by provided type id number
205 function getNetworkDataByTypeId ($id, $column = '') {
206 // Ids lower one are not accepted
208 // Not good, should be fixed
209 debug_report_bug(__FUNCTION__, __LINE__, 'Network type id ' . $id . ' is smaller than 1.');
212 // Set current network id
213 setCurrentNetworkId($id);
216 if (!isset($GLOBALS['network_data'][$id])) {
217 // By default we have no data
218 $GLOBALS['network_data'][$id] = array();
220 // Query for the network data
221 $result = SQL_QUERY_ESC("SELECT
222 d.`network_id`, d.`network_short_name`, d.`network_title`, d.`network_reflink`, d.`network_data_seperator`, d.`network_row_seperator`, d.`network_request_type`, d.`network_charset`,
223 t.`network_type_handle`, t.`network_type_api_url`, t.`network_type_click_url`, t.`network_type_banner_url`
225 `{?_MYSQL_PREFIX?}_network_data` AS d
227 `{?_MYSQL_PREFIX?}_network_types` AS t
229 d.`network_id`=t.`network_id`
231 t.`network_type_id`=%s
233 array(bigintval($id)), __FUNCTION__, __LINE__);
235 // Do we have an entry?
236 if (SQL_NUMROWS($result) == 1) {
238 $GLOBALS['network_data'][$id] = SQL_FETCHARRAY($result);
242 SQL_FREERESULT($result);
246 if (empty($column)) {
248 return $GLOBALS['network_data'][$id];
251 return $GLOBALS['network_data'][$id][$column];
255 // "Getter" for a network type data by provided id number
256 function getNetworkTypeDataById ($id) {
257 // Ids lower one are not accepted
259 // Not good, should be fixed
260 debug_report_bug(__FUNCTION__, __LINE__, 'Network type id ' . $id . ' is smaller than 1.');
263 // By default we have no data
264 $GLOBALS['network_type_data'][$id] = array();
266 // Query for the network data
267 $result = SQL_QUERY_ESC("SELECT
268 `network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`
270 `{?_MYSQL_PREFIX?}_network_types`
274 array(bigintval($id)), __FUNCTION__, __LINE__);
276 // Do we have an entry?
277 if (SQL_NUMROWS($result) == 1) {
279 $GLOBALS['network_type_data'][$id] = SQL_FETCHARRAY($result);
283 SQL_FREERESULT($result);
286 return $GLOBALS['network_type_data'][$id];
289 // "Getter" for a network request parameter data by provided id number
290 function getNetworkRequestParamsDataById ($id) {
291 // Ids lower one are not accepted
293 // Not good, should be fixed
294 debug_report_bug(__FUNCTION__, __LINE__, 'Network request parameter id ' . $id . ' is smaller than 1.');
297 // By default we have no data
298 $networkRequestData = array();
300 // Query for the network data
301 $result = SQL_QUERY_ESC("SELECT
302 `network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`
304 `{?_MYSQL_PREFIX?}_network_request_params`
306 `network_param_id`=%s
308 array(bigintval($id)), __FUNCTION__, __LINE__);
310 // Do we have an entry?
311 if (SQL_NUMROWS($result) == 1) {
313 $networkRequestData = SQL_FETCHARRAY($result);
317 SQL_FREERESULT($result);
320 return $networkRequestData;
323 // Updates given network (id) with data from array
324 function doNetworkUpdateDataByArray ($id, $networkData) {
325 // Ids lower one are not accepted
327 // Not good, should be fixed
328 debug_report_bug(__FUNCTION__, __LINE__, 'Network id ' . $id . ' is smaller than 1.');
331 // Just call our inner method
332 return adminSaveSettings($networkData, '_network_data', sprintf("`network_id`=%s", bigintval($id)), array(), false, false);
335 // Updates given network type handler (id) with data from array
336 function doNetworkUpdateTypeByArray ($id, $networkTypeData) {
337 // Ids lower one are not accepted
339 // Not good, should be fixed
340 debug_report_bug(__FUNCTION__, __LINE__, 'Network type handler id ' . $id . ' is smaller than 1.');
343 // Just call our inner method
344 return adminSaveSettings($networkTypeData, '_network_types', sprintf("`network_type_id`=%s", bigintval($id)), array(), false, false);
347 // Updates given network request parameters (id) with data from array
348 function doNetworkUpdateParamsByArray ($id, $networkParamData) {
349 // Ids lower one are not accepted
351 // Not good, should be fixed
352 debug_report_bug(__FUNCTION__, __LINE__, 'Network request parameter id ' . $id . ' is smaller than 1.');
355 // Just call our inner method
356 return adminSaveSettings($networkParamData, '_network_request_params', sprintf("`network_param_id`=%s", bigintval($id)), array(), false, false);
359 // Removes given network entry
360 function doAdminRemoveNetworkEntry ($table, $column, $id, $limit = 1) {
362 SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_network_%s` WHERE `%s`=%s LIMIT %s",
363 array($table, $column, $id, $limit), __FUNCTION__, __LINE__);
365 // Return affected rows
366 return SQL_AFFECTEDROWS();
369 // Generates a list of networks for given script and returns it
370 function generateAdminNetworkList () {
374 // Query for all networks
375 $result = SQL_QUERY('SELECT
376 `network_id`, `network_short_name`, `network_title`
378 `{?_MYSQL_PREFIX?}_network_data`
380 `network_short_name` ASC', __FUNCTION__, __LINE__);
382 // Do we have entries?
383 if (!SQL_HASZERONUMS($result)) {
386 while ($row = SQL_FETCHARRAY($result)) {
387 // Is this valid, then add it
388 if ((is_array($row)) && (isset($row['network_id']))) {
390 $rows[$row['network_id']] = $row;
394 // Generate the selection box
395 $content = generateSelectionBoxFromArray($rows, 'network', 'network_id');
398 $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
402 SQL_FREERESULT($result);
408 // Generator (somewhat getter) for a list of network types for given network id
409 function generateAdminNetworkTypeList ($networkId) {
413 // Query all types of this network
414 $result = SQL_QUERY_ESC("SELECT
415 `network_type_id`, `network_type_handle`
417 `{?_MYSQL_PREFIX?}_network_types`
421 `network_type_handle` ASC",
423 bigintval($networkId)
424 ), __FUNCTION__, __LINE__);
426 // Do we have entries?
427 if (!SQL_HASZERONUMS($result)) {
430 while ($row = SQL_FETCHARRAY($result)) {
431 // Is this valid, then add it
432 if ((is_array($row)) && (isset($row['network_type_id']))) {
434 $rows[$row['network_type_id']] = $row;
438 // Generate the selection box
439 $content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id');
442 $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
446 SQL_FREERESULT($result);
452 // Generator (somewhat getter) for a list of network types for all types
453 function generateAdminDistinctNetworkTypeList () {
457 // Query all types of this network
458 $result = SQL_QUERY('SELECT
459 t.`network_type_id`, t.`network_type_handle`, d.`network_title`
461 `{?_MYSQL_PREFIX?}_network_types` AS t
463 `{?_MYSQL_PREFIX?}_network_data` AS d
465 t.`network_id`=d.`network_id`
467 d.`network_short_name` ASC,
468 t.`network_type_handle` ASC', __FUNCTION__, __LINE__);
470 // Do we have entries?
471 if (!SQL_HASZERONUMS($result)) {
474 while ($row = SQL_FETCHARRAY($result)) {
475 // Is this valid, then add it
476 if ((is_array($row)) && (isset($row['network_type_id']))) {
478 $rows[$row['network_type_id']] = $row;
482 // Generate the selection box
483 $content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id', '', '_title');
486 $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
490 SQL_FREERESULT($result);
491 //* DEBUG: */ die('<pre>'.encodeEntities($content).'</pre>');
497 // Generator (somewhat getter) for network type options
498 function generateNetworkTypeOptions ($id) {
499 // Is this an array, then we just came back from edit/delete actions
500 if (is_array($id)) $id = '';
503 if (!isset($GLOBALS[__FUNCTION__][$id])) {
504 // Generate output and cache it
505 $GLOBALS[__FUNCTION__][$id] = generateOptionList(
508 'network_type_handle',
512 "WHERE `network_id`=%s",
513 bigintval(getRequestParameter('network'))
516 'translateNetworkTypeHandler'
521 return $GLOBALS[__FUNCTION__][$id];
524 // Generates an options list of all available (hard-coded) handlers
525 function generateNetworkTypesAvailableOptions () {
527 if (!isset($GLOBALS[__FUNCTION__])) {
529 $GLOBALS[__FUNCTION__] = generateOptionList(
565 $GLOBALS['network_types_disabled'],
566 'translateNetworkTypeHandler'
571 return $GLOBALS[__FUNCTION__];
574 // Generates an options list (somewhat getter) ofr request keys
575 function generateNetworkRequestKeyOptions () {
577 if (!isset($GLOBALS[__FUNCTION__])) {
578 // Generate and cache it
579 $GLOBALS[__FUNCTION__] = generateOptionList(
601 $GLOBALS['network_params_disabled'],
602 'translateNetworkRequestParameter'
607 return $GLOBALS[__FUNCTION__];
610 // Generator (somewhat getter) for (return) array translation
611 function generateNetworkTranslationOptions ($default = '') {
613 if (!isset($GLOBALS[__FUNCTION__][$default])) {
614 // Generate and cache it
615 $GLOBALS[__FUNCTION__][$default] = generateOptionList(
616 'network_translations',
617 'network_translation_id',
618 'network_translation_name',
622 $GLOBALS['network_translation_disabled'],
623 'translateNetworkTranslationName'
628 return $GLOBALS[__FUNCTION__][$default];
631 // Generates an option list of request types
632 function generateNetworkRequestTypeOptions ($default = '') {
634 if (!isset($GLOBALS[__FUNCTION__][$default])) {
636 $GLOBALS[__FUNCTION__][$default] = generateOptionList(
643 '{--ADMIN_NETWORK_REQUEST_TYPE_GET--}',
644 '{--ADMIN_NETWORK_REQUEST_TYPE_POST--}'
651 return $GLOBALS[__FUNCTION__][$default];
654 // Generates an option list of network_active
655 function generateNetworkActiveOptions ($default = '') {
657 if (!isset($GLOBALS[__FUNCTION__][$default])) {
659 $GLOBALS[__FUNCTION__][$default] = generateYesNoOptionList($default);
663 return $GLOBALS[__FUNCTION__][$default];
666 // Translates 'translate_name' for e.g. templates
667 function translateNetworkTranslationName ($name) {
668 // Get the message id
669 return '{--ADMIN_NETWORK_TRANSLATE_' . strtoupper($name) . '_NAME--}';
672 // Translates the network type handler (e.g. banner, paidmail) for templates
673 function translateNetworkTypeHandler ($type) {
674 // Get the message id
675 return '{--ADMIN_NETWORK_TYPES_' . strtoupper($type) . '--}';
678 // Translates request type
679 function translateNetworkRequestType ($type) {
680 // Get the message id
681 return '{--ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($type) . '--}';
684 // Translates request parameter
685 function translateNetworkRequestParameter ($param) {
686 // Get the message id
687 return '{--ADMIN_NETWORK_REQUEST_PARAMETER_' . strtoupper($param) . '--}';
690 // Translates API index
691 function translateNetworkApiIndex ($index) {
693 if (!isset($GLOBALS['network_api_index'])) {
694 // Get an array of all API array indexes
695 $GLOBALS['network_api_index'] = array();
698 $result = SQL_QUERY('SELECT
699 `network_api_id`, `network_api_index`, `network_translation_name`
701 `{?_MYSQL_PREFIX?}_network_api_translation`
703 `{?_MYSQL_PREFIX?}_network_translations`
705 `network_api_index`=`network_translation_id`
707 `sort` ASC', __FUNCTION__, __LINE__);
709 // Do we have entries?
710 if (!SQL_HASZERONUMS($result)) {
712 while ($row = SQL_FETCHARRAY($result)) {
713 // Add it to our global array
714 $GLOBALS['network_api_index'][$row['network_api_index']] = $row;
719 SQL_FREERESULT($result);
722 // Default name is unknown
725 // Is the entry there?
726 if (isset($GLOBALS['network_api_index'][$index])) {
728 $name = $GLOBALS['network_api_index'][$index]['network_translation_name'];
731 // Return translation
732 return translateNetworkTranslationName($name);
735 //------------------------------------------------------------------------------
736 // Call-back functions
737 //------------------------------------------------------------------------------
739 // Callback function to add new network
740 function doAdminNetworkProcessAddNetwork () {
741 // We can say here, the form is sent, so check if the network is already added
742 if (isNetworkNameValid(postRequestParameter('network_short_name'))) {
744 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_ALREADY_ADDED=' . postRequestParameter('network_short_name') . '%}');
748 // Remove the 'ok' part
749 unsetPostRequestParameter('ok');
751 // Add the whole request to database
752 SQL_QUERY('INSERT INTO
753 `{?_MYSQL_PREFIX?}_network_data`
755 `' . implode('`, `', array_keys(postRequestArray())) . "`
757 '" . implode("','", array_values(postRequestArray())) . "'
758 )", __FUNCTION__, __LINE__);
760 // Add the id for output only
761 setPostRequestParameter('network_id', SQL_INSERTID());
764 if (!SQL_HASZEROAFFECTED()) {
765 // Successfully added
766 loadTemplate('admin_network_added', false, postRequestArray());
769 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_DATA_NOT_ADDED=' . postRequestParameter('network_short_name') . '%}');
773 // Displays selected networks for editing
774 function doAdminNetworkProcessHandleNetwork () {
775 // Do we have selections?
776 if (ifPostContainsSelections()) {
777 // Something has been selected, so start displaying one by one
779 foreach (postRequestParameter('sel') as $id => $sel) {
782 // Load this network's data
783 $networkData = getNetworkDataById($id);
785 // Do we have found the network?
786 if (count($networkData) > 0) {
787 if (isFormSent('edit')) {
788 // Add row template for editing
789 $OUT .= loadTemplate('admin_edit_networks_row', true, $networkData);
790 } elseif (isFormSent('delete')) {
791 // Add row template for deleting
792 $OUT .= loadTemplate('admin_delete_networks_row', true, $networkData);
795 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
801 // If we have no rows, we don't need to display the edit form
803 // Output main template
804 if (isFormSent('edit')) {
805 loadTemplate('admin_edit_networks', false, $OUT);
806 } elseif (isFormSent('delete')) {
807 loadTemplate('admin_delete_networks', false, $OUT);
810 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
813 // Don't display the list/add new form
814 $GLOBALS['network_display'] = false;
816 // Nothing selected/found
817 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_FOUND--}');
822 // Handle network type form
823 function doAdminNetworkProcessHandleNetworkType () {
824 // Do we have selections?
825 if (ifPostContainsSelections()) {
827 $networkData = getNetworkDataById(getRequestParameter('network'));
829 // Something has been selected, so start displaying one by one
831 foreach (postRequestParameter('sel') as $id => $sel) {
834 // Load this network's data
835 $networkTypeData = getNetworkTypeDataById($id);
837 // Do we have found the network?
838 if (count($networkTypeData) > 0) {
839 if (isFormSent('edit')) {
840 // Add row template for deleting
841 $OUT .= loadTemplate('admin_edit_network_types_row', true, $networkTypeData);
842 } elseif (isFormSent('delete')) {
843 // Add row template for deleting
844 $OUT .= loadTemplate('admin_delete_network_types_row', true, $networkTypeData);
847 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
853 // If we have no rows, we don't need to display the edit form
855 // Output main template
856 if (isFormSent('edit')) {
857 loadTemplate('admin_edit_network_types', false, $OUT);
858 } elseif (isFormSent('delete')) {
859 loadTemplate('admin_delete_network_types', false, $OUT);
862 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
865 // Don't display the list/add new form
866 $GLOBALS['network_display'] = false;
868 // Nothing selected/found
869 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_FOUND--}');
874 // Handle network request parameter form
875 function doAdminNetworkProcessHandleRequestParams () {
876 // Do we have selections?
877 if (ifPostContainsSelections()) {
879 $GLOBALS['network_params_disabled'] = array();
882 $networkData = getNetworkDataById(getRequestParameter('network'));
884 // Something has been selected, so start displaying one by one
886 foreach (postRequestParameter('sel') as $id => $sel) {
889 // Load this network's data
890 $networkRequestData = getNetworkRequestParamsDataById($id);
892 // Do we have found the network?
893 if (count($networkRequestData) > 0) {
894 if (isFormSent('edit')) {
895 // Add row template for deleting
896 $OUT .= loadTemplate('admin_edit_network_params_row', true, $networkRequestData);
897 } elseif (isFormSent('delete')) {
899 $networkRequestData['network_type_data'] = getNetworkTypeDataById($networkRequestData['network_type_id']);
901 // Add row template for deleting
902 $OUT .= loadTemplate('admin_delete_network_params_row', true, $networkRequestData);
905 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
911 // If we have no rows, we don't need to display the edit form
913 // Output main template
914 if (isFormSent('edit')) {
915 loadTemplate('admin_edit_network_params', false, $OUT);
916 } elseif (isFormSent('delete')) {
917 loadTemplate('admin_delete_network_params', false, $OUT);
920 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
923 // Don't display the list/add new form
924 $GLOBALS['network_display'] = false;
926 // Nothing selected/found
927 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
932 // Changes given networks
933 function doAdminNetworkProcessChangeNetwork () {
934 // Do we have selections?
935 if (ifPostContainsSelections()) {
936 // By default nothing is updated
939 // Something has been selected, so start updating them
940 foreach (postRequestParameter('sel') as $id => $sel) {
941 // Update this entry?
944 $networkData = array();
946 // Transfer whole array, except 'sel'
947 foreach (postRequestArray() as $key => $entry) {
948 // Skip 'sel' and submit button
949 if (in_array($key, array('sel', 'change'))) continue;
951 // Do we have this enty?
952 if (!isset($entry[$id])) {
953 // Not found, needs fixing
954 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
958 $networkData[$key] = $entry[$id];
961 // Update the network data
962 $updated += doNetworkUpdateDataByArray($id, $networkData);
966 // Do we have updates?
969 displayMessage('{%message,ADMIN_NETWORK_UPDATED=' . $updated . '%}');
972 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_CHANGED--}');
977 // Removes given networks
978 function doAdminNetworkProcessRemoveNetwork () {
979 // Do we have selections?
980 if (ifPostContainsSelections()) {
981 // By default nothing is removed
984 // Something has been selected, so start updating them
985 foreach (postRequestParameter('sel') as $id => $sel) {
986 // Update this entry?
989 $removed += doAdminRemoveNetworkEntry('data', 'network_id', $id);
993 // Do we have removes?
996 displayMessage('{%message,ADMIN_NETWORK_REMOVED=' . $removed . '%}');
999 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_REMOVED--}');
1004 // Add a network type handler if not yet found
1005 function doAdminNetworkProcessAddNetworkType () {
1006 // Is the network type handle already used with given network?
1007 if (isNetworkTypeHandleValid(postRequestParameter('network_type_handle'), getRequestParameter('network'))) {
1009 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED=' . postRequestParameter('network_type_handle') . '%}');
1011 // ... so abort here
1015 // Remove the 'ok' part
1016 unsetPostRequestParameter('ok');
1019 setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
1021 // Is network_type_banner_url set?
1022 if (postRequestParameter('network_type_banner_url') == '') {
1023 // Remove empty value to get a NULL for an optional entry
1024 unsetPostRequestParameter('network_type_banner_url');
1027 // Add the whole request to database
1028 SQL_QUERY('INSERT INTO
1029 `{?_MYSQL_PREFIX?}_network_types`
1031 `' . implode('`, `', array_keys(postRequestArray())) . "`
1033 '" . implode("','", array_values(postRequestArray())) . "'
1034 )", __FUNCTION__, __LINE__);
1037 if (!SQL_HASZEROAFFECTED()) {
1038 // Successfully added
1039 loadTemplate('admin_network_type_added', false, postRequestArray());
1042 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_NOT_ADDED=' . postRequestParameter('network_type_handle') . '%}');
1046 // Changes given network type handlers
1047 function doAdminNetworkProcessChangeNetworkType () {
1048 // Do we have selections?
1049 if (ifPostContainsSelections()) {
1050 // By default nothing is updated
1053 // Something has been selected, so start updating them
1054 foreach (postRequestParameter('sel') as $id => $sel) {
1055 // Update this entry?
1058 $networkTypeData = array();
1060 // Transfer whole array, except 'sel'
1061 foreach (postRequestArray() as $key => $entry) {
1062 // Skip 'sel' and submit button
1063 if (in_array($key, array('sel', 'change'))) continue;
1065 // Do we have this enty?
1066 if (!isset($entry[$id])) {
1067 // Not found, needs fixing
1068 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
1071 // Fix empty network_type_banner_url to NULL
1072 if (($key == 'network_type_banner_url') && (trim($entry[$id]) == '')) {
1078 $networkTypeData[$key] = $entry[$id];
1081 // Update the network data
1082 $updated += doNetworkUpdateTypeByArray($id, $networkTypeData);
1086 // Do we have updates?
1089 displayMessage('{%message,ADMIN_NETWORK_TYPES_UPDATED=' . $updated . '%}');
1092 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_CHANGED--}');
1097 // Changes given network request parameters
1098 function doAdminNetworkProcessChangeNetworkParam () {
1099 // Do we have selections?
1100 if (ifPostContainsSelections()) {
1101 // By default nothing is updated
1104 // Something has been selected, so start updating them
1105 foreach (postRequestParameter('sel') as $id => $sel) {
1106 // Update this entry?
1109 $networkParamsData = array();
1111 // Transfer whole array, except 'sel'
1112 foreach (postRequestArray() as $key => $entry) {
1113 // Skip 'sel' and submit button
1114 if (in_array($key, array('sel', 'change'))) continue;
1116 // Do we have this enty?
1117 if (!isset($entry[$id])) {
1118 // Not found, needs fixing
1119 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
1122 // Fix empty request_param_default to NULL
1123 if (($key == 'request_param_default') && (trim($entry[$id]) == '')) {
1129 $networkParamsData[$key] = $entry[$id];
1132 // Update the network data
1133 $updated += doNetworkUpdateParamsByArray($id, $networkParamsData);
1137 // Do we have updates?
1140 displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_UPDATED=' . $updated . '%}');
1143 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_CHANGED--}');
1148 // Removes given network type handlers
1149 function doAdminNetworkProcessRemoveNetworkType () {
1150 // Do we have selections?
1151 if (ifPostContainsSelections()) {
1152 // By default nothing is removed
1155 // Something has been selected, so start updating them
1156 foreach (postRequestParameter('sel') as $id => $sel) {
1157 // Update this entry?
1159 // Remove this entry
1160 $removed += doAdminRemoveNetworkEntry('types', 'network_type_id', $id);
1164 // Do we have removes?
1167 displayMessage('{%message,ADMIN_NETWORK_TYPES_REMOVED=' . $removed . '%}');
1170 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_REMOVED--}');
1175 // Removes given network request parameters
1176 function doAdminNetworkProcessRemoveNetworkParam () {
1177 // Do we have selections?
1178 if (ifPostContainsSelections()) {
1179 // By default nothing is removed
1182 // Something has been selected, so start updating them
1183 foreach (postRequestParameter('sel') as $id => $sel) {
1184 // Update this entry?
1186 // Remove this entry
1187 $removed += doAdminRemoveNetworkEntry('request_params', 'network_param_id', $id);
1191 // Do we have removes?
1194 displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_REMOVED=' . $removed . '%}');
1197 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_REMOVED--}');
1202 // Adds a request parameter to given network and type
1203 function doAdminNetworkProcessAddNetworkParam () {
1204 // Is the request parameter already used with given network?
1205 if (isNetworkRequestParameterValid(postRequestParameter('request_param_key'), postRequestParameter('network_type_id'), getRequestParameter('network'))) {
1207 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED=' . postRequestParameter('request_param_key') . '%}');
1209 // ... so abort here
1213 // Remove the 'ok' part
1214 unsetPostRequestParameter('ok');
1217 setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
1219 // Is request_param_default set?
1220 if (postRequestParameter('request_param_default') == '') {
1221 // Remove empty value to get a NULL for an optional entry
1222 unsetPostRequestParameter('request_param_default');
1225 // Add the whole request to database
1226 SQL_QUERY('INSERT INTO
1227 `{?_MYSQL_PREFIX?}_network_request_params`
1229 `' . implode('`, `', array_keys(postRequestArray())) . "`
1231 '" . implode("','", array_values(postRequestArray())) . "'
1232 )", __FUNCTION__, __LINE__);
1235 if (!SQL_HASZEROAFFECTED()) {
1236 // Successfully added
1237 loadTemplate('admin_network_request_param_added', false, postRequestArray());
1240 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED=' . postRequestParameter('request_param_key') . '%}');
1244 // Adds a API response array entry
1245 function doAdminNetworkProcessAddNetworkApiTranslation () {
1246 // Is the request parameter already used with given network?
1247 if (isNetworkApiTranslationValid(postRequestParameter('network_api_index'), postRequestParameter('network_type_id'), getRequestParameter('network'))) {
1249 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_API_TRANSLATION_ALREADY_ADDED=' . postRequestParameter('network_api_index') . '%}');
1251 // ... so abort here
1255 // Remove the 'ok' part
1256 unsetPostRequestParameter('ok');
1259 setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
1262 setPostRequestParameter('sort', (countSumTotalData(
1263 postRequestParameter('network_id'),
1264 'network_api_translation',
1268 sprintf(" AND `network_type_id`=%s", bigintval(postRequestParameter('network_type_id')))
1271 // Add the whole request to database
1272 SQL_QUERY('INSERT INTO
1273 `{?_MYSQL_PREFIX?}_network_api_translation`
1275 `' . implode('`, `', array_keys(postRequestArray())) . "`
1277 '" . implode("','", array_values(postRequestArray())) . "'
1278 )", __FUNCTION__, __LINE__);
1281 if (!SQL_HASZEROAFFECTED()) {
1282 // Successfully added
1283 loadTemplate('admin_network_api_translation_added', false, postRequestArray());
1286 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_API_TRANSLATION_NOT_ADDED=' . postRequestParameter('network_api_index') . '%}');
1290 // Do expression code for this extension
1291 function doExpressionNetwork ($data) {
1292 // Construct replacer
1293 $replacer = sprintf(
1294 "{DQUOTE} . %s(%s, '%s') . {DQUOTE}",
1296 $data['matches'][4][$data['key']],
1300 // Replace %network% with the current network id
1301 $replacer = str_replace('%network%', getCurrentNetworkId(), $replacer);
1304 $code = replaceExpressionCode($data, $replacer);