- $sql = "SELECT DISTINCT s.id, p.sender, p.subject, p.text, p.url, p.timestamp, s.max_rec FROM `{!_MYSQL_PREFIX!}_pool` AS p
-LEFT JOIN `{!_MYSQL_PREFIX!}_user_stats` AS s
-ON p.id=s.pool_id
-WHERE p.id='".REQUEST_GET('mid')."' LIMIT 1";
-
- // Column, type and ID for member's mail
- $col = "stats_id"; $type = "NORMAL"; $ID = "-1";
+ $sql = "SELECT
+ s.id, p.sender, p.subject, p.text, p.url, p.timestamp, s.max_rec
+FROM
+ `{?_MYSQL_PREFIX?}_pool` AS p
+LEFT JOIN
+ `{?_MYSQL_PREFIX?}_user_stats` AS s
+ON
+ p.id=s.pool_id
+WHERE
+ p.id='".getRequestElement('mid')."'
+LIMIT 1";
+
+ // Column, type and id for member's mail
+ $col = 'stats_id'; $type = 'NORMAL'; $ID = '-1';