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?

[Blackbeard]

i have installed this hack and have set it to be a helpdesk for all topics like pc as well as forum bugs, but i would like to make a suggestion for a future idea, if other people use this hack in this way, would it be possible to make it make a automatic post in a forum saying a member is asking for help, please proceed to the helpdesk and see if you can resolve their problem.

think this will make a super hack even better if thats possible.

PS does anyone have a guide on how to use this, what each thing does, that members can read - iam about to do one myself if i find a spare 5 mins.

[WhSox21]

Originally Posted by WhSox21

What browser? Would you be willing to give me access to check this problem out?

Nevermind, it's IE specific and I figured out the problem. I'll release an update here shortly with instructions on how to fix the problem.

[JayJay]

Originally Posted by Blackbeard

PS does anyone have a guide on how to use this, what each thing does, that members can read - iam about to do one myself if i find a spare 5 mins.

If you look up at the information about this modification then you will see the following:

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


Is this what you are looking for? Or are you looking for a user guide? One assumes that such a system is straightforward to submit a question, but if you really need a user guide then I don't believe there is one.

[JayJay]

Originally Posted by WhSox21

Nevermind, it's IE specific and I figured out the problem. I'll release an update here shortly with instructions on how to fix the problem.

Thanks WhSox. I have the same thing, but I was happy to live with it, considering I'm not in and out of user permissions. It is merely a cosmetic afterall. However, fixing this would be excellent.

[ESADCG]

EDIT : Dismiss, I got it to work after doing another complete uninstall/re-install :nervous:

Originally Posted by WhSox21

Run a full uninstall of the settings. Just click the link that says Uninstall Settings. Download verion 1.54 rather than version 1.53 and then try to install it. That error was the only fix of version 1.54.

Ok, did that. Made a little difference. But now I get this error when I try to re-install 1.54.

Invalid SQL: ALTER TABLE `vb3_usergroup` ADD `ticketpermissions` INT(10) UNSIGNED DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'ticketpermissions'

mysql error number: 1060

Date: Wednesday 09th of March 2005 01:47:14 PM
Script: http://****/VB/admincp/helpdesk_inst...install&step=4
Referer: http://****/VB/admincp/helpdesk_inst...install&step=3

[WhSox21]

Originally Posted by ESADCG

Ok, did that. Made a little difference. But now I get this error when I try to re-install 1.54.

Invalid SQL: ALTER TABLE `vb3_usergroup` ADD `ticketpermissions` INT(10) UNSIGNED DEFAULT '0' NOT NULL
mysql error: Duplicate column name 'ticketpermissions'

mysql error number: 1060

Date: Wednesday 09th of March 2005 01:47:14 PM
Script: http://****/VB/admincp/helpdesk_inst...install&step=4
Referer: http://****/VB/admincp/helpdesk_inst...install&step=3

You're fine. The install has ran everything that it really needs to run. If you still need to do the template edit to add it to your navbar change the step=4 to step=5 in the url. Then you'll be fine. Your helpdesk should be running fine now.

[WhSox21]

Ok, I have fixed the problem with the Usergroup Settings page in IE where it moves down half the page. To fix this problem it's rather simple.

1. Upload helpdesk_install.php to your admincp folder and run it.
2. Click on a link that says Install Templates.

You're done, don't go through any other steps, if you do then it will give you database errors.

Warning: This will update any HelpDesk templates. If you have made any changes save them first and then run this to prevent problems.

[Slave]

Originally Posted by WhSox21

Ok, I have fixed the problem with the Usergroup Settings page in IE where it moves down half the page. To fix this problem it's rather simple.

1. Upload helpdesk_install.php to your admincp folder and run it.
2. Click on a link that says Install Templates.

You're done, don't go through any other steps, if you do then it will give you database errors.

Warning: This will update any HelpDesk templates. If you have made any changes save them first and then run this to prevent problems.

Lovely .. that did the trick .. thanks ..

[LOTR]

I cant find 2. Click on a link that says Install Templates. on the helpdesk_install.php, where is it actually?

Im using 1.54 now, is it Updates/Adds Templates?

[LEAD_WEIGHT]

Originally Posted by LOTR

I cant find 2. Click on a link that says Install Templates. on the helpdesk_install.php, where is it actually?

Im using 1.54 now, is it Updates/Adds Templates?

Example

http://yourdomain/forums/admincp/helpdesk_install.php?