X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fpurge%2Fpurge-general.php;h=07205e280fe3bddd5f4838163135208cb45a0dca;hb=094f3a6af3b901020395eafee16b3b5e151f1137;hp=cb33c8799236f2e41ddc98e86fc63eb728a5a449;hpb=ca256746fe0757a23df4064824c8fe2087ad5634;p=mailer.git

diff --git a/inc/purge/purge-general.php b/inc/purge/purge-general.php
index cb33c87992..07205e280f 100644
--- a/inc/purge/purge-general.php
+++ b/inc/purge/purge-general.php
@@ -53,17 +53,20 @@ if (getAutoPurge() > 0) {
 
 	// Then check for outdated mail order. We don't delete them just the confirmation links will be deleted.
 	$result = SQL_QUERY('SELECT
-	s.id, s.userid, s.pool_id, t.price
+	`s`.`id`,
+	`s`.`userid`,
+	`s`.`pool_id`,
+	`t`.`price`
 FROM
-	`{?_MYSQL_PREFIX?}_user_stats` AS s
+	`{?_MYSQL_PREFIX?}_user_stats` AS `s`
 LEFT JOIN
-	`{?_MYSQL_PREFIX?}_payments` AS t
+	`{?_MYSQL_PREFIX?}_payments` AS `t`
 ON
-	s.`payment_id`=t.`id`
+	`s`.`payment_id`=`t`.`id`
 WHERE
-	(UNIX_TIMESTAMP() - s.`timestamp_ordered`) >= {?auto_purge?}
+	(UNIX_TIMESTAMP() - `s`.`timestamp_ordered`) >= {?auto_purge?}
 ORDER BY
-	s.userid ASC', __FILE__, __LINE__);
+	`s`.`userid` ASC', __FILE__, __LINE__);
 	if (!SQL_HASZERONUMS($result)) {
 		// Start deleting procedure
 		$userid = NULL;