More improved SQL queries

[mailer.git] / inc / modules / guest / what-mediadata.php

diff --git a/inc/modules/guest/what-mediadata.php b/inc/modules/guest/what-mediadata.php
index 5fa8585278e029cd3139d90bb888a85c4f7797bd..7c51cb95403804919a67c67afa6716e2bbe5d9e2 100644 (file)
--- a/inc/modules/guest/what-mediadata.php
+++ b/inc/modules/guest/what-mediadata.php
@@ -77,13 +77,13 @@ if ($TEST > time()) {
 }
 
 // User who can receive mails
 }
 
 // User who can receive mails

-$result_max = SQL_QUERY("SELECT COUNT(max_mails) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE status='CONFIRMED' AND max_mails > 0", __FILE__, __LINE__);
+$result_max = SQL_QUERY("SELECT COUNT(max_mails) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' AND max_mails > 0", __FILE__, __LINE__);

 list($dummy) = SQL_FETCHROW($result_max);
 SQL_FREERESULT($result_max);
 define('user_max_mails', $dummy);
 
 // Users who can receive mails today
 list($dummy) = SQL_FETCHROW($result_max);
 SQL_FREERESULT($result_max);
 define('user_max_mails', $dummy);
 
 // Users who can receive mails today

-$result_rec = SQL_QUERY("SELECT COUNT(receive_mails) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE status='CONFIRMED' AND receive_mails > 0", __FILE__, __LINE__);
+$result_rec = SQL_QUERY("SELECT COUNT(receive_mails) FROM `{!_MYSQL_PREFIX!}_user_data` WHERE `status`='CONFIRMED' AND receive_mails > 0", __FILE__, __LINE__);

 list($dummy) = SQL_FETCHROW($result_rec);
 SQL_FREERESULT($result_rec);
 define('user_max_rec', $dummy);
 list($dummy) = SQL_FETCHROW($result_rec);
 SQL_FREERESULT($result_rec);
 define('user_max_rec', $dummy);