Removed some column aliases as they make it harder to check which column was ment

[mailer.git] / inc / modules / admin / what-list_payouts.php

diff --git a/inc/modules/admin/what-list_payouts.php b/inc/modules/admin/what-list_payouts.php
index be043aceac4c6b3f2e5828de868aa42fd2436be8..2d8588f8e27f1fb2ff73c76fdc4e299e4797bfd8 100644 (file)
--- a/inc/modules/admin/what-list_payouts.php
+++ b/inc/modules/admin/what-list_payouts.php
@@ -232,10 +232,10 @@ LIMIT 1",
        `t`.`type`,
        `p`.`payout_timestamp`,
        `p`.`status`,
-       `t`.`allow_url` AS `allow`,
-       `p`.`target_url` AS `url`,
-       `p`.`link_text` AS `alt`,
-       `p`.`banner_url` AS `banner`
+       `t`.`allow_url`
+       `p`.`target_url`,
+       `p`.`link_text`
+       `p`.`banner_url`
 FROM
        `{?_MYSQL_PREFIX?}_user_payouts` AS `p`
 LEFT JOIN
@@ -258,9 +258,9 @@ ORDER BY
                        }
 
                        // Nothing entered must be secured in member/what-payputs.php !
-                       if ($content['allow'] == 'Y') {
+                       if ($content['allow_url'] == 'Y') {
                                // Banner/Textlink views/clicks request
-                               if (!empty($content['banner'])) {
+                               if (!empty($content['banner_url'])) {
                                        // Load template for the banner
                                        $content['target_account'] = loadTemplate('admin_list_payouts_banner', TRUE, $content);
                                } else {
@@ -269,7 +269,7 @@ ORDER BY
                                }
 
                                // Admins can addionally test the URL for framekillers
-                               $content['target_bank'] = '<a href="' . generateFrametesterUrl($content['url']) . '" target="_blank">{--CLICK_HERE--}</a>';
+                               $content['target_bank'] = '<a href="' . generateFrametesterUrl($content['target_url']) . '" target="_blank">{--CLICK_HERE--}</a>';
                        } // END - if
 
                        // Add/Translate some data