Add-On Releases - PS - HelpCenter

HelpCenter is the ultimate ticket support system for your vBulletin!

Click Here for vBulletin 3.6 Version

HelpCenter is a support ticket system made for vBulletin. It allows you to manage your members questions much easier, saving you the hassle of going through emails and private messages.

Visit PaulSonny for news, demos, screenshots, and more!

Demo: PaulSonny HelpCenter

Features

If you have any feature requests please make them known at PaulSonny.

* Automatic Template Edits
* Turn HelpCenter ON/OFF and display a custom message.
* Disallow New Tickets to be created and display a custom message.
* Give your Ticket ID's a Prefix.
* Auto Open closed tickets when a new reply is made. (Now an Admin Option)
* Add, Edit and Delete departments via AdminCP, view Tickets within a Department.
* Open/Closed ticket AdminCP Management.
* Make tickets public/private.
* Ticket Priorities. (Low/Medium/High)
* WOL: HelpCenter.
* View Statistics about HelpCenter in the AdminCP.

Installation Instructions

[] Upload all the files from the Upload folder.
[] Import product-helpcenter.xml via the AdminCP.
[] Set Permissions for each usergroup via the AdminCP for HelpCenter.
[] Set Departments up via the AdminCP for HelpCenter.

Footnotes

Please report all bugs, feature requests and comments here.

Version History:

Version 1.00 Beta 1:

Initial version for vBulletin 3.7.

Version 1.00 Beta 2:

Bug Fixes.

Version 1.00 Beta 3:

Database Errors Fixed.
Added Extra Usergroup Permissions.
Ticket Priority Added.
Ticket Number Prefix Added.
Plus Much More...

Version 1.00 Beta 4:

Added Some extra Admin Features.
Fixed some bugs.
Other small features added.

Version 1.00 Beta 4 Security Fix

Cross Site Request Forgery (CSRF) Fixed.

Version 1.00 Beta 5:

Further Enchanged Some Admin Functions.
Enhanced My Tickets Interface.
Paginated Results.
Fixed More bugs, such as Guest Tickets Problem. (Temporary Measure!)
Other small features added.

Version 1.00 Beta 6:

Make tickets public/private.
Tidied up Admin Interface.
Fixed Phrases.
Tidied Up the Code.
It now parses smilies in your tickets. so you get !
Other small features added.

Version 1.00 Release Candidate 1:

Fixed SQL Vunerabilities
Fixed Phrases.
Tidied Up the Code.
Implemented Delete Confirmation Screens.
Improved CSRF Security.

Version 1.00:

Can View HelpCenter Permission Added.
Updated Delete Confirmations.
Fixed No Title Error.
Tidied Up the Code.

Version 1.01:

Minor Template Change for Version.
Standard Editor Error Fixed.
Improved Code Structure for Editors.

Please remember to click Mark As Installed if you use this modification.
If you use this plug-in, and find it useful, please support us by nominating us for Mod Of The Month (MOTM) in the top right corner of this thread, or feel free to donate.

You will get an email when a new version is released.

Thanks, PaulSonny & The Development Team.

[Aaron218]

I get that error and im the owner of my board i have edit'd my usergroup to allow me to use the system and im still getting that error. Also the navbar edit is not working

Aaron217, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

[Twilkey]

Originally Posted by Aaron218

I get that error and im the owner of my board i have edit'd my usergroup to allow me to use the system and im still getting that error. Also the navbar edit is not working

Aaron217, you do not have permission to access this page. This could be due to one of several reasons:

Your user account may not have sufficient privileges to access this page. Are you trying to edit someone else's post, access administrative features or some other privileged system?
If you are trying to post, the administrator may have disabled your account, or it may be awaiting activation.

Uninstall and reinstall and see if it works. As for the template edit, you may have to change the code that the auto edit searches for. You may have deleted the code that it searches for by default. What is your site.

[macc]

hello!

i get error when i click on public ticket

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT * FROM vb_helpcenter_ticket AS helpcenterticket LEFT JOIN vb_helpcenter_department AS helpcenterdepartment ON (helpcenterdepartment.departmentid = helpcenterticket.departmentid) WHERE ticketstatus=1 AND ticketview=1 ORDER BY datelastupdate DESC;
MySQL Error   : Unknown column 'ticketview' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, May 22nd 2008 @ 08:41:23 AM
Error Date    : Thursday, May 22nd 2008 @ 08:41:23 AM
Script        : http://belaplay.com/vb/libar/helpcen...=publictickets
Referrer      : http://belaplay.com/vb/libar/helpcenter.php
IP Address    : 
Username      : Admin
Classname     : vB_Database
MySQL Version : 4.1.22-standard

and on bottom show "help center rc ver 1.0" (i updated to gold )

some help or solution?

regards

macc

[mvigod]

Suggestion/Question
Is it possible to have reported posts to create a ticket as private and assigned to the moderator of the forum it was reported in?

Looks great so far!

[scan-pa]

Installed.

Few questions.

1) New version still has RC 1 on the url link footer tag.

2) How do I assign Staff to only have access to specific Departments?

I want Super Admins to handle all Departments, Admins & Super Moderators to handle specific assigned departments ect....

There needs to be a pop up notification for Super Admins, Admins, Super Moderators of new tickets opened or replyed to. also an email for each open, reply, close event sent to the webmaster email address.

[Aaron218]

my site is not yet ready however if you think you can help me its www.gamingstop.site88.net

[PaulSonny]

Sorry about the late reply, been having a few problems but everything seems sorted now.

Originally Posted by Aaron218

I get that error and im the owner of my board i have edited my usergroup to allow me to use the system and im still getting that error. Also the navbar edit is not working:

I would recommend uninstalling and reinstalling, can you confirm whether you had a previous version of HelpCenter installed?

The navbar edit may not be working because it cant find the search text, check your Main Settings and provide an alternative search criteria.

Originally Posted by macc

hello!

i get error when i click on public ticket

Database error in vBulletin 3.7.0:
Invalid SQL:
SELECT * FROM vb_helpcenter_ticket AS helpcenterticket LEFT JOIN vb_helpcenter_department AS helpcenterdepartment ON (helpcenterdepartment.departmentid = helpcenterticket.departmentid) WHERE ticketstatus=1 AND ticketview=1 ORDER BY datelastupdate DESC;
MySQL Error   : Unknown column 'ticketview' in 'where clause'
Error Number  : 1054
Request Date  : Thursday, May 22nd 2008 @ 08:41:23 AM
Error Date    : Thursday, May 22nd 2008 @ 08:41:23 AM
Script        : http://belaplay.com/vb/libar/helpcen...=publictickets
Referrer      : http://belaplay.com/vb/libar/helpcenter.php
IP Address    : 
Username      : Admin
Classname     : vB_Database
MySQL Version : 4.1.22-standard

and on bottom show "help center rc ver 1.0" (i updated to gold )

some help or solution?

regards

macc

The ticketview problem was solved in a previous release, I wonder if the upgrade hasnt worked correctly, could you please download the latest package, uninstall the product and then install as new and overwrite all files.

See if this corrects your problem.

Originally Posted by mvigod

Suggestion/Question
Is it possible to have reported posts to create a ticket as private and assigned to the moderator of the forum it was reported in?

Looks great so far!

Not at the moment.

Originally Posted by scan-pa

Installed.

Few questions.

1) New version still has RC 1 on the url link footer tag.

2) How do I assign Staff to only have access to specific Departments?

I want Super Admins to handle all Departments, Admins & Super Moderators to handle specific assigned departments ect....

There needs to be a pop up notification for Super Admins, Admins, Super Moderators of new tickets opened or replyed to. also an email for each open, reply, close event sent to the webmaster email address.

Have you customised any of the templates? if so can you revert them and this should fix the RC1 issue.

Departments dont have usergroup permissions.

Notifications are going to be a Pro Version feature.

Originally Posted by Aaron218

my site is not yet ready however if you think you can help me its www.gamingstop.site88.net

Please view my advice above and if that doesnt work ill gladly take a look for you.

Thanks very much, Paul.

[Charlie98902]

Paul I have a simple request to the unpaid version I am just testing right now. Can there be a auto prefix like responded from {username}? This way it helps to know if you are needing to look at the response, this of course works for the usergroup staff as well as the user. Also have it state it is open kinda like a prefix [OPEN] or [CLOSED]? Or is this stuff in the Pro?

Also the only problem I am having with the links in the navigation as well as admin links in the help center, this is when you go to click on it the wording disappears but you can click to create or so still. I can't seem to find how to change it. I can give you access if needed to look at what I am saying on this.

Also I am wondering if the pro version is ready and how much?

[PaulSonny]

When you view the My Tickets, Open Tickets or Closed Tickets one of the columns tells you when it was last updated and who by. for example Today by PaulSonny.

In the My Tickets it shows open or closed tickets in seperate tables, then Open Tickets links displays all open tickets. and then Closed Tickets links display all closed tickets.

Your other problem has been known before, and it seems to be something to do with the styles. If you can send me an admin login and your site I will login and correct it.

Pro version is in development, not an official release yet and no definite price.

Thanks, Paul.

[Charlie98902]

Well the help center is only being tested right now on my test vb so altering it would only help that unless I can just move the files from the test to the live site. Or you can tell me how to and what to alter? I can give you access to the test forum if still neded just let me know.