What do you look for?

nbperp

I'm considering rebooting my indexing project from a few years back. My database is set up with all the characters and I want to have a usable index whereby if someone is looking for a character that "can generate protect tiles" but also has a Stun power, they'd be able to find it.

I started this a while back and was overloaded with terms, so it was darn near unusuable. My goal this time would be much simplified.

To that end.... what would you look for?

nbperp

Some of my initial thoughts:

Create Strike tiles
Create Protect tiles
Create Attack tiles
Creates [color*6] tiles
Creates Web tiles
Creates Charged tiles

KGB

Your filters are nice but need to be even more specific than that (you forgot traps, CDs, Repeaters).

For some of the monthly Puzzle Ops quests require you to do things like have X number of enemy protect tiles. So a 'create protect tiles' is nice. But being able to filter for 'create protect tiles' and 'create enemy protect tiles' is even nicer.

For your color tiles, more than just powers that create the color tiles it would be nice to find character who remove specific ones (Quake's Blue can go in this for every color since you pick the one to remove) and ways to differentiate between 'instant' powers like 3 star Kamala Kahns purple that creates Green and 3 star Scarlet Witch who needs a CD to go off before she create purple.

Also another way to filter might be active/passive. So someone who is filtering for 'create protect' tiles might want to also filter for active vs passive (passive = BrB / 3 & 4 star Luke Cage, Active = 3 star Magneto, 4 star Falcon).

Ideally your site will have multiple filter selections (protect tiles, active/passive/either, enemy/team/either) that you can turn on/off as needed.

Basically we need filters for all the Puzzle Ops quests

KGB

nbperp

My short list was more of a prompt than an intended exhaustive list. My goal with this thread is to generate discussion and get a full list of ways powers need to be indexed so that the tool can be as useful as possible - and yes, I want it so that I can turn to it during the Puzzle Ops.

I agree with all you've said and I'm thinking about how to really make it work. One way would be to index to a "concept" where a concept is made up of a series of standard terms (e.g., "Passive Create Friendly Protect"). Alternatively, each index term could be made up of a limited vocabulary (with a means to propose new terms as needed) that can do the same thing without the heaviness of "concept/index term")

KGB

Your 'concept' of standard words that can be filtered is probably the easiest way to go. Since you are entering the data you'll be able to assign a few words "Passive Create Friendly Protect" to a power. Then your filters just have to search for that word and multiple filters will just do 'and' clauses.

That will be very straight forward in javascript (I've done it before for the old Puzzlequest games)

KGB

nbperp

Came up with a general vocabulary list. A given power would be able to have any number of index terms, but each term would be made up of the following words. Would appreciate feedback with any terms that need to be added. I don't think any given term would need more than one from a given line (if it were necessary, you'd just make 2 terms for the power):

Active, Passive
Create, Destroy, Remove
Select, Random
Stun, Send Away, Send Airborne, Make Invisible
Friendly, Enemy, Self
Countdown, Repeater
Black, Blue, Green, Purple, Red, Yellow, Team-Up, Critical
Strike, Protect, Attack
Fortify, Web, Charged, Trap, Critical, Tentacle, Wasp, Lock

sambrookjm

@nbperp said:
Came up with a general vocabulary list. A given power would be able to have any number of index terms, but each term would be made up of the following words. Would appreciate feedback with any terms that need to be added. I don't think any given term would need more than one from a given line (if it were necessary, you'd just make 2 terms for the power):

Active, Passive
Create, Destroy, Remove
Select, Random
Stun, Send Away, Send Airborne, Make Invisible
Friendly, Enemy, Self
Countdown, Repeater
Black, Blue, Green, Purple, Red, Yellow, Team-Up, Critical
Strike, Protect, Attack
Fortify, Web, Charged, Trap, Critical, Tentacle, Wasp, Lock

Great start! For "Wasp", do you mean "Swarm"?

"Match-4" and "Match-5" since some abilities trigger on those (Profe$$or X, 3-star Loki...)

"Steal" (for AP thieves) and "Generate" (4-star Vulture, Gambit...)

"Revive" (Chasm, iHulk...)

"Permanent" (Omega-3, Mephisto...)

KGB

Burst Heal, True Heal,
Self Damage, Self Team Damage (these could be in the heal category)
Match Damage Increase, Match Damage Decrease
Damage, AOE Damage (these meant to be combined with active/passive obviously so for example Omega Reds AOE Damage would show up under Passive + AOE Damage)

Also Board Shuffle (like Quake's Green) needs to go somewhere (Create/Destroy/Remove?) unless it's under it's own new category.

KGB

P.S. Not sure what you mean by " I don't think any given term would need more than one from a given line". For example Kitty's passive that removes enemy specials would have all 3 of "Strike, Protect, Attack" so if you filtered on 'remove' then any of 'strike' or 'protect' or 'attack' should return a positive match. Same with Quakes Blue that Removes tiles of a specified color, it needs to match any of the 6 colors.

icarusmonkey

I support this. I've always wanted a comprehensive list of Affiliations, though I know this changes regularly and could be difficult to maintain.

Don't forget "Ally", unless that's what you mean by "Friendly". Also "Swap" to your Create, Destroy, Remove category.

Also Stun Immunity.

I'd add "Drain" to Steal - Kang cares about that wording, though I don't think it's consistent with other characters. For example, 5Yelena uses "reduce" and Gargantos uses "destroy" when it comes to AP.

Other types of tiles can include Hellfire, Shrapnel, Bubbles, and Quicksilver's locked, which I think work like other locked tiles but have a different animation. Probably others.

Sounds like an exciting endeavor. Good luck!

nbperp

@icarusmonkey said:

Sounds like an exciting endeavor. Good luck!

I'm hoping once I get the app put together, I can convince some of the fine folks here to come and help!

KGB

@nbperp said:

@icarusmonkey said:

Sounds like an exciting endeavor. Good luck!

I'm hoping once I get the app put together, I can convince some of the fine folks here to come and help!

Are you making an app that you'd have to install on a phone (not as great for steam players)?

I thought it was just going to be a website.

KGB

nbperp

@KGB said:

@nbperp said:

@icarusmonkey said:

Sounds like an exciting endeavor. Good luck!

I'm hoping once I get the app put together, I can convince some of the fine folks here to come and help!

Are you making an app that you'd have to install on a phone (not as great for steam players)?

I thought it was just going to be a website.

KGB

It’ll be both a website and something you can run on your phone. The system I use is called Oracle APEX (which stands for Application Express, thus my referring to what i build as an app)

WhiteBomber

Nice, I figured there had to be people here doing something similar. I was planning on making a "Team Builder" since keeping track my fun teams was too deep, and making new ones is becoming increasingly more difficult with a million options.

I started breaking out functionality a while back and assigning it to characters. I wanted it to tell you how good those characters were at those things, which in turn, will also suggest characters that are good partners and counters to each other.

So, in the ORed example below, you can see all of the things he does and how much he excels at them; if the ability applies, it gets a scoring from 1-3 and if it doesn't it is rated 0.
Next to it is the counter rating, if they counter that ability, they get a rating of A-C, and if doesn't counter, it's X.

The goal was to finish filling all of this out for every character and give it a UI which could help you build teams. At minimum, it will give you a fast way to filter which characters are good at what.

bluewolf

Love

in all the wrong places

WhiteBomber

@nbperp what are you using as the database?

nbperp

@WhiteBomber said:
@nbperp what are you using as the database?

Oracle (Apex for the front end)

Gymp28

This sounds like a brilliant resource! I love a spreadsheet, and this sounds essentially like a 3D one: complex!
Keen to learn of any updates on this. Keep up the good work @nbperp !

LavaManLee

Great idea. If we can expand to supports, I want to know which supports have a chance to add AP at the start. The search they have by perk, will show anything that has to do with the color. I don't care about that. I just want to know which ones have a chance to add AP.

trenchdigger

@LavaManLee
In the Tips and Guides section of this forum there is a pinned thread, about 5 from the top called "Supports that give you AP". It's been there for a while, but I think it is still pretty accurate.

LavaManLee

@trenchdigger said:
@LavaManLee
In the Tips and Guides section of this forum there is a pinned thread, about 5 from the top called "Supports that give you AP". It's been there for a while, but I think it is still pretty accurate.

Thanks! Didn't know that. Appreciate it.

captainheath

I've been using this: https://www.quietse7en.com/index.html