Mailer project continued:

[mailer.git] / inc / modules / member / what-stats.php

diff --git a/inc/modules/member/what-stats.php b/inc/modules/member/what-stats.php
index c31177ee1cbd454ccaa2882a384678a30137cc0f..51b82ba7e5d51aaea674924aed7e0844dd59f4bc 100644 (file)
--- a/inc/modules/member/what-stats.php
+++ b/inc/modules/member/what-stats.php
@@ -50,7 +50,15 @@ $main_content = array();
 
 // Load waiting/pending orders
 $result = SQL_QUERY_ESC("SELECT
-       `id`,`cat_id`,`payment_id`,`subject`,`url`,`timestamp`,`target_send`,`data_type`,`zip`
+       `id`,
+       `cat_id`,
+       `payment_id`,
+       `subject`,
+       `url`,
+       `timestamp`,
+       `target_send`,
+       `data_type`,
+       `zip`
 FROM
        `{?_MYSQL_PREFIX?}_pool`
 WHERE
@@ -83,14 +91,22 @@ if (!SQL_HASZERONUMS($result)) {
 SQL_FREERESULT($result);
 
 // Load sent orders
-$result = SQL_QUERY_ESC("SELECT
-       `id`,`cat_id`,`payment_id`,`subject`,`url`,`timestamp_ordered`,`max_rec`,`timestamp_send`,`clicks`
+$result = SQL_QUERY_ESC('SELECT
+       `id`,
+       `cat_id`,
+       `payment_id`,
+       `subject`,
+       `url`,
+       `timestamp_ordered`,
+       `max_rec`,
+       `timestamp_send`,
+       `clicks`
 FROM
        `{?_MYSQL_PREFIX?}_user_stats`
 WHERE
        `userid`=%s
 ORDER BY
-       `timestamp_ordered` DESC",
+       `timestamp_ordered` DESC',
        array(getMemberId()), __FILE__, __LINE__);
 
 if (!SQL_HASZERONUMS($result)) {