From 38e2d498fc9fd64d302b670766f6044aa4c85058 Mon Sep 17 00:00:00 2001
From: kkalev <kkalev>
Date: Mon, 11 Aug 2003 14:15:16 +0000
Subject: [PATCH] Change AcctStopTime = '0' with AcctStopTime IS NULL

---
 Changelog               | 1 +
 htdocs/user_admin.php3  | 2 +-
 htdocs/user_finger.php3 | 2 +-
 3 files changed, 3 insertions(+), 2 deletions(-)

diff --git a/Changelog b/Changelog
index 1766916..95ac9d7 100644
--- a/Changelog
+++ b/Changelog
@@ -37,6 +37,7 @@ Ver 1.63:
 * Make log_badlogins work with usernames containing spaces
 * Only delete sessions which are not open in truncate_radacct. Bug noted by Evren Yurtesen <yurtesen@ispro.net.tr>
 * Add a user input tag in user_stats.php3
+* Change AcctStopTime = '0' with AcctStopTime IS NULL
 Ver 1.62:
 * Remove one sql query from user_admin which was not needed.
 * Instead of a query like "LIKE 'YYYY-MM-DD%'" use "AcctStopTime >= 'YYYY-MM-DD 00:00:00 AND AcctStopTime
diff --git a/htdocs/user_admin.php3 b/htdocs/user_admin.php3
index 987f54b..732a4ac 100644
--- a/htdocs/user_admin.php3
+++ b/htdocs/user_admin.php3
@@ -166,7 +166,7 @@ if ($link){
 
 	$search = @da_sql_query($link,$config,
 	"SELECT * FROM $config[sql_accounting_table]
-	WHERE UserName = '$login' AND AcctStopTime = '0'
+	WHERE UserName = '$login' AND AcctStopTime IS NULL
 	ORDER BY AcctStartTime DESC LIMIT 1;");
 	if ($search){
 		if (@da_sql_num_rows($search,$config)){
diff --git a/htdocs/user_finger.php3 b/htdocs/user_finger.php3
index be0b688..5ddfbfb 100644
--- a/htdocs/user_finger.php3
+++ b/htdocs/user_finger.php3
@@ -82,7 +82,7 @@ if ($link){
 		$search = @da_sql_query($link,$config,
 		"SELECT DISTINCT UserName,AcctStartTime,FramedIPAddress,CallingStationId
 		FROM $config[sql_accounting_table] WHERE
-		AcctStopTime = '0' AND NASIPAddress = '$name_data' $extra
+		AcctStopTime IS NULL AND NASIPAddress = '$name_data' $extra
 		GROUP BY UserName ORDER BY AcctStartTime;");
 		if ($search){
 			$now = time();
-- 
2.39.5