Administrative and Maintenance Tools - Excessive Signature Check

vBulletin Excessive Signature Check v1.0

Modified for vBulletin 3.7.0 rc1
?Tommy Miland 2008
http://www.snute.net
With permission from original owner

Original script for e107 by:
?Richard Perry 2004
http://www.greycube.com

Released under the terms and conditions of the
GNU General Public License (http://gnu.org).

Note: Use at your own risk!

Installation:

- Upload the signaturecheck.php to your admincp folder
- Add a link in the footer template
Find:

<if condition="$vboptions['hometitle']"><a href="$vboptions[homeurl]">$vboptions[hometitle]</a> -</if>

Add after:

<if condition="$show['admincplink']"><a href="$admincpdir/signaturecheck.php$session[sessionurl_q]">Check Signatures</a> -</if>

Configuration:

Edit the signaturecheck.php and near the top you can change the following settings

$image_maxsize = // MAX FILE SIZE IN KB
$image_maxwidth = // WIDTH IN PIXELS
$image_maxheight = // HEIGHT IN PIXELS
$image_timeout = // TIME ALLOWED FOR LOADING THE IMAGE IN SECONDS


Running:

Note the script can only be run by an admin.


By default the script is PASSIVE and will NOT remove any signatures, just display the results.

For this type in a browser www.yourdomain.com/forum/admincp/signaturecheck.php


You can make the script active and go through replacing excessive signatures as well

For this type in a browser www.yourdomain.com/forum/admincp/signaturecheck.php?active=1


On either mode, THE SCRIPT CAN TAKE A LONG TIME TO LOAD, this is because the

webserver has to download each signature image to be able to check the size.

Just be patient and go make a drink, im talking about 10 mins per 500 sigs.



Limitations:

Currently the signature check is limited to checking images only

This means that excessive text based signatures ( large fonts, long lines etc ) will not be fixed.

Existing signatures in your forum posts will not be replaced, wich means the script will only replace signatures in the profile.
To replace signatures wich have been removed by the script, you need to run "Empty Signature Cache" in the Maintenance section of Admincp. (Thanks to FRDS for the reminder)

Take a look at the images to see how it works:

[RvG2]

hey nice idea

[SEOvB]

Cool idea and nicely done, but vBulletin can do this already using the signature permissions, and then rebuild signature cache from maintence i beleive

Though this gives a report and is alot cooler

[tmiland]

Originally Posted by FRDS

Cool idea and nicely done, but vBulletin can do this already using the signature permissions, and then rebuild signature cache from maintence i beleive

Though this gives a report and is alot cooler

Thank you
Vbulletin has no way of controlling external images, as far as i know, thats why i did this
The image a user uploads is another thing. I'm talking about an image between the [IMG] tags wich is hosted at f.eks photobucket.

If there is, please tell me where to find those settings!

[KURTZ]

interesting tool ... nice job

/me clicks install

[iRO Wiki]

First suggestion:

It would be a lot cleaner to go through if all results with "no image" could be hidden.


Noticed a few glitches so far:

On a few I get Signature Removed - Only One Image is Allowed.

There's no setting in the file for amount of images allowed, and the code further down is confusing! Having it look up usergroup[sigmaximages] (if possible) or just making it an option at the top with the rest would be awesome!

When the image isn't found, I get messages similar to the following:

Warning: fsockopen() [function.fsockopen]: unable to connect to img165.imageshack.us:80 (Connection timed out) in /xxx/admincp/signaturecheck.php on line 106

Warning: getimagesize(http://imageurlhere.com) [function.getimagesize]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /xxx/admincp/signaturecheck.php on line 156

Is that normal? The script is working fine by detecting a 404, I'm just not sure it's supposed to be returing those errors.



My forums.domain.com is turned into forums.domain.com/forum for the result URL.

Changing line 65 to this should fix it no matter what your base URL is:

echo "<a href='/member.php?u=$mysql_row[userid]'>$mysql_row[userid]</a> $check_result <br />";

I'll keep toying with it!

[King Kovifor]

You might want to try to utilize the vBulletin options. They would allow non-coders an easy way to change their options for your mod.

[tmiland]

Originally Posted by iRO Wiki

On a few I get Signature Removed - Only One Image is Allowed.

There's no setting in the file for amount of images allowed, and the code further down is confusing! Having it look up usergroup[sigmaximages] (if possible) or just making it an option at the top with the rest would be awesome!

Hmm... As a temporary fix, change line 96 from

PHP Code:

   if ($images[1][1]) 


to

PHP Code:

   if ($images[1][2]) 


Originally Posted by iRO Wiki

When the image isn't found, I get messages similar to the following:

Warning: fsockopen() [function.fsockopen]: unable to connect to img165.imageshack.us:80 (Connection timed out) in /xxx/admincp/signaturecheck.php on line 106

Warning: getimagesize(http://imageurlhere.com) [function.getimagesize]: failed to open stream: HTTP request failed! HTTP/1.1 404 Not Found in /xxx/admincp/signaturecheck.php on line 156

Is that normal? The script is working fine by detecting a 404, I'm just not sure it's supposed to be returing those errors.

It should state below the error something like this:

Signature Removed - Unable to load the image

My forums.domain.com is turned into forums.domain.com/forum for the result URL.

Changing line 65 to this should fix it no matter what your base URL is:

Code:
echo "<a href='/member.php?u=$mysql_row[userid]'>$mysql_row[userid]</a> $check_result <br />";

That doesnt work for me... It will bring me to mydomain/member.php?u=x
and is ofcourse different from user to user

[King Kovifor]

Also, it is proper coding style for vBulletin is to use the vBulletin Database class ($vbulletin->db) for all your mySQL actions.