Harrow's End Key

One of the key things I use the SOE data for is checking a characters readiness for raiding. Some think it's over-kill for a 'casual' guild, but our raiding has improved markedly since we started doing this.

Currently, that involves checking health, critical chance and the % of adornment slots filled. All of that can be done with a single query listing all members of the guild.

I'm thinking of extending this to including checking that Epic Repercussions is complete and that they have access to looting Obols, Spirits, etc. The second one could just be a matter of looking up whether they have completed the final quest in the Ethernere signature quest line (or checking the related achievements), but I think having the key to Harrow's End would suffice.

Is there a query to determine if somebody has completed a particular quest, and can it be performed at the guild or character level (in 1 step)?

Is there a query that can be used to determine if somebody has activated the key to Harrow's End?

 

I've been wanting to add this to EQ2U forever. However Quest data is not yet available, and Achievements were never added for these things:

• Epic Repercussions
• Tower of Frozen Shadow x2 (earning the debuff)
• Drinal's Steward key
• Drinal's Steward quest

So there are two solutions:
#1 we ask for these Achievements to be added
#2 we wait for Quest data.

 

Actually I was wrong. Epic Repercussions can be determined from spell data:

census.daybreakgames.com/xml/get/eq2/spe...on.&c:show=name,level,icon,classes&c:limit=99

I have now added this to the Spell view on EQ2U.


also for ToFS x2 debuff, the Mage debuff gets exported on mages:

<div style="padding-left: 30px"><spell alternate_advancement="0" aoe_radius_meters="0" beneficial="0" cast_secs_hundredths="50" chardiff="0" crc="1260897704" deity="0" given_by="spellscroll" id="1616154856" last_update="1366730604.689141" level="0" max_targets="0" name="Pall of the Elements" name_lower="pall of the elements" recast_secs="60" recovery_secs_tenths="0" spellbook="0" tier="9" tier_name="Master" ts="1366730604.689141" type="spells" typeid="0" version="1">
<div style="padding-left: 60px"><cost concentration="0" health="0" power="3" savagery="0">
<div style="padding-left: 90px"><per_tick health="0" power="0" savagery="0"/>
<div style="padding-left: 60px"></cost>
<div style="padding-left: 60px"><duration does_not_expire="0" max_sec_tenths="360" min_sec_tenths="360"/>
<div style="padding-left: 60px"><icon backdrop="-1" icon_heroic_op="-1" id="928"/>
<div style="padding-left: 60px"><description/>
<div style="padding-left: 60px"><effect_list>
<div style="padding-left: 90px"><effect description="Reduces the confidence level of some raid level NPC's." indentation="0"/>
<div style="padding-left: 90px"><effect description="Cannot be modified except by direct means" indentation="0"/>
<div style="padding-left: 60px"></effect_list>
<div style="padding-left: 30px"></spell>

But the Scout, Fighter, and Priest spells are there in spell data, but are NOT being exported on characters. I guess we need to find out if ToFS x2 debuff is still needed in current content and, if so, get this fixed.

 

For the x2 Debuff in the meantime, I guess you could check and see if they have the spell:
Scouts: Slice of Despair
Spell#674390489
Mages: Pall of Elements
Spell#1616154856
Fighters: Demoralizing Swipe
Spell#2917802350
Priests: Divine Despair
Spell#612359111

I don't believe it's needed in any CoE zones, not sure about new Siren's Grotto.
It is still required for Plane of War.

For Epic Repercussions I guess you could do the same and check if they have the spell:

But I see Feldon is already ahead of us

 

Mages are exporting with it. I tested a Coercer.

Scouts, Fighters, and Priests aren't exporting with this spell, from what I can find. ie, you won't find a Scout, Fighter, or Priest in Census who has their spell.

It sure would be nice to have it. I will ask.

Yeah I just threw it onto our Spells page. If we had more of this Unlock type of stuff, I would add a whole tab to EQ2U.

 

PoW is still very relevant. The top 12 guilds on our server (including us) have killed the first 2 named in PoW, but only 3 guilds have cleared it. Meanwhile, only the top 5 guilds have been able to kill anything in Siren's Grotto or Dreadcutter. CoE EM content is all doable by a semi-casual guild, but the first named in either of the two new zones totally smash most guilds.

It's a pity the other classes aren't 'exporting' those abilities yet.

One way some of this could be handled is by having a 'key ring' and exporting that. Hopefully, they store all of the zone access flags in a single place. Otherwise, I imagine that's not going to be trivial to implement something like this on the eq2 server side of things.

Achievements for all these things would make it very easy to check though.

 

I've been doing ER and Singular Focus detection from the get go on Dragon's Armory. I'd love to add ToFS debuffs as well so I'll pester SOE with Feldon =) For the slackers out there, I'll be nice:

switch($spellData["id"]) {
case "3062851873": // Beastlord Epic - Master of Beasts
case "2357709831": // Berzerker Epic - Whirlwind
case "525825229": // Bruiser Epic - Unyielding Resolve
case "306666685": // Guardian Epic - Wrath of Vel"Arek
case "1463331340": // Monk Epic - Perfect Serenity
case "449915658": // Paladin Epic - Marr"s Favor
case "792904718": // Shadowknight Epic - Seething Hatred
case "593450753": // Assassin Epic - Assassin"s Flurry
case "660714803": // Brigand Epic - Havoc"s Treachery
case "2976474773": // Dirge Epic - March of Blades
case "509781089": // Ranger Epic - Eagle"s Talon (grandmaster)
case "1273618570": // Swashbuckler Epic - Swarthy Ways
case "698807671": // Troubador Epic - Ayonic Inspiration
case "2597294319": // Defiler Epic - Nightmares
case "2672801118": // Fury Epic - Nature"s Wrath
case "382126813": // Inquisitor Epic - Cleansing of the Soul
case "2657181028": // Mystic Epic - Spirit Tap
case "2775781479": // Templar Epic - Divine Light
case "1636577504": // Warden Epic - Nature"s Restoration
case "472410880": // Coercer Epic - Siren"s Gift
case "1720755111": // Conjurer Epic - Elemental Mastery
case "2719301397": // Illusionist Epic - Mirage Mastery
case "3039617986": // Necromancer Epic - Secrets of Vazaelle
case "102736953": // Warlock Epic - Negative Void
case "2840893721": // Wizard Epic - Focused Mind
$foundEpic = 1;
break;
case "2662824675":
$foundSingularFocus = 1;
break;
}

 

Not sure how you will choose to display it. But some classes have 2 myth spells.
I.E. Coercer w/ Siren's Stare & Siren's Gift

 

EQ2U shows it as 1 or 2 spells. I added all 37 spells to the appropriate classes and then added "Epic Repercussions: " to the name of each spell. We have our own metadata we display along with the SOE data, so I was able to customize the spell names there.

What Dedith is talking about is just using one spell from each class to detect if the character has completed the quest and, if so, display a message/icon/checkbox saying the character has completed the quest. In this case, it doesn't matter if some classes have 2 spells. You're only using 1 as a test.

At some point down the road when we have DoV War Runes, Epic Repercussions, ToFS x2 debuff, Drinal's Steward Key, and Drinal's Steward full access all as flags/quest data, then I will create a whole separate "Keychain" tab on EQ2U to display all this data.

 

It is as Feldon says, I just use one of the spells to detect if a character has completed the quest. If a character has one, they have the other as well.

 

Any word on when Scout, Fighter, and Healer X2 Debuff spells will be added to the data?

 

I'm still trying to get Refining data since 8 months now.

 

I thought this one may have been a quick one to fix since Mages was already in.

 

It's not the fix being small or not, it's that census doesn't get a lot of dev time. And we just started asking about this. Make sure you've requested this fix as well, send an email to [url="mailto:[email protected]">[email protected][/url]

 

Well Healer's seems to be exporting now. Slowly but surely...
Now just waiting on Fighters & Scouts