Signature Image System - Version 3.0Beta...

Can I stress that this IS A BETA

Please do the following before attempting to install:

1.) Backup your Files & Database before doing anything
2.) Be aware that this is a BETA
3.) Be aware that although I have tested this myself, there may still be problems...

I did the hack .txt files in a strange way for some reason - I recommend running the Queries first, which are at the end of "file mods.txt"...

The files you should have are:

In the main folder
signature.php
file mods.txt
file mods2.txt
templates.txt
queries.txt
3.0Beta - Show Signatures.txt
3.0Beta - Usergroup override - permissions.txt
UPGRADING.txt
NEW INSTALL.txt

In the admin folder
signature.php

"file mods.txt" & "file mods2.txt" contain File modifications..."templates.txt" contains just templates to add and templates to edit..."queries.txt" contains Queries to run...

Install Info:
Hack Version: 3.0Beta
Files to edit: 8 (admin/functions.php, admin/user.php, root/member.php, root/showthread.php, root/register.php, root/online.php, root/global.php, admin/index.php)
Templates to add: 19
Templates to edit: 5
Time to install: ???

Thanks
Special thanks should go to the following people:

N9ne - For providing a new modifyoptions template modification, a small template addon, and a postbit modification
Minifreunde - For requesting this hack, and for being a BETA tester
DrkFusion - For being a BETA tester
NTLDR - For fixing an SQL Error in the admin/user.php file

Support - I am not officially offering support, because I have not installed this myself...As it is a BETA, I am waiting to find what errors other people find I will help if I can however, so there is what I would call minimal support...

If you require assitance, please - Only reply in this thread

Enjoy!

UPDATE!!-1.1Beta

I have corrected the template (i believe), and have uploaded a new .zip file...This file also contains the corrections I mentioned below, apart from the member.php issue, which will be 1.2Beta when fixed - Ok...The template wasnt corrected properly Can someone please find a way to make the "modifyoptions" template addon work? Im not good with tables etc in HTML

UPDATE!!-1.2Beta

I have corrected the code error that causes you to be redirected to the usercp.php file from the "edit options" screen...Please download the new file, or you can scroll down and find my fix (2nd post from the bottom) - The template still is not fixed, so again, if anyone can supply me with one that does, please do

UPDATE!!-1.3Beta

Now the modifyoptions template error has been corrected thanks to N9ne This hack is still a BETA until the other two BETA testers (DrkFusion & Minifreunde) have come back and posted that it works, but from my end, it does work

UPDATE!!-1.4Beta

I have included another file in the .zip - It now has an auto-query installer, so that you only need to add the Templates manually

UPDATE!!-1.5Beta

I have updated the "file mod.txt" file now Thanks to NTLDR for helping me fix the error in admin/user.php. For those of you who want to correct, it is the first change to user.php in the new .zip file, or you can see the fix on the second page of this thread

UPDATE!!-1.6Beta

I have updated the "file mod2.txt" file to include instructions for adding the "Signatures" option to the Admin Control panel...I totally forgot about this part!!! - See Page 3 for the update if you dont want to re-download

UPDATE!!-1.7Beta

Everybody who has this installed must update to 1.7Beta now!!! I forgot that the $post[signature] variable in admin/functions.php already exists!!! I have corrected the .txt file, and now the variable is $post[signatureimg] - Luckily, I had already realised this with the templates, so no editing other than admin/functions.php is needed - See Page 4 for the update without downloading the .zip

UPDATE!!-1.8Beta

Everybody who has this installed must update to 1.8Beta now!!! I also forgot another 2 things - I forgot that the instructions were set to overwrite the "postbit_signature" template...Please read this post if you have Version 1.7Beta or earlier, to fix it

=-=

UPDATE!!-1.9Beta

I have just released Version 1.9Beta!

What you should do to upgrade:

Click here!

=-=

UPDATE!!-2Beta

I have just released Version 2Beta!

What you should do to upgrade:

Click here!

=-=

UPDATE!!-2.1Beta

I have just released Version 2.1Beta!

=-=

UPDATE!!-2.2Beta

I have just released Version 2.2Beta!

What you should do to upgrade:

Click here!

=-=

UPDATE!!-3.0Beta

I have just released Version 3.0Beta!

What you should do to upgrade:

Click here!

=-=

Satan

[N9ne]

Try this...

[Chris M]

Awesome

It works!

Satan

[N9ne]

Glad it worked

[Chris M]

As am I

News

This hack will remain a BETA until Minifreunde and DrkFusion report back in this thread saying that it works

I myself have tested it on my offline boards, so I know that it does work

Satan

[NTLDR]

Originally posted by hellsatan
For your pleasure, I have attached the referrers script...
It does prevent hotlinking

Thanks for posting that hellsatan, I was looking for a PHP way to block referrers some time ago, I can impliment this into my vB now

[Chris M]

No problems

Satan

[Chris M]

Hmmm...

I found this error

Database error in vBulletin Control Panel 2.2.8:

Invalid SQL: SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,
                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
                               FROM user
                               LEFT JOIN signature ON signature.signatureid=user.signatureid
                               LEFT JOIN customsignature ON customsignature.userid=user.userid
                               WHERE user.userid=1
mysql error: You have an error in your SQL syntax near 'signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsi' at line 6

mysql error number: 1064

Date: Wednesday 30th of October 2002 04:06:54 PM
Script: http://127.0.0.1/forum/forum/admin/u...=edit&userid=1
Referer: http://127.0.0.1/forum/admin/index.php

Satan

[Chris M]

Open admin/user.php
Find:

PHP Code:

                               avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
                               FROM user
                               LEFT JOIN signature ON signature.signatureid=user.signatureid
                               LEFT JOIN customsignature ON customsignature.userid=user.userid 


Change to:

PHP Code:

                       avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,
                               signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature
                               FROM user
                               LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                               LEFT JOIN customavatar ON customavatar.userid=user.userid
                               LEFT JOIN signature ON signature.signatureid=user.signatureid
                               LEFT JOIN customsignature ON customsignature.userid=user.userid 


Satan

[Neo]

Nice job bro.

[Chris M]

Fanks

Hopefully it will be a Full Release before too long

Satan