97 sentra gxe problems already searched couldnt find anything

[jakums]

ok so its got a a** load of miles on it 246,687 to be exact...so driving it down the road it shat it self in the middle of the street. i guess it it desided to free out buy having the check engine light & ebrake light go off and it blew my low beam balbs and screamed at my throught my speakers....literly so ya it needs an alternater but theres more my rad phanes have decided that my sentra is just not cool enough so they decided a full time job of pissing me off and never turning off and ontop of that when i turn the key here wat i donno what it is (pic will be below all this) it makes a zzzzzzzz niose when i turn the key and then it will stop its dosent sound healthy so what is it