]> git.mxchange.org Git - mailer.git/blobdiff - inc/modules/admin/what-list_network_array_translation.php
introduced isSqlResult() which encapsulates checking MySQL/i results
[mailer.git] / inc / modules / admin / what-list_network_array_translation.php
index dfc1bdaf221e97e6ab87d49bfafb1f54aec07aa9..1ef12fe8096c0d2526a85534f1a1a0c07b3713ea 100644 (file)
  * $Date::                                                            $ *
  * $Tag:: 0.2.1-FINAL                                                 $ *
  * $Author::                                                          $ *
- * Needs to be in all Files and every File needs "svn propset           *
- * svn:keywords Date Revision" (autoprobset!) at least!!!!!!            *
  * -------------------------------------------------------------------- *
  * Copyright (c) 2003 - 2009 by Roland Haeder                           *
- * Copyright (c) 2009, 2010 by Mailer Developer Team                    *
- * For more information visit: http://www.mxchange.org                  *
+ * Copyright (c) 2009 - 2016 by Mailer Developer Team                   *
+ * For more information visit: http://mxchange.org                      *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
@@ -43,7 +41,7 @@ if ((!defined('__SECURITY')) || (!isAdmin())) {
 } // END - if
 
 // Add description as navigation point
-addMenuDescription('admin', __FILE__);
+addYouAreHereLink('admin', __FILE__);
 
 // These are expert settings!
 if (doVerifyExpertSettings() != 'agreed') {
@@ -52,103 +50,106 @@ if (doVerifyExpertSettings() != 'agreed') {
 } // END - if
 
 // By default we should display list/add new forms
-$GLOBALS['network_display'] = true;
+$GLOBALS['network_display'] = TRUE;
 
 // Handle form here
 doNetworkHandleForm();
 
 // Display forms?
-if ($GLOBALS['network_display'] === false) {
+if ($GLOBALS['network_display'] === FALSE) {
        // Abort here
        return;
 } // END - if
 
-// Do we have a network selected?
-if (isGetRequestParameterSet('network')) {
+// Is there a network selected?
+if (isGetRequestElementSet('network_id')) {
        // Get its data for template
-       $networkData = getNetworkDataById(getRequestParameter('network'));
+       $networkData = getNetworkDataFromId(getRequestElement('network_id'));
 
-       // Is a network type selected?
-       if (!isGetRequestParameterSet('network_type')) {
-               // Then present a new selection form
-               outputHtml(generateAdminNetworkTypeList(getRequestParameter('network'), getRequestParameter('network_type')));
-
-               // Abort any other processing
-               return;
-       } // END - if
+       // Init type
+       $networkData['network_type_id'] = 0;
 
        // Init disabled list
        $GLOBALS['network_array_translation_disabled'] = array();
 
+       // Only show params from given type handler if choosen
+       $ADD = '';
+       if ((isPostRequestElementSet('network_type_id')) && (!is_array(postRequestElement('network_type_id')))) {
+               // Only show from current type handler
+               $ADD = sprintf(' AND `p`.`network_type_id`=%s', bigintval(postRequestElement('network_type_id')));
+
+               // Overwrite type
+               $networkData['network_type_id'] = bigintval(postRequestElement('network_type_id'));
+
+               // Display message
+               displayMessage('{--ADMIN_LIST_NETWORK_ARRAY_TRANSLATION_LIMITED_TO_TYPE--}');
+       } // END - if
+
        // Load all advert codes for given network
-       $result = SQL_QUERY_ESC("SELECT
-       p.`network_array_id`, t.`network_type_id`, t.`network_type_handle`, p.`network_array_index`, p.`network_index_translation`
+       $result = sqlQueryEscaped('SELECT
+       `p`.`network_array_id`,
+       `t`.`network_type_id`,
+       `t`.`network_type_handler`,
+       `p`.`network_array_index`,
+       `p`.`network_array_sort`
 FROM
-       `{?_MYSQL_PREFIX?}_network_array_translation` AS p
+       `{?_MYSQL_PREFIX?}_network_array_translation` AS `p`
 INNER JOIN
-       `{?_MYSQL_PREFIX?}_network_types` AS t
+       `{?_MYSQL_PREFIX?}_network_types` AS `t`
 ON
-       p.`network_type_id`=t.`network_type_id`
+       `p`.`network_type_id`=`t`.`network_type_id`
 WHERE
-       p.`network_id`=%s AND
-       p.`network_type_id`=%s
+       `p`.`network_id`=%s
+       ' . $ADD . '
 ORDER BY
-       t.`network_type_handle` ASC,
-       p.`network_array_id` ASC",
+       `t`.`network_type_handler` ASC,
+       `p`.`network_array_sort` ASC',
                array(
-                       bigintval(getRequestParameter('network')),
-                       bigintval(getRequestParameter('network_type'))
+                       bigintval(getRequestElement('network_id'))
                ), __FILE__, __LINE__);
 
-       // Remember the rows
-       $rows = SQL_NUMROWS($result);
-
-       // Do we have entries?
-       if ($rows > 0) {
+       // Are there entries?
+       if (!ifSqlHasZeroNumRows($result)) {
                // List all entries
-               $OUT = ''; $SW = 2;
-               while ($row = SQL_FETCHARRAY($result)) {
-                       // Add color switching
-                       $row['sw'] = $SW;
-
+               $OUT = '';
+               while ($row = sqlFetchArray($result)) {
                        // Add it to network if the type matches selected
-                       if ($row['network_type_id'] == getRequestParameter('network_type_id')) {
+                       if ($row['network_type_id'] == postRequestElement('network_type_id')) {
                                // Matches, then add it for disabling this entry
-                               $GLOBALS['network_array_translation_disabled'][$row['network_array_index']] = true;
+                               $GLOBALS['network_array_translation_disabled'][$row['network_array_index']] = TRUE;
                        } // END - if
 
                        // Add row template and switch color
-                       $OUT .= loadTemplate('admin_list_network_array_translation_row', true, $row);
-                       $SW = 3 - $SW;
+                       $OUT .= loadTemplate('admin_list_network_array_translation_row', TRUE, $row);
                } // END - while
 
-               // Prepare data for template
+               // Prepare array with generic elements
                $content = array(
-                       'rows'              => $OUT,
-                       'network_id'        => bigintval(getRequestParameter('network')),
-                       'network_title'     => $networkData['network_title'],
-                       'network_reflink'   => $networkData['network_reflink'],
+                       'rows'       => $OUT,
+                       'network_id' => bigintval(getRequestElement('network_id'))
                );
 
                // Load main template
-               loadTemplate('admin_list_network_array_translation', false, $content);
+               loadTemplate('admin_list_network_array_translation', FALSE, $content);
        } else {
                // No entries found
-               loadTemplate('admin_settings_saved', false, getMaskedMessage('ADMIN_NETWORK_ARRAY_TRANSLATION_404', $networkData['network_title']));
+               displayMessage('{%message,ADMIN_NETWORK_ARRAY_TRANSLATION_404=' . $networkData['network_title'] . '%}');
        }
 
        // Free result
-       SQL_FREERESULT($result);
-
-       // Add options list for network type
-       $networkData['translation_index'] = ($rows + 1);
-       $networkData['type_options']      = generateNetworkTypeOptions(getRequestParameter('network_type_id'));
+       sqlFreeResult($result);
 
        // Add form for adding new array_translation pair
-       loadTemplate('admin_add_network_array_translation', false, $networkData);
+       loadTemplate('admin_add_network_array_translation', FALSE, $networkData);
 } else {
        // Generate network list for this script
-       outputHtml(generateAdminNetworkList());
+       $OUT = generateAdminNetworkList();
+
+       // Is it not empty?
+       if (!empty($OUT)) {
+               // Output it
+               outputHtml($OUT);
+       } // END - if
 }
 
 // [EOF]