shaitan Posted June 30, 2014 Share 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") Link to comment Share on other sites More sharing options...
Strike Posted June 30, 2014 Share 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 Link to comment Share on other sites More sharing options...
shaitan Posted June 30, 2014 Author Share Posted June 30, 2014 .INI file I'll pm you a link here. Link to comment Share on other sites More sharing options...
woolwind Posted June 30, 2014 Share Posted June 30, 2014 Are you trying to compare 2 files of 3000 lines each, or 3000 separate files? in Unix? Link to comment Share on other sites More sharing options...
BillieJoe67 Posted June 30, 2014 Share 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 Link to comment Share on other sites More sharing options...
shaitan Posted June 30, 2014 Author Share 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. Link to comment Share on other sites More sharing options...
vlatkozelka Posted June 30, 2014 Share 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 . Link to comment Share on other sites More sharing options...
shaitan Posted June 30, 2014 Author Share Posted June 30, 2014 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 More sharing options...
BillieJoe67 Posted July 1, 2014 Share 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)) Link to comment Share on other sites More sharing options...
shaitan Posted July 1, 2014 Author Share Posted July 1, 2014 lol I'll check it when I get off of work tonight. Link to comment Share on other sites More sharing options...
BillieJoe67 Posted July 5, 2014 Share Posted July 5, 2014 Leaving this here so I don't forget it http://jsfiddle.net/hAxFn/14/ Link to comment Share on other sites More sharing options...
shaitan Posted July 20, 2014 Author Share 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. Link to comment Share on other sites More sharing options...
woolwind Posted July 21, 2014 Share 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. Link to comment Share on other sites More sharing options...
shaitan Posted July 25, 2014 Author Share Posted July 25, 2014 I so did not read this. D: When I get to it, I'll pm you. Link to comment Share on other sites More sharing options...
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