I was messing with the tuning files and found what I believe to be the effects emotions have on skills (or, rather, their effective levels, used to determine success but not for unlocking interactions). The condensed version follows.
Happy: +1 to all skills, or +2 if Elated (Very Happy).
Confident: +1 to all skills, and a further +1 to Charisma. Fearless (Very Confident) increases the bonus to all skills by a further +1.
Energized: +2 to all physical skills, or +3 if Pumped (Very Energized).
Flirty: +1 to Charisma, or +2 if Passionate (Very Flirty)
Focused: +2 to all mental skills, or +3 if In The Zone (Very Focused)
Inspired: +2 to all creative skills, or +3 if Imaginative (Very Inspired)
Inspired (with Muser): +3 to all creative skills, or +4 if Imaginative (Very Inspired)
Playful: +2 to Comedy, +1 to Charisma. A further +1 to Comedy if Silly (Very Playful), or +2 to Comedy if Hysterical.
Angry: -1 to all creative and mental skills, as well as to Charisma, and +1 to Mischief. Furious increases the penalties to -2 and bonus to +2, enraged to -3 and +3.
Angry (with Hot Headed trait): -1 to all creative and mental skills, as well as to Charisma; +1 to Mischief and to all physical skills. Furious increases the bonus to physical skills (only) to +2, and Enraged to +3.
Bored: -1 to all skills.
Dazed: -3 to all skills.
Embarrassed: -1 to all social skills. Humiliated (Very Embarrassed) increases the penalty to -2, and Mortified to -3.
Sad: -1 to all skills, except creative ones, which get a +1 bonus instead. Depressed bumps the penalties to -2 and removes the bonus to creative skills.
Sad (with Gloomy trait): -1 to all skills, except creative ones, which get a +1 bonus instead. Depressed bumps the penalties to -2 and the bonus to +2.
Tense: -1 to all skills, -2 if very tense.
Uncomfortable: -1 to all skills, -2 if Miserable (Very Uncomfortable)
Keep in mind that this is only the effect on effective skill levels; emotions play a larger role than mere skill bonuses and penalties.
Edit: I just found that I had forgotten Embarrassed in this table. Added.