PT Log File to Database Parser

Results 1 to 5 of 5
  1. #1
    RZA-PT | KilroyPT Phatkone is online now
    True MemberRank
    Aug 2007 Join Date
    SydneyLocation
    938Posts

    config PT Log File to Database Parser

    PT Log File to Database Parser
    Hi All

    i got sick of sifting through log files so I made this console app that will read and parse them to a database for you.
    Database is simply:

    - ID (INT) Identity,
    - Checksum (NVARCHAR), Checksum of entry used to prevent duplicates
    - Type (NVARCHAR), Log type (admin, debug, server, aging etc etc)
    - Timestamp (DATETIME), log entry time
    - Msg (NVARCHAR), Log message

    First run will prompt you for database connection info, database and table names,
    It will then create the tables in the chosen database.
    It will also create logparser.ini which will hold those settings along with timeout and overwrite
    set overwrite to "true" if you wish it to delete the files once they have been processed (it will only delete if it successfully processes the entire file.
    This helps reduce run time of the task and saves storage space.
    be default this is set to false.
    timeout is the time in minutes between each passing, default is 5 minutes.


    https://drive.google.com/file/d/18fc...iYjaYnZf7/view


    I find this useful cause then logs can be audited through a web interface tool and its much quicker than trying to process over the files every time.

    I hope its of use to others :)


  2. #2
    Fuck. SheenBR is offline
    ModeratorRank
    Feb 2008 Join Date
    Jaú, BrazilLocation
    2,388Posts

    Re: PT Log File to Database Parser

    Why didnt you edit the source code to already save as database records?

  3. #3
    RZA-PT | KilroyPT Phatkone is online now
    True MemberRank
    Aug 2007 Join Date
    SydneyLocation
    938Posts

    Re: PT Log File to Database Parser

    Quote Originally Posted by SheenBR View Post
    Why didnt you edit the source code to already save as database records?
    some of us aren't using the source code

  4. #4
    Fuck. SheenBR is offline
    ModeratorRank
    Feb 2008 Join Date
    Jaú, BrazilLocation
    2,388Posts

    Re: PT Log File to Database Parser

    I see. Well, if you want to improve your knoledge, you can always create a dll to override that specific method and make it work for every server.
    Nonetheless, very good initiative

  5. #5
    RZA-PT | KilroyPT Phatkone is online now
    True MemberRank
    Aug 2007 Join Date
    SydneyLocation
    938Posts

    Re: PT Log File to Database Parser

    yea when life isnt so chaotic I want to build DLL's out of the source for logging and items etc, (much the way vormav did writefield)

    butttt with a kid on the way i think i wont get much time :D



Advertisement