vb.org Archive

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)

CRego3D 11-05-2002 02:34 AM

Quote:

Originally posted by mADmAX`
Not sure if this is right, but I noticed there was nothing in usercp.php with this so I added it. Right after I added it, it started working, so eitehr theres a step missing or I missed one.

PHP Code:

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

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

(Note the space in { imagesfolder}

PHP Code:

// ############################### start private messages ############################### 


I had t do the same to work :/

CRego3D 11-05-2002 04:30 AM

Suggestion:

how abbout adding a way for the users to tie a URL to the sigimage ?

Kars10 11-05-2002 07:43 AM

Quote:

Originally posted by CRego3D
Suggestion:

how abbout adding a way for the users to tie a URL to the sigimage ?

Yeah this could be very cool!! :)

Chris M 11-05-2002 03:05 PM

@Mini & Crego -

I had that planned for the next release;)

About the Usercp change

I had not tested this part, as it was an addon made by N9ne, who said it worked...

I shall add that code to the file this weekend:)

@Crego - Yes...I forgot to change that in the install file, but I shall at the weekend...That was part of a hack I had installed...

Satan

mADmAX` 11-05-2002 03:26 PM

Quote:

Originally posted by CRego3D


I had t do the same to work :/

What version of VB are you running? I am still running 2.27...

(Maybe from 2.27 - 2.28, something was changed where 2.27 users need to add that also)

N9ne 11-05-2002 03:28 PM

This is really weird, can someone tell me, is global.php hacked in this version 3? If it is it seemed to include the signature image globally for me, that's why the signature image does work for me in userCP :confused:

CRego3D 11-05-2002 04:05 PM

Quote:

Originally posted by mADmAX`


What version of VB are you running? I am still running 2.27...

(Maybe from 2.27 - 2.28, something was changed where 2.27 users need to add that also)

2.2.8 .. I woudl really liek to know why it needs that code .. it is working .. but still :p .. hehe

trying to get this to work, so we can used it on yaxay 2 .. hopefully we will be able to export it to our gallery/tuts as well :D

PennylessZ28 11-05-2002 10:14 PM

Here is the current problem I'm having, that I could use some help with. After I edited the member.php file, and I've followed it to the teeth 4 times now, I get the following error when I go to the user CP and click options >>

Quote:

Database error in vBulletin: 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: Tuesday 05th of November 2002 07:11:11 PM
Script: /forum/member.php?action=editoptions
Referer: http://www.hr3rdgen.org/forum/usercp.php?
I'm not sure what I can do to correct this problem or fix it. Anyone give some advice?

mADmAX` 11-05-2002 10:23 PM

PHP Code:

ALTER TABLE user ADD signatureid smallint(6NOT NULL 

Run that query as it seems you are missing that one.

Also make sure you ran all other queries in the queries.txt file.

Hope that helps...

PennylessZ28 11-05-2002 10:59 PM

Thank you, as that seems to have sovled my problem


All times are GMT. The time now is 08:55 AM.

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.01307 seconds
  • Memory Usage 1,744KB
  • 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_php_printable
  • (5)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