so i am trying to remember what it was like back in the day...were sigs always pulled from the db for each post? I assume they were
but it strikes me as sad that older posts don't carry older sigs. each new sig wipes out the old one and old posts get "updated"
i suspect this sadness of mine is out of scope for sickos.net as it'd be a structural change to the underlying software but i wonder what others thing about it
- add avatar url and signature fields to the post table
- modify the template to display those instead of what's on the user table
- update the post adding code to set the values on the post table based on what's on the user table at that moment
- make sure changing your avatar doesn't remove your old uploaded avatar
I am still thinking about this. i wonder if a stopgap is just, at sig update time, offering to snapshot one's sig privately into a personal sig gallery.
As a dork who updates his avatar yearly, I love the idea of it being attached to the post upon submission. One issue I see with signatures is they can display external content (see: my sig), which may change, but just getting the text stored off and attached is a great step