shaitan Posted June 30, 2014 Posted June 30, 2014 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=OSTKshaiPlayerIP=24.*.*.*:49402SelectedVeterancy=ScrnVetCommandoSelectedChar=DamageHealedStat=124583WeldingPointsStat=24153533ShotgunDamageStat=71423506HeadshotKillsStat=39278StalkerKillsStat=373068BullpupDamageStat=1065433910MeleeDamageStat=58803875FlameThrowerDamageStat=54757196SelfHealsStat=22346SoleSurvivorWavesStat=344CashDonatedStat=2497092FeedingKillsStat=51BurningCrossbowKillsStat=52GibbedFleshpoundsStat=1533StalkersKilledWithExplosivesStat=2063GibbedEnemiesStat=68711BloatKillsStat=13936SirenKillsStat=17095KillsStat=480742ExplosivesDamageStat=49443588TotalPlayTime=2526738WinsCount=634LostsCount=539TotalZedTimeStat=280695.000000cc=(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 Posted June 30, 2014 Posted June 30, 2014 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
woolwind Posted June 30, 2014 Posted June 30, 2014 Are you trying to compare 2 files of 3000 lines each, or 3000 separate files? in Unix?
BillieJoe67 Posted June 30, 2014 Posted June 30, 2014 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 Posted June 30, 2014 Author Posted June 30, 2014 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 Posted June 30, 2014 Posted June 30, 2014 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 Posted June 30, 2014 Author Posted June 30, 2014 It adds both values together Billie. File A: TotalPlayTime=1988613 File B: TotalPlayTime=2538902 It gave me 4527515.
BillieJoe67 Posted July 1, 2014 Posted July 1, 2014 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 Posted July 1, 2014 Author Posted July 1, 2014 lol I'll check it when I get off of work tonight.
BillieJoe67 Posted July 5, 2014 Posted July 5, 2014 Leaving this here so I don't forget it http://jsfiddle.net/hAxFn/14/
shaitan Posted July 20, 2014 Author Posted July 20, 2014 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 Posted July 21, 2014 Posted July 21, 2014 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 Posted July 25, 2014 Author Posted July 25, 2014 I so did not read this. D: When I get to it, I'll pm you.
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now