wizard spells with no somatic component


log in or register to remove this ad




Andargor's page has a nifty MySQL database for the entire SRD, including the spells:
http://www.andargor.com/

A SQL string that would find such would be:
SELECT name, RIGHT(SUBSTRING_INDEX(SUBSTRING(level, LOCATE("sor/wiz",level)),',',1),1) AS WizLevel FROM spell WHERE LOCATE("sor/wiz",level) > '0' AND (FIND_IN_SET(' S', components) = 0 AND FIND_IN_SET('S', components) = 0) ORDER BY WizLevel ASC;

(EDIT: this probably won't work in the new version as is... you'd have to change the "sor/wiz" strings to "Sorcerer/Wizard")

This gives the following spells:
Code:
    0th:
Flare
Light
    1st:
Feather Fall
Hold Portal
True Strike
Ventriloquism
    2nd:
Blindness/Deafness
Blur
Darkness
Knock
    3rd:
Displacement
Suggestion
Tongues
    4th:
Dimension Door
Geas, Lesser
Shout
    5th:
Contact other plane
Teleport
    6th:
Suggestion, Mass
    7th:
Phase Door
Power Word Blind
Teleport Object
Teleport, Greater
    8th:
Maddening Scream
Binding
Charm Monster, Mass
Irresistible Dance
Power Word Stun
    9th:
Mage's Disjunction
Power Word Kill
Prismatic Sphere
Teleportation Circle
Time Stop
Wail of the Banshee
Wish
 
Last edited:

Remove ads

Top