Where is the signature imformation stored?

[jdelator]

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

[Dismounted]

What are you trying to do?

[jdelator]

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.

[Dismounted]

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

[jdelator]

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?

[Vaupell]

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

the colum is ewen named signature

[Dismounted]

My bad - it must have been moved sometime.

[ThorstenA]

Vaupell, thanks for your answer!