]> git.mxchange.org Git - mailer.git/blob - inc/libs/network_functions.php
db658e0a61d9a8fe7a40027307e349709938cb9a
[mailer.git] / inc / libs / network_functions.php
1 <?php
2 /************************************************************************
3  * Mailer v0.2.1-FINAL                                Start: 11/04/2009 *
4  * ===================                          Last change: 11/04/2009 *
5  *                                                                      *
6  * -------------------------------------------------------------------- *
7  * File              : network_functions.php                            *
8  * -------------------------------------------------------------------- *
9  * Short description : Functions for ext-network                        *
10  * -------------------------------------------------------------------- *
11  * Kurzbeschreibung  : Funktionen fuer ext-network                      *
12  * -------------------------------------------------------------------- *
13  * $Revision::                                                        $ *
14  * $Date::                                                            $ *
15  * $Tag:: 0.2.1-FINAL                                                 $ *
16  * $Author::                                                          $ *
17  * Needs to be in all Files and every File needs "svn propset           *
18  * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
19  * -------------------------------------------------------------------- *
20  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
21  * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
22  * For more information visit: http://www.mxchange.org                  *
23  *                                                                      *
24  * This program is free software; you can redistribute it and/or modify *
25  * it under the terms of the GNU General Public License as published by *
26  * the Free Software Foundation; either version 2 of the License, or    *
27  * (at your option) any later version.                                  *
28  *                                                                      *
29  * This program is distributed in the hope that it will be useful,      *
30  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
31  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the        *
32  * GNU General Public License for more details.                         *
33  *                                                                      *
34  * You should have received a copy of the GNU General Public License    *
35  * along with this program; if not, write to the Free Software          *
36  * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston,               *
37  * MA  02110-1301  USA                                                  *
38  ************************************************************************/
39
40 // Some security stuff...
41 if (!defined('__SECURITY')) {
42         die();
43 } // END - if
44
45 // Private setter for current network id
46 function setCurrentNetworkId ($id) {
47         $GLOBALS['current_network_id'] = bigintval($id);
48 }
49
50 // Private getter for current network id
51 function getCurrentNetworkId () {
52         return $GLOBALS['current_network_id'];
53 }
54
55 // Handle a (maybe) sent form here
56 function doNetworkHandleForm () {
57         // Was the form sent?
58         if ((isFormSent()) || (isFormSent('edit')) || (isFormSent('del')) || (isFormSent('change')) || (isFormSent('remove'))) {
59                 // Do we have a 'do'?
60                 if (isGetRequestParameterSet('do')) {
61                         // Process the request
62                         doAdminNetworkProcessForm();
63                 } else {
64                         // No 'do' found
65                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_DO_404--}');
66                 }
67         } // END - if
68 }
69
70 // Processes an admin form
71 function doAdminNetworkProcessForm () {
72         // Form really sent?
73         if ((!isFormSent()) && (!isFormSent('edit')) && (!isFormSent('del')) && (!isFormSent('change')) && (!isFormSent('remove'))) {
74                 // Abort here
75                 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_FORM_NOT_SENT--}');
76                 return;
77         } elseif (!isGetRequestParameterSet('do')) {
78                 // No 'do' found
79                 loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_DO_404--}');
80                 return;
81         }
82
83         // Create function name
84         $functionName = sprintf("doAdminNetworkProcess%sForm", ucfirst(strtolower(getRequestParameter('do'))));
85
86         // Is the function valid?
87         if (!function_exists($functionName)) {
88                 // Invalid function name
89                 debug_report_bug(__FUNCTION__, __LINE__, 'Invalid do ' . getRequestParameter('do') . ', function ' . $functionName .' does not exist.', false);
90         } // END - if
91
92         // Call-back the method handling our request
93         call_user_func($functionName);
94 }
95
96 // Checks wether the (short) network name is already used (valid)
97 function isNetworkNameValid ($name) {
98         // Query for it
99         $result = SQL_QUERY_ESC("SELECT `network_id` FROM `{?_MYSQL_PREFIX?}_network_data` WHERE `network_short_name`='%s' LIMIT 1",
100                 array($name), __FUNCTION__, __LINE__);
101
102         // Does it exist?
103         $isValid = (SQL_NUMROWS($result) == 1);
104
105         // Free result
106         SQL_FREERESULT($result);
107
108         // Return result
109         return $isValid;
110 }
111
112 // Checks wether the given network type is already used (valid)
113 function isNetworkTypeHandleValid ($type, $networkId) {
114         // Query for it
115         $result = SQL_QUERY_ESC("SELECT `network_type_id` FROM `{?_MYSQL_PREFIX?}_network_types` WHERE `network_id`=%s AND `network_type_handle`='%s' LIMIT 1",
116                 array($networkId, $type), __FUNCTION__, __LINE__);
117
118         // Does it exist?
119         $isValid = (SQL_NUMROWS($result) == 1);
120
121         // Free result
122         SQL_FREERESULT($result);
123
124         // Return result
125         return $isValid;
126 }
127
128 // Checks wether the given network request parameter is already used (valid)
129 function isNetworkRequestParameterValid ($key, $type, $networkId) {
130         // Query for it
131         $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",
132                 array($networkId, $type, $key), __FUNCTION__, __LINE__);
133
134         // Does it exist?
135         $isValid = (SQL_NUMROWS($result) == 1);
136
137         // Free result
138         SQL_FREERESULT($result);
139
140         // Return result
141         return $isValid;
142 }
143
144 // "Getter" for a network's data by provided id number
145 function getNetworkDataById ($id, $column = '') {
146         // Ids lower one are not accepted
147         if ($id < 1) {
148                 // Not good, should be fixed
149                 debug_report_bug(__FUNCTION__, __LINE__, 'Network id ' . $id . ' is smaller than 1.');
150         } // END - if
151
152         // Set current network id
153         setCurrentNetworkId($id);
154
155         // Is it cached?
156         if (!isset($GLOBALS['network_data'][$id])) {
157                 // By default we have no data
158                 $GLOBALS['network_data'][$id] = array();
159
160                 // Query for the network data
161                 $result = SQL_QUERY_ESC("SELECT
162         `network_id`, `network_short_name`, `network_title`, `network_reflink`, `network_data_seperator`, `network_row_seperator`, `network_request_type`, `network_charset`
163 FROM
164         `{?_MYSQL_PREFIX?}_network_data`
165 WHERE
166         `network_id`=%s
167 LIMIT 1",
168                         array(bigintval($id)), __FUNCTION__, __LINE__);
169
170                 // Do we have an entry?
171                 if (SQL_NUMROWS($result) == 1) {
172                         // Then get it
173                         $GLOBALS['network_data'][$id] = SQL_FETCHARRAY($result);
174                 } // END - if
175
176                 // Free result
177                 SQL_FREERESULT($result);
178         } // END - if
179
180         // Return result
181         if (empty($column)) {
182                 // Return array
183                 return $GLOBALS['network_data'][$id];
184         } else {
185                 // Return column
186                 return $GLOBALS['network_data'][$id][$column];
187         }
188 }
189
190 // "Getter" for a network's data by provided type id number
191 function getNetworkDataByTypeId ($id, $column = '') {
192         // Ids lower one are not accepted
193         if ($id < 1) {
194                 // Not good, should be fixed
195                 debug_report_bug(__FUNCTION__, __LINE__, 'Network type id ' . $id . ' is smaller than 1.');
196         } // END - if
197
198         // Set current network id
199         setCurrentNetworkId($id);
200
201         // Is it cached?
202         if (!isset($GLOBALS['network_data'][$id])) {
203                 // By default we have no data
204                 $GLOBALS['network_data'][$id] = array();
205
206                 // Query for the network data
207                 $result = SQL_QUERY_ESC("SELECT
208         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`,
209         t.`network_type_handle`, t.`network_type_api_url`, t.`network_type_click_url`, t.`network_type_banner_url`
210 FROM
211         `{?_MYSQL_PREFIX?}_network_data` AS d
212 LEFT JOIN
213         `{?_MYSQL_PREFIX?}_network_types` AS t
214 ON
215         d.`network_id`=t.`network_id`
216 WHERE
217         t.`network_type_id`=%s
218 LIMIT 1",
219                         array(bigintval($id)), __FUNCTION__, __LINE__);
220
221                 // Do we have an entry?
222                 if (SQL_NUMROWS($result) == 1) {
223                         // Then get it
224                         $GLOBALS['network_data'][$id] = SQL_FETCHARRAY($result);
225                 } // END - if
226
227                 // Free result
228                 SQL_FREERESULT($result);
229         } // END - if
230
231         // Return result
232         if (empty($column)) {
233                 // Return array
234                 return $GLOBALS['network_data'][$id];
235         } else {
236                 // Return column
237                 return $GLOBALS['network_data'][$id][$column];
238         }
239 }
240
241 // "Getter" for a network type data by provided id number
242 function getNetworkTypeDataById ($id) {
243         // Ids lower one are not accepted
244         if ($id < 1) {
245                 // Not good, should be fixed
246                 debug_report_bug(__FUNCTION__, __LINE__, 'Network type id ' . $id . ' is smaller than 1.');
247         } // END - if
248
249         // By default we have no data
250         $GLOBALS['network_type_data'][$id] = array();
251
252         // Query for the network data
253         $result = SQL_QUERY_ESC("SELECT
254         `network_type_id`, `network_id`, `network_type_handle`, `network_type_api_url`, `network_type_click_url`, `network_type_banner_url`
255 FROM
256         `{?_MYSQL_PREFIX?}_network_types`
257 WHERE
258         `network_type_id`=%s
259 LIMIT 1",
260                 array(bigintval($id)), __FUNCTION__, __LINE__);
261
262         // Do we have an entry?
263         if (SQL_NUMROWS($result) == 1) {
264                 // Then get it
265                 $GLOBALS['network_type_data'][$id] = SQL_FETCHARRAY($result);
266         } // END - if
267
268         // Free result
269         SQL_FREERESULT($result);
270
271         // Return result
272         return $GLOBALS['network_type_data'][$id];
273 }
274
275 // "Getter" for a network request parameter data by provided id number
276 function getNetworkRequestParamsDataById ($id) {
277         // Ids lower one are not accepted
278         if ($id < 1) {
279                 // Not good, should be fixed
280                 debug_report_bug(__FUNCTION__, __LINE__, 'Network request parameter id ' . $id . ' is smaller than 1.');
281         } // END - if
282
283         // By default we have no data
284         $networkRequestData = array();
285
286         // Query for the network data
287         $result = SQL_QUERY_ESC("SELECT
288         `network_param_id`, `network_id`, `network_type_id`, `request_param_key`, `request_param_value`, `request_param_default`
289 FROM
290         `{?_MYSQL_PREFIX?}_network_request_params`
291 WHERE
292         `network_param_id`=%s
293 LIMIT 1",
294                 array(bigintval($id)), __FUNCTION__, __LINE__);
295
296         // Do we have an entry?
297         if (SQL_NUMROWS($result) == 1) {
298                 // Then get it
299                 $networkRequestData = SQL_FETCHARRAY($result);
300         } // END - if
301
302         // Free result
303         SQL_FREERESULT($result);
304
305         // Return result
306         return $networkRequestData;
307 }
308
309 // Updates given network (id) with data from array
310 function doNetworkUpdateDataByArray ($id, $networkData) {
311         // Ids lower one are not accepted
312         if ($id < 1) {
313                 // Not good, should be fixed
314                 debug_report_bug(__FUNCTION__, __LINE__, 'Network id ' . $id . ' is smaller than 1.');
315         } // END - if
316
317         // Just call our inner method
318         return adminSaveSettings($networkData, '_network_data', sprintf("`network_id`=%s", bigintval($id)), array(), false, false);
319 }
320
321 // Updates given network type handler (id) with data from array
322 function doNetworkUpdateTypeByArray ($id, $networkTypeData) {
323         // Ids lower one are not accepted
324         if ($id < 1) {
325                 // Not good, should be fixed
326                 debug_report_bug(__FUNCTION__, __LINE__, 'Network type handler id ' . $id . ' is smaller than 1.');
327         } // END - if
328
329         // Just call our inner method
330         return adminSaveSettings($networkTypeData, '_network_types', sprintf("`network_type_id`=%s", bigintval($id)), array(), false, false);
331 }
332
333 // Updates given network request parameters (id) with data from array
334 function doNetworkUpdateParamsByArray ($id, $networkParamData) {
335         // Ids lower one are not accepted
336         if ($id < 1) {
337                 // Not good, should be fixed
338                 debug_report_bug(__FUNCTION__, __LINE__, 'Network request parameter id ' . $id . ' is smaller than 1.');
339         } // END - if
340
341         // Just call our inner method
342         return adminSaveSettings($networkParamData, '_network_request_params', sprintf("`network_param_id`=%s", bigintval($id)), array(), false, false);
343 }
344
345 // Removes given network entry
346 function doAdminRemoveNetworkEntry ($table, $column, $id, $limit = 1) {
347         // Remove the entry
348         SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_network_%s` WHERE `%s`=%s LIMIT %s",
349                 array($table, $column, $id, $limit), __FUNCTION__, __LINE__);
350
351         // Return affected rows
352         return SQL_AFFECTEDROWS();
353 }
354
355 // Generates a list of networks for given script and returns it
356 function generateAdminNetworkList () {
357         // Init output
358         $content = '';
359
360         // Query for all networks
361         $result = SQL_QUERY('SELECT
362         `network_id`, `network_short_name`, `network_title`
363 FROM
364         `{?_MYSQL_PREFIX?}_network_data`
365 ORDER BY
366         `network_short_name` ASC', __FUNCTION__, __LINE__);
367
368         // Do we have entries?
369         if (!SQL_HASZERONUMS($result)) {
370                 // List all entries
371                 $rows = array();
372                 while ($row = SQL_FETCHARRAY($result)) {
373                         // Is this valid, then add it
374                         if ((is_array($row)) && (isset($row['network_id']))) {
375                                 // Add entry
376                                 $rows[$row['network_id']] = $row;
377                         } // END - if
378                 } // END - while
379
380                 // Generate the selection box
381                 $content = generateSelectionBoxFromArray($rows, 'network', 'network_id');
382         } else {
383                 // Nothing selected
384                 $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
385         }
386
387         // Free the result
388         SQL_FREERESULT($result);
389
390         // Return the list
391         return $content;
392 }
393
394 // Generator (somewhat getter) for a list of network types for given network id
395 function generateAdminNetworkTypeList ($networkId) {
396         // Init content
397         $content = '';
398
399         // Query all types of this network
400         $result = SQL_QUERY_ESC("SELECT
401         `network_type_id`, `network_type_handle`
402 FROM
403         `{?_MYSQL_PREFIX?}_network_types`
404 WHERE
405         `network_id`=%s
406 ORDER BY
407         `network_type_handle` ASC",
408                 array(
409                         bigintval($networkId)
410                 ), __FUNCTION__, __LINE__);
411
412         // Do we have entries?
413         if (!SQL_HASZERONUMS($result)) {
414                 // List all entries
415                 $rows = array();
416                 while ($row = SQL_FETCHARRAY($result)) {
417                         // Is this valid, then add it
418                         if ((is_array($row)) && (isset($row['network_type_id']))) {
419                                 // Add entry
420                                 $rows[$row['network_type_id']] = $row;
421                         } // END - if
422                 } // END - while
423
424                 // Generate the selection box
425                 $content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id');
426         } else {
427                 // Nothing selected
428                 $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
429         }
430
431         // Free the result
432         SQL_FREERESULT($result);
433
434         // Return content
435         return $content;
436 }
437
438 // Generator (somewhat getter) for a list of network types for all types
439 function generateAdminDistinctNetworkTypeList () {
440         // Init content
441         $content = '';
442
443         // Query all types of this network
444         $result = SQL_QUERY('SELECT
445         t.`network_type_id`, t.`network_type_handle`, d.`network_title`
446 FROM
447         `{?_MYSQL_PREFIX?}_network_types` AS t
448 LEFT JOIN
449         `{?_MYSQL_PREFIX?}_network_data` AS d
450 ON
451         t.`network_id`=d.`network_id`
452 ORDER BY
453         d.`network_short_name` ASC,
454         t.`network_type_handle` ASC', __FUNCTION__, __LINE__);
455
456         // Do we have entries?
457         if (!SQL_HASZERONUMS($result)) {
458                 // List all entries
459                 $rows = array();
460                 while ($row = SQL_FETCHARRAY($result)) {
461                         // Is this valid, then add it
462                         if ((is_array($row)) && (isset($row['network_type_id']))) {
463                                 // Add entry
464                                 $rows[$row['network_type_id']] = $row;
465                         } // END - if
466                 } // END - while
467
468                 // Generate the selection box
469                 $content = generateSelectionBoxFromArray($rows, 'network_type', 'network_type_id', '', '_title');
470         } else {
471                 // Nothing selected
472                 $content = loadTemplate('admin_settings_unsaved', false, '{--ADMIN_ENTRIES_404--}');
473         }
474
475         // Free the result
476         SQL_FREERESULT($result);
477         //* DEBUG: */ die('<pre>'.encodeEntities($content).'</pre>');
478
479         // Return content
480         return $content;
481 }
482
483 // Generator (somewhat getter) for network type options
484 function generateNetworkTypeOptions ($id) {
485         // Is this an array, then we just came back from edit/delete actions
486         if (is_array($id)) $id = '';
487
488         // Is this cached?
489         if (!isset($GLOBALS['network_type_options'][$id])) {
490                 // Generate output and cache it
491                 $GLOBALS['network_type_options'][$id] = generateOptionList(
492                         'network_types',
493                         'network_type_id',
494                         'network_type_handle',
495                         $id,
496                         '',
497                         sprintf(
498                                 "WHERE `network_id`=%s",
499                                 bigintval(getRequestParameter('network'))
500                         )
501                 );
502         } // END - if
503
504         // Return content
505         return $GLOBALS['network_type_options'][$id];
506 }
507
508 // Generator (somewhat getter) for request key options
509 function generateNetworkRequestKeyOptions ($key) {
510         // Is it cached?
511         if (!isset($GLOBALS['network_request_param_key'][$key])) {
512                 // Generate and cache it
513                 $GLOBALS['network_request_param_key'][$key] = generateOptionList(
514                         '/ARRAY/',
515                         array(
516                                 'id',
517                                 'sid',
518                                 'hash',
519                                 'password',
520                                 'reload',
521                                 'maximum_stay',
522                                 'minimum_stay',
523                                 'currency',
524                                 'type',
525                                 'remain',
526                                 'reward',
527                                 'size',
528                                 'erotic',
529                                 'extra'
530                         ),
531                         array(
532                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_ID--}',
533                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_SID--}',
534                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_HASH--}',
535                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_PASSWORD--}',
536                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_RELOAD--}',
537                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_MAXIMUM_STAY--}',
538                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_MINIMUM_STAY--}',
539                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_CURRENCY--}',
540                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_TYPE--}',
541                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_REMAIN--}',
542                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_REWARD--}',
543                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_SIZE--}',
544                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_EROTIC--}',
545                                 '{--ADMIN_NETWORK_REQUEST_PARAMETER_EXTRA--}'
546                         ),
547                         $key,
548                         '', '',
549                         $GLOBALS['network_params_disabled']
550                 );
551         } // END - if
552
553         // Return content
554         return $GLOBALS['network_request_param_key'][$key];
555 }
556
557 // Generator (somewhat getter) for (return) array translation
558 function generateNetworkTranslationOptions ($default = '') {
559         // Is it cached?
560         if (!isset($GLOBALS['network_translation'][$default])) {
561                 // Generate and cache it
562                 $GLOBALS['network_translation'][$default] = generateOptionList(
563                         'network_translations',
564                         'network_translation',
565                         'network_translation',
566                         $default,
567                         '',
568                         sprintf("WHERE `network_type_id`=%s",
569                                 bigintval(getRequestParameter('network_type'))
570                         ),
571                         $GLOBALS['network_translation_disabled'],
572                         'ADMIN_NETWORK_ARRAY_TRANSLATION_'
573                 );
574         } // END - if
575
576         // Return content
577         return $GLOBALS['network_translation'][$default];
578 }
579
580 //------------------------------------------------------------------------------
581 //                             Call-back functions
582 //------------------------------------------------------------------------------
583
584 // Callback function to add new network
585 function doAdminNetworkProcessAddnetworkForm () {
586         // We can say here, the form is sent, so check if the network is already added
587         if (isNetworkNameValid(postRequestParameter('network_short_name'))) {
588                 // Already there
589                 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_ALREADY_ADDED', postRequestParameter('network_short_name')));
590                 return false;
591         } // END - if
592
593         // Remove the 'ok' part
594         unsetPostRequestParameter('ok');
595
596         // Add the whole request to database
597         SQL_QUERY('INSERT INTO
598         `{?_MYSQL_PREFIX?}_network_data`
599 (
600         `' . implode('`,`', array_keys(postRequestArray())) . "`
601 ) VALUES (
602         '" . implode("','", array_values(postRequestArray())) . "'
603 )", __FUNCTION__, __LINE__);
604
605         // Add the id for output only
606         setPostRequestParameter('network_id', SQL_INSERTID());
607
608         // Output message
609         if (SQL_AFFECTEDROWS() == 1) {
610                 // Successfully added
611                 loadTemplate('admin_network_added', false, postRequestArray());
612         } else {
613                 // Not added
614                 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_DATA_NOT_ADDED', postRequestParameter('network_short_name')));
615         }
616 }
617
618 // Displays selected networks for editing
619 function doAdminNetworkProcessHandlenetworkForm () {
620         // Do we have selections?
621         if (ifPostContainsSelections()) {
622                 // Something has been selected, so start displaying one by one
623                 $OUT = '';
624                 foreach (postRequestParameter('sel') as $id => $sel) {
625                         // Is this selected?
626                         if ($sel == 1) {
627                                 // Load this network's data
628                                 $networkData = getNetworkDataById($id);
629
630                                 // Do we have found the network?
631                                 if (count($networkData) > 0) {
632                                         if (isFormSent('edit')) {
633                                                 // Make selection box for network_request_type
634                                                 $networkData['network_request_type'] = generateOptionList(
635                                                         '/ARRAY/',
636                                                         array(
637                                                                 'GET',
638                                                                 'POST'
639                                                         ),
640                                                         array(
641                                                                 '{--ADMIN_NETWORK_REQUEST_TYPE_GET--}',
642                                                                 '{--ADMIN_NETWORK_REQUEST_TYPE_POST--}'
643                                                         ),
644                                                         $networkData['network_request_type']
645                                                 );
646
647                                                 // Add row template for editing
648                                                 $OUT .= loadTemplate('admin_edit_networks_row', true, $networkData);
649                                         } elseif (isFormSent('del')) {
650                                                 // Translate the request type
651                                                 $networkData['network_request_type'] = '{--ADMIN_NETWORK_REQUEST_TYPE_' . $networkData['network_request_type'] . '--}';
652
653                                                 // Add row template for deleting
654                                                 $OUT .= loadTemplate('admin_del_networks_row', true, $networkData);
655                                         } else {
656                                                 // Problem!
657                                                 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
658                                         }
659                                 } // END - if
660                         } // END - if
661                 } // END - foreach
662
663                 // If we have no rows, we don't need to display the edit form
664                 if (!empty($OUT)) {
665                         // Output main template
666                         if (isFormSent('edit')) {
667                                 loadTemplate('admin_edit_networks', false, $OUT);
668                         } elseif (isFormSent('del')) {
669                                 loadTemplate('admin_del_networks', false, $OUT);
670                         } else {
671                                 // Problem!
672                                 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
673                         }
674
675                         // Don't display the list/add new form
676                         $GLOBALS['network_display'] = false;
677                 } else {
678                         // Nothing selected/found
679                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_FOUND--}');
680                 }
681         } // END - if
682 }
683
684 // Handle network type form
685 function doAdminNetworkProcessHandlenetworktypeForm () {
686         // Do we have selections?
687         if (ifPostContainsSelections()) {
688                 // Load network data
689                 $networkData = getNetworkDataById(getRequestParameter('network'));
690
691                 // Something has been selected, so start displaying one by one
692                 $OUT = '';
693                 foreach (postRequestParameter('sel') as $id => $sel) {
694                         // Is this selected?
695                         if ($sel == 1) {
696                                 // Load this network's data
697                                 $networkTypeData = getNetworkTypeDataById($id);
698
699                                 // Do we have found the network?
700                                 if (count($networkTypeData) > 0) {
701                                         if (isFormSent('edit')) {
702                                                 // Add row template for deleting
703                                                 $OUT .= loadTemplate('admin_edit_network_types_row', true, $networkTypeData);
704                                         } elseif (isFormSent('del')) {
705                                                 // Add row template for deleting
706                                                 $OUT .= loadTemplate('admin_del_network_types_row', true, $networkTypeData);
707                                         } else {
708                                                 // Problem!
709                                                 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
710                                         }
711                                 } // END - if
712                         } // END - if
713                 } // END - foreach
714
715                 // If we have no rows, we don't need to display the edit form
716                 if (!empty($OUT)) {
717                         // Output main template
718                         if (isFormSent('edit')) {
719                                 loadTemplate('admin_edit_network_types', false, $OUT);
720                         } elseif (isFormSent('del')) {
721                                 loadTemplate('admin_del_network_types', false, $OUT);
722                         } else {
723                                 // Problem!
724                                 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
725                         }
726
727                         // Don't display the list/add new form
728                         $GLOBALS['network_display'] = false;
729                 } else {
730                         // Nothing selected/found
731                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_FOUND--}');
732                 }
733         } // END - if
734 }
735
736 // Handle network request parameter form
737 function doAdminNetworkProcessHandlerequestparamsForm () {
738         // Do we have selections?
739         if (ifPostContainsSelections()) {
740                 // Init cache array
741                 $GLOBALS['network_params_disabled'] = array();
742
743                 // Load network data
744                 $networkData = getNetworkDataById(getRequestParameter('network'));
745
746                 // Something has been selected, so start displaying one by one
747                 $OUT = '';
748                 foreach (postRequestParameter('sel') as $id => $sel) {
749                         // Is this selected?
750                         if ($sel == 1) {
751                                 // Load this network's data
752                                 $networkRequestData = getNetworkRequestParamsDataById($id);
753
754                                 // Do we have found the network?
755                                 if (count($networkRequestData) > 0) {
756                                         if (isFormSent('edit')) {
757                                                 // Add options list for network type
758                                                 $networkRequestData['type_options'] = generateNetworkTypeOptions($networkRequestData['network_type_id']);
759
760                                                 // Add options list for request key
761                                                 $networkRequestData['key_options'] = generateNetworkRequestKeyOptions($networkRequestData['request_param_key']);
762
763                                                 // Add row template for deleting
764                                                 $OUT .= loadTemplate('admin_edit_network_params_row', true, $networkRequestData);
765                                         } elseif (isFormSent('del')) {
766                                                 // Get type data
767                                                 $networkRequestData['network_type_data'] = getNetworkTypeDataById($networkRequestData['network_type_id']);
768
769                                                 // Add row template for deleting
770                                                 $OUT .= loadTemplate('admin_del_network_params_row', true, $networkRequestData);
771                                         } else {
772                                                 // Problem!
773                                                 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
774                                         }
775                                 } // END - if
776                         } // END - if
777                 } // END - foreach
778
779                 // If we have no rows, we don't need to display the edit form
780                 if (!empty($OUT)) {
781                         // Output main template
782                         if (isFormSent('edit')) {
783                                 loadTemplate('admin_edit_network_params', false, $OUT);
784                         } elseif (isFormSent('del')) {
785                                 loadTemplate('admin_del_network_params', false, $OUT);
786                         } else {
787                                 // Problem!
788                                 debug_report_bug(__FUNCTION__, __LINE__, 'Cannot detect edit/del.');
789                         }
790
791                         // Don't display the list/add new form
792                         $GLOBALS['network_display'] = false;
793                 } else {
794                         // Nothing selected/found
795                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_FOUND--}');
796                 }
797         } // END - if
798 }
799
800 // Changes given networks
801 function doAdminNetworkProcessChangenetworkForm () {
802         // Do we have selections?
803         if (ifPostContainsSelections()) {
804                 // By default nothing is updated
805                 $updated = 0;
806
807                 // Something has been selected, so start updating them
808                 foreach (postRequestParameter('sel') as $id => $sel) {
809                         // Update this entry?
810                         if ($sel == 1) {
811                                 // Init data array
812                                 $networkData = array();
813
814                                 // Transfer whole array, except 'sel'
815                                 foreach (postRequestArray() as $key => $entry) {
816                                         // Skip 'sel' and submit button
817                                         if (in_array($key, array('sel', 'change'))) continue;
818
819                                         // Do we have this enty?
820                                         if (!isset($entry[$id])) {
821                                                 // Not found, needs fixing
822                                                 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
823                                         } // END - if
824
825                                         // Add this entry
826                                         $networkData[$key] = $entry[$id];
827                                 } // END - foreach
828
829                                 // Update the network data
830                                 $updated += doNetworkUpdateDataByArray($id, $networkData);
831                         } // END - if
832                 } // END - foreach
833
834                 // Do we have updates?
835                 if ($updated > 0) {
836                         // Updates done
837                         loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_UPDATED', $updated));
838                 } else {
839                         // Nothing changed
840                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_CHANGED--}');
841                 }
842         } // END - if
843 }
844
845 // Removes given networks
846 function doAdminNetworkProcessRemovenetworkForm () {
847         // Do we have selections?
848         if (ifPostContainsSelections()) {
849                 // By default nothing is removed
850                 $removed = 0;
851
852                 // Something has been selected, so start updating them
853                 foreach (postRequestParameter('sel') as $id => $sel) {
854                         // Update this entry?
855                         if ($sel == 1) {
856                                 // Remove this entry
857                                 $removed += doAdminRemoveNetworkEntry('data', 'network_id', $id);
858                         } // END - if
859                 } // END - foreach
860
861                 // Do we have removes?
862                 if ($removed > 0) {
863                         // Removals done
864                         loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REMOVED', $removed));
865                 } else {
866                         // Nothing removed
867                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_NOTHING_REMOVED--}');
868                 }
869         } // END - if
870 }
871
872 // Add a network type handler if not yet found
873 function doAdminNetworkProcessAddnetworktypeForm () {
874         // Is the network type handle already used with given network?
875         if (isNetworkTypeHandleValid(postRequestParameter('network_type_handle'), getRequestParameter('network'))) {
876                 // Already added
877                 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_HANDLE_ALREADY_ADDED', postRequestParameter('network_type_handle')));
878
879                 // ... so abort here
880                 return false;
881         } // END - if
882
883         // Remove the 'ok' part
884         unsetPostRequestParameter('ok');
885
886         // Add id
887         setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
888
889         // Is network_type_banner_url set?
890         if (postRequestParameter('network_type_banner_url') == '') {
891                 // Remove empty value to get a NULL for an optional entry
892                 unsetPostRequestParameter('network_type_banner_url');
893         } // END - if
894
895         // Add the whole request to database
896         SQL_QUERY("INSERT INTO
897         `{?_MYSQL_PREFIX?}_network_types`
898 (
899         `" . implode('`,`', array_keys(postRequestArray())) . "`
900 ) VALUES (
901         '" . implode("','", array_values(postRequestArray())) . "'
902 )", __FUNCTION__, __LINE__);
903
904         // Output message
905         if (SQL_AFFECTEDROWS() == 1) {
906                 // Successfully added
907                 loadTemplate('admin_network_type_added', false, postRequestArray());
908         } else {
909                 // Not added
910                 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_NOT_ADDED', postRequestParameter('network_type_handle')));
911         }
912 }
913
914 // Changes given network type handlers
915 function doAdminNetworkProcessChangenetworktypeForm () {
916         // Do we have selections?
917         if (ifPostContainsSelections()) {
918                 // By default nothing is updated
919                 $updated = 0;
920
921                 // Something has been selected, so start updating them
922                 foreach (postRequestParameter('sel') as $id => $sel) {
923                         // Update this entry?
924                         if ($sel == 1) {
925                                 // Init data array
926                                 $networkTypeData = array();
927
928                                 // Transfer whole array, except 'sel'
929                                 foreach (postRequestArray() as $key => $entry) {
930                                         // Skip 'sel' and submit button
931                                         if (in_array($key, array('sel', 'change'))) continue;
932
933                                         // Do we have this enty?
934                                         if (!isset($entry[$id])) {
935                                                 // Not found, needs fixing
936                                                 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
937                                         } // END - if
938
939                                         // Fix empty network_type_banner_url to NULL
940                                         if (($key == 'network_type_banner_url') && (trim($entry[$id]) == '')) {
941                                                 // Set it to NULL
942                                                 $entry[$id] = null;
943                                         } // END - if
944
945                                         // Add this entry
946                                         $networkTypeData[$key] = $entry[$id];
947                                 } // END - foreach
948
949                                 // Update the network data
950                                 $updated += doNetworkUpdateTypeByArray($id, $networkTypeData);
951                         } // END - if
952                 } // END - foreach
953
954                 // Do we have updates?
955                 if ($updated > 0) {
956                         // Updates done
957                         loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_UPDATED', $updated));
958                 } else {
959                         // Nothing changed
960                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_CHANGED--}');
961                 }
962         } // END - if
963 }
964
965 // Changes given network request parameters
966 function doAdminNetworkProcessChangenetworkparamForm () {
967         // Do we have selections?
968         if (ifPostContainsSelections()) {
969                 // By default nothing is updated
970                 $updated = 0;
971
972                 // Something has been selected, so start updating them
973                 foreach (postRequestParameter('sel') as $id => $sel) {
974                         // Update this entry?
975                         if ($sel == 1) {
976                                 // Init data array
977                                 $networkParamsData = array();
978
979                                 // Transfer whole array, except 'sel'
980                                 foreach (postRequestArray() as $key => $entry) {
981                                         // Skip 'sel' and submit button
982                                         if (in_array($key, array('sel', 'change'))) continue;
983
984                                         // Do we have this enty?
985                                         if (!isset($entry[$id])) {
986                                                 // Not found, needs fixing
987                                                 debug_report_bug(__FUNCTION__, __LINE__, 'No entry in key=' . $key . ', id=' . $id . ' found.');
988                                         } // END - if
989
990                                         // Fix empty request_param_default to NULL
991                                         if (($key == 'request_param_default') && (trim($entry[$id]) == '')) {
992                                                 // Set it to NULL
993                                                 $entry[$id] = null;
994                                         } // END - if
995
996                                         // Add this entry
997                                         $networkParamsData[$key] = $entry[$id];
998                                 } // END - foreach
999
1000                                 // Update the network data
1001                                 $updated += doNetworkUpdateParamsByArray($id, $networkParamsData);
1002                         } // END - if
1003                 } // END - foreach
1004
1005                 // Do we have updates?
1006                 if ($updated > 0) {
1007                         // Updates done
1008                         loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_UPDATED', $updated));
1009                 } else {
1010                         // Nothing changed
1011                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_CHANGED--}');
1012                 }
1013         } // END - if
1014 }
1015
1016 // Removes given network type handlers
1017 function doAdminNetworkProcessRemovenetworktypeForm () {
1018         // Do we have selections?
1019         if (ifPostContainsSelections()) {
1020                 // By default nothing is removed
1021                 $removed = 0;
1022
1023                 // Something has been selected, so start updating them
1024                 foreach (postRequestParameter('sel') as $id => $sel) {
1025                         // Update this entry?
1026                         if ($sel == 1) {
1027                                 // Remove this entry
1028                                 $removed += doAdminRemoveNetworkEntry('types', 'network_type_id', $id);
1029                         } // END - if
1030                 } // END - foreach
1031
1032                 // Do we have removes?
1033                 if ($removed > 0) {
1034                         // Removals done
1035                         loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_TYPES_REMOVED', $removed));
1036                 } else {
1037                         // Nothing removed
1038                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_TYPES_NOTHING_REMOVED--}');
1039                 }
1040         } // END - if
1041 }
1042
1043 // Removes given network request parameters
1044 function doAdminNetworkProcessRemovenetworkparamForm () {
1045         // Do we have selections?
1046         if (ifPostContainsSelections()) {
1047                 // By default nothing is removed
1048                 $removed = 0;
1049
1050                 // Something has been selected, so start updating them
1051                 foreach (postRequestParameter('sel') as $id => $sel) {
1052                         // Update this entry?
1053                         if ($sel == 1) {
1054                                 // Remove this entry
1055                                 $removed += doAdminRemoveNetworkEntry('request_params', 'network_param_id', $id);
1056                         } // END - if
1057                 } // END - foreach
1058
1059                 // Do we have removes?
1060                 if ($removed > 0) {
1061                         // Removals done
1062                         loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_REMOVED', $removed));
1063                 } else {
1064                         // Nothing removed
1065                         loadTemplate('admin_settings_unsaved', false, '{--ADMIN_NETWORK_REQUEST_PARAMETER_NOTHING_REMOVED--}');
1066                 }
1067         } // END - if
1068 }
1069
1070 // Adds a request parameter to given network and type
1071 function doAdminNetworkProcessAddnetworkparamForm () {
1072         // Is the request parameter already used with given network?
1073         if (isNetworkRequestParameterValid(postRequestParameter('request_param_key'), postRequestParameter('network_type_id'), getRequestParameter('network'))) {
1074                 // Already added
1075                 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_ALREADY_ADDED', postRequestParameter('request_param_key')));
1076
1077                 // ... so abort here
1078                 return false;
1079         } // END - if
1080
1081         // Remove the 'ok' part
1082         unsetPostRequestParameter('ok');
1083
1084         // Add id
1085         setPostRequestParameter('network_id', bigintval(getRequestParameter('network')));
1086
1087         // Is request_param_default set?
1088         if (postRequestParameter('request_param_default') == '') {
1089                 // Remove empty value to get a NULL for an optional entry
1090                 unsetPostRequestParameter('request_param_default');
1091         } // END - if
1092
1093         // Add the whole request to database
1094         SQL_QUERY('INSERT INTO
1095         `{?_MYSQL_PREFIX?}_network_request_params`
1096 (
1097         `' . implode('`,`', array_keys(postRequestArray())) . "`
1098 ) VALUES (
1099         '" . implode("','", array_values(postRequestArray())) . "'
1100 )", __FUNCTION__, __LINE__);
1101
1102         // Output message
1103         if (SQL_AFFECTEDROWS() == 1) {
1104                 // Successfully added
1105                 loadTemplate('admin_network_request_param_added', false, postRequestArray());
1106         } else {
1107                 // Not added
1108                 loadTemplate('admin_settings_unsaved', false, getMaskedMessage('ADMIN_NETWORK_REQUEST_PARAMETER_NOT_ADDED', postRequestParameter('request_param_key')));
1109         }
1110 }
1111
1112 // Do expression code for this extension
1113 function doExpressionNetwork ($data) {
1114         // Construct replacer
1115         $replacer = sprintf(
1116                 "{DQUOTE} . %s(%s, '%s') . {DQUOTE}",
1117                 $data['callback'],
1118                 $data['matches'][4][$data['key']],
1119                 $data['extra_func']
1120         );
1121
1122         // Replace %network% with the current network id
1123         $replacer = str_replace('%network%', getCurrentNetworkId(), $replacer);
1124
1125         // Replace the code
1126         $code = replaceExpressionCode($data, $replacer);
1127
1128         // Return it
1129         return $code;
1130 }
1131
1132 // [EOF]
1133 ?>
1134