Where is the signature imformation stored?
 

I know some of it is stored in sigparsed. Where else?

What are you trying to do?

I have a really annoying staff member that wants to use flash in his sig. I dont want to install the bbcode just so that he can use it because then people will start using hidden flash posts with annoying music and what not. I told him I would directly inject the html code in the database (so that I didnt have to deal with the bbcode and also get the staff member off my back).

So I placed the html code in the sigparsed table. But then he noticed the in the user profile it wasnt parsed. I realize that the flash ability will go away once he tries to edit his signature and I made sure he knows that. sigparsed though seems like the place where the signatures are parsed and cached for posts and what not. I just thought there was another place where the signature information was stored.

The signature (pre-parsed) is stored in the user table.

Are you sure? That was the first table I checked. I rechecked it right now and I can't find it. I am using 3.7, I know I've seen the sig info in the user table in 3.5. Did it get moved back in 3.8?

in on 3.8.1 my user signatures are stored in
the table named PREFIX + usertextfield

the colum is ewen named signature

My bad - it must have been moved sometime.

Vaupell, thanks for your answer!