Jump to content
Sign in to follow this  
laffo16

tricky question, help plz

Recommended Posts

laffo16

does anyone know of an easy way to compair two different time stamps. I'll go into a little more details, when playing poker online, all hand historys are recorded into a program called poker tracker (as an mdb). The databases information is updated every minute, their is a column in a particular table which gives the time stamp of when a table is closed (session_end) eg 20060716051500 (year, month, day, hour, minute, second). In my script i need to know if a session is over 5 minutes old. I understand you can use a few built in macros to get the date/time, but is their any easy to say, if session_end time is 5 minutes or older then current time?

i tried to work it out but just got confused :\

thanks for any help.

Share this post


Link to post
Share on other sites
MHz

Instead of watching for the Universal Time Coordinate format modification. You can set WMI to watch the mdb file (hopefully is local). AutoIt Beta is needed for this. The output shown here will ConsoleWrite to the console of your editor if the modification event is older then 5 minutes.

; File to watch for modification
$file = 'Path\to\file.mdb'

; Setup WMI
$sComputer = @ComputerName
$oWMIService = ObjGet("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & $sComputer & "\root\cimv2")
$colMonitoredEvents = $oWMIService.ExecNotificationQuery _
    ("SELECT * FROM __InstanceModificationEvent WITHIN 10 WHERE " _
    & "TargetInstance ISA 'CIM_DataFile' AND " _
    & "TargetInstance.Name='" & StringReplace($file, '\', '\\') & "'")
 
While 1
    ; Reset timer to zero
    $time = TimerInit()
    ; Monitor file for event
    $oLatestEvent = $colMonitoredEvents.NextEvent
    ; Output if event older then 5 minutes
    If TimerDiff($time) > (5*60000) Then
        ConsoleWrite('Time: ' & @HOUR & ':' & @MIN & ':' & @SEC & @LF)
        ConsoleWrite("File: " & $oLatestEvent.TargetInstance.Name & @LF)
        ConsoleWrite("New size: " & $oLatestEvent.TargetInstance.FileSize & @LF)
        ConsoleWrite("Old size: " & $oLatestEvent.PreviousInstance.FileSize & @LF)
    EndIf
WEnd

Share this post


Link to post
Share on other sites
Broots

Instead of watching for the Universal Time Coordinate format modification. You can set WMI to watch the mdb file (hopefully is local). AutoIt Beta is needed for this. The output shown here will ConsoleWrite to the console of your editor if the modification event is older then 5 minutes.

; File to watch for modification
$file = 'Path\to\file.mdb'

; Setup WMI
$sComputer = @ComputerName
$oWMIService = ObjGet("winmgmts:" _
    & "{impersonationLevel=impersonate}!\\" & $sComputer & "\root\cimv2")
$colMonitoredEvents = $oWMIService.ExecNotificationQuery _
    ("SELECT * FROM __InstanceModificationEvent WITHIN 10 WHERE " _
    & "TargetInstance ISA 'CIM_DataFile' AND " _
    & "TargetInstance.Name='" & StringReplace($file, '\', '\\') & "'")
 
While 1
    ; Reset timer to zero
    $time = TimerInit()
    ; Monitor file for event
    $oLatestEvent = $colMonitoredEvents.NextEvent
    ; Output if event older then 5 minutes
    If TimerDiff($time) > (5*60000) Then
        ConsoleWrite('Time: ' & @HOUR & ':' & @MIN & ':' & @SEC & @LF)
        ConsoleWrite("File: " & $oLatestEvent.TargetInstance.Name & @LF)
        ConsoleWrite("New size: " & $oLatestEvent.TargetInstance.FileSize & @LF)
        ConsoleWrite("Old size: " & $oLatestEvent.PreviousInstance.FileSize & @LF)
    EndIf
WEnd
MHZ ... thanks for your help ... you guidance for this post has helped me answer my query over here

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×