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.

[Hostboard]

Auto close after X amount of days of in activity as defined in the ACP? This would then generate a PM to the user...


Title: Your Support Ticket XXX is Now Closed
Body: AUTOMATED NOTICE: Your support ticket has been closed due to X days of inactivity. However, if you require any further assistance, please:

• Open a "link to new ticket", OR
• "Link to Re-open" your ticket.

Your Support Team:
Link to Profiles of Admin | Link to Profiles of Admin | And so on...

Links support team could also be a new user group "support team" or one defined in the ACP

[mikexxx]

Originally Posted by PaulSonny

Further update, try this one guys and let me know.

With regards to the DB error, remove previous version and import this as fresh.

Thanks, Paul.

Better
In usergroep manger the name of the table is still missing.

And when i submit a new ticket i get a database error.

-----------------------

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
INSERT INTO helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress, threadnum) VALUES ('1','test','test test test','3','1','Mike','Mike','1','1209449977','1209 449977','0.0.0.0','0');

MySQL Error : Unknown column 'threadnum' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 29th 2008 @ 08:19:37 AM
Error Date : Tuesday, April 29th 2008 @ 08:19:38 AM
Script : http://www.xxxxxxxnl/helpcenter.php?do=newticket
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.45-enterprise-gpl

[GoTTi]

i just upgraded to beta 5 due to a error, so i uninstalled and reinstalled the mod, and looking in the usergroup under admin, there is no title on the help center area of options, its blank. but the radio buttons and options are there.

[GoTTi]

i had this same error. i uninstalled the mod, and reinstalled it and the error is gone. i think if u upgrade to the current version you will get the error...

as far as the title bar in the usergroup missing, mine is missing also.

Originally Posted by mikexxx

Better
In usergroep manger the name of the table is still missing.

And when i submit a new ticket i get a database error.

-----------------------

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
INSERT INTO helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress, threadnum) VALUES ('1','test','test test test','3','1','Mike','Mike','1','1209449977','1209 449977','0.0.0.0','0');

MySQL Error : Unknown column 'threadnum' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 29th 2008 @ 08:19:37 AM
Error Date : Tuesday, April 29th 2008 @ 08:19:38 AM
Script : http://www.xxxxxxxnl/helpcenter.php?do=newticket
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.45-enterprise-gpl

[PaulSonny]

I will sort the HelpCenter table phrase when I get home, with regards to the "MySQL Error : Unknown column 'threadnum' in 'field list'" I think there is something wrong within the product file for altering the table.

I will update the product so that it creates the table with the new field name, but it may mean everyone has to uninstall and re-install to get it working correctly.

If anyone could have a look at the product file and check the SQL Query (version 0.5) then i'd be grateful.

Thanks, Paul.

[GoTTi]

paul that error is only duplicating itself on upgrade. i tested it on 2 forums. must uninstall and reinstall mod to not have errory.

[PaulSonny]

ah right I understand now GoTTi and thanks for letting me know, I will fix the Usergroup phrase now.

Thanks, Paul.

[IR15H]

I figured out the DB error. The problem occurred with reading the table, rather than creating it, so the problem wasn't in the product file. Once I realised that I stopped looking in the wrong place and had a quick look in helpcenter.php. I figured out the error, and managed to fix it myself . If anyone else has prefixes on their SQL tables then do the following in helpcenter.php

SEARCH FOR;

$departmenttitle = $vbulletin->db->query_read("SELECT department FROM helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

REPLACE WITH;

$departmenttitle = $vbulletin->db->query_read("SELECT department FROM " . TABLE_PREFIX . "helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

...or just wait for Paul to update the zip .

[PaulSonny]

Thanks Irish I have fixed this for the next release.

Thanks, Paul.

[MikeHolohan]

Originally Posted by IR15H

I figured out the DB error. The problem occurred with reading the table, rather than creating it, so the problem wasn't in the product file. Once I realised that I stopped looking in the wrong place and had a quick look in helpcenter.php. I figured out the error, and managed to fix it myself . If anyone else has prefixes on their SQL tables then do the following in helpcenter.php

SEARCH FOR;

$departmenttitle = $vbulletin->db->query_read("SELECT department FROM helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

REPLACE WITH;

$departmenttitle = $vbulletin->db->query_read("SELECT department FROM " . TABLE_PREFIX . "helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

...or just wait for Paul to update the zip .

Well done, works well... Mike.