XP Pruning.

[ferrets]

Hi,

A quick question regarding XP pruning and the change in the new 2.3.1 version

Change: Not all old data will be erased, the most current timestamp will be checked and all other records will be updated to that timestamp

When does it update all the races time field in the database to the most recent connection time?

when they next join server?
or when it checks database for fields to delete?

basically do i need to wait a few weeks before i turn on the database pruning to allow all the regulars to connect and the mod update all their races with their most recent connection time?


Thanks

[Krazy]

When does it update all the races time field in the database to the most recent connection time?

when they next join server?
or when it checks database for fields to delete?

Yes, when they next join server.

basically do i need to wait a few weeks before i turn on the database pruning to allow all the regulars to connect and the mod update all their races with their most recent connection time?

I am waiting 2 months before I enable the pruning again to make sure people do not lose their xp, so yes I think it is a smart idea.

[ferrets]

Thanks Krazy,

I just connected to my server and then checked the database and all of the time fields were different? If it does update the time field when the user joins it doesn't seem mine did

I will wait a bit longer anyway before turning it on

[Alphawolf]

It will update the timefield at round end or if the player types savexp. It depends on your settings.

[ferrets]

I just joined my server and a few rounds ended and I waited until the map changed.

as you can see all my records don't have my most recent connection time.

I think I am missing something really obvious here



Thanks

[Geesu]

It updates them all at once when the player joins (based on steam id)... Perhaps you haven't updated

[ferrets]

[ 21] Warcraft 3 Frozen 2.3.1b Geesu==(Pimp Dad warcraft3FT.amx running

lol ... do i have to enable database pruning for it to do this?

[Geesu]

yes

[ferrets]

Thanks Geesu,

Okay my last stab at how I think it works.

Right so it wont update the time feild with auto pruning set to 1 but if we set it it will delete all the old fields without anyone getting a chance to join?

So this is not possible with FT_auto_pruning set to 0

I am waiting 2 months before I enable the pruning again to make sure people do not lose their xp, so yes I think it is a smart idea.

then I guess I just have to set it to a large amount of days to start with?

sv_daysbeforedelete 31

Am I on the right lines now?

[ferrets]

Ok thanks a lot Geesu just tried it out and it worked

have set the number of days to 300 for now