North Charleston police officer fired after f...