HelpDesk v1.63

Feature Request...

If you're interested in requesting a feature please use the form on this page:
http://www.hackvb.com/helpdesk.php

Description:
This is a ticket support system. Your members can now open up tickets rather than email you all the time.

Features

• No File Edits!
• Ability to turn the HelpDesk off.
• Ability to turn the New Ticket option off.
• Automated Response to users when tickets are submitted by email or private message.
• Ability to select which usergroups have access to creating Departments and managing the other usergroup's HelpDesk settings.
• Departments / Ticket Categories.
• Limit usergroups to handle certain department tickets.
• Limit usergroups by the following actions: new tickets, edit tickets, delete tickets, resolve / unresolve tickets, claim/unclaim ownership of tickets.
• New Tickets since last visit to forums.
• New Replies since last visit to forums.
• Unresolved / Resolved Tickets.
• WYSIWYG Editor for replies.

No File Edits!
When upgrading your forums there will be no problems. This will not give you any headaches because it almost runs separate of vBulletin..

1 Template Modification
This only has one template modification and that is to the navbar if you want a link there.

How-tos:
Giving Access to the Departments and Usergroup Settings
Usergroup Settings
Managing Departments

Installed?
Please click install if you install so you get notifications of all the latest bug fixes and feature addons.


Bug Fixes / Feature Additions:
v1.00 - Initial Release
v1.01 - Added template caching for a slight performance increase. Thanks to: princeton
v1.02 - Install script updated to create databases with table prefixes. Also added the ability to select which usergroups have access to the administer options.
v1.03 - Uninstall section added to the install script.
v1.50 - Ton of features added. Will update this with a link to the post where I named all the features added.
v1.51 - Bug fix. This fixes the problem with sending PMs for the auto responder.
v1.52 - Bug fix. This fixes the problem where the creator of tickets cannot reply to the ticket and a cosmetic fix to the installer.
v1.53 - Bug fixes. Fixes the problem with the PM pop-up, database errors for some people and the delete errors.
v1.54 - Bug fixes. Fixes the problem with the install script with one table.
v1.55 - Bug fixes. Fixes the problem with the Usergroup Settings page loading half the way down the page in IE.
v1.60 - Bug fixes. Fixes the security hole pointed out by xYarub. This also adds the send a new PM on ticket update feature.
v1.61 - Bug fixes.
v1.62 - Parse error fix.
v1.63 - Really fixed the permission errors.

Donations:
Hacks like these takes up enormous amounts of time and energy. This hack is entirely free to use. Please help me, help the vBulletin community by donating. Donations will keep me releasing hacks for free rather than doing custom work. A donation of any amount is much appreciated! Tell me this hack isn't work a couple bucks?

[MissKalunji]

Originally Posted by WhSox21

I'm planning on developing this hack into a plugin as soon as vB3.5 is released. What do you guys think of making it more like vBulletin's bug reporting system.

Although this hack will no longer be supported on vBulletin.org it will be supported on vBulletinplugins.com once I release it.

I'll be looking for more feedback in the coming (couple) week(s). Keep in mind this hack will stay free although it may change a little.

vbplugins!?!?!

i cant wait!!

[Stachel]

In pictures,


From doing:

In template HELPDESK_SHELL, added below $navbar


.
.
.
$header
$navbar

<!-- FAQ template guts addition -->

inserted here all contents of FAQ template
(except the $navbar and above or $footer and below because it's already in this HELPDESK_SHELL template)

<!-- end FAQ template guts addition -->

<!-- table to support left column nav -->
.
.
.


Any ideas for how to get to the goal of the contents of FAQ.PHP always being on top?
Stachel

[WhSox21]

First off. You will need to add the FAQ phrases to the phrasegroups array by adding this to the end of the array:
, 'fronthelp'

So it should look like this:
$phrasegroups = array('posting', 'search', 'fronthelp');

That will at least get you the phrases on that page.

That will probably only add the search fields. You will then have to include the required php file in the helpdesk along with the php code to pull the FAQ info out of the database. If you're not sure how exactly to do it I can help you out tomorrow. Just let me know if you don't fully understand what you're doing.

[psico]

I?m testing the helpdesk and I?ve created a ticket and then tried to replied but it showed me this error:

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT DISTINCT userid, username, pmpopup FROM user AS user WHERE ( FIND_IN_SET(, membergroupids) OR usergroupid = OR userid = 64) AND userid != 64
mysql error: 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 ' membergroupids) OR usergroupid = OR userid = 64) AND userid !=

mysql error number: 1064

Date: Thursday 09th of June 2005 05:16:53 PM
Script: http://www.psicofxp.com/forums/helpdesk.php
Referer: http://www.psicofxp.com/forums/helpd...cket&amp;tid=1
Username: Psico

The problem seems to be that the variable $tug in line 422 of helpdesk.php is empty...

Anyone can help me with this?

Tnx in advance.

Psico.

[WhSox21]

Did you create your department and did you set usergroups to have access to the departments?

[Stachel]

Originally Posted by WhSox21

First off. You will need to add the FAQ phrases to the phrasegroups array by adding this to the end of the array:
, 'fronthelp'

So it should look like this:
$phrasegroups = array('posting', 'search', 'fronthelp');

That will at least get you the phrases on that page.

That will probably only add the search fields. You will then have to include the required php file in the helpdesk along with the php code to pull the FAQ info out of the database. If you're not sure how exactly to do it I can help you out tomorrow. Just let me know if you don't fully understand what you're doing.

Ohhhhhhhhhhh - I was thinking because the template headers and footers are almost identical, it should work!!

But the other difference is what includes and things that the PHP files calling the template has already declared, right? **click**

because faq.php calls the FAQ template
and
helpdesk.php calls the helpdesk template

Aha !!!

So if I just put all the includes and instantiations from FAQ.php into HELPDESK.php, it shoudl work right? :squareeyed:

I'll try that when I get home from work tonight.

Thanks !!

Stachel

[smdani]

WhSox21,
it's an icredible hack. Maybe it is what I was looking for a long time ago!
I will wait for vB 3.5 PluGIN for installing it!
Thanks a lot for your great support!

[TheMusicMan]

WHSox21

Did you see my last request which has now dissapeard onto the previous page...? Simply asking for how to open the Ticket URL sent in PM in the same browser window instead of new browser window.

Thanks....

[Stachel]

Originally Posted by WhSox21

If you're not sure how exactly to do it I can help you out tomorrow. Just let me know if you don't fully understand what you're doing.

Affirmative.

Have tried to make the result of clicking the FAQ button appear above the HelpDesk for 2 nights now.

Still am only seeing the results shown in the lame attempt picture above.

I copied just about everything that seemed relevant from

faq.php --> helpdesk.php
and
FAQ template --> HelpDesk Shell template

Stachel

[quachvu]

WhSox21 : how can i fix the code so i can use BBCODE in help desk? thanks