Roll20 uses cookies to improve your experience on our site. Cookies enable you to enjoy certain features, social sharing functionality, and tailor message and display ads to your interests on our site and others. They also help us understand how our site is being used. By continuing to use our site, you consent to our use of cookies. Update your cookie preferences .
×
Create a free account
This post has been closed. You can still view previous posts, but you can't post any new replies.

Successful Multi-Query System

May 24 (9 years ago)

Edited June 15 (9 years ago)
I have gotten a successful multi-dropdown-query system to work with attacks and the contents of the weapon queries will change based on what token is selected. If you would like to give it a quick test, feel free to join. Right now I've only got one weapon set up for it along with some different text options. Please don't alter any of the weapon macros, but feel free to look at them. I know that many people consider this to be one of the biggest troubles for the site, but I've finally gotten something to work for it. As for the actual query function, I'm going to keep that as my own little secret for now until I can make sure it's 100% functional. So as of now, it's still in the testing phase. I know that many people will benefit from this, so that's why I'm wanting to keep this as a simple testing until I know for sure that I can make it work with up to a 4-tier query system, due to that probably being the biggest hierarchy one could possibly need for a query system. 

Edit: To eliminate any worry of someone altering my work, I blocked off access from the journal for everyone, but you may still use the tokens. 

Edit: This only works for Pathfinder. I apologize to those that were hoping for one for their system. However, since I made my work public, you can probably tweak it so that it'll work within your system as well. Also removed the join link since the game will become my own personal workshop for macros.
May 24 (9 years ago)
Scott C.
Forum Champion
Sheet Author
API Scripter
Compendium Curator
Seems to work fine. Are you just calling a variety of macros using the drop down selection syntax for roll queries?
May 24 (9 years ago)

Edited May 24 (9 years ago)
I'm using the character sheet stuff for the attacks. I only have one custom global macro. I do customize the character sheet stuff though so that it'll work properly. It's actually quite simple if you read the advanced roll query syntax thing. And I apologize if i didn't understand your question correctly.
May 24 (9 years ago)
Scott C.
Forum Champion
Sheet Author
API Scripter
Compendium Curator
nope, I think that answered my question
Okay. If you make your own and it works out fairly well, would you like to compare methods?
UPDATE: Now has 6 weapon slots and they all work. Will implement some skills in the next update.

Requirements: Characters must have something in for weapons 0-5 even if it's just named Null. This can be customized with great ease to either increase or decrease the weapon slot number. This is dependent on the character with the most weapons.

Known bug: Does NOT work with Honey Badger (SkyCaptain's (?) ) power card API. I have tested this out in a Pro hosted game that uses them, and have not found a way to get them to play nicely.

Future Update: All Skills, Personal Skills will be just between user and gm (i.e. stealth, Knowledge, Slight of Hand, perception, etc.).

If you have any suggestions, feel free to say them, and I might just implement them.

Also recommend following the thread to stay up to date on the status of the project.
UPDATE 2: Skills do work. Only have Acrobatics and Appraise in, but they do work. The macro is 100% global. It is not in the character sheet abilities list.

I'll update again once I have ALL skills in. But overall... I think it's complete. I'll make a separate macro for spells, which I know is has been having an ongoing change lately.
June 05 (9 years ago)
Scott C.
Forum Champion
Sheet Author
API Scripter
Compendium Curator
Are you ready to make the structure public?
June 05 (9 years ago)
It's just using html entities on a roll query inside a roll query pretty much. I figured it out but have since lost interest in it. It's too big of a pain in the ass to deal with html entity replacement.
It's pretty much as SkyCaptain said. It's just a bunch of HTML conversions including those made in the character sheet so as to keep the macro relatively neat. But yes, I'll make all of my conversions public within the next day or so. I just got back from a trip (on which I had no internet whatsoever...) so I haven't been able to finish it up. The macro is for pathfinder, but I'm sure it wouldn't be too hard to change a couple things to convert it into a working form for other systems.
June 15 (9 years ago)

Edited July 09 (9 years ago)
So, this is the release of my character sheet macro changes along with my Multi-Query macro for anyone who wishes to use it.

Skills:
 @{PC-whisper} &{template:pf_generic& #125; & #123;& #123;character_name=@{character_name} & #125;& #125; & #123;& #123;name=@{Skill-name found by hovering over the name of the skill} & #125;& #125; & #123;& #123;check=[[ 1d20cs>20cf<1 + [[@{selected|Skill modifier}]] ]] & #125;& #125; & #123;& #123;

Attacks:
@{PC-whisper} &{template:pf_attack& #125; & #123;& #123;character_name=@{character_name} & #125;& #125; & #123;& #123;subtitle& #125;& #125; & #123;& #123;name=@{name} & #125;& #125; & #123;& #123;attack=[[ 1d20cs>[[ @{crit-target} ]] + [[ @{total-attack} ]] ]] & #125;& #125; & #123;& #123;damage=[[ @{damage-dice-num}d@{damage-die} + [[ @{total-damage} ]] ]] & #125;& #125; & #123;& #123;crit_confirm=[[ 1d20 + [[ @{total-attack} ]] ]] & #125;& #125; & #123;& #123;crit_damage=[[ [[ (@{damage-dice-num} * (@{crit-multiplier} - 1)) ]]d@{damage-die} + [[ (@{total-damage} * (@{crit-multiplier} - 1)) ]] ]] & #125;& #125; & #123;& #123;type=@{type} & #125;& #125; & #123;& #123;weapon_notes=@{notes} & #125;& #125; 

Query Macro:

?{What would you like to do? | Attack, ?{What would you like to use to attack? & #124; @{selected|repeating_weapon_$0_name}& #44;%{selected|repeating_weapon_$0_attack-roll} & #124; @{selected|repeating_weapon_$1_name}& #44;%{selected|repeating_weapon_$1_attack-roll}  & #124; @{selected|repeating_weapon_$2_name}& #44;%{selected|repeating_weapon_$2_attack-roll} & #124; @{selected|repeating_weapon_$3_name}& #44;%{selected|repeating_weapon_$3_attack-roll} & #124; @{selected|repeating_weapon_$4_name}& #44;%{selected|repeating_weapon_$4_attack-roll} & #124; @{selected|repeating_weapon_$5_name}& #44;%{selected|repeating_weapon_$5_attack-roll} & #125;| Use a Skill,?{What skill would you like to use? & #124; Acrobatics& #44;%{selected|Acrobatics-check} & #124; Appraisal& #44;%{selected|Appraise-check} & #124; Bluff& #44;%{selected|Bluff-check} & #124; Climb& #44;%{selected|Climb-check} & #124; Craft (@{selected|Craft-name})& #44;%{selected|Craft-check} & #124; Craft (@{selected|Craft2-name})& #44;%{selected|Craft2-check} & #124; Craft (@{selected|Craft3-name})& #44;%{selected|Craft3-check} & #124; Diplomacy& #44;%{selected|Diplomacy-check} & #124; Disable Device& #44;%{selected|Disable-Device-check} & #124; Disguise& #44;%{selected|Disguise-check} & #124; Escape Artist& #44;%{selected|Escape-Artist-check} & #124; Fly& #44;%{selected|Fly-check} & #124; Handle Animal& #44;%{selected|Handle-Animal-check} & #124; Heal& #44;%{selected|Heal-check} & #124; Intimidate& #44;%{selected|Intimidate-check} & #124; Knowledge (Arcana)& #44;%{selected|Knowledge-Arcana-check} & #124; Knowledge (Dungeoneering)& #44;%{selected|Knowledge-Dungeoneering-check} & #124; Knowledge (Geography)& #44;%{selec0ted|Knowledge-Geography-check} & #124; Knowledge (History)& #44;%{selected|Knowledge-History-check} & #124; Knowledge (Local)& #44;%{selected|Knowledge-Local-check} & #124; Knowledge (Nature)& #44;%{selected|Knowledge-Nature-check} & #124; Knowledge (Nobility)& #44;%{selected|Knowledge-Nobility-check} & #124; Knowledge (Planes)& #44;%{selected|Knowledge-Planes-check} & #124; Knowledge (Religion)& #44;%{selected|Knowledge-Religion-check} & #124; Linguistics& #44;%{selected|Linguistics-check} & #124; Perception& #44;%{selected|Perception-check} & #124; Perform (@{selected|Perform-name})& #44;%{selected|Perform-check} & #124; Perform (@{selected|Perform2-name})& #44;%{selected|Perform2-check} & #124; Perform (@{selected|Perform3-name})& #44;%{selected|Perform3-check} & #124; Profession (@{selected|Profession-name})& #44;%{selected|Profession-check} & #124; Profession (@{selected|Profession2-name})& #44;%{selected|Profession2-check} & #124; Profession (@{selected|Profession3-name})& #44;%{selected|Profession3-check} & #124; Ride& #44;%{selected|Ride-check} & #124; Sense Motive& #44;%{selected|Sense-Motive-check} & #124; Sleight of Hand& #44;%{selected|Sleight-of-Hand-check} & #124; Spellcraft& #44;%{selected|Spellcraft-check} & #124; Stealth& #44;%{selected|Stealth-check} & #124; Survival& #44;%{selected|Survival-check} & #124; Swim& #44;%{selected|Swim-check} & #124; Use Magic Device& #44;%{selected|Use-Magic-Device-check} & #124; & #125; }

All you have to be doing to use these macros/character sheet changes (sheet changes are 100% optional, you can put this stuff in the global macros section) is to be using Pathfinder, know how to create a macro, and removes the spaces between the &'s and the #'s. I had to put them in like that so as to keep them from being converted into their actual characters as this is pretty much a bunch of HTML conversions. I hope whomever uses this enjoys it.

If you find any bugs with it feel free to leave a message on here, or send me a private message detailing what the bug is and how it happened.

NOTE: I will not respond to any messages about it not working with the power card API as I don't have access to that. I have tinkered around with it before when I was in a game that was hosted by someone that used it, but I couldn't figure out a way to get it to work before the game was done. I also will not reply to messages about rolling from the character itself not working if they are for skills or attacks as altering the attack and skill macros inside the character sheet and putting in HTML conversions will break the sheet rolls for whatever has been converted. Now if you have issues with the macros themselves, then I'll do what I can to help.
 
NOTE 2: If you want to make it so that people can still you sheet rolls, then put the about macros in the global macro section found under the settings tab that's above the chat area.