User:Aldyron/Diagnostics/Items consistency/Pages using Template Spelldescription

Consistency diagnostics sortable table I used to make lots of mistakes; so, in order to catch my own mistakes, I've trained myself to become a bit of a consistency nazi. The following sortable table should make it easier to identify pages (if any) in need of some tidying-up for consistent properties, both individually and as part of a database. Click and/or shift-click on the column headers to sort the table in different ways, with one or more key columns. Sometimes, by comparing rows, you notice something out of place you might want to edit. By design, this is not a refined table: it is designed to give editors a circumstance bonus to spot inconsistencies (if any) between similar template arguments, so funny table shapes and ugly rows are what we look for. If the table itself has a disrupted shape, two things can be to blame: whoever wrote the dpl code (likely, me) didn't test it long enough and things like an extra space or a missing space influences wikitable markup; or the transcluded content itself disrupts the markup. The latter may or may not be something to correct in the corresponding page (some content was never meant to be transcluded into a table, but if it is in this table, I might have had some reason to include it). This particular table selects pages with the following criteria: page uses Template:Spelldescription.

Almost too long As it is now, this query is close to hitting the system-wide record limit, currently set at 500.

Keep an eye on types As far as I can see, the maximum number of spell subschools + descriptors (i.e. the several Type n columns) is currently 6, so column Type 7 is all empty. That's intentional: if you ever notice anything in column Type 7, that means there's something new. In that case, please update the query code to include type8, update this notice box, and check again (in case two or more were added). Or notify me, I'll do it. Thank you. Aldyron (Contributions • Message) 08:09, October 3, 2013 (EDT)

Content page	Namespace	Title	Name	Icon	School	Type 1	Type 2	Type 3	Type 4	Type 5	Type 6	Type 7	Artificer	Bard	Cleric	Druid	Favored Soul	Paladin	Ranger	Sorcerer/Wizard	Cost	Components	Metamagic	Range	Target	Duration	Save	Spell Resistance	Cooldown	Categories	N
Spelldescription	Template	Spelldescription		[[File:]]																										Requested merges, Spells with a Somatic component, Spells with a Verbal component, Templates
Spelldescription	Template	Spelldescription	Bestow Curse	BestowCurse.png	Necromancy										3		3			4	10	SomaticSomatic: A somatic component is a measured and precise movement of the hand. You cannot cast spells that require this component if you cannot move causing arcane spell failure resulting in a ruined spell. Spells without a somatic component may be used with disregard to Arcane Spell Failure chance. Note - that characters make the same arm gestures for most spells in DDO, so you can't tell which spells require this component by watching your character's animations., VerbalVerbal: A verbal component is a spoken incantation. You cannot cast spells that require this component if you cannot act or speak. Certain rare spells, such as Silence Creature, may temporarily disable spells that require verbal components.	Enlarge, Heighten, Quicken	Standard	Foe	7 minutes 40 seconds at CL20	Will save negates	Yes	3 seconds (All except Sor), 2 seconds (Sor)	Requested merges, Spells with a Somatic component, Spells with a Verbal component, Templates
Spelldescription	Template	Spelldescription	Bestow Curse	BestowCurse.png	Necromancy										3		3			4	10	SomaticSomatic: A somatic component is a measured and precise movement of the hand. You cannot cast spells that require this component if you cannot move causing arcane spell failure resulting in a ruined spell. Spells without a somatic component may be used with disregard to Arcane Spell Failure chance. Note - that characters make the same arm gestures for most spells in DDO, so you can't tell which spells require this component by watching your character's animations., VerbalVerbal: A verbal component is a spoken incantation. You cannot cast spells that require this component if you cannot act or speak. Certain rare spells, such as Silence Creature, may temporarily disable spells that require verbal components.	Enlarge, Heighten, Quicken	Standard	Foe	7 minutes 40 seconds at CL20	Will save negates	Yes	3 seconds (All except Sor), 2 seconds (Sor)	Requested merges, Spells with a Somatic component, Spells with a Verbal component, Templates
Xiaobo's Shock Dust		Xiaobo's Shock Dust		XiaoboShockDust.png	Evocation	Electricity																		Touch	Enemy	38 sec.[Unverified"38 sec." has not been verified in-game. Please verify it!]	Reflex			All spells, Electricity spells, Evocation spells, Help improve, Monster abilities, Unverified
Administrators' noticeboard/Requests				[[File:]]
Night Horrors		Night Horrors		Rejuvenation Cocoon Icon.png	Transmutation																				Self	90 seconds		No	1 Minute	All spells, Buff spells, Spells with unknown range, Transmutation spells, Unique item enchantments
Move like the Night		Move like the Night		Rejuvenation Cocoon Icon.png	Transmutation																				Friend, Self	25 seconds		No	1 Minute	All spells, Buff spells, Spells with unknown range, Transmutation spells
Requested merges				[[File:]]
Joenuts/Sandbox/Infobox-Spell Migration				[[File:]]
Joenuts/Spell pages that use Spelldescription				[[File:]]