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

[CRego3D]

Originally posted by 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 ############################### 


I had t do the same to work :/

[CRego3D]

Suggestion:

how abbout adding a way for the users to tie a URL to the sigimage ?

[Kars10]

Originally posted by CRego3D
Suggestion:

how abbout adding a way for the users to tie a URL to the sigimage ?

Yeah this could be very cool!!

[Chris M]

@Mini & Crego -

I had that planned for the next release

About the Usercp change

I had not tested this part, as it was an addon made by N9ne, who said it worked...

I shall add that code to the file this weekend

@Crego - Yes...I forgot to change that in the install file, but I shall at the weekend...That was part of a hack I had installed...

Satan

[mADmAX`]

Originally posted by CRego3D


I had t do the same to work :/

What version of VB are you running? I am still running 2.27...

(Maybe from 2.27 - 2.28, something was changed where 2.27 users need to add that also)

[N9ne]

This is really weird, can someone tell me, is global.php hacked in this version 3? If it is it seemed to include the signature image globally for me, that's why the signature image does work for me in userCP

[CRego3D]

Originally posted by mADmAX`


What version of VB are you running? I am still running 2.27...

(Maybe from 2.27 - 2.28, something was changed where 2.27 users need to add that also)

2.2.8 .. I woudl really liek to know why it needs that code .. it is working .. but still .. hehe

trying to get this to work, so we can used it on yaxay 2 .. hopefully we will be able to export it to our gallery/tuts as well

[PennylessZ28]

Here is the current problem I'm having, that I could use some help with. After I edited the member.php file, and I've followed it to the teeth 4 times now, I get the following error when I go to the user CP and click options >>

Database error in vBulletin: Invalid SQL: SELECT user.signatureid,signaturepath,NOT ISNULL(signaturedata) AS hascustom,customsignature.dateline
FROM user
LEFT JOIN signature ON signature.signatureid=user.signatureid
LEFT JOIN customsignature ON customsignature.userid=user.userid
WHERE user.userid='1'
mysql error: Unknown column 'user.signatureid' in 'field list'
mysql error number: 1054
Date: Tuesday 05th of November 2002 07:11:11 PM
Script: /forum/member.php?action=editoptions
Referer: http://www.hr3rdgen.org/forum/usercp.php?

I'm not sure what I can do to correct this problem or fix it. Anyone give some advice?

[mADmAX`]

PHP Code:

ALTER TABLE user ADD signatureid smallint(6) NOT NULL 


Run that query as it seems you are missing that one.

Also make sure you ran all other queries in the queries.txt file.

Hope that helps...

[PennylessZ28]

Thank you, as that seems to have sovled my problem