Elbanco Rodriguez

Been Around
  • Content count

    125
  • Joined

  • Last visited


Reputation Activity

  1. Devajufan liked a post in a topic by Elbanco Rodriguez in Breaking News: BF1 Server Rental stated?   
    This game's server side things are complete meh right now...
    Why on earth they had to scrap working server system...oh wait, badmins everywhere and "unified gaming experience on all platforms" >_>

    Well done ruining game for PC players. 
  2. Devajufan liked a post in a topic by Elbanco Rodriguez in Breaking News: BF1 Server Rental stated?   
    This game's server side things are complete meh right now...
    Why on earth they had to scrap working server system...oh wait, badmins everywhere and "unified gaming experience on all platforms" >_>

    Well done ruining game for PC players. 
  3. Elbanco Rodriguez liked a post in a topic by L0s-Am1g0 in Breaking News: BF1 Server Rental stated?   
    And they can only kick / ban from within the game, so have to load the game first, then bring down a menu from within the game.
    As always. EA sucks!
  4. lampje1990 liked a post in a topic by Elbanco Rodriguez in Revolucion Radio   
  5. Devajufan liked a post in a topic by Elbanco Rodriguez in Revolucion Radio   
    If only Varien had physical releases I'd buy them...won't buy any digital music...
     
  6. Elbanco Rodriguez liked a post in a topic by HptmNaumann in Revolucion Radio   
  7. Elbanco Rodriguez liked a post in a topic by El Edwina in A small problem   
    The forum was migrated to new hosting a few weeks ago. It's likely a result of that so I'll look into it. 
  8. Elbanco Rodriguez liked a post in a topic by MrIbra in [Steam] DiRT Showdown (Free game)   
    Get it while you can!
    https://www.humblebundle.com/store/dirt-showdown-free-game
     
  9. lampje1990 liked a post in a topic by Elbanco Rodriguez in Revolucion Radio   
  10. Sanslik liked a post in a topic by Elbanco Rodriguez in Server Rental, Yes I do.   
    I'd guess this one:
    Complete post in here: https://forums.battlefield.com/en-us/discussion/61545/an-announcement-from-alexander-hassoon-regarding-rsp
  11. kirikou97212 liked a post in a topic by Elbanco Rodriguez in Revolucion Radio   
    For some reason I prefer this version:
     
  12. Elbanco Rodriguez liked a post in a topic by JaYDee in Freebie Dirt 3 Complete Edition   
    https://www.humblebundle.com/store/dirt-3-complete-edition-free-game
  13. DivXion liked a post in a topic by Elbanco Rodriguez in Drones - anyone have one?   
    How come this hasn't been in thread yet...
    Endless possibilities what one can put on drone...
  14. Devajufan liked a post in a topic by Elbanco Rodriguez in Official Movie Thread   
  15. DivXion liked a post in a topic by Elbanco Rodriguez in Drones - anyone have one?   
    How come this hasn't been in thread yet...
    Endless possibilities what one can put on drone...
  16. Devajufan liked a post in a topic by Elbanco Rodriguez in Official Movie Thread   
  17. Elbanco Rodriguez liked a post in a topic by Z3N1G4T4 in Halloween Treat   
    A little treat for Halloween
    Have you ever wondered where your precious precious BF4 reports are?
    I did ...
    some data:

    the columns used:

    some stats:



    and some slicers:

     
    Let's start:
    • get the reports IDs
        • brute force through IE
    • make an API call to get the data
        • relevant link and documentation
    • choosing the DB
        • importing the data
        • exporting the data
    • use the data

    GET THE REPORTS IDs:
    the basic idea is to collect all the reports IDs of the games that were played.
    Since I was not able to find anything similar to an API call to extract that first
    needed data I did the next reasonable thing (at least for me) and it was automating
    a tedious navigation task.
    So: go to your reports and click "view more reports", inspect the various tables/div
    with the built-in inspector and voilà, that's it. You'll see that the reports ID are
    there, you just need to be a little creative with data carving. If you are used to
    this you'll find it pretty trivial.
    The only way I know to automate IE is through Visual Basic Script, so I basically wrote
    a procedure that opens IE, navigates to my reports, clicks "view more reports" thousands and thousands
    of times and collect a specific element by his Tag Name and gently ask to give me
    one of its specific attribute.
    In the end I decided to rewrite the script in VBA and coded directly inside Excel for
    practical simplicity. So now I can quickly check if a specific ID was already downloaded etc.

    MAKE AN API CALL TO GET THE DATA:
    that's simpler than the previous part.
    Look at this: https://github.com/akwaz/blAPI
    having the list of reports and the relevant API call you can now develop something
    to get the data. I coded it right in Excel with VBA.
    Enjoy your reports saved one by one in JSON format

    CHOOSING THE DB:
    I don't know much about DBs, SQL Server aside I know very little. At the beginning I
    was determined to write my own interpreter but after some analysis I decided not to
    invest so much time in it.
    Asking around I found out that MongoDB is pretty awesome at handling JSON data.
        IMPORTING THE DATA:
        at this stage you already have your precious reports saved so just install MongoDB.
        Create a DB, create your new collection and import all the files.
        Not having much familiarity with this tool and not knowing how it is supposed to be
        automated I went the brutal way as always. Batch files FTW!
            
    for %%f in (*.txt) do ( please import my files )
        I, obviously, called that .bat through VBA in Excel...just you know, I do everything
        through Excel and probably not in the best way. But it works...so
        Using this kludge I count for the records and verify if match with the reports count I've previously downloaded etc.
        
        EXPORTING THE DATA:
        that part is quite simple, you just need to investigate the JSON through something that transforms it in human-readable strings.
        In this instance I used a plug-in for Notepad++, named JSON Viewer, to analyze the structure and choose
        the columns to export. I started looking up Stack Overflow, you'll find everything and beyond.

    USE THE DATA:
    now that your data is in a table format, and practical to analyze, just use your preferred software
    to do it
    Would you like to guess what I used? Yes, Excel again!
    You could use R, or even KNIME (and R) for some complex statistical analysis.
  18. Elbanco Rodriguez liked a post in a topic by HptmNaumann in Revolucion Radio   
  19. Elbanco Rodriguez liked a post in a topic by HptmNaumann in Revolucion Radio   
  20. MoJo liked a post in a topic by Elbanco Rodriguez in Images of items I/You/We have recently purchased.   
    In the end that one cd I was going to buy, got multiplied...
     
  21. Devajufan liked a post in a topic by Elbanco Rodriguez in Revolucion Radio   
  22. El Kedalfi liked a post in a topic by Elbanco Rodriguez in Revolucion Radio   
  23. MuddyEdg liked a post in a topic by Elbanco Rodriguez in My motorcycle crash   
    Could've been worse. You were lucky if twisted mirror was the only thing that broke.
    Don't want to even think what would've happen for my bike...on my luck fairings and some other shit would've been broken
    Luckily no crashes here yet.
  24. MuddyEdg liked a post in a topic by Elbanco Rodriguez in Weird laws   
    Note to self: "Never visit Indonesia" >_>
    ...or don't get caught.
    Some further reading on the matter: Link
  25. DivXion liked a post in a topic by Elbanco Rodriguez in Test your pc.   
    http://www.userbenchmark.com/UserRun/1485932
     
    UserBenchmarks: Game 99%, Desk 123%, Work 89%
    CPU: Intel Core i7-6700K - 101.3%
    GPU: AMD R9 390 - 89.3%
    SSD: Samsung 850 Evo 250GB - 117.3%
    SSD: Samsung 950 NVMe PCIe M.2 256GB - 206.8%
    SSD: Samsung 850 Evo 500GB - 84.5%
    HDD: WD Green 2TB (2012) - 76.1%
    RAM: G.SKILL Ripjaws 4 DDR4 2666 C15 4x8GB - 90.9%
    MBD: Asus SABERTOOTH Z170 MARK 1