Hi Folks,
I don't know if you consider SQL tips as hacks, but if so then please accept the following for vB 3.x.
We have a problem on our forum with people putting in rediculously long signatures. Some of these look ok, though, as the occasional responsible people are using only a few carriage returns and make use of the [size] tag to make their signature text smaller.
This SQL script is very simple but for people not accustomed to SQL, it might be useful. It doesn't deal with carriage returns (yet) but does deal with otherwise lengthy signatures by wrapping a size tag round them but ONLY if the user hasn't used a size tag already :
PHP Code:
update usertextfield set signature = concat('[size=1]',signature,'[/size]') where signature not like '%[size%' and length(signature) > 100;
This only changes signatures containing over 100 characters. Obviously you can change the 100 to any figure. Some of our members have signatures over 400 characters in size. At least if the text is small it doesn't take up a whole page.
I think you haven't noticed the vb option "Maximum Length of Signature" in your admin cp?
Well no, actually I had overlooked that. It was set to 500 and I've dropped it to 100. Still for existing users it's useful. And for people with forums where they want people to have lengthier sigs.
Quote:
Originally Posted by drumsy
Hmmm, so if I wanted to limit font size in signatures, I could use this query by changing 100 to 1? Would I run this query via the AdminCP?
Well putting the size tag around all signatures will make them longer by 14 characters. So there's little point in doing it on sigs below, say, 30 characters.
I have never run queries in the admnicp since I use phpmyadmin but I guess you could.
Definitely backup your usertextfield table first.
I've been trying to get the div overflow method working for many months now ... both now that one of my forums is on vBulletin and before when it was on Invisionboard.
The problem I find is that it works with Mozilla/Firefox, but not with IE. If there were a way to get it working with both browsers, it would be great. Most users still stick with IE, so they are the ones you want to have it working for. And my mods keep moaning about signature problems, I don't even want anything complex to limit them, just something simple like that would be ideal.
I've been trying to get the div overflow method working for many months now ... both now that one of my forums is on vBulletin and before when it was on Invisionboard.
The problem I find is that it works with Mozilla/Firefox, but not with IE. If there were a way to get it working with both browsers, it would be great. Most users still stick with IE, so they are the ones you want to have it working for. And my mods keep moaning about signature problems, I don't even want anything complex to limit them, just something simple like that would be ideal.