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?

[WhSox21]

Everyone that has had trouble give me some time. I'll go back through the thread and reply to each and every one of you. I'll be releasing a small update tonight and possibly a larger one depending on the time I have. I'll let everyone know.

[WhSox21]

I updated the script to allow the selection of usergroups access. I also added a install text file for people to help them get the hack installed. The install script now also uses the table prefixes when creating the tables.

[WhSox21]

Anyone thinking about upgrading hold off until I update the install script!

[computer1]

Can u tel me howe I can unistall this whit all off the error I get please so I can uppdate this to my vb 3.0.7

I get this error when I reinstall helpdesk howe can I fix this ??

Database error in vBulletin 3.0.7:

Invalid SQL: CREATE TABLE `ticketreply` (
`replyid` int(10) unsigned NOT NULL auto_increment,
`ticketid` int(10) unsigned NOT NULL default '0',
`username` varchar(50) NOT NULL default '',
`userid` int(10) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`pagetext` mediumtext NOT NULL,
`ipaddress` varchar(15) NOT NULL default '',
PRIMARY KEY (`replyid`),
KEY `userid` (`userid`),
KEY `threadid` (`ticketid`,`userid`)
) TYPE=MyISAM AUTO_INCREMENT=1
mysql error: Table 'ticketreply' already exists

mysql error number: 1050

[jugo]

WHSox, I want to thank you for this.

It would be cool to add notification when a new ticket is entered.

and to be able to assign the tickets to a certaing person or department.

[WhSox21]

Install script upgraded.

Originally Posted by juanph

WHSox, I want to thank you for this.

It would be cool to add notification when a new ticket is entered.

and to be able to assign the tickets to a certaing person or department.

This is going to be in the near future. I wanted to release this so people could decide who had access and it had a bug fix in the install script.

computer1 -
Do you have phpMyAdmin access? If so drop those tables and run the install again. Actually, to think about it. I'll just upgrade the install script again.

EDIT: Install script has been updated. Try running version 1.02 rather than 1.01!

[jugo]

Awesome Hack.....And Thanks to Cry for letting you set it up on his board (great guy).

Let me know when the new installer is ready, I want to upgrade it to version 1.02 so I can assign who can and can't enter Tickets.

[computer1]

WhSox21
I dont have phpmyadmin howe can I do that nowe ????

[WhSox21]

Originally Posted by juanph

Awesome Hack.....And Thanks to Cry for letting you set it up on his board (great guy).

Let me know when the new installer is ready, I want to upgrade it to version 1.02 so I can assign who can and can't enter Tickets.

It's ready. This requires a file edit of the helpdesk.php file though. Trying to stay away from vbulletin file edits for the early versions. Either way, it's ready.

computer1 - Just download the new version and install the hack again.

[jugo]

Originally Posted by Creed

Go to your admincp, click usergroups. ==> usergroup manager. From that point you can edit the permissions of each usergroup. Just look for "Can create tickets"

So is this somewhere, because if it is, I may have missed it.

The Groups that put into the helpdesk.php file are the ones allowed to Administer the tickets. I want to only allow a certain group to enter tickets....is THAT possible??