Reply to thread

Message

<blockquote data-quote="gtJormungand" data-source="post: 2042460" data-attributes="member: 1186">Andargor's page has a nifty MySQL database for the entire SRD, including the spells: <a href="http://www.andargor.com/" target="_blank">http://www.andargor.com/</a>A SQL string that would find such would be:SELECT name, RIGHT(SUBSTRING_INDEX(SUBSTRING(level, LOCATE(&quot;sor/wiz&quot;,level)),',',1),1) AS WizLevel FROM spell WHERE LOCATE(&quot;sor/wiz&quot;,level) &gt; '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 &quot;sor/wiz&quot; strings to &quot;Sorcerer/Wizard&quot;)This gives the following spells:[CODE]&nbsp; &nbsp; 0th:FlareLight&nbsp; &nbsp; 1st:Feather FallHold PortalTrue StrikeVentriloquism&nbsp; &nbsp; 2nd:Blindness/DeafnessBlurDarknessKnock&nbsp; &nbsp; 3rd:DisplacementSuggestionTongues&nbsp; &nbsp; 4th:Dimension DoorGeas, LesserShout&nbsp; &nbsp; 5th:Contact other planeTeleport&nbsp; &nbsp; 6th:Suggestion, Mass&nbsp; &nbsp; 7th:Phase DoorPower Word BlindTeleport ObjectTeleport, Greater&nbsp; &nbsp; 8th:Maddening ScreamBindingCharm Monster, MassIrresistible DancePower Word Stun&nbsp; &nbsp; 9th:Mage's DisjunctionPower Word KillPrismatic SphereTeleportation CircleTime StopWail of the BansheeWish[/CODE]</blockquote>

[QUOTE="gtJormungand, post: 2042460, member: 1186"] Andargor's page has a nifty MySQL database for the entire SRD, including the spells: [url]http://www.andargor.com/[/url] 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 [/CODE] [/QUOTE]

Verification