Do my secret photos get activated by other members?

No, other members can't see your secret photos. 

A Fetish.com administrator will review the photos you upload to the secret gallery.