East St. Louis detective resigns amid drug charges