DUI Charge Gets South Carolina Police Officer Fired