In Germany you need to look away your gun and need to have it in a locked case for traveling (even in a car as a hunter).
And for the school shootings: less bullying more social support.
It's not magic, it's not the guns and other weapons.
The solution to all is education and social support.
Let people take part in our society.