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?

[TheMusicMan]

Originally Posted by Lizard King

You can link to helpdesk like helpdesk.php?styleid=2

D'oh... now why didn't I think of that eh!!! Thaks.

Also: I have a suggestion. Is there a way to have the number of tickets for each category (i.e. Unresolved, Resolved, New etc) shown in say the welcome panel for those who can answer support tickets...? Not very well articuklated but essentiall what I mean is... is there a way to see the number of those tickets somewhere on the forumhome (or anywhere) for those who can respond to tickets. It would be great if underneath the "Private Messages: n" in navbar I could see how many tickets there were in each section. Would also be good if those who have submitted a ticket could see if there is a reply awaiting them...

[yinyang]

Originally Posted by TheMusicMan

D'oh... now why didn't I think of that eh!!! Thaks.

Also: I have a suggestion. Is there a way to have the number of tickets for each category (i.e. Unresolved, Resolved, New etc) shown in say the welcome panel for those who can answer support tickets...? Not very well articuklated but essentiall what I mean is... is there a way to see the number of those tickets somewhere on the forumhome (or anywhere) for those who can respond to tickets. It would be great if underneath the "Private Messages: n" in navbar I could see how many tickets there were in each section. Would also be good if those who have submitted a ticket could see if there is a reply awaiting them...

numbering would be cool and i guess that could easily lead into counting ticket replies,etc.?

[WhSox21]

Originally Posted by TheMusicMan

D'oh... now why didn't I think of that eh!!! Thaks.

Also: I have a suggestion. Is there a way to have the number of tickets for each category (i.e. Unresolved, Resolved, New etc) shown in say the welcome panel for those who can answer support tickets...? Not very well articuklated but essentiall what I mean is... is there a way to see the number of those tickets somewhere on the forumhome (or anywhere) for those who can respond to tickets. It would be great if underneath the "Private Messages: n" in navbar I could see how many tickets there were in each section. Would also be good if those who have submitted a ticket could see if there is a reply awaiting them...

http://www.hackvb.com/helpdesk.php - For requests.

[TheMusicMan]

Originally Posted by WhSox21

http://www.hackvb.com/helpdesk.php - For requests.

Hi - I can't get at the site I'm afraid. Get timeout errors... is all OK?

[WhSox21]

It appears my host is down for some reason.

[jerett]

Anyone know why the nav link might not show up for the helpdesk?

[KTBleeding]

Originally Posted by jerett

Anyone know why the nav link might not show up for the helpdesk?

Did you edit the navbar template?

[mholtum]

/me installs! Great Hack thanks.

[MoK]

Hallo Community,

This is my first Post here, and at first i would to say sorry for my bad english *lol*. It?s not my favourite Language :nervous: ... I?ve install these Hack, but when i made a new Ticket i?ve got a SQL Database Error when i submint him! The Auto-Messega arrive me, and the Ticket i can see it in the Help Desk, but when i will open it, it is the same Database Error as when i submint the Ticket... I Hope your can help me and i hope so much that you can understand me

This is the Database Error i become:

Datenbankfehler in vBulletin 3.0.7:

Ungueltige SQL-Abfrage: SELECT DISTINCT userid FROM user AS user, ticket AS ticket LEFT JOIN ticketdepartment AS ticketdepartment ON (ticketdepartment.departmentid = ticket.departmentid) WHERE ( FIND_IN_SET(, membergroupids) OR usergroupid = ) AND (userid = 1 OR ticket.postuserid = 1)
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 = ) AND (userid = 1 OR ticket.p

mysql error number: 1064

Datum: 20.04.2005 13:55:25
Skript: http://www.diegilde2.de/Forum/forum/helpdesk.php?do=ticket&tid=2
Referer: http://www.diegilde2.de/Forum/forum/helpdesk.php?do=unresolved
Benutzername: MoK

best regards MoK

[WhSox21]

For some reason it looks like $bbuserinfo is not being set. I honestly have no idea why that's not working correctly? I would need more information on your files.

[MoK]

Thank you for youre Answer,

and which informations you need?

greetz MoK

[MoK]

I have found the Problem

It?s a great Hack! Thank you WhSox21 for this !!!!!!!!

[misuse]

Great work. Easy install. Submitted request at the URL listed.

[evenmonkeys]

It would appear that the bug I had you fix seems to be popping back up. I have users who are finding ways around your fix. They're still able to view and reply to other tickets.

[MikeWarner]

Originally Posted by xYarub

It would appear that the bug I had you fix seems to be popping back up. I have users who are finding ways around your fix. They're still able to view and reply to other tickets.

I am also getting this.