vb.org Archive
Page 18 of 25 « First 81617 18 1920 Last »
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)

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


All times are GMT. The time now is 02:25 AM.
Page 18 of 25 « First 81617 18 1920 Last »
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.01531 seconds
  • Memory Usage 1,770KB
  • 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
  • (1)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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