How can I create a stained glass light effect?
Add a spot lamp, then go to texture panel, clic on the lightbulb (lamp texture) and add your texture.
I don't use BGE so I couldn't help more with it, but it looks like what you want.