Welcome to the Achaea Forums! Please be sure to read the Forum Rules.

Achaealyzer - a stat tracking database. (Mudlet)

AesiAesi Posts: 1,222Member @ - Epic Achaean

Achaealyzer

  • A database for tracking stats in Achaea.
usage:
  • alz.getstats() - returns all trackable stats in one table, much like GMCP does
  • getstats also takes optional parameters.

alz.getstats("param")

  • "gold" - returns only the gold statistics.
  • "exp" - returns only the experience statistics.
  • "crits" - returns only the critical hit statistics.
  • "pve" - returns only the pve kill/death table
  • "pvp" - returns only the pvp kill/death/arenakill/arenadeath table.

Here is a typical full output (note that It was made today, so the history simply isn't there)

{
  pve = {
{
_row_id = 19,
kills = 3,
name = "a common mine labourer",
deaths = 0
},
{
_row_id = 20,
kills = 1,
name = "the mine foreman",
deaths = 0
},
{
_row_id = 21,
kills = 9,
name = "a dwarf sentry",
deaths = 0
},
{
_row_id = 22,
kills = 2,
name = "a dwarf initiate",
deaths = 0
}
},
crits = {
total = {
alltime = 43,
week = 43,
day = 43,
month = 43,
hour = 43,
year = 43
},
critical = {
alltime = 23,
week = 23,
day = 23,
month = 23,
hour = 23,
year = 23
},
crushing = {
alltime = 11,
week = 11,
day = 11,
month = 11,
hour = 11,
year = 11
},
obliterating = {
alltime = 4,
week = 4,
day = 4,
month = 4,
hour = 4,
year = 4
},
wsc = {
alltime = 2,
week = 2,
day = 2,
month = 2,
hour = 2,
year = 2
},
annihilating = {
alltime = 3,
week = 3,
day = 3,
month = 3,
hour = 3,
year = 3
}
},
gold = {
alltime = 1887,
week = 1887,
day = 1887,
month = 1887,
hour = 1887,
year = 1887
},
exp = {
alltime = 0.3,
week = 0.3,
day = 0.3,
month = 0.3,
hour = 0.3,
year = 0.3
},
pvp = {
{
arenadeaths = 1,
kills = 2,
name = "Elawien",
arenakills = 1,
_row_id = 5,
deaths = 0
}
}
}

The database file is in your mudlet profile folder and can be easily moved between profiles.

Enjoy!

(Ensure you move the Achaealyzer trigger folder near the top above any gags you have)

Download: https://github.com/jtokarchuk/AchaeaScripts/blob/master/Achaealyzer/Achaealyzer.zip?raw=true


Please provide any feedback or questions! I probably won't get to it today as I actually want to play the game for the rest of the day, but I will at some point!

JadysAereidhna

Comments

  • AtalkezAtalkez Posts: 4,790Member @@ - Legendary Achaean
    Maybe add a trigger so that when you run STAT STAT, it populates that information into the table.

    So like if I have 2000 PKs and 1000 arena wins, it will parse that info into the database so that the database and STAT STAT aren't different.


    You hug Aurora compassionately.
    Aesi
  • AesiAesi Posts: 1,222Member @ - Epic Achaean
    Atalkez said:
    Maybe add a trigger so that when you run STAT STAT, it populates that information into the table.

    So like if I have 2000 PKs and 1000 arena wins, it will parse that info into the database so that the database and STAT STAT aren't different.
    I could look into adding a total section to read that data in, but it may ultimately look confusing as the database has it broken down by individual person.

    Perhaps a different section for it? hm
  • AesiAesi Posts: 1,222Member @ - Epic Achaean
    Update.

    • function calls were only returning gold tables. fixed.

Sign In to Comment.