d2jsp
Log InRegister
d2jsp Forums > Diablo II > Diablo 2 Discussion > Ladder Tracker > Character Statistics
Prev15678943Next
Add Reply New Topic New Poll
Member
Posts: 750
Joined: Jun 12 2020
Gold: 0.00
Jun 15 2020 09:43am
Quote (Rontu @ 15 Jun 2020 17:17)
hi, not sure if i understand your question.
We store a snapshot of the current ladder every 20 mins. So people with unchanged xp will also be saved there again.
This data is important to us, as we can run analysis (like bot detection) or show diagrams per char over time

Im saying storing entries with same xp is pointless, if xp doesn’t change you already know they did not play/gain any xp. You are flooding yourself with pointless data.
Member
Posts: 15,272
Joined: Aug 9 2009
Gold: 2,387.00
Jun 15 2020 11:09am
Quote (freeuse @ Jun 15 2020 05:43pm)
Im saying storing entries with same xp is pointless, if xp doesn’t change you already know they did not play/gain any xp. You are flooding yourself with pointless data.


Well we could do, but for the moment database space is not a problem, it might be in future if we add other realms. Then I will think about your point, thx for your input ^_^

This post was edited by Rontu on Jun 15 2020 11:10am
Member
Posts: 15,272
Joined: Aug 9 2009
Gold: 2,387.00
Jun 15 2020 11:10pm
Up
Member
Posts: 7,584
Joined: Feb 21 2007
Gold: 17,089.00
Jun 16 2020 12:18am
I don't think that storing 1,7k entries every 20min is going to be a problem. If it really becomes a problem you could set up a cron job and clear entries that are older than, lets say, 7 days.
In a week there will be around 850k entries per realm and for a database thats not really a lot.


Cool project! Any plans on releasing the source code?
Member
Posts: 15,272
Joined: Aug 9 2009
Gold: 2,387.00
Jun 16 2020 10:09am
Quote (PlueschPsycho @ Jun 16 2020 08:18am)
I don't think that storing 1,7k entries every 20min is going to be a problem. If it really becomes a problem you could set up a cron job and clear entries that are older than, lets say, 7 days.
In a week there will be around 850k entries per realm and for a database thats not really a lot.


Cool project! Any plans on releasing the source code?


Ah nice to see another person from austria.
Yea well it's 1.7k entries per ladder list, we are currently tracking 4 lists, so it's around 5.7k entries per cycle.

There are no plans in releasing the source code. It was some work getting everything set up and getting the data and we don't want to get copied easily (although I don't think that's very likely).
Maybe you could tell us more why you care about releasing the source code?
Would you be interested into the full source code, or only parts like the web application, bot detection or data catching?

Thanks for your feedback and time ^_^
Member
Posts: 7,584
Joined: Feb 21 2007
Gold: 17,089.00
Jun 16 2020 01:26pm
Hehe yeah there a few from austria around ;)

Ah right my bad, but still it should be manageable by a db.

No, it was just a general question - nowadays a lot of projects are open source and to be honest I am just curious and like to see how they are made :)

> There are no plans in releasing the source code. It was some work getting everything set up and getting the data and we don't want to get copied easily (although I don't think that's very likely).

I completely understand.
Member
Posts: 47,433
Joined: Jun 6 2015
Gold: 33,448.00
Jun 16 2020 01:32pm
Would love a hardcore East graph
Member
Posts: 15,272
Joined: Aug 9 2009
Gold: 2,387.00
Jun 16 2020 01:49pm
Quote (PlueschPsycho @ Jun 16 2020 09:26pm)
Hehe yeah there a few from austria around ;)

Ah right my bad, but still it should be manageable by a db.

No, it was just a general question - nowadays a lot of projects are open source and to be honest I am just curious and like to see how they are made :)

> There are no plans in releasing the source code. It was some work getting everything set up and getting the data and we don't want to get copied easily (although I don't think that's very likely).

I completely understand.


yep it is. But it might get interesting if we add other realms.
still pm'd ya some information about the site

Quote (BasedGoff @ Jun 16 2020 09:32pm)
Would love a hardcore East graph


will think about it, but is not an easy task for us
Member
Posts: 47,433
Joined: Jun 6 2015
Gold: 33,448.00
Jun 16 2020 01:50pm
Quote (Rontu @ Jun 16 2020 11:49am)
yep it is. But it might get interesting if we add other realms.
still pm'd ya some information about the site



will think about it, but is not an easy task for us


is it financials? i know the east hardcore ladder community would donate funds to make this happen
Member
Posts: 15,272
Joined: Aug 9 2009
Gold: 2,387.00
Jun 16 2020 02:24pm
Quote (BasedGoff @ Jun 16 2020 09:50pm)
is it financials? i know the east hardcore ladder community would donate funds to make this happen


it's not primary about financials. More about the work that has to be done to add all realms. For us the important part is hearing that people would love it to happen - that motivates of course.
We will see what we can do. ^_^
Go Back To Diablo 2 Discussion Topic List
Prev15678943Next
Add Reply New Topic New Poll