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://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 (isGetRequestElementSet('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 (!isGetRequestElementSet('do')) {
77 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_DO_404--}');
81 // Create function name
82 $functionName = sprintf("doAdminNetworkProcess%s", capitalizeUnderscoreString(getRequestElement('do')));
84 // Is the function valid?
85 if (!function_exists($functionName)) {
86 // Invalid function name
87 debug_report_bug(__FUNCTION__, __LINE__, 'Invalid do ' . getRequestElement('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 isNetworkRequestElementValid ($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
505 if (!isset($GLOBALS[__FUNCTION__][$id])) {
506 // Generate output and cache it
507 $GLOBALS[__FUNCTION__][$id] = generateOptionList(
510 'network_type_handle',
514 "WHERE `network_id`=%s",
515 bigintval(getRequestElement('network'))
518 'translateNetworkTypeHandler'
523 return $GLOBALS[__FUNCTION__][$id];
526 // Generates an options list of all available (hard-coded) handlers
527 function generateNetworkTypesAvailableOptions () {
529 if (!isset($GLOBALS[__FUNCTION__])) {
531 $GLOBALS[__FUNCTION__] = generateOptionList(
567 $GLOBALS['network_types_disabled'],
568 'translateNetworkTypeHandler'
573 return $GLOBALS[__FUNCTION__];
576 // Generates an options list (somewhat getter) ofr request keys
577 function generateNetworkRequestKeyOptions () {
579 if (!isset($GLOBALS[__FUNCTION__])) {
580 // Generate and cache it
581 $GLOBALS[__FUNCTION__] = generateOptionList(
603 $GLOBALS['network_params_disabled'],
604 'translateNetworkRequestElement'
609 return $GLOBALS[__FUNCTION__];
612 // Generator (somewhat getter) for (return) array translation
613 function generateNetworkTranslationOptions ($default = '') {
615 if (!isset($GLOBALS[__FUNCTION__][$default])) {
616 // Generate and cache it
617 $GLOBALS[__FUNCTION__][$default] = generateOptionList(
618 'network_translations',
619 'network_translation_id',
620 'network_translation_name',
624 $GLOBALS['network_translation_disabled'],
625 'translateNetworkTranslationName'
630 return $GLOBALS[__FUNCTION__][$default];
633 // Generates an option list of request types
634 function generateNetworkRequestTypeOptions ($default = '') {
636 if (!isset($GLOBALS[__FUNCTION__][$default])) {
638 $GLOBALS[__FUNCTION__][$default] = generateOptionList(
645 '{--ADMIN_NETWORK_REQUEST_TYPE_GET--}',
646 '{--ADMIN_NETWORK_REQUEST_TYPE_POST--}'
653 return $GLOBALS[__FUNCTION__][$default];
656 // Generates an option list of network_api_active
657 function generateNetworkApiActiveOptions ($default = '') {
659 if (!isset($GLOBALS[__FUNCTION__][$default])) {
661 $GLOBALS[__FUNCTION__][$default] = generateYesNoOptionList($default);
665 return $GLOBALS[__FUNCTION__][$default];
668 // Translates 'translate_name' for e.g. templates
669 function translateNetworkTranslationName ($name) {
670 // Get the message id
671 return '{--ADMIN_NETWORK_TRANSLATE_' . strtoupper($name) . '_NAME--}';
674 // Translates the network type handler (e.g. banner, paidmail) for templates
675 function translateNetworkTypeHandler ($type) {
676 // Get the message id
677 return '{--ADMIN_NETWORK_TYPES_' . strtoupper($type) . '--}';
680 // Translates request type
681 function translateNetworkRequestType ($type) {
682 // Get the message id
683 return '{--ADMIN_NETWORK_REQUEST_TYPE_' . strtoupper($type) . '--}';
686 // Translates request parameter
687 function translateNetworkRequestElement ($param) {
688 // Get the message id
689 return '{--ADMIN_NETWORK_REQUEST_PARAMETER_' . strtoupper($param) . '--}';
692 // Translates API index
693 function translateNetworkApiIndex ($index) {
695 if (!isset($GLOBALS['network_api_index'])) {
696 // Get an array of all API array indexes
697 $GLOBALS['network_api_index'] = array();
700 $result = SQL_QUERY('SELECT
701 `network_api_id`,`network_api_index`,`network_translation_name`
703 `{?_MYSQL_PREFIX?}_network_api_translation`
705 `{?_MYSQL_PREFIX?}_network_translations`
707 `network_api_index`=`network_translation_id`
709 `sort` ASC', __FUNCTION__, __LINE__);
711 // Do we have entries?
712 if (!SQL_HASZERONUMS($result)) {
714 while ($row = SQL_FETCHARRAY($result)) {
715 // Add it to our global array
716 $GLOBALS['network_api_index'][$row['network_api_index']] = $row;
721 SQL_FREERESULT($result);
724 // Default name is unknown
727 // Is the entry there?
728 if (isset($GLOBALS['network_api_index'][$index])) {
730 $name = $GLOBALS['network_api_index'][$index]['network_translation_name'];
733 // Return translation
734 return translateNetworkTranslationName($name);
737 //------------------------------------------------------------------------------
738 // Call-back functions
739 //------------------------------------------------------------------------------
741 // Callback function to add new network
742 function doAdminNetworkProcessAddNetwork () {
743 // We can say here, the form is sent, so check if the network is already added
744 if (isNetworkNameValid(postRequestElement('network_short_name'))) {
746 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_ALREADY_ADDED=' . postRequestElement('network_short_name') . '%}');
750 // Remove the 'ok' part
751 unsetPostRequestElement('ok');
753 // Add the whole request to database
754 SQL_QUERY('INSERT INTO
755 `{?_MYSQL_PREFIX?}_network_data`
757 `' . implode('`,`', array_keys(postRequestArray())) . "`
759 '" . implode("','", array_values(postRequestArray())) . "'
760 )", __FUNCTION__, __LINE__);
762 // Add the id for output only
763 setPostRequestElement('network_id', SQL_INSERTID());
766 if (!SQL_HASZEROAFFECTED()) {
767 // Successfully added
768 loadTemplate('admin_network_added', false, postRequestArray());
771 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_DATA_NOT_ADDED=' . postRequestElement('network_short_name') . '%}');
775 // Displays selected networks for editing
776 function doAdminNetworkProcessHandleNetwork () {
777 // Do we have selections?
778 if (ifPostContainsSelections()) {
779 // Something has been selected, so start displaying one by one
781 foreach (postRequestElement('sel') as $id => $sel) {
784 // Load this network's data
785 $networkData = getNetworkDataById($id);
787 // Do we have found the network?
788 if (count($networkData) > 0) {
789 if (isFormSent('edit')) {
790 // Add row template for editing
791 $OUT .= loadTemplate('admin_edit_networks_row', true, $networkData);
792 } elseif (isFormSent('delete')) {
793 // Add row template for deleting
794 $OUT .= loadTemplate('admin_delete_networks_row', true, $networkData);
797 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
803 // If we have no rows, we don't need to display the edit form
805 // Output main template
806 if (isFormSent('edit')) {
807 loadTemplate('admin_edit_networks', false, $OUT);
808 } elseif (isFormSent('delete')) {
809 loadTemplate('admin_delete_networks', false, $OUT);
812 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
815 // Don't display the list/add new form
816 $GLOBALS['network_display'] = false;
818 // Nothing selected/found
819 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_FOUND--}');
824 // Handle network type form
825 function doAdminNetworkProcessHandleNetworkType () {
826 // Do we have selections?
827 if (ifPostContainsSelections()) {
829 $networkData = getNetworkDataById(getRequestElement('network'));
831 // Something has been selected, so start displaying one by one
833 foreach (postRequestElement('sel') as $id => $sel) {
836 // Load this network's data
837 $networkTypeData = getNetworkTypeDataById($id);
839 // Do we have found the network?
840 if (count($networkTypeData) > 0) {
841 if (isFormSent('edit')) {
842 // Add row template for deleting
843 $OUT .= loadTemplate('admin_edit_network_types_row', true, $networkTypeData);
844 } elseif (isFormSent('delete')) {
845 // Add row template for deleting
846 $OUT .= loadTemplate('admin_delete_network_types_row', true, $networkTypeData);
849 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
855 // If we have no rows, we don't need to display the edit form
857 // Output main template
858 if (isFormSent('edit')) {
859 loadTemplate('admin_edit_network_types', false, $OUT);
860 } elseif (isFormSent('delete')) {
861 loadTemplate('admin_delete_network_types', false, $OUT);
864 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
867 // Don't display the list/add new form
868 $GLOBALS['network_display'] = false;
870 // Nothing selected/found
871 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_FOUND--}');
876 // Handle network request parameter form
877 function doAdminNetworkProcessHandleRequestParams () {
878 // Do we have selections?
879 if (ifPostContainsSelections()) {
881 $GLOBALS['network_params_disabled'] = array();
884 $networkData = getNetworkDataById(getRequestElement('network'));
886 // Something has been selected, so start displaying one by one
888 foreach (postRequestElement('sel') as $id => $sel) {
891 // Load this network's data
892 $networkRequestData = getNetworkRequestParamsDataById($id);
894 // Do we have found the network?
895 if (count($networkRequestData) > 0) {
896 if (isFormSent('edit')) {
897 // Add row template for deleting
898 $OUT .= loadTemplate('admin_edit_network_params_row', true, $networkRequestData);
899 } elseif (isFormSent('delete')) {
901 $networkRequestData['network_type_data'] = getNetworkTypeDataById($networkRequestData['network_type_id']);
903 // Add row template for deleting
904 $OUT .= loadTemplate('admin_delete_network_params_row', true, $networkRequestData);
907 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
913 // If we have no rows, we don't need to display the edit form
915 // Output main template
916 if (isFormSent('edit')) {
917 loadTemplate('admin_edit_network_params', false, $OUT);
918 } elseif (isFormSent('delete')) {
919 loadTemplate('admin_delete_network_params', false, $OUT);
922 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
925 // Don't display the list/add new form
926 $GLOBALS['network_display'] = false;
928 // Nothing selected/found
929 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
934 // Changes given networks
935 function doAdminNetworkProcessChangeNetwork () {
936 // Do we have selections?
937 if (ifPostContainsSelections()) {
938 // By default nothing is updated
941 // Something has been selected, so start updating them
942 foreach (postRequestElement('sel') as $id => $sel) {
943 // Update this entry?
946 $networkData = array();
948 // Transfer whole array, except 'sel'
949 foreach (postRequestArray() as $key => $entry) {
950 // Skip 'sel' and submit button
951 if (in_array($key, array('sel', 'do_edit'))) {
955 // Do we have this enty?
956 if (!isset($entry[$id])) {
957 // Not found, needs fixing
958 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
962 $networkData[$key] = $entry[$id];
965 // Update the network data
966 $updated += doNetworkUpdateDataByArray($id, $networkData);
970 // Do we have updates?
973 displayMessage('{%message,ADMIN_NETWORK_UPDATED=' . $updated . '%}');
976 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_CHANGED--}');
981 // Removes given networks
982 function doAdminNetworkProcessRemoveNetwork () {
983 // Do we have selections?
984 if (ifPostContainsSelections()) {
985 // By default nothing is removed
988 // Something has been selected, so start updating them
989 foreach (postRequestElement('sel') as $id => $sel) {
990 // Update this entry?
993 $removed += doAdminRemoveNetworkEntry('data', 'network_id', $id);
997 // Do we have removes?
1000 displayMessage('{%message,ADMIN_NETWORK_REMOVED=' . $removed . '%}');
1003 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_REMOVED--}');
1008 // Add a network type handler if not yet found
1009 function doAdminNetworkProcessAddNetworkType () {
1010 // Is the network type handle already used with given network?
1011 if (isNetworkTypeHandleValid(postRequestElement('network_type_handle'), getRequestElement('network'))) {
1013 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED=' . postRequestElement('network_type_handle') . '%}');
1015 // ... so abort here
1019 // Remove the 'ok' part
1020 unsetPostRequestElement('ok');
1023 setPostRequestElement('network_id', bigintval(getRequestElement('network')));
1025 // Is network_type_banner_url set?
1026 if (postRequestElement('network_type_banner_url') == '') {
1027 // Remove empty value to get a NULL for an optional entry
1028 unsetPostRequestElement('network_type_banner_url');
1031 // Add the whole request to database
1032 SQL_QUERY('INSERT INTO
1033 `{?_MYSQL_PREFIX?}_network_types`
1035 `' . implode('`,`', array_keys(postRequestArray())) . "`
1037 '" . implode("','", array_values(postRequestArray())) . "'
1038 )", __FUNCTION__, __LINE__);
1041 if (!SQL_HASZEROAFFECTED()) {
1042 // Successfully added
1043 loadTemplate('admin_network_type_added', false, postRequestArray());
1046 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_TYPES_NOT_ADDED=' . postRequestElement('network_type_handle') . '%}');
1050 // Changes given network type handlers
1051 function doAdminNetworkProcessChangeNetworkType () {
1052 // Do we have selections?
1053 if (ifPostContainsSelections()) {
1054 // By default nothing is updated
1057 // Something has been selected, so start updating them
1058 foreach (postRequestElement('sel') as $id => $sel) {
1059 // Update this entry?
1062 $networkTypeData = array();
1064 // Transfer whole array, except 'sel'
1065 foreach (postRequestArray() as $key => $entry) {
1066 // Skip 'sel' and submit button
1067 if (in_array($key, array('sel', 'do_edit'))) {
1071 // Do we have this enty?
1072 if (!isset($entry[$id])) {
1073 // Not found, needs fixing
1074 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
1077 // Fix empty network_type_banner_url to NULL
1078 if (($key == 'network_type_banner_url') && (trim($entry[$id]) == '')) {
1084 $networkTypeData[$key] = $entry[$id];
1087 // Update the network data
1088 $updated += doNetworkUpdateTypeByArray($id, $networkTypeData);
1092 // Do we have updates?
1095 displayMessage('{%message,ADMIN_NETWORK_TYPES_UPDATED=' . $updated . '%}');
1098 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_CHANGED--}');
1103 // Changes given network request parameters
1104 function doAdminNetworkProcessChangeNetworkParam () {
1105 // Do we have selections?
1106 if (ifPostContainsSelections()) {
1107 // By default nothing is updated
1110 // Something has been selected, so start updating them
1111 foreach (postRequestElement('sel') as $id => $sel) {
1112 // Update this entry?
1115 $networkParamsData = array();
1117 // Transfer whole array, except 'sel'
1118 foreach (postRequestArray() as $key => $entry) {
1119 // Skip 'sel' and submit button
1120 if (in_array($key, array('sel', 'do_edit'))) {
1124 // Do we have this enty?
1125 if (!isset($entry[$id])) {
1126 // Not found, needs fixing
1127 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
1130 // Fix empty request_param_default to NULL
1131 if (($key == 'request_param_default') && (trim($entry[$id]) == '')) {
1137 $networkParamsData[$key] = $entry[$id];
1140 // Update the network data
1141 $updated += doNetworkUpdateParamsByArray($id, $networkParamsData);
1145 // Do we have updates?
1148 displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_UPDATED=' . $updated . '%}');
1151 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_CHANGED--}');
1156 // Removes given network type handlers
1157 function doAdminNetworkProcessRemoveNetworkType () {
1158 // Do we have selections?
1159 if (ifPostContainsSelections()) {
1160 // By default nothing is removed
1163 // Something has been selected, so start updating them
1164 foreach (postRequestElement('sel') as $id => $sel) {
1165 // Update this entry?
1167 // Remove this entry
1168 $removed += doAdminRemoveNetworkEntry('types', 'network_type_id', $id);
1172 // Do we have removes?
1175 displayMessage('{%message,ADMIN_NETWORK_TYPES_REMOVED=' . $removed . '%}');
1178 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_REMOVED--}');
1183 // Removes given network request parameters
1184 function doAdminNetworkProcessRemoveNetworkParam () {
1185 // Do we have selections?
1186 if (ifPostContainsSelections()) {
1187 // By default nothing is removed
1190 // Something has been selected, so start updating them
1191 foreach (postRequestElement('sel') as $id => $sel) {
1192 // Update this entry?
1194 // Remove this entry
1195 $removed += doAdminRemoveNetworkEntry('request_params', 'network_param_id', $id);
1199 // Do we have removes?
1202 displayMessage('{%message,ADMIN_NETWORK_REQUEST_PARAMETER_REMOVED=' . $removed . '%}');
1205 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_REMOVED--}');
1210 // Adds a request parameter to given network and type
1211 function doAdminNetworkProcessAddNetworkParam () {
1212 // Is the request parameter already used with given network?
1213 if (isNetworkRequestElementValid(postRequestElement('request_param_key'), postRequestElement('network_type_id'), getRequestElement('network'))) {
1215 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED=' . postRequestElement('request_param_key') . '%}');
1217 // ... so abort here
1221 // Remove the 'ok' part
1222 unsetPostRequestElement('ok');
1225 setPostRequestElement('network_id', bigintval(getRequestElement('network')));
1227 // Is request_param_default set?
1228 if (postRequestElement('request_param_default') == '') {
1229 // Remove empty value to get a NULL for an optional entry
1230 unsetPostRequestElement('request_param_default');
1233 // Add the whole request to database
1234 SQL_QUERY('INSERT INTO
1235 `{?_MYSQL_PREFIX?}_network_request_params`
1237 `' . implode('`,`', array_keys(postRequestArray())) . "`
1239 '" . implode("','", array_values(postRequestArray())) . "'
1240 )", __FUNCTION__, __LINE__);
1243 if (!SQL_HASZEROAFFECTED()) {
1244 // Successfully added
1245 loadTemplate('admin_network_request_param_added', false, postRequestArray());
1248 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED=' . postRequestElement('request_param_key') . '%}');
1252 // Adds a API response array entry
1253 function doAdminNetworkProcessAddNetworkApiTranslation () {
1254 // Is the request parameter already used with given network?
1255 if (isNetworkApiTranslationValid(postRequestElement('network_api_index'), postRequestElement('network_type_id'), getRequestElement('network'))) {
1257 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_API_TRANSLATION_ALREADY_ADDED=' . postRequestElement('network_api_index') . '%}');
1259 // ... so abort here
1263 // Remove the 'ok' part
1264 unsetPostRequestElement('ok');
1267 setPostRequestElement('network_id', bigintval(getRequestElement('network')));
1270 setPostRequestElement('sort', (countSumTotalData(
1271 postRequestElement('network_id'),
1272 'network_api_translation',
1276 sprintf(" AND `network_type_id`=%s", bigintval(postRequestElement('network_type_id')))
1279 // Add the whole request to database
1280 SQL_QUERY('INSERT INTO
1281 `{?_MYSQL_PREFIX?}_network_api_translation`
1283 `' . implode('`,`', array_keys(postRequestArray())) . "`
1285 '" . implode("','", array_values(postRequestArray())) . "'
1286 )", __FUNCTION__, __LINE__);
1289 if (!SQL_HASZEROAFFECTED()) {
1290 // Successfully added
1291 loadTemplate('admin_network_api_translation_added', false, postRequestArray());
1294 loadTemplate('admin_settings_unsaved', false, '{%message,ADMIN_NETWORK_API_TRANSLATION_NOT_ADDED=' . postRequestElement('network_api_index') . '%}');
1298 // Do expression code for this extension
1299 function doExpressionNetwork ($data) {
1300 // Construct replacer
1301 $replacer = sprintf(
1302 "{DQUOTE} . %s(%s, '%s') . {DQUOTE}",
1304 $data['matches'][4][$data['key']],
1308 // Replace %network% with the current network id
1309 $replacer = str_replace('%network%', getCurrentNetworkId(), $replacer);
1312 $code = replaceExpressionCode($data, $replacer);