database file comparison

[shaitan]

I was wondering if any of you know of a way to compare two files(having over 3000 entries), run a search/script, and see which value is the highest of the two files?
 
In red is each persons SteamID, so that part would be a good constant to use. The TotalPlayTime is each persons gametime.
Run script/sql/whatever, using A file with B file, check TotalPlayTime numbers under each SteamID column, and get the person with the highest amount played between A and B.
 
I already have the files getting saved/copied each hour. I'd like to be able to once a week make a Steam PlayerOfTheWeek. If it's possible that'd be great, if so maybe we can extend it to these other values like DamageHealedStat.
 
 
[76561197996249999 StatsObject]
PlayerName=OSTKshai
PlayerIP=24.*.*.*:49402
SelectedVeterancy=ScrnVetCommando
SelectedChar=
DamageHealedStat=124583
WeldingPointsStat=24153533
ShotgunDamageStat=71423506
HeadshotKillsStat=39278
StalkerKillsStat=373068
BullpupDamageStat=1065433910
MeleeDamageStat=58803875
FlameThrowerDamageStat=54757196
SelfHealsStat=22346
SoleSurvivorWavesStat=344
CashDonatedStat=2497092
FeedingKillsStat=51
BurningCrossbowKillsStat=52
GibbedFleshpoundsStat=1533
StalkersKilledWithExplosivesStat=2063
GibbedEnemiesStat=68711
BloatKillsStat=13936
SirenKillsStat=17095
KillsStat=480742
ExplosivesDamageStat=49443588
TotalPlayTime=2526738
WinsCount=634
LostsCount=539
TotalZedTimeStat=280695.000000
cc=(N="Ach",V="F22B4C77873E19D900E0C9FAE05C00B284072623F380A1AF2FF3FE7CCFBEC27BFD93BF7F7CFFE90B7E673A80E8DEF264FF01")
cc=(N="AchMaps",V="37101330103100010011011000000000000000000000")
cc=(N="ScrnPistolKillProgress",V="38769")
cc=(N="ScrnPistolDamageProgress",V="12011901")
cc=(N="SentryTechPerkProg",V="8517563")

[Strike]

is this logged in a text file or a database (in database you can join multiple tables)?

Hit me up on irc/ts and i will write you the query string to solve it

[shaitan]

.INI file

I'll pm you a link here.

[woolwind]

Are you trying to compare 2 files of 3000 lines each, or 3000 separate files?  in Unix?

[BillieJoe67]

Probably fairly buggy: http://jsfiddle.net/hAxFn/4/

 

Only works with integer stats (ie the ones I added in supportedStats)

 

Select the stat you want to compare on and drag the file into the square (you currently have to drag the first one twice cus voodoo, any subsequent files work first time).

The stat is not auto-selected on page load for some reason

The clear button doesn't work, neither does changing the selected stat - you'll have to refresh the page and re-drag the files.

Dragging subsequent files means the values are appending to the existing stats where appropriate (I think this is what you wanted? original post wasn't terribly clear)

 

If you actually use this, drop me a pm and I'll try to fix it up.

 

Edit: I'm a noob, was using old style event names with new event listeners - most issues are now fixed thanks to removing two characters twice

[shaitan]

Woolwind, its a killing floor mutator, and a part of it is this stat system for the perks. It keeps record/gives the player their perk levels/etc.

Its all stored in that .INI file. At the moment there is over 220,000 lines. Over 3000 people, with all their stats.

[vlatkozelka]

Woolwind, its a killing floor mutator, and a part of it is this stat system for the perks. It keeps record/gives the player their perk levels/etc.Its all stored in that .INI file. At the moment there is over 220,000 lines. Over 3000 people, with all their stats.

if its 2 files ... i can make a parser for u , u give it 2 files it gives u playerOfTheWeek ... unless u want something else .

[shaitan]

It adds both values together Billie.

 

File A:  TotalPlayTime=1988613

File B:  TotalPlayTime=2538902

It gave me 4527515.

[BillieJoe67]

I did misunderstand then 

 

http://jsfiddle.net/hAxFn/10/

That should show the highest value from any file you drag (but it can only support dragging one file at a time (I'll fix the multiple file support later))

[shaitan]

lol I'll check it when I get off of work tonight.

[BillieJoe67]

Leaving this here so I don't forget it http://jsfiddle.net/hAxFn/14/

[shaitan]

Welp it's been awhile, I've got a shitload of logs saved up for this. It doesn't work though. If you put in one file, it says i need two at once. If I do two at once, nothing happens.

[woolwind]

Welp it's been awhile, I've got a shitload of logs saved up for this. It doesn't work though. If you put in one file, it says i need two at once. If I do two at once, nothing happens.

sorry, lost track of this thread.  If you have sample files and tell me exactly what you want for output I can script something up pretty easily to run on linux.

[shaitan]

I so did not read this. D:  When I get to it, I'll pm you.