Commit: db3077789b8fd3ac52e176c7ca00bb65990ab528 - opengatem (git)

OpengateM Source Repository

Commit MetaInfo

• Revision: db3077789b8fd3ac52e176c7ca00bb65990ab528 (tree)
• Time: 2016-06-25 17:44:40
• Author: watanaby <watanaby@user...>
• Commiter: watanaby

Log Message

added padding in popup. fix mysql query in acquiring log list

Change Summary

• modified: doc/Changes.html
• modified: html/showlog.js
• modified: mngsrc/managementdb.c

Incremental Difference

--- a/doc/Changes.html
+++ b/doc/Changes.html
@@ -275,9 +275,9 @@ OpengateM History</H3>
 	</DT><DD>
         Modified code to prevent inflation of Databases (drop table macippair/sessionmd:MySQL, delete old records of macmodify:MySQL and macinfo:SQLite3).
 	</DD>
-	<DT>Ver.1.1.1 at 2016.6.24
+	<DT>Ver.1.1.1 at 2016.6.25
 	</DT><DD>
-        Restored table sessionmd in management db (It holds the log expired after 1 month. Saving-log can be disabled in opengatemd.conf).
+        Restored table sessionmd in management db (It holds the log expired after 1 month. Log-saving can be disabled in opengatemd.conf).
 	</DD>
 </DL>
 <P>

--- a/html/showlog.js
+++ b/html/showlog.js
@@ -43,7 +43,8 @@ function onmouseoverHandler(element, logItemNo) {
 		// popup style
 		popup.style.position = "fixed"; 
 		popup.style.left = e.clientX+20; 
-		popup.style.top  = e.clientY+10; 
+	        popup.style.top  = e.clientY+10;
+		popup.style.padding  = 20;
 		popup.style.background = colorList["popup"]; 
 		popup.style.display = "block";
 

--- a/mngsrc/managementdb.c
+++ b/mngsrc/managementdb.c
@@ -502,7 +502,7 @@ int getNextUsageLogFromMngDb(char* userId, char* extraId, char* macAddr, char* d
 	     " gatewayName "
 	     " from macaddrs, sessionmd "
 	     " where macaddrs.macAddress=sessionmd.macAddress "
-	     " and entryDate < openTime and openTime < limitDate "
+	     " and entryDate <= openTime and openTime <= limitDate "
 	     " and (%s<closeTime or closeTime=0) "
 	     " and userId='%s' and extraId='%s'",
 	     GetConfValue("ShowLogAfter"), userId, extraId);