Signature Image System Hack - Version 3.0+...

This hack is now a Full Release!!!...You can visit the BETA thread here - I will still be using that thread to test out upcoming versions!

Please do the following before attempting to install:

1.) Backup your Files & Database before doing anything
2.) Be aware that although I have tested this myself, there may still be problems...If you do not backup your files & database, I cannot condone your install of this hack...

The files you should have are:

In the main folder
modifications.php
templates.php
queries.php
3.0 - Show Signatures.php
3.0 - Usergroup override - permissions.php
NEW INSTALL.php

In the root folder
signature.php

In the admin folder
signature.php

*================================================= ================================================== ==================*
Please Note:
The install files are in the ".php" format, as vBulletin.org Parses all "{ imagesfolder }" and other replacment variables
used in the code - With .php extensions, it does not.
*================================================= ================================================== ==================*

Install Info:
Hack Version: 3.0+
Files to edit: 9 (admin/functions.php, admin/user.php, root/member.php, root/showthread.php, root/register.php, root/online.php, root/global.php, root/usercp.php, admin/index.php)
Templates to add: 19
Templates to edit: 5
Time to install: Approx 10-15 Minutes

Thanks
Special thanks should go to the following people:

N9ne - For providing template modifications, and for being a BETA tester
Minifreunde - For requesting this hack, and for being a BETA tester
DrkFusion - For being a BETA tester
NTLDR - For helping with a few errors during the BETA testing stage...
mADmAX`- For providing the missing code to the root/usercp.php file...You can find his manual change here

Support - I am offering support, but only in THIS THREAD...I unfortunately cannot be here during the coming weeks (Mon-Fri), so therefore you will have to rely on others for assitance, should it be urgent...If you do require assitance, please - Only reply in this thread

Screenshots
Screenshots will be coming in the next post in a .zip file of their own...

Updating from BETA

Depending on what version you are updating from, I recommend the following:

Version 1.0Beta - 2.1Beta - Complete re-install
Version 2.2Beta - Follow the instructions for the .php files starting "3.0", and there is one register.php modification and one usercp.php modification in the "modifications.php" file
Version 3.0Beta - There is one register.php modification and one usercp.php modification in the "modifications.php" file

v3+ comes out!
v3+ is really just the following:

Converting of all install files to .php format (to prevent code parsing)
Creation of an extra folder (root) to house the root/signature.php file (so you dont get confused with the install .php files)
The root/usercp.php modifcation I forgot to include

Enjoy!

Satan

[Chris M]

Hmmm...

You should try re-doing the queries

Perhaps it will correct the problem

If not, Im not quite sure whats wrong

Satan

[Shadow_NL]

LOL, I forgot to run this query:

ALTER TABLE user ADD signatureid smallint(6) NOT NULL

Heh thanks for the help.

[Chris M]

No problems

Glad you found the problem

Satan

[Crazy Pete]

hellsatan, I just noticed another problem. I have the dimension settings set at a max width of 468 and a max height of 200. Yet someone on my board managed to get a signature image that's 210 wide but 300 high. Any ideas why/how, or how to fix that? Thanks.

[LangTuDaTinh]

Originally posted by Crazy Pete
hellsatan, I just noticed another problem. I have the dimension settings set at a max width of 468 and a max height of 200. Yet someone on my board managed to get a signature image that's 210 wide but 300 high. Any ideas why/how, or how to fix that? Thanks.

heheheh read my post above.... i have the same problem....

[Chris M]

@Crazy Pete - This seems to be a recurring problem, only experienced by some users...

Myself and a few other people have yet to be able to re-create this problem...

I shall see if I can find out what causes it

Satan

[Crazy Pete]

@hellsatan - Thanks!

[Chris M]

No problems

Satan

[L-Mane]

When I ran the fourth query I got this error

SQL-query :

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (103,'Signatures','27')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Enable Signatures','signatureenabled','1','Use this option to enable/disable the overall use of signature images.<br><br>Signature Images can be uploaded via the Admin Panel or the User Control Panel','yesno','1')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Minimum custom posts','signaturecustomposts','','Minimum number of posts that a user required before they can specify a custom signature image for use.','','2')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Allow uploads','signatureallowupload','1','Allow Signature Image uploads?','yesno','3')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Allow website uploads','signatureallowwebsite','1','Allow users to upload their signature image from another website?','yesno','4')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Maximum Image Width','signaturemaxwidth','400','Enter the maximum width value in pixels for a Signature image. Set this to 0 for no limit','','5')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Maximum Image Height','signaturemaxheight','','Enter the maximum height value in pixels for a Signature image. Set this to 0 for no limit','','5')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Display Height','numsignatureshigh','5','How many rows of signature images do you wish to display to the user when selecting a signature?','','7')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Display Width','numsignatureswide'

MySQL said:
You have an error in your SQL syntax near 'INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,op' at line 2

anyone know the answer to this?

[Crazy Pete]

@ L-Mane, try those queries again, but instead of ending them each with just ), make sure they all end in );

That should do the trick.