I found that opening MS Excel, using the import option, and setting the deliminator to ^ let me view the spells in collum format and make changing them all to be usable by lvl 1 and all classes was super easy. you then simply export it again making sure you use ^ as your deliminator. ***NOTE*** a value of 255 for the level means that it cannot be used, your value should read something like "wizard(1)" in game.
As for setting your scrolls to all/all, you have to go into the database and make the changes to the table "items", collum "classes" AND "races", value "65535"
|