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]

Yeh...

If you apply the change above, it will do what you want...

All that it means above is that they dont have to have a signature to have a signature image

Satan

[Vile]

Very nice hack, but I need some help

I dont mean to sound like such a n00b (which I am) but...

I ran the first 3 queries just fine, but when I got to the fourth query which is:

PHP Code:

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (103,'Signatures','27')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) VALUES (NULL,103,'Allow uploads','signatureallowupload','1','Allow Signature Image uploads?','yesno','3')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) VALUES (NULL,103,'Display Width','numsignatureswide','5','How many columns of signature images do you wish to display to the user when selecting a signature?','','8') 


I get the following error:

PHP Code:

SQL-query :  

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

INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) VALUES (NULL,103,'Allow uploads','signatureallowupload','1','Allow Signature Image uploads?','yesno','3')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,optioncode,displayorder) 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,description,op' at line 2 


I know it says I have an error in line 2, but I have no idea what or how I'm supposed to fix it.

Any ideas?

Thanks a lot.

[mADmAX`]

Just installed this and for some reason on the usercp, if you have no signature image...you get a missing image. I checked the html code and it looked like this....

< img src = "" >

Either I am tired or I can not figure out why the $ bbuserinfo[signatureurl] code doesnt pass the if, then else.

Also noticed that its signatureid and not signatureurl in the table user, if that is the issue. Again, I am tired so probably my over looking.

[N9ne]

Hm, this is strange, in my userCP I use <img src="$bbuserinfo[signatureurl]" border="0" alt=""> and if there is no sig image, there's no broken image, there's nothing...

[mADmAX`]

Not sure if this is right, but I noticed there was nothing in usercp.php with this so I added it. Right after I added it, it started working, so eitehr theres a step missing or I missed one.

PHP Code:

// ############################### start signature ###############################

  $bbuserinfo[signatureurl]=getsignatureurl($bbuserinfo[userid]);
  if ($bbuserinfo[signatureurl]=="") {
    $bbuserinfo[signatureurl]="http://{ imagesfolder}/clear.gif";
  } 


(Note the space in { imagesfolder}

PHP Code:

// ############################### start private messages ############################### 


[mADmAX`]

Anyway we can use this for flash signature images?

I tried a few things and it will not load:

< embed src=signaturexxxxxxx >

[assassingod]

Have you tried the proper flash tag?:

<OBJECT classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=4,0,0,0" width=380 height=28 align=middle id=quickstart>
<PARAM name="Movie" value="signaturexxxxxxx">
<PARAM name="loop" value="false">
<PARAM name="bgcolor" value="#000000">
<EMBED src="signaturexxxxxxx" width=200 height=40 align=middle swLiveConnect=true pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" LOOP=FALSE bgcolor=#000000 name="signaturexxxxxxx">
</EMBED>
</OBJECT>

[mADmAX`]

Yes, I tried that but it seems that it will not pull the embed out of the database using this hack for some reason.

[N9ne]

I did not have to modify usercp.php when I made the template addon, as I think it is calling it from global.php...

[CRego3D]

PHP Code:

    case 'editavatar':
      $userinfo[where] = "Changing <a href=\"member.php?s=$session[sessionhash]&action=editavatar\">Avatar</a>";
      break;

add below:
---

    case 'editsignature':
      $userinfo[where] = "Changing <a href=\"member.php?s=$session[sessionhash]&action=editsignature\">Signature Image</a>";
      break;[/ 


can't find it .. all I have is

case 'editavatar':
$userinfo[where] = "Changing Avatar";
break;