Jump to content
RenCorner Network

database file comparison


shaitan
 Share

Recommended Posts

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")

Link to comment
Share on other sites

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 ;)

Link to comment
Share on other sites

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

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 .

Link to comment
Share on other sites

It adds both values together Billie.

 

File A:  TotalPlayTime=1988613

File B:  TotalPlayTime=2538902

It gave me 4527515.

Link to comment
Share on other sites

  • 2 weeks later...

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...