Hi, just thought I'd take a quick stab at your question. If you wanted to event script it, you could have your weapon inflict a state called 'drain' (or whatever) and have a parallel event called from battle that checks to see if any enemies are inflicted with this state, then - HP from the enemy and + to your hero. You'd have to do a condition branch for each potential enemy.
Hope that helps.