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

People can't check out the helpdesk on your site because it requires registration! :lick:

oh mah bad
that means
unregistered cant use it?

[WhSox21]

Originally Posted by MissKalunji

changing now...

You can't change that unless you edit the file. This version of the helpdesk requires registration. That's why you don't see the unregistered usergroup in the usergroup settings section!

[MissKalunji]

Originally Posted by WhSox21

You can't change that unless you edit the file. This version of the helpdesk requires registration. That's why you don't see the unregistered usergroup in the usergroup settings section!

oh oops

[high]* MissKalunji feels dumb :nervous:[/high]

[MissKalunji]

Originally Posted by WhSox21

Not sure what you mean exactly. After setting the usergroup settings everything should be alright. Only usergroups that "Can ____ Any Ticket" will be able to see most of the tickets. Then you must set the usergroups who can edit the departments seperated by commas.

Every regular user can only see their own tickets.

so about hte departement what the usergroup for?

[WhSox21]

Originally Posted by MissKalunji

so about hte departement what the usergroup for?

The department usergroup gives those usergroups access to the tickets in the department. The usergroup settings is where you can limit the usergroups abilities.

[MissKalunji]

Originally Posted by WhSox21

The department usergroup gives those usergroups access to the tickets in the department. The usergroup settings is where you can limit the usergroups abilities.

Thank you so much!!!!!!!!!!!!!

[T3MEDIA]

so what is new with this baby?

[ChrisBaktis]

Im getting many database errors - if I click on my tickets, or unresolved tickets, I get a database error.

Database error in vBulletin 3.0.7:

Invalid SQL: SELECT ticketid, title, postusername, dateline, lastposter, lastupdate, department FROM ticket AS ticket JOIN ticketdepartment AS ticketdepartment ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND ownerid = 0 AND dateline >= 1110062033 AND ticketdepartment.departmentid IN (3)
mysql error: You have an error in your SQL syntax near 'ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND owne' at line 1

mysql error number: 1064

Date: Saturday 05th of March 2005 05:42:39 PM
Script: http://rustysoaptraders.com/forums/helpdesk.php?do=newtickets
Referer: http://rustysoaptraders.com/forums/helpdesk.php?do=departments
Username: poongamer

I was able to setup departments.

Get a database error if I go to www.mysite.com/forums/helpdesk.php

[WhSox21]

Originally Posted by T3MEDIA

so what is new with this baby?

Departments
Usergroup Settings
PM / Email on new ticket (to ticket creator).
Master Switch
Turn off accepting new tickets.
Can see resolved tickets.

Originally Posted by ChrisBaktis

Im getting many database errors - if I click on my tickets, or unresolved tickets, I get a database error.

I was able to setup departments.

Get a database error if I go to www.mysite.com/forums/helpdesk.php

I don't see anything wrong with that. What I would do if you don't have any tickets yet is use the install script and click the uninstall link and go through everything then go back and use the install link. This should fix everything if not let me know.

gr33tz - I got an email saying you replied with a problem. Did you fix your problem?

[ChrisBaktis]

Still getting many database errors.

Only two things work:

Setting up Departments, and New Tickets under User Control - All other links generate Database error.