Bandwidth Quota permanent reset

[misterm]

The same theme has been discussed before, but the error is still in version 2.2.4.
I have reinstalled everything, but I have still the problem.

I use the program in Germany. (time format?, date format?)

Sorry for my english...

THX

[Shane]

I think the program is getting it confused with the time format. I made the program on my computer, which is sent to English and USA for time and date format.

I think the problem comes down to me having it store the time and date as 1 string instead of breaking the date apart. I bet if I do that instead this will fix the problem. You willing to test that for me once I make an update? 

Shane

[misterm]

Hallo Shane,

how far is the update. could not wait longer...

thx

marco

[Shane]

Holy crap I forgot 

I got started on my first game for the iPad which I am releasing next week. So I totally spaced it lol

As soon as I finish up this current project I will get started. I have a sticky pad on my monitor to remind me

I will even try and see how big of a job it will be and see if I can do the update this weekend, can't promise though.

Shane

[Shane]

I leave on the 9th for a week to go to my sisters wedding.
So I want to get this done before then.

But I do have a problem and need to find the best way to handle it.

Right now the date is stored in 1 column in the database. In order to read the date properly I need to break the date apart and store it in 3 columns instead.
The problem is when I make this change the old database will no longer work right, so old logs wont be of any use for the dates.

For you this should be fine since the date isnt working right anyways. But the problem is what about the other users who it does work for? all the old logs will have to be cleared and start fresh.

At least this will be a one time thing. Not sure whats the best way to handle it.

Shane

[Shane]

I think I may have an idea that would fix the problem and without having to change the database.

In the program I have the date and time saving as

sCurrentDate = Format(Date, sDateFormat)
sCurrentHour = Format(Time, "h")

Which the word "Date" and "Time" both pull the date and time as a whole from the system. Which means it also pulls in the format of the user's system.

This is where it is messing up, when it loads the date from the database it is reading in the default format from the US. So its getting the day and months backwards on you.

I think that the trick will be is to have it store the date and time in the same default format instead of the users system.

Then when it is pulled from the database it can be formatted to the users system properly.
Only thing is I will need some testing done.
I can get a test exe made today if your up to help me test

Shane

[Shane]

OK well I changed my xp system to a german time format and I think I got it all fixed.
New versions is out

Make sure that you go to reports, then options. And set the right date format you want to use.

I ended up not having to change the database.
It turned out I had the date saving to the database with the format set in the report options instead of by the system default format. After changing that things seem to start working much better


Let me know how it goes.

Shane

[misterm]

Hi Shane,

when I look at reports everything is OK, but the "bandwidth quota monitor" reset the traffic back again and again.

Do you understand what I mean?


The two monitor screenshots have been made immediately after the other.


Marco 

[Shane]

What does the auto reset screen show for the last and next reset time?

Shane

[misterm]

 

[Shane]

Odd, I have the auto reset and the new version set and its working fine.
Did you set the date format option in the report options?

Shane

[misterm]

have it set so

[Shane]

How often is the quota resetting?

Shane

[misterm]

uneven

[misterm]

I tested with a stopwatch
approximately one minute to the next reset


I think it is exactly 1 minute