vb.org Archive
Page 5 of 7 « First 34 5 67
Show 40 post(s) from this thread on one page

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)

Chris M 01-02-2003 09:06 AM
I don't know why it isn't showing up:bored::(

Satan

partang2 01-02-2003 09:16 AM
Quote:
Originally posted by hellsatan
I don't know why it isn't showing up:bored::(

Satan

Well, at least it was a honest answer.... :( Think I will keep it installed.... Maybe someone will find the answer to this problem soon....

Chris M 01-02-2003 12:34 PM
I will keep searching:(

Satan

partang2 01-02-2003 12:37 PM
Thanx m8! :)

LangTuDaTinh 01-06-2003 01:11 AM
if user don't have custom sig then this sig image will not display in postbit. is there a way to bypass this.

thanks
thanks for your fix on height.

LangTuDaTinh 01-06-2003 01:24 AM
no need, found a way to do it....thanks anyway.

Chris M 01-08-2003 05:34 PM
Could you telll how you found out?:)

Satan

VAN 01-12-2003 08:56 AM
Nevermind. :D staring at code for 8 hours causes one to make silly mistakes.

Great hack, bud, though your docs could use some polish. ;)

Chris M 01-12-2003 12:52 PM
Yeh...I didn't have much time to create proper ones:bored:

I will some day soon:D

Satan

Kevorkian 01-13-2003 02:46 PM
satan please i have a big problem with your hack contact me by mail :(

Kevorkian 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 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 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 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 01-18-2003 01:24 PM
That isn't a fault caused by this hack...:(

Satan

S1R1US 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 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 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 01-31-2003 08:26 PM
Could you post the lines surrounding and including line 818 from member.php?:)

Satan

Dado 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);

Chris M 01-31-2003 08:55 PM
This is what I have...

Code:
// 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);
Try replacing your code with mine...:)

Satan

Dado 01-31-2003 10:29 PM
same error :(

Chris M 02-01-2003 12:13 PM
Hmm...

I'm not sure...Perhaps someone else can help?:confused:

Satan

Xelation 02-02-2003 06:47 PM
WOW!!! THATS A TON OF CODE TO ADD! lol expected time 10-15 mins... took me more than an hour....

never the less.. GREAT HACK!!! I installed without any problems at all :)

S1R1US 02-06-2003 10:39 PM
Quote:
Originally posted by hellsatan
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
oh okay. Thanks for the response. Maybe have a feature that limits it globally instead of just uploaded images.

Chris M 02-08-2003 01:06 PM
Well...I am not totally sure, but I believe Herman/Herman Nation's (cant remember his username) Signature Limit hack may be what you are looking for;)

@Xelation - Good news:) Hmmm....an hour eh:p I know it took me a little while longer than the estimated time...Ah well - Will update it eventually:p

:)

Satan

Preech 02-09-2003 06:59 PM
ummm i dont have any of the code in my member.php your instructions say to look for. any suggestions?

S1R1US 02-10-2003 02:03 AM
if someone says

run the install file in admin cp? that will add the necessary tables...

how do i do that?

Chris M 02-14-2003 06:22 PM
@S1R1US - Upload the file to your /admin/ directory...

Then call that file via http://www.yoursite.tld/path-to-forum/admin/file.php:)

Satan

S1R1US 02-21-2003 03:53 PM
thanks, that worked. Now at the end of the instructions there are query's to do. I've looked everywhere in the adminCP and see nowhere to do a query. What is it, how can i do it, and where.

Chris M 02-21-2003 06:46 PM
You can either do it via PhpMyAdmin, or download the "SQL Query" hack by FireFly...

Satan

darkmaninc 02-27-2003 05:26 PM
hellsatan i went back and unstalled all queries and everything i had this hack installed before with 2.2.8 i upgraded a few days ago to vbulletin 2.3.0 and when going through most of the steps were the same i ran upon something somewhere i can't recall that was no longer in one of the files now i can't figure out how to get this working think ya can help me out ?

Chris M 03-02-2003 06:00 PM
Could you post waht this difference is perhaps?

I'm not too sure about whether it will work for vB2.3.0...

Satan

L-Mane 03-02-2003 09:00 PM
Yeah I tried this on 2.30 and ran into problems on functions so how will I go about uninstalling these queries?

S1R1US 03-03-2003 01:29 PM
is there phpadmin or mysql hack for 2.2.9?

Xelation 04-17-2003 05:20 PM
This hack does work for 2.3.0! Im running it on my forum with no problems at all! Great hack hellsatan!

ryancooper 04-19-2003 10:48 PM
Clip posted in wrong forum! LOL

Gemini 04-20-2003 12:20 AM
Rather than looking through all the posts, can this hack be installed via the vbhacker hack?

C.Birch 04-20-2003 07:55 PM
i have a prob and that is i can upload a sign but it will not show up in my posts.

212rikanmofo 04-20-2003 08:31 PM
i cannot find this in my member.php file

$signaturechecked[$bbuserinfo[signatureid]]="checked";

im using 2.3.0, please help...


All times are GMT. The time now is 04:40 PM.
Page 5 of 7 « First 34 5 67
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02049 seconds
  • Memory Usage 1,842KB
  • 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
  • (4)bbcode_code_printable
  • (1)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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