Fix for rewritting code

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

diff --git a/inc/modules/admin/what-list_links.php b/inc/modules/admin/what-list_links.php
index 731b4edc61f6fc60b5d75859b4f7a24d7399adab..69c19b7ae209d42fd12a7d455f99cf4d727609ed 100644 (file)
--- a/inc/modules/admin/what-list_links.php
+++ b/inc/modules/admin/what-list_links.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 01/28/2004 *
- * ================                             Last change: 12/13/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 01/28/2004 *
+ * ===================                          Last change: 12/13/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-list_links.php                              *
@@ -97,17 +97,17 @@ if (isGetRequestElementSet('userid')) {
                                        // @TODO Rewrite this to includes/filter
                                        switch ($type) {
                                                case 'NORMAL':
-                                                       $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp_ordered`, `cat_id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
+                                                       $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp_ordered` AS `timestamp`, `cat_id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1",
                                                                array(bigintval($id)), __FILE__, __LINE__);
                                                        $type = 'mailid'; $DATA = $id; $PROBLEM = getMessage('NORMAL_MAIL_PROBLEM');
-                                                       $LINK = "<a href=\"{?URL?}/mailid.php?userid=".getRequestElement('userid')."&amp;mailid=".$id."\" target=\"_blank\">".$id."</a>";
+                                                       $LINK = "<a href=\"{%url=mailid.php?userid=".getRequestElement('userid')."&amp;mailid=".$id."%}\" target=\"_blank\">".$id."</a>";
                                                        break;
 
                                                case 'BONUS':
                                                        $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp`, `cat_id` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1",
                                                                array(bigintval($id2)), __FILE__, __LINE__);
                                                        $type = 'bonusid'; $DATA = $id2; $PROBLEM = getMessage('BONUS_MAIL_PROBLEM');
-                                                       $LINK = "<a href=\"{?URL?}/mailid.php?userid=".getRequestElement('userid')."&amp;bonusid=".$id2."\" target=\"_blank\">".$id2."</a>";
+                                                       $LINK = "<a href=\"{%url=mailid.php?userid=".getRequestElement('userid')."&amp;bonusid=".$id2."%}\" target=\"_blank\">".$id2."</a>";
                                                        break;
 
                                                default: // Problem in application detected!
@@ -118,16 +118,18 @@ if (isGetRequestElementSet('userid')) {
 
                                        if (SQL_NUMROWS($result_data) == 1) {
                                                // Mail was found!
-                                               list($subject, $timestamp, $cat) = SQL_FETCHROW($result_data);
-                                               if (empty($subject)) $subject = getMessage('DEFAULT_SUBJECT_LINE');
+                                               $content = SQL_FETCHARRAY($result_data);
+
+                                               // Fix empty subject
+                                               if (empty($content['subject'])) $content['subject'] = getMessage('DEFAULT_SUBJECT_LINE');
 
                                                // Prepare data for the row template
                                                $content = array(
-                                                       'sw'      => $SW,
-                                                       'link'    => $LINK,
-                                                       'subject' => $subject,
-                                                       'stamp'   => generateDateTime($timestamp, 0),
-                                                       'cat'     => getCategory($cat),
+                                                       'sw'        => $SW,
+                                                       'link'      => $LINK,
+                                                       'subject'   => $content['subject'],
+                                                       'timestamp' => generateDateTime($content['timestamp'], 0),
+                                                       'cat'       => getCategory($content['cat_id']),
                                                );
 
                                                // Load row template
@@ -135,11 +137,11 @@ if (isGetRequestElementSet('userid')) {
                                        } else {
                                                // Load template for error
                                                $OUT .= loadTemplate('admin_list_links_problem',
-                                               array(
+                                                       array(
                                                                'sw'            => $SW,
                                                                'problem'       => $PROBLEM,
                                                                'data'          => $DATA
-                                               )
+                                                       )
                                                );
                                        }