Huge HTML/CSS rewrite (see forum)
[mailer.git] / inc / modules / admin / what-email_archiv.php
index 8ce52b112bc4ff7d705310a366207fb24ec00d23..545bba14333c3ca3742f0a62bea756c6e5995fcf 100644 (file)
@@ -92,7 +92,7 @@ if (SQL_NUMROWS($result) > 0) {
        while ($pool = SQL_FETCHROW($result)) {
                // Check sent mails and clicks
                $result_mails = SQL_QUERY_ESC("SELECT `max_rec`, `clicks` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `pool_id`=%s LIMIT 1",
-                       array(bigintval($pool[0])), __FILE__, __LINE__);
+                       array(bigintval($pool['id'])), __FILE__, __LINE__);
                list($sent, $clicks) = SQL_FETCHROW($result_mails);
                SQL_FREERESULT($result_mails);
 
@@ -100,30 +100,30 @@ if (SQL_NUMROWS($result) > 0) {
                $unconfirmed = $sent - $clicks;
                if ($unconfirmed > 0) {
                        // Add link to list_unconfirmed what-file
-                       $unconfirmed = "<strong><a href=\"{?URL?}/modules.php?module=admin&amp;what=list_unconfirmed&amp;mid=".$pool[0]."\">".$unconfirmed."</a></strong>";
+                       $unconfirmed = "<strong><a href=\"{?URL?}/modules.php?module=admin&amp;what=list_unconfirmed&amp;mid=".$pool['id']."\">".$unconfirmed."</a></strong>";
                } // END - if
 
                // Prepare data for the row template
-               $row = array(
+               $content = array(
                        'sw'          => $SW,
-                       'u_link'      => generateUserProfileLink($pool[1]),
-                       'subject'     => $pool[2],
-                       'text'        => $pool[3],
-                       'pay'         => getPaymentTitlePrice($pool[5]),
-                       'cat'         => getCategory($pool[10]),
+                       'u_link'      => generateUserProfileLink($pool['sender']),
+                       'subject'     => $pool['subject'],
+                       'text'        => $pool['text'],
+                       'pay'         => getPaymentTitlePrice($pool['payment_id']),
+                       'cat'         => getCategory($pool['cat_id']),
                        'sent'        => $sent,
-                       'ruserids'    => convertReceivers($pool[4]),
+                       'ruserids'    => convertReceivers($pool['receivers']),
                        'unconfirmed' => $unconfirmed,
-                       'type'        => translatePoolType($pool[6]),
-                       'target_send' => $pool[9],
-                       'frametester' => generateFrametesterUrl($pool[8]),
-                       'url'         => $pool[8],
-                       'stamp'       => generateDateTime($pool[7], 0),
-                       'mid'         => $pool[0],
+                       'type'        => translatePoolType($pool['data_type']),
+                       'target_send' => $pool['target_send'],
+                       'frametester' => generateFrametesterUrl($pool['url']),
+                       'url'         => $pool['url'],
+                       'timestamp'   => generateDateTime($pool['timestamp'], 0),
+                       'mid'         => $pool['id'],
                );
 
                // Load row template and switch colors
-               $OUT .= loadTemplate('admin_email_archiv_row', true, $row);
+               $OUT .= loadTemplate('admin_email_archiv_row', true, $content);
                $SW = 3 - $SW;
        } // END - while