Beta: ProfitUI Quick Macro Button Configurator

[gm9]

-- This is now available from the download area --.

So I'm sitting in a hotel room on a business trip, can't sleep and felt like doing some coding.

Attached is a modified version of Ornathian's great All Spell Guide table that can be used to automatically configure your ProfitUI quick macro buttons with level detecting code for entire spell lines.

Operation is very simple (I hope):

• You must have Microsoft Excel running on Windows. Should be compatible with most if not all Excel versions out there as far as I can tell. Might convert this to something more portable one day, but for now that's all you get. Also, you must enable macros to run in this table.
• You will see a huge table listing all spells/abilities in the game (or so Ornathian claims, but I haven't found anything missing so far). Select any one of them (click anywhere on the line containing it).
• Now click the huge red button, select your eq2 path and the macro button you want to configure (1 to 5).
• When you hit "Save", level detecting macro code for the entire spell line will automatically be written to _ProfitUI_QuickRaidButtons.txt in your ProfitUI folder. Do me a favor and make a backup of that file first!
• Rinse and repeat for any other spell for any other subclass you want to configure
• The eq2 path will be stored if you save the worksheet when you close it.

Feedback and bug reports are appreciated. It seems to work fine, but then again it's past 3 a.m. in the morning here, who know's how reliable I'm coding at this time. Error handling is pretty minimal at this point.

Should be a very useful tool if it's working though I hope. Thanks for testing.

Version history:
beta 8 - hopefully works with Excel 2000 now
beta 7 - uses ProfitUI 4.5 level detection code based on non-mentored level. Also tooltips now comprise the entire spell line including the level for each spell.
beta 6 - added possibility to add /raidsay, /groupsay, /say and /tell text
beta 5 - colors for calain80
beta 4 -

• Fixed a bug where a spell line would always be saved to button 1 regardless of your selection in certain circumstances
• Added complete error handling for eq2 path selection and detecting of an existing ProfitUI installation.
• Your settings of the table (filters, selected cell) will now be restored after saving a spell line
• Spell lines with only 1 spell no longer have "line" in the tooltip and the spell name is no longer enclosed in apostrophs

beta 3 - fix for level detection that always tried to use the next higher instead of the current spell (bug introduced with beta 2 I think)
beta 2 - fix for spells with apostrophs
beta 1 - initial release

[ShadowProwler420]

Originally Posted by gm9

So I'm sitting in a hotel room on a business trip, can't sleep and felt like doing some coding.

Man, I'm not sure if you should be commended (for possibly trying to use code-writing as a sleep agent) or committed for this (I can just picture you sitting in your dark hotel room with only the light source coming from your laptop )!!

[gm9]

Originally Posted by ShadowProwler420

(I can just picture you sitting in your dark hotel room with only the light source coming from your laptop )!!

lol, you are right, that was pretty much it.

[gm9]

OP updated with Beta 2 download, fixing a bug with the eq2 macros for spell lines containing apostrophs.

(it would write

'"spell'name"'

but the outer apostrophs don't work apparently)

Also fixing a bug happening when the save window was closed via the [x].

Any feedback is appreciated, even if you just tell me that it works and is the greatest thing since sliced bread.

[sorinth]

While you are in tinker mode, you may want to think about implementing the ability to add chat to the button. For raid wide info on rezzes and such. However, you dont need to make the text, just give us the ability to add it (without having to edit multiple files multiple times). If it can be done through the configurator, that would be great. also, not sure if there would be a common point in each button casting tree to add this or if it would need to appear multiple times in the tree. Just a thought and thanx for the excellent work!

[Fritos]

This unfortunately is not working for me, all the macros that it is assigning to the buttons state that 'I no longer have this ability' or some error to that sorts when I click Buttons 1-4, the only one that does work is the 5th button, which is my REZ button. This is my code that it spit out.

<Page Name="Inquisitor">
		<Data Name="Button1" Macro="SpellForMyLevel='Ministration'
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 57)
SpellForMyLevel=COND ? 'Devoted Ministration' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 43)
SpellForMyLevel=COND ? 'Faithful Ministration' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 29)
SpellForMyLevel=COND ? 'Minister Wounds' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 22)
SpellForMyLevel=COND ? 'Treat Wounds' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 15)
SpellForMyLevel=COND ? 'Combat Healing' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 7)
SpellForMyLevel=COND ? 'Combat Treatment' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 1)
SpellForMyLevel=COND ? 'Treatment' : SpellForMyLevel
useabilityonplayer Parent.Target SpellForMyLevel" Tooltip="Treatment Line"/>
		<Data Name="Button2" Macro="SpellForMyLevel='Arch Recovery'
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 60)
SpellForMyLevel=COND ? 'Fanatical Healing' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 46)
SpellForMyLevel=COND ? 'Intolerant Healing' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 32)
SpellForMyLevel=COND ? 'Dogmatic Healing' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 18)
SpellForMyLevel=COND ? 'Greater Recovery' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 10)
SpellForMyLevel=COND ? 'Recovery' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 3)
SpellForMyLevel=COND ? 'Minor Recovery' : SpellForMyLevel
useabilityonplayer Parent.Target SpellForMyLevel" Tooltip="Minor Recovery Line"/>
		<Data Name="Button3" Macro="SpellForMyLevel='Penance'
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 68)
SpellForMyLevel=COND ? 'Suffering Penance' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 54)
SpellForMyLevel=COND ? 'Woeful Penance' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 40)
SpellForMyLevel=COND ? 'Stinging Penance' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 26)
SpellForMyLevel=COND ? 'Favor of the Repentant' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 19)
SpellForMyLevel=COND ? 'Bestowal of Vitality' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 12)
SpellForMyLevel=COND ? 'Bestowal of Vitae' : SpellForMyLevel
useabilityonplayer Parent.Target SpellForMyLevel" Tooltip="Bestowal of Vitae Line"/>
		<Data Name="Button4" Macro="SpellForMyLevel='Alleviation'
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 70)
SpellForMyLevel=COND ? 'Reproachful Alleviation' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 56)
SpellForMyLevel=COND ? 'Derisive Alleviation' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 42)
SpellForMyLevel=COND ? 'Scolding Alleviation' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 28)
SpellForMyLevel=COND ? '&quot;Penitent&apos;s Sermon&quot;' : SpellForMyLevel
COND=(Parent.Parent.Parent.GroupMembers.GroupMember0.MemberInfoPage.Level.Text < 14)
SpellForMyLevel=COND ? '&quot;Penitent&apos;s Alleviation&quot;' : SpellForMyLevel
useabilityonplayer Parent.Target SpellForMyLevel" Tooltip="&quot;Penitent&apos;s Alleviation&quot; Line"/>
		<Data Name="Button5" Macro="useabilityonplayer Parent.Target Conversion of the Soul" Tooltip="Conversion of the Soul Line"/>
	</Page>

Not sure if it matters, but I set it up to spit out for all 80 levels (don't want to have to do this every time I get a new spell) even though by toon is max at 67? I guess what I'm not understanding how it's looking for the spells. Like For my 'Penance' spell for button 3. If I'm reading that correctly, If I'm lower than 68 it's trying to cast 'Suffering Penance', which wouldn't be correct cause I haven't obtained that spell yet. It should be trying to cast 'Woeful Penance' being I don't get 'Suffering Penance' till 68?

[gm9]

Originally Posted by sorinth

While you are in tinker mode, you may want to think about implementing the ability to add chat to the button.

Yes, I already thought about that, but I'll actually have to do some tests first with respect to all the special characters people may want to put in there and how I can encode them such that it works in game, in particular if people start inputing encoded characters (never mind the details, but whatever can go wrong, someone will find it. ).

Apart from that it's easy to add.

[gm9]

Originally Posted by sorinth

While you are in tinker mode, you may want to think about implementing the ability to add chat to the button. For raid wide info on rezzes and such. However, you dont need to make the text, just give us the ability to add it (without having to edit multiple files multiple times). If it can be done through the configurator, that would be great. also, not sure if there would be a common point in each button casting tree to add this or if it would need to appear multiple times in the tree. Just a thought and thanx for the excellent work!

I just added Beta 6 to the OP that allows you to do that. You get the same text regardless of your level, anything else would be overkill I suppose.

[Mareid]

Ive got toons of all classes, spell casters and potion users, and nary a one is over 40. I haven't had a ton of luck with the auto-drink or auto-cure-spell buttons, so this will give me a chance to test out what I'm doing wrong. Love the idea!

[dxbmarine]

Don't know if it helps at all, but I was going through this thread and thought of something which I encountered with another application....

If the code is written in XML or uses any XML at all, be aware that versions of Excel (prior to, I believe 2002) do not have XML handling enabled. Also, when using the "standard" version of Office (2003 and up) it is nice to know that it will ship with an Excel version which has (very) limited XML handling capabilities.....

As for general interest: Just another 40 minute wait to get my Lvl 53 Necromancer out of bed, after a 2 year and 4 months sleep.... Be happy to test this out, once I've gotten into the game again!

Greetz!