So, here is a simple server log parser, which will search log files for every unique kill it can find, and run specific query which you can define by yourself.
WARNING: Before you execute this first time, better ensure there is no
logs from different server in your server folder.
Didnt add cap 110/120 uniques yet, since wrote this for my 100 cap srv.
cfg.ini contains common settings for mssql connection and such
rewards.ini file contains definitions for mob kill rewards
cfg.ini -> maxLevelDifference = how much levels higher can character be than unique level
cfg.ini -> query directive
basically, for writing custom query
function has 4 format arguments -
means, you can use them in query this way (few examples):
query=UPDATE MYTABLE SET POINTS=(POINTS + {0}) WHERE AccountName='{1}'
query=UPDATE SK_Silk set silk_own = (silk_own + {0}) where JID='{4}'
*removed* [v1.0.5 - fixed query]
Contents should be extracted and runned from the server folder.
Please, report all the issues you get (better, with exception text).
WARNING: Before you execute this first time, better ensure there is no
logs from different server in your server folder.
Didnt add cap 110/120 uniques yet, since wrote this for my 100 cap srv.
cfg.ini contains common settings for mssql connection and such
rewards.ini file contains definitions for mob kill rewards
cfg.ini -> maxLevelDifference = how much levels higher can character be than unique level
cfg.ini -> query directive
basically, for writing custom query
function has 4 format arguments -
Code:
{0} - nPoints
{1} - Username
{2} - CharID
{3} - charName
{4} - userJID
query=UPDATE MYTABLE SET POINTS=(POINTS + {0}) WHERE AccountName='{1}'
query=UPDATE SK_Silk set silk_own = (silk_own + {0}) where JID='{4}'
*removed* [v1.0.5 - fixed query]
Contents should be extracted and runned from the server folder.
Please, report all the issues you get (better, with exception text).
