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)

Chris M 12-07-2002 09:50 PM

Hmmm...

You should try re-doing the queries;)

Perhaps it will correct the problem:)

If not, Im not quite sure whats wrong:confused:

Satan

Shadow_NL 12-08-2002 05:45 AM

LOL, I forgot to run this query:

ALTER TABLE user ADD signatureid smallint(6) NOT NULL

Heh thanks for the help.

Chris M 12-08-2002 12:20 PM

No problems:)

Glad you found the problem;)

Satan

Crazy Pete 12-09-2002 01:26 PM

hellsatan, I just noticed another problem. I have the dimension settings set at a max width of 468 and a max height of 200. Yet someone on my board managed to get a signature image that's 210 wide but 300 high. Any ideas why/how, or how to fix that? :) Thanks.

LangTuDaTinh 12-09-2002 06:04 PM

Quote:

Originally posted by Crazy Pete
hellsatan, I just noticed another problem. I have the dimension settings set at a max width of 468 and a max height of 200. Yet someone on my board managed to get a signature image that's 210 wide but 300 high. Any ideas why/how, or how to fix that? :) Thanks.
heheheh read my post above.... i have the same problem....

Chris M 12-12-2002 12:58 PM

@Crazy Pete - This seems to be a recurring problem, only experienced by some users...

Myself and a few other people have yet to be able to re-create this problem...

I shall see if I can find out what causes it;)

Satan

Crazy Pete 12-12-2002 02:10 PM

@hellsatan - Thanks!

Chris M 12-12-2002 02:32 PM

No problems:)

Satan

L-Mane 12-15-2002 03:41 AM

When I ran the fourth query I got this error

SQL-query :

INSERT INTO settinggroup (settinggroupid,title,displayorder) VALUES (103,'Signatures','27')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Enable Signatures','signatureenabled','1','Use this option to enable/disable the overall use of signature images.<br><br>Signature Images can be uploaded via the Admin Panel or the User Control Panel','yesno','1')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Minimum custom posts','signaturecustomposts','','Minimum number of posts that a user required before they can specify a custom signature image for use.','','2')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Allow uploads','signatureallowupload','1','Allow Signature Image uploads?','yesno','3')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Allow website uploads','signatureallowwebsite','1','Allow users to upload their signature image from another website?','yesno','4')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Maximum Image Width','signaturemaxwidth','400','Enter the maximum width value in pixels for a Signature image. Set this to 0 for no limit','','5')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Maximum Image Height','signaturemaxheight','','Enter the maximum height value in pixels for a Signature image. Set this to 0 for no limit','','5')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Display Height','numsignatureshigh','5','How many rows of signature images do you wish to display to the user when selecting a signature?','','7')

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,103,'Display Width','numsignatureswide'

MySQL said:
You have an error in your SQL syntax near 'INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,op' at line 2

anyone know the answer to this?

Crazy Pete 12-15-2002 03:49 AM

@ L-Mane, try those queries again, but instead of ending them each with just ), make sure they all end in );

That should do the trick.


All times are GMT. The time now is 07:24 PM.

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.01704 seconds
  • Memory Usage 1,740KB
  • 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
  • (1)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