Support Forum Helper Hack v1.1

Download the latest version (v1.1)[ Here ]

As requested [ Here ] by z3comp...

Well here's my first hack for vb2.2.8 thought you'd never see me again right? (joking )

Instructions in the Installation.php file attached below... open in a text editor

What does this hack do?
// +++++++++++++++++++++
* Allows you to specify a help forum in which users can decipher which threads have been helped and vice-versa
* Allows for specifically Administrators, Smods, Moderators, and the user that created the thread to confirm that help has been given
* Customizeable Prefixes (vbulletin options)
* Option to close thread upon help being recieved!

What to do?
// +++++++++++++++++++++
Queries to Run (5) **
File Modification (6)
forumdisplay.php (2)
newthread.php (1)
postings.php (1)
showthread.php (2)
Template Edits (2)
Templates to Add (3)
** runs no extra queries

This hack has been tested on vbulletin 2.2.7 & 2.2.8
If you like this hack i would be greatful if you click [ Install ] and gave some feedback about difficulties and what not thanks in advance!

Screenshots Below...

g-force2k2

[NuclioN]

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]

@ Nuclion:

Had the same problem.

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

Regards,

Hp

[CSchulle]

Thx a very fine hack.

Run fantastical on my 2.3.0g

Gru?
CS

[Sufian]

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

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

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

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

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

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.

Can't find the code

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

Or

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

[ap0c]

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

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

Or

<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]

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]

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

[WEForums]

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]

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 ?