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]

Originally Posted by Bolas

I got the same database error with a CLEAN installation of 1.52 while running helpdesk.php.
my vb version is 3.06

Invalid SQL: INSERT INTO domain_com_-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.ticket WHERE ticketid = 3
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 '-_forums.ticketdeleted SELECT * FROM domain_com_-_forums.

mysql error number: 1064

MySQL 3.23.58

Did you try uploading this file attached to this post:
https://vborg.vbsupport.ru/showpost....&postcount=194

[computer1]

I get this database eror when I install everything nowe
on vb.3.0.7
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 postuserid = 1
mysql error: You have an error in your SQL syntax near 'ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND post' at line 1

mysql error number: 1064

Date: Sunday 06th of March 2005 08:49:34 PM
Script: http://forum.tanakawebb.com/helpdesk.php
Referer: http://forum.tanakawebb.com/

and where shld I change this????
Add a department. (www.yoursite.com/helpdesk.php?do=departments)

[WhSox21]

Originally Posted by computer1

I get this database eror when I install everything nowe
on vb.3.0.7
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 postuserid = 1
mysql error: You have an error in your SQL syntax near 'ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND post' at line 1

mysql error number: 1064

Date: Sunday 06th of March 2005 08:49:34 PM
Script: http://forum.tanakawebb.com/helpdesk.php
Referer: http://forum.tanakawebb.com/

and where shld I change this????
Add a department. (www.yoursite.com/helpdesk.php?do=departments)

Start reading the past posts. I'm trying to get someone that has this problem run the script I attached in one of the past posts. Then if it works I'll update the hack.

[MissKalunji]

Originally Posted by WhSox21

Just about any administer link will give you the error. I believe it's a problem with the syntax I used, it doesn't support the older versions of MySQL. I've changed it to do exactly how vBulletin does so it should work.

administrater in helpdesk? i guess they probably updated mysql caz i dont get n e error

[Bolas]

Originally Posted by WhSox21

Did you try uploading this file attached to this post:
https://vborg.vbsupport.ru/showpost....&postcount=194

I'm very afraid.
You're right, I didn't read your post with attachment.
I upload it and now it works fine.

A very great work, thanx, again!

[WhSox21]

Originally Posted by Bolas

I'm very afraid.
You're right, I didn't read your post with attachment.
I upload it and now it works fine.

A very great work, thanx, again!

Ok so delete problem is fixed... Now let's see about this other select problem.

[LOTR]

Originally Posted by WhSox21

This will be fixed in the next version once I sort out all the other bugs.

Thanks, do hope you can update when this issue is fix WhSox21. Appreciate your work

[WhSox21]

Originally Posted by LOTR

Thanks, do hope you can update when this issue is fix WhSox21. Appreciate your work

I'm just waiting for someone to confirm if the file I attached earlier works or not?

[ChrisBaktis]

I uploaded the new helpdesk.php file and all seems good now - I tried all the links and looks like everything is ok now. Great hack!

[clearchannel]

Originally Posted by WhSox21

Start reading the past posts. I'm trying to get someone that has this problem run the script I attached in one of the past posts. Then if it works I'll update the hack.

I uploaded the new helpdesk script you recently posted, I no longer get the database error.

Keep up the great work, your gonna nail this one, I have no doubt.