Hmmm...

Im not really sure what you want - :confused:

Do you want either:
1.) Users can only have Signature Images
OR
2.) Users can have both, but only editable on the "Edit Signature" screen
OR
3.) None of the Above

?:)

Satan

#2 would be ideal. They could have only text, or text/image, or only image, but only editable on the "Edit Signature" screen.

That's the way I think it should work.

Right:)

I will see what I can do:) - I might not get it done though;)

Satan

ok i figured out the some posts missing sigs thing..it was a quick reply issue...

/me smacks forehead again...

so i guess we're down to the two problems

1. no text sigs in the new hack, imageless sigs

2. sigs put in by admin cp do not show up in the usercp (this is a biggy in an imperfect world)

3. no sig barrier (the white line) in sigs put in by usercp once you make the postbit template correction to correct the big fat "0" you get by resetting user sigs in php...i mean, you can insert one, but then sigs inserted by admin cp will have two...

oh, thats three problems

also, way to support satan. thanks alot for your help and hack...mucho gracias

Im not sure why number 2 is happening:confused:

I dont think that is related to this hack:)

Satan

i think it is..at least, its related to something the hack doesnt do...

if you manually put in the sig in the admin cp by editing the profile, it doesnt register with the hack, meaning it isnt uploaded to the system and displayed in the usercp...if the hack interracted with the existing admin functions for adding sigs, wouldnt that be resolved? just a simple check to the db for images when you load the usercp or something...if i was a hax0r id work it out myself...unfortunately, im sort of dumb..

I see...

What you mean is that if you add a Sig Image via the Admin CP, it doesnt show in the UserCP...

Unfortunately, it wasnt part of the original hack:( - N9ne coded the template modification, and someone else did the usercp.php modification - I would have to take a look at the usercp modification to get it to work properly:)

Satan

yup thats it...thanks for having alook.

also, where would i look to change the image path to clear.gif...cant seem to find it...

The styles:)

Admin CP:)

Satan

the styles?

you mean templates? no matter what I do the path to the image remains http://images/clear.gif without the proper branching for my forum. did i miss something, you think?

You have to modify the styles in the "images path" section...

Also make sure you have the "Bulletin Board Url" section filled in:)

Satan

i do. i've got both of those filled out. doyou mean the url info in the signature.php...if so im pretty sure i have that done as well...my board is http://ladder.iglnet.com/forums if youd like to have a look.

Hmmm...

Im not sure whats wrong then:confused:

Satan

me neither, but its driving me nuts!! haha one little thing and ill be done

the problem seems to be that its looking for http://images/clear.gif instead of just images/clear.gif...but im not sure where to look to change that..its not in the templates, i dont think

found it. it was in usercp.php

the section beginning

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

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

needed to be replaced with this:

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

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

where "images" = {"imagesfolder"} without "" (this board wont let me type in the exact code.

I see:)

Thank you for that;)

I will update the file:)

Satan

Thanks for the hack, but I got an error.

When I go to my user cp it gives this error:

Database error in vBulletin 2.2.8:

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: Sunday 08th of December 2002 12:36:53 AM
Script: http://localhost/public/test/forum/p...um/usercp.php?
Referer: http://localhost/public/test/forum/s...php?postid=101

What did I do wrong? I followed all the instructions..

Thanks in advance.

Have you made sure that you ran the MySQL Queries?

Satan

Wow fast responce, I'm pretty sure I've added them all. Any idea what I could do? Add them again or so?

Thanks in advance.

Hmmm...

You should try re-doing the queries;)

Perhaps it will correct the problem:)

If not, Im not quite sure whats wrong:confused:

Satan

LOL, I forgot to run this query:

ALTER TABLE user ADD signatureid smallint(6) NOT NULL

Heh thanks for the help.

No problems:)

Glad you found the problem;)

Satan

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

@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

@hellsatan - Thanks!

No problems:)

Satan

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?

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

They are really meant to be run seperately:)

If you do as Crazy Pete suggested, it should work:)

@Crazy Pete - No luck yet:( Still looking;)

Satan

I got it

You got what?

Satan

I think he means he got the queries to work correctly?

Perhaps:)

Sorry Pete - Still no luck yet:(

I won't be able to look over the next day (machine getting killed and re-installed again):(

Satan

Yeah I got them to work. How would I go about uninstalling the queries because we got some issues going on and I want to make sure that it isn't something I did.

Er...

For the Queries you ran, just change the "ADD" to "DROP", and remove anything after the row name;)

i.e. ALTER TABLE user DROP sigimage
(or whatever it was - i forget:p)

Satan

I think I've found the Fix for the Height/Width issue - Apparently sometimes you couldn't restrict the height or width, and I think this is the fix:

In root/member.php find:

Replace with:
:)

Satan

I have the same problem here! All installed ok, I can upload images and they show up in usercp, but nothing shows up in the posts... I have a ordinary textsignature from before. Care to answer hellsatan?

This is a very nice hack..