How do I do [X] questions here

[Montonago]

I have a few things I want to try, but I'm not sure how I would script them:

I would like to have a crank or wheel activate some sort of event, for example, have wood_crank_1 unlock castle_door_2 when it reaches it's maximum rotation. Allowing the player into the room to retrieve an item to unstuck another wheel that moves an obstacle in front of a lever to open a secret door, etc. I don't know how to make the wheels/cranks do things when they reach the maximum/minimum rotation, and I don't know how to do the secret door event like in the Old Archives.

I would also like to create a lighting effect like they used in Harry Potter: The Sorcerer's Stone, where when the player is near a light it will self-ignite, and when they get x amount away from the light source, it extinguishes. I'm assuming this has to do with areas, but I'm not sure how that would be set up. Any help would be appreciated. Thanks!

Also, feel free to post any "How do I do [x]" questions here to save thread space.