XP Pruning.

ferrets · Post by **ferrets** » Tue Feb 07, 2006 11:12 am

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

Post by **Krazy** » Tue Feb 07, 2006 3:25 pm

ferrets wrote: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.

ferrets wrote: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 · Post by **ferrets** » Wed Feb 08, 2006 4:14 am

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 · Post by **Alphawolf** » Wed Feb 08, 2006 4:17 am

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

ferrets · Post by **ferrets** » Wed Feb 08, 2006 4:34 am

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

Post by **Geesu** » Wed Feb 08, 2006 12:34 pm

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

ferrets · Post by **ferrets** » Wed Feb 08, 2006 1:19 pm

[ 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?

Post by **Geesu** » Wed Feb 08, 2006 7:23 pm

ferrets · Post by **ferrets** » Thu Feb 09, 2006 2:16 am

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 · Post by **ferrets** » Thu Feb 09, 2006 2:38 am

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

have set the number of days to 300 for now

Warcraft 3 MODs

XP Pruning.

XP Pruning.

Re: XP Pruning.