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)
-   -   Support Forum Helper Hack v1.1 (https://vborg.vbsupport.ru/showthread.php?t=44109)

NuclioN 12-29-2002 03:36 PM

I wonder how Tim could place images before the postinginfo, how did you do this Tim (or someone else)?

The images don't show up here in showthread either.

attic 01-28-2003 06:36 PM

@ Nuclion:

Had the same problem.

I just copied the helpbutton template directly in the showthread template. Now it does show up!

Regards,

Hp

CSchulle 04-25-2003 08:54 PM

Thx a very fine hack.

Run fantastical on my 2.3.0g ;)

Gru?
CS

Sufian 05-03-2003 12:16 AM

I'm having some trouble getting those sql queries to work. I get a syntax error message for each:

Quote:

SQL-query : [Edit]

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'Help Forum\',\'HELPforum\',\'1\',\'The forumid of the forum that you want the Forum Help Option to avialable in. (to make available for multiple forums simply seperate each forumid with a comma!)\',\'\',\'15\')

MySQL said:

You have an error in your SQL syntax near '\'Help Forum\',\'HELPforum\',\'2\',\'The forumid of the forum that you want the ' at line 1
Quote:

SQL-query : [Edit]

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'User Question Answered\',\'HELPdone\',\'<i>[Answered]</i>&nbsp;\',\'The name of the prefix for thread where the user has been helped!\',\'\',\'16\')

MySQL said:

You have an error in your SQL syntax near '\'User Question Answered\',\'HELPdone\',\'<i>[Answered]</i>&nbsp;\',\'The name o' at line 1
Quote:

SQL-query : [Edit]

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'User Question Unanswered\',\'HELPundone\',\'<i>[Un-Answered]</i>&nbsp;\',\'The name of the prefix for the thread where the user is awaiting help!\',\'\',\'17\')

MySQL said:

You have an error in your SQL syntax near '\'User Question Unanswered\',\'HELPundone\',\'<i>[Un-Answered]</i>&nbsp;\',\'The' at line 1
Quote:

SQL-query : [Edit]

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorder) VALUES (NULL,9,\'Help Thread Status\',\'HELPopen\',\'0\',\'Close that particular thread once help is provided?\',\'yesno\',\'18\')

MySQL said:

You have an error in your SQL syntax near '\'Help Thread Status\',\'HELPopen\',\'0\',\'Close that particular thread once he' at line 1
Quote:

SQL-query : [Edit]

ALTER TABLE thread ADD helpoption smallint(6) NOT NULL DEFAULT \'0\'

MySQL said:

You have an error in your SQL syntax near '\'0\'' at line 1
Any help would be appreciated. I'm new when it comes to mysql so I don't really know what to do.

Hostc 05-26-2003 07:05 PM

Can't find the code


Code:

<td width="100%"><smallfont color="#EEEEFF" class="thtcolor"><b>Thread</b></smallfont></td>
Or

Code:

<td width="100%"><smallfont color="#EEEEFF"><b>$timezone</b></smallfont></td>
:(

ap0c 05-26-2003 10:48 PM

Quote:

Today at 04:05 PM Hostc said this in Post #55
Can't find the code


Code:

<td width="100%"><smallfont color="#EEEEFF" class="thtcolor"><b>Thread</b></smallfont></td>
Or

Code:

<td width="100%"><smallfont color="#EEEEFF"><b>$timezone</b></smallfont></td>
:(

search for $timezone and Thread</b> and it will turn up..


kind of glad people bumped this thread up,installed and working fine

xs1 05-27-2003 12:01 PM

INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'Help Forum','HELPforum','1','The forumid of the forum that you want the Forum Help Option to avialable in. (to make available for multiple forums simply seperate each forumid with a comma!)','','15')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'User Question Answered','HELPdone','<i>[Answered]</i>&nbsp;','The name of the prefix for thread where the user has been helped!','','16')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'User Question Unanswered','HELPundone','<i>[Un-Answered]</i>&nbsp;','The name of the prefix for the thread where the user is awaiting help!','','17')
INSERT INTO setting (settingid,settinggroupid,title,varname,value,desc ription,optioncode,displayorde r) VALUES (NULL,9,'Help Thread Status','HELPopen','0','Close that particular thread once help is provided?','yesno','18')
ALTER TABLE thread ADD helpoption smallint(6) NOT NULL DEFAULT '0'

got this error when i queried the above

Error

SQL-query :

INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (

NULL , 9, 'Help Forum', 'HELPforum', '1', 'The forumid of the forum that you want the Forum Help Option to avialable in. (to make available for multiple forums simply seperate each forumid with a comma!)', '', '15'
)
INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (
NULL , 9, 'User Question Answered', 'HELPdone', '<i>[Answered]</i>&nbsp;', 'The name of the prefix for thread where the user has been helped!', '', '16'
)
INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (
NULL , 9, 'User Question Unanswered', 'HELPundone', '<i>[Un-Answered]</i>&nbsp;', 'The name of the prefix for the thread where the user is awaiting help!', '', '17'
)
INSERT INTO setting( settingid, settinggroupid, title, varname, value, description, optioncode, displayorder )
VALUES (
NULL , 9, 'Help Thread Status', 'HELPopen', '0', 'Close that particular thread once help is provided?', 'yesno', '18'
)
ALTER TABLE thread ADD helpoption smallint( 6 ) NOT NULL DEFAULT '0'

MySQL said:

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO setting( settingid, settinggroupid, title, varname

xs1 06-02-2003 07:07 AM

installed somehow......but i dont find any options there :(

WEForums 06-02-2003 07:30 AM

Hmm... try creating it in your /admin/setting.php file. Run it in your browser and do the following steps:

Forum Display Options > click [add setting]
Title: Help Forum
Variable Name: HELPforum
Value 16
Description: The forumid of the forum that you want the Forum Help Option to avialable in. (to make available for multiple forums simply separate each forumid with a comma!)
Code to generate option:
Display Order: 15

----------------------------------------------------------------------

Forum Display Options > click [add setting]
Title: User Question Answered
Variable Name: HELPdone
Value: [Answered]
Description: The name of the prefix for thread where the user has been helped! (You may use HTML.)
Code to generate option:
Display Order: 16

---------------------------------------------------------------------

Forum Display Options > click [add setting]
Title: User Question Unanswered
Variable Name: HELPundone
Value: [Un-Answered]
Description: The name of the prefix for the thread where the user is awaiting help! (You may use HTML.)
Code to generate option:
Display Order: 17

-----------------------------------------------------------------------------

Forum Display Options > click [add setting]
Title: Help Thread Status
Variable Name: HELPopen
Value: 0
Description: Close that particular thread once help is provided?
Code to generate option: yesno
Display Order: 18

-----------------------------------------------------------

That should do it for you. They'll be in the vBulletin Options page.

xs1 06-02-2003 10:57 AM

wowowo really it worked now on the test forum....but a question if i need to intall on my orginal forum can i follow the same procudure or run mysql queries manually ?


All times are GMT. The time now is 02:34 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.01865 seconds
  • Memory Usage 1,758KB
  • 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
  • (6)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
  • (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