The Arcive of Official vBulletin Modifications Site.

Signature Image System Hack - Version 3.0+... · **Released**: 11-01-2002

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

Kevorkian · #**172** 01-13-2003, 03:03 PM

how i can delete all querys of this hack from my database? some one can post me a killer query?

arka)Dream · #**173** 01-15-2003, 07:43 PM

I get this error when I try to open a thread:

PHP Code:


			
Database error in vBulletin 2.2.9:



Invalid SQL: 

SELECT

post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,

attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter

,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline

,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline

,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline

FROM post

LEFT JOIN icon ON icon.iconid=post.iconid

LEFT JOIN user ON user.userid=post.userid

LEFT JOIN userfield ON userfield.userid=user.userid

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

                       LEFT JOIN signature ON signature.signatureid=user.signatureid

                           LEFT JOIN customsignature ON customsignature.userid=user.userid

LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid

WHERE post.postid IN (0,202,245,252)

ORDER BY dateline 



mysql error: Not unique table/alias: 'signature'



mysql error number: 1066



Date: Wednesday 15th of January 2003 01:14:15 PM

Script: [url]http://www.eo-gaming.com/forum/forum/showthread.php?threadid=50[/url]

Referer: [url]http://www.eo-gaming.com/forum/forumdisplay.php?forumid=12[/url]

Also, the signature options aren't displaying when I go to "Edit Profile" ... Can anyone help me out?

Chris M · #**174** 01-17-2003, 04:50 PM

The Signature Options will show in the "Edit Options" screen, and that is because you have incorrectly edited the file...

You have inserted 2 sets of the edited data

Code:

,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline
,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline

^ Duplicate lines (delete one)

Code:

                       LEFT JOIN customavatar ON customavatar.userid=user.userid
                       LEFT JOIN signature ON signature.signatureid=user.signatureid
                       LEFT JOIN customsignature ON customsignature.userid=user.userid
                       LEFT JOIN signature ON signature.signatureid=user.signatureid

^Duplicate line sets (delete one set)

Satan

arka)Dream · #**175** 01-18-2003, 01:21 AM

Nope. I still get an error...

Code:

Database error in vBulletin 2.2.9:

Invalid SQL: 
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,icon.title as icontitle,icon.iconpath,
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
,avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline
,signature.signaturepath,NOT ISNULL(customsignature.signaturedata) AS hascustomsignature,customsignature.dateline AS signaturedateline

LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
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
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE post.postid IN (0,394,395,429)
ORDER BY dateline 

mysql error: You have an error in your SQL syntax near 'LEFT JOIN icon ON icon.iconid=post.iconid
LEFT JOIN user ON user.userid=post.use' at line 8

mysql error number: 1064

Date: Friday 17th of January 2003 07:16:14 PM
Script: http://www.eo-gaming.com/forum/forum...hp?threadid=78
Referer: http://www.eo-gaming.com/forum/forum....php?forumid=4

Chris M · #**176** 01-18-2003, 01:24 PM

That isn't a fault caused by this hack...

Satan

S1R1US · #**177** 01-31-2003, 03:51 AM

Does this hack have the ability to limit the size of an image in a sig and/or the amount of characters used?

Chris M · #**178** 01-31-2003, 05:13 PM

This only has the ability to limit the size of the uploaded Signature image, either by pixel size, or file size, and will only allow images within the upload limit to be shown...

Satan

Dado · #**179** 01-31-2003, 08:22 PM

any idea why I am getting this error?

Quote:

Parse error: parse error in /usr/local/www/www.dtmpower.net/forum/member.php on line 818

Chris M · #**180** 01-31-2003, 08:26 PM

Could you post the lines surrounding and including line 818 from member.php?

Satan

Dado · #**181** 01-31-2003, 08:33 PM

Here you go

Quote:

// draw cp nav bar
$cpnav[1]="{secondaltcolor}";
$cpnav[2]="{secondaltcolor}";
$cpnav[3]="{firstaltcolor}";
$cpmenu[3]="class=\"fjsel\" selected";
$cpnav[4]="{secondaltcolor}";
$cpnav[5]="{secondaltcolor}";
$cpnav[6]="{secondaltcolor}";
$cpnav[7]="{secondaltcolor}";
eval("\$cpnav = \"".gettemplate("usercpnav")."\";");

eval("dooutput(\"".gettemplate("modifyoptions")."\ ");");
}

// ############################### 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();
}

$adminemail=iif($allowmail=="yes",1,0);
$emailnotification=iif($emailnotification=="yes",1 ,0);
$options=iif($showsignatures=="yes",1,0);
$options+=iif($showavatars=="yes",2,0);
$options+=iif($showimages=="yes",4,0);
$options+=iif($vbcode=="yes",8,0);
$showemail=iif($showemail=="yes",1,0);
$invisible=iif($invisible=="yes",1,0);
$cookieuser=iif($cookieuser=="yes",1,0);
$nosessionhash=iif($nosessionhash=="yes",1,0);
$receivepm=iif($receivepm=="yes",1,0);
$emailonpm=iif($emailonpm=="yes",1,0);
$pmpopup=iif($pmpopup=="yes",1,0);
$allowrate=iif($allowrate=="yes",1,0);

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.18828 seconds Memory Usage 2,343KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (3)bbcode_code (1)bbcode_php (2)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!