User:Aegonostic

Hello there, I love Hearthstone!

• I love helping to improve the content on this wiki. :)
• I've helped out on the main Wikipedia before.
• I like to improve the grammar and clarity of articles for fluid reading.
• I am a bit experienced in stopping vandalism as well, but I don't think I will encounter much on here.

I have contributed a variety of content to this wiki, in small portions in various articles. :)

I love playing co-op Tavern Brawls, with an extreme obsession. :D

• Unite Against Mechazod!
• Return of Mechazod!
• Nefarian Rises!
• A Mammoth of a New Year

- I love this wiki! Everyone is pretty helpful. Virtual hugs to everyone! ^__^

P.S. Please help narrow down the TODO list for Template:Verify here!

• Category:Statements needing citations

P.S.S. And if you can, please update outdated images seen here!

• Category:Pages with outdated images

Diary?

The past

NOTICE: I will be retiring on and off from this wiki. However, I will continue to enjoy watching Trolden videos from my RSS feed and making wiki-edits whenever I see the need.

• The change from Adventures to Expansions hit me hard (Battle.net blog link 2017/02/16).
  • The annual price of Hearthstone increased by roughly ~7000 gold.
    • (Comment from 2019: no joke)
    • My calculations showed that free-to-play would not be sustainable.
      • Even more so for new players.
  • April came and went (Journey to Un'Goro).
    • There were no big reprieves from the massive price increase.
      • Only Year of the Mammoth dust refunds, and meager free expansion packs.
    • The time it takes to play Hearthstone is too much.
    • I sadly contemplated quitting Hearthstone.
• After opening 39 Un'Goro packs without a legendary, I sadly quit and retired from Hearthstone. :(
  • Mayor Noggenfogger and 2x Sergeant Sally, from Mean Streets of Gadgetzan!
  • Amara, Warden of Hope and The Voraxx from Journey to Un'Goro!
  • Quit and retired from Hearthstone.
    • But, maybe I will come back to Hearthstone again someday! :O
• Also, the pre-nerf The Caverns Below was not fun to play against. :(
  • Image: Battle.net nerf comparison
  • No fun counterplay deck besides all-out face-deck.
  • Seeing Counterspell work against The Caverns Below gave me some chuckles one time though. :)
  • (Comment from 2019: Wow, Caverns was nerfed like an insane number of times)
• I will miss playing co-op brawls. :(
  • I will be back to play co-op brawls. :)

Heroic Tavern Brawl

A side note about Heroic Tavern Brawl:

• It is bad, because if a player loses, it just feels bad for the player that lost, and there will be a lot of players that lose.
• It is a cash grab and it hurts casual players.
  • At least give players a free pack for that week! :(
• Worse return rates than Arena: Heroic_Tavern_Brawl#Statistics_table
• Encourages netdecking.
  • I don't like netdecking.
• However, viewing Heroic Tavern Brawls on Twitch is very satisfying.
• (Comment from 2019: Heroic Tavern Brawl has been replaced by the better more-Arena-like Your Standard Brawliseum.)

April 2018

Got back into the game on April 2018.

All I see is:

• Dragon Priest with that board-killing card Duskbreaker and throwing down 15 something stats turn 6 with Spiteful Summoner
• Warlock throwing down their new Sludge Belcher called Voidlord and shutting down all aggro, then resummoning those things late-game with Bloodreaver Gul'dan
• Secret mage just throwing everything to face with the help of that new card Explosive Runes, then winning
• Paladin summoning a bunch of dudes and owning the board with Divine Shields, Righteous Protectors, and Sunkeeper Tarim

Tavern Brawls are mediocre, but sometimes they're fun.

Looking forward to Monster Hunt, plus the new reduced-cost quests. The old quest requirements really needed improvements.

April 13, 2018

• How did a controllable Yogg get through playtesting?
  • (Comment from 2019: turns out getting rid of "fun and interactive" was a calculated move, and probably a good decision)

June 2018

Questions:

• Are there enough ways to play the game to keep players happy?
• Why not implement microtransactions for purchasing specific cards for real money?
  • I have no dust, so do I really have to use gold to buy packs to disenchant to get dust to get cards?
• When will the game offer discounts on Wild cards?
  • Will Wild format die out if, after a few years, more and more players lack the number of cards they need to play Wild?

August 2018

• How do new players play this game if the cost is so high?
• When will the game client be rewritten to be faster?
  • This game runs super sluggish on phones.
• When will the game client be rewritten to be smaller?

November 2018

• Without new ways to use cards in the collection, they eventually devalue over time.
  • Will the game add more game formats (besides the current Standard and Wild)?
  • Will the game implement game modes featuring card set restrictions and card bans?
• Value of Ranked play is based mostly on the variety, balance, and accessibility of fun winnable deck types.

December 2018

• Identifying the set logo behind a card's card text is near impossible in the game, for mobile at least.
• Rumble Run is one of the worst things I've seen in Hearthstone.
  • The other would be Heroic Tavern Brawl with the gate-walled 1000 gold entry fee, but that was fixed by its replacement, Your Standard Brawliseum.
• Test Subject wombo combo decks just became my favorite decks of all time. :)

January 2019

• Pretty good meta this season. :)
  • Huge variety of aggro vs control vs combo decks on the ladder.

September 2019

Whoa, journey down memory lane!

Good things going for Hearthstone:

• Hearthstone is still fun to play!
• Zephrys the Great is a very fun card to play with and experiment with.
• Specialist was the worst match format ever, I'm glad they took no less than half a year to figure that out and replace it with a new format (now Shield-Phase Conquest).
• Hearthstone is now using the triangle combat system properly I think.

Bad things?:

• Everything looks and feels expensive, and it definitely is when you want to experiment with a lot of cards.
• Hearthstone still gets stale/repetitive with locked metas, but this is solved with the more frequent card balances/additions/buffs.
• Arena getting rid of bucket system soon? (very bad)
• No real in-game achievements for the player. Game just wants the player to open the game, play a few matches for quests, and ponder about what Hearthstone could be like in the future.
• Tried downloading this game on desktop again, and boy the graphics are kind of horrible.

December 2019

Good things about Hearthstone:

• New updates still make Hearthstone fun.

Mediocre things about Hearthstone:

• Powercreep is profitable and somewhat healthy, but too much is really unhealthy.

Bad things about Hearthstone:

• Card balance and class balance.

April 2020

Good things about Hearthstone:

• New game mode using Wild cards is coming! :D
• New updates still make Hearthstone fun.

Bad things about Hearthstone:

• Card balance and class balance. :(

Article templates / boilerplates

Useful templates to use for new pages / datapages:

• Hearthstone Wiki:Boilerplates

Testing

^{[verification requested]}

2

Template:DrawChance

{{DrawChance}}

100% // 100%

// Error

100% // 100%

// Error

16

2

Template:List cards/Upcoming misbehaving

Template:List cards/Upcoming

Category:Upcoming cards 0

Category:Upcoming expansion cards 0

Category:Statements needing citations 55

{{List cards|category=Upcoming|collapsed=yes}}

{{List cards|category=Upcoming|collectible=true|collapsed=yes}}

{{List cards|category=Upcoming|collectible=false|collapsed=yes}}

Boilerplates

Hearthstone Wiki:Boilerplates

Collectible cards

These templates force pages to add category Category: Pages where template include size is exceeded :

{{List cards|collectible=True|collapsed=yes}}
{{List cards|collectible=True|format=Standard|collapsed=yes}}
{{List cards|collectible=True|format=Wild|collapsed=yes}}

How to debug {{Custom card count}} for having the wrong number of collectible cards?

{{custom card count|collectible=True}} currently equals:

Card counts

Refer to Card set#List for true card counts.

Standard

• Basic collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("B","a","s","i","c")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 133

• Classic collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("C","l","a","s","s","i","c")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 236

• Journey to Un'Goro collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("J","o","u","r","n","e","y"," ","t","o"," ","U","n","'","G","o","r","o")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 135

• Knights of the Frozen Throne collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("K","n","i","g","h","t","s"," ","o","f"," ","t","h","e"," ","F","r","o","z","e","n"," ","T","h","r","o","n","e")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 135

• Kobolds and Catacombs collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("K","o","b","o","l","d","s"," ","a","n","d"," ","C","a","t","a","c","o","m","b","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 135

• The Witchwood collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","W","i","t","c","h","w","o","o","d")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

/ Should be 135

• The Boomsday Project collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j","e","c","t")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 135 (once all cards are revealed)

• • The Boomsday Project collectible cards with added category "Upcoming":

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Upcoming_card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","B","o","o","m","s","d","a","y"," ","P","r","o","j","e","c","t")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

Wild

• Naxxramas collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("N","a","x","x","r","a","m","a","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 30

• Goblins vs Gnomes collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("G","o","b","l","i","n","s"," ","v","s"," ","G","n","o","m","e","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 123

• Blackrock Mountain collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("B","l","a","c","k","r","o","c","k"," ","M","o","u","n","t","a","i","n")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 31

• The Grand Tournament collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","G","r","a","n","d"," ","T","o","u","r","n","a","m","e","n","t")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 132

• The League of Explorers collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("T","h","e"," ","L","e","a","g","u","e"," ","o","f"," ","E","x","p","l","o","r","e","r","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 45

• Whispers of the Old Gods collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("W","h","i","s","p","e","r","s"," ","o","f"," ","t","h","e"," ","O","l","d"," ","G","o","d","s")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 134

• One Night in Karazhan collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("O","n","e"," ","N","i","g","h","t"," ","i","n"," ","K","a","r","a","z","h","a","n")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 45

• Mean Streets of Gadgetzan collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("M","e","a","n"," ","S","t","r","e","e","t","s"," ","o","f"," ","G","a","d","g","e","t","z","a","n")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 132

• Hall of Fame collectible cards:

Function: CargoSQLQuery::run Query: SELECT COUNT(DISTINCT `cargo__Cards`.`_pageName`) AS `count` FROM `cargo__Cards` LEFT OUTER JOIN `cargo___pageData` ON ((`cargo__Cards`.`_pageId`=`cargo___pageData`.`_pageId`)) WHERE (`cargo___pageData`.`_categories__full` RLIKE "(^|\\|)Card_data(\\||$)") AND `cargo__Cards`.`bg_type` IS NULL AND (`cargo__Cards`.`collectible`=1) AND (`cargo__Cards`.`sets` HOLDS CONCAT("H","a","l","l"," ","o","f"," ","F","a","m","e")) ORDER BY COUNT(DISTINCT `cargo__Cards`.`_pageName`) LIMIT 1000

// Should be 13

Kobolds & Catacombs

Some cards had "|collectible=False" instead of "|collectible=false", making the card count of the set wrong. Now fixed.

{{List cards|set=Kobolds and Catacombs|collectible=true|collapsed=yes}}

Tags

Normal tags

List all normal tags:

{{#cargo_query: tables=Cards |fields=Cards.tags |where=Cards.tags__full IS NOT NULL |group by=Cards.tags |limit=5000 |format=ul }}

Hidden tags

List of all hidden tags:

{{#cargo_query: tables=Cards |fields=Cards.hiddentags |where=Cards.hiddentags__full IS NOT NULL |group by=Cards.hiddentags |limit=5000 |format=ul }}

Querying

Syntax for testing for cards with tags / hidden tags:

{{Cards|category=All|tag=TAG}}

{{Cards|category=All|hiddentag=HIDDEN_TAG}}

Arena exclusions

Arena

Not working:

{{Cards|format=standard|exclusions=arena|collectible=true}}

{{Cards|format=standard|exclusions=asdf|collectible=true}}

Collapsible content

Something here.

Potential purging/caching problems

• Hearthstone_Wiki_talk:Community_portal#Keeping_Wild_Event_cards_out_of_queries
• Talk:Rise of Shadows card list
• Alleycat (Battlegrounds)

Link to card table

Special:CargoTables/Cards