Wand with a spell and the hero's line of sight.

I have a question regarding two situations:

1) I need to edit a wand so that it always grants a specific spell, in my case, Earthquake. Despite searching through the game files, I haven't found where the information about its special properties is stored. I only found the bonuses to the main characteristics.

2) Is it possible to reduce the hero's vision range? If so, how?

Thank you for your help.