signature in db
 

where is your signature located?
i cant seem to find it in the database

usertextfield table

ok thanks but now i getting a db error:
what does that mean?

you have two columns userid and are not specific which one you mean.

replace it with user.userid in the wherclause

how do i parse bbcode?

parse_bbcode()

look at functions_bbcodeparse.php

thanks

whats difference between bbcodeparse and bbcodeparse2?

bbcodeparse2 is the actual parser, you have to manually set up the options there.
bbcodeparse does find out which options bbcodeparse2 has to use.
depending on where you want to use the parser, most of the time in an external script bbcodeparse2 is your choise :)