A man shot himself in the foot before he went on a meth-fuelled rampage with a loaded rifle through the southern suburbs of Cairns, assaulting officers with urine, faeces, and a cup of milo while in hospital.