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)

marocnl 10-04-2002 02:25 PM

Parse error: parse error, expecting `']''

in showthread.php i got this error............anybody any idea?

It works great, just this issue.

marocnl 10-04-2002 02:34 PM

FIXED!

No, i'm not just bumping this great hack :D

Tim Wheatley 10-04-2002 05:47 PM

Quote:

Originally posted by g-force2k2
Tim not really sure... looked at your coding didn't see any clashes... pm me your forumdisplay.php and i'll take a look for you ;) regards...

g-force22

I'll send showthread too because it's not working right in there too... Thank you. :)

squawell 10-05-2002 09:11 AM

g-force22 see attach file that is my problem...

i download ur new install file...

and another problem i already install ""cumston prefix"" this hack

after i installed urs and it cannt work...so can u fix that??

Matt 10-05-2002 07:45 PM

How do I make it so that threads that are stuck in the forum don't have this other sticky please?

Tim Wheatley 10-06-2002 12:41 PM

Quote:

Originally posted by Tim Wheatley


I'll send showthread too because it's not working right in there too... Thank you. :)

I see you're away at the moment g-force2k2, I hope all is ok...

You fixed my forumdisplay problem, but it still does not work in showthread. It does not show the links where I can make the thread answered.

I sent you a PM, please let me know if you need me to send showthread.php.

Many Thanks!

Tim

g-force2k2 10-08-2002 08:08 PM

yeah sorry im didn't realize you were having an issue with the showthread.php file i sent you the fixed file... let me know what happens.. (hopefully i attached the file) sorry about the misunderstanding... regards...

g-force2k2

Tim Wheatley 10-09-2002 06:33 PM

It didn't attach unfortunately. :D

Could you be so kind to resend?

Thank you. :)

Graphics 12-27-2002 07:46 PM

Looks like good stuff, I'll install it tomorrow morning as I'm too tired right now... :p

Graphics 12-29-2002 12:22 PM

OK I installed it, but none of the stuff shows. In the query I put forumid '6,7'. (Without quotes) Should I have put '6 , 7'?

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 ?

WEForums 06-02-2003 11:26 AM

I would do whatever steps you did on the test forum since it worked. If it works once, it should work twice.

Matt 08-07-2003 02:25 AM

Quote:

10-05-02 at 09:45 PM Matt said this in Post #45
How do I make it so that threads that are stuck in the forum don't have this other sticky please?
Anyone?

DaQuixlet 08-07-2003 09:28 PM

How do you run a query?

Kane Da Don 11-04-2003 09:42 AM

i love this hack but i was wondering if any one could help me out on telling me wat i need to do so i can add more options to it like a drop down menu and more selection instead of the "answered" and "unanswered" ones like "repeated question" , "More Help" something like that

wolfman 01-16-2004 08:25 PM

any plans for a vb3 version of this?

g-force2k2 01-16-2004 11:11 PM

Me! make sure that you did not block out the line afterwards.

PHP Code:

$DB_site->insert_id(); 

If not post the code around my code and I will see what I can do.

Wolfman I will work on a port to vb3.

Cheers,
g-force2k2

rodrigoke 03-18-2004 12:39 PM

$helpoption = iif($foruminfo[forumid] == $HELPforum,'0','');

shouldn't this be
$helpoption = iif($foruminfo[forumid] == $HELPforum,'0','1');
to set if the thread is specified?

anyway i can't make it to work...
it doesn't show up...
i'll have a look later

rodrigoke 03-18-2004 01:00 PM

the vars
$HELPforum
$HELPundone
$HELPdone
(which come from the db table setting)

aren't available in forumdisplay.php
that's why the prefix isn't shown....
the rest works

how can we make them available?

rodrigoke 03-18-2004 01:21 PM

ok you have to go to the control panel and save your vbulletin options :)
that way the new setting is loaded :)

rodrigoke 03-18-2004 01:39 PM

one last thing:
Note: If you want to add an image (button) instead of the word link simply replace '[ Thread Helped ]' with:
<a href='{imagesfolder}/image_name_here.gif' border='0' alt='Thread has been helped!'>
Replace 'image_name_here' with the image file name and place the image in your images folder!

the "<a href" needs to be an "<img" tag

<img src="{imagesfolder}/image_name_here.gif" border="0" alt="Thread has been helped!">

JGM007 06-29-2004 03:21 PM

Quote:

Originally Posted by g-force2k2
Wolfman I will work on a port to vb3.

g-force2k2


Hi g-force2k2,
I was currious if you were still thinking about porting this to VB3? I am working to move my community over, and I really liked having this hack in VB2 in my help forum, and I would like to use it in VB3 because I think it is that good of a hack :-)

Thanks!

-JGM

Eagle Creek 02-28-2005 10:22 PM

Quote:

Originally Posted by JGM007
Hi g-force2k2,
I was currious if you were still thinking about porting this to VB3? I am working to move my community over, and I really liked having this hack in VB2 in my help forum, and I would like to use it in VB3 because I think it is that good of a hack :-)

Thanks!

-JGM

This hack is great but is there a version for vB 3.0.7?

And can you replace the text by icons?

Alphawolf83 10-21-2005 09:05 PM

Quote:

Originally Posted by Eagle Creek
This hack is great but is there a version for vB 3.0.7?

And can you replace the text by icons?

*push* Is there any "conversion" of this hack for the 3.0.x yet?


All times are GMT. The time now is 05:54 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.01383 seconds
  • Memory Usage 1,822KB
  • 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
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (33)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