Hi,
Raw Log Browsing System is Live now.
About the Raw Log Browsing System(RLB):
RLB expression editor is a free text control able to parse SQL like where clause.
RLB currently does not have a wizard UI to auto generate the expression. You write the expressions in a similar way that you tell someone what to do, well sort of.
RLB has no limitation of row count thought you can see 100 at a time, you can traverse from the start to the end of the fight raw logs.
RLB consist of three panes:
- Upper Pane: This pane hold the legend of all available Contexts.
- Left Pane: Will show only if you're logged in, this pane let you save/update/delete Expression Presets to your Private Preset Library or to Your Guild Preset Library
- Lower pane: The actual Expression Editor where you enter your code.
What is a Context
A context is an abbreviation for something you may look for in the Raw Log, like: Source Unit Name, Spell, get all Hostile Units, get all failed dispels and many more.
An expression may include a single context or many of those which you decide how to relate one to each other by using logical operators.
Examples:
- Get all source friendly units missed melee events:
[s_friendly] and [miss_melee]
- Get all player's 'ImAlwaysdispeling' dispels:
[s_name] = 'ImAlwaysdispeling' and ([dispel] or [dispel_failed])
- Get all players died from defile:
[t_friendly] and [killed] and [spell] = 'Defile'
- Get all stacks information about Mystic Buffet for player 'IdidNotGetAbove5Stack'
[t_name] = 'IdidNotGetAbove5Stack' and [aura_all_applications] and [aura_all_removals] and [spell] = 'Mystic Buffet'
- Get all Damage taken from targets with names starting with 'Shamb' (take notice that like is case sensitive and ilike is not)
[t_friendly] and [dmg] and[s_name] ilike 'shamb%'
- Get all CC's done to a Valkir with Spawn ID-35876
[t_spawn_id] = 35876 and [spell_cc]
- Get all dispels done to the Tanks between '2010-12-1 10:21:22' and '2010-12-1 10:21:52'
[t_tank] and [dispel] and [time] between '2010-12-1 10:21:22' and '2010-12-1 10:21:52'
- Get all DPS and Healers whom agroed:
([t_dps] or [t_healer]) and [dmg_melee]
- Get only the dispels from Pally healers:
[s_paladin] and [s_healer] and [dispel]
Note: At this point, if you enter an invalid expression, RLB will not tell you what exactly is wrong but only a general error message.
Although I'll be addressing that in the future, This is what you might want to check out If you get errors:
1) Check that you use Valid context Names, you'll need to include the Brackets([]) too.
2) Check that you enter a valid value to a mandatory Value Context such as [spell] (It has to be [spell] = 'some spell name' or [spell] in ('spell name 1', 'spell name 2')).
3) Check that the logical operator are in place. write something like [t_friendly] [dispel] will result in an error. Should be: [t_friendly] and [dispel]
4) Time values must be fully qualified with year-month-day hour:minutes like '2010-12-1 10:21' (seconds and milliseconds are optional)
5) Check that your expression does not include words like: delete, select, drop, create, update and such. this is due to monitoring SQL Injections.
Raidlogs will reject any expression with such content.
A link where you can check it out:
http://www.raidlogs.com/fight/browser/585/19
This is just an introduction post, I'm sure that people will be very creative in what they can get out of it.
Elija
