vb.org Archive - Signature Image System Hack

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Signature Image System Hack - Version 3.0+... (https://vborg.vbsupport.ru/showthread.php?t=45310)

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

These are the Screenshots:)

Satan

Wow im impressed, very very nice hack, ill be installing this asap, if any problems ill reply in here.

Cololies:)

There shouldnt be, as it has been tested by 4 seperate people, but holler if there is:)

Satan

Well it's still running flawlessly on my test board hellsatan, as you've already seen.

I can confirm this works with 2.2.8 if hacked in properly ;)

Yes...

N9ne's vB Test Board has been heavily hacked, and it works without troubles:)

Satan

When he says heavily hacked, it means I have 70 hacks installed ;)

I butchered the code with my butchers knife ;)

It's good to see a full release of this hack, I was very impressed with the beta versions, just afraid to install them. ;) But now I can, great work, and thanks. :)

Looks good hellsatan;) This will be great for me:)

Thank you:ninja:

Nice to see this go final hellsatan, a well written and usefull hack :D

Thanks:)

I am glad to see it go Final too, meaning that I am ready to think of upgrades;)

Satan

Thx a lot HS for this hack :)

Very nice Hellsatan, but I'm curious of 3 issues before considering installation.

#1. Does this add extra queries to showthread.php, and if so, how many?

#2. Is there a way to upload 1 signature image, then upload another--not replacing the first, but in order to have 2 signature images?

#3. It's just adding the signature image correct? So users who want to have text + a signature image can still do so by filling in the signature field?

awesome d00d 1 thing though can u add to it where a user gets to pick which sig then want to use in there posts like sig #1 or sig #2 in a drop down box or pick random so it picks a different one for each post :D

@velo & wolfe - Currently, it only supports 1 signature image...

@wolfe - The random image thing I could probably do, if I work out how to get 2 signatures in the database;)

@velo - Yes...You can still have a normal signature...I just thought that if you host people's images on your site, this way you can disable IMG code, remove their sig from your site, and they can store it in the database, only accessable by the sites you permit:)

And i think, but not confirmed, that It adds 2 queries to showthread.php, but I am sure someone else can confirm it:)

I shall investigate the 2 signature images thing, but I suspect that will cause a few problems as regards selecting them:ermm:

Satan

Mostly everything worked really well, but I got 2 problems:

1. In the edit options bit, the 'current avatar' image doesn't work anymore.

2. You have to have a current custom sig (from edit profile) for the sig image to show up :S

Other than them 2 probs, it works gr8

Ah yes...

With number 2, that is correct...

That is something both myself and N9ne neglected to mention...(N9ne modification;))...

Im not sure why the Avatar doesnt work any more...:ermm:

It works perfectly on everywhere else ive seen it installed...

The only thing I can suggest is that you re-check the code changes to functions.php & member.php...

Satan

Thank you :) I'll check through the files and hopefully fix it,

Is there anyway to change the current sig thing or get around it somehow?

Do you mean as in not enable signatures?

Sure...

Just remove the following from the "post_signature" template:

Code:

$post[signatureimg]

and add it to the postbit template, where you want it to appear;)

Then edit the postbit_signatureimg template, and remove the :

Code:

<br>

at the beginning...:)

Satan

I was thinking more of having both enabled, but making it so that if someone doesn't have a signature from edit profile, their signature image still works.

If thats not possible tho, thanx for the other option :) I'll prolly just use that instead, but my members do like having images and text in their sigs :)

-Freefall-

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

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. :)

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.

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...:confused:

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 ###############################

Anyway we can use this for flash signature images?

I tried a few things and it will not load:

< embed src=signaturexxxxxxx >

Have you tried the proper flash tag?:

Code:

<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>

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

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

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;

Quote:

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 :/

Suggestion:

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

Quote:

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!! :)

@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

Quote:

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)

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 :confused:

Quote:

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 :p .. 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 :D

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 >>

Quote:

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?

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...

Thank you, as that seems to have sovled my problem

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01656 seconds Memory Usage 1,908KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (8)bbcode_php_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: