The last days we are busy with an update process of Airio, EQ Worry does some major restructuring and because of that I needed to alter/restart the system a lot.

The problem is that the database of Airio has became corrupt over the months.. It's a pure text database and Airio simply doesn't restart anymore without the help of a backup file 'trick' ... Normally thats not that much of a problem to import all data from the backup after a restart but... The backup didn't run anymore since last Wednesday. I didn't realized that, sorry

I got some complains from people who lost a considerate amount of points. I'm sorry but I cannot do anything about that

I will make an alert/warning thing now, so there is a warning when the backup gets out of sync. Over the months the database has risen to 227.000 records and it's impossible to check manually what exactly is causing this corruption. I warned EQ Worry a couple of times already that this amount of data cannot be handled anymore in a textual way but he is only a human too ( ) and some even bigger restructuring is needed to fulfill my requests / feature demands.

In the meantime I have to do it with this backup process so it's vital that it keeps running every minute. (Normally every minute a backup is being made).

On the website there will be an error shown when the backup fails. (Or maybe it's better to show a time, also when its good).

For now, sorry for the loss of points of the 4 or 5 days

On the other hand, everybody can start driving UFR/XFR on the GTR server without a problem

Does this also affect the global experience index, or just rank points and safety rating on Cargame?

No global affects.

Not sure if this is the intended message, but the message telling us stats updated contains a stock PHP mysql warning message (can't see full error as it is truncated).

Oh no, hackers attack!

you need to coerce EQ Worry into getting the DB into MYSQL or Prostgress as text files are far from ideal for storing large amounts of data.

Exactly... Worry underestimated the whole data gathering a bit. The backup database which I'm talking about actually is a SQL powered database and Airio is writing to it. But it doesn't read. The complete structure of Airio must be changed for that. Would love to see that happen


In game message, hhmm even better

But no, I am causing that error. It's because open track layouts are not recognized properly yet and thats why the end table is failing in timing as a result of that. When a race starts, certain 'things' get initiated.

work hard with that

I know; http://www.flasharcade.com/arcade-games ... -game.html

Airio is now partly SQLite powered

!pi and !pb are optimized and it's lightning fast again. Happy with the progress

Even Harvey has it's !pi back

mmmm....seee-quill
is that why i spotted EQ Worry on the server this afternoon, checking the his handy work with the Airio SQL fix?

Checking performance yeah, we have the biggest database of the gamez... After I added an index for !pb it really went lightspeed.

But we still experience some problems. It's unstable.

Sorry for the people this evening who experience troubles but we have to go through this... To make the world better, blabla

to coin a phrase:

you can't make an omelette without breaking some eggs.

It's for the better good there are bound to be a few "teething problems"

Loving your work

sorry to bump this. but.. ive noticed as i go alot to AA and here.. i got different stats on airattack and here. for example i do not have the same points in safety and !ex.
why is that? doesnt the airio go with same stats?

i been meaning to ask this for a long time but keep forgetting it when i see EQ on AA.
now i remembered due to this thread. some other stats dont match aswell, so ive just been wondering about this for some time now.

any answer to it?
or is it simply.. do stats both places...?

Ofcourse safety is different...

!ex should be the same.

!ex, or Live For Speed Experience Index (LFSEI), is a global statistic/index. Anything else such as rank and safety rating is local on each server, or in the case of Cargame.nl, local to the network and it's servers.

hm.... then something aint working properly..

This is your !ex at Airio World:
http://stats.airio.eu/EXD.aspx?U=THE%20WIZARD%20DK

On which server is your !ex different from that in the link above?