Page 1 of 1
XP Pruning.
Posted: Tue Feb 07, 2006 11:12 am
by 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

Re: XP Pruning.
Posted: Tue Feb 07, 2006 3:25 pm
by Krazy
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.
Posted: Wed Feb 08, 2006 4:14 am
by 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
Posted: Wed Feb 08, 2006 4:17 am
by Alphawolf
It will update the timefield at round end or if the player types savexp. It depends on your settings.
Posted: Wed Feb 08, 2006 4:34 am
by 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
Posted: Wed Feb 08, 2006 12:34 pm
by Geesu
It updates them all at once when the player joins (based on steam id)... Perhaps you haven't updated

Posted: Wed Feb 08, 2006 1:19 pm
by 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?
Posted: Wed Feb 08, 2006 7:23 pm
by Geesu
yes
Posted: Thu Feb 09, 2006 2:16 am
by 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?

Posted: Thu Feb 09, 2006 2:38 am
by ferrets
Ok thanks a lot Geesu just tried it out and it worked
have set the number of days to 300 for now
