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.

[Lindsey]

Database error in vBulletin 3.7.0:

Invalid SQL:
INSERT INTO helpcenter_department (departmentid,department,status,displayorder,forum id) VALUES ('','Hosting','0','1','78');

MySQL Error : Unknown column 'forumid' in 'field list'
Error Number : 1054
Request Date : Saturday, May 10th 2008 @ 09:17:35 AM
Error Date : Saturday, May 10th 2008 @ 09:17:35 AM
Script : http://****.com/forums/admincp/helpc...=adddepartment
Referrer : http://***.com/forums/admincp/helpce...=departmentadd
IP Address : //////////
Username : Lindsey
Classname : vB_Database
MySQL Version : 5.0.51a-community

[WildWeb]

Originally Posted by Lindsey

Database error in vBulletin 3.7.0:

Invalid SQL:
INSERT INTO helpcenter_department (departmentid,department,status,displayorder,forum id) VALUES ('','Hosting','0','1','78');

MySQL Error : Unknown column 'forumid' in 'field list'
Error Number : 1054
Request Date : Saturday, May 10th 2008 @ 09:17:35 AM
Error Date : Saturday, May 10th 2008 @ 09:17:35 AM
Script : http://****.com/forums/admincp/helpc...=adddepartment
Referrer : http://***.com/forums/admincp/helpce...=departmentadd
IP Address : //////////
Username : Lindsey
Classname : vB_Database
MySQL Version : 5.0.51a-community

Same error here after fresh install of todays release.

[dcw]

Yeah I am getting that error... *sigh*

[VTXCafe.com]

Same error as the ones above.

[PaulSonny]

Uploaded new package which will fix the above issue, sorry about that. I added a new field and stupidly forgot to add it to the installation code of the product.

Anyway should be fixed now.

Uninstall & Reinstall.

Thanks, Paul.

[powerful_rogue]

Hi Paul, great to have mod back

Ive just installed the new product however I have a problem!

When I create new departements, they remain closed. Ive updated them to be open but this dosent seem to make any difference.

Edit -

Ive added an attachment - Where abouts do I need to look to edit the CSS for the "Ticket ID" and "Posted By" - At the moment there the same colour as the backgroud so only show up when you put your mouse over them.

The other question is regarding the "Admin" link on the left hand side, should there be anything underneath that?

[ecihanuysal]

Originally Posted by powerful_rogue

Hi Paul, great to have mod back

Ive just installed the new product however I have a problem!

When I create new departements, they remain closed. Ive updated them to be open but this dosent seem to make any difference.

i also have this problem. how can we solve it?

[PaulSonny]

I have fixed the department error, I had mis-typed the word status in the admin file so it wasnt finding the value from the form correctly.

With regards to the CSS, if you look in the hcenter_ticketlist template each <td> tag will have a class, just remove that class.

Thanks, Paul.

[ecihanuysal]

Thank you Paul

[powerful_rogue]

Originally Posted by PaulSonny

I have fixed the department error, I had mis-typed the word status in the admin file so it wasnt finding the value from the form correctly.

With regards to the CSS, if you look in the hcenter_ticketlist template each <td> tag will have a class, just remove that class.

Thanks, Paul.

Brillaint.

Now its in RC stage do we still need to uninstall and then install or can we just upload and overwrite now?