Magic Cop (1990)
A former cop rejoins the police department to investigate a drug ring that employs ghosts and vampires