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, 2010 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('change')) || (isFormSent('remove'))) {
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('change')) && (!isFormSent('remove'))) {
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] = generateOptionList(
674 return $GLOBALS[__FUNCTION__][$default];
677 // Translates 'translate_name' for e.g. templates
678 function translateNetworkTranslationName ($name) {
679 // Get the message id
680 return getMessage('ADMIN_NETWORK_TRANSLATE_' . strtoupper($name) . '_NAME');
683 // Translates the network type handler (e.g. banner, paidmail) for templates
684 function translateNetworkTypeHandler ($type) {
685 // Get the message id
686 return getMessage('ADMIN_NETWORK_TYPES_' . strtoupper($type) . '');
689 // Translates request type
690 function translateNetworkRequestType ($type) {
691 // Get the message id
692 return getMessage('ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($type) . '');
695 // Translates request parameter
696 function translateNetworkRequestParameter ($param) {
697 // Get the message id
698 return getMessage('ADMIN_NETWORK_REQUEST_PARAMETER_' . strtoupper($param) . '');
701 // Translates API index
702 function translateNetworkApiIndex ($index) {
704 if (!isset($GLOBALS['network_api_index'])) {
705 // Get an array of all API array indexes
706 $GLOBALS['network_api_index'] = array();
709 $result = SQL_QUERY('SELECT
710 `network_api_id`, `network_api_index`, `network_translation_name`
712 `{?_MYSQL_PREFIX?}_network_api_translation`
714 `{?_MYSQL_PREFIX?}_network_translations`
716 `network_api_index`=`network_translation_id`
718 `sort` ASC', __FUNCTION__, __LINE__);
720 // Do we have entries?
721 if (SQL_NUMROWS($result) > 0) {
723 while ($row = SQL_FETCHARRAY($result)) {
724 // Add it to our global array
725 $GLOBALS['network_api_index'][$row['network_api_index']] = $row;
730 SQL_FREERESULT($result);
733 // Default name is unknown
736 // Is the entry there?
737 if (isset($GLOBALS['network_api_index'][$index])) {
739 $name = $GLOBALS['network_api_index'][$index]['network_translation_name'];
742 // Return translation
743 return translateNetworkTranslationName($name);
746 //------------------------------------------------------------------------------
747 // Call-back functions
748 //------------------------------------------------------------------------------
750 // Callback function to add new network
751 function doAdminNetworkProcessAddNetwork () {
752 // We can say here, the form is sent, so check if the network is already added
753 if (isNetworkNameValid(postRequestParameter('network_short_name'))) {
755 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_ALREADY_ADDED', postRequestParameter('network_short_name')));
759 // Remove the 'ok' part
760 unsetPostRequestParameter('ok');
762 // Add the whole request to database
763 SQL_QUERY('INSERT INTO
764 `{?_MYSQL_PREFIX?}_network_data`
766 `' . implode('`,`', array_keys(postRequestArray())) . "`
768 '" . implode("','", array_values(postRequestArray())) . "'
769 )", __FUNCTION__, __LINE__);
771 // Add the id for output only
772 setPostRequestParameter('network_id', SQL_INSERTID());
775 if (SQL_AFFECTEDROWS() == 1) {
776 // Successfully added
777 loadTemplate('admin_network_added', false, postRequestArray());
780 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_DATA_NOT_ADDED', postRequestParameter('network_short_name')));
784 // Displays selected networks for editing
785 function doAdminNetworkProcessHandleNetwork () {
786 // Do we have selections?
787 if (ifPostContainsSelections()) {
788 // Something has been selected, so start displaying one by one
790 foreach (postRequestParameter('sel') as $id => $sel) {
793 // Load this network's data
794 $networkData = getNetworkDataById($id);
796 // Do we have found the network?
797 if (count($networkData) > 0) {
798 if (isFormSent('edit')) {
799 // Add row template for editing
800 $OUT .= loadTemplate('admin_edit_networks_row', true, $networkData);
801 } elseif (isFormSent('delete')) {
802 // Add row template for deleting
803 $OUT .= loadTemplate('admin_delete_networks_row', true, $networkData);
806 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
812 // If we have no rows, we don't need to display the edit form
814 // Output main template
815 if (isFormSent('edit')) {
816 loadTemplate('admin_edit_networks', false, $OUT);
817 } elseif (isFormSent('delete')) {
818 loadTemplate('admin_delete_networks', false, $OUT);
821 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
824 // Don't display the list/add new form
825 $GLOBALS['network_display'] = false;
827 // Nothing selected/found
828 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_FOUND--}');
833 // Handle network type form
834 function doAdminNetworkProcessHandleNetworkType () {
835 // Do we have selections?
836 if (ifPostContainsSelections()) {
838 $networkData = getNetworkDataById(getRequestParameter('network'));
840 // Something has been selected, so start displaying one by one
842 foreach (postRequestParameter('sel') as $id => $sel) {
845 // Load this network's data
846 $networkTypeData = getNetworkTypeDataById($id);
848 // Do we have found the network?
849 if (count($networkTypeData) > 0) {
850 if (isFormSent('edit')) {
851 // Add row template for deleting
852 $OUT .= loadTemplate('admin_edit_network_types_row', true, $networkTypeData);
853 } elseif (isFormSent('delete')) {
854 // Add row template for deleting
855 $OUT .= loadTemplate('admin_delete_network_types_row', true, $networkTypeData);
858 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
864 // If we have no rows, we don't need to display the edit form
866 // Output main template
867 if (isFormSent('edit')) {
868 loadTemplate('admin_edit_network_types', false, $OUT);
869 } elseif (isFormSent('delete')) {
870 loadTemplate('admin_delete_network_types', false, $OUT);
873 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
876 // Don't display the list/add new form
877 $GLOBALS['network_display'] = false;
879 // Nothing selected/found
880 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_FOUND--}');
885 // Handle network request parameter form
886 function doAdminNetworkProcessHandleRequestParams () {
887 // Do we have selections?
888 if (ifPostContainsSelections()) {
890 $GLOBALS['network_params_disabled'] = array();
893 $networkData = getNetworkDataById(getRequestParameter('network'));
895 // Something has been selected, so start displaying one by one
897 foreach (postRequestParameter('sel') as $id => $sel) {
900 // Load this network's data
901 $networkRequestData = getNetworkRequestParamsDataById($id);
903 // Do we have found the network?
904 if (count($networkRequestData) > 0) {
905 if (isFormSent('edit')) {
906 // Add row template for deleting
907 $OUT .= loadTemplate('admin_edit_network_params_row', true, $networkRequestData);
908 } elseif (isFormSent('delete')) {
910 $networkRequestData['network_type_data'] = getNetworkTypeDataById($networkRequestData['network_type_id']);
912 // Add row template for deleting
913 $OUT .= loadTemplate('admin_delete_network_params_row', true, $networkRequestData);
916 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
922 // If we have no rows, we don't need to display the edit form
924 // Output main template
925 if (isFormSent('edit')) {
926 loadTemplate('admin_edit_network_params', false, $OUT);
927 } elseif (isFormSent('delete')) {
928 loadTemplate('admin_delete_network_params', false, $OUT);
931 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
934 // Don't display the list/add new form
935 $GLOBALS['network_display'] = false;
937 // Nothing selected/found
938 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
943 // Changes given networks
944 function doAdminNetworkProcessChangeNetwork () {
945 // Do we have selections?
946 if (ifPostContainsSelections()) {
947 // By default nothing is updated
950 // Something has been selected, so start updating them
951 foreach (postRequestParameter('sel') as $id => $sel) {
952 // Update this entry?
955 $networkData = array();
957 // Transfer whole array, except 'sel'
958 foreach (postRequestArray() as $key => $entry) {
959 // Skip 'sel' and submit button
960 if (in_array($key, array('sel', 'change'))) continue;
962 // Do we have this enty?
963 if (!isset($entry[$id])) {
964 // Not found, needs fixing
965 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
969 $networkData[$key] = $entry[$id];
972 // Update the network data
973 $updated += doNetworkUpdateDataByArray($id, $networkData);
977 // Do we have updates?
980 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_UPDATED', $updated));
983 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_CHANGED--}');
988 // Removes given networks
989 function doAdminNetworkProcessRemoveNetwork () {
990 // Do we have selections?
991 if (ifPostContainsSelections()) {
992 // By default nothing is removed
995 // Something has been selected, so start updating them
996 foreach (postRequestParameter('sel') as $id => $sel) {
997 // Update this entry?
1000 $removed += doAdminRemoveNetworkEntry('data', 'network_id', $id);
1004 // Do we have removes?
1007 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REMOVED', $removed));
1010 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_REMOVED--}');
1015 // Add a network type handler if not yet found
1016 function doAdminNetworkProcessAddNetworkType () {
1017 // Is the network type handle already used with given network?
1018 if (isNetworkTypeHandleValid(postRequestParameter('network_type_handle'), getRequestParameter('network'))) {
1020 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED', postRequestParameter('network_type_handle')));
1022 // ... so abort here
1026 // Remove the 'ok' part
1027 unsetPostRequestParameter('ok');
1030 setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
1032 // Is network_type_banner_url set?
1033 if (postRequestParameter('network_type_banner_url') == '') {
1034 // Remove empty value to get a NULL for an optional entry
1035 unsetPostRequestParameter('network_type_banner_url');
1038 // Add the whole request to database
1039 SQL_QUERY('INSERT INTO
1040 `{?_MYSQL_PREFIX?}_network_types`
1042 `' . implode('`,`', array_keys(postRequestArray())) . "`
1044 '" . implode("','", array_values(postRequestArray())) . "'
1045 )", __FUNCTION__, __LINE__);
1048 if (SQL_AFFECTEDROWS() == 1) {
1049 // Successfully added
1050 loadTemplate('admin_network_type_added', false, postRequestArray());
1053 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_NOT_ADDED', postRequestParameter('network_type_handle')));
1057 // Changes given network type handlers
1058 function doAdminNetworkProcessChangeNetworkType () {
1059 // Do we have selections?
1060 if (ifPostContainsSelections()) {
1061 // By default nothing is updated
1064 // Something has been selected, so start updating them
1065 foreach (postRequestParameter('sel') as $id => $sel) {
1066 // Update this entry?
1069 $networkTypeData = array();
1071 // Transfer whole array, except 'sel'
1072 foreach (postRequestArray() as $key => $entry) {
1073 // Skip 'sel' and submit button
1074 if (in_array($key, array('sel', 'change'))) continue;
1076 // Do we have this enty?
1077 if (!isset($entry[$id])) {
1078 // Not found, needs fixing
1079 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
1082 // Fix empty network_type_banner_url to NULL
1083 if (($key == 'network_type_banner_url') && (trim($entry[$id]) == '')) {
1089 $networkTypeData[$key] = $entry[$id];
1092 // Update the network data
1093 $updated += doNetworkUpdateTypeByArray($id, $networkTypeData);
1097 // Do we have updates?
1100 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_UPDATED', $updated));
1103 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_CHANGED--}');
1108 // Changes given network request parameters
1109 function doAdminNetworkProcessChangeNetworkParam () {
1110 // Do we have selections?
1111 if (ifPostContainsSelections()) {
1112 // By default nothing is updated
1115 // Something has been selected, so start updating them
1116 foreach (postRequestParameter('sel') as $id => $sel) {
1117 // Update this entry?
1120 $networkParamsData = array();
1122 // Transfer whole array, except 'sel'
1123 foreach (postRequestArray() as $key => $entry) {
1124 // Skip 'sel' and submit button
1125 if (in_array($key, array('sel', 'change'))) continue;
1127 // Do we have this enty?
1128 if (!isset($entry[$id])) {
1129 // Not found, needs fixing
1130 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
1133 // Fix empty request_param_default to NULL
1134 if (($key == 'request_param_default') && (trim($entry[$id]) == '')) {
1140 $networkParamsData[$key] = $entry[$id];
1143 // Update the network data
1144 $updated += doNetworkUpdateParamsByArray($id, $networkParamsData);
1148 // Do we have updates?
1151 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_UPDATED', $updated));
1154 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_CHANGED--}');
1159 // Removes given network type handlers
1160 function doAdminNetworkProcessRemoveNetworkType () {
1161 // Do we have selections?
1162 if (ifPostContainsSelections()) {
1163 // By default nothing is removed
1166 // Something has been selected, so start updating them
1167 foreach (postRequestParameter('sel') as $id => $sel) {
1168 // Update this entry?
1170 // Remove this entry
1171 $removed += doAdminRemoveNetworkEntry('types', 'network_type_id', $id);
1175 // Do we have removes?
1178 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_REMOVED', $removed));
1181 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_REMOVED--}');
1186 // Removes given network request parameters
1187 function doAdminNetworkProcessRemoveNetworkParam () {
1188 // Do we have selections?
1189 if (ifPostContainsSelections()) {
1190 // By default nothing is removed
1193 // Something has been selected, so start updating them
1194 foreach (postRequestParameter('sel') as $id => $sel) {
1195 // Update this entry?
1197 // Remove this entry
1198 $removed += doAdminRemoveNetworkEntry('request_params', 'network_param_id', $id);
1202 // Do we have removes?
1205 loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_REMOVED', $removed));
1208 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_REMOVED--}');
1213 // Adds a request parameter to given network and type
1214 function doAdminNetworkProcessAddNetworkParam () {
1215 // Is the request parameter already used with given network?
1216 if (isNetworkRequestParameterValid(postRequestParameter('request_param_key'), postRequestParameter('network_type_id'), getRequestParameter('network'))) {
1218 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED', postRequestParameter('request_param_key')));
1220 // ... so abort here
1224 // Remove the 'ok' part
1225 unsetPostRequestParameter('ok');
1228 setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
1230 // Is request_param_default set?
1231 if (postRequestParameter('request_param_default') == '') {
1232 // Remove empty value to get a NULL for an optional entry
1233 unsetPostRequestParameter('request_param_default');
1236 // Add the whole request to database
1237 SQL_QUERY('INSERT INTO
1238 `{?_MYSQL_PREFIX?}_network_request_params`
1240 `' . implode('`,`', array_keys(postRequestArray())) . "`
1242 '" . implode("','", array_values(postRequestArray())) . "'
1243 )", __FUNCTION__, __LINE__);
1246 if (SQL_AFFECTEDROWS() == 1) {
1247 // Successfully added
1248 loadTemplate('admin_network_request_param_added', false, postRequestArray());
1251 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED', postRequestParameter('request_param_key')));
1255 // Adds a API response array entry
1256 function doAdminNetworkProcessAddNetworkApiTranslation () {
1257 // Is the request parameter already used with given network?
1258 if (isNetworkApiTranslationValid(postRequestParameter('network_api_index'), postRequestParameter('network_type_id'), getRequestParameter('network'))) {
1260 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_API_TRANSLATION_ALREADY_ADDED', postRequestParameter('network_api_index')));
1262 // ... so abort here
1266 // Remove the 'ok' part
1267 unsetPostRequestParameter('ok');
1270 setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
1273 setPostRequestParameter('sort', (countSumTotalData(
1274 postRequestParameter('network_id'),
1275 'network_api_translation',
1279 sprintf(" AND `network_type_id`=%s", bigintval(postRequestParameter('network_type_id')))
1282 // Add the whole request to database
1283 SQL_QUERY('INSERT INTO
1284 `{?_MYSQL_PREFIX?}_network_api_translation`
1286 `' . implode('`,`', array_keys(postRequestArray())) . "`
1288 '" . implode("','", array_values(postRequestArray())) . "'
1289 )", __FUNCTION__, __LINE__);
1292 if (SQL_AFFECTEDROWS() == 1) {
1293 // Successfully added
1294 loadTemplate('admin_network_api_translation_added', false, postRequestArray());
1297 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_API_TRANSLATION_NOT_ADDED', postRequestParameter('network_api_index')));
1301 // Do expression code for this extension
1302 function doExpressionNetwork ($data) {
1303 // Construct replacer
1304 $replacer = sprintf(
1305 "{DQUOTE} . %s(%s, '%s') . {DQUOTE}",
1307 $data['matches'][4][$data['key']],
1311 // Replace %network% with the current network id
1312 $replacer = str_replace('%network%', getCurrentNetworkId(), $replacer);
1315 $code = replaceExpressionCode($data, $replacer);