saving history

NewUser2 · Guest

What's an easy way for me to build an accurate local database of charaters on my server and also make daily snapshots for use here.

I am thinking a fresh daily snapshot would be like:
1. Purge
2. DateStamp
3. Take Census
4. Upload

which would wipe out my local data. What's the simple solution to have access both sets of data?

Rollie · Posted: Thu Jan 20, 2005 9:40 am Post subject:

If you are using the /censusdate function then you don't need to purge unless you just want to.

Purging is recommended if you do not use the /censusdate function as I have no way to tell how old an entry is when it is submitted.

NewUser2 · Guest

ok, so if I use the command, I can keep building my local data and give you the snapshots you need for more accurate seen last data - awsome, that took a bit to sink in.

What If I send in 2 files with the same stamp: is one rejected or last one in counts?

Like today I did stamp for 20th, did a census and sent in file. I have done more census since then, so I have different data in my file.

If I upload another file later today with the same stamp, will it get used?

Rollie · Posted: Thu Jan 20, 2005 9:49 am Post subject:

They all get used. Here is how the process works.

When you take a census, it will save off 3 things:

char name
level
guild
Timestamp - (with date if you use /censusdate, or will say NS)

Now, when I process the entries, I look at the datestamp. If one is not available (NS is there), then I will just use the current date and update. If a date is there, then I will use the given date.

I then compare the given level with the one I have for this char in the database. If the new level is higher, then I will update the char record in the database. If the new level is lower, then I will ignore that entry.

Make sense?

So long story short, yeah, keep sending them in. They all count =)

NewUser2 · Guest

Yup, will do thanks.