Usercp Signature Preview

[Kinox]

vbhacker v1.0.2 file

*Usercp Signature*

- Limit limitations on register new user
- Limit limitations on usercp after user register
- Preview sig in usercp
- Limit lines in sig
- Limit images in sig
- Limit width
- Limit height

Enjoy

NOTE:
Limit width/height only works on .gif, .jpg, .jpeg, and so on... not on .txt, .php, .cgi, .html and so on... if user might use them in [img ] [/img ] tag...

Limits to limit extensions will come in future...

UPDATED October 3
Added signature.mass.delete.php - Add that to your /admin, and run it only if you want all signatures deleted, it will erase all signatures in your database if you want limits to be set on existing registered users...

LATEST VERSION DOWNLOAD:
https://vborg.vbsupport.ru/attachment.php?s=&postid=266936
-------------------------------------------------------------------------
Check out http://nekio.com.
Check out http://hololith.com - my personal website.

[Kinox]

UPDATED 10/03/02

[Sparkz]

Please include textfiles of your hacks too...

[Kinox]

screen2

[Lesane]

Your instructions says:

+-------------------------------------------------------------------------------------------------+
| Create a new template named "hl_signature_usercp" with this: |
+-------------------------------------------------------------------------------------------------+
<table cellpadding="0" cellspacing="0" border="0" bgcolor="#0A293E" width="100%" align="center"><tr><td>
<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr id="cat">
<td bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan="5" nowrap><normalfont color="#000000"><b>Signature Preview</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#1C5780" valign="top"><smallfont>
$previewsignature
</smallfont>
</td>
</tr>
</table>
</td></tr></table>
+-------------------------------------------------------------------------------------------------+ ;)

It's more &alt & & quot then real code :D

[Velocd]

Great hack Kinox! I love the signature limits on it. :)

The only suggestion I can make, a general miss by many hackers, is to make sure you include any custom templates into the $templatesused=''; list to prevent extra queries.

[Velocd]

Hmm..well, I just really installed it right now and I'm a bit confused on why you do this:

$userinfo=$DB_site-&(gt;query_first(&*quot;
SELECT signature
FROM user
WHERE userid=$bbuserid
LIMIT 1
");


You have &*quot (wo/asterik) codes in here and it's screwing up the thing, is there a reason you inserted this?

[Chris M]

He probably tried to do it with some sort of Web Dev package...

Satan

[Velocd]

That's my guess, it's alittle annoying to fix though...I'll try to post some instructions up without these HTML thingies..

[Chris M]

Cool thanks:)

Satan

[Velocd]

His VBHacker file is also quite corrupted towards the end, when you generate a text file that is. although it is minus the html codes..

[Velocd]

Ok! Here is a "working" version (attached). I'm not sure why the code was so screwed up, luckily in both the vbhacker and text he attached above the queries were not screwed up..interestingly enough...hopefully he didn't do this on purpose :lick:

[Floris]

hey
this is nice
fnx for sharing :)

[Chris M]

Lol...

Thanks Velo:)

Satan

[bonnmac]

Works Great! Thank you.

[Keta]

<---installing now...this should of been done a long time ago... lol

[Kinox]

yeah I seem to forget that...

Originally posted by Velocd
Great hack Kinox! I love the signature limits on it. :)

The only suggestion I can make, a general miss by many hackers, is to make sure you include any custom templates into the $templatesused=''; list to prevent extra queries.

[Mathiau]

great work, will try to put this in now!

[Bugz]

+-------------------------------------------------------------------------------------------------+
Create a new template named hl_signature_usercp
+-------------------------------------------------------------------------------------------------+
<table cellpadding="0" cellspacing="0" border="0" bgcolor="#0A293E" width="100%" align="center"><tr><td>
<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr id="cat">
<td bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan="5" nowrap><normalfont color="#000000"><b>Signature Preview</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#1C5780" valign="top"><smallfont>
$previewsignature
</smallfont>
</td>
</tr>
</table>
</td></tr></table>
+-------------------------------------------------------------------------------------------------+

and

+-------------------------------------------------------------------------------------------------+
Create a new template named hl_signature_usercpno
+-------------------------------------------------------------------------------------------------+
<table cellpadding="0" cellspacing="0" border="0" bgcolor="#0A293E" width="100%" align="center"><tr><td>
<table cellpadding="4" cellspacing="1" border="0" width="100%">
<tr id="cat">
<td bgcolor="#336D95" background="https://vborg.vbsupport.ru/images/catagory_backing.gif" colspan="5" nowrap><normalfont color="#000000"><b>Signature Preview</b></normalfont></td>
</tr>
<tr>
<td bgcolor="#1C5780" valign="top"><smallfont>
You have no signature at the moment.
</smallfont>
</td>
</tr>
</table>
</td></tr></table>
+-------------------------------------------------------------------------------------------------+

have it linking to vb.org what sould that be ?

[Smoothie]

Originally posted by Velocd
Great hack Kinox! I love the signature limits on it. :)

The only suggestion I can make, a general miss by many hackers, is to make sure you include any custom templates into the $templatesused=''; list to prevent extra queries. Can you tell me what to add and where? Need to reduce as many queries as possible. :)

[Smoothie]

BTW, excellent hack! And Velocd, thanks for the translation. :)

[tkeil69575]

Hi Kinox,
great hack, thank you!

I installed it this morning and the preview is working fine, but the limit checking of images and number of lines isnt. Any ideas what might be wrong.

i did create the error templates and the cp is showing up the limit settings, but its just not taking effect.

tina

ps. and yes i've double checked member.php

[Kinox]

look at the files in the ....+fix+.rar

<tr id="cat">
<td bgcolor="{ categorybackcolor }" colspan="5" nowrap><normalfont color="{ categoryfontcolor }"><b>Signature Preview</b></normalfont></td>
</tr>

Originally posted by Bugz
have it linking to vb.org what sould that be ?

[Kinox]

it works, I have tested it on vb 2.2.6...

please DL

..+fix+.rar

it has all the files needed, that includes .txt file... v1.1

Originally posted by tkeil69575
Hi Kinox,
great hack, thank you!

I installed it this morning and the preview is working fine, but the limit checking of images and number of lines isnt. Any ideas what might be wrong.

i did create the error templates and the cp is showing up the limit settings, but its just not taking effect.

tina

ps. and yes i've double checked member.php

[Smoothie]

Could you possibly zip that file? I can't open rar files.

[ForKmaN]

Yeha me either, I tried to open the rar but it was corrupt, zip would be nice please :)

[Kinox]

zip

[Kinox]

<font size="3">BTW dont use "Velocd" file, its wrong</font>

[Smoothie]

Originally posted by Kinox
BTW dont use "Velocd" file, its wrong I did, whats wrong with it?

[Kinox]

templates, file changes, mysql seems to look fine...

Originally posted by Smoothie
I did, whats wrong with it?

[Smoothie]

ok, cool. It works fine too :) Your 2 templates had the replacement variables, his didn't.

[Bugz]

Originally posted by Kinox
look at the files in the ....+fix+.rar

<tr id="cat">
<td bgcolor="{ categorybackcolor }" colspan="5" nowrap><normalfont color="{ categoryfontcolor }"><b>Signature Preview</b></normalfont></td>
</tr>




ok cool works perfect on 2.2.6



it'd be cool for this to be in 3.0

*:Clicks Install:*

[Smoothie]

I'm getting this error, but only from this user:Invalid SQL:
SELECT signature
FROM user
WHERE userid=
LIMIT 1

mysql error: You have an error in your SQL syntax near 'LIMIT 1
' at line 5

mysql error number: 1064

[Kinox]

its not my code... threre is no


SELECT signature
FROM user


querie...

[Smoothie]

I see it right in your install file:
In usercp.php, replace this code: // main page:With this code:// main page:

// ############################### start signature preview ###############################
// ?hololith.com (NanoEntity)
$userinfo=$DB_site->query_first("
SELECT signature
FROM user
WHERE userid=$bbuserid
LIMIT 1
");

if ($allowsmilies==1) {
$smiliesonoff=$ontext;
} else {
$smiliesonoff=$offtext;
}

if ($userinfo[signature]) {
// format signature
$signature=htmlspecialchars($userinfo[signature]);
$previewsignature=bbcodeparse($signature,0,$allows milies);

// display signature
eval("\$siglist = \"".gettemplate("hl_signature_usercp")."\";");
} else {
// no signature, display
eval("\$siglist = \"".gettemplate("hl_signature_usercpno")."\";");
}

[Kinox]

oh hehe, forgot... was 12am when I made that post, I was tired...

I will update the zip in few min...

[ForKmaN]

did you update it yet? :)

[Kinox]

yes its updated now, v1.2

post #1

[Bugz]

i dont get it..

whats updated ?.

i have no problems with it. is there anyway you could have a upgrade .txt ?

[Kinox]

I removed from usercp.php

$userinfo querie
and allowsmilies

and changed some vars in

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

+ updated html code to hl_signature_usercp, and hl_signature_usercpno

so it looks like in the screenshot

[ForKmaN]

Works good for me, but what happens to the sigs that are allready over the limit?

[Kinox]

nothing, when user updates there cp info, the limits will be set...

[ForKmaN]

ahh kool

Well worked a charm! Thanks! :)
And also thanks for vbhacker 1.0.2

[Kinox]

im trying to make the vbhacker + hackmaker to save files to its own directory like admin/hacks/

its in development... : )

[Illuvatar]

Hate to ask...

But we're gonna wait till 3.0 comes out before we upgrade.

Will this work in Version 2.2.5?
Thanks,
Illu

[Smoothie]

Good job on this Kinox! Works like a charm.

[Baptizer]

Hello, has anyone attempted this on 2.2.7? I think i am going too.......

[Smoothie]

Working fine in 2.2.7

[Baptizer]

Thanks smooothie!

[Illuvatar]

/me installs this most excellent hack and then runs around in circles!!

Whoo hoo!

My first time at running queries and it all went off without a hitch!!

Thanks Kinox!

Illu

[Ghostsuit]

Yup damn nice hack and works great on 2.2.7

[Kinox]

Thanks guys, i'm glad you are enjoying it :P

Dont have time to update, I have been working on http://gfxart.net

Grand Opening 01/01/03

[LightBringer]

Quick Question:

You say to do the following:

+-------------------------------------------------------------------------------------------------+
| In member.php, replace this code: |
+-------------------------------------------------------------------------------------------------+
include("./global.php");

if ($bbuserinfo[userid]==0 or $permissions['canmodifyprofile']==0) {
+-------------------------------------------------------------------------------------------------+

+-------------------------------------------------------------------------------------------------+
| With this code: |
+-------------------------------------------------------------------------------------------------+
$templatesused .= 'hl_signature_error_wh,hl_signature_error_long,hl_ signature_error_images';
include("./global.php");

if ($bbuserinfo[userid]==0 or $permissions['canmodifyprofile']==0) {
+-------------------------------------------------------------------------------------------------+


However, within member.php there are several locations of that code.
I'm curious as to what section it should be installed in.

[Kinox]

in

start update options
and
start update profile

[LightBringer]

Originally posted by Kinox
in

start update options
and
start update profile

Thank ya! :)

[L-Mane]

How do I know if this hack works?

[Koyske8000]

gohan was so happy when he saw this hack cause at his board, the people have like crap in there sig which annoys us admins... :D

[Kinox]

It dose work 100% from what I have tested L-Mane... :P

[LOD-squa]

It does work I tested it on my forums and works 100% and koys is right =P

[Exo]

my signatur editor doesn't work anymore? I get only a white page when i use it and click on save? please help!! :(

[L-Mane]

Well people still using banners larger then the size I put down :(

[Kinox]

Yes L-Mane, this hack dose not affect stored data in DB, only data that is being entered into DB...

What you have to do is remove there sig by hand, or ask them to remove it, then when thay try to enter new sig or update, the limits will be set, and thay will get errors if they enter wrong set limits...

If you want, I can write a simple script that will erase all signatures stored in your DB, so when thay try to reenter them again, limits will be set...

[Kinox]

Check Post #1, UPDATE October 3!

[L-Mane]

Originally posted by Kinox

If you want, I can write a simple script that will erase all signatures stored in your DB, so when thay try to reenter them again, limits will be set...

Will it be free? If so go for it :)

[Kinox]

Yes its free and you can download it from Post #1...

[L-Mane]

Ok people are still able to have pics bigger then what size I put.

I have it for 400 x 185 and people have pics that are wider then 400 :( what could be the problem

[Kinox]

where is your forum, and where is the sig that is bigger then 400?

threadid/link...

did you run signature.mass.delete.php and followed all the steps?

[L-Mane]

I sent you a PM since I don't want to keep replying back and forth in this thread.

[Kinox]

I tested the code in your forum and you forgot to add something in, recheck everything if you inserted it at the right places...

becouse


// ############################### start update profile ###############################
if ($HTTP_POST_VARS['action']=="updateprofile") {


has no changes made in member.php...

[L-Mane]

I have just about given up on this. I've been sitting here for hours trying to figure this out. Everything is fine except it detecting images that are too wide or big. :( cry time

[Mono]

Works like a charm. Thanks.

*Clicks install*

[Buddha]

excellent hack.
thanks.

*installed*

[Herman]

Kinox, why didn't u include credit for the image size control to me? After all, I made the first working one...

[Sadie Frost]

Is there a way to make the preview work with images in html instead of just with the img tags? :)

[Dynamic One]

Great Hack Kinox,

Thanks a lot :0)

[alekz]

Hi all,
anyone tried it with version 2.2.9?
does it work?

[spazeman]

works great thanks!!! just what i needed, sig images are a huge thing on my board. :)

[Glenn379]

I know this is somewhat old but I just installed, and Damn this is good. Great Job! I hope I get to make hacks like these ;) *install*

[Kinox]

yes it works for 2.2.9.. :P

[Molok]

Smilies are Counted as a Image.

Is it possible that Smilies will not be counted as a Image ?

[Kinox]

I dont think it can, as smilie is an image file type.

But I will see what I can do.

[sebastien69]

Ok i upgrade my forum in 2.2.9 and still have a bug with this hack

The signature doesnt appear just have the vbcode with the link in the preview

can you tell me what i do wrong

[Arie]

Hmm... it would be cool if you also could set the limit of characters per line, as this will still allow you to post huge sigs if you don't use a line break :(

[S1R1US]

in the last instricution sit has query's to run. How do I run a query?

[JimF]

Hi:

Can someone point me to the link with the most recent files for this hack? I want to be sure I'm using the right one.

-jim

[Kamakazy]

will this hack work for vB ver 2.3.0???

[Oblivion Knight]

Thankyou for this Kinox, it's just what I'm looking for.
I'm going to backup my database before I install this, and if everything runs ok, I'll click install at a later date.

- Oblivion.


[edit]
I haven't yet tested the limits that are implemented into the hack, but the preview is working fine. I'm running vBulletin version 2.3.0.

Thankyou very much. :)
* Oblivion Knight clicks install.

[kevinnguyen]

when i run the second query, i got this
Error

SQL-query :

INSERT INTO setting
VALUES ( 221, 302, 'Maximum images per signature?', 'maxsigimages', '5', 'Maximum number of *images* to allow in signatures. Set this to 0 to have no effect.', '', '2' )

MySQL said:


Duplicate entry '221' for key 1
wat can i do?
thanx

[Alien]

Can anyone confirm this hack working in 2.3.0 as well as the limitations?

I'd love to know. Thanks! :D

-Jason

[NanoEntity]

Yes it works for 2.3.0. also about Duplicate entry '221' for key 1

Just rename 221 to NULL

INSERT INTO setting
VALUES ( NULL, 302, 'Maximum images per signature?', 'maxsigimages', '5', 'Maximum number of *images* to allow in signatures. Set this to 0 to have no effect.', '', '2' )

[Alien]

Thanks for the info, I'll give it a whirl today!

-Jason

[Alien]

In mine, it seemed to add properly using 221, do I need to change 221 to NULL for this to function properly?

Just wanted to know if it was just changed to NULL for those who have a duplicate entry!

Thanks. :D

[Oblivion Knight]

No, you don't need to change 221 to NULL.
It was only changed for those that had a duplicate entry :)

Are there any plans in the future to allow admins (and possibly megamods) to get past the limits that are set?

[Beth]

Hello,

This is the first I've tried.

I got this

"Parse error: parse error in /home/mysite/mysite/test/usercp.php on line 358"

Can someone help as I'm all new to this ?

[Illuvatar]

I've got to agree with Arie......

I've been wondering how folks on my boards were getting around this hack, and it must be that they put in a paragraph or sumsuch without line breaks.

Has anyone been able to modify this hack to compensate? Maybe a character restriction as well?

<fingers crossed>

[S.Shady]

i was wondering how do uninstall it. i can do the file edits but i would like to undo the querys. how whould i do that ?

its a nice hack and worked perfect on 2.3.0 but we no longer need it.

[L-Mane]

Peeps still find a way round the hack by putting www. in the link.

[subu1]

hey Friends, in my 2.2.8

search in Member.php for:

include("./global.php");
if ($bbuserinfo[userid]==0 or $permissions['canmodifyprofile']==0) {


change to

$templatesused .= 'hl_signature_error_wh,hl_signature_error_long,hl_ signature_error_images';
include("./global.php");

if ($bbuserinfo[userid]==0 or $permissions['canmodifyprofile']==0) {

i have it on line 452

// ############################### start update profile ###############################
if ($HTTP_POST_VARS['action']=="updateprofile") {
$templatesused = 'redirect_updatethanks,error_fieldmissing,error_em ailmismatch,error_emailtaken,error_fieldmissing,er ror_requiredfieldmissing,error_birthdayfield';
include("./global.php");
if ($bbuserinfo[userid]==0 or $permissions['canmodifyprofile']==0) {
show_nopermission();
}

and 715

// ############################### start modify options ###############################
if ($action=="editoptions") {
$templatesused = 'modifyoptions_maxposts,modifyoptions_styleset,mod ifyoptions_stylecell,usercpnav,modifyoptions';
include("./global.php");
// do modify profile form

if ($bbuserinfo[userid]==0 or $permissions['canmodifyprofile']==0) {

and 996

// ############################### start update options ###############################
if ($HTTP_POST_VARS['action']=="updateoptions") {
$templatesused = 'redirect_updatethanks';
include("./global.php");

if ($bbuserinfo[userid]==0 or $permissions['canmodifyprofile']==0) {
show_nopermission();
}

wich line must be change :rolleyes: :banana: :banana: :rambo:

thxxx for help :bunny:

[wyzzor]

Thanks. :) god job

[Kwesi]

Hoe do i Run the Query? im sorry.. im just a big newb

[tmapm]

When I edit my profile my signature isn't there.. Does anyone know what the cause of this could be?

Kwesi: You can do it in phpmysqladmin if you have it.

Or in another hack they did it with a file. Create a php file, put this in it. Run it, Then delete it:


<?php
error_reporting(7);


require('./global.php');

$q1="INSERT INTO settinggroup VALUES (302,'[HL]Signature Settings',302)";
$q2="INSERT INTO setting VALUES (320,302,'Maximum signature lines?', 'maxsiglines', '5', 'Maximum number of *line breaks* allowed in signatures. Set this to 0 to have no effect.', '', '1')";
$q3="INSERT INTO setting VALUES (221,302,'Maximum images per signature?', 'maxsigimages','5' , 'Maximum number of *images* to allow in signatures. Set this to 0 to have no effect.','', '2')";
$q4="INSERT INTO setting VALUES (322,302,'Maximum image width?', 'maxsigwidth','450','Maximum *width* allowed for images in signatures. Set this to 0 to have no effect.', '', '3')";
$q5="INSERT INTO setting VALUES (323,302,'Maximum image height?', 'maxsigheight','125','Maximum *height* allowed for images in signatures. Set this to 0 to have no effect.', '', '4')";
$q6="UPDATE setting SET title='Maximum images per post?' WHERE settingid='18'";
$q7="UPDATE setting SET description='Maximum number of images to allow in posts. Set this to 0 to have no effect.' WHERE settingid='18'";

$DB_site->query($q1);
$DB_site->query($q2);
$DB_site->query($q3);
$DB_site->query($q4);
$DB_site->query($q5);
$DB_site->query($q6);
$DB_site->query($q7);

echo "Success! DELETE THIS FILE IMMEDIATELY!";

?>

[WEForums]

I don't really understand. I have installed this hack and afterwards members complained. They claim they get a "WEForums database error." When they copy, there is no error there that needs to be fixed. While this only occured on a few (maybe 5% of the users), I removed the hack, and they are saying it works. They claim to be using IE6...so what would cause this?

[NanoEntity]

I have this installed on 2.3.0, and it works as it should, no problems... ;)

http://nekio.com

[TheLab]

I have a veryyyyyyy strange problem. The hack works GREAT! The limits i have give is 450x80 and it works fine. EXCEPT! One user.. who has his signature in his own site and he links the pic without problem. The pic is 450x100. I have tried to use it too and it let me use it!! Now the more strange thing.. when i upload it to my site..and try to link it doesnt work.. it says its off limit. So i can only think that is some problem with the users domain. Any ideas?

[TheLab]

Also one more thing i would like to ask. Is there any way to check the size of the signature?

[SEShady]

What do I do with the 2 files that came with the original install zip? The INSTALL file doesn't specify. Or I am just overlooking something.

Thanks,
Shady

[msimplay]

will this hack be updated for vb3 its much needed