1. a bit of a ladies man
2. the soul of the party
It can also be used in sarcastic terms to define someone who is the complete opposite such as a bald, old wrinkled geezer.
" Check out that old yin, wit a shagger! ha ha!"